المشاركة الأصلية كتبت بواسطة PirateKings
(المشاركة 5264477)
مش شغاال
عملت اللي انت قلت عليه علي الفيس خد الاكواد اهيه بايظ
JobRewardLog
Job_Reward
كود PHP:
1 130 1000000000 2000000000 300000000 4000000000 5000000000 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 50 ITEM_ETC_SD_TOKEN_03 50 ITEM_ETC_SD_TOKEN_01 50 ITEM_ETC_SD_TOKEN_02 100 ITEM_ETC_SD_TOKEN_03 100 ITEM_ETC_SD_TOKEN_01 100 ITEM_ETC_SD_TOKEN_02 150 ITEM_ETC_SD_TOKEN_03 150 ITEM_ETC_SD_TOKEN_01 200 ITEM_ETC_SD_TOKEN_02 200 ITEM_ETC_SD_TOKEN_03 200 ITEM_ETC_SD_TOKEN_01 250 ITEM_ETC_SD_TOKEN_02 250 ITEM_ETC_SD_TOKEN_03 250
Top_Jop_System
كود PHP:
1 50 60 ITEM_ETC_SD_TOKEN_01 500 0 ITEM_ETC_SD_TOKEN_02 500 0 ITEM_ETC_SD_TOKEN_03 500 0 0 0 20 Points
Top_Job_Count
كود PHP:
USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[Top_Job_Count] Script Date: 20/04/2016 04:49:52 ص ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
-- ============================================= -- Author: Abdelrhman Elbattawy -- =============================================
ALTER procedure [dbo].[Top_Job_Count] @CharID int as ---------- Main Declares ---------------------- DECLARE @UserID int = (SELECT userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharID) DECLARE @PointsTR int ,@Top_TR int ,@CharName1 varchar(20),@Points2 int , @Points3 int ,@CharName2 varchar(20) , @CharName3 varchar(20),@HwanTitle1 int ,@PointsHU int ,@PointsTH int ,@Top_HU int ,@Top_TH int ,@HwanTitle int ,@Reward1 varchar(MAX),@Num1 int,@Num2 int,@Num3 int ,@Reward2 varchar(MAX) ,@Reward3 varchar(MAX) , @Notice varchar(Max),@Silkown int,@Plus1 int,@Plus2 int,@Plus3 int,@Silkgift int ,@Count int , @CharNameOld varchar(20) ,@Hwanlevelchange int,@CheckHwanlevel tinyint Set @PointsTR = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='1') Set @PointsHU = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='3') Set @PointsTH = (Select Points From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where CharID=@CharID And JopType='2') ----------- Start Top System --------------------------
/* Start Trader Section */ Set @Top_TR = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='1' Order By Points desc) Set @CharName1 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TR) Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_Own,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '1' Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName1) Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle) Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld) IF @PointsTR >= @Count BEGIN -- Take the title from the player IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1) Begin Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName1,@CheckHwanlevel,@HwanTitle) END IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName1) IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System])) BEGIN UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName1 END UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld -- Adding the title to the new player IF(@HwanTitle > '0') Begin UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName1 END -- Item Reward EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3 EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift -- Notice Lines To show All server this char is Hero insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName1+'*** , '+@Notice+'',GETDATE()) -- Delete Log Unique From Table DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '1' END
/* End Trader Section */
/* Start Thieves Section */ Set @Top_TH = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='2' Order By Points desc) Set @CharName2 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_TH) Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName2) Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_Own,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '2' Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle) Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld) IF @PointsTH >= @Count BEGIN -- Take the title from the player IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2) Begin Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName2,@CheckHwanlevel,@HwanTitle) END IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName2) IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System])) BEGIN UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName2 END UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld -- Adding the title to the new player IF(@HwanTitle > '0') Begin UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName2 END -- Item Reward EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3 EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift -- Notice Lines To show All server this char is Hero insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName2+'*** , '+@Notice+'',GETDATE()) -- Delete Log Unique From Table DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '2' END
/* End Thieves Section */
/* Start Hunter Section */ Set @Top_HU = (Select Top 1 (CharID) From [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType='3' Order By Points desc) Set @CharName3 = (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] where CharID=@Top_HU) Set @CheckHwanlevel = (SELECT HwanLevel FROM [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @CharName3) Select @Count = Points,@Notice=notice,@HwanTitle = HwanLevel ,@Reward1=Reward1,@Reward2=Reward2,@Reward3=Reward3,@Num1=Num1,@Num2=Num2,@Num3=Num3,@Silkown=Silk_Own,@Silkgift=Silk_Gift,@Plus1=Plus1,@Plus2=Plus2,@Plus3=Plus3 From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System] Where JopType = '3' Set @CharNameOld = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanTitle) Set @Hwanlevelchange = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles_Jop] Where CharName=@CharNameOld) IF @PointsHU >= @Count BEGIN -- Take the title from the player IF Not EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3) Begin Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] ([CharName],[OldHwan],[UName]) Values (@CharName3,@CheckHwanlevel,@HwanTitle) END IF EXISTS (Select Oldhwan From SRO_VT_SHARDLOG.dbo._OldTitles_jop where CharName=@CharName3) IF (@CheckHwanlevel Not In (Select Hwanlevel From [SRO_VT_SHARDLOG].[dbo].[Top_Jop_System])) BEGIN UPDATE [SRO_VT_SHARDLOG].[dbo].[_OldTitles_jop] Set OldHwan=@CheckHwanlevel , UName=@HwanTitle where CharName=@CharName3 END UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange where CharName16 = @CharNameOld -- Adding the title to the new player IF(@HwanTitle > '0') Begin UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = @HwanTitle where CharName16 = @CharName3 END -- Item Reward EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward1,@Num1,@Plus1 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward2,@Num2,@Plus2 EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,@Reward3,@Num3,@Plus3 EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Own] @UserID,@Silkown EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Gift] @UserID,@Silkgift -- Notice Lines To show All server this char is Hero insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice',' *** '+@CharName3+'*** , '+@Notice+'',GETDATE()) -- Delete Log Unique From Table DELETE from [SRO_VT_SHARDLOG].[dbo].[JobRewardLog] where JopType = '3' END
/* End Hunter Section */
_Job_Coin
كود PHP:
USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_Job_Coin] Script Date: 20/04/2016 04:50:32 ص ******/ 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 ,@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 ------------------------
و طبعا addlogchar
|