Nice idea actually. only one small problem my experience in writing wow addons is close to zero.

just that i dont forget it:

Doesnt take care of multi-guild-realm and stuff
gonna need to check how to implement this

Very useful addon to roster thx :-)

I am uploading to roster from multiple guilds and the report Witch Hunt produces is difficult to use because all the guilds are shown in the one list. Could you possible add a feature that would enable either the guilds to be accessed separately or split the report into individual guilds?

Thx so much :-)
Pip

asuming you are talking about the roster2 version

see this thread
http://www.wowroster.net/Forums/viewtopic/t=4398.html

filter by guild planned for next version

Can witch hunt also TRACK people that upload only "part" of CP information ?

Something like ..

-you don't have uploaded bags/bank
-you don't have uploaded spellbook/quests
-you don't have uploaded recipes
etc...

Can track "armory" update from a complete CP update...

interesting idea.
just not sure what to check exaclty for
how do you now that char didnt upload bags? recipies? or update?

any roster guru got an idea?

On roster 2.0 by using the function char() in update_hook.php, then you can get all the information from cp.lua and look if there are data or not. I think roster always uploaded all stuff, you can only disable the viewing. Hope that is right?

So there´s no Bag, Bank, Spellbook... updatet for a char, there should be no data for this in cp.lua.

Just an Idea

Nefuh

Carasak wrote:how do you now that char didnt upload bags? recipies? or update?

Well, when you have a member_id from the members table, a SQL like this:

SELECT * FROM `roster_quests` WHERE member_id = look_for_id

will do the job.
If this statement yields results, then member_id has quests in the quests table for the member you're looking for :look_for_id, means a good upload.
Members without any quest do exists, but its must be a rare thing.

This goes for any table : quests, reputations, recipes, etc.
The pets table could be scanned, if you knoiw what char could have them ^^

For items, you should search in the item table.
Have a %partiel%lookup in the item_parrent colum.
'equip' means equiped,
'Bag' means 'item in a bag',
'Bank Bag' means 'items are in a bag.

Something like that

Code: Select all

  $query = "SELECT `p`.`name`, `m`.`guild_title`"
         . " FROM `".$roster->db->table('players')."` AS p, `".$roster->db->table('members')."` AS m"
         . " WHERE `p`.`guild_id` = '1' AND `p`.`member_id` = `m`.`member_id` AND `p`.`name` NOT IN"
         . " ( SELECT DISTINCT `p`.`name` FROM `".$roster->db->table('players')."` AS p, `".$roster->db->table('recipes')."` AS r"
         . " WHERE `p`.`member_id` = `r`.`member_id`"
         . ") ORDER BY `name`";

Change recipes to another table.. like spellbook, talents, reputations, skill, quest, etc..

Code: Select all

  $query = "SELECT `p`.`name`, `m`.`guild_title`"
         . " FROM `".$roster->db->table('players')."` AS p, `".$roster->db->table('members')."` AS m"
         . " WHERE `p`.`guild_id` = '1' AND `p`.`member_id` = `m`.`member_id` AND `p`.`name` NOT IN"
         . " ( SELECT DISTINCT `p`.`name` FROM `".$roster->db->table('players')."` AS p, `".$roster->db->table('items')."` AS i"
         . " WHERE `p`.`member_id` = `i`.`member_id`"
         . " AND `i`.`item_parent` LIKE 'Bank%'"
         . ") ORDER BY `guild_title`";

Change Bank to Bag to get the rest..

Carasak wrote:

ds001 wrote:I like the mod nice job!
One suggestion/request. Please make a define in the config file to that allows viewing of the mod if not logged in as Admin. I want all my guild members to see who is a slacker or not.

done

released v1.1.1

Is it in the V2 also?? Cause I wanted to let my Officers be able to use witchunt also but only comes up while in admin and can't seem to find where the setting is to allow others.

in the CP panel for witch hunt is a option Admin only yes/no


the addon is still beta since i didnt come arround to update it for the roster2. release..so thre might be incompatiblities.

Yup that was it worked fine ,, thank you

Awesome mod. Feature request: Can it adjust for the timezone? My roster is setup of for -4, but Witch Hunt is showing GMT. Ideally, it could grab it from the main roster setting. TIA

yes that time thing is still buggy...scheduled for release version

Good deal and good work. Thanks a lot!