Classifieds Newest First

Hi,

I have put up a number of classified ads, can anybody tell me how to set the newest ads at the top, or how to order the classifieds.

Thanks

There are 2 spots you need to change:

inc/classes/BxDolClassifieds.php

Locate:

$sOrderBy = (getParam('enable_classifieds_sort') == 'on') ? 'ORDER BY `ClassifiedsSubs`.`NameSub` ASC' : '' ;

And also locate:

$sOrderBy = (getParam('enable_classifieds_sort') == 'on') ? 'ORDER BY `Classifieds`.`Name` ASC' : '' ;

Where you see:  ASC  Change it to:  DESC and that will place newest at the top & oldest at the bottom. 

Enjoy.

Thanks for your reply

I have made those changes and it doesn't have any effect. I am using version 6.1.6

Here is a link http://www.icebiker.com/ads 

Cheers

Yes, I just tried this again, I found that it orders the categories list, not the items.

I am trying to order the items within the categories to newest first.

Any help would be appreciated.

Thanks

Do a search in the same file for "ASC" (without the quotes) and look for references when you find it to categories in the function and then set that ASC to DESC and it will complete the task your looking for.  If it's not there, then you'll need to write into the function the ability to organize and then set that to DESC.

Hi

Thanks again for your reply, unfortunately, it didn't do the trick.

I got this from Boonex support

replace the following line
$sQuery.=" ORDER BY `ClassifiedsAdvertisements`.`DateTime` ";
with
$sQuery.=" ORDER BY `ClassifiedsAdvertisements`.`DateTime` DESC ";

It didn't work either, however, I noticed on the boonex demo version the oldest ad appears first. So the oldest ad first must be the default for the system.

I also noticed that on the demo version 7 hookie, the problem seems to be addressed.