		elitepvpers > Popular Games > Metin2 > Metin2 Private Server
Query

You last visited: Today at 04:29

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

Advertisement

Advertise with us!

Query

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

06/24/2016, 19:44	#1
The2MrMetin2 elite*gold: 0 The Black Market: 0/0/0 Join Date: Mar 2012 Posts: 980 Received Thanks: 12	Query Bekomem diesen Error: PHP Code: `[Err] 1136 - Column count doesn't match value count at row 1` wenn ich diese Query ausführe: Spoiler PHP Code: INSERT INTO `item_proto` VALUES ('82824', 'Roter Sonnenkristall', 'Roter Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82825', 'Grüner Sonnenkristall', 'Grüner Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82826', 'Gelber Sonnenkristall', 'Gelber Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82827', 'Blauer Sonnenkristall', 'Blauer Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82828', 'Roter Stern', 'Roter Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82829', 'Gelber Stern', 'Gelber Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82830', 'Lila Stern', 'Lila Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82831', 'Blauer Stern', 'Blauer Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82832', 'Roter Diamant', 'Roter Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82833', 'Blauer Diamant', 'Blauer Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82834', 'Grüner Diamant', 'Grüner Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82835', 'Gelber Diamant', 'Gelber Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82836', 'Gelbe Perle', 'Gelbe Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82837', 'Lila Perle', 'Lila Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0'); INSERT INTO `item_proto` VALUES ('82838', 'Grüne Perle', 'Grüne Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0');

06/24/2016, 20:25	#2
Fydes elite*gold: 0 The Black Market: 72/1/0 Join Date: Mar 2014 Posts: 1,619 Received Thanks: 984	Der Query hat zu wenig Zeichen. Überprüfe deine Columns und den Query. Liebe Grüße

06/25/2016, 01:27	#3
~~#Metho~~ elite*gold: 0 The Black Market: 0/0/0 Join Date: Apr 2015 Posts: 428 Received Thanks: 361	So: Spoiler PHP Code: INSERT INTO `item_proto` VALUES ('82824', 'Roter Sonnenkristall', 'Roter Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82825', 'Grüner Sonnenkristall', 'Grüner Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82826', 'Gelber Sonnenkristall', 'Gelber Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82827', 'Blauer Sonnenkristall', 'Blauer Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82828', 'Roter Stern', 'Roter Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82829', 'Gelber Stern', 'Gelber Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82830', 'Lila Stern', 'Lila Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82831', 'Blauer Stern', 'Blauer Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82832', 'Roter Diamant', 'Roter Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82833', 'Blauer Diamant', 'Blauer Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82834', 'Grüner Diamant', 'Grüner Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82835', 'Gelber Diamant', 'Gelber Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82836', 'Gelbe Perle', 'Gelbe Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82837', 'Lila Perle', 'Lila Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); INSERT INTO `item_proto` VALUES ('82838', 'Grüne Perle', 'Grüne Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0'); Oder so: Spoiler PHP Code: INSERT INTO `item_proto` VALUES ('82824', 'Roter Sonnenkristall', 'Roter Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82825', 'Grüner Sonnenkristall', 'Grüner Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82826', 'Gelber Sonnenkristall', 'Gelber Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82827', 'Blauer Sonnenkristall', 'Blauer Sonnenkristall', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82828', 'Roter Stern', 'Roter Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82829', 'Gelber Stern', 'Gelber Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82830', 'Lila Stern', 'Lila Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82831', 'Blauer Stern', 'Blauer Stern', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82832', 'Roter Diamant', 'Roter Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82833', 'Blauer Diamant', 'Blauer Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82834', 'Grüner Diamant', 'Grüner Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82835', 'Gelber Diamant', 'Gelber Diamant', '5', '0', '0', '1', '0', '4', '0', '', '10000', '1000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82836', 'Gelbe Perle', 'Gelbe Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82837', 'Lila Perle', 'Lila Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); INSERT INTO `item_proto` VALUES ('82838', 'Grüne Perle', 'Grüne Perle', '5', '0', '0', '1', '0', '4', '0', '', '100000', '10000', '', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0', '0'); sollte es gehen

06/25/2016, 08:22	#4
MrTherzon elite*gold: 0 The Black Market: 180/0/1 Join Date: Dec 2012 Posts: 9,396 Received Thanks: 2,738	Ich hatte dir doch schon per PN geschrieben das du die Spalten der DB zählen sollst und die deiner Query und dann anpassen musst.

« Kori Client & Server Problem | Truhen lassen sich nach reboot nicht öffnen »

Similar Threads
[Release][Query] Query _InvCOS Items WITH _Char Connection 12/29/2015 - SRO PServer Guides & Releases - 1 Replies Ok, so i needed to write this query for a procedure im working on and not many people know how to connect the pet inventory table to the character table.... so this query will explain how its done... im not going to explain every single detail, like how there is no charcos when pet is despawned / dead... but yea you can probably figure that all out from this query... The code... USE SELECT pet_invo. ,pet_invo. PetSlot
Query 04/08/2013 - Metin2 Private Server - 1 Replies Hey leute :) Wollte fragen ob jemand ein TuT oder die Query von den rüssis hat wie man die einfügt. :D & ihr braucht jetzt nicht kommen machs selber! http://www.elitepvpers.com/forum/metin2-pserver-g uides-strategies/1852706-armor-release-armor-all-c haracters.html
[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 +1. The time now is 04:30.

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