03-20-2017, 01:23 AM
Помогите ребят, щас стул сгорит уже, сколько занимаюсь никогда такого небыло, ошибка сиснаксиса.
Ошибка
[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 'INSERT INTO `npc`
(id, idTemplate, name, serverSideName, title, serverSide' at line 1
[Err] INSERT INTO `npc`
(id, idTemplate, name, serverSideName, title, serverSideTitle, race, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type, ss, bss, ss_rate, AI, drop_herbs)
VALUES
('50018', '35639', 'Auction', '1', 'Аукцион', '1', '2', '8', '25', '70', 'male', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', ' ', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
(id, idTemplate, name, serverSideName, title, serverSide' at line 1
[Err] INSERT INTO `npc`
(id, idTemplate, name, serverSideName, title, serverSideTitle, race, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type, ss, bss, ss_rate, AI, drop_herbs)
VALUES
('50018', '35639', 'Auction', '1', 'Аукцион', '1', '2', '8', '25', '70', 'male', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', ' ', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
запрос
INSERT INTO `npc`
(id, idTemplate, name, serverSideName, title, serverSideTitle, race, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type, ss, bss, ss_rate, AI, drop_herbs)
VALUES
('50018', '35639', 'Auction', '1', 'Аукцион', '1', '2', '8', '25', '70', 'male', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', ' ', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
(id, idTemplate, name, serverSideName, title, serverSideTitle, race, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type, ss, bss, ss_rate, AI, drop_herbs)
VALUES
('50018', '35639', 'Auction', '1', 'Аукцион', '1', '2', '8', '25', '70', 'male', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', ' ', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');