Small question about honor rank

[hamoelpap3]

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


USE [SRO_VT_SHARD]
DECLARE @ Varchar (MAX)
DECLARE @ates INT
DECLARE @Points INT
DECLARE @D INT
DECLARE @D INT
SET @ = '*[YourCharName]'
SET @D = (Select CharID FROM _Char Where CharName16 = @)
SET @D = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @D)
SET @ates = '1234[Number Of Graduates] '
SET @Points= @ates * 39

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

UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @ates
WHERE [Dbo].[_TrainingCamp].[ID] = @D
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @Points
WHERE [dbo].[_TrainingCampMember].[CampID] @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 ?: )

[​Exo]

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

[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 @points = @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

[hamoelpap3]

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?

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 @points = @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 , iam set it 50 or 100 as example
but it stay the same no body skip him in the rank -_- : /

[​Exo]

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


Sent from my iPhone using Tapatalk

[hamoelpap3]

Problem Solved, just a wrong space made it wrong

ty Exo