[Problem] Honor Rank

08/05/2015 14:44 B13.#1
hey guys,
i have a problem in honor rank where players aren't at top as they should be
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.
08/05/2015 15:10 Br.Abdelfattah#2
It appears to me that it doesn't weekly update .
08/05/2015 16:30 John*?#3
maybe he have less honor points
08/05/2015 19:27 tschulian#4
Quote:
Originally Posted by John*? View Post
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
08/05/2015 22:05 B13.#5
Quote:
Originally Posted by Br.Abdelfattah View Post
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 ? :confused:
08/06/2015 01:12 Br.Abdelfattah#6
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 .
08/06/2015 09:43 B13.#7
:confused:
[Only registered and activated users can see links. Click Here To Register...]
08/06/2015 10:22 Aaron*#8
Use this procedure
Quote:
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


08/07/2015 01:00 B13.#9

Sadly doesn't work :(
where is the problem :confused:
08/07/2015 05:04 Aaron*#10
Then your _TRAINING_CAMP_HONORRANKUPDATE procedure is modified/f*cked up, use the original one instead.Here is the original procedure
Quote:
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
08/07/2015 09:35 B13.#11
Quote:
Originally Posted by Leonius* View Post
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 :mad:
08/07/2015 09:53 witchymoo#12
1) Manually execute the SP to check if there's any error
Code:
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

Code:
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
08/07/2015 17:38 B13.#13
IN GAME
[Only registered and activated users can see links. Click Here To Register...]
IN SQL

IS there is a way to change this
and make it order them by graduates
*Note the guy with 162 graduates has more honor point,
just asking ..
thx for your help
08/07/2015 22:21 Aaron*#14
Add me on skype: aeron.53
I'm gonna fix it. Pretty sure I know where exactly the error is.
08/07/2015 22:55 B13.#15
Quote:
Originally Posted by Leonius* View Post
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 .!