1. Add "Cost" field to variation table.
Since some of my customers request for customization on Linux Yen ES.  I
would like to add "Cost" field to the "variation" table.  It allows
vendors to charge extra for customization like faster processor, larger
hard disk drive, etc.

SQL statement:
ALTER TABLE variation ADD Cost float(11,2);

Add this line to file add_variation:
. . . 
print(L_ADDVARIATION_COST);
print("<INPUT TYPE=\"text\" NAME=\"inputCost\" SIZE=\"32\">");
print("<BR>\n");
. . .

Add this line to file english:
. . .
define ('L_ADDVARIATION_COST', 'Cost');
. . .

2. Add "IPAddress" field to user table.
We want to know where our customer IP address is orginated from when they
first create their account.  It helps us to easily investigate fraud or
order that suggest "unusual" behavior.  PHP uses the variable
$REMOTE_ADDR to store IP address of client browser.

SQL statement:
ALTER TABLE user ADD IPAddress varchar(256);

Can we put this in FreeTrade 2.0?

Kent




------------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Site:            http://www.working-dogs.com/freetrade/
Problems?:       [EMAIL PROTECTED]

Reply via email to