Content Module categories/page order

Worker Joined: Dec 05, 2006 Posts: 180

Version: Raven Nuke 7.6
Would it be possible to set the order number in which the Categores and pages are shown? instead of by date or possibly by id #. I think the id # is kinda like the date? erm something like that right? I say this because I see in the index code "ORDER BY date" is used.

Would another way be, going into the sql database and editing the id #'s for right now till something is created to do so? Would it be hard in doing so?

thanks,

j

edit: so maybe in the future we could chose the id number. Oh then again having two of the same id #'s wouldnt work. Or... um well the only thing i can think of is another script telling us to use such and such id as either 1 or 2nd on the list and so on. Say id#3 should appear 1st on the list... know what i mean?

:shrugs:

edit#2: oh yea i forgot i wanted to ask.
As i view the contents page, while logged into admin account. I see there is at the bottom of the page "Content Module Administration Panel" box but nothing in it? is there suppose to be something there?

Posted: Thu Dec 07, 2006 5:05 pm

doh i just thought of something. Ill change the index file to "ORDER BY title ASC" then lable the titles in number order..... ok going off to try.

Edit: ok didnt work, unless im doing something wrong. I dont know anything about php really. I just found and replaced all "ORDER BY date" to "ORDER BY title ASC"

Edit: ok it works for the content pages under or inside the Categories. Still need to figure out where the code is for the Categories

Posted: Thu Dec 07, 2006 6:37 pm

Ok got it.

File: /modules/Content/index.php

Find:

Code:




    echo "<center><font class=\"content\">"._LISTOFCONTENT." $sitename:</center><br><br>";


    $result = $db->sql_query("SELECT * FROM ".$prefix."_pages_categories");

Replace with:

Code:

    echo "<center><font class=\"content\">"._LISTOFCONTENT." $sitename:</center><br><br>";


    $result = $db->sql_query("SELECT * FROM ".$prefix."_pages_categories ORDER BY title ASC");

Also I replaced all "ORDER BY date" with "ORDER BY title ASC"

the ASC is for ascending or you could put DESC for descending.

So now my Categories looks like this:

1. whatevers First
2. whatever
3. apple

So when creating my Categories and Pages inside my Content module I labled the titles "1. whatevers First".... 1. being part of the title.

Is there a better way? let me know thanks

registered · Posted: Fri Dec 08, 2006 7:01 am

Nope. Looks good. This allows you to control the order simply by renumbering your titles. Good job!

Posted: Fri Dec 08, 2006 2:43 pm

thanks