Duplicates in "Made By" Area STILL showing up....

Guild listing of known recipes

Moderator: ds

Duplicates in "Made By" Area STILL showing up....

Postby Mithan » Wed Aug 16, 2006 2:43 am

As I posted last week here:
http://www.wowroster.net/Forums/viewtopic/t=598/

I have a problem with duplicate formula's showing up in the Raid by section.

Yesterday, I totally nuked my Roster and re-installed it and forced people to upload new data. The min CP version is set to 1.5.4a.

I am still getting the problem...

Any other tips?
Last edited by Mithan on Wed Aug 16, 2006 3:00 am, edited 1 time in total.
Mithan
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Wed Jul 05, 2006 7:58 am

Duplicates in "Made By" Area STILL showing up....

Postby zanix » Wed Aug 16, 2006 3:19 am

There are certain items that even though they are the same, they have different item_id's, and this means that they are technically different items and it picks this up

This is a dead roster addon, meaning that no one updates it anymore
If someone want to take over it, they are more than welcome to
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

Re: Duplicates in "Made By" Area STILL showing up....

Postby XanDer » Thu Oct 26, 2006 2:48 pm

zanix wrote:There are certain items that even though they are the same, they have different item_id's, and this means that they are technically different items and it picks this up


Yes.. it's right.
There are technically different recipes.
The only field different is the tooltip info (the cooldown info for differents alchemists).
The request also searches distinct item including the tooltip.
If there are 3 differents cooldown, you will see 3 times the same recipe.

The only thing I find is to filter the makers in order to display for which maker correspond this recipe with this cooldown.

To do that:

Find in "addon\recipe\RecipeList.php" l.149

Code: Select all
$qry_users = "select m.name, r.difficulty, s.skill_level ".
  "from ".ROSTER_MEMBERSTABLE." m, ".ROSTER_RECIPESTABLE." r, ".ROSTER_SKILLSTABLE." s ".
  "where r.member_id = m.member_id and r.member_id = s.member_id and r.skill_name = s.skill_name ".
  "and recipe_name = '".addslashes($recipe->data['recipe_name'])."' order by m.name";


Replace by

Code: Select all
$qry_users = "select m.name, r.difficulty, s.skill_level ".
   "from ".ROSTER_MEMBERSTABLE." m, ".ROSTER_RECIPESTABLE." r, ".ROSTER_SKILLSTABLE." s ".
   "where r.member_id = m.member_id and r.member_id = s.member_id and r.skill_name = s.skill_name ".
   "and recipe_name = '".addslashes($recipe->data['recipe_name'])."' and recipe_tooltip = '".addslashes($recipe->data['recipe_tooltip'])."' order by m.name";


I know, it's not the best way...
But with this fix, there is a good raison to have multiple times the same recipe :)

For me a better way is not to select distinct tooltip, but I don't find how to do that keeping all infos.

zanix wrote:This is a dead roster addon, meaning that no one updates it anymore
If someone want to take over it, they are more than welcome to


I agree with you.
It's really too bad that's a dead roster addon.
I think it's by the way a terrible addon for people who want see what is craftable in the guild.
XanDer
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Sat Sep 02, 2006 8:13 pm

Re: Duplicates in "Made By" Area STILL showing up....

Postby iradu » Thu Oct 26, 2006 10:12 pm

I would like to take over this addon. In fact I made something like this, but when I tried to upload my addon I saw this addon which is better than mine

http://roster.theorderofazeroth.com/add ... =allrecipe
iradu
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Mon Aug 28, 2006 1:07 pm


Return to Made By

Who is online

Users browsing this forum: No registered users and 0 guests

cron