|
You last visited: Today at 04:29
Advertisement
Query
Discussion on Query within the Metin2 Private Server forum part of the Metin2 category.
06/24/2016, 19:44
|
#1
|
elite*gold: 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:
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
|
elite*gold: 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
|
elite*gold: 0
Join Date: Apr 2015
Posts: 428
Received Thanks: 361
|
So:
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:
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
|
elite*gold: 0
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.
|
|
|
 |
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.
|
|