HLP
27-12-2015, 03:24 PM
سلام عليكم
الموضوع ممكن يكون موجود بسكرول بس انا حبيت اعمله بطريقة جديدة
الموضوع بيان من عنوانه
remove adv & Blue Avatar & Maximum BY Message
يعني الاعب يبعت رسالة لنفسه فيها Adv او blue Avatar او Maximum و يعمل تيلبورت
وبعد ما الاعب بيعت الرسالة بيجله pm بيقوله Done Teleport Please عن طريق برنامج vSro Multi Tool by iLegend
Link (https://mega.nz/#!2hY0ATDD!8n6b8FpqXUgQLqeUjHFUL_MlDT7Ykz__9uWMjlv 39N8)
_Memo_Add
-- remove blue avatar by HLP
If (@TargetCharName like @SenderCharName and @Message = 'blue avatar' )
DECLARE @CharID int
DECLARE @charname varchar (68)
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
begin
Update SRO_VT_SHARD.dbo._Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from SRO_VT_SHARD.dbo._InventoryForAvatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
------------------
--Remove Maximum by HLP
If (@TargetCharName like @SenderCharName and @Message = 'Maximum' )
begin
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
Update SRO_VT_SHARD.dbo._Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 999999999)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
-------------------------------
--Remover ADV by HLP
If (@TargetCharName like @SenderCharName and @Message = 'ADV' )
begin
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
begin
DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory
WHERE CharID=@CharID AND slot = 13) and bOptType=2
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
end
الموضوع ممكن يكون موجود بسكرول بس انا حبيت اعمله بطريقة جديدة
الموضوع بيان من عنوانه
remove adv & Blue Avatar & Maximum BY Message
يعني الاعب يبعت رسالة لنفسه فيها Adv او blue Avatar او Maximum و يعمل تيلبورت
وبعد ما الاعب بيعت الرسالة بيجله pm بيقوله Done Teleport Please عن طريق برنامج vSro Multi Tool by iLegend
Link (https://mega.nz/#!2hY0ATDD!8n6b8FpqXUgQLqeUjHFUL_MlDT7Ykz__9uWMjlv 39N8)
_Memo_Add
-- remove blue avatar by HLP
If (@TargetCharName like @SenderCharName and @Message = 'blue avatar' )
DECLARE @CharID int
DECLARE @charname varchar (68)
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
begin
Update SRO_VT_SHARD.dbo._Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from SRO_VT_SHARD.dbo._InventoryForAvatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
------------------
--Remove Maximum by HLP
If (@TargetCharName like @SenderCharName and @Message = 'Maximum' )
begin
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
Update SRO_VT_SHARD.dbo._Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 999999999)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
-------------------------------
--Remover ADV by HLP
If (@TargetCharName like @SenderCharName and @Message = 'ADV' )
begin
set @CharID = (select CHARid from _Char where CharName16 = @SenderCharName)
set @charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @charid)
begin
DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory
WHERE CharID=@CharID AND slot = 13) and bOptType=2
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Done Teleport Please',Getdate())
end
end