I have this procedure :
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_Job_Coin] Script Date: 4/25/2020 11:10:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================
ALTER procedure [dbo].[_Job_Coin]
@CharID int
as
---------- Main & Select Declares ----------------------
DECLARE @JobType int ,@Contri bigint ,@CurLevel int [MENTION=292919]user[/MENTION]JID int , @Points int ,@CharName varchar(20) [MENTION=1183983]reql[/MENTION]evel int [MENTION=1064142]reward[/MENTION]_1_3Star varchar(max) [MENTION=1064142]reward[/MENTION]_2_3Star varchar(max) [MENTION=1064142]reward[/MENTION]_3_3Star varchar(max),@Num_1_3Star int,@Num_2_3Star int,@Num_3_3Star int
[MENTION=1064142]reward[/MENTION]_1_4Star varchar(max) [MENTION=1064142]reward[/MENTION]_2_4Star varchar(max) [MENTION=1064142]reward[/MENTION]_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
[MENTION=1064142]reward[/MENTION]_1_5Star varchar(max) [MENTION=1064142]reward[/MENTION]_2_5Star varchar(max) [MENTION=1064142]reward[/MENTION]_3_5Star varchar(max),@Num_1_5Star int,@Num_2_5Star int,@Num_3_5Star int,@Gold_2Star bigint,@Gold_1Star bigint
[MENTION=1064142]reward[/MENTION]_1_2Star varchar(max) [MENTION=1064142]reward[/MENTION]_2_2Star varchar(max) [MENTION=1064142]reward[/MENTION]_3_2Star varchar(max),@Num_1_2Star int,@Num_2_2Star int,@Num_3_2Star int
[MENTION=1064142]reward[/MENTION]_1_1Star varchar(max) [MENTION=1064142]reward[/MENTION]_2_1Star varchar(max) [MENTION=1064142]reward[/MENTION]_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 [MENTION=292919]user[/MENTION]JID = (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 [MENTION=508836]remain[/MENTION]gold bigint = (Select RemainGold From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@CharID)
---------- Start Trader System ----------------------
Select [MENTION=1183983]reql[/MENTION]evel=Curlevel , [MENTION=1064142]reward[/MENTION]_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star [MENTION=1064142]reward[/MENTION]_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star [MENTION=1064142]reward[/MENTION]_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
[MENTION=1064142]reward[/MENTION]_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star [MENTION=1064142]reward[/MENTION]_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star [MENTION=1064142]reward[/MENTION]_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
[MENTION=1064142]reward[/MENTION]_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star [MENTION=1064142]reward[/MENTION]_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star [MENTION=1064142]reward[/MENTION]_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
[MENTION=1064142]reward[/MENTION]_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star [MENTION=1064142]reward[/MENTION]_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star [MENTION=1064142]reward[/MENTION]_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
[MENTION=1064142]reward[/MENTION]_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star [MENTION=1064142]reward[/MENTION]_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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')
BEGIN
-- UPDATE SRO_VT_SHARD.dbo._CharTrijob SET Contribution = '0' WHERE CharID = @CharID
-- UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set RemainGold = [MENTION=508836]remain[/MENTION]gold + @Gold_5Star where CharID=@CharID
--EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_5Star,@Num_1_5Star,0
-- EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_5Star,@Num_2_5Star,0
--EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_3_5Star,@Num_3_5Star,0
UPDATE [SRO_VT_SHARD].[dbo].[_CharTrijob] SET Contribution = '0' WHERE CharID = @CharID
declare [MENTION=831308]userid[/MENTION]_2_TOP varchar(64);
SET [MENTION=831308]userid[/MENTION]_2_TOP = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
declare @Charnameunique varchar(64)
Select @Charnameunique=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk_JPOINT] @OrderID = NULL, [MENTION=831308]userid[/MENTION] = [MENTION=831308]userid[/MENTION]_2_TOP, @PkgID = NULL, @NumSilk = '10', @Price = 99
-- exec SRO_VT_SHARD.DBO._ADD_ITEM_EXTERN @Charnameunique,'ITEM_RANDOM_JOBP_SCROLL',1,0
-- 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 [MENTION=1183983]reql[/MENTION]evel=Curlevel , [MENTION=1064142]reward[/MENTION]_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star [MENTION=1064142]reward[/MENTION]_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star [MENTION=1064142]reward[/MENTION]_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
[MENTION=1064142]reward[/MENTION]_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star [MENTION=1064142]reward[/MENTION]_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star [MENTION=1064142]reward[/MENTION]_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
[MENTION=1064142]reward[/MENTION]_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star [MENTION=1064142]reward[/MENTION]_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star [MENTION=1064142]reward[/MENTION]_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
[MENTION=1064142]reward[/MENTION]_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star [MENTION=1064142]reward[/MENTION]_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star [MENTION=1064142]reward[/MENTION]_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
[MENTION=1064142]reward[/MENTION]_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star [MENTION=1064142]reward[/MENTION]_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 [MENTION=1183983]reql[/MENTION]evel=Curlevel , [MENTION=1064142]reward[/MENTION]_1_3Star=Reward_1_3Star ,@Num_1_3Star=Num_1_3Star [MENTION=1064142]reward[/MENTION]_2_3Star=Reward_2_3Star,@Num_2_3Star=Num_2_3Star [MENTION=1064142]reward[/MENTION]_3_3Star=Reward_3_3Star,@Num_3_3Star=Num_3_3Star
[MENTION=1064142]reward[/MENTION]_1_4Star=Reward_1_4Star ,@Num_1_4Star=Num_1_4Star [MENTION=1064142]reward[/MENTION]_2_4Star=Reward_2_4Star,@Num_2_4Star=Num_2_4Star [MENTION=1064142]reward[/MENTION]_3_4Star=Reward_3_4Star,@Num_3_4Star=Num_3_4Star,@Gold_3Star = Gold_3Star,@Gold_4Star = Gold_4Star,@Gold_5Star = Gold_5Star
[MENTION=1064142]reward[/MENTION]_1_5Star=Reward_1_5Star ,@Num_1_5Star=Num_1_5Star [MENTION=1064142]reward[/MENTION]_2_5Star=Reward_2_5Star,@Num_2_5Star=Num_2_5Star [MENTION=1064142]reward[/MENTION]_3_5Star=Reward_3_5Star,@Num_3_5Star=Num_3_5Star,@Gold_2Star = Gold_2Star
[MENTION=1064142]reward[/MENTION]_1_2Star=Reward_1_2Star ,@Num_1_2Star=Num_1_2Star [MENTION=1064142]reward[/MENTION]_2_2Star=Reward_2_2Star,@Num_2_2Star=Num_2_2Star [MENTION=1064142]reward[/MENTION]_3_2Star=Reward_3_2Star,@Num_3_2Star=Num_3_2Star,@Gold_1Star = Gold_1Star
[MENTION=1064142]reward[/MENTION]_1_1Star=Reward_1_1Star ,@Num_1_1Star=Num_1_1Star [MENTION=1064142]reward[/MENTION]_2_1Star=Reward_2_1Star,@Num_2_1Star=Num_2_1Star [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_1Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_1Star,@Num_1_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_1Star,@Num_2_1Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 = [MENTION=508836]remain[/MENTION]gold + @Gold_2Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_2Star,@Num_1_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_2Star,@Num_2_2Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_3Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_3Star,@Num_1_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_3Star,@Num_2_3Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_4Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_4Star,@Num_1_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_4Star,@Num_2_4Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 >= [MENTION=1183983]reql[/MENTION]evel 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 = [MENTION=508836]remain[/MENTION]gold + @Gold_5Star where CharID=@CharID
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_1_5Star,@Num_1_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_2_5Star,@Num_2_5Star,0
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName [MENTION=1064142]reward[/MENTION]_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 ------------------------
all works well but i should restart the client after finish the trade/hunter/thiefs and the reall and big problem is.. cuz if i finish a trade/hunter/thief every time when i restart the client i get 10 points ... how can i fix it ? Thanks
