Hercules Elf Bot - Jul 27, 2012 23:19
Originally posted by [b]Cusy[/b]
On item_db_re.sql:
[CODE]0 01:03:31 REPLACE INTO `item_db_re` VALUES (1231,'Bazerald','Bazerald',4,20,NULL,500,'70:105',NULL,1,NULL,0x028F5EEE,7,2,2,4,36,1,1,'bonus bAtkEle,Ele_Fire; bonus bInt,5;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:05:00 REPLACE INTO `item_db_re` VALUES (1433,'Imperial_Spear','Imperial Spear',4,20,NULL,1800,'180:50',NULL,3,1,0x00004082,7,2,2,3,102,1,4,'bonus2 bSkillAtk,"LG_CANNONSPEAR",20+getrefine()/2; bonus2 bSkillAtk,"LG_BANISHINGPOINT",20+getrefine()/2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:05:54 REPLACE INTO `item_db_re` VALUES (1472,'Staff_Of_Soul','Soul Staff',4,20,NULL,1400,'25:200',NULL,1,NULL,0x00810204,7,2,34,3,73,1,10,'bonus bInt,5; bonus bAgi,2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:06:43 REPLACE INTO `item_db_re` VALUES (1473,'Wizardy_Staff','Wizardry Staff',4,20,NULL,2400,'120:200',NULL,1,NULL,0x00810204,7,2,34,4,90,1,10,'bonus bInt,6; bonus bDex,2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
[/CODE]
And so on (i've stopped commenting non-working lines after 4 items).
Using MySQL Workbench under Win Server 2008 R2
Using revision 16516
item_db, mob_db_re and mob_skill_db_re works fine.
This post has been edited by
Cusy
on Jul 27, 2012 23:25