Recently installed the guildvault addon to wowroster v1.7.3, and for some reason we keep getting the error..

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\wwwroot\conclave\guild\roster\addons\guildvault\includes\functions.lib.php on line 800

Not sure what the problem may be, but the updates are working fine. The only thing we appear to be mising is the icons for the empty bank slots.

Ok i looked at the file functions.lib.php.

You have set to stack the items, correct?

The error is that the addon looks for all data in the actual tab and for the actual item. And it seems that for one or more items the sql query returned an empty result.

Try to replace:

Code: Select all

                    
while ($data1 = mysql_fetch_array($result1)) 
{
        $item_count = $item_count + $data1['item_quantity'];
}
 

with:

Code: Select all

if ($result1 = $wowdb->query($sql1))
{
    while ($data1 = mysql_fetch_array($result1)) 
    {
        $item_count = $item_count + $data1['item_quantity'];
    }
}
 

You find this code in the "functions.lib.php" near line 800.
Please report if this solved the error.

In the downloaded archive there should be 2 image files: "No_Icon.gif" and "No_Icon.jpg". These files must me copied to the /img/Interface/Icons Folder.

If the error is still there, please post your roster adress and if possible activate Roster Debug Mode (so i can take a look at the sql queries).

Nefuh

It worked, everything is going now. Thanks for the speedy reply and keep up the good work

Thanks

I will add this fix to the downloadable version.

Nefuh