Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
xAtlas
New Member
New Member


Joined: Nov 09, 2005
Posts: 10
Location: Michigan

PostPosted: Fri Nov 11, 2005 12:59 pm Reply with quote

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

_________________
Success is only gained through failure.

Last edited by xAtlas on Fri Nov 11, 2005 3:19 pm; edited 2 times in total 
View user's profile Send private message Visit poster's website AIM Address
64bitguy
The Mouse Is Extension Of Arm


Joined: Mar 06, 2004
Posts: 1159
Location: Sanbornton, NH USA

PostPosted: Fri Nov 11, 2005 1:37 pm Reply with quote

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

_________________
Steph Benoit Only registered users can see links on this board! Get registered or login!
1CMS, 100% Section 508 and W3C XHTML/CSS Compliant (Truly) 
View user's profile Send private message Visit poster's website
xAtlas
PostPosted: Fri Nov 11, 2005 1:48 pm Reply with quote

sweet! sure will. brb
 
xAtlas
PostPosted: Fri Nov 11, 2005 1:55 pm Reply with quote

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?
 
64bitguy
PostPosted: Fri Nov 11, 2005 2:04 pm Reply with quote

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
 
64bitguy
PostPosted: Fri Nov 11, 2005 2:14 pm Reply with quote

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

Thanks
Steph
 
xAtlas
PostPosted: Fri Nov 11, 2005 3:18 pm Reply with quote

YOU ROCK!!! I'll come here forever!!! Very Happy
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©