Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 00:57

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

Advertisement



[Help] Honor Ranking aka Job Ranking

Discussion on [Help] Honor Ranking aka Job Ranking within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2010
Posts: 375
Received Thanks: 150
[Help] Honor Ranking aka Job Ranking

Hello experts

well im doing honor ranking to show the jobbers top kills based on Graduate count

every kill = graduate

but somehow ingame Ranking didnt show the right grad count on the db ?

here is the [_TRAINING_CAMP_UPDATEHONORRANK] SP

PHP Code:
ALTER PROCEDURE [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
AS
    
SET NOCOUNT ON

    
-- 일단 랭킹 테이블을 세팅한다.
    DECLARE [
MENTION=1452052]ranking[/MENTION]    INT
    SET 
[MENTION=1452052]ranking[/MENTION] = 1

    
DECLARE [MENTION=320029]campi[/MENTION]D    INT
    
DECLARE [MENTION=955363]rank[/MENTION]    TINYINT

BEGIN TRANSACTION

    
    SELECT TOP 10 
[IDFROM _TrainingCamp WITH (NOLOCK)
    
WHERE GraduateCount >= 15
    ORDER BY GraduateCount DESC
EvaluationPoint DESC

    
-- 일단 전체 랭킹을 없음으로 표시하자.
    
UPDATE _TrainingCamp SET Rank 5 WHERE Rank <> 5
    
IF (@@ERROR <> 0)
    
BEGIN
        ROLLBACK TRANSACTION

        DEALLOCATE RankCursor
        
RETURN -1
    END

    
-- 랭킹 테이블도 초기*하자.
    
UPDATE _TrainingCampHonorRank SET CampID nullRank null
    
IF (@@ERROR <> 0)
    
BEGIN
        ROLLBACK TRANSACTION

        DEALLOCATE RankCursor
        
RETURN -1
    END

    OPEN RankCursor
    FETCH NEXT FROM RankCursor INTO 
[MENTION=320029]campi[/MENTION]D
    
WHILE @@FETCH_STATUS 0
    BEGIN
        
IF [MENTION=1452052]ranking[/MENTION] <= 5
        BEGIN
            SET 
[MENTION=955363]rank[/MENTION] = 1
        END
        
ELSE IF [MENTION=1452052]ranking[/MENTION] <= 15
        BEGIN
            SET 
[MENTION=955363]rank[/MENTION] = 2
        END
        
ELSE IF [MENTION=1452052]ranking[/MENTION] <= 30
        BEGIN
            SET 
[MENTION=955363]rank[/MENTION] = 3
        END
        
ELSE
        
BEGIN
            SET 
[MENTION=955363]rank[/MENTION] = 4
        END

        UPDATE _TrainingCamp SET Rank 
= [MENTION=955363]rank[/MENTIONWHERE [ID] = [MENTION=320029]campi[/MENTION]D    
        
IF (@@ERROR <> OR @@ROWCOUNT 0)
        
BEGIN
            ROLLBACK TRANSACTION
            CLOSE RankCursor
            DEALLOCATE RankCursor

            
RETURN -2
        END
        UPDATE _TrainingCampHonorRank SET CampID 
= [MENTION=320029]campi[/MENTION]DRank = [MENTION=955363]rank[/MENTIONWHERE Ranking = [MENTION=1452052]ranking[/MENTION]    
        IF (@@
ERROR <> OR @@ROWCOUNT 0)
        
BEGIN
            ROLLBACK TRANSACTION
            CLOSE RankCursor
            DEALLOCATE RankCursor

            
RETURN -3
        END 
        
        SET 
[MENTION=1452052]ranking[/MENTION] = [MENTION=1452052]ranking[/MENTION] + 1

        FETCH NEXT FROM RankCursor INTO 
[MENTION=320029]campi[/MENTION]D
    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 <> OR @@ROWCOUNT 0)
    
BEGIN
        ROLLBACK TRANSACTION
        
RETURN -4
    END

COMMIT TRANSACTION

    SET NOCOUNT OFF

    
RETURN 
Dragonz2105 is offline  
Old 12/31/2016, 18:04   #2
 
elite*gold: 0
Join Date: Jan 2009
Posts: 935
Received Thanks: 394
up
leo2111 is offline  
Old 01/02/2017, 23:10   #3


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,646
As far as I remember the ingame ranking doesn't show up-to-date counts. You have to restart the gs to see the new values. And no, there's no easy solution to that.
​Exo is offline  
Reply


Similar Threads Similar Threads
[Selling] OW Account - actual ranking 3200 max - 3900 ranking credits
09/23/2016 - Overwatch Trading - 14 Replies
Selling OW account - Last Season #74 ranked ( 3800 ranked credits left on Acc ) No weapons buyed - This Season #3200 max - #3180 now Battlenet Acc also includes
Vsro How made Honor Ranking and buffs working
04/02/2012 - SRO Private Server - 4 Replies
Hello guys can anyone help me my Honor rank and honor buffs dont work honor system is working and i can get my points but the guy in my academy if they are 40++ they will get exp too how i can fix this ?
[Tutorial] Fix honor ranking (in case you use my released clean db).
10/26/2011 - SRO Private Server - 5 Replies
Step 1. Open your mssql editor Step 2. Go to SRO_VT_SHARD or w/e your shard is called Step 3. Open up the _TrainingCampHonorRank table Step 4. In field Ranking - enter value 1 and hit enter and so on till 50 so it should look like this: http://sroparadise.org/dl/ranking.jpg Step 5. Manually update the honor ranking for 1st time - use this query: USE SRO_VT_SHARD exec _TRAINING_CAMP_UPDATEHONORRANK



All times are GMT +2. The time now is 00:57.


Powered by vBulletin®
Copyright ©2000 - 2023, 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 ©2023 elitepvpers All Rights Reserved.