Register for your free account! | Forgot your password?

You last visited: Today at 18:27

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Probleme in Query

Discussion on Probleme in Query within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
Sogma's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 670
Received Thanks: 137
Exclamation Probleme in Query

Hey Com,

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')
LG Sogma
Sogma is offline  
Old 07/27/2012, 14:00   #2
 
NotEnoughForYou's Avatar
 
elite*gold: 0
Join Date: Jun 2010
Posts: 3,407
Received Thanks: 2,024
wie wärs mit nem ; am Ende?
NotEnoughForYou is offline  
Thanks
1 User
Old 07/27/2012, 18:33   #3
 
Sogma's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 670
Received Thanks: 137
Dankeschön, habe ich wohl vergessen
Sogma is offline  
Reply


Similar Threads Similar Threads
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



All times are GMT +2. The time now is 18:27.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.