sorting admin messages - newest to oldest [7.6/3.1] [fixed]

Posted: Fri Nov 11, 2005 12:59 pm

Maybe I'm just stupid but is there a simple way to have the newest admin messages sorted to the top of the news list instead of the bottom? I can't seem to find diddley squat on this...

Thanks Smile

Posted: Fri Nov 11, 2005 1:37 pm

I haven't tested this, but you can try to sort messages by date.

In that case, open up the mainfile.php and find:

Code:

$result = $db->sql_query("SELECT * FROM ".$prefix."_message WHERE active='1' $querylang");

Replace with:

Code:

$result = $db->sql_query("SELECT * FROM ".$prefix."_message WHERE active='1' $querylang ORDER BY date DESC");

Let us know if that solves the problem.

Steph

Posted: Fri Nov 11, 2005 1:48 pm

sweet! sure will. brb

Posted: Fri Nov 11, 2005 1:55 pm

eh. I only have this

Code:

$result = $db->sql_query("SELECT * FROM ".$prefix."_config");

I'm using 7.6 patched 3.1. Maybe it's in another file?

Posted: Fri Nov 11, 2005 2:04 pm

Do a search of your mainfile.php for _message

You should find it in there.

In the latest version of Patched 3.1, they have it on line 572 as:

Code:

$result = $db->sql_query("SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang");

Replace that with:

Code:

$result = $db->sql_query("SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang ORDER BY date DESC");

Steph

Posted: Fri Nov 11, 2005 2:14 pm

Sorry, I was looking at something else, so I have edited my latest post to clarify.

Thanks
Steph

Posted: Fri Nov 11, 2005 3:18 pm

YOU ROCK!!! I'll come here forever!!! Very Happy