UPDATE I
SET I.ItemID = 0
FROM SRO_VT_SHARD.dbo._Inventory I
JOIN SRO_VT_SHARD.dbo._Items IT
ON I.ItemID = IT.ID64
WHERE IT.RefItemID = 24670 AND IT.Data >= 5000
[Help] SQL Query 03/02/2019 - SRO Private Server - 17 Replies i used this query to fix problem, that mobs don't spawn
but it missed up my npc's places. new uniques places added. and reseted it to the basic DB.
here's the query i want to reverse it, or disable it.
NOTE: i can't restore the DB.
here's the query
DELETE FROM ..
USE
GO
[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
[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