[question] only one player get a title ?

11/25/2015 17:36 B13.#1
hey guys i would like to know how to make a title only obtained by one player
like there is only could be 1 medusa slayer or roc slayer etc
or top uniques hunters the highest score gets a title but when some one gets more points than him i want the title get moved from the low score to the highest score
thx all !
11/26/2015 12:26 Vxo#2
begin
update _char where hwanlevel = 0 or oldhwanlevel (instead of slayer title)
begin
update _char set hwanlevel = (slayer title no.) (don't forget u must take oldhwanlevel before updating new hwan)
end
end
bla bla bla.
11/26/2015 12:59 blapanda#3
Quote:
Originally Posted by Vxo View Post
begin
update _char where hwanlevel = 0 or oldhwanlevel (instead of slayer title)
begin
update _char set hwanlevel = (slayer title no.) (don't forget u must take oldhwanlevel before updating new hwan)
end
end
bla bla bla.
That is not even near helpful.

First of all, you need a table, which records the kills on each character (similar to the Academy ranking table), next you need to check the kill logs, which player killed what unique, and update the respective player with it's kill count on that new table. Another query should monitor the kill count on that table and update the title automatically set by a specific time period (same like the Academy stuff...). The hard part will be: which ID is fetching from "player killed unique xyz", if you have no clue about the eventID stuff.

Good luck figuring it out and creating your own custom title service.
11/26/2015 13:59 B13.#4
thx all i will try that but,
i bet i will keep doing what im doing all with my hands :c
11/26/2015 18:36 Vxo#5
Quote:
Originally Posted by B13. View Post
thx all i will try that but,
i bet i will keep doing what im doing all with my hands :c
Good luck.
11/29/2015 23:39 B13.#6
#REQUEST2CLOSE#