Code:
--- Lottery system --- if( @ItemRefID ='46089' and @Operation = '41') begin -- Gold Lottery !
DECLARE @Upper_Gold INT = '150000000', @Lower_Gold INT = '30000000'
DECLARE @random_Gold INT = ROUND(( @Upper_GOLD - @Lower_GOLD -1) * RAND() + @Lower_GOLD), 0);
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_Gold where CharID = @CharID end
DECLARE @CharName varchar(65) = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if( @ItemRefID ='46091' and @Operation = '41') begin -- Lottery stone
DECLARE @Item_Code1 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._SilkStone_Lot where ID between '1' and '30'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code1,50,0 end end
if( @ItemRefID ='46088' and @Operation = '41') begin -- Lottery Acc
DECLARE @Item_Code Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._LegandAcc where ID between '1' and '12'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code,1,0 end end
if( @ItemRefID ='46087' and @Operation = '41') begin --Lottery Set
DECLARE @Item_Code2 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._LegandSet where ID between '1' and '108'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code2,1,0 end end
if( @ItemRefID ='46086' and @Operation = '41') begin --Lottery Weapon
DECLARE @Item_Code3 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._LegandWeapon where ID between '1' and '32'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code3,1,0 end end
if( @ItemRefID ='46092' and @Operation = '41') begin -- Lottery Gift
DECLARE @Item_Code6 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._FIRYGIFT where ID between '1' and '20'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code6,1,0 end end
DECLARE @Upper_SILK INT = '60', @Lower_SILK INT = '1'
DECLARE @random_SILK INT = ROUND(( @Upper_SILK - @Lower_SILK -1) * RAND() + @Lower_SILK), 0);
DECLARE @userID_14 INT
if( @ItemRefID ='46090' and @Operation = '41') begin -- Lottery Acc
begin
--7--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @userID = @userID_14, @PkgID = NULL, @NumSilk = @random_Gold, @price = 500
END
END
if( @ItemRefID ='46098' and @Operation = '41') begin --Lottery Mob,s 1
DECLARE @MOB_Code15 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB1 where ID between '1' and '14'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code15,1,0 end end
if( @ItemRefID ='46099' and @Operation = '41') begin --Lottery Mob,s 2
DECLARE @MOB_Code16 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB2 where ID between '1' and '14'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code16,1,0 end end
if( @ItemRefID ='46100' and @Operation = '41') begin --Lottery Mob,s 3
DECLARE @MOB_Code17 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB3 where ID between '1' and '14'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code17,1,0 end end
if( @ItemRefID ='46101' and @Operation = '41') begin --Lottery Mob,s 4
DECLARE @MOB_Code18 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB4 where ID between '1' and '14'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code18,1,0 end end
if( @ItemRefID ='46102' and @Operation = '41') begin --Lottery Mob,s 5
DECLARE @MOB_Code19 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB5 where ID between '1' and '14'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code19,1,0 end end
if( @ItemRefID ='46103' and @Operation = '41') begin --Lottery Mob,s 6
DECLARE @MOB_Code20 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB6 where ID between '1' and '17'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code20,1,0 end end
if( @ItemRefID ='46104' and @Operation = '41') begin --Lottery Mob,s7
DECLARE @MOB_Code21 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB7 where ID between '1' and '17'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code21,1,0 end end
if( @ItemRefID ='46105' and @Operation = '41') begin --Lottery Mob,s 8
DECLARE @MOB_Code22 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB8 where ID between '1' and '15'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code22,1,0 end end
if( @ItemRefID ='46106' and @Operation = '41') begin --Lottery Mob,s 9
DECLARE @MOB_Code23 Varchar(256) = (Select top 1 CodeName from SRO_VT_FT.dbo._MOB9 where ID between '1' and '23'
order by NEWID())
if @CharName not like '$%^GM$%^'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName @MOB_Code23,1,0 end end
