The Arcive of vBulletin Modifications Site. |
|
Details »»
|
|||||||||||||||||||||||||
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!! Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
|||
|
|||
|
Ed, can you help me with this?
|
|
#3
|
|||
|
|||
|
Code:
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");
}
--------------------------
|
![]() |
|
|