Help needed with setting up Rooster seach

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

Help needed with setting up Rooster seach

Postby joms » Mon Jul 16, 2007 2:57 am

Is there a way that i can disabel the option Items, when the members seach for a word.

When we curently search for the word "Mana" it will pop up with all the potions that the players are running round with in there bag's and we more need it for looking after recepis.

I have disabeld the option that is called show bags and bank's.

Thx in advance
joms
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Aug 02, 2006 1:11 pm

Help needed with setting up Rooster seach

Postby zanix » Mon Jul 16, 2007 3:38 am

Moved
Before you make a post, read the Forum Rules

The options show bags and show bank are display options only, the items are still uploaded to roster

If you are looking for a recipe search, I suggest using the Made By Roster 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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Help needed with setting up Rooster seach

Postby tuigii » Mon Jul 16, 2007 3:57 pm

joms wrote:I have disabeld the option that is called show bags and bank's.

Is there a way that i can disabel the option Items, when the members seach for a word.


Yes.
When you don't want that one can search in sacs of members, when their sac isn't shown, then there is a possibility.
What I use is this:
Players options => sacs = set to "user".
For every player (in the individual player table) that doesn't want his sac to be searched, I put the sac option to 'off'.
For others, wo don't care, I put it 'on'.

Open search.php and goto line 68
Change
Code: Select all
$query="SELECT players.name,players.server,items.* FROM `".ROSTER_ITEMSTABLE."` items,`".ROSTER_PLAYERSTABLE."` players WHERE items.member_id = players.member_id AND items.item_name LIKE '%$search%' ORDER BY players.name ASC"


and change it for

Code: Select all
$query="SELECT players.name,players.server,members.bg,items.* FROM `".ROSTER_ITEMSTABLE."` items,`".ROSTER_PLAYERSTABLE."` players, `".ROSTER_MEMBERSTABLE."` members WHERE items.member_id = players.member_id AND  members.member_id = players.member_id AND members.bg = '1' AND items.item_name LIKE '%$search%' ORDER BY players.name ASC"


What happens here :
The members table is included, and when the 'bg' (bag) is set to '1' - searching is permitted.
'3' means NO.

This all means that players who can see their sacs can also have theire sacs being searched. And only them.
Last edited by tuigii on Thu Oct 11, 2007 5:00 pm, edited 3 times in total.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron