Some useful Query 12/15/2014 - SRO PServer Guides & Releases - 5 Replies Some really useful queries to change things in your server(at least for me)
To change the mob slots(example you want to spawn niya generals in roc mountain instead of wing tribes then use this query):
USE SRO_VT_SHARD
UPDATE .SET dwObjID = replace(dwObjID, 'Mob ID you want to remove', 'Mob ID you want to spawn instead of removed one') WHERE dwObjID LIKE 'Repeat the mod ID you want to remove';
To set elixir stacks:
UPDATE dbo._RefObjItem
SET MaxStack = 250
WHERE ID BETWEEN 2025 AND...
Query 02/15/2012 - Metin2 Private Server - 1 Replies woher bekommt man die Query von einer waffe?
[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
need sql query , help 08/12/2010 - Dekaron Private Server - 3 Replies hello epvp ,
well i open this topic , coz i want a sql code .
to set all my players ( dekaron players )
tables :
wPosX , wPoxY , wRetPosX , wRetPosY , wMapIndex , wRetMapIndex
to this postion
wPosX : 415
wPoxY : 133
wRetPosX : 415