[HELP]Query Fehler

08/23/2011 21:18 Critone#1
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 Benhero#2
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 Critone#3
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 Benhero#4
Keine, du musst einfach 2 in der Query anhängen :D

Mfg
08/24/2011 17:52 Critone#5
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 .NighT™#6
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 Critone#7
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 .NighT™#8
Versuchs so:

Greetz
.NighT™
08/24/2011 19:38 Critone#9
Hat geklappt Danke :)