Query start
[ERR] 1050 - Table 'temporaryobjecttable' already exists
[ERR]
CREATE TABLE `skill_trees` (
`class_id` int(10) unsigned NOT NULL DEFAULT '0',
`skill_id` int(10) unsigned NOT NULL DEFAULT '0',
`level` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`sp` int(10) unsigned NOT NULL DEFAULT '0',
`min_level` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`class_id`,`skill_id`,`level`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `spawnlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`location` varchar(40) NOT NULL DEFAULT '',
`count` int(11) NOT NULL DEFAULT '0',
`npc_templateid` int(11) NOT NULL DEFAULT '0',
`locx` int(11) NOT NULL DEFAULT '0',
`locy` int(11) NOT NULL DEFAULT '0',
`locz` int(11) NOT NULL DEFAULT '0',
`randomx` int(11) NOT NULL DEFAULT '0',
`randomy` int(11) NOT NULL DEFAULT '0',
`heading` int(11) NOT NULL DEFAULT '0',
`respawn_delay` int(11) NOT NULL DEFAULT '0',
`loc_id` int(11) NOT NULL DEFAULT '0',
`periodOfDay` decimal(2,0) DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
KEY `key_npc_templateid` (`npc_templateid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10075728 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `teleport` (
`Description` varchar(75) DEFAULT NULL,
`id` decimal(11,0) NOT NULL DEFAULT '0',
`loc_x` decimal(9,0) DEFAULT NULL,
`loc_y` decimal(9,0) DEFAULT NULL,
`loc_z` decimal(9,0) DEFAULT NULL,
`price` decimal(6,0) DEFAULT NULL,
`fornoble` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `temporaryObjectTable` (
`object_id` int(11) NOT NULL,
PRIMARY KEY (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `temporaryobjecttable` (
`object_id` int(11) NOT NULL,
PRIMARY KEY (`object_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
CREATE TABLE `temporaryobjecttable_copy1` (
`object_id` int(11) NOT NULL,
PRIMARY KEY (`object_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
CREATE TABLE `topclan_lastrewards` (
`date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`clan` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
CREATE TABLE `topclan_points` (
`clan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`points` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
CREATE TABLE `topic` (
`topic_id` int(11) NOT NULL DEFAULT '0',
`topic_forum_id` int(11) NOT NULL DEFAULT '0',
`topic_name` varchar(255) NOT NULL DEFAULT '',
`topic_date` decimal(20,0) NOT NULL DEFAULT '0',
`topic_ownername` varchar(255) NOT NULL DEFAULT '0',
`topic_ownerid` int(11) NOT NULL DEFAULT '0',
`topic_type` int(11) NOT NULL DEFAULT '0',
`topic_reply` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `unitpay_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`unitpayId` varchar(255) NOT NULL,
`account` varchar(255) NOT NULL,
`sum` float NOT NULL,
`itemsCount` int(11) NOT NULL DEFAULT '1',
`dateCreate` datetime NOT NULL,
`dateComplete` datetime DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
CREATE TABLE `walker_routes` (
`route_id` int(11) NOT NULL DEFAULT '0',
`npc_id` int(11) NOT NULL DEFAULT '0',
`move_point` int(11) NOT NULL,
`chatText` varchar(255) DEFAULT NULL,
`move_x` int(11) NOT NULL DEFAULT '0',
`move_y` int(11) NOT NULL DEFAULT '0',
`move_z` int(11) NOT NULL DEFAULT '0',
`delay` int(11) NOT NULL DEFAULT '0',
`running` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`route_id`,`npc_id`,`move_point`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `weapon` (
`item_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(70) NOT NULL DEFAULT '',
`bodypart` enum('hatchling','lhand','lrhand','rhand','strider','wolf') NOT NULL,
`cryst
[ERR] 1146 - Table 'x50.temporaryobjecttable_copy1' doesn't exist
[ERR]
INSERT INTO `x50`.`skill_trees` (`class_id`,`skill_id`,`level`,`name`,`sp`,`min_level`) VALUES (0, 3, 1, 'Power Strike', 50, 5),(0, 3, 2, 'Power Strike', 50, 5),(0, 3, 3, 'Power Strike', 50, 5),(0, 3, 4, 'Power Strike', 370, 10),(0, 3, 5, 'Power Strike', 370, 10),(0, 3, 6, 'Power Strike', 370, 10),(0, 3, 7, 'Power Strike', 1300, 15),(0, 3, 8, 'Power Strike', 1300, 15),(0, 3, 9, 'Power Strike', 1300, 15),(0, 16, 1, 'Mortal Blow', 50, 5),(0, 16, 2, 'Mortal Blow', 50, 5),(0, 16, 3, 'Mortal Blow', 50, 5),(0, 16, 4, 'Mortal Blow', 370, 10),(0, 16, 5, 'Mortal Blow', 370, 10),(0, 16, 6, 'Mortal Blow', 370, 10),(0, 16, 7, 'Mortal Blow', 1300, 15),(0, 16, 8, 'Mortal Blow', 1300, 15),(0, 16, 9, 'Mortal Blow', 1300, 15),(0, 56, 1, 'Power Shot', 50, 5),(0, 56, 2, 'Power Shot', 50, 5),(0, 56, 3, 'Power Shot', 50, 5),(0, 56, 4, 'Power Shot', 370, 10),(0, 56, 5, 'Power Shot', 370, 10),(0, 56, 6, 'Power Shot', 370, 10),(0, 56, 7, 'Power Shot', 1300, 15),(0, 56, 8, 'Power Shot', 1300, 15),(0, 56, 9, 'Power Shot', 1300, 15),(0, 141, 1, 'Weapon Mastery', 160, 5),(0, 141, 2, 'Weapon Mastery', 1100, 10),(0, 141, 3, 'Weapon Mastery', 4000, 15),(0, 142, 1, 'Armor Mastery', 160, 5),(0, 142, 2, 'Armor Mastery', 550, 10),(0, 142, 3, 'Armor Mastery', 550, 10),(0, 142, 4, 'Armor Mastery', 2000, 15),(0, 142, 5, 'Armor Mastery', 2000, 15),(0, 226, 1, 'Relax', 160, 5),(1, 75, 1, 'Detect Insect Weakness', 18000, 32),(1, 78, 1, 'War Cry', 3700, 20),(1, 100, 1, 'Stun Attack', 1200, 20),(1, 100, 2, 'Stun Attack', 1200, 20),(1, 100, 3, 'Stun Attack', 1200, 20),(1, 100, 4, 'Stun Attack', 2100, 24),(1, 100, 5, 'Stun Attack', 2100, 24),(1, 100, 6, 'Stun Attack', 2100, 24),(1, 100, 7, 'Stun Attack', 4000, 28),(1, 100, 8, 'Stun Attack', 4000, 28),(1, 100, 9, 'Stun Attack', 4000, 28),(1, 100, 10, 'Stun Attack', 6100, 32),(1, 100, 11, 'Stun Attack', 6100, 32),(1, 100, 12, 'Stun Attack', 6100, 32),(1, 100, 13, 'Stun Attack', 10000, 36),(1, 100, 14, 'Stun Attack', 10000, 36),(1, 100, 15, 'Stun Attack', 10000, 36),(1, 121, 1, 'Battle Roar', 12000, 28),(1, 148, 1, 'Vital Force', 6400, 24),(1, 148, 2, 'Vital Force', 18000, 32),(1, 211, 1, 'Boost HP', 3700, 20),(1, 211, 2, 'Boost HP', 12000, 28),(1, 211, 3, 'Boost HP', 31000, 36),(1, 212, 1, 'Fast HP Recovery', 6400, 24),(1, 212, 2, 'Fast HP Recovery', 18000, 32),(1, 216, 1, 'Polearm Mastery', 3700, 20),(1, 216, 2, 'Polearm Mastery', 6400, 24),(1, 216, 3, 'Polearm Mastery', 6000, 28),(1, 216, 4, 'Polearm Mastery', 6000, 28),(1, 216, 5, 'Polearm Mastery', 9100, 32),(1, 216, 6, 'Polearm Mastery', 9100, 32),(1, 216, 7, 'Polearm Mastery', 16000, 36),(1, 216, 8, 'Polearm Mastery', 16000, 36),(1, 227, 1, 'Light Armor Mastery', 1900, 20),(1, 227, 2, 'Light Armor Mastery', 1900, 20),(1, 227, 3, 'Light Armor Mastery', 3200, 24),(1, 227, 4, 'Light Armor Mastery', 3200, 24),(1, 227, 5, 'Light Armor Mastery', 4000, 28),(1, 227, 6, 'Light Armor Mastery', 4000, 28),(1, 227, 7, 'Light Armor Mastery', 4000, 28),(1, 227, 8, 'Light Armor Mastery', 6100, 32),(1, 227, 9, 'Light Armor Mastery', 6100, 32),(1, 227, 10, 'Light Armor Mastery', 6100, 32),(1, 227, 11, 'Light Armor Mastery', 10000, 36),(1, 227, 12, 'Light Armor Mastery', 10000, 36),(1, 227, 13, 'Light Armor Mastery', 10000, 36),(1, 231, 1, 'Heavy Armor Mastery', 1900, 20),(1, 231, 2, 'Heavy Armor Mastery', 1900, 20),(1, 231, 3, 'Heavy Armor Mastery', 3200, 24),(1, 231, 4, 'Heavy Armor Mastery', 3200, 24),(1, 231, 5, 'Heavy Armor Mastery', 4000, 28),(1, 231, 6, 'Heavy Armor Mastery', 4000, 28),(1, 231, 7, 'Heavy Armor Mastery', 4000, 28),(1, 231, 8, 'Heavy Armor Mastery', 6100, 32),(1, 231, 9, 'Heavy Armor Mastery', 6100, 32),(1, 231, 10, 'Heavy Armor Mastery', 6100, 32),(1, 231, 11, 'Heavy Armor Mastery', 10000, 36),(1, 231, 12, 'Heavy Armor Mastery', 10000, 36),(1, 231, 13, 'Heavy Armor Mastery', 10000, 36),(1, 245, 1, 'Wild Sweep', 1200, 20),(1, 245, 2, 'Wild Sweep', 1200, 20),(1, 245, 3, 'Wild Sweep', 1200, 20),(1, 245, 4, 'Wild Sweep', 2100, 24),(1, 245, 5, 'Wild Sweep', 2100, 24),(1, 245, 6, 'Wild Sweep', 2100, 24),(1, 245, 7, 'Wild Sweep', 4000, 28),(1, 245, 8, 'Wild
[ERR] 1146 - Table 'x50.z_queued_items' doesn't exist
[ERR]
INSERT INTO `x50`.`z_queued_items` (`id`,`char_id`,`name`,`date`,`item_id`,`item_count`,`item_ench`,`aug_id`,`aug_lvl`,`status`) VALUES (1, '268474678', 'Unitpay', '2016-07-03 02:58:38', 14504, 3, 0, 0, 0, 1),(2, '268473802', 'Unitpay', '2016-07-03 03:11:04', 14504, 1, 0, 0, 0, 1),(3, '268472153', 'Unitpay', '2016-07-03 05:14:43', 14504, 1, 0, 0, 0, 1),(4, '268475692', 'Unitpay', '2016-07-03 06:28:24', 14504, 3, 0, 0, 0, 1),(5, '268472252', 'Колесо Удачи', '2016-07-03 09:53:09', 14500, 2000, 0, 0, 0, 1),(6, '268473802', 'Колесо Удачи', '2016-07-03 12:17:19', 14503, 3, 0, 0, 0, 1),(7, '268473802', 'Колесо Удачи', '2016-07-03 12:17:32', 14513, 1, 0, 0, 0, 1),(8, '268473802', 'Колесо Удачи', '2016-07-03 12:17:46', 14500, 1000, 0, 0, 0, 1),(9, '268472004', 'Колесо Удачи', '2016-07-03 12:20:37', 14501, 10, 0, 0, 0, 1),(10, '268513926', 'Колесо Удачи', '2016-07-03 18:29:36', 14501, 10, 0, 0, 0, 1),(11, '268513926', 'Колесо Удачи', '2016-07-03 18:29:48', 14501, 25, 0, 0, 0, 1),(12, '268513926', 'Колесо Удачи', '2016-07-03 18:30:01', 14503, 1, 0, 0, 0, 1),(13, '268513926', 'Колесо Удачи', '2016-07-03 18:30:13', 14500, 25000, 0, 0, 0, 1),(14, '268513926', 'Колесо Удачи', '2016-07-03 18:30:25', 14500, 1000, 0, 0, 0, 1),(15, '268513926', 'Колесо Удачи', '2016-07-03 18:30:38', 14513, 1, 0, 0, 0, 1),(16, '268513926', 'Колесо Удачи', '2016-07-03 18:30:49', 14501, 50, 0, 0, 0, 1),(17, '268513926', 'Колесо Удачи', '2016-07-03 18:31:01', 14502, 1, 0, 0, 0, 1),(18, '268513926', 'Колесо Удачи', '2016-07-03 18:31:13', 14509, 100, 0, 0, 0, 1),(19, '268513926', 'Колесо Удачи', '2016-07-03 18:31:25', 14500, 1000, 0, 0, 0, 1),(20, '268513926', 'Колесо Удачи', '2016-07-03 18:31:38', 14502, 2, 0, 0, 0, 1),(21, '268513926', 'Колесо Удачи', '2016-07-03 18:31:51', 14500, 1000, 0, 0, 0, 1),(22, '268513926', 'Колесо Удачи', '2016-07-03 18:32:03', 14503, 1, 0, 0, 0, 1),(23, '268513926', 'Колесо Удачи', '2016-07-03 18:32:15', 14504, 1, 0, 0, 0, 1),(24, '268513926', 'Колесо Удачи', '2016-07-03 18:32:28', 14513, 1, 0, 0, 0, 1),(25, '268513926', 'Колесо Удачи', '2016-07-03 18:32:40', 14501, 50, 0, 0, 0, 1),(26, '268513926', 'Колесо Удачи', '2016-07-03 18:32:54', 14509, 100, 0, 0, 0, 1),(27, '268513926', 'Колесо Удачи', '2016-07-03 18:33:06', 14503, 1, 0, 0, 0, 1),(28, '268513926', 'Колесо Удачи', '2016-07-03 18:33:18', 14513, 1, 0, 0, 0, 1),(29, '268513926', 'Колесо Удачи', '2016-07-03 18:33:31', 14503, 1, 0, 0, 0, 1),(30, '268513926', 'Колесо Удачи', '2016-07-03 18:33:44', 14510, 100, 0, 0, 0, 1),(31, '268513926', 'Колесо Удачи', '2016-07-03 18:33:56', 14500, 1000, 0, 0, 0, 1),(32, '268472852', 'Колесо Удачи', '2016-07-03 19:38:16', 14501, 50, 0, 0, 0, 1),(33, '268472852', 'Колесо Удачи', '2016-07-03 19:38:19', 5592, 500, 0, 0, 0, 1),(34, '268472852', 'Колесо Удачи', '2016-07-03 19:38:57', 14513, 1, 0, 0, 0, 1),(35, '268472004', 'Пожертвование', '2016-07-03 21:58:14', 14504, 4, 0, 0, 0, 1),(36, '268472004', 'Пожертвование', '2016-07-03 22:07:46', 14504, 100, 0, 0, 0, 1),(37, '268472515', 'Unitpay', '2016-07-03 22:10:33', 14504, 3, 0, 0, 0, 1),(38, '268472751', 'Пожертвование', '2016-07-03 23:09:10', 14504, 22, 0, 0, 0, 1),(39, '268478667', 'Колесо Удачи', '2016-07-03 23:59:57', 14500, 2000, 0, 0, 0, 1),(40, '268487926', 'Пожертвование', '2016-07-04 00:10:20', 14504, 10, 0, 0, 0, 1),(41, '268513926', 'Пожертвование', '2016-07-04 00:17:42', 14504, 5, 0, 0, 0, 1),(42, '268478667', 'Колесо Удачи', '2016-07-04 00:50:21', 14501, 10, 0, 0, 0, 1),(43, '268478667', 'Колесо Удачи', '2016-07-04 00:50:36', 14503, 3, 0, 0, 0, 1),(44, '268478667', 'Колесо Удачи', '2016-07-04 00:50:49', 14503, 1, 0, 0, 0, 1),(45, '268478667', 'Колесо Удачи', '2016-07-04 00:51:03', 14503, 1, 0, 0, 0, 1),(46, '268478667', 'Колесо Удачи', '2016-07-04 00:51:15', 14510, 100, 0, 0, 0, 1),(47, '268540110', 'Пожертвование', '2016-07-04 00:51:49', 14504, 3, 0, 0, 0, 1),(48, '268472362', 'Пожертвование', '2016-07-04 01:01:21', 14504, 5, 0, 0, 0, 1),(49, '268544424', 'Пожертвование', '2016-07-04 02:07:11', 14504, 5, 0, 0, 0, 1),(50, '268544424', 'Колесо Удачи', '2016-07-04 02:12:45', 9982,
[SQL] Finished with error