osC database change

[Guest]

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());

 

 

[♥geoffreywalton]

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,

[Guest]

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!