[Problem] Honor Rank

[B13.]

hey guys,
i have a problem in honor rank where players aren't at top as they should be

 Spoiler

there is many others like him
*he is like this for 7 days so.. where is the problem ?
.is there a way to fix it without removing the graduates ?
thx all.

[Br.Abdelfattah]

It appears to me that it doesn't weekly update .

[John*?]

maybe he have less honor points

[tschulian]

Originally Posted by John*?

maybe he have less honor points

its not about the honor points.
if this 162 graduates are "worse" than the 132 graduates he cant be at top

[B13.]

Originally Posted by Br.Abdelfattah

It appears to me that it doesn't weekly update .

i have restarted all server files to see what happens,
wont that make it refresh when i load them again ?

can it be a problem in the account ?

[Br.Abdelfattah]

No , it should be done every week , and if the time is set wrong so it won't update , so in smc check the honor rank update time .

[B13.]

[Aaron*]

Use this procedure

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TrainingCampRanking] Script Date: 8/6/2015 9:21:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROCEDURE [dbo].[_TrainingCampRanking]
AS


SELECT Ranking, Tcm.CharName, [Rank]
FROM _TrainingCampHonorRank Tchr
JOIN _TrainingCampMember Tcm
ON Tchr.CampID = Tcm.CampID
WHERE Tcm.MemberClass = 0
order by HonorPoint desc

[B13.]

 Spoiler

Originally Posted by Leonius*

Use this procedure

Sadly doesn't work
where is the problem

[Aaron*]

Then your _TRAINING_CAMP_HONORRANKUPDATE procedure is modified/f*cked up, use the original one instead.Here is the original procedure

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] Script Date: 8/7/2015 4:01:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
AS
SET NOCOUNT ON


-- ÀÏ´Ü ·©Å· Å×À̺íÀ» ¼¼ÆÃÇÑ´Ù.
DECLARE @Ranking INT
SET @Ranking = 1


DECLARE @CampID INT
DECLARE @Rank TINYINT


BEGIN TRANSACTION


DECLARE RankCursor CURSOR FAST_FORWARD FOR
SELECT TOP 50 [ID] FROM _TrainingCamp WITH (NOLOCK)
WHERE EvaluationPoint >= 10
ORDER BY EvaluationPoint DESC, LatestEvaluationDate ASC


-- ÀÏ´Ü Àüü ·©Å·À» ¾øÀ½À¸·Î Ç¥½ÃÇÏÀÚ.
UPDATE _TrainingCamp SET Rank = 5 WHERE Rank <> 5
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION


DEALLOCATE RankCursor
RETURN -1
END


-- ·©Å· Å×ÀÌºíµµ ÃʱâÈ*ÇÏÀÚ.
UPDATE _TrainingCampHonorRank SET CampID = null, Rank = null
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION


DEALLOCATE RankCursor
RETURN -1
END


OPEN RankCursor
FETCH NEXT FROM RankCursor INTO @CampID
WHILE @@FETCH_STATUS = 0
BEGIN
IF @Ranking <= 5
BEGIN
SET @Rank = 1
END
ELSE IF @Ranking <= 15
BEGIN
SET @Rank = 2
END
ELSE IF @Ranking <= 30
BEGIN
SET @Rank = 3
END
ELSE
BEGIN
SET @Rank = 4
END


UPDATE _TrainingCamp SET Rank = @Rank WHERE [ID] = @CampID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
CLOSE RankCursor
DEALLOCATE RankCursor


RETURN -2
END
UPDATE _TrainingCampHonorRank SET CampID = @CampID, Rank = @Rank WHERE Ranking = @Ranking
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
CLOSE RankCursor
DEALLOCATE RankCursor


RETURN -3
END

SET @Ranking = @Ranking + 1


FETCH NEXT FROM RankCursor INTO @CampID
END


CLOSE RankCursor
DEALLOCATE RankCursor


-- ¸¶Áö¸·À¸·Î °»½ÅÇÑ ³¯Â¥¸¦ Àû¾îº¸ÀÚ!!!
IF EXISTS (SELECT LastUpdateDate FROM _TrainingCampHonorRankUpdateDate)
BEGIN
UPDATE _TrainingCampHonorRankUpdateDate SET LastUpdateDate = GETDATE()
END
ELSE
BEGIN
INSERT INTO _TrainingCampHonorRankUpdateDate VALUES (GETDATE())
END


IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -4
END


COMMIT TRANSACTION


SET NOCOUNT OFF


RETURN 1

[B13.]

Originally Posted by Leonius*

Then your _TRAINING_CAMP_HONORRANKUPDATE procedure is modified/f*cked up, use the original one instead.Here is the original procedure

nope, still no work same result.
maybe i should just ban the guy

[witchymoo]

1) Manually execute the SP to check if there's any error

EXEC [_TRAINING_CAMP_UPDATEHONORRANK]

See if an error come up. If not, proceed to step 2

2) Check graduation and honor point to make sure is it the ranking displayed correctly

SELECT b.CampID, a.Rank, a.GraduateCount, a.LatestEvaluationDate, b.CharID, b.CharName, b.HonorPoint FROM [_TrainingCamp] a WITH (NOLOCK) INNER JOIN [_TrainingCampMember] b ON a.ID = b.CampID ORDER BY GraduateCount DESC

Check out result and match it with your in-game display.

good luck

[B13.]

IN GAME

IN SQL

 Spoiler

IS there is a way to change this

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_TrainingCampRanking]    Script Date: 8/7/2015 5:35:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROCEDURE [dbo].[_TrainingCampRanking]
AS


SELECT Ranking, Tcm.CharName, [Rank]
FROM _TrainingCampHonorRank Tchr 
JOIN _TrainingCampMember Tcm
ON Tchr.CampID = Tcm.CampID
WHERE Tcm.MemberClass = 0
order by HonorPoint desc 


and make it order them by graduates
*Note the guy with 162 graduates has more honor point,
just asking ..
thx for your help

[Aaron*]

Add me on skype: aeron.53
I'm gonna fix it. Pretty sure I know where exactly the error is.

[B13.]

Originally Posted by Leonius*

Add me on skype: aeron.53
I'm gonna fix it. Pretty sure I know where exactly the error is.

i appreciate your offer i really do,
as always my **** luck the mic is not working so
2 things.
1. u speak i listen and type
2. tell me what u need to see in the SQL and i upload pics for you and when you have free time you could say how to fix it
thx again mate .!