Inventory Mangement System - FAQ

1. What does this program cost? Cost: $50 [includes 1 year maintenance]
   Installation: $50
   Maintenance/year: $50
   - Free upgrades
   


2. How do I setup the database configuration? First you need to create the table in MySQL, and the User with permissions:
   Connect as root (it will ask for a password):
   > mysql -uroot -p
   Create the database (DB_NAME):
   > create DB_NAME;
   Create the user with permissions (change uppercase items):
   > grant select,insert,update,delete,create,drop on DB_NAME.* to 'USER@HOST' identified by 'PASSWORD';
   
   
   In the file: config/global.inc.php
   You will find 4 variables. These need to be changed by you:
   $DB_HOST="HOST"; // localhost or your DB server name
   $DB_USER="USER"; // which mysql user has access to your DB
   $DB_TABLE="TABLENAME"; //the mysql DB_NAME name for your DB
   $DB_PASSWORD='PASSWORD'; // your mysql DB password
   
   
   This is just for information on where they get used. Nothing needs to be changed here:
   File: config/db.inc.php
   $db = mysql_connect($DB_HOST,$DB_USER,$DB_PASSWORD);
   $x=mysql_select_db($DB_TABLE,$db);
   


3. What are the simple install instructions?
   1. FTP the provided zip [upon purchase] onto your webserver.
   2. unzip/archive it:
      i. gunzip ims.tar.gz
      ii. tar -xf ims.tar
      
   3. edit config/global.inc.php
      - adminEmail
      - uploaddir [must be chmod 777]
      - uploadpath is the http address
      - ITEMS -- this must be set to enable specific column names - not all must be used, and not all defined must be used.
      a "#" in the first location of the name denotes the item is to be shown [if defined] on multi-list pages
      Photos must start with "Photo-*"
      - Edit the DB_* values to access your mysql database.
      
   4. edit view_item to have your path to the style.css file
   5. edit view.php to have your path to the style.css file
   6. access via http test.php to see if PHP is enabled on your server.
   7. configure the mysql database [must have user and table defined already] - this imports the scheme:
      mysql -uUSERNAME -hYOURMYSQLHOST -p TABLENAME < ims.mysql_db.sql
      << this will prompt you for the password>>
      This will also build an initial database for you.
      
   8. Access via http the login.php file
      Username: admin
      Password: wordpass
   
   
4. How would I change the attributes saved for the inventory items? It is designed so that the database does not know what the fields are labeled - that definition is made in the config php file.
   
   Excerpt from code:
   $ITEMS=array(
   "", # do not use the first one!
   "Photo-Normal", #1
   "#Photo-Thumb", #2
   "#Address 1", #3
   "Address 2", #4
   "#City", #5
   "#State", #6
   "#Zip", #7
   "#Number Bedrooms", #8
   "#Number Baths", #9
   "#List Price", #10
   "MLS ID",
   "Photo-Added1",
   "Photo-Added2",
   "Photo-Added3",
   ... <more>
   It is set up to have up to 40 different attributes, or less if you specify "" (null-string)