Register for your free account! | Forgot your password?

You last visited: Today at 13:37

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Honor Buff Jop

Discussion on Honor Buff Jop within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 24
The Black Market: 2/0/0
Join Date: Jun 2020
Posts: 42
Received Thanks: 10
Arrow Honor Buff Jop

i want add systems jop
with trade not kills
SourceRoad is offline  
Old 06/14/2020, 08:56   #2
 
NorseGodTyr's Avatar
 
elite*gold: 0
The Black Market: 14/0/1
Join Date: May 2013
Posts: 2,223
Received Thanks: 1,482
easy edit the Procedure
i have Job Honor system Based on Job level & Exp [right now i have job level 40]
NorseGodTyr is offline  
Old 06/14/2020, 15:28   #3
 
elite*gold: 24
The Black Market: 2/0/0
Join Date: Jun 2020
Posts: 42
Received Thanks: 10
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 ?
SourceRoad is offline  
Old 06/14/2020, 19:08   #4
 
Loyality_'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2020
Posts: 25
Received Thanks: 6
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
Loyality_ is offline  
Old 06/15/2020, 03:53   #5
 
bimbum*'s Avatar
 
elite*gold: 47
The Black Market: 4/0/0
Join Date: Oct 2017
Posts: 579
Received Thanks: 1,017
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
Attached Files
File Type: txt job.txt (3.5 KB, 10 views)
bimbum* is offline  
Old 06/15/2020, 05:44   #6
 
elite*gold: 24
The Black Market: 2/0/0
Join Date: Jun 2020
Posts: 42
Received Thanks: 10
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
SourceRoad is offline  
Old 06/15/2020, 06:40   #7
 
bimbum*'s Avatar
 
elite*gold: 47
The Black Market: 4/0/0
Join Date: Oct 2017
Posts: 579
Received Thanks: 1,017
Quote:
Originally Posted by SourceRoad View Post
give me your discord
*Bimbum#0848
bimbum* is offline  
Old 06/15/2020, 12:06   #8
 
elite*gold: 24
The Black Market: 2/0/0
Join Date: Jun 2020
Posts: 42
Received Thanks: 10
up
SourceRoad is offline  
Reply

« problem at /camera | Top Hunter,Trader and thief Give him Title »

Similar Threads Similar Threads
Mega-ix l Cap 100 l Isro System l New Jop System l New Honor System
07/28/2014 - SRO PServer Advertising - 142 Replies
Mega-ix Your Way To Fun http://epvpimg.com/vpSaf.png Website Features Website Register Download Facebook Page



All times are GMT +1. The time now is 13:38.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.