[Release] Some Querys

[Vision Sro]

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

[Mohamed Yakout]

how works ?

[Vision Sro]

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 ..

[Mohamed Yakout]

i mean this query in sro vt account or shard

[Vision Sro]

SRO_VT_SHARD most querys in SHARD

[Mohamed Yakout]

ok sir, can i have another querys ?

[Vision Sro]

nevermind bro .. just tell me which query u want

[Mohamed Yakout]

query to remove unique

[Vision Sro]

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

[Mohamed Yakout]

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

[Vision Sro]

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

[Mohamed Yakout]

which one, VT_SHARD Or ACCOUNT

[Vision Sro]

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

[Mohamed Yakout]

ok can i have more 2 querys :X|

[Vision Sro]

sure