|
You last visited: Today at 14:11
Advertisement
query help
Discussion on query help within the EO PServer Hosting forum part of the Eudemons Online category.
05/16/2011, 07:11
|
#1
|
elite*gold: 0 
Join Date: Mar 2009
Posts: 263
Received Thanks: 117
|
query help
how do i delete a item id from cq_dropItemrule
like i tried
delete cq_dropitemrule 1020150
lol i know its not that simple but can someone help i just want one certain item id removed from the droprule but theres like 200 of them so was wondering if theres a way to do a query to look for everything that says this 1020150 and remove or update it to a differnt id please let me know thanks 
|
|
|
|
05/16/2011, 08:42
|
#2
|
elite*gold: 20
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 827
|
dropitemrule has a range of itemid locations, item0~item14
the sql would be like this
Code:
delete from cq_dropitemrule where item0 = 1020150
|
|
|
|
|
05/16/2011, 14:23
|
#3
|
elite*gold: 0
Join Date: Mar 2009
Posts: 263
Received Thanks: 117
|
Quote:
Originally Posted by hio77
dropitemrule has a range of itemid locations, item0~item14
the sql would be like this
Code:
delete from cq_dropitemrule where item0 = 1020150
|
thanks
|
|
|
|
 |
Similar Threads
|
Wo ist die Query?
09/24/2010 - Metin2 Private Server - 4 Replies
Hi Com,
Da ich mich nicht damit auskenne dachte ich, ich frage euch mal, man muss ja bei neuen Rüssis, Waffen, Reittieren die Query benutzen, aber wo ist die und wie benutz man die?
MfG
|
[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/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...
|
All times are GMT +1. The time now is 14:11.
|
|
