Get Honor Point by Killing Jobbers.

[Witchy Moo]

Yeah my bad sorry, it should be this:

/* Check if Camp exist */
DECLARE @CampID INT
SELECT @CampID = CampID FROM [SRO_VT_SHARD].[dbo].[_TrainingCampMember] WHERE CharID = @KillerCharID AND MemberClass = 0
IF  (@CampID <> 0)
BEGIN
    -- Set graduate
    UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCamp] SET GraduateCount = GraduateCount + 1 WHERE ID = @CampID
    -- Add honor point
    UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCampMember] SET HonorPoint = HonorPoint + (your formula here) WHERE CharID = @KillerCharID
END

"WHERE ID = @CampID", my mistake on that one :)

[BadFist]

So, what i have to do? I got it worked but it server need to be restarted to see real kills points. any idea?

one of my dev was make on website to see how nanny point have each player

[zizoelnigm]

look here maybe this help you

[RenePunik]

look here maybe this help you

This won't help, His thread won't work on anyway. because all his lines are wrong.

[MikroTekken]

but i show you it work for me :D

- - - Updated - - -

you did pretty nice mods fulfilling your needs though, no need to change anything if they already works.

The _AddLogChar thingy is completely different thing, I just tried to add an example for you to record kill activities, which you can use for the honor thingy you wanna make, or other stuff.

For example you can update the kill count to automatically to your honor table everytime a char got killed, like:

/* Check if Camp exist */
DECLARE @CampID INT
SELECT @CampID = CampID FROM [SRO_VT_SHARD].[dbo].[_TrainingCampMember] WHERE CharID = @KillerCharID AND MemberClass = 0
IF  (@CampID <> 0)
BEGIN
    -- Set graduate
    UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCamp] SET GraduateCount = GraduateCount + 1 WHERE CampID = @CampID
    -- Add honor point
    UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCampMember] SET HonorPoint = HonorPoint + (your formula here) WHERE CharID = @KillerCharID
END

the formula should be some value you want, say, how much honor value a person will get when they kill in job mode. And that sequence should be called by _AddLogChar, inside the Event 20 sequence :)

something like that... ish..

but he mean want to update honor every time in game not in tab in tab so easy but in game it need add update honor in SMC like every 1 minute

[RenePunik]

@Witchy Moo, Honor rank page didn't update... even If i killed a thief 50 times.. It update only in one way, when i restart my server.

[Witchy Moo]

isn't honor rank page updated by '[_TRAINING_CAMP_UPDATEHONORRANK]' procedure? which the last time i remember is placed on [_Schedule] table or SMC schedule and not real time?

[RenePunik]

isn't honor rank page updated by '[_TRAINING_CAMP_UPDATEHONORRANK]' procedure? which the last time i remember is placed on [_Schedule] table or SMC schedule and not real time?

I made it to update every one hour, btw it wasn't updated also.

[hexcode]

I made it to update every one hour, btw it wasn't updated also.

Any update about updating honor points without server restart? Scheduled execution of _TRAINING_CAMP_UPDATEHONORRANK do not update the points.Any new fresh ideas?

Regards