Challenges order by newest first - Graveyard

RE: Challenges order by newest first

Jan_AQ — Mon, 21 Aug 2023 08:59:01 +0000

Oh Thank Merlin i posted this.

This NEEDS to be in the default download. This is the only way you can view the most recent and screen them, deleting or fixing them as they show up.

Re: Challenges order by newest first

SomethingBlue42 — Thu, 15 Dec 2011 16:07:57 +0000

I've been wondering if there was a way to do this for a LONG time now. Very useful! Thanks!

Re: Challenges order by newest first

IzDoodle — Wed, 17 Aug 2011 16:15:08 +0000

This was super easy, and super helpful. I was trying to figure out how to do this. Thanks so much.

Re: Challenges order by newest first

jacci — Thu, 07 Apr 2011 05:27:18 +0000

Want to thank you for this snippet of coding Jan_AQ, has come in very useful.

Challenges order by newest first

Jan_AQ — Wed, 22 Apr 2009 07:17:23 +0000

I have been trying to figure out a way to view the newest challenges on my site and I came up with this briefly:

A way to view the newest challenges first. (Challenges module version 1.4)
Challenges will be listed by newest first on the Challenges page, as well as under every letter.

In the Challenges module folder open browse.php

Line 66:

change from:

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

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