Q-Shop v3.0 includes a number of additional configuration parameters that are managed via the Control Panel. Some are new fields and some have been moved from being hardcoded in several files. The fields are:

SMTP_Username
SMTP_Password
UserReviews
Shop_Address1
LogoURL
ShowTop10Center
Shop_Address2
smLogoURL
ShowTop10Right
Shop_City
NotAvailImg
Shop_ZIP
Shop_State
Shop_Country
Shop_Telephone
FeatProdsNumber
Shop_Fax
ShowTerms
SECUREURL
TimeOut
TempPath

The following SQL script will insert the new entries into the database. You can run the script using the SQL Query tool under the DB Tool section in the Control Panel:

INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('SMTP_Username','',2,2)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('SMTP_Password','',2,3)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('UserReviews','0',3,1)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_Address1','Address 1',4,1)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('LogoURL','images/logo.gif',5,1)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('ShowTop10Center','1',3,2)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_Address2','Address 2',4,2)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('smLogoURL','images/logop_inv.gif',5,2)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('ShowTop10Right','1',3,3)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_City','City',4,3)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('NotAvailImg','images/notavailable_sm.gif',5,3)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_ZIP','0000',4,4)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_State','State',4,5)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_Country','Country',4,6)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_Telephone','555 11111',4,7)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('FeatProdsNumber','2',0,8)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('Shop_Fax','555 55555',4,8)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('ShowTerms','1',0,10)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('SECUREURL','',0,11)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('TimeOut','30',0,12)
INSERT INTO Config_Table (FieldName, Content, Type, OrderNumber) VALUES ('TempPath','c:\inetpub\q-shop3\db\',0,13)
UPDATE Config_Table SET Content = NULL WHERE Content = '' AND FieldName = 'SECUREURL'