11-08-2017, 02:16 AM
|
#9
|
|
|
• الانـتـسـاب » Jul 2017
|
|
• رقـم العـضـويـة » 133179
|
|
• المشـــاركـات » 472
|
|
• الـدولـة » Daquhlia - Mansoura
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
رد: ٍٍSenior Member Scroll #HB
كود:
IF (@Operation = '41') and (@ItemRefID = '47295') --- This scroll is made by #HB
Begin
declare @SeniorMemberOldName varchar(64)
set @SeniorMemberOldName = (select CharName from [SRO_VT_SHARD].dbo.Senior_Member)
declare @SeniorMemberCharID int
set @SeniorMemberCharID = (select CharID from [SRO_VT_SHARD].dbo.Senior_Member)
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set CharName16 = @SeniorMemberOldName where CharID = @SeniorMemberCharID
UPDATE [SRO_VT_SHARD].dbo._Friend Set FriendCharName = @SeniorMemberOldName where FriendCharID = @SeniorMemberCharID
UPDATE [SRO_VT_SHARD].dbo._GuildMember Set CharName = @SeniorMemberOldName where CharID = @SeniorMemberCharID
UPDATE [SRO_VT_SHARD].dbo._Inventory Set ItemID = '252793' where CharID = @CharID AND Slot = '108'
DELETE FROM [SRO_VT_SHARD].dbo.Senior_Member
END
|
|
|
التعديل الأخير تم بواسطة HB# ; 26-08-2017 الساعة 07:57 PM
|