Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Need Help with Guest Account


Recommended Posts

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.



Link to comment
Share on other sites

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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...