|
You last visited: Today at 18:31
Advertisement
Query von Gm-eq
Discussion on Query von Gm-eq within the Metin2 Private Server forum part of the Metin2 category.
06/28/2010, 21:55
|
#1
|
elite*gold: 0 
Join Date: Aug 2009
Posts: 23
Received Thanks: 2
|
Query von Gm-eq
hat einer von euch die Query von den Gm helmen etc wäre sehr nett wenn ihr sie posten könntet
|
|
|
|
06/28/2010, 22:00
|
#2
|
elite*gold: 2
Join Date: Jun 2010
Posts: 87
Received Thanks: 72
|
query?
|
|
|
|
|
06/28/2010, 22:03
|
#3
|
elite*gold: 0
Join Date: Dec 2009
Posts: 1,994
Received Thanks: 286
|
Quote:
Originally Posted by i7.
query?
|
Query tables kannst du in der item_proto einfach unter Query eingeben Run drücken direkt alle items in der DB 
p.s Hab sie geuploadet weiß nicht ob es erlaubt ist ihn zu posten wenn nicht bitte von Moderator raus editieren oder ich werde es machen falls es verboten ist
|
|
|
|
|
06/28/2010, 22:06
|
#4
|
elite*gold: 0
Join Date: Feb 2010
Posts: 7,220
Received Thanks: 6,758
|
Würde sagen es gibt keine Query für GM-Eq, da jeder unter GM-Equipment
etwas anderes versteht.
|
|
|
|
|
06/28/2010, 22:10
|
#5
|
elite*gold: 0
Join Date: Aug 2009
Posts: 23
Received Thanks: 2
|
ich hab ein beispiel gegeben : helm also eingendlich suche ich den schmuck der 999 def gibt etc
|
|
|
|
|
06/28/2010, 22:11
|
#6
|
elite*gold: 0
Join Date: Dec 2009
Posts: 1,994
Received Thanks: 286
|
Quote:
Originally Posted by xElfenLiedx
ich hab ein beispiel gegeben : helm also eingendlich suche ich den schmuck der 999 def gibt etc
|
Hab es in einen Post geuploadet
p.s thanks wäre nice 
bestimmt laden die jetzt alle die query und vergessen mich das ich denen geholfen habe, so ist elitepvpers-.-
|
|
|
|
|
06/28/2010, 22:32
|
#7
|
elite*gold: 125
Join Date: Apr 2008
Posts: 1,217
Received Thanks: 1,304
|
Quote:
Originally Posted by °°Since°°
Query tables kannst du in der item_proto einfach unter Query eingeben Run drücken direkt alle items in der DB
p.s Hab sie geuploadet weiß nicht ob es erlaubt ist ihn zu posten wenn nicht bitte von Moderator raus editieren oder ich werde es machen falls es verboten ist
|
Natürlich kann man SQL-Queries posten!
MySQL hat ja mal gar nichts mit Metin2 (Servern) zu tun... Den Query kann man sich bei den values umschreiben wie man lustig ist.
|
|
|
|
|
06/30/2010, 20:45
|
#8
|
elite*gold: 0
Join Date: Aug 2009
Posts: 23
Received Thanks: 2
|
push ^^
|
|
|
|
|
07/03/2010, 14:32
|
#9
|
elite*gold: 0
Join Date: Aug 2009
Posts: 23
Received Thanks: 2
|
push
|
|
|
|
|
08/26/2010, 01:05
|
#10
|
elite*gold: 0
Join Date: Aug 2010
Posts: 5
Received Thanks: 1
|
könnte mir ma bitte jemand die queri für gm helm schicken oder heir rein stellen ??
danke
|
|
|
|
|
10/29/2010, 21:49
|
#11
|
elite*gold: 0
Join Date: Apr 2010
Posts: 26
Received Thanks: 4
|
will auch was dazu sagen, es gibt genug threads in denen dein GM equip aufgelistet wird, aber ich bin ja mal lieb.
Drachengoldarmband:114200-114209
Drachengottarmband:14220-14229
Drachengottschuhe:15260-15269
Drachengotthelm:91000-91009
Drachengottschild:92000-92009
Drachenhautschuhe:15240-15249
Drachengoldkette:116200-116209
Drachengeoldohrringe:117200-117209
GM-Krieger Helm; Helm ab LvL:99, Vnum: 12670
GM-Ninja Helm; Helm ab LvL:99, Vnum: 12671
GM-Sura Helm; Helm ab LvL:99, Vnum: 12672
GM-Schamanen Helm; Helm ab LvL:99, Vnum: 12673
GM-Ohrringe; Ohrringe ab LvL:99; Vnum: 12674
GM-Armband; Armband ab LvL:99, Vnum: 12675
GM-Halskette; Halskette ab LvL:99, Vnum: 12676
GM-Schuhe; Schuhe ab LvL:99, Vnum: 12677
GM-Schild; Schild ab LvL:99, Vnum: 13210
wünsche viel spaß, obwohl diese codes oft genug gepostet werden aber *wayne* 
Thx wäre angebracht Ò.ó
MfG
|
|
|
|
|
12/10/2010, 20:38
|
#12
|
elite*gold: 0
Join Date: May 2009
Posts: 13
Received Thanks: 2
|
Der Download hat nichts gebracht -.- war nur krieger helm und ninja helm drinn und suche die immer noch die Query daten pls posten!
|
|
|
|
|
12/10/2010, 21:06
|
#13
|
elite*gold: 0
Join Date: Oct 2010
Posts: 102
Received Thanks: 13
|
ehm meinst du die sachen von profizocker files?
|
|
|
|
|
12/10/2010, 22:15
|
#14
|
elite*gold: 0
Join Date: Oct 2009
Posts: 54
Received Thanks: 10
|
ich hab hier nur die querrys die ich selbst gemacht hab weil ich nix anderes gefunden habe:
INSERT INTO `item_proto` VALUES ('12670', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '56', '0', '2', '', '20000', '890000', '1', '99', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12671', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '52', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12672', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '28', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12673', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '44', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12674', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '6', '0', '1', '0', '0', '64', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '5', '999', '6', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12675', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '3', '0', '1', '0', '0', '8', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '72', '999', '71', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12676', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '5', '0', '1', '0', '0', '32', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '9', '999', '4', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12677', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '4', '0', '1', '0', '0', '4', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '15', '999', '16', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12678', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '2', '0', '1', '0', '0', '256', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '17', '999', '63', '999', '0', '0', '0', '7', '0', '0', '0', '9999', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
E: du musst die namen noch mal im server dann umändern, weil ich nicht wüsste wie man den namen in den code umändert:
12670-GM Krieger Helm
12671-GM Ninja Helm
12672-GM Sura Helm
12673-GM Schami Helm
12674-GM ohringe
12675-GM armband
12676-GM halskette
12677-GM schuhe
12678-GM schild
|
|
|
|
|
12/10/2010, 22:18
|
#15
|
elite*gold: 0
Join Date: Dec 2010
Posts: 50
Received Thanks: 12
|
Quote:
Originally Posted by **TERROR**
ich hab hier nur die querrys die ich selbst gemacht hab weil ich nix anderes gefunden habe:
INSERT INTO `item_proto` VALUES ('12670', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '56', '0', '2', '', '20000', '890000', '1', '99', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12671', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '52', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12672', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '28', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12673', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '1', '0', '1', '44', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '99', '0', '0', '1', '999999', '2', '999999', '0', '0', '0', '9999', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12674', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '6', '0', '1', '0', '0', '64', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '5', '999', '6', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12675', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '3', '0', '1', '0', '0', '8', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '72', '999', '71', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12676', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '5', '0', '1', '0', '0', '32', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '9', '999', '4', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12677', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '4', '0', '1', '0', '0', '4', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '15', '999', '16', '999', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12678', 0xB9ABC0CEC0C720C1F5C7A520202020202020202020202020 , 0xAA5AB14EC3D2A9FAAED12020202020202020202020202020 , '2', '2', '0', '1', '0', '0', '256', '', '500000', '890000', '0', '0', '0', '15', '1', '99', '0', '0', '17', '999', '63', '999', '0', '0', '0', '7', '0', '0', '0', '9999', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');
E: du musst due namen noch mal im server dann umändern, weil ich nicht wüsste wie man den namen in den code umändert:
12670-GM Krieger Helm
12671-GM Ninja Helm
12672-GM Sura Helm
12673-GM Schami Helm
12674-GM ohringe
12675-GM armband
12676-GM halskette
12677-GM schuhe
12678-GM schild
|
Es gibt auch Spoiler schonmal davon was gehört?
|
|
|
|
 |
|
Similar Threads
|
[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
|
query
05/05/2010 - Metin2 Private Server - 0 Replies
So es gab mal ein ttut wie man query fur navicat usen kan nur ich finde in nicht mehr hat jemand den link?
|
Query?
05/03/2010 - Metin2 Private Server - 24 Replies
Hi Liebe Community ;)
Ich wollte mal neue waffen einfügen ;)
Jemand sagte mir um sie in die DB einzufügen musst du in die Item_Proto gehen und ein query machen...
aber wie geht das? ich muss das da einfügen
INSERT INTO `item_proto` VALUES ('7220', 'Spada Raggio di Luna +0 ', 'Spada Raggio di Luna +0', '1', '0', '0', '2', '32', '1', '16', '', '30000', '100', '7221', '19', '0', '5', '1', '80', '0', '0', '7', '15', '17', '2', '0', '0', '0', '90', '110', '5', '67', '117', '-1', '-1',...
|
A Query
03/02/2010 - 12Sky2 - 6 Replies
Hi,
First off, i'm an addict for 12sky 2. I play both 12sky 2 PH and 12sky 2 aeria. All the hax i find here for aeria server
has been very helpful. Apparently, things are quite the opposite for 12sky2 ph server since we have Xtrap. So hacking is quite
impossible for PH. Lately there has been major issues in PH server like some people using cheats/hacks. Fact is, there are already
people banned in PH server for using hax.
Anyway, been trying to find a way to hack 12sky 2 ph server but...
|
Query Help? xD
01/24/2009 - EO PServer Hosting - 3 Replies
Hey lol Can anyone show me how to make this Query replace the old Legion Admin.. Check out this wordpad please and if you Know how to make these Translations replace the old ones Please email me at [email protected]
|
All times are GMT +1. The time now is 18:32.
|
|
