Honor Buff Jop

06/14/2020 06:36 SourceRoad#1
i want add systems jop
with trade not kills
06/14/2020 08:56 NorseGodTyr#2
easy edit the Procedure ;)
i have Job Honor system Based on Job level & Exp [right now i have job level 40]
06/14/2020 15:28 SourceRoad#3
Quote:
Originally Posted by NorseGodTyr View Post
easy edit the Procedure ;)
i have Job Honor system Based on Job level & Exp [right now i have job level 40]
i create this i got level 7 and still no get honor after refresh
and here Procedure level 5 what this problem ?
06/14/2020 19:08 Loyality_#4
Quote:
Originally Posted by NorseGodTyr View Post
easy edit the Procedure ;)
i have Job Honor system Based on Job level & Exp [right now i have job level 40]
i hope send me System Job Coin
06/15/2020 03:53 bimbum*#5
Quote:
Originally Posted by SourceRoad View Post
i want add systems jop
with trade not kills
i didn't try that . but it has to work with you
it depends on contribution, you can customize it as you want
HTML Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_JobGrant]    Script Date: 6/15/2020 4:48:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[_JobGrant]
@CharName varchar(64)
 
AS

DECLARE [MENTION=1395019]Contribution[/MENTION] bigint,  [MENTION=300085]JoB[/MENTION]Type tinyint, [MENTION=681476]cont[/MENTION]Base bigint,  [MENTION=291440]Limit[/MENTION] int = 1500, [MENTION=290176]Coin[/MENTION] int,@AP INT, [MENTION=786412]coins[/MENTION]ThisWeek int,@APThisWeek int, [MENTION=786412]coins[/MENTION]um INT=0,@APSum INT, @CharID INT,
  [MENTION=292919]user[/MENTION]JID INT, [MENTION=2377502]Gems[/MENTION] INT, [MENTION=2377502]Gems[/MENTION]Base bigint,  [MENTION=5876716]GOLDB[/MENTION]ase bigint
SELECT [MENTION=1395019]Contribution[/MENTION]=Contribution,  [MENTION=300085]JoB[/MENTION]Type=JobType, @CharID=C.CharID,  [MENTION=292919]user[/MENTION]JID=U.UserJID
FROM SRO_VT_SHARD.._Char C WITH (NOLOCK)
JOIN SRO_VT_ShARD.._CharTriJob CT ON C.CharID=CT.CharID
JOIN SRO_VT_SHARD.._User U ON C.CharID=U.CharID
WHERE C.CharName16=@CharName
SET [MENTION=681476]cont[/MENTION]Base = CASE
	WHEN  [MENTION=300085]JoB[/MENTION]Type=1 THEN 1111908 -- trader   6002175 (dw to trade route) old rate 18046
	WHEN  [MENTION=300085]JoB[/MENTION]Type=2 THEN 2226400 --thief
	WHEN  [MENTION=300085]JoB[/MENTION]Type=3 THEN 5000360 --hunter
		END
SELECT [MENTION=786412]coins[/MENTION]um =  [MENTION=1395019]Contribution[/MENTION] [MENTION=681476]cont[/MENTION]Base)
SELECT @APSum [MENTION=786412]coins[/MENTION]um
SELECT [MENTION=786412]coins[/MENTION]ThisWeek=coalesce(SUM(Coin),0) FROM _CoinLog WHERE CharID in (SELECT CharID FROM SRO_VT_SHARD.._User WHERE UserJID  [MENTION=292919]user[/MENTION]JID)
SET [MENTION=290176]Coin[/MENTION] = CASE
	WHEN [MENTION=786412]coins[/MENTION]ThisWeek [MENTION=786412]coins[/MENTION]um <=  [MENTION=291440]Limit[/MENTION] THEN [MENTION=786412]coins[/MENTION]um
	WHEN [MENTION=786412]coins[/MENTION]ThisWeek<  [MENTION=291440]Limit[/MENTION] AND [MENTION=786412]coins[/MENTION]ThisWeek [MENTION=786412]coins[/MENTION]um >  [MENTION=291440]Limit[/MENTION] THEN  [MENTION=291440]Limit[/MENTION] [MENTION=786412]coins[/MENTION]ThisWeek
	ELSE 0
	END

	SELECT @APThisWeek=coalesce(SUM(Coin),0) FROM _APJob WHERE CharID in (SELECT CharID FROM SRO_VT_SHARD.._User WHERE UserJID  [MENTION=292919]user[/MENTION]JID)
SET @AP = CASE
	WHEN @APThisWeek+@APSum <= 400 THEN @APSum
	WHEN @APThisWeek< 400 AND @APThisWeek+@APSum > 400 THEN 400-@APThisWeek
	ELSE 0
	END
SET  [MENTION=5876716]GOLDB[/MENTION]ase = CASE
	WHEN  [MENTION=300085]JoB[/MENTION]Type=1 THEN 12.75 --old = 714
	WHEN  [MENTION=300085]JoB[/MENTION]Type=2 THEN 8.42 -- old = 20
	WHEN  [MENTION=300085]JoB[/MENTION]Type=3 THEN 3 --old = 23
	END
IF(NOT EXISTS(SELECT 1 FROM _ContriSave WHERE CharID=@CharID))
	BEGIN
		INSERT INTO _ContriSave values (@CharID,0,GETDATE())
	END
	/*if @AP>0
BEGIN
EXEC _AddAP @CharName,@AP
		INSERT _APJob SELECT @CharID,@AP,GETDATE()
		END */
IF [MENTION=290176]Coin[/MENTION] > 0
	BEGIN
		INSERT INTO _CoinLog values (@CharID [MENTION=290176]Coin[/MENTION],GETDATE())
		--EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @charname,'ITEM_ETC_SD_TOKEN_04' [MENTION=290176]Coin[/MENTION],0 slow shit
		exec _AddHonorPoints @CharID [MENTION=290176]Coin[/MENTION]
		
		UPDATE _ContriSave SET Contri+ [MENTION=1395019]Contribution[/MENTION] WHERE CharID=@CharID
		
	END
	UPDATE SRO_VT_SHARD.._Char  SET RemainGold+ [MENTION=1395019]Contribution[/MENTION]  [MENTION=5876716]GOLDB[/MENTION]ase WHERE CharID=@CharID
	UPDATE SRO_VT_SHARD.._CharTrijob Set Contribution=0 WHERE CharID=@CharID
HTML Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddHonorPoint]    Script Date: 6/15/2020 4:50:25 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AddHonorPoint]
@CharID INT,
  [MENTION=2127817]points[/MENTION] INT
AS

UPDATE TC SET GraduateCount+  [MENTION=2127817]points[/MENTION],EvaluationPoint+=39  [MENTION=2127817]points[/MENTION],LatestEvaluationDate=GETDATE() 
FROM SRO_VT_SHARD.._TrainingCamp TC
JOIN SRO_VT_SHARD.._TrainingCampMember TCM ON TC.ID=TCM.CampID
WHERE TCM.CharID=@CharID AnD TCM.MemberClass=0
06/15/2020 05:44 SourceRoad#6
Quote:
Originally Posted by bimbum* View Post
i didn't try that . but it has to work with you
it depends on contribution, you can customize it as you want
HTML Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_JobGrant]    Script Date: 6/15/2020 4:48:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[_JobGrant]
@CharName varchar(64)
 
AS

DECLARE [MENTION=1395019]Contribution[/MENTION] bigint,  [MENTION=300085]JoB[/MENTION]Type tinyint, [MENTION=681476]cont[/MENTION]Base bigint,  [MENTION=291440]Limit[/MENTION] int = 1500, [MENTION=290176]Coin[/MENTION] int,@AP INT, [MENTION=786412]coins[/MENTION]ThisWeek int,@APThisWeek int, [MENTION=786412]coins[/MENTION]um INT=0,@APSum INT, @CharID INT,
  [MENTION=292919]user[/MENTION]JID INT, [MENTION=2377502]Gems[/MENTION] INT, [MENTION=2377502]Gems[/MENTION]Base bigint,  [MENTION=5876716]GOLDB[/MENTION]ase bigint
SELECT [MENTION=1395019]Contribution[/MENTION]=Contribution,  [MENTION=300085]JoB[/MENTION]Type=JobType, @CharID=C.CharID,  [MENTION=292919]user[/MENTION]JID=U.UserJID
FROM SRO_VT_SHARD.._Char C WITH (NOLOCK)
JOIN SRO_VT_ShARD.._CharTriJob CT ON C.CharID=CT.CharID
JOIN SRO_VT_SHARD.._User U ON C.CharID=U.CharID
WHERE C.CharName16=@CharName
SET [MENTION=681476]cont[/MENTION]Base = CASE
	WHEN  [MENTION=300085]JoB[/MENTION]Type=1 THEN 1111908 -- trader   6002175 (dw to trade route) old rate 18046
	WHEN  [MENTION=300085]JoB[/MENTION]Type=2 THEN 2226400 --thief
	WHEN  [MENTION=300085]JoB[/MENTION]Type=3 THEN 5000360 --hunter
		END
SELECT [MENTION=786412]coins[/MENTION]um =  [MENTION=1395019]Contribution[/MENTION] [MENTION=681476]cont[/MENTION]Base)
SELECT @APSum [MENTION=786412]coins[/MENTION]um
SELECT [MENTION=786412]coins[/MENTION]ThisWeek=coalesce(SUM(Coin),0) FROM _CoinLog WHERE CharID in (SELECT CharID FROM SRO_VT_SHARD.._User WHERE UserJID  [MENTION=292919]user[/MENTION]JID)
SET [MENTION=290176]Coin[/MENTION] = CASE
	WHEN [MENTION=786412]coins[/MENTION]ThisWeek [MENTION=786412]coins[/MENTION]um <=  [MENTION=291440]Limit[/MENTION] THEN [MENTION=786412]coins[/MENTION]um
	WHEN [MENTION=786412]coins[/MENTION]ThisWeek<  [MENTION=291440]Limit[/MENTION] AND [MENTION=786412]coins[/MENTION]ThisWeek [MENTION=786412]coins[/MENTION]um >  [MENTION=291440]Limit[/MENTION] THEN  [MENTION=291440]Limit[/MENTION] [MENTION=786412]coins[/MENTION]ThisWeek
	ELSE 0
	END

	SELECT @APThisWeek=coalesce(SUM(Coin),0) FROM _APJob WHERE CharID in (SELECT CharID FROM SRO_VT_SHARD.._User WHERE UserJID  [MENTION=292919]user[/MENTION]JID)
SET @AP = CASE
	WHEN @APThisWeek+@APSum <= 400 THEN @APSum
	WHEN @APThisWeek< 400 AND @APThisWeek+@APSum > 400 THEN 400-@APThisWeek
	ELSE 0
	END
SET  [MENTION=5876716]GOLDB[/MENTION]ase = CASE
	WHEN  [MENTION=300085]JoB[/MENTION]Type=1 THEN 12.75 --old = 714
	WHEN  [MENTION=300085]JoB[/MENTION]Type=2 THEN 8.42 -- old = 20
	WHEN  [MENTION=300085]JoB[/MENTION]Type=3 THEN 3 --old = 23
	END
IF(NOT EXISTS(SELECT 1 FROM _ContriSave WHERE CharID=@CharID))
	BEGIN
		INSERT INTO _ContriSave values (@CharID,0,GETDATE())
	END
	/*if @AP>0
BEGIN
EXEC _AddAP @CharName,@AP
		INSERT _APJob SELECT @CharID,@AP,GETDATE()
		END */
IF [MENTION=290176]Coin[/MENTION] > 0
	BEGIN
		INSERT INTO _CoinLog values (@CharID [MENTION=290176]Coin[/MENTION],GETDATE())
		--EXEC SRO_VT_SHARD.._ADD_ITEM_EXTERN @charname,'ITEM_ETC_SD_TOKEN_04' [MENTION=290176]Coin[/MENTION],0 slow shit
		exec _AddHonorPoints @CharID [MENTION=290176]Coin[/MENTION]
		
		UPDATE _ContriSave SET Contri+ [MENTION=1395019]Contribution[/MENTION] WHERE CharID=@CharID
		
	END
	UPDATE SRO_VT_SHARD.._Char  SET RemainGold+ [MENTION=1395019]Contribution[/MENTION]  [MENTION=5876716]GOLDB[/MENTION]ase WHERE CharID=@CharID
	UPDATE SRO_VT_SHARD.._CharTrijob Set Contribution=0 WHERE CharID=@CharID
HTML Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddHonorPoint]    Script Date: 6/15/2020 4:50:25 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AddHonorPoint]
@CharID INT,
  [MENTION=2127817]points[/MENTION] INT
AS

UPDATE TC SET GraduateCount+  [MENTION=2127817]points[/MENTION],EvaluationPoint+=39  [MENTION=2127817]points[/MENTION],LatestEvaluationDate=GETDATE() 
FROM SRO_VT_SHARD.._TrainingCamp TC
JOIN SRO_VT_SHARD.._TrainingCampMember TCM ON TC.ID=TCM.CampID
WHERE TCM.CharID=@CharID AnD TCM.MemberClass=0


give me your discord
06/15/2020 06:40 bimbum*#7
Quote:
Originally Posted by SourceRoad View Post
give me your discord
*Bimbum#0848
06/15/2020 12:06 SourceRoad#8
up