omar1778
29-12-2018, 09:26 PM
السلام عليكم انا عملت حاجه كده علي السريع Kill GM ~ HIDE N Seek ب سيلك و سيلك من ال Uniques kills و titles
https://mega.nz/#!oLIDzQ4a!N-Ygr9As7pEUPVop6UoFYRRvQ9vNdahJ7VERjEkq3yY
--GM Kill
IF (@EventID=20 and @CharID=7846)
DECLARE @KilledCharName VARCHAR(512) = @Desc
SELECT @KilledCharName = REPLACE(@KilledCharName, LEFT(@KilledCharName, CHARINDEX('(', @KilledCharName)), '')
SELECT @KilledCharName = REPLACE(@KilledCharName, RIGHT(@KilledCharName, CHARINDEX(')', REVERSE(@KilledCharName))), '')
declare @K_ID INT = (SELECT CharID FROM SRO_VT_SHARD.._Char WHERE CharName16=@KilledCharName)
declare @UserJID INT =(SELECT USERJID FROM SRO_VT_SHARD.._User WHERE CharID=@K_ID)
declare @silk int
set @silk=100
BEGIN
insert into DIEGO_EVENTS.._LogGM values (@KilledCharName)
END
هزود ده في _AddLogChar
ال DB شغاله علي vsro multi tools
https://mega.nz/#!oLIDzQ4a!N-Ygr9As7pEUPVop6UoFYRRvQ9vNdahJ7VERjEkq3yY
--GM Kill
IF (@EventID=20 and @CharID=7846)
DECLARE @KilledCharName VARCHAR(512) = @Desc
SELECT @KilledCharName = REPLACE(@KilledCharName, LEFT(@KilledCharName, CHARINDEX('(', @KilledCharName)), '')
SELECT @KilledCharName = REPLACE(@KilledCharName, RIGHT(@KilledCharName, CHARINDEX(')', REVERSE(@KilledCharName))), '')
declare @K_ID INT = (SELECT CharID FROM SRO_VT_SHARD.._Char WHERE CharName16=@KilledCharName)
declare @UserJID INT =(SELECT USERJID FROM SRO_VT_SHARD.._User WHERE CharID=@K_ID)
declare @silk int
set @silk=100
BEGIN
insert into DIEGO_EVENTS.._LogGM values (@KilledCharName)
END
هزود ده في _AddLogChar
ال DB شغاله علي vsro multi tools