Запрос Базы Не Идет!

[DEHUC 8]

Всем привет...

помогите запрос залить сборка ПВ

пишет ошибку на этом запросе!

INSERT INTO `armor` VALUES

('9450','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9451','Intact Plate Armor','fullarmor','true','heavy','9780','leather','s','0','-1','333','0','0','0','0','true','true','true','true','0','0'),

('9452','Intact Gauntlet - Heavy Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9453','Intact Solleret - Heavy Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9454','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9455','Intact Brigandine','fullarmor','true','light','5400','leather','s','0','-1','249','0','0','0','0','true','true','true','true','0','0'),

('9456','Intact Leather Gloves - Light Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9457','Intact Boots - Light Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9459','Intact Doublet','fullarmor','true','magic','2450','leather','s','0','-1','166','0','866','0','0','true','true','true','true','0','0'),

('9460','Intact Silk Gloves - Robe','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9461','Intact Sandals - Robe','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9458','Intact Helm - Robe','head','true','none','570','fine_steel','s','0','-1','83','0','0','0','0','true','true','true','true','0','0');

как залить???

с менят +++++

[DEHUC 8]

помогите плиззз

[NewTrend 159]

Переделайте запрос под свою сборку...

[NiQQ 58]

Всем привет...

помогите запрос залить сборка ПВ

пишет ошибку на этом запросе!

INSERT INTO `armor` VALUES

('9450','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9451','Intact Plate Armor','fullarmor','true','heavy','9780','leather','s','0','-1','333','0','0','0','0','true','true','true','true','0','0'),

('9452','Intact Gauntlet - Heavy Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9453','Intact Solleret - Heavy Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9454','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9455','Intact Brigandine','fullarmor','true','light','5400','leather','s','0','-1','249','0','0','0','0','true','true','true','true','0','0'),

('9456','Intact Leather Gloves - Light Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9457','Intact Boots - Light Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9459','Intact Doublet','fullarmor','true','magic','2450','leather','s','0','-1','166','0','866','0','0','true','true','true','true','0','0'),

('9460','Intact Silk Gloves - Robe','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9461','Intact Sandals - Robe','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9458','Intact Helm - Robe','head','true','none','570','fine_steel','s','0','-1','83','0','0','0','0','true','true','true','true','0','0');

как залить???

с менят +++++

ты еще большим шрифтом написать не мог?

[DEHUC 8]

ты еще большим шрифтом написать не мог?

может просто у когото зрение плохое!

[DEHUC 8]

Переделайте запрос под свою сборку...

как это сделать?

[DsQuared 243]

К каждому запросу в пв надо добавлять путь к картинке,и не всегда совпадает не которые значения,например такие как wood и так далее

[DEHUC 8]

К каждому запросу в пв надо добавлять путь к картинке,и не всегда совпадает не которые значения,например такие как wood и так далее

а можеш помочь адаптировать мой запрос?

[DEHUC 8]

К каждому запросу в пв надо добавлять путь к картинке,и не всегда совпадает не которые значения,например такие как wood и так далее

INSERT INTO `armor` VALUES

('9450','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9451','Intact Plate Armor','fullarmor','true','heavy','9780','leather','s','0','-1','333','0','0','0','0','true','true','true','true','0','0'),

('9452','Intact Gauntlet - Heavy Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9453','Intact Solleret - Heavy Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9454','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0'),

('9455','Intact Brigandine','fullarmor','true','light','5400','leather','s','0','-1','249','0','0','0','0','true','true','true','true','0','0'),

('9456','Intact Leather Gloves - Light Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9457','Intact Boots - Light Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9459','Intact Doublet','fullarmor','true','magic','2450','leather','s','0','-1','166','0','866','0','0','true','true','true','true','0','0'),

('9460','Intact Silk Gloves - Robe','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9461','Intact Sandals - Robe','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0'),

('9458','Intact Helm - Robe','head','true','none','570','fine_steel','s','0','-1','83','0','0','0','0','true','true','true','true','0','0');

[DsQuared 243]

INSERT INTO `armor` VALUES

('9450','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9451','Intact Plate Armor','fullarmor','true','heavy','9780','leather','s','0','-1','333','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9452','Intact Gauntlet - Heavy Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9453','Intact Solleret - Heavy Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9454','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9455','Intact Brigandine','fullarmor','true','light','5400','leather','s','0','-1','249','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9456','Intact Leather Gloves - Light Armor','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9457','Intact Boots - Light Armor','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9459','Intact Doublet','fullarmor','true','magic','2450','leather','s','0','-1','166','0','866','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9460','Intact Silk Gloves - Robe','gloves','true','none','580','leather','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9461','Intact Sandals - Robe','feet','true','none','1130','blood_steel','s','0','-1','55','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

('9458','Intact Helm - Robe','head','true','none','570','fine_steel','s','0','-1','83','0','0','0','0','true','true','true','true','0','0','Icon.NOIMAGE');

Пробуй

[DEHUC 8]

Пробуй

он меня отматерил опять

 

 

ERROR 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 ''9451','Intact Plate Armor','fullarmor','true','heavy','9780','leather','s','0',' at line 1

ERROR 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 ''9452','Intact Gauntlet - Heavy Armor','gloves','true','none','580','leather','s' at line 1

ERROR 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 ''9453','Intact Solleret - Heavy Armor','feet','true','none','1130','blood_steel'' at line 1

ERROR 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 ''9454','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','' at line 1

ERROR 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 ''9455','Intact Brigandine','fullarmor','true','light','5400','leather','s','0','' at line 1

ERROR 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 ''9456','Intact Leather Gloves - Light Armor','gloves','true','none','580','leath' at line 1

ERROR 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 ''9457','Intact Boots - Light Armor','feet','true','none','1130','blood_steel','s' at line 1

ERROR 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 ''9459','Intact Doublet','fullarmor','true','magic','2450','leather','s','0','-1'' at line 1

ERROR 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 ''9460','Intact Silk Gloves - Robe','gloves','true','none','580','leather','s','0' at line 1

ERROR 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 ''9461','Intact Sandals - Robe','feet','true','none','1130','blood_steel','s','0'' at line 1

ERROR 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 ''9458','Intact Helm - Robe','head','true','none','570','fine_steel','s','0','-1'' at line 1

[DEHUC 8]

Даже вот делаю запрос на шлем и вот что пишет в консоли!

mysql> INSERT INTO `armor` VALUES

('9450','Intact Helm','head','true','none','570','fine_steel','s','0','-1','69','0','0','0','0','true','true','true','true','0','0');

 

ERROR 1136 : Column count doesn't match value count at row 1

[OnaHa 46]

Делаешь экспорт из навиката, открываешь, оставляешь 1 строку (для примера), ниже этой строки вставляешь 1 строку того, что хочешь залить на сервер, копируешь обе строки в excel, делаешь разбивку по столбцам, смотришь, где и что не так, правишь, сохраняешь в формате с разделителями, заливаешь в мускул