[Release] Some Querys

here you go ..
Declare @CharName VarChar(max)
Declare @Level BigInt
SET @CharName= '’Marwan Abbas' --CharName
SET @Level = '120' --Level
UPDATE [Dbo].[_Char]
SET InventorySize = '109', --Iventory Size Min 45 max 109
RemainGold = RemainGold + '1', --GOLD to give
HwanLevel = '0', --Zerk Level ( 0 to none )
RemainSkillPoint = RemainSkillPoint + '101000', --SkillPoint to give
CurLevel = @Level,
MaxLevel = @Level,
Strength = @Level+19,
Intellect = @Level+19,
RemainStatPoint = @Level * 3 -3,
RemainHwanCount = 5, --RemainHwanCount
ExpOffset = 1-- Exp
WHERE CharName16 = @CharName

how works ?

its so easy .. take a look on the words
Charname= .. ur char name
level and inventory size remaingold .. hwanlevel = zerk level dat yellow name etc ..

i mean this query in sro vt account or shard

SRO_VT_SHARD most querys in SHARD

ok sir, can i have another querys ?

nevermind bro .. just tell me which query u want

query to remove unique

Use SRO_VT_SHARD
Declare @RefMobID Int , @TacticsID Int , @HiveID Int , @MonsterCodeName Varchar(128)
Set @MonsterCodeName = 'Unique CodeName128'
Set @RefMobID = (Select ID From dbo._RefObjCommon Where CodeName128 = @MonsterCodeName)
Set @TacticsID = (Select dwTacticsID From dbo.Tab_RefTactics Where dwObjID = @RefMobID)
Set @HiveID = (Select dwHiveID From dbo.Tab_RefNest Where dwTacticsID = @TacticsID)
Delete From dbo.Tab_RefNest Where dwTacticsID = @TacticsID and dwHiveID = @HiveID
Delete From dbo.Tab_RefHive Where dwHiveID = @HiveID
Delete From dbo.Tab_RefTactics Where dwObjID = @RefMobID and dwTacticsID = @TacticsID

kinda hard for u but just focus .. u will realize how to do it

yeah its so hard xD
ok can i have query to remove prem from someone

DECLARE @CharName Varchar (MAX)
DECLARE @CharID INT
SET @CharName = 'Write here player name'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
DELETE FROM _TimedJob WHERE CharID = @CharID

just write player name and press execute then tell him to teleport

which one, VT_SHARD Or ACCOUNT

SHARD bro ..
if its ACCOUNT i will let you know

ok can i have more 2 querys :X|

sure