Clan Adverts

Sponsors

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme
Mech Warrior Online Xtreme Theme

User Box

Anonymous
38.107.179.216
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ? This s...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriously...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - Change message order on nuke raven
Change message order on nuke raven

1 Replies / 1751 Views
Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » Ravens Nuke

View previous topic :: View next topic


Please report all major problems to Ravens Site.

mia_undertaker
Reputation: 461.4 Add RepSubtract Rep
Local time: 2:23 AM

blank.gif

 Tree Hugger
Tree Hugger

0.04 posts per day
Medals: 0
Joined: Jun 03, 2007
Last Visit: 28 Feb 2011
Posts: 72
Points: 9879 
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 · Modern Gamer Multi Theme · Gamer Cards Module
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: 2088.8 Add RepSubtract Rep
votes: 22
Local time: 2:23 AM
Location: Jackson Mississippi
usa.gif

 Site Admin
Site Admin

1.17 posts per day
Medals: 2 (View more...)
Dedication (Amount: 1)
Scripts/Coder
Scripts/Coder
Joined: Nov 14, 2006
Last Visit: 03 May 2012
Posts: 2353
Points: 132516 
Post Change message order on nuke raven Posted: Sat Apr 26, 2008 4:17 am
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version
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.
 

Phpnuke Downloads | VMaxxRx Male Enhancement  
View user's profileSend private messageVisit poster's website Reply with quote
Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » Ravens Nuke


 
1 Replies / 1751 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
 

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke