quest sorting

Here you can find plenty of help with your general coding needs and projects
If it is about a specific program, use the corresponding forum
DO NOT ask basic questions such as "How do I print a variable", use Google for that

quest sorting

Postby vittoriusly » Fri Mar 09, 2007 7:19 pm

I found the last version of "show quest" features very annoying: it doesn't sort the quest by zone (and inside the same zone by level), but only by quest_id.

In WoWRoster 1.7.3 I modified line 87 inside the file $ROSTERLIB\quest.php (<rosterdir>\lib\quest.php usually)
Code: Select all
$query= "SELECT * FROM `".ROSTER_QUESTSTABLE."` WHERE `member_id` = '$member_id' ORDER BY `zone` ASC, `quest_level` DESC";

Instead of
Code: Select all
/$query= "SELECT * FROM `".ROSTER_QUESTSTABLE."` WHERE `member_id` = '$member_id' ORDER BY 'quest_index' ASC ";


With that query you'll see your quests order by zone first (alphabetic order) and then by lvl (from the highest one to the "easyest" one).
That's all.
I hope It could be usefull.
vittoriusly
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Jul 17, 2006 2:35 pm

quest sorting

Postby zanix » Fri Mar 09, 2007 8:40 pm

Not a bad idea
Consider this in 1.8
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

quest sorting

Postby zanix » Fri Mar 09, 2007 9:17 pm

Ok, I like it, it will be in 1.8
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to General Code Help

Who is online

Users browsing this forum: No registered users and 0 guests

cron