Ich wollte bei meinem Server einen Shop mit Uppitems einbauen. Um nicht alle Uppitems manuell in die Db zu hämmern, habe ich mir eine Query gemacht. Jedoch bekomme ich wenn ich die Query ausführen will die Fehlermeldung
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 `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30008' at line 2
Was ist an meiner Query falsch?
Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30007', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30008', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30009', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30010', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30011', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30014', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30015', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30016', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30017', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30018', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30019', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30021', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30022', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30023', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30025', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30027', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30028', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30031', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30030', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30032', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30033', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30034', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30035', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30037', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30038', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30039', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30040', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30041', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30042', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30045', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30046', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30047', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30048', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30049', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30050', '2')
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('17', '30051', '2')
Query 02/15/2012 - Metin2 Private Server - 1 Replies woher bekommt man die Query von einer waffe?
Minecraft Probleme ( Ruckel-, Grafik- und/oder Lag- Probleme 09/10/2011 - Minecraft - 3 Replies So, es ist das:
Und zwar geh ich gleih zum Punkt, mein Minecraft ruckelt alle 5-6 sec. .
Und wenn ich denn "F3" drücke, kommt doch (glaub ich wenn das das ist) dieser Debug modus, steht / ist ein Bild wo es die Verbindung oder wie das Spiel grad läuft, an.
Hier ein Screenshot: was los ist:
http://imageshack.us/photo/my-images/850/20110910 205313.png/
an den immerwieder gleichmäßigen roten linien die oben aufkommen.
[Help] query in sql 06/06/2011 - Shaiya Private Server - 6 Replies there is some easy query's already in this forum. but i hope some will share there other too. or i have one i realy want and can't make for mye self.
when you get a username that has payed for points (AP) (DP) and so on
is there a query to add to already points. so i don't just change it to 70 000 if he already have 20 000 and pays for 70 000.
i want something to add 70 000 to 20 000 so i get 90 000 and not just change it to 70 000 and all the points he/she hade is gone.
i don't...
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY! 08/18/2010 - Metin2 Private Server - 1 Replies Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
Probleme in Query
