PDA

View Full Version : New/Active Sort Order for 1.1.4


12-05-2000, 02:51 PM
Can someone give me the modification to make the sorting order for new/active threads to go by group, not by newest first?

I have it on my 1.1.3, but I need it for the 1.1.4! (wasn't sure what I changed last time)

Thanks!!

12-07-2000, 05:18 PM
Ed, can you help me with this?

12-09-2000, 04:46 PM
IN SEARCH.PHP

Find:
------------------------
$searchresults=$DB_site->query("SELECT DISTINCT
threadid,
lastpost
FROM thread
WHERE visible=1 $checkforum $subjectonly $checkuser $checkdate $combinedwords
ORDER BY lastpost DESC");
-------------------------

Replace with:
-------------------------
if ($getdaily=="yes") {
$searchresults=$DB_site->query("SELECT DISTINCT
threadid,
lastpost
FROM thread
WHERE visible=1 $checkforum $subjectonly $checkuser $checkdate $combinedwords
ORDER BY forumid DESC");
} else {
$searchresults=$DB_site->query("SELECT DISTINCT
threadid,
lastpost
FROM thread
WHERE visible=1 $checkforum $subjectonly $checkuser $checkdate $combinedwords
ORDER BY lastpost DESC");
}
--------------------------