MikeyF Posted February 28, 2004 Posted February 28, 2004 First I just want to say I think it is great that the people involved with oscommerce made such a terrific product and it is open source. I am new to using php and mysql. I am trying to set up: Guest Account version 2.0 By Ole Byskov (olby) / Ian Davidson I cannot figure out how or where to: Changes to database: (the are the commands in the sql file) AC Add this field to table customers: # Add customers guest_flag values to each customer ALTER TABLE `customers` ADD `guest_flag` CHAR( 1 ) NULL DEFAULT '0'; Add these 2 fields to table configuration by running these lines in phpmyadmin or what ever you prefer. # Add admin-facility to Guest Accounts INSERT INTO configuration_group VALUES (40, 'Guests', 'Guests settings', 40, 1); INSERT INTO configuration VALUES ('', 'Guests accounts', 'GUEST_ON', 'true', 'Allow Customers to purchase without an account', 40, 1, '2003-09-09 13:07:44', '2003-09-09 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); I went into phpmyadmin and added the guest_flag to the database but to be honest I'm not sure if it is in the correct area. I just want to make sure I am doing it correctly. Thanks
only2empires Posted February 29, 2004 Posted February 29, 2004 Easiest way is to go to your phpmyadmin, click on your database name right under the "Home" to bring up all the files on the right-hand side. Choose "SQL" at the top and when that page comes up..find: Or Location of the textfile : and browse for the file within the contribution (guestmod SQL file). Click "GO" and it will insert for you.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.