Sql

[driad 42]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''555','1','Thomas D. Turkey','1',''Misguided Holiday Scrooge','1','LineageMonste' at line 1

[Err] ('555','1','Thomas D. Turkey','1',''Misguided Holiday Scrooge','1','LineageMonster4.br_crazy_turkey','8,50','8,50','80','male','L2Npc','40','3290.113068776940000','1674.800000000000000','8,500000000000000','3.000000000000000','40','43','30','21','20','20','0','0','970.53755','341.37500','662.75133','249.80341','253','4','333','0','0','0','80.00000','1.00000','0','1')

 

 

DROP TABLE IF EXISTS `buffer_buff_list`;

DROP TABLE IF EXISTS `buffer_scheme_contents`;

DROP TABLE IF EXISTS `buffer_scheme_list`;

 

CREATE TABLE `buffer_buff_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`buff_class` int(2) DEFAULT NULL,

`buffType` varchar(10) DEFAULT NULL,

`buffId` int(5) DEFAULT '0',

`buffLevel` int(5) DEFAULT NULL,

`forClass` tinyint(1) DEFAULT NULL,

`canUse` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=136;

CREATE TABLE `buffer_scheme_contents` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`scheme_id` int(11) DEFAULT NULL,

`skill_id` int(dirol.gif DEFAULT NULL,

`skill_level` int(4) DEFAULT NULL,

`buff_class` int(2) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=30;

CREATE TABLE `buffer_scheme_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`player_id` varchar(40) DEFAULT NULL,

`scheme_name` varchar(36) DEFAULT NULL,

`mod_accepted` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=7;

 

INSERT INTO `buffer_buff_list` VALUES ('1', '0', 'buff', '1036', '2', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('2', '0', 'buff', '1040', '3', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('3', '0', 'buff', '1043', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('4', '0', 'buff', '1044', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('5', '0', 'buff', '1045', '6', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('6', '0', 'buff', '1047', '4', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('7', '0', 'buff', '1048', '6', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('8', '0', 'buff', '1059', '3', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('9', '0', 'buff', '1068', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('10', '0', 'buff', '1077', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('11', '0', 'buff', '1085', '3', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('12', '0', 'buff', '1086', '2', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('13', '0', 'buff', '1087', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('14', '0', 'buff', '1204', '2', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('15', '0', 'buff', '1240', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('16', '0', 'buff', '1242', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('17', '0', 'buff', '1243', '6', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('18', '0', 'buff', '1257', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('19', '0', 'buff', '1268', '4', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('20', '0', 'buff', '1303', '2', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('21', '0', 'buff', '1304', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('22', '0', 'buff', '1307', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('23', '0', 'buff', '1311', '6', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('24', '0', 'buff', '1397', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('25', '0', 'buff', '1460', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('26', '0', 'buff', '1232', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('27', '0', 'buff', '1238', '3', '3', '0');

INSERT INTO `buffer_buff_list` VALUES ('28', '0', 'special', '1323', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('29', '0', 'special', '1388', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('30', '0', 'special', '1389', '3', '1', '1');

 

INSERT INTO `buffer_buff_list` VALUES ('31', '1', 'song', '264', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('32', '1', 'song', '265', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('33', '1', 'song', '266', '1', '3', '1');

[Msg] Finished - Unsuccessfully

При заливки баффера)

[Yokus 19]

А где запрос на вставку НПЦ? По-моему он вызывает ошибку

[SmokiMo 892]

('555','1','Thomas D. Turkey','1',''Misguided Holiday Scrooge','1','LineageMonster4.br_crazy_turkey','8,50','8,50','80','male','L2Npc','40','3290.113068776940000','1674.800000000000000','8,500000000000000','3.000000000000000','40','43','30','21','20','20','0','0','970.53755','341.37500','662.75133','249.80341','253','4','333','0','0','0','80.00000','1.00000','0','1')

 

Перед ('555', не хватает данных.