MemberList and Profession

by **KaguraS** » Tue May 27, 2008 8:25 pm

In the member list I dont want to show Professions of level < 75 , what should I do to fix it?

by **PleegWat** » Tue May 27, 2008 10:02 pm

open 'memberslist.php', and find:

Code: Select all: $SQL_prof = $wowdb->query( "SELECT * FROM `".ROSTER_SKILLSTABLE."` WHERE `member_id` = '".$row['member_id']."' AND (`skill_type` = '".$wordings[$lang]['professions']."' OR `skill_type` = '".$wordings[$lang]['secondary']."') ORDER BY `skill_order` ASC" );

Replace with:

Code: Select all: $SQL_prof = $wowdb->query( "SELECT * FROM `".ROSTER_SKILLSTABLE."` WHERE `member_id` = '".$row['member_id']."' AND (`skill_type` = '".$wordings[$lang]['professions']."' OR `skill_type` = '".$wordings[$lang]['secondary']."') AND `skill_level` > 75 ORDER BY `skill_order` ASC" );

by **KaguraS** » Wed May 28, 2008 6:39 am

hum ty, but i was asking for the roster 1.99, i forget to mention it

by **zanix** » Wed May 28, 2008 11:14 am

This post should have been in "The BETA Files" forum then
We assume all posts in this section are for 1.7.3, until 2.0 (1.9.9.x) goes final

I'm not sure how to edit the SQL for the memberslist addon

by **KaguraS** » Wed May 28, 2008 10:34 pm

Aw sorry I noticed this when Pleeg replied my post in siggen forums, i'm trying to make a solution but no success yet. Ty anyway