Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osC database change


Guest

Recommended Posts

Hi

 

I'm looking to make a change to the osC db, and have already added some contributions changing the db. Specifically, I'm trying to understand the configuration table, (and if I need to change the "11", "12", "13", and "14" for sort_order from the below code). I think it depends on the last item with the configuration_group_id of "8", but I'm not sure what this exactly means. In the screen shot of the db, I see that there are more configuration_group_id after 8 (ie 9 stock) , but if I look at the details of "8" Product Listing, I see the last screen shot. Can someone help me learn a little about the db and if I need to change the code. (My guess is that I do, perhaps 16, 17, 18, 19, but I thought I'd ask and learn before just doing and breaking it.

 

Thank you!

 

Code I'm looking to add:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Add Multiples column', 'PRODUCT_LIST_MULTIPLE', '0', 'Do you want to display the Multiple Quantity with Attributes column?', '8', '11', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Add Multiples with Buy Now column', 'PRODUCT_LIST_BUY_NOW_MULTIPLE', '0', 'Do you want to display the Multiple Quantity Buy Now with Attributes column?', '8', '12', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Number of column per row', 'PRODUCT_LIST_NUMCOL', '3', 'How many columns per row to display?', '8', '13', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Show actual price in the pull down menu for attributes', 'PRODUCT_LIST_ACTUAL_PRICE_IN_DROPDOWN', 'No', 'Do you want to show the actual price in the pull down menu for attributes or the (+ $10.00) ?', '8', '14', 'tep_cfg_select_option(array(\'Yes\', \'No\'), ', now());

 

osc.gif

 

osc1.gif

Link to comment
Share on other sites

Not sure what you are trying to achieve.

 

If you could share that then we could describe what needs to be done to achieve that,

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

I'm looking to install the product_listing_columns_2_2_5 contribution, but since know so little about the db I'm trying to do more than simply get it installed/working, I was hoping to actual learn something along the way about what it is I'm doing. That said I thought the two screen shots of what is in my db may make the answer to whether I can install as is, or if I need to change obvious to someone who knows what they are doing.

 

Product Listing in Columns

 

Thanks for being willing to help!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...