Get Honor Point by Killing Jobbers.

Yeah my bad sorry, it should be this:

Code:

---

/* 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 :)

Quote:

---

Originally Posted by RenePunik

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

look here maybe this help you

Quote:

---

Originally Posted by zizoelnigm

look here maybe this help you

---

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

but i show you it work for me :D

- - - Updated - - -

Quote:

---

Originally Posted by Witchy Moo

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:

Code:

---

/* 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

@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.

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?

Quote:

---

Originally Posted by 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?

---

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

Quote:

---

Originally Posted by RenePunik

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