Code:
IF (@Operation = 41 and [MENTION=1134588]item[/MENTION]RefID In(98890408,98890409,98890410,98890411,98890412,98890413,98890414,98890415,98890424,998890408,98890416,98890417,98890418,98890419,98890420))
BEGIN
DECLARE
[MENTION=1956629]chestt[/MENTION]able VARCHAR(MAX), [MENTION=806297]sql[/MENTION]Comm NVARCHAR(MAX)
SET [MENTION=1956629]chestt[/MENTION]able =
CASE [MENTION=1134588]item[/MENTION]RefID
WHEN 98890408 THEN '_DG10ModelsChest' WHEN 98890409 THEN '_EGYAModelsChest'
WHEN 98890410 THEN '_EGYBModelsChest' WHEN 98890411 THEN '_DG11ModelsChest'
WHEN 98890412 THEN '_DG12ModelsChest' WHEN 98890413 THEN '_DG13ModelsChest'
WHEN 98890414 THEN '_DG14ModelsChest' WHEN 98890415 THEN '_DG15ModelsChest'
WHEN 998890408 THEN '_DG16ModelsChest' WHEN 98890416 THEN '_DG17ModelsChest'
WHEN 98890417 THEN '_DG18ModelsChest' WHEN 98890418 THEN '_DG19ModelsChest'
WHEN 98890419 THEN '_DG20ModelsChest' WHEN 98890420 THEN '_DG21ModelsChest'
ELSE '_DG18ModelsChest_SpecialOnes'
END;
SET [MENTION=806297]sql[/MENTION]Comm = 'DECLARE [MENTION=1920592]Succ[/MENTION]Rate INT, [MENTION=2331165]Codename12[/MENTION]8 VARCHAR (128),
[MENTION=5724309]DG10[/MENTION]ModelsChestCharName VARCHAR(64), [MENTION=323292]nameS[/MENTION]TR128 VARCHAR(128),
[MENTION=1920592]Succ[/MENTION]Notification VARCHAR(MAX), [MENTION=656255]fail[/MENTION]Notification VARCHAR(MAX), [MENTION=1138848]modeli[/MENTION]temID INT,
[MENTION=3340698]Highest[/MENTION]Possibility INT = 50,
[MENTION=637345]lowes[/MENTION]tPossibility INT = 48
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Rate = ROUND(RAND()* [MENTION=3340698]Highest[/MENTION]Possibility - [MENTION=637345]lowes[/MENTION]tPossibility) + [MENTION=637345]lowes[/MENTION]tPossibility, 0)
SELECT TOP 1 [MENTION=5724309]DG10[/MENTION]ModelsChestCharName = (SELECT [CharName16] from SRO_VT_SHARD.._Char where [CharID] = '+ CAST(@CharID AS NVARCHAR) + ');
SELECT TOP 1 [MENTION=2331165]Codename12[/MENTION]8 = (SELECT TOP 1 [CodeName128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [SuccRate] = [MENTION=1920592]Succ[/MENTION]Rate ORDER BY NEWID())
SELECT TOP 1 [MENTION=323292]nameS[/MENTION]TR128 = ( SELECT [NameStr128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [CodeName128] [MENTION=2331165]Codename12[/MENTION]8)
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Notification = FORMATMESSAGE(''[%s] Cracked Models Chest and won [%s].'', [MENTION=5724309]DG10[/MENTION]ModelsChestCharName, [MENTION=323292]nameS[/MENTION]TR128)
SELECT TOP 1 [MENTION=656255]fail[/MENTION]Notification = FORMATMESSAGE(''Failed to crack Models Chest, Goodluck next time.'')
SELECT TOP 1 [MENTION=1138848]modeli[/MENTION]temID = (SELECT [ID] FROM SRO_VT_SHARD.dbo.[_RefObjCommon] Where CodeName128 [MENTION=2331165]Codename12[/MENTION]8)
IF [MENTION=1920592]Succ[/MENTION]Rate = 50
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC SRO_VT_ZYENO.[dbo].[_InstantAddOrRemoveItemChest] 1,'+ CAST(@CharID AS NVARCHAR) +' [MENTION=1138848]modeli[/MENTION]temID,1,0,0,''Models Chest''
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 3 [MENTION=1920592]Succ[/MENTION]Notification,''true'','''',''true'',''false'',0
END
ELSE
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 0 [MENTION=656255]fail[/MENTION]Notification,''false'' [MENTION=5724309]DG10[/MENTION]ModelsChestCharName,''false'',''true'',0
END
'
EXEC sp_executesql [MENTION=806297]sql[/MENTION]Comm;
END