Encyclopedia - Sort Order

registered · Worker Joined: Feb 18, 2004 Posts: 244

Hi,

RN76v2.02

The Encyclopedia lists all entries in the proper catagory. However the entries themselves are not alphabitized.

http://www.psy-center.com/modules.php?name=Encyclopedia&op=terms&eid=2&ltr=A

Could this easily be sorted by adding a sort order to an sql querry somewhere?

Could this be added to the next patch?

Justa' thought and possible suggestion.

Thanks,
Darrell

Posted: Mon Feb 27, 2006 7:58 am

Darrell3831, we have not modified the core nuke 76 modules and so this is standard nuke functionality (though "brain dead" that it might be Laughing

). We are focusing our attentions first on ensuring the community has the most stable and secure distribution of PHP-Nuke a few key add-ons that the community deems "standard fair" for a nuke distribution. We are not including any additional functionalities to existing modules at this time.

Posted: Mon Feb 27, 2006 2:59 pm

Okay,

Thanks for the reply Montego.

Re: RN7.6v2.02

Anyone wanting to fix this themselves, and keep fixing it thru each update, edit line 113 of /modules/encyclopedia/index.php.

Change it from this:

Code:

   $result3 = $db->sql_query("SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'");

To this:

Code:

   $result3 = $db->sql_query("SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid' order by title");

It works for me. You'll just have to redo it each time you upgrade.

Take care,
Darrell

Posted: Mon Feb 27, 2006 6:51 pm

I realize it is just a "nit", but just wanted folks to be clear that this is an "enhancement" to existing core nuke functionality, not really a bug fix.

Posted: Mon Feb 27, 2006 8:02 pm

I think given that this is an Encyclopedia, people would expect it to be alphabetical.
I'd call this a bug fix Smile

Posted: Tue Feb 28, 2006 7:12 am

Hey, it doesn't take much to twist my arm, especially when I am wrong! killing me

Posted: Thu Mar 09, 2006 6:30 am

Guys, would you also want them sorted on the search results?

Worker Joined: Nov 22, 2004 Posts: 208 Location: Italy

Possibly!

Posted: Thu Mar 09, 2006 7:33 am

guidyy, well, that was helpful... Neutral

Posted: Thu Mar 09, 2006 7:57 am

lol! I mean that would be nice ....
Guido

Posted: Thu Mar 09, 2006 8:35 am

Thank you!

Posted: Fri Mar 10, 2006 8:34 am

Darrell3831, this has been fixed for 2.02.02.

edited: was fixed for the term list, search found in title and search found in term text.

Posted: Fri Mar 10, 2006 1:19 pm

Great,

I appreciate the time you spend on this package. It's nice not to have to keep fixing it thru subsuquent upgrades.

Thanks,
Darrell