Small question about honor rank

I want give char a honor buff , i have this query


USE [SRO_VT_SHARD]
DECLARE @[Only registered and activated users can see links. Click Here To Register...] Varchar (MAX)
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ates INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Points INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...]D INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...]D INT
SET @[Only registered and activated users can see links. Click Here To Register...] = '*[YourCharName]'
SET @[Only registered and activated users can see links. Click Here To Register...]D = (Select CharID FROM _Char Where CharName16 = @[Only registered and activated users can see links. Click Here To Register...])
SET @[Only registered and activated users can see links. Click Here To Register...]D = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @[Only registered and activated users can see links. Click Here To Register...]D)
SET @[Only registered and activated users can see links. Click Here To Register...]ates = '1234[Number Of Graduates] '
SET @[Only registered and activated users can see links. Click Here To Register...]Points= @[Only registered and activated users can see links. Click Here To Register...]ates * 39

--------------------

UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @[Only registered and activated users can see links. Click Here To Register...]ates
WHERE [Dbo].[_TrainingCamp].[ID] = @[Only registered and activated users can see links. Click Here To Register...]D
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @[Only registered and activated users can see links. Click Here To Register...]Points
WHERE [dbo].[_TrainingCampMember].[CampID] @[Only registered and activated users can see links. Click Here To Register...]D




when i use it , it works but when some one graduate more chars
char rank not go down , constant in rank ...

i want give the char #Honorpoint and #Graduatecount
so when some one graduate more chars he raise above him

i tryed with _traningcampmembers and succes to give him honorpoint
but failed to give him #Graduatecount , any help ?: )

What? More English please. I can't understand a thing. What exactly is the problem?

That qurry is to update a single char, if im not wrong , if you set a single char name, "set @ graduates = 1235 " and "set @[Only registered and activated users can see links. Click Here To Register...]points = @[Only registered and activated users can see links. Click Here To Register...]ates *39 " thst means nobody will ever reach the character which you've setted in the procedure ,thats why nobody "can rise above him " xD

Quote:

Originally Posted by ​Exo What? More English please. I can't understand a thing. What exactly is the problem?

ex: DB with 10 chars , char1 , 2 , 3 :10

i use this query for char #2 give him 50 graduates and 1950 honor point

when player char #3 graduate 60 and char #4 graduate 100 they suppose
to skip him , but no , char #2 stay the top of the rank ....

i wanna give the char ONLY graduates ( GraduateCount) so when
some one graduate more chars skip him in the rank , got my point?

Quote:

Originally Posted by leo2111 That qurry is to update a single char, if im not wrong , if you set a single char name, "set @ graduates = 1235 " and "set @[Only registered and activated users can see links. Click Here To Register...]points = @[Only registered and activated users can see links. Click Here To Register...]ates *39 " thst means nobody will ever reach the character which you've setted in the procedure ,thats why nobody "can rise above him " xD

for sure iam not set graduate 12345 :D , iam set it 50 or 100 as example
but it stay the same no body skip him in the rank -_- : /

TrainingCamp tables doesn't update unless you restart the server.


Sent from my iPhone using Tapatalk

Problem Solved, just a wrong space made it wrong :D

ty Exo