[CLUB]
KGUARDDAN MAGİC POPTAN ÇIKINCA NOTİCE GEÇMESİ KODU;
Kod:
IF @Operation =112 AND @Slot_To=1 AND @ItemRefID=9239 -- Magic Pop Win Notice
BEGIN
DECLARE @StartIndex INT, @EndIndex INT , @RewardItemID INT , @ItemName VARCHAR(128),@CharName16 VARCHAR(64),@Message VARCHAR(128)
SET @StartIndex = PATINDEX('%[0-9]%', @strDesc)
SET @EndIndex = PATINDEX('%[^0-9]%', SUBSTRING(@strDesc, @startIndex, LEN(@strDesc)))
SET @RewardItemID = (SELECT SUBSTRING(@strDesc, @startIndex, @endIndex - 1))
SET @CharName16= (SELECT CharName16 FROM SRO_VT_SHARD.._Char WITH (NOLOCK) WHERE CharID=@CharID)
SET @ItemName = (CASE
WHEN @RewardItemID = 9374 THEN 'Gold Dragon Flag (M)'
WHEN @RewardItemID = 9375 THEN 'Gold Dragon Flag (F)'
WHEN @RewardItemID = 24411 THEN 'Devil''s Spirit S grade (M)'
WHEN @RewardItemID = 24412 THEN 'Devil''s Spirit S grade (F)'
WHEN @RewardItemID = 11287 THEN 'Capricorn Grand Cross'
WHEN @RewardItemID = 11323 THEN 'Capricorn Saint Splendor'
WHEN @RewardItemID = 11395 THEN 'Capricorn Luminous Relic'
WHEN @RewardItemID = 11251 THEN 'Capricorn Justice'
WHEN @RewardItemID = 11467 THEN 'Capricorn Gia Brain'
WHEN @RewardItemID = 11503 THEN 'Capricorn Seraphim Praise'
WHEN @RewardItemID = 11539 THEN 'Capricorn Sacred Wing'
WHEN @RewardItemID = 11431 THEN 'Capricorn DemonicLuster'
WHEN @RewardItemID = 11611 THEN 'Capricorn Heavenly Scutum'
WHEN @RewardItemID = 11359 THEN 'Capricorn Ruined Hell'
WHEN @RewardItemID = 4116 THEN 'Reaper Soul Spear'
WHEN @RewardItemID = 4188 THEN 'Mirage Illusion Bow'
WHEN @RewardItemID = 4152 THEN 'Horyeokbongin Polearm'
WHEN @RewardItemID = 4044 THEN 'Reaper Ghost Sword'
WHEN @RewardItemID = 4080 THEN 'Strom Adamantine Blade'
WHEN @RewardItemID = 4224 THEN 'Splinter Blade Shield'
ELSE '' END)
IF @ItemName IS NOT NULL
BEGIN
INSERT INTO KGuardEDGE.._DeveloperCommands(Cmd,Data1,Data2) VALUES ('server_sendrednote','Congratulations! ['+@CharName16+'] won ['+@ItemName+'] from Magic Pop.',' ')
END
END
[/CLUB]
KGUARDDAN MAGİC POPTAN ÇIKINCA NOTİCE GEÇMESİ KODU;
Kod:
IF @Operation =112 AND @Slot_To=1 AND @ItemRefID=9239 -- Magic Pop Win Notice
BEGIN
DECLARE @StartIndex INT, @EndIndex INT , @RewardItemID INT , @ItemName VARCHAR(128),@CharName16 VARCHAR(64),@Message VARCHAR(128)
SET @StartIndex = PATINDEX('%[0-9]%', @strDesc)
SET @EndIndex = PATINDEX('%[^0-9]%', SUBSTRING(@strDesc, @startIndex, LEN(@strDesc)))
SET @RewardItemID = (SELECT SUBSTRING(@strDesc, @startIndex, @endIndex - 1))
SET @CharName16= (SELECT CharName16 FROM SRO_VT_SHARD.._Char WITH (NOLOCK) WHERE CharID=@CharID)
SET @ItemName = (CASE
WHEN @RewardItemID = 9374 THEN 'Gold Dragon Flag (M)'
WHEN @RewardItemID = 9375 THEN 'Gold Dragon Flag (F)'
WHEN @RewardItemID = 24411 THEN 'Devil''s Spirit S grade (M)'
WHEN @RewardItemID = 24412 THEN 'Devil''s Spirit S grade (F)'
WHEN @RewardItemID = 11287 THEN 'Capricorn Grand Cross'
WHEN @RewardItemID = 11323 THEN 'Capricorn Saint Splendor'
WHEN @RewardItemID = 11395 THEN 'Capricorn Luminous Relic'
WHEN @RewardItemID = 11251 THEN 'Capricorn Justice'
WHEN @RewardItemID = 11467 THEN 'Capricorn Gia Brain'
WHEN @RewardItemID = 11503 THEN 'Capricorn Seraphim Praise'
WHEN @RewardItemID = 11539 THEN 'Capricorn Sacred Wing'
WHEN @RewardItemID = 11431 THEN 'Capricorn DemonicLuster'
WHEN @RewardItemID = 11611 THEN 'Capricorn Heavenly Scutum'
WHEN @RewardItemID = 11359 THEN 'Capricorn Ruined Hell'
WHEN @RewardItemID = 4116 THEN 'Reaper Soul Spear'
WHEN @RewardItemID = 4188 THEN 'Mirage Illusion Bow'
WHEN @RewardItemID = 4152 THEN 'Horyeokbongin Polearm'
WHEN @RewardItemID = 4044 THEN 'Reaper Ghost Sword'
WHEN @RewardItemID = 4080 THEN 'Strom Adamantine Blade'
WHEN @RewardItemID = 4224 THEN 'Splinter Blade Shield'
ELSE '' END)
IF @ItemName IS NOT NULL
BEGIN
INSERT INTO KGuardEDGE.._DeveloperCommands(Cmd,Data1,Data2) VALUES ('server_sendrednote','Congratulations! ['+@CharName16+'] won ['+@ItemName+'] from Magic Pop.',' ')
END
END
[/CLUB]
