[HELP] About Honor Rank

[mostafa2224]

Hello Brother
i have problem with Honor Rank
just 5 person get Buff Honor
and the normal is 50 Person not 5 how i can solve it
now in DB

dbo._TrainingCampHonorRank
1	324	1
2	328	1
3	327	1
4	326	1
5	335	1
6	NULL	NULL
7	NULL	NULL
8	NULL	NULL
9	NULL	NULL
10	NULL	NULL
11	NULL	NULL
12	NULL	NULL
13	NULL	NULL
14	NULL	NULL
15	NULL	NULL
16	NULL	NULL
17	NULL	NULL
18	NULL	NULL
19	NULL	NULL
20	NULL	NULL
21	NULL	NULL
22	NULL	NULL
23	NULL	NULL
24	NULL	NULL
25	NULL	NULL
26	NULL	NULL
27	NULL	NULL
28	NULL	NULL
29	NULL	NULL
30	NULL	NULL
31	NULL	NULL
32	NULL	NULL
33	NULL	NULL
34	NULL	NULL
35	NULL	NULL
36	NULL	NULL
37	NULL	NULL
38	NULL	NULL
39	NULL	NULL
40	NULL	NULL
41	NULL	NULL
42	NULL	NULL
43	NULL	NULL
44	NULL	NULL
45	NULL	NULL
46	NULL	NULL
47	NULL	NULL
48	NULL	NULL
49	NULL	NULL
50	NULL	NULL

dbo._TrainingCamp
323	2011-10-19 01:08:00	5	0	0	2011-10-19 01:08:00.000		
324	2011-10-19 02:11:00	1	22	77	2011-10-21 18:53:37.283		
325	2011-10-20 16:25:00	5	0	0	2011-10-20 16:25:00.000		
326	2011-10-20 16:49:00	1	5	21	2011-10-23 14:10:41.257		
327	2011-10-21 14:39:00	1	9	34	2011-10-23 13:50:57.737		
328	2011-10-21 17:34:00	1	10	46	2011-10-22 17:23:25.840		
329	2011-10-21 19:40:00	5	0	0	2011-10-21 19:40:00.000		
330	2011-10-22 12:10:00	5	0	0	2011-10-22 12:10:00.000		
331	2011-10-22 17:03:00	5	1	5	2011-10-23 08:29:02.953		
332	2011-10-22 17:22:00	5	0	0	2011-10-22 17:22:00.000		
333	2011-10-22 22:09:00	5	0	0	2011-10-22 22:09:00.000		
334	2011-10-22 22:38:00	5	1	5	2011-10-23 09:15:28.930		
335	2011-10-22 22:54:00	1	6	30	2011-10-23 13:54:54.777		
336	2011-10-23 00:10:00	5	6	17	2011-10-23 14:19:48.150		
337	2011-10-23 05:23:00	5	6	30	2011-10-23 15:04:43.170		
338	2011-10-23 05:48:00	5	1	5	2011-10-23 06:16:34.247		
339	2011-10-23 08:35:00	5	3	9	2011-10-23 11:16:14.293

so any help please

any one there can help ?

[carmenjason]

same problem ( for me I got 3 only in the rank system )
AND FOR *** SAKE .. HOPE ANYONE REPLY THIS !!

[_slimshady_]

Maybe don't put null for 6-50. Try putting 0

[1337Demon]

same problem here .

did any one can help us !>!>!>!>!>!>!

I'm boring

[AceSpace]

I like google so much result of searching:
First query:

 Spoiler

PHP Code:

USE SRO_VT_SHARD
/****** Query by BryanSA ******/
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK
/****** HeroSilkroad Revolution ******/ 


Second query:

 Spoiler

PHP Code:

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 


If didn't work then try this [Credit goes to Madelyn]

 Spoiler

Delete the table. and use it.

PHP Code:

USE [SRO_VT_SHARD]
GO
/****** Objeto: Table [dbo].[_TrainingCampHonorRank] Fecha de la secuencia de comandos: 06/07/2012 16:18:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_TrainingCampHonorRank](
[Ranking] [int] NOT NULL,
[CampID] [int] NULL,
[Rank] [tinyint] NULL,
CONSTRAINT [PK__TrainingCampHonorRank] PRIMARY KEY CLUSTERED 
(
[Ranking] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] 


And add again 50 lines.

SET = Ranking to 1 only. and enter and make again with the 50 lines.
Example..

1 NULL NULL
2 NULL NULL
3 NULL NULL
4 NULL NULL
5 NULL NULL
6 NULL NULL
7 NULL NULL
....
50 NULL NULL


Reset GameServer. :P:
Likeme..

Regards