[Help] How to fix Honor in vsro files !

02/27/2013 19:01 Rene.Punik#1

Hello everybody in elitepvpers forum , i'm new in the our forum .. i hope to any one release a guide for my problem so, please i hope to one help me !

02/27/2013 19:12 Snow*#2

Wrong section >> [Only registered and activated users can see links. Click Here To Register...]

Open dbo._TrainingCampHonorRank and paste dat. >> [Only registered and activated users can see links. Click Here To Register...]

Code:

1 NULL NULL
 2 NULL NULL
 3 NULL NULL
 4 NULL NULL
 5 NULL NULL
 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

Another one >> [Only registered and activated users can see links. Click Here To Register...]

Another one >>

Spoiler

Quote:

Originally Posted by ��Rock��

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.. :D

Regards

02/27/2013 20:29 Rene.Punik#3

Please I really want to help this problem I tried a lot of times too much time, but I can not successfully repaired , and don't working yet ... please help me guys !

02/28/2013 03:03 MNX-Style#4

you could try this also

PHP Code:


			
USE [SRO_VT_SHARD]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]

02/28/2013 20:56 PortalDark#5

#moved to correct section