E-Silkroad Job Rank

01/24/2015 04:55 !Ego#1
Guy's i got surprised now
when i was testing the honor rank
and i found that the honor rank is actually Job rank
so how can i make it as a honor rank again ?
01/24/2015 06:34 Snow*#2
i go surprised when i read ur post how i can be not surprised?

Use a clean database maybe?
01/24/2015 06:37 !Ego#3
No I need this DB.
I make it full edit
NEW avatars
NEW npcs
DROP
MAX LVL

so It's hard to use anthor..
01/24/2015 06:43 Snow*#4
Take the honor stored procedures and tables from a clean database then
01/24/2015 07:09 !Ego#5
Okay Please tell me their names !
01/24/2015 14:00 Aaron*#6
Quote:
Originally Posted by BuiLt4KiLl View Post
Okay Please tell me their names !

_TRAINING_CAMP_CREATE
01/24/2015 14:07 Syloxx#7
Quote:
Originally Posted by BuiLt4KiLl View Post
Okay Please tell me their names !
can you please tell me what you wanna do with the Silkroad Serverfiles?

-Start a commercial server?
--Will result in a waste of money since your are not experienced enough.

-Start a server for you and your friends?
--Does it really matter what kind of DB you use then?

-Start a server to develop on it?
--Use clean server files and do your own shit otherwise uŽll never reach something.
01/24/2015 15:26 !Ego#8
Will iam free to do what i want to....
Please answer with a good answer or don't at all !

Quote:
Originally Posted by Jocs View Post
_TRAINING_CAMP_CREATE
bro i replaced it but it doesn't work :(
I have 1000 Graduates and i haven't appear on the honor rank list or the buffs come to me !

UP !
01/25/2015 00:32 ​Exo#9
Have you fixed the tables? Restarted the GS?
01/25/2015 00:41 !Ego#10
I replaced produce [_TRAINING_CAMP_CREATE]
and no thing other
sure i restarted the server

please i wanna this honor rank a lot.
01/25/2015 01:51 Aaron*#11
use this query
Quote:
use sro_vt_shard
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
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]
it should work now.
01/25/2015 02:30 !Ego#12
Can u give me a query to refresh the honor rank ?!
and about it after i Execute it i should restart the server or not ?

Thanks guy's when i was using the query for Refresh honor rank i checked it produce and i found that the produce was refreshing the Job Rank.
01/25/2015 11:31 Aaron*#13
Quote:
Originally Posted by BuiLt4KiLl View Post
Can u give me a query to refresh the honor rank ?!
and about it after i Execute it i should restart the server or not ?

Thanks guy's when i was using the query for Refresh honor rank i checked it produce and i found that the produce was refreshing the Job Rank.
the query that i have given you does that.