MemberList and Profession

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

MemberList and Profession

Postby 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?
Last edited by KaguraS on Tue May 27, 2008 8:52 pm, edited 1 time in total.
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am

MemberList and Profession

Postby 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" );
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

MemberList and Profession

Postby KaguraS » Wed May 28, 2008 6:39 am

hum ty, but i was asking for the roster 1.99, i forget to mention it
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am

MemberList and Profession

Postby 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
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

MemberList and Profession

Postby 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 :)
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron