View Single Post
  #16  
Old 08-03-2006, 08:04 AM
 
lachild lachild is offline
 

Advanced Member
  
Join Date: May 2006
Posts: 92
 

Default Works Perfectly in 4.1.2

Thanks for the mod I did have to change one line to get the sort by working correctly.

As noted by Shan in an earlier post I changed the following line:

Code:
case "add_date": $sort_string = "$sql_tbl[products].add_date DESC"; break;

to this
Code:
case "add_date": $sort_string = "$sql_tbl[products].add_date $direction"; break;

Works great! Thanks again

Update:

Mod did not by default change to dispay by date. I found that I had to update the products_order feild in the Config table within the datebase.

Use the following SQL command to get the new Date module as an option in the admin section.

Code:
UPDATE `xcart_config` SET `variants` = 'productcode:lbl_sku title:lbl_product orderby:lbl_default price:lbl_price add_date:lbl_date ' WHERE `name` = 'products_order' LIMIT 1 ;
__________________
Westin Shafer
Come Together Technologies
http://www.ComeTogetherTechnologies.com
Reply With Quote