Guildbank and Categorized_Guildbank problem with recipes

Addons for WoWRosterDF

Guildbank and Categorized_Guildbank problem with recipes

Postby Theophilius » Tue Mar 06, 2007 5:44 pm

Hi all,

Sorry to disturb if this has already been resolved but I haven't find anything on this.

Guildbank (former roster code) seems to have a problem with the recipes generating objects bind when used (not equiped neither soulbound)... not sure of the english, i'm playing with a french client of the game (here we have : "lié", "lié quand équipé" et "lié quand utilisé").

Those recipes are not displayed because of a test in the sql taking only the bind when equiped objects as a valid result for the guildbank.

I've done a workaround consisting on duplicating the boe line in the localization file and replacing boe by bou and the boe text by the correct bind when used text first

For frFR.php (in woWrosterDF/localization):
$wordings['frFR']['tooltip_soulbound']='Lié';
$wordings['frFR']['tooltip_boe']='Lié quand équipé';
$wordings['frFR']['tooltip_bou']='Lié quand utilisé';
$wordings['frFR']['tooltip_equip']='Equipé';


AND adding a test to the sql request in guildbank.php and guildbank2.php (both of them are used ?).

In guildbank.php and guildbank2.php (in WoWrosterDF, 2 replacements for the 1st and 1 for the 2nd) :

AND (i.item_tooltip
NOT LIKE '%".$wordings[$roster_conf['roster_lang']]['tooltip_soulbound']."%'
OR i.item_tooltip
LIKE '%".$wordings[$roster_conf['roster_lang']]['tooltip_boe']."%'
GROUP BY i.item_name";


by

AND (i.item_tooltip
NOT LIKE '%".$wordings[$roster_conf['roster_lang']]['tooltip_soulbound']."%'
OR i.item_tooltip
LIKE '%".$wordings[$roster_conf['roster_lang']]['tooltip_boe']."%'
OR i.item_tooltip
LIKE '%".$wordings[$roster_conf['roster_lang']]['tooltip_bou']."%')
GROUP BY i.item_name";


As the same issue is existing with Categorized_Guildbank you need to edit the gbank.php file to add the bou part of the test.

The categorized guildbank addon seems to have a problem with enchantment recipes (maybe others too). Those are not put in the Enchantment recipes cat but in the generated objet cat.

Hope this is understandable :D

Thanks a lot for your help.
User avatar
Theophilius
WR.net Apprentice
WR.net Apprentice
 
Posts: 28
Joined: Sat Feb 24, 2007 4:49 pm

Guildbank and Categorized_Guildbank problem with recipes

Postby tuigii » Tue Mar 06, 2007 6:29 pm

This subject is already being discussed here :
http://www.wowroster.net/Forums/viewtop ... html#16078
In this thread : [V1.0.4] Guildbank Request Mod
In this forum : Index › 3rd-party AddOns and Mods › Categorized Guild Bank

Check your findings with mine ..... :thumright:
Last edited by tuigii on Tue Mar 06, 2007 6:29 pm, edited 1 time 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

Re: Guildbank and Categorized_Guildbank problem with recipes

Postby Theophilius » Tue Mar 06, 2007 6:43 pm

Wooooooups... :oops:

hu hummm... Thanks tuigii, going to have a look there.
User avatar
Theophilius
WR.net Apprentice
WR.net Apprentice
 
Posts: 28
Joined: Sat Feb 24, 2007 4:49 pm


Return to WoWRosterDF Addons

Who is online

Users browsing this forum: No registered users and 1 guest

cron