The lueparser file has seemed to fix my problems thanks for all the hard work.

Thank you for your hard work! I just tried the new lueparser file and everything is working!

Bondo wrote:thank you for working so hard on fixking this problem mate, really appreciated.

The title seems fixed. I now just got this error:

Quest [n] could not be inserted
1062: Duplicate entry '28-n' for key 1

I think I fixed this issue in my roster by replacing

else if($value == 'nil')
{
$value = NULL;
}
$stack[$stack_pos][1][$name] = $value;

with

else if($value == 'nil')
{
$value = NULL;
}
else if($value == 'nil, ')
{
continue;
}
$stack[$stack_pos][1][$name] = $value;

worked like a charm! Thank you!

I have abit of a problem, i have overwrite the file u have poste, and now i dont get any arrow when i upload the lua file.

All data is upload, but for some resson it make a empthy space in my Quest log, and the same in the Bank.

U can see it Here

I have just check my Quest log in the Game, and there is only 5 quest under Blackrock spire, so dont know why it make that empthy space.

Have the new GP and CP 2.0.4 or what it call

Found another problem
MY CT profiler is 2.0.4

Code: Select all

}, -- [11]
                     {
                        ["Item"] = "16696:0:0:0:0:0:0:0",
                        ["Color"] = "0070dd",
                        ["Tooltip"] = "Devout Belt<br>Binds when equipped<br>Waist   Cloth<br>46 Armor<br>+4 Stamina<br>+20 Intellect<br>+9 Spirit<br>Durability 30 / 30<br>Requires Level 53<br> <br><br>Vestments of the Devout (0/8)<br>  Devout Belt<br>  Devout Sandals<br>  Devout Bracers<br>  Devout Crown<br>  Devout Gloves<br>  Devout Mantle<br>  Devout Skirt<br>  Devout Robe<br> <br><br>(2) Set: +200 Armor.<br>(4) Set: Increases damage and healing done by magical spells and effects by up to 23.<br>(6) Set: When struck in combat has a chance of shielding the wearer in a protective shield which will absorb 350 damage.<br>(8) Set: +8 All Resistances.",
                        ["Icon"] = "INV_Belt_10",
                        ["Name"] = "Devout Belt",
                     }, -- [12]
                     nil, -- [13]
                     {
                        ["Item"] = "13009:0:0:0:0:0:0:0",
                        ["Color"] = "0070dd",
                        ["Tooltip"] = "Cow King's Hide<br>Binds when equipped<br>Chest   Leather<br>148 Armor<br>+10 Stamina<br>+10 Arcane Resistance<br>+10 Fire Resistance<br>+10 Nature Resistance<br>+10 Frost Resistance<br>+10 Shadow Resistance<br>Durability 100 / 100<br>Requires Level 46",
                        ["Icon"] = "INV_Chest_Leather_06",
                        ["Name"] = "Cow King's Hide",
                     }, -- [14]


see that nill between [12] and [13] ?

it translates into

Code: Select all

INSERT INTO `roster_items` SET `member_id` = '28', `item_name` = 'Devout Belt', `item_parent` = 'Bag2', `item_slot` = '12', `item_color` = '0070dd', `item_id` = '16696:0:0:0:0:0:0:0', `item_texture` = 'Interface/Icons/INV_Belt_10', `item_tooltip` = 'Devout Belt\nBinds when equipped\nWaist Cloth\n46 Armor\n+4 Stamina\n+20 Intellect\n+9 Spirit\nDurability 30 / 30\nRequires Level 53\n \n\nVestments of the Devout (0/8)\n Devout Belt\n Devout Sandals\n Devout Bracers\n Devout Crown\n Devout Gloves\n Devout Mantle\n Devout Skirt\n Devout Robe\n \n\n(2) Set: +200 Armor.\n(4) Set: Increases damage and healing done by magical spells and effects by up to 23.\n(6) Set: When struck in combat has a chance of shielding the wearer in a protective shield which will absorb 350 damage.\n(8) Set: +8 All Resistances.', `level` = '53', `item_quantity` = '1'
INSERT INTO `roster_items` SET `member_id` = '28', `item_name` = 'n', `item_parent` = 'Bag2', `item_slot` = '13', `item_color` = 'n', `item_id` = 'n', `item_texture` = 'Interface/Icons/n', `item_tooltip` = 'n', `item_quantity` = 'n'
INSERT INTO `roster_items` SET `member_id` = '28', `item_name` = 'Cow King\'s Hide', `item_parent` = 'Bag2', `item_slot` = '14', `item_color` = '0070dd', `item_id` = '13009:0:0:0:0:0:0:0', `item_texture` = 'Interface/Icons/INV_Chest_Leather_06', `item_tooltip` = 'Cow King\'s Hide\nBinds when equipped\nChest Leather\n148 Armor\n+10 Stamina\n+10 Arcane Resistance\n+10 Fire Resistance\n+10 Nature Resistance\n+10 Frost Resistance\n+10 Shadow Resistance\nDurability 100 / 100\nRequires Level 46', `level` = '46', `item_quantity` = '1'

It Inserts an item with the name "n"

The insertion of an item with the name "n" when there is an empty slot in a bag ( nil, in lua file ) was solve for me after the above mentioned fix of the luaparser.php file you can download from this thread.

This is what I did :
1. download new luaparser.php from this thread,
2. Change this file on line 144 :

Code: Select all

else if($value == 'nil')
{
$value = NULL;
}
$stack[$stack_pos][1][$name] = $value;

by

Code: Select all

else if($value == 'nil')
{
$value = NULL;
}
else if($value == 'nil, ')
{
continue;
}
$stack[$stack_pos][1][$name] = $value;

3. Copied the new luaparser.php file to roster/lib dir.

If you then upload the CT profiler is 2.0.4 .lua file to the roster the items with name 'n' are no longer there.

This also solves the :
Notice: Undefined offset: 1 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247
problem of the guildbank addon as it is caused by the items with name 'n' in the db.

[PUPPETS]Gonzo wrote:

Bondo wrote:thank you for working so hard on fixking this problem mate, really appreciated.

The title seems fixed. I now just got this error:

Quest [n] could not be inserted
1062: Duplicate entry '28-n' for key 1

I think I fixed this issue in my roster by replacing

else if($value == 'nil')
{
$value = NULL;
}
$stack[$stack_pos][1][$name] = $value;

with

else if($value == 'nil')
{
$value = NULL;
}
else if($value == 'nil, ')
{
continue;
}
$stack[$stack_pos][1][$name] = $value;

I've realized about this problem. This is not the correct fix; it will be along later.

Uploaded a new version that should fix the incorrect parsing of nil values. Basically I forgot to trim some stuff at the end of the line.

it woks fine! thank you again

Finally I got it working fine with this new version

thanks

The update error in the quest data popped up for me now. It is caused by a change in the SV syntax that I hadn't run into yet.

I've fixed it in wowdb, but I won't offer that for download here. The update should go fine despite the error. Hopefully we'll push a 1.7.3 beta this weekend which will also contain some cosmetic fixes.

PleegWat wrote:

[PUPPETS]Gonzo wrote:[stuff]

I've realized about this problem. This is not the correct fix; it will be along later.

Uhm, *blush*

Thanks for fixing!

Thx that work

Hi !

I've still got a problem with the new lua file.
This problem is

Code: Select all

Quest [] could not be inserted
1062: Duplicate entry '17-' for key 1

And it looks like I have a nameless quest :\

I tried the hack from [PUPPETS]Gozzo, but no luck so far.

Any Idea or a link to a post I missed ?