|
You last visited: Today at 14:17
Advertisement
[HELP]Query Fehler
Discussion on [HELP]Query Fehler within the Metin2 Private Server forum part of the Metin2 category.
08/23/2011, 21:18
|
#1
|
elite*gold: 149
Join Date: Feb 2010
Posts: 1,297
Received Thanks: 345
|
[HELP]Query Fehler
Hey,
ich habe ein Problem, unzwar kriegt mein Serveradmin dem ich dieses Query geschikt habe...
Code:
INSERT INTO `item_proto` VALUES ('9599',Stab +9 ,'Stab +9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3')
INSERT INTO `item_proto` VALUES ('9598',Stab +8 ,'Stab +8','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9599','705','5','80','3')
INSERT INTO `item_proto` VALUES ('9597',Stab +7 ,'Stab +7','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9598','704','5','65','3')
INSERT INTO `item_proto` VALUES ('9596',Stab +6 ,'Stab +6','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9597','703','5','50','3')
INSERT INTO `item_proto` VALUES ('9595',Stab +5 ,'Stab +5','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9596','24','5','40','3')
INSERT INTO `item_proto` VALUES ('9594',Stab +4 ,'Stab +4','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9595','23','5','30','3')
INSERT INTO `item_proto` VALUES ('9593',Stab +3 ,'Stab +3','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9594','22','5','0','3')
INSERT INTO `item_proto` VALUES ('9592',Stab +2 ,'Stab +2','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9593','21','5','0','3')
INSERT INTO `item_proto` VALUES ('9591',Stab +1 ,'Stab +1','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9592','20','5','0','3')
INSERT INTO `item_proto` VALUES ('9590',Stab +0 ,'Stab +0','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9591','19','5','0','3')
INSERT INTO `item_proto` VALUES ('9499',Dolche +9 ,'Dolche +9','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3');
INSERT INTO `item_proto` VALUES ('9498',Dolche +8 ,'Dolche +8','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9499','705','5','80','3');
INSERT INTO `item_proto` VALUES ('9497',Dolche +7 ,'Dolche +7','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9498','704','5','65','3');
INSERT INTO `item_proto` VALUES ('9496',Dolche +6 ,'Dolche +6','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9497','703','5','50','3');
INSERT INTO `item_proto` VALUES ('9495',Dolche +5 ,'Dolche +5','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9496','24','5','40','3');
INSERT INTO `item_proto` VALUES ('9494',Dolche +4 ,'Dolche +4','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9495','23','5','30','3');
INSERT INTO `item_proto` VALUES ('9493',Dolche +3 ,'Dolche +3','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9494','22','5','0','3');
INSERT INTO `item_proto` VALUES ('9492',Dolche +2 ,'Dolche +2','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9493','21','5','0','3');
INSERT INTO `item_proto` VALUES ('9491',Dolche +1 ,'Dolche +1','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9492','20','5','0','3');
INSERT INTO `item_proto` VALUES ('9490',Dolche +0 ,'Dolche +0','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9491','19','5','0','3');
INSERT INTO `item_proto` VALUES ('9399',Bogen +9 ,'Bogen +9','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3');
INSERT INTO `item_proto` VALUES ('9398',Bogen +8 ,'Bogen +8','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9399','705','5','80','3');
INSERT INTO `item_proto` VALUES ('9397',Bogen +7 ,'Bogen +7','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9398','704','5','65','3');
INSERT INTO `item_proto` VALUES ('9396',Bogen +6 ,'Bogen +6','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9397','703','5','50','3');
INSERT INTO `item_proto` VALUES ('9395',Bogen +5 ,'Bogen +5','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9396','24','5','40','3');
INSERT INTO `item_proto` VALUES ('9394',Bogen +4 ,'Bogen +4','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9395','23','5','30','3');
INSERT INTO `item_proto` VALUES ('9393',Bogen +3 ,'Bogen +3','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9394','22','5','0','3');
INSERT INTO `item_proto` VALUES ('9392',Bogen +2 ,'Bogen +2','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9393','21','5','0','3');
INSERT INTO `item_proto` VALUES ('9391',Bogen +1 ,'Bogen +1','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9392','20','5','0','3');
INSERT INTO `item_proto` VALUES ('9390',Bogen +0 ,'Bogen +0','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9391','19','5','0','3');
INSERT INTO `item_proto` VALUES ('9199',Zweihandschwert +9 ,'Zweihandschwert +9','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3');
INSERT INTO `item_proto` VALUES ('9198',Zweihandschwert +8 ,'Zweihandschwert +8','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9199','705','5','80','3');
INSERT INTO `item_proto` VALUES ('9197',Zweihandschwert +7 ,'Zweihandschwert +7','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9198','704','5','65','3');
INSERT INTO `item_proto` VALUES ('9196',Zweihandschwert +6 ,'Zweihandschwert +6','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9197','703','5','50','3');
INSERT INTO `item_proto` VALUES ('9195',Zweihandschwert +5 ,'Zweihandschwert +5','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9196','24','5','40','3');
INSERT INTO `item_proto` VALUES ('9194',Zweihandschwert +4 ,'Zweihandschwert +4','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9195','23','5','30','3');
INSERT INTO `item_proto` VALUES ('9193',Zweihandschwert +3 ,'Zweihandschwert +3','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9194','22','5','0','3');
INSERT INTO `item_proto` VALUES ('9192',Zweihandschwert +2 ,'Zweihandschwert +2','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9193','21','5','0','3');
INSERT INTO `item_proto` VALUES ('9191',Zweihandschwert +1 ,'Zweihandschwert +1','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9192','20','5','0','3');
INSERT INTO `item_proto` VALUES ('9190',Zweihandschwert +0 ,'Zweihandschwert +0','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9191','19','5','0','3');
INSERT INTO `item_proto` VALUES ('9299',Schwert +9 ,'Schwert +9','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3');
INSERT INTO `item_proto` VALUES ('9298',Schwert +8 ,'Schwert +8','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9299','705','5','80','3');
INSERT INTO `item_proto` VALUES ('9297',Schwert +7 ,'Schwert +7','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9298','704','5','65','3');
INSERT INTO `item_proto` VALUES ('9296',Schwert +6 ,'Schwert +6','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9297','703','5','50','3');
INSERT INTO `item_proto` VALUES ('9295',Schwert +5 ,'Schwert +5','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9296','24','5','40','3');
INSERT INTO `item_proto` VALUES ('9294',Schwert +4 ,'Schwert +4','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9295','23','5','30','3');
INSERT INTO `item_proto` VALUES ('9293',Schwert +3 ,'Schwert +3','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9294','22','5','0','3');
INSERT INTO `item_proto` VALUES ('9292',Schwert +2 ,'Schwert +2','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9293','21','5','0','3');
INSERT INTO `item_proto` VALUES ('9291',Schwert +1 ,'Schwert +1','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9292','20','5','0','3');
Folgenden Fehler:
Code:
[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 `item_proto` VALUES ('9598',Stab +8 ,'Stab +8','1','4','0','2','284'' at line 2
Kann mir bitte jemand helfen?
Ich habe extra die ganze Query geschrieben bzw. umgeändert und jetzt
Bitte helft mir...
gruß
critone
|
|
|
08/23/2011, 21:27
|
#2
|
elite*gold: 964
Join Date: Mar 2008
Posts: 2,629
Received Thanks: 1,636
|
Kann es sein das er die Falsche version der Datenbank hat als die Query? Er sollte mal überprüfen ob er auch genau so viele Spalten hat wie die Query einfügen würde.
Bzw. hier
PHP Code:
Stab +9 ,'Stab +9'
bei dem ersten fehlen die ' ' kann es dammit zusammen hängen?
Mfg.
|
|
|
08/23/2011, 21:30
|
#3
|
elite*gold: 149
Join Date: Feb 2010
Posts: 1,297
Received Thanks: 345
|
Wenn ich richtig gezählt habe sind es in der Query 40 Spalten...
die DB hat 42 Spalten...aber welche 2 muss ich jetzt aus der Query löschen?
|
|
|
08/23/2011, 21:44
|
#4
|
elite*gold: 964
Join Date: Mar 2008
Posts: 2,629
Received Thanks: 1,636
|
Keine, du musst einfach 2 in der Query anhängen
Mfg
|
|
|
08/24/2011, 17:52
|
#5
|
elite*gold: 149
Join Date: Feb 2010
Posts: 1,297
Received Thanks: 345
|
Also ich habe einfach 2 Nullen überall dran gehängt...
dann sieht das so aus...
Code:
INSERT INTO `item_proto` VALUES ('9599',Stab +9 ,'Stab +9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9598',Stab +8 ,'Stab +8','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9599','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9597',Stab +7 ,'Stab +7','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9598','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9596',Stab +6 ,'Stab +6','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9597','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9595',Stab +5 ,'Stab +5','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9596','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9594',Stab +4 ,'Stab +4','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9595','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9593',Stab +3 ,'Stab +3','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9594','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9592',Stab +2 ,'Stab +2','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9593','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9591',Stab +1 ,'Stab +1','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9592','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9590',Stab +0 ,'Stab +0','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9591','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9499',Dolche +9 ,'Dolche +9','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9498',Dolche +8 ,'Dolche +8','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9499','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9497',Dolche +7 ,'Dolche +7','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9498','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9496',Dolche +6 ,'Dolche +6','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9497','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9495',Dolche +5 ,'Dolche +5','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9496','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9494',Dolche +4 ,'Dolche +4','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9495','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9493',Dolche +3 ,'Dolche +3','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9494','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9492',Dolche +2 ,'Dolche +2','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9493','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9491',Dolche +1 ,'Dolche +1','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9492','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9490',Dolche +0 ,'Dolche +0','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9491','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9399',Bogen +9 ,'Bogen +9','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9398',Bogen +8 ,'Bogen +8','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9399','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9397',Bogen +7 ,'Bogen +7','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9398','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9396',Bogen +6 ,'Bogen +6','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9397','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9395',Bogen +5 ,'Bogen +5','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9396','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9394',Bogen +4 ,'Bogen +4','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9395','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9393',Bogen +3 ,'Bogen +3','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9394','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9392',Bogen +2 ,'Bogen +2','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9393','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9391',Bogen +1 ,'Bogen +1','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9392','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9390',Bogen +0 ,'Bogen +0','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9391','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9199',Zweihandschwert +9 ,'Zweihandschwert +9','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9198',Zweihandschwert +8 ,'Zweihandschwert +8','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9199','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9197',Zweihandschwert +7 ,'Zweihandschwert +7','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9198','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9196',Zweihandschwert +6 ,'Zweihandschwert +6','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9197','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9195',Zweihandschwert +5 ,'Zweihandschwert +5','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9196','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9194',Zweihandschwert +4 ,'Zweihandschwert +4','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9195','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9193',Zweihandschwert +3 ,'Zweihandschwert +3','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9194','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9192',Zweihandschwert +2 ,'Zweihandschwert +2','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9193','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9191',Zweihandschwert +1 ,'Zweihandschwert +1','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9192','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9190',Zweihandschwert +0 ,'Zweihandschwert +0','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9191','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9299',Schwert +9 ,'Schwert +9','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9298',Schwert +8 ,'Schwert +8','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9299','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9297',Schwert +7 ,'Schwert +7','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9298','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9296',Schwert +6 ,'Schwert +6','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9297','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9295',Schwert +5 ,'Schwert +5','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9296','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9294',Schwert +4 ,'Schwert +4','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9295','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9293',Schwert +3 ,'Schwert +3','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9294','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9292',Schwert +2 ,'Schwert +2','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9293','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9291',Schwert +1 ,'Schwert +1','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9292','20','5','0','3','0','0');
aber dann kommt folgender Fehler
Code:
[SQL]
INSERT INTO `item_proto` VALUES ('9599',Stab +9 ,'Stab +9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
[Err] 1054 - Unknown column 'Stab' in 'field list'
Bitte helft mir...
^Push
Bitte helft mir...das ist echt wichtig...
|
|
|
08/24/2011, 18:04
|
#6
|
elite*gold: 351
Join Date: Apr 2011
Posts: 2,062
Received Thanks: 1,526
|
Mach zwischen "Stab" und "+9" z.B. kein Abstand. Einfach so:
Beispiel:
Code:
INSERT INTO `item_proto` VALUES ('9599',[COLOR="red"]Stab+9[/COLOR] ,'[COLOR="Red"]Stab+9[/COLOR]','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
Vielleicht gehts dann.
Greetz
.NighT™
|
|
|
08/24/2011, 18:57
|
#7
|
elite*gold: 149
Join Date: Feb 2010
Posts: 1,297
Received Thanks: 345
|
So habe das mit dem Stab usw. geändert.
Das sieht jetzt so aus...
Code:
INSERT INTO `item_proto` VALUES ('9599',Stab+9 ,'Stab+9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9598',Stab+8 ,'Stab+8','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9599','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9597',Stab+7 ,'Stab+7','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9598','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9596',Stab+6 ,'Stab+6','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9597','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9595',Stab+5 ,'Stab+5','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9596','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9594',Stab+4 ,'Stab+4','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9595','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9593',Stab+3 ,'Stab+3','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9594','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9592',Stab+2 ,'Stab+2','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9593','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9591',Stab+1 ,'Stab+1','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9592','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9590',Stab+0 ,'Stab+0','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9591','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9499',Dolche+9 ,'Dolche+9','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9498',Dolche+8 ,'Dolche+8','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9499','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9497',Dolche+7 ,'Dolche+7','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9498','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9496',Dolche+6 ,'Dolche+6','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9497','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9495',Dolche+5 ,'Dolche+5','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9496','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9494',Dolche+4 ,'Dolche+4','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9495','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9493',Dolche+3 ,'Dolche+3','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9494','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9492',Dolche+2 ,'Dolche+2','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9493','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9491',Dolche+1 ,'Dolche+1','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9492','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9490',Dolche+0 ,'Dolche+0','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9491','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9399',Bogen+9 ,'Bogen+9','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9398',Bogen+8 ,'Bogen+8','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9399','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9397',Bogen+7 ,'Bogen+7','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9398','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9396',Bogen+6 ,'Bogen+6','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9397','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9395',Bogen+5 ,'Bogen+5','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9396','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9394',Bogen+4 ,'Bogen+4','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9395','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9393',Bogen+3 ,'Bogen+3','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9394','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9392',Bogen+2 ,'Bogen+2','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9393','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9391',Bogen+1 ,'Bogen+1','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9392','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9390',Bogen+0 ,'Bogen+0','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9391','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9199',Zweihandschwert+9 ,'Zweihandschwert+9','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9198',Zweihandschwert+8 ,'Zweihandschwert+8','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9199','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9197',Zweihandschwert+7 ,'Zweihandschwert+7','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9198','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9196',Zweihandschwert+6 ,'Zweihandschwert+6','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9197','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9195',Zweihandschwert+5 ,'Zweihandschwert+5','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9196','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9194',Zweihandschwert+4 ,'Zweihandschwert+4','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9195','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9193',Zweihandschwert+3 ,'Zweihandschwert+3','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9194','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9192',Zweihandschwert+2 ,'Zweihandschwert+2','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9193','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9191',Zweihandschwert+1 ,'Zweihandschwert+1','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9192','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9190',Zweihandschwert+0 ,'Zweihandschwert+0','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9191','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9299',Schwert+9 ,'Schwert+9','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9298',Schwert+8 ,'Schwert+8','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9299','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9297',Schwert+7 ,'Schwert+7','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9298','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9296',Schwert+6 ,'Schwert+6','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9297','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9295',Schwert+5 ,'Schwert+5','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9296','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9294',Schwert+4 ,'Schwert+4','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9295','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9293',Schwert+3 ,'Schwert+3','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9294','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9292',Schwert+2 ,'Schwert+2','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9293','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9291',Schwert+1 ,'Schwert+1','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9292','20','5','0','3','0','0');
beim einfügen kommt dieser Fehler...
Code:
[SQL]
INSERT INTO `item_proto` VALUES ('9599',Stab+9 ,'Stab+9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
[Err] 1054 - Unknown column 'Stab' in 'field list'
Bitte...ich versteh nicht was ich falsch mache...
Das ist die DB von den Daroo-Files *Noob-Edition*...
|
|
|
08/24/2011, 19:10
|
#8
|
elite*gold: 351
Join Date: Apr 2011
Posts: 2,062
Received Thanks: 1,526
|
Versuchs so:
Code:
INSERT INTO `item_proto` VALUES ('9599','Stab+9' ,'Stab+9','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9598','Stab+8' ,'Stab+8','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9599','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9597','Stab+7' ,'Stab+7','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9598','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9596','Stab+6' ,'Stab+6','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9597','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9595','Stab+5' ,'Stab+5','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9596','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9594','Stab+4' ,'Stab+4','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9595','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9593','Stab+3' ,'Stab+3','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9594','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9592','Stab+2' ,'Stab+2','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9593','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9591','Stab+1' ,'Stab+1','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9592','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9590','Stab+0' ,'Stab+0','1','4','0','2','284','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9591','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9499','Dolche+9' ,'Dolche+9','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9498','Dolche+8' ,'Dolche+8','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9499','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9497','Dolche+7' ,'Dolche+7','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9498','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9496','Dolche+6' ,'Dolche+6','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9497','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9495','Dolche+5' ,'Dolche+5','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9496','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9494','Dolche+4' ,'Dolche+4','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9495','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9493','Dolche+3' ,'Dolche+3','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9494','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9492','Dolche+2' ,'Dolche+2','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9493','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9491','Dolche+1' ,'Dolche+1','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9492','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9490','Dolche+0' ,'Dolche+0','1','1','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9491','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9399','Bogen+9' ,'Bogen+9','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9398','Bogen+8' ,'Bogen+8','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9399','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9397','Bogen+7' ,'Bogen+7','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9398','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9396','Bogen+6' ,'Bogen+6','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9397','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9395','Bogen+5' ,'Bogen+5','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9396','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9394','Bogen+4' ,'Bogen+4','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9395','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9393','Bogen+3' ,'Bogen+3','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9394','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9392','Bogen+2' ,'Bogen+2','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9393','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9391','Bogen+1' ,'Bogen+1','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9392','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9390','Bogen+0' ,'Bogen+0','1','2','0','2','52','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9391','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9199','Zweihandschwert+9' ,'Zweihandschwert+9','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9198','Zweihandschwert+8' ,'Zweihandschwert+8','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9199','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9197','Zweihandschwert+7' ,'Zweihandschwert+7','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9198','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9196','Zweihandschwert+6' ,'Zweihandschwert+6','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9197','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9195','Zweihandschwert+5' ,'Zweihandschwert+5','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9196','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9194','Zweihandschwert+4' ,'Zweihandschwert+4','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9195','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9193','Zweihandschwert+3' ,'Zweihandschwert+3','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9194','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9192','Zweihandschwert+2' ,'Zweihandschwert+2','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9193','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9191','Zweihandschwert+1' ,'Zweihandschwert+1','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9192','20','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9190','Zweihandschwert+0' ,'Zweihandschwert+0','1','3','0','3','312','1','16','0','30000','100','1','100','0','0','7','15','17','1','0','0','0','205','230','230','250','0','65535','65535','65535','65535','65535','65535','9191','19','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9299','Schwert+9' ,'Schwert+9','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','30','17','10','0','0','0','205','230','230','250','135','65535','65535','65535','65535','65535','65535','267','703','5','100','3','0','0');
INSERT INTO `item_proto` VALUES ('9298','Schwert+8' ,'Schwert+8','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','27','17','9','0','0','0','205','230','230','250','120','65535','65535','65535','65535','65535','65535','9299','705','5','80','3','0','0');
INSERT INTO `item_proto` VALUES ('9297','Schwert+7' ,'Schwert+7','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','24','17','8','0','0','0','205','230','230','250','105','65535','65535','65535','65535','65535','65535','9298','704','5','65','3','0','0');
INSERT INTO `item_proto` VALUES ('9296','Schwert+6' ,'Schwert+6','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','22','17','7','0','0','0','205','230','230','250','90','65535','65535','65535','65535','65535','65535','9297','703','5','50','3','0','0');
INSERT INTO `item_proto` VALUES ('9295','Schwert+5' ,'Schwert+5','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','19','17','6','0','0','0','205','230','230','250','75','65535','65535','65535','65535','65535','65535','9296','24','5','40','3','0','0');
INSERT INTO `item_proto` VALUES ('9294','Schwert+4' ,'Schwert+4','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','18','17','5','0','0','0','205','230','230','250','60','65535','65535','65535','65535','65535','65535','9295','23','5','30','3','0','0');
INSERT INTO `item_proto` VALUES ('9293','Schwert+3' ,'Schwert+3','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','17','17','4','0','0','0','205','230','230','250','45','65535','65535','65535','65535','65535','65535','9294','22','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9292','Schwert+2' ,'Schwert+2','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','16','17','3','0','0','0','205','230','230','250','30','65535','65535','65535','65535','65535','65535','9293','21','5','0','3','0','0');
INSERT INTO `item_proto` VALUES ('9291','Schwert+1' ,'Schwert+1','1','0','0','2','32','1','16','0','30000','100','1','100','0','0','7','15','17','2','0','0','0','205','230','230','250','15','65535','65535','65535','65535','65535','65535','9292','20','5','0','3','0','0');
Greetz
.NighT™
|
|
|
08/24/2011, 19:38
|
#9
|
elite*gold: 149
Join Date: Feb 2010
Posts: 1,297
Received Thanks: 345
|
Hat geklappt Danke
|
|
|
|
Similar Threads
|
Navicat Query Fehler
08/21/2011 - Metin2 Private Server - 7 Replies
Hallo ,
Wollte auf meinen alten Server die neuen Zombies draufmachen.
Für diesen benutze ich die 2010er Files.
Ich habe schon viele Querys probiert auch von einen anderen
Server wo ich die Mobbbs schon drinne habe aber es geht nicht.
INSERT INTO `mob_proto` VALUES ('2501', 'zombie_diseased_kid', 0x5A6F6D626965204B696E64, '1', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '30', '40', '200', '10', '100', '500', '2000', '3', '3', '500000',...
|
[HowTo]2010er Query fehler beheben
08/05/2011 - Metin2 PServer Guides & Strategies - 1 Replies
heyyyy
|
[Fehler]Query von neuen Metinsteinen
06/19/2011 - Metin2 Private Server - 1 Replies
Hoi,
brauch mal eure Hilfe, immer wenn ich die Querys aus diesem Thread ausführen will, bekomm ich folgenden Fehler:
ERROR 1136 : Column count doesn't match value count at row 1
Viel anfangen kann ich damit nich. Hab auch mal versucht die Querys über die mob_proto.xml zu generieren, kommt der gleiche Fehler.
Ahja, sind die 2010er Files von Daroo, also die US mob_proto.
|
Navicat Query einfügen fehler hilfe
10/13/2010 - Metin2 Private Server - 7 Replies
also wenn ich ihn navicatbei der item proto einen neuen query einfügen steht da irgendtwas mit cannot creat file das system kann den pfad nicht finden
|
HowTo item_proto Query Fehler beheben
05/09/2010 - Metin2 PServer Guides & Strategies - 17 Replies
Hallo, ihr kennt bestimmt diesen Fehler.
Ihr geht in die item_proto in Navicat und wollt Items/Waffen/Rüstungen und so weiter hinzufügen.
Ihr geht wie immer auf File-> dann auf Query, nun fügt ihr euren code ein.
Beispiel die neue Waffe:
INSERT INTO `item_proto` VALUES (7500, "Donnerklinge+0 ", "Donnerklinge+0", 1, 3, 0, 3, 56, 1, 16, '', 10000000, 15000000, 7501, 46, 0, 15, 1, 80, 0, 0, 7, 27, 17, 2, 5, 8, 0, 1, 0, 216, 248, 12, 0, 64992, 127, 64976, 21631, 4855, 0, 3, 0);
INSERT...
|
All times are GMT +1. The time now is 14:17.
|
|