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]

Reply via email to