1) Obtain W2B_Restaurant.zip
2) unzip it into the directory you want (best way is document root 'htdocs' or 'www')
3) Make sure your directory structure is like this:
W2B_Restaurant/
W2B_Restaurant/admin
W2B_Restaurant/conf (chmod to 777)
W2B_Restaurant/img
W2B_Restaurant/js
W2B_Restaurant/lib
W2B_Restaurant/languages
W2B_Restaurant/templates
Attention! Befor running Install script you need to set permissions to make 'conf' directory and it's content files writable!
This involves using the CHMOD command. If you do not understand CHMOD, there are some resources and information listed at
http://www.eclecticpixels.com/tutorials/chmod/. CHMOD as follows:
chmod 777 conf (this is a directory)
chmod 777 all files in the conf directory
After the installation and final configuration you may chmod "conf" directory to 606 for security purposes.
Manual Installation
==============================================================
Below instruction only for MySQL database backend.
For other databases backends see their manuals
==============================================================
4) Create a MySQL database (If you have an installed MySQL database and enough experinece in SQL
you may pass this step).
The database needs a database-name, a username, and a password.
The database-name can be any name beginning with a letter, the username
should be your unix login name. The password must be different from all
other passwords in your system for security reasons.
If you have root access to the MySQL server then you can create the
database following these instructions:
4.1. On UNIX prompt write:
mysqladmin -uroot -p create YourDataBaseName
(enter MySQL root password)
4.2. On UNIX prompt write:
mysql -uroot -p
(enter MySQL root password)
4.3. On MySQL prompt write:
grant select, insert, update, create, alter, delete, drop
on DATABASENAME.*
to USERNAME@localhost
identified by 'PASSWORD' ;
quit
If you don't have root access then you have to ask the webmaster to
create a database for you. Just specify the database-name, username,
and password. Remember that the database password must be different from
your normal password.
5) Create database tables
There are two ways:
- From the command line for your operating system, type
% mysql YourDataBaseName < W2B_Restaurant.sql
This will send the statements into the mysql client and create the tables for you. To verify that this was done correctly, go into the mysql client and see.
%mysql YourDataBaseName
You should see
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.22.32
Type 'help' for help.
mysql>
now type
mysql> show tables;
and you should see the next tables listed
+----------------------------+
| Tables_in_YourDataBaseName |
+----------------------------+
|R_cards |
|R_departs |
|R_discard |
|R_dish_group |
|R_dishes |
|R_halls |
|R_invoices |
|R_orders |
|R_prod |
|R_prod_group |
|R_rtables |
|R_units |
|R_users |
+----------------------------+
- use phpMyAdmin or similar DataBase Web Administration tools to run the SQL requests from W2B_Restaurant.sql file
6) Make changes to the W2B_Restaurant/conf/conf.inc file. This file is well documented, so you should be able to pick out what you need to change fairly easily.
########### MySQL DataBase Setting ####################
$dbname = "yourDBName"; //DataBase Name
$hostname = "mysql.yourdomain.comm:64366"; //Host Name:PORT
$username = "yourDBUserName"; //DataBase Access UserName
$password = "yourDBPassword"; //DataBase Access Password
########### WebDocs real path #################
$path="/usr/local/apache/htdocs/W2B_Restaurant"; //real path
$catalogurl="http://localhost/W2B_Restaurant"; //Your Site URL
$sp="/"; //Windows System '\\'
$admin="admin@demo.com"; //Admin email
$site_url="http://www.w2bpm.com/";
############## Color configuration for the default HTML table layout
$design["tab_color"]="#d4d5c2"; //HTML Table background color tag setting
$design["tr_color"]="#E4E5D2"; //HTML Table <tr> tag background color setting
$design["td_color"]="white"; //HTML Table <td> tag background color setting
############# Categories List End ########################
include("../languages/lang_eng.inc"); choose Interface Language
You may create your own language interface simply translating the message variables in the lang_eng.inc.
8) Once all this has been done, you should protect the conf/conf.inc file (that contains
your login/password for db access). Look at your server documentation to find out
how to do this.
For the Apache server, you'll need to create an ".htaccess" file (without quotes) in
the conf subdir that contains:
<files conf.inc>
Order Deny,Allow
Deny From All
</files>
9) To customize page layout you may the files in 'templates' folder:
|