07-24-2010, 09:48 PM
[Err] 1054 - Unknown column 'device' in 'field list'
[Err] INSERT INTO `npcAIData` VALUES
делаю изменения тут
(18775,15,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,'device',900,900,NULL,NULL,'balanced'),
структура таблицы
[Err] INSERT INTO `npcAIData` VALUES
делаю изменения тут
(18775,15,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,'device',900,900,NULL,NULL,'balanced'),
структура таблицы
PHP код:
<?php
DROP TABLE IF EXISTS `npcAIData`;
CREATE TABLE `npcAIData` (
`npc_id` int(5) NOT NULL DEFAULT '0',
`skill_chance` int(3) DEFAULT NULL,
`primary_attack` int(1) DEFAULT NULL,
`canMove` int(1) DEFAULT NULL,
`minrangeskill` int(5) DEFAULT NULL,
`minrangechance` int(3) DEFAULT NULL,
`maxrangeskill` int(5) DEFAULT NULL,
`maxrangechance` int(3) DEFAULT NULL,
`soulshot` int(4) DEFAULT '0',
`spiritshot` int(4) DEFAULT '0',
`spschance` int(3) DEFAULT '0',
`sschance` int(3) DEFAULT '0',
`ischaos` int(4) DEFAULT NULL,
`clan` varchar(41) DEFAULT NULL,
`clan_range` int(4) DEFAULT NULL,
`enemyRange` int(4) DEFAULT NULL,
`enemyClan` varchar(40) DEFAULT NULL,
`dodge` int(3) DEFAULT NULL,
`ai_type` varchar(8) DEFAULT 'fighter',
PRIMARY KEY (`npc_id`)