Item_db parsing problem

[Cusy]

This should be the non-working line in item_db.txt

15037,Pertz_Plate,Pertz Plate,5,20,,3000,,110,,0,0x00000080,8,2,16,,100,1,0,{ bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17; if(isequipped(2476,2575,2884)) { bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus2 bSkillAtk,"RK_SONICWAVE",100; bonus2 bSkillAtk,"RK_WINDCUTTER",100; autobonus "{ sc_start SC_CONCENTRATION,10000,getskilllv(\"LK_CONCENTRATION\") ? getskilllv(\"LK_CONCENTRATION\"):1; bonus bAspd,2; }",1,10000,BF_WEAPON,"{}"; } },{},{}

But even if i comment, remove or edit that line,mapserv-sql.exe still reads the old one. Any suggestion?

[JoWei]

Was that line in pre-RE DB or RE DB?

Also what server mode are you on right now?

If you're using RE then you should modify the one in db/RE folder

else if you're using pre-RE then you should modify the one in db/pre-RE folder

[Cusy]

rAthena\db\re

Even if i remove that file, the error is still the same

[jysn]

your using sql db? check the database on that particular item.

[Cusy]

SELECT * FROM ragnarok.item_db WHERE id=15037;

gave me this result:

'15037', 'Pertz_Plate', 'Pertz Plate', '5', '20', NULL, '3000', NULL, '110', NULL, '0', '128', '8', '2', '16', NULL, '100', '1', '0', 'bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17; if(isequipped(2476,2575,2884)) { bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus2 bSkillAtk,"RK_SONICWAVE",100; bonus2 bSkillAtk,"RK_WINDCUTTER",100; autobonus "{ sc_start SC_CONCENTRATION,10000,(getskilllv("LK_CONCENTRATION"))?getskilllv("LK_CONCENTRATION"):1; bonus bAspd,2; }",1,10000,BF_WEAPON,"{}"; }', NULL, NULL

This is the insert query from item_db.sql:

REPLACE INTO `item_db` VALUES (15037,'Pertz_Plate','Pertz Plate',5,20,NULL,3000,NULL,110,NULL,0,0x00000080,8,2,16,NULL,100,1,0,'bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17; if(isequipped(2476,2575,2884)) { bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus2 bSkillAtk,\"RK_SONICWAVE\",100; bonus2 bSkillAtk,\"RK_WINDCUTTER\",100; autobonus \"{ sc_start SC_CONCENTRATION,10000,(getskilllv(\"LK_CONCENTRATION\"))?getskilllv(\"LK_CONCENTRATION\"):1; bonus bAspd,2; }\",1,10000,BF_WEAPON,\"{}\"; }',NULL,NULL);

[znromonk]

Run this query:

REPLACE INTO `item_db` VALUES (15037, 'Pertz_Plate', 'Pertz Plate', 5, 20, 0, 3000, 0, 110, 0, 0, 0, 8, 2, 16, 0, 100, 1, 0, '{ bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17; if(isequipped(2476,2575,2884)) { bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus2 bSkillAtk,\"RK_SONICWAVE\",100; bonus2 bSkillAtk,\"RK_WINDCUTTER\",100; autobonus \"{ sc_start SC_CONCENTRATION,10000,getskilllv(\"LK_CONCENTRATION\") ? getskilllv(\"LK_CONCENTRATION\"):1; bonus bAspd,2; }\",1,10000,BF_WEAPON,\"{}\"; } }', '{}', '{}');

What's different ? The NULLs are 0 and the last 2 NULLs are parentheses. This is how my db has it and I do not get any errors.

[jysn]

i also encountered this error on that item then i change my sql script base on ratemyserver.

bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17; if(isequipped(2476,2575,2884)){ bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; /* bonus2 bSkillAtk,"RK_SONICWAVE",100; bonus2 bSkillAtk,"RK_WINDCUTTER",100; bonus3 bAutoSpell,"RK_STORMBLAST",1,10; */ bonus bAspd,2; }

[novacrash]

There's another post about this http://rathena.org/board/topic/66035-pertz-plate-itemdb-error/

See my answer there.