[Help]Permanent Hero L2J

[l1qu1d1c3]

hey guys/gals,i want to know how to set a player of my server a permanent hero.i opened the hero.sql tables with navicat and set the stuff in but it doesnt work.is there any ways?i do //sethero but its not permanent

 

[PunKed]

the player must realize a "olympiad quest" with pvp.

 

[tasma]

opened the hero.sql tables with navicat and set the stuff in but it doesnt work

Try that again with server down (btw im Lara if y remeber me)

 

[l1qu1d1c3]

well punked i dont want him to do olympiad coz the olympiad is off.i want her hero coz i put it in the tables.yeah tasma i know who u are.like u quoted,it doesnt work with the server on or off

 

[Pampurko]

In characters.sql put "1" in nobless table , and in heroes.sql too after server restart it must be a hero but i readed somewhere in the forums that this is no good for the server sry for my bad english

 

[l1qu1d1c3]

why isnt it good for the server?

 

[nadi]

in 'heroes' table there are rows
'char_id' -> u put the id of the char u want to set hero (u can see it at characters table)
'Char_name' -> the name of the char
'class_id' -> the char class id also u can see in characters table
'count' -> here u must put a number different from 0, like 3/4/5 etc.
'played' -> also u must change it not to be 0
and if u fill up all right like above the char u chosen will be hero permanently

 

[WulfgarXX]

replace into heroes values
('char_id', 'char_name', 'class_id', 'count', 'played');

here's a way to do it.

 

[nadi]

thats what i already posted but with a bigger explanation for the ones who dont know some things -.-'