I'm a bit stumped here. This happens on more than a few monsters.
CODE
REPLACE INTO `mob_db` VALUES (1942,'TREASURE_BOX45','Treasure Chest','Treasure Chest',99,0,0,0,0,0,0,0,0,0,0,0,0,0,999,0,0,0,0,0,20,0x120,0,0,0,0,0,0,0,0,0,0,0,0
,7834,80,658,500,12999,10000,984,4850,985,7275,1176,150,1734,150,1819,150,0,0,0,0)
DEX is 19th in the list. Its value is 999.
This gives the error:
CODE
Error Code: 1264
Out of range value for column 'DEX' at row 1
And the top of the file clearly states...
[codebox]CREATE TABLE `mob_db` (
...
`STR` tinyint(4) unsigned NOT NULL default '0',
`AGI` tinyint(4) unsigned NOT NULL default '0',
`VIT` tinyint(4) unsigned NOT NULL default '0',
`INT` tinyint(4) unsigned NOT NULL default '0',
`DEX` tinyint(4) unsigned NOT NULL default '0',
`LUK` tinyint(4) unsigned NOT NULL default '0',
...
) ENGINE=MyISAM[/codebox]
If a tinyint does not support 999, does this mean I have to change the sql file? I don't understand what's going on here. Is there something I have to change? I'm clueless because there are no current guides on how to make a sql server. (IMG:
style_emoticons/default/sleep.gif)
.