USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_Job_Coin] Script Date: 4/15/2016 7:48:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================
CREATE procedure [dbo].[_Job_Coin]
@CharID int
as
---------- Main & Select Declares ----------------------
DECLARE @JobType int ,@Contri bigint ,@CurLevel int ,@UserJID int , @Points int ,@CharName varchar(20),@Reqlevel int,@Reward_1_3Star varchar(max),@Reward_2_3Star varchar(max),@Reward_3_3Star varchar(max),@Num_1_3Star int,@Num_2_3Star int,@Num_3_3Star int
,@Reward_1_4Star varchar(max),@Reward_2_4Star varchar(max),@Reward_3_4Star varchar(max),@Num_1_4Star int,@Num_2_4Star int,@Num_3_4Star int,@Gold_3Star bigint,@Gold_4Star bigint,@Gold_5Star bigint
,@Reward_1_5Star varchar(max),@Reward_2_5Star varchar(max),@Reward_3_5Star varchar(max),@Num_1_5Star int,@Num_2_5Star int,@Num_3_5Star int,@Gold_2Star bigint,@Gold_1Star bigint
,@Reward_1_2Star varchar(max),@Reward_2_2Star varchar(max),@Reward_3_2Star varchar(max),@Num_1_2Star int,@Num_2_2Star int,@Num_3_2Star int
,@Reward_1_1Star varchar(max),@Reward_2_1Star varchar(max),@Reward_3_1Star varchar(max),@Num_1_1Star int,@Num_2_1Star int,@Num_3_1Star int
Set @JobType = (Select JobType From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @CurLevel = (Select CurLevel From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Set @UserJID = (Select userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID)
Set @Contri = (Select Contribution From [SRO_VT_SHARD].[dbo].[_CharTrijob] where CharID=@CharID)
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Set @CharName =(Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
Declare @Remaingold bigint = (Select RemainGold From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
---------- Start Trader System ----------------------
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3_1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='1'
/* 1 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '2420' And '48400')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END
/* 2 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '50820' And '87120')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END
/* 3 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '89540' And '137940')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='1'
END
END
/* 4 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '140360' And '205700')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='1'
END
END
/* 5 Star Section */
IF (@JobType = '1' AND @Contri BETWEEN '208120' And '384780')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'1','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='1'
END
END
---------- End Trader System ----------------------
----------- Start Hunter System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3_1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='3'
/* 1 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '1776' And '35520')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END
/* 2 Star Section */
IF (@JobType = '3' AND @Contri BETWEEN '37296' And '63936')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END
/* 3 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '65712' And '101232')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='3'
END
END
/* 4 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '103008' And '150960')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='3'
END
END
/* 5 Star Section */
IF (@JobType = '3' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '152736' And '282384')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'3','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='3'
END
END
----------- End Hunter System ------------------------
----------- Start Thieves System ----------------------
Set @Points = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Select @Reqlevel=Curlevel , @Reward_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star ,@Reward_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star ,@Reward_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
,@Reward_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star ,@Reward_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star ,@Reward_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
,@Reward_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star ,@Reward_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star ,@Reward_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
,@Reward_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star ,@Reward_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star ,@Reward_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
,@Reward_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star ,@Reward_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star ,@Reward_3_1Star=Reward_3_1Star,@Num_3_1Star=Num_3_1Star From [SRO_VT_SHARDLOG].[dbo].[Job_Reward] where JopType='2'
/* 1 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '6128' And '122560')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_1Star,@Num_3_1Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 1, ur points not increased',Getdate())
END
/* 2 Star Section */
IF (@JobType = '2' AND @Contri BETWEEN '128688' And '220608')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_2Star,@Num_3_2Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 2, ur points not increased',Getdate())
END
/* 3 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '226736' And '349296')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_3Star,@Num_3_3Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 3, ur point now increased +1',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','1')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 1 where CharID=@CharID And JopType='2'
END
END
/* 4 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '355424' And '520880')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_4Star,@Num_3_4Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 4, ur point now increased +2',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','2')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 2 where CharID=@CharID And JopType='2'
END
END
/* 5 Star Section */
IF (@JobType = '2' AND @CurLevel >= @Reqlevel AND @Contri BETWEEN '527008' And '974352')
BEGIN
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = @Remaingold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,@Reward_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'u have achieved star 5, ur point now increased +3',Getdate())
IF Not EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] ([CharID],[Charname],[JopType],[Points]) Values (@CharID,@CharName,'2','3')
END
IF EXISTS (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2')
BEGIN
UPDATE [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] Set charname=@Charname , Points=@Points + 3 where CharID=@CharID And JopType='2'
END
END
----------- End Thieves System ------------------------
GO
