I have made some (what I feel are) improvements in the program.
1. I added processing for non-credit cards (i.e. checks). This was a
requirement for a company that doesn't even have Credit Card processing. I
basically added to the billing_method a row with:
ID = CHK
Name = Check
Precedence = 1 (I needed this as the default)
I changed the precedence on the other tables.
I then added a little code to SET_ORDER_INFO
I can send the diff to anyone who wants it.
2. I added a way for the customer to update their Home Page. This is
functional but not complete. I will also add code to allow the user to
update the header and footer and other pages.
I created a new database called pages with 3 columns
# --------------------------------------------------------
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
page varchar(30) NOT NULL,
section varchar(30) NOT NULL,
content longtext NOT NULL,
PRIMARY KEY (page),
UNIQUE page (page)
);
I then added some procedures to deal with this. At this point I don't
allow the user to delete or add pages. Only update.
Again if their is any interest the code is available.
Thanks,
Jon Griffin
[EMAIL PROTECTED]
Check out:
<http://www.salsablanca.com>
<http://www.jongriffin.com>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]