Phpraid Events displaying backwards

Joomla/Mambo integration forum

Phpraid Events displaying backwards

Postby shizimu » Wed Mar 07, 2007 9:37 am

I installed the module, but at the moment the events displayed in the module block are actually backwards. SO they displayed the end of the months raids and not the new ones coming.

http://www.delinquents.co.uk/

To the right is the module. Is this intentional? How can i make it display the next raid onwards?
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Re: Phpraid Events displaying backwards

Postby shizimu » Thu Mar 08, 2007 5:27 pm

Sussed it.

Fix is if you dont know...

edit the module file named mod_phpraid_events.php

So that the line that reads

Code: Select all
$result = mysql_query("SELECT location, description, old, invite_time FROM ".$prefix."raids  WHERE old=0 order by start_time desc limit $show_new_raids") or die(mysql_error());


should be changed to

Code: Select all
$result = mysql_query("SELECT location, description, old, invite_time FROM ".$prefix."raids  WHERE old=0 order by start_time ASC limit $show_new_raids") or die(mysql_error());


that will fix it so that the module will now display the raids from the closest onwards.
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm


Return to Joomla/Mambo

Who is online

Users browsing this forum: No registered users and 0 guests

cron