USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 20/05/2015 12:17:08 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
--Start All Produc's Storxy-
---------------------------------------------------------------------------------------------------------
declare @lottery_coins int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '5' order by newid())
declare @charnamme_test varchar (50)=(select charname16 from _char where CharID=@CharID)
if(@JobID = '70061') --Storxy Coins (LOW)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_1 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '5' and '20' order by newid())
if(@JobID = '70062') --Storxy Coins (Normal)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_1,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_2 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '25' and '35' order by newid())
if(@JobID = '70063') --Storxy Coins (Max)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_2,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_3 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '10' order by newid())
if(@JobID = '70064') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_11',@lottery_co ins_3,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_4 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '10' order by newid())
if(@JobID = '70065') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_11',@lottery_c oins_4,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_5 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())
if(@JobID = '70066') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B',@lot tery_coins_5,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_6 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())
if(@JobID = '70067') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ARMOR_B',@lott ery_coins_6,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_7 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())
if(@JobID = '70068') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_SHIELD_B',@lot tery_coins_7,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_8 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '1' and '25' order by newid())
if(@JobID = '70069') --
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B',@ lottery_coins_8,1
end
---------------------------------------------------------------------------------------------------------
declare @lottery_coins_9 int=(select top 1 amount from SRO_VT_SHARDLOG..lottery_coins where id between '25' and '35' order by newid())
if(@JobID = '59754') --Storxy Coins (Max)
begin
exec _ADD_ITEM_EXTERN @charnamme_test ,'ITEM_ETC_SD_TOKEN_01',@lottery_coins_9,1
end
---------------------------------------------------------------------------------------------------------
if(@JobID = '59752') -- 10M SP
begin
update _Char set RemainSkillPoint = RemainSkillPoint+'10000000' where CharID = @CharID -- I don't want the title i just want the blue zerk.
end
---------------------------------
if(@JobID= '59749')-- Holy temple remove
begin
delete from _CharInstanceWorldData where CharID= @CharID
return -3
end
if(@JobID= '59750') --Remover Blue Avatar
begin
Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventoryforavatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
return -3
end
if(@JobID = '59751') -- Pk Remover
begin
Update _Char Set DailyPK = 0 Where CharID = @CharID
Update _Char Set TotalPK = 0 Where CharID = @CharID
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID
return -3
end
if(@JobID= '59753') --Remover Adv
begin
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot like '6' and bOptType=2 AND CharID=@CharID)
end
--End All Bluemoon Scrolls Producs By Storxy--
if(@JobID = '59701')
BEGIN
UPDATE dbo._Char SET HwanLevel = 32 Where CharID = @CharID
END
if(@JobID = '59702')
BEGIN
UPDATE dbo._Char SET HwanLevel = 33 Where CharID = @CharID
END
if(@JobID = '59703')
BEGIN
UPDATE dbo._Char SET HwanLevel = 34 Where CharID = @CharID
END
if(@JobID = '59704')
BEGIN
UPDATE dbo._Char SET HwanLevel = 35 Where CharID = @CharID
END
if(@JobID = '59705')
BEGIN
UPDATE dbo._Char SET HwanLevel = 36 Where CharID = @CharID
END
if(@JobID = '59706')
BEGIN
UPDATE dbo._Char SET HwanLevel = 37 Where CharID = @CharID
END
if(@JobID = '59707')
BEGIN
UPDATE dbo._Char SET HwanLevel = 38 Where CharID = @CharID
END
if(@JobID = '59708')
BEGIN
UPDATE dbo._Char SET HwanLevel = 39 Where CharID = @CharID
END
if(@JobID = '59709')
BEGIN
UPDATE dbo._Char SET HwanLevel = 40 Where CharID = @CharID
END
if(@JobID = '59710')
BEGIN
UPDATE dbo._Char SET HwanLevel = 41 Where CharID = @CharID
END
if(@JobID = '59711')
BEGIN
UPDATE dbo._Char SET HwanLevel = 42 Where CharID = @CharID
END
if(@JobID = '59712')
BEGIN
UPDATE dbo._Char SET HwanLevel = 43 Where CharID = @CharID
END
if(@JobID = '59713')
BEGIN
UPDATE dbo._Char SET HwanLevel = 44 Where CharID = @CharID
END
if(@JobID = '59714')
BEGIN
UPDATE dbo._Char SET HwanLevel = 45 Where CharID = @CharID
END
if(@JobID = '59715')
BEGIN
UPDATE dbo._Char SET HwanLevel = 46 Where CharID = @CharID
END
if(@JobID = '59716')
BEGIN
UPDATE dbo._Char SET HwanLevel = 47 Where CharID = @CharID
END
if(@JobID = '59717')
BEGIN
UPDATE dbo._Char SET HwanLevel = 48 Where CharID = @CharID
END
if(@JobID = '59718')
BEGIN
UPDATE dbo._Char SET HwanLevel = 49 Where CharID = @CharID
END
if(@JobID = '59719')
BEGIN
UPDATE dbo._Char SET HwanLevel = 50 Where CharID = @CharID
END
if(@JobID = '59720')
BEGIN
UPDATE dbo._Char SET HwanLevel = 51 Where CharID = @CharID
END
if(@JobID = '59721')
BEGIN
UPDATE dbo._Char SET HwanLevel = 52 Where CharID = @CharID
END
if(@JobID = '59722')
BEGIN
UPDATE dbo._Char SET HwanLevel = 53 Where CharID = @CharID
END
if(@JobID = '59723')
BEGIN
UPDATE dbo._Char SET HwanLevel = 54 Where CharID = @CharID
END
if(@JobID = '59724')
BEGIN
UPDATE dbo._Char SET HwanLevel = 55 Where CharID = @CharID
END
if(@JobID = '59725')
BEGIN
UPDATE dbo._Char SET HwanLevel = 56 Where CharID = @CharID
END
if(@JobID = '59726')
BEGIN
UPDATE dbo._Char SET HwanLevel = 57 Where CharID = @CharID
END
if(@JobID = '59727')
BEGIN
UPDATE dbo._Char SET HwanLevel = 58 Where CharID = @CharID
END
if(@JobID = '59728')
BEGIN
UPDATE dbo._Char SET HwanLevel = 59 Where CharID = @CharID
END
if(@JobID = '59729')
BEGIN
UPDATE dbo._Char SET HwanLevel = 60 Where CharID = @CharID
END
if(@JobID = '59730')
BEGIN
UPDATE dbo._Char SET HwanLevel = 61 Where CharID = @CharID
END
if(@JobID = '59731')
BEGIN
UPDATE dbo._Char SET HwanLevel = 62 Where CharID = @CharID
END
if(@JobID = '59732')
BEGIN
UPDATE dbo._Char SET HwanLevel = 63 Where CharID = @CharID
END
if(@JobID = '59733')
BEGIN
UPDATE dbo._Char SET HwanLevel = 64 Where CharID = @CharID
END
if(@JobID = '59734')
BEGIN
UPDATE dbo._Char SET HwanLevel = 65 Where CharID = @CharID
END
if(@JobID = '59735')
BEGIN
UPDATE dbo._Char SET HwanLevel = 66 Where CharID = @CharID
END
if(@JobID = '59736')
BEGIN
UPDATE dbo._Char SET HwanLevel = 67 Where CharID = @CharID
END
if(@JobID = '59737')
BEGIN
UPDATE dbo._Char SET HwanLevel = 68 Where CharID = @CharID
END
if(@JobID = '59738')
BEGIN
UPDATE dbo._Char SET HwanLevel = 69 Where CharID = @CharID
END
if(@JobID = '59739')
BEGIN
UPDATE dbo._Char SET HwanLevel = 70 Where CharID = @CharID
END
if(@JobID = '59740')
BEGIN
UPDATE dbo._Char SET HwanLevel = 71 Where CharID = @CharID
END
if(@JobID = '59741')
BEGIN
UPDATE dbo._Char SET HwanLevel = 72 Where CharID = @CharID
END
if(@JobID = '59742')
BEGIN
UPDATE dbo._Char SET HwanLevel = 73 Where CharID = @CharID
END
if(@JobID = '59743')
BEGIN
UPDATE dbo._Char SET HwanLevel = 74 Where CharID = @CharID
END
if(@JobID = '59744')
BEGIN
UPDATE dbo._Char SET HwanLevel = 75 Where CharID = @CharID
END
if(@JobID = '59745')
BEGIN
UPDATE dbo._Char SET HwanLevel = 76 Where CharID = @CharID
END
if(@JobID = '59746')
BEGIN
UPDATE dbo._Char SET HwanLevel = 77 Where CharID = @CharID
END
if(@JobID = '59747')
BEGIN
UPDATE dbo._Char SET HwanLevel = 78 Where CharID = @CharID
END
if(@JobID = '59748')
BEGIN
UPDATE dbo._Char SET HwanLevel = 79 Where CharID = @CharID
END
if(@JobID = '59749')
BEGIN
UPDATE dbo._Char SET HwanLevel = 80 Where CharID = @CharID
END
if(@JobID = '59750')
BEGIN
UPDATE dbo._Char SET HwanLevel = 81 Where CharID = @CharID
END
if(@JobID = '59751')
BEGIN
UPDATE dbo._Char SET HwanLevel = 82 Where CharID = @CharID
END
if(@JobID = '59699')
BEGIN
UPDATE dbo._Char SET HwanLevel = 30 Where CharID = @CharID
END
if(@JobID = '59700')
BEGIN
UPDATE dbo._Char SET HwanLevel = 31 Where CharID = @CharID
END
if(@JobID = '60001')
BEGIN
UPDATE dbo._Char SET HwanLevel = 100 Where CharID = @CharID
END
if(@JobID = '60002')
BEGIN
UPDATE dbo._Char SET HwanLevel = 101 Where CharID = @CharID
END
if(@JobID = '60003')
BEGIN
UPDATE dbo._Char SET HwanLevel = 102 Where CharID = @CharID
END
if(@JobID = '60004')
BEGIN
UPDATE dbo._Char SET HwanLevel = 103 Where CharID = @CharID
END
if(@JobID = '60005')
BEGIN
UPDATE dbo._Char SET HwanLevel = 104 Where CharID = @CharID
END
if(@JobID = '60006')
BEGIN
UPDATE dbo._Char SET HwanLevel = 105 Where CharID = @CharID
END
if(@JobID = '60007')
BEGIN
UPDATE dbo._Char SET HwanLevel = 106 Where CharID = @CharID
END
if(@JobID = '60008')
BEGIN
UPDATE dbo._Char SET HwanLevel = 107 Where CharID = @CharID
END
if(@JobID = '60009')
BEGIN
UPDATE dbo._Char SET HwanLevel = 108 Where CharID = @CharID
END
if(@JobID = '60010')
BEGIN
UPDATE dbo._Char SET HwanLevel = 109 Where CharID = @CharID
END
if(@JobID = '60011')
BEGIN
UPDATE dbo._Char SET HwanLevel = 110 Where CharID = @CharID
END
if(@JobID = '60012')
BEGIN
UPDATE dbo._Char SET HwanLevel = 111 Where CharID = @CharID
END
if(@JobID = '60013')
BEGIN
UPDATE dbo._Char SET HwanLevel = 112 Where CharID = @CharID
END
if(@JobID = '60014')
BEGIN
UPDATE dbo._Char SET HwanLevel = 113 Where CharID = @CharID
END
if(@JobID = '60015')
BEGIN
UPDATE dbo._Char SET HwanLevel = 114 Where CharID = @CharID
END
if(@JobID = '60016')
BEGIN
UPDATE dbo._Char SET HwanLevel = 115 Where CharID = @CharID
END
if(@JobID = '60017')
BEGIN
UPDATE dbo._Char SET HwanLevel = 116 Where CharID = @CharID
END
if(@JobID = '60018')
BEGIN
UPDATE dbo._Char SET HwanLevel = 117 Where CharID = @CharID
END
if(@JobID = '60019')
BEGIN
UPDATE dbo._Char SET HwanLevel = 118 Where CharID = @CharID
END
if(@JobID = '60020')
BEGIN
UPDATE dbo._Char SET HwanLevel = 119 Where CharID = @CharID
END
if(@JobID = '60021')
BEGIN
UPDATE dbo._Char SET HwanLevel = 120 Where CharID = @CharID
END
if(@JobID = '60022')
BEGIN
UPDATE dbo._Char SET HwanLevel = 121 Where CharID = @CharID
END
if(@JobID = '60023')
BEGIN
UPDATE dbo._Char SET HwanLevel = 122 Where CharID = @CharID
END
if(@JobID = '60024')
BEGIN
UPDATE dbo._Char SET HwanLevel = 123 Where CharID = @CharID
END
if(@JobID = '60025')
BEGIN
UPDATE dbo._Char SET HwanLevel = 124 Where CharID = @CharID
END
if(@JobID = '60026')
BEGIN
UPDATE dbo._Char SET HwanLevel = 125 Where CharID = @CharID
END
if(@JobID = '60027')
BEGIN
UPDATE dbo._Char SET HwanLevel = 126 Where CharID = @CharID
END
if(@JobID = '60028')
BEGIN
UPDATE dbo._Char SET HwanLevel = 127 Where CharID = @CharID
END
if(@JobID = '60029')
BEGIN
UPDATE dbo._Char SET HwanLevel = 128 Where CharID = @CharID
END
if(@JobID = '60030')
BEGIN
UPDATE dbo._Char SET HwanLevel = 129 Where CharID = @CharID
END
if(@JobID = '60031')
BEGIN
UPDATE dbo._Char SET HwanLevel = 130 Where CharID = @CharID
END
if(@JobID = '60032')
BEGIN
UPDATE dbo._Char SET HwanLevel = 131 Where CharID = @CharID
END
if(@JobID = '60033')
BEGIN
UPDATE dbo._Char SET HwanLevel = 132 Where CharID = @CharID
END
if(@JobID = '60034')
BEGIN
UPDATE dbo._Char SET HwanLevel = 133 Where CharID = @CharID
END
if(@JobID = '60035')
BEGIN
UPDATE dbo._Char SET HwanLevel = 134 Where CharID = @CharID
END
if(@JobID = '60036')
BEGIN
UPDATE dbo._Char SET HwanLevel = 135 Where CharID = @CharID
END
if(@JobID = '60037')
BEGIN
UPDATE dbo._Char SET HwanLevel = 136 Where CharID = @CharID
END
if(@JobID = '60038')
BEGIN
UPDATE dbo._Char SET HwanLevel = 137 Where CharID = @CharID
END
if(@JobID = '60039')
BEGIN
UPDATE dbo._Char SET HwanLevel = 138 Where CharID = @CharID
END
if(@JobID = '60040')
BEGIN
UPDATE dbo._Char SET HwanLevel = 139 Where CharID = @CharID
END
if(@JobID = '60041')
BEGIN
UPDATE dbo._Char SET HwanLevel = 140 Where CharID = @CharID
END
if(@JobID = '60042')
BEGIN
UPDATE dbo._Char SET HwanLevel = 141 Where CharID = @CharID
END
if(@JobID = '60043')
BEGIN
UPDATE dbo._Char SET HwanLevel = 142 Where CharID = @CharID
END
if(@JobID = '60044')
BEGIN
UPDATE dbo._Char SET HwanLevel = 143 Where CharID = @CharID
END
if(@JobID = '60045')
BEGIN
UPDATE dbo._Char SET HwanLevel = 144 Where CharID = @CharID
END
if(@JobID = '60046')
BEGIN
UPDATE dbo._Char SET HwanLevel = 145 Where CharID = @CharID
END
if(@JobID = '60047')
BEGIN
UPDATE dbo._Char SET HwanLevel = 146 Where CharID = @CharID
END
if(@JobID = '60048')
BEGIN
UPDATE dbo._Char SET HwanLevel = 147 Where CharID = @CharID
END
if(@JobID = '60049')
BEGIN
UPDATE dbo._Char SET HwanLevel = 148 Where CharID = @CharID
END
if(@JobID = '60050')
BEGIN
UPDATE dbo._Char SET HwanLevel = 149 Where CharID = @CharID
END
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##begin due to develop composite item
if (@JobID = 1 or @JobID = 2)
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
---------
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
--##end due to develop composite item
if(@JobID = '59691') -- Mudar nome do char
BEGIN
declare @CharName16 varchar(64)
Select @CharName16=CharName16 from _Char where CharID = @CharID
Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID
return -3
END
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
----