Not displaying keys...

by **shan_aya** » Mon Oct 02, 2006 11:17 pm

oki,
file 973 have right keys fonction but bonuses equipments error

file 521 have wrong key fonction but right bonus

if this help somenone ^^

by **RainRider** » Thu Oct 19, 2006 1:26 am

Still no solution for this? (the patch from Zanix does not work for me)

by **sdwwraith** » Wed Nov 15, 2006 5:16 am

If you've implemented the other fix, you also need to find:

Code: Select all: $items = $inst_keys[$row['clientLocale']][$faction];

And change it to:

Code: Select all: $items = $inst_keys[$row['clientLocale']][ substr($faction,0,1) ];

Worked for me anyway.

by **Finwe** » Mon Nov 27, 2006 7:54 pm

Grobsnelf wrote:My "Keys" were breaking as well, when it reached the only player in the guild with a German WoW.

Tried manually doing the changes - but now it breaks before even showing on player with:

invalid argument supplied for foreach() in /home/subscrib/public_html/guild-succession.com/roster/membersinst.php on line 183

Tried downloading and applying the files in the zip file - and still the same result.

The error is also accompanied by the following Database Error:

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY members.name' at line 1
SQL:
SELECT members.name FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '92' AND () GROUP BY members.name
File: membersinst.php
Line: 206

If you use, like me, roster for your own characters, don't forget to complete in your database roster_guild.faction (Alliance or horde).
The first letter of $faction variable is use in the line that follow :
$items = $inst_keys[$row['clientLocale']][ substr($faction,0,1) ];

This corrected the mistake you describe for me.