[MOD REQUEST] Most ...
 
Notifications
Clear all

[MOD REQUEST] Most Recent Challenges

7 Posts
3 Users
0 Reactions
2,403 Views
(@jessicarae)
Posts: 25
Eminent Member
Topic starter
 

Could someone create a Mod for the Challenges page where you can sort by Most Recent? A few of my members asked for this so they don't have to sort through all the pages of Challenges to find new ones. Is something like that possible?


 
Posted : 10/11/2007 6:15 pm
 Elle
(@jenny)
Posts: 594
Honorable Member
 

You could edit the challenges file to sort it by the challenge ID.

I don't have challenges and I've never actually used it before, so I'm not quite sure where to edit this.

I've read somewhere that challenges don't store dates, so you can't sort it by "recent", but you can sort it by challenge ID which would be something similar.


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 10/11/2007 6:58 pm
(@jessicarae)
Posts: 25
Eminent Member
Topic starter
 

Thanks for the info, Jenny. πŸ™‚

If anyone knows how I could edit the challenges file so that it sorts by ID instead of alphabetically I would greatly appreciate it!


 
Posted : 10/11/2007 10:13 pm
(@purpleyin)
Posts: 16
Active Member
 

I'd be interested in this too, would be useful. I had a look over the file but can't figure out where to change this, I'm not familiar enough with the code.


 
Posted : 16/03/2008 3:53 pm
 Elle
(@jenny)
Posts: 594
Honorable Member
 

A preliminary look from a recent download...

modules/challenges/browse.php

line 66:

$query = "SELECT chal.* FROM ".TABLEPREFIX."fanfiction_challenges as chal $chalquery ORDER BY title LIMIT $offset, $itemsperpage";

Change to:

$query = "SELECT chal.* FROM ".TABLEPREFIX."fanfiction_challenges as chal $chalquery ORDER BY chalid DESC LIMIT $offset, $itemsperpage";

archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 16/03/2008 4:27 pm
(@purpleyin)
Posts: 16
Active Member
 

Oooh thank you, that worked like a charm. πŸ˜€


 
Posted : 16/03/2008 5:18 pm
(@purpleyin)
Posts: 16
Active Member
 

I'm finding the same modification doesn't work reapplying it after an upgrade to 3.4.3 - any clue why?


 
Posted : 05/06/2008 8:13 am
Share: