Clan Adverts

Custom PHPNuke Scripts

www.clan-themes.co.uk :: View topic - Change message order on nuke raven

 Welcome To Clan Themes 

As the board grows please remember the Search Option and we hope you find our community useful.

We also monitor Private Messages to stop members from abusing our sites system.
If you are asking for assistance please provide your site link and nuke version, Thanks.
Change message order on nuke raven

1 Replies / 719 Views
Post new topic   Reply to topic  

   www.clan-themes.co.uk Forum Index » Ravens Nuke

View previous topic :: View next topic


Please report all major problems to Ravens Site, please.

mia_undertaker
Reputation: 452
Local time: 1:55 PM


 Status: Offline
0.08 posts per day
Medals: 0
Joined: Jun 03, 2007
Last Visit: 29 Oct 2008
Posts: 43
Points: 766 
Post Change message order on nuke raven Posted: Sat Apr 26, 2008 2:52 am   
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0
I need to add some order by code to my mainfile.php to change the order of my messages on my main page.
I know to use an ORDER BY mid DESC but I am not sure about the syntax.

Here is the line of code I need to add it to:

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

Can someone help me out?

Thanks
[MIA] UnderTaker
 

 
View user's profileSend private message Reply with quote

floppy
Reputation: 1794.6
votes: 10
Local time: 1:55 PM
Location: Jackson Mississippi
usa.gif

 Status: Offline
2.77 posts per day
Medals: 1 (View more...)
Dedicated User (Amount: 1)
Clan Themes Scripts/Coder
Clan Themes Scripts/Coder
Joined: Nov 14, 2006
Last Visit: 02 Dec 2008
Posts: 2074
Points: 4423 
Post Change message order on nuke raven Posted: Sat Apr 26, 2008 4:17 am   
Shop Purchases:Clan Roster 2.0
if the main key is mid then

Code:
ORDER BY mid


Code:
ORDER BY mid ASC


Code:
ORDER BY mid DESC


Tag that on the end before $querylang I think. Honestly not sure what that stands for off top of my head.

Ex:
Code:
 $result = $db->sql_query('SELECT * FROM '.$prefix.'_message WHERE active=1 ORDER BY mid ASC '.$querylang );


It could possibly have to be after $querylang, I need to look that one up /shrug.
 

 
View user's profileSend private messageVisit poster's website Reply with quote
Post new topic   Reply to topic  
   www.clan-themes.co.uk Forum Index » Ravens Nuke


 
1 Replies / 719 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
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 cannot attach files in this forum
You cannot download files in this forum