Jump to content

241

Members
  • Content count

    6,148
  • Joined

  • Last visited

Everything posted by 241

  1. Just set the sort order to rand() Set the sort order for the feature products. p.products_id
  2. clear the featured date in the admin by highlighting it and pressing delete, this will set date to 00-00-00
  3. This is what all will need to be removed, however be aware of the warning -- WARNING Be careful with this next bit as your id numbers may be different ALTER TABLE categories DROP categories_featured, DROP categories_featured_until; ALTER TABLE manufacturers DROP manufacturer_featured, DROP manufacturers_featured, DROP manufacturers_featured_until, DROP manufacturer_featured_until; ALTER TABLE products DROP products_featured_until, DROP products_featured; ALTER TABLE products_description DROP products_short; -- WARNING Be careful with this next bit as your id numbers may be different DELETE FROM configuration_group WHERE configuration_group_id = '99' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '143' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '144' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '145' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '146' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '147' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '148' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '149' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '150' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '151' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '152' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '153' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '154' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '155' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '156' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '157' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '158' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '159' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '160' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '161' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '162' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '163' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '164' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '165' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '166' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '167' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '168' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '169' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '170' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '171' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '172' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '173' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '174' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '175' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '176' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '177' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '178' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '179' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '180' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '181' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '182' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '183' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '184' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '185' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '186' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '187' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '188' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '189' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '190' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '191' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '192' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '193' LIMIT 1; DELETE FROM configuration WHERE configuration_id = '194' LIMIT 1;
  4. 241

    Error Message - Just Installed Contribution.

    ome of the queries in the file has a space between the F and the ROM of FROM
  5. 241

    Ordering each product attribute type

    you could change the order of the case. default is for the drop menus whilst the text area is a case. You could move the code to make the default the text area and make the drop menu a case
  6. for the moment you can only show one category with products at a time. the link code is wrong, I think this was covered before it need to read FILENAME_DEFAULT not FILENAME_PRODUCT_INFO and it also needs to be cPath= rather than categories_id=
  7. 241

    Payment

    I will presume that this is for cheque payments, therefore it is in your admin left hand menu under modules then payment then Check/Money Order, click the edit button and make the change
  8. 241

    easypopulate help!

    ok so you have the temp directory in store and what do you have in easypopulate.php for $tempdir have you saved the file as a tab deliminated file with extension .txt
  9. 241

    easypopulate help!

    lets start at the beginning is your site located in the root or in a directory called catalog
  10. 241

    easypopulate help!

    try this create a directory in your catalog called easypopulate and set the permissions to CHMOD 777 all rights to all things. Next change these two lines in easypopulate.php to this $tempdir = "/easypopulate/"; $tempdir2 = "/easypopulate/";
  11. Sorry that you feel the need to give up as this is an easy contribution to install. You will need to post your other questions in the general support forum as they are not related to this contribution and it's support channel.
  12. do you have products_featured in your products table in the database, if not run this sql to see if it produces any duplicate entry errors. Only run the sql if no products_featured field is in the products table of the database ALTER TABLE `products` ADD `products_featured` tinyint(1) default '0' AFTER `products_status`; ALTER TABLE `products` ADD `products_featured_until` date default NULL AFTER `products_date_available`; ALTER TABLE `categories` ADD `categories_featured_until` date default NULL AFTER `sort_order`; ALTER TABLE `categories` ADD `categories_featured` tinyint(1) default '0' AFTER `sort_order`; ALTER TABLE `manufacturers` ADD `manufacturer_featured_until` date default NULL AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturers_featured_until` date default NULL AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturers_featured` tinyint(1) default '0' AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturer_featured` tinyint(1) default '0' AFTER `manufacturers_image`; ALTER TABLE `products_description` ADD `products_short` TEXT AFTER `products_name`;
  13. 241

    South AFrican Postage

    check your tare weight in the admin left menu shipping/packaging in the configuration box
  14. Is it possible to track clicks on popup pages as well?
  15. It may be that the sql did not complete, try running this sql ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT; ALTER TABLE `manufacturers_info` CHANGE `languages_id` `languages_id` INT( 11 ) DEFAULT '1' NOT NULL; INSERT INTO configuration_group VALUES ('99', 'Featured Sets', 'Configure featured sets', 16, 1); INSERT INTO configuration VALUES ('', 'Display featured products', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Show featured products?', 99, 1, '2004-06-23 20:16:49', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured products section', 'FEATURED_PRODUCTS_POSITION', '2', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 2, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured products maximum', 'MAX_DISPLAY_FEATURED_PRODUCTS', '2', 'How many featured products show?', 99, 3, '2004-06-22 18:16:16', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured products layout', 'FEATURED_PRODUCTS_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 4, '2004-06-28 23:23:35', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 5, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured products period', 'DAYS_UNTIL_FEATURED_PRODUCTS', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 6, '2004-06-23 18:15:33', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured products set layout', 'FEATURED_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 7, '2004-06-28 23:23:04', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured products set style', 'FEATURED_SET_STYLE', '4', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 8, '2004-07-12 12:20:27', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_SET_STYLE_SHADOW', 'left', 'right or left', 99, 9, '2004-07-12 12:24:42', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature products.', 'FEATURED_PRODUCTS_SORT_ORDER', 'p.products_id', '<br><b>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 10, '2004-06-10 23:54:40', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for products by ascending or descending', 'FEATURED_PRODUCTS_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 11, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Products vertical line height', 'VLINE_IMAGE_HEIGHT', '240', 'Sets the height of the vertical line divider', 99, 12, '2004-06-10 17:49:09', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Products vertical line colour', 'VLINE_IMAGE_COLOUR', 'blue', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 13, '2004-06-10 16:51:31', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Products horizontal line colour', 'HORIZONTAL_LINE_COLOUR', 'f8fd69', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 14, '2004-06-10 17:11:42', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured manufacturers', 'FEATURED_MANUFACTURERS_DISPLAY', 'true', 'Show featured manufacturers?', 99, 15, '2004-06-23 20:16:58', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured manufacturers', 'FEATURED_MANUFACTURERS_POSITION', '1', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 16, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured manufacturers maximum', 'MAX_DISPLAY_FEATURED_MANUFACTURERS', '6', 'How many featured manufacturers to show?', 99, 17, '2004-06-23 22:45:27', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured manufacturers layout', 'FEATURED_MANUFACTURERS_COLUMNS', '6', 'How many columns do you want to use in your layout?', 99, 18, '2004-06-23 22:45:32', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Set the sort order for the featured manufacturers.', 'FEATURED_MANUFACTURERS_SORT_ORDER', 'm.manufacturers_id', '<br><b>manufacturers id, <br>manufacturers name, <br>random.</b><br>', 99, 19, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''m.manufacturers_id'', ''m.manufacturers_name'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the manufacturers sort order by ascending or descending', 'FEATURED_MANUFACTURERS_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 20, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Manufacturers vertical line height', 'MANUFACTURERS_VLINE_IMAGE_HEIGHT', '110', 'Sets the height of the vertical line divider', 99, 21, '2004-06-23 22:26:18', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Manufacturers vertical line colour', 'MANUFACTURERS_VLINE_IMAGE_COLOUR', 'red', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 22, '2004-06-11 19:59:35', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Manufacturers horizontal line colour', 'MANUFACTURERS_HORIZONTAL_LINE_COLOUR', 'AABBDD', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 23, '2004-06-19 16:39:39', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured manufacturers period', 'DAYS_UNTIL_FEATURED_MANUFACTURERS', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 24, '2004-06-23 18:15:40', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured manufacturer with products', 'FEATURED_MANUFACTURER_DISPLAY', 'true', 'Show featured manufacturer with products?', 99, 25, '2004-06-19 20:08:08', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured manufacturer with products', 'FEATURED_MANUFACTURER_POSITION', '3', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 26, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured manufacturer with products maximum', 'MAX_DISPLAY_FEATURED_MANUFACTURER', '2', 'How many featured manufacturer with products show?', 99, 27, '2004-06-23 22:24:58', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in manufacturer with products layout', 'FEATURED_MANUFACTURER_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 28, '2004-06-19 20:09:15', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_MANUFACTURER_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 29, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured manufacturer with products period', 'DAYS_UNTIL_FEATURED_MANUFACTURER', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 30, '2004-06-23 18:15:50', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured manufacturer with products set layout', 'FEATURED_MANUFACTURER_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 31, '2004-06-23 22:24:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured manufacturer with products set style', 'FEATURED_MANUFACTURER_SET_STYLE', '3', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 32, '2004-07-12 12:38:14', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_MANUFACTURER_SET_STYLE_SHADOW', 'right', 'right or left', 99, 33, '2004-07-12 11:56:00', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature manufacturer with products.', 'FEATURED_MANUFACTURER_SORT_ORDER', 'm.manufacturers_id', '<br><b>manufacturers id, <br>manufacturers name, <br>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 34, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''m.manufacturers_id'', ''m.manufacturers_name'', ''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the manufacturer sort order by ascending or descending', 'FEATURED_MANUFACTURER_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 35, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Manufacturer with products vertical line height', 'MANUFACTURER_VLINE_IMAGE_HEIGHT', '150', 'Sets the height of the vertical line divider', 99, 36, '2004-06-23 22:26:04', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Manufacturer with products vertical line colour', 'MANUFACTURER_VLINE_IMAGE_COLOUR', 'blue', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 37, '2004-06-10 16:51:31', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Manufacturer with products horizontal line colour', 'MANUFACTURER_HORIZONTAL_LINE_COLOUR', 'f8fd69', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 38, '2004-06-10 17:11:42', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured categories', 'FEATURED_CATEGORIES_DISPLAY', 'true', 'Show featured categories?', 99, 39, '2004-06-19 20:08:08', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured categories', 'FEATURED_CATEGORIES_POSITION', '4', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 40, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured categories maximum', 'MAX_DISPLAY_FEATURED_CATEGORIES', '4', 'How many featured categories show?', 99, 41, '2004-06-28 16:48:04', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured categories layout', 'FEATURED_CATEGORIES_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 42, '2004-06-19 20:09:15', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_CATEGORIES_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 43, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured categories period', 'DAYS_UNTIL_FEATURED_CATEGORIES', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 44, '2004-06-23 18:15:50', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured categories set layout', 'FEATURED_CATEGORIES_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 45, '2004-06-28 16:46:19', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured categories set style', 'FEATURED_CATEGORIES_SET_STYLE', '3', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 46, '2004-07-12 12:37:44', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_CATEGORIES_SET_STYLE_SHADOW', 'right', 'right or left', 99, 47, '2004-07-12 11:56:00', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature categories.', 'FEATURED_CATEGORIES_SORT_ORDER', 'c.categories_id', '<br><b>categories id, <br>categories name, <br>manufacturers id, <br>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 48, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''c.categories_id'', ''cd.categories_name'', ''m.manufacturers_id'', ''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the categories sort order by ascending or descending', 'FEATURED_CATEGORIES_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 49, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Categories vertical line height', 'CATEGORIES_VLINE_IMAGE_HEIGHT', '150', 'Sets the height of the vertical line divider', 99, 50, '2004-06-23 22:26:04', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Categories vertical line colour', 'CATEGORIES_VLINE_IMAGE_COLOUR', 'green', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 51, '2004-06-28 16:29:02', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Categories horizontal line colour', 'CATEGORIES_HORIZONTAL_LINE_COLOUR', 'dcab89', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 52, '2004-06-28 16:27:32', '0000-00-00 00:00:00', NULL, NULL);
  16. I don't see any issues here merge the two parts, in this case the header tags part into the featured sets part by adding this into the query , pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,
  17. Does the product have attribute options? If product has attributes options it will go to product_info.php If product does not have attributes options it will go to shopping_cart.php
  18. 241

    Split files

    is your temp directory in the catalog directory or the admin
  19. Header Whitespace download the file catalog/includes/functions/general.php open it and place your cursor after the last ?> then press delete several times, save the file and upload it. Do not use the file manager to edit online as this can cause the whitespace. instead use an ftp program such as ws_ftp to download the file to a local machine and edit then upload using the ftp program If you require more information then Click
  20. 241

    Free shipping for selected products

    you could add an entry to the database, to give you an entry section in admin. Then use an array statement
  21. 241

    SQL problems

    you already have an entry in the database with the configuration_group_id value of 30 the resolve is to change the sql to be INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` ) VALUES ( '', 'Current Auctions', 'Current Auction configuration', 30, 1 );
  22. Yes, you should run the sql from the point of original fault ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT replacing this line with the ammended line ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT;
  23. this previous post has the answer http://forums.oscommerce.com/index.php?sho...ndpost&p=612729
  24. Read my last reply to you
  25. yes instead of replacing the code from your previous question you would add the code line below so as to be <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED_SETS); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr>
×