[Release]Query fast adding item to npc. 05/21/2016 - SRO PServer Guides & Releases - 12 Replies Today I'd like to share a query with you. This query will quickly add an item to an NPC - test it and rate it.
USE
----------By Nefetis--------------
DECLARE @PRICETYPE VARCHAR (70)
DECLARE @PRICE VARCHAR (70)
DECLARE @TAB VARCHAR (70)
DECLARE @CODENAME128 VARCHAR (70)
DECLARE @OPTLEVEL VARCHAR (70)
Query to reset gold 07/06/2013 - Shaiya PServer Development - 3 Replies Hello, i need a query to sql to remove all gold from my serwer.. :P
Its very important for me.
*for all toons*
Fast Query to Add Drops in Mob , Unique or what ever ^^ 09/13/2012 - SRO PServer Guides & Releases - 1 Replies To get mob ID use this Query
Change MOB_RM_ROC With your Monster or Unique Code
To get ITEM ID use this Query
Reset All Players to a Spot in GameWorld (Small Query) 01/03/2012 - SRO Private Server - 3 Replies UPDATE _Char
SET LatestRegion = '25416',
PosX = '779.661',
PosY = '3.081456',
PosZ = '1575.07068',
AppointedTeleport = '27754',
WorldID = '1'
(change only the current player place ~ so if he reverse to last died place or last recall place will spawn at the place he recalled or died)
![Help fast please [Query reset GOld]](https://www.elitepvpers.com/forum/iconimages/sro-private-server/help-fast-please-query-reset-gold_ltr.gif){kind=small}
