Make a true hero

[GizZ]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:4412
L2JDP Revision Number:7664

Hello everyone
I know that exists the //sethero but once the player restart he lose the hero status.
There is anyway to put one player like a true hero? on the monument and so on

[SolidSnake]

Open 'characters' table in Navicat (database), so copy the player's charId and class_id
Now open 'heroes' table and click on + to create a new line, then paste the charId in the first column, the class_id in the second, 1 to third, 0 to fourth and nothing to 'message'

Start/Restart gameserver

[GizZ]

I tried but didnt work ...
Maybe its because there is because the server is new and there is no one hero ?

[Probe]

you saved after adding the line and rebooted server?


edit:
try this

INSERT INTO heroes VALUES
((SELECT char_id FROM characters WHERE char_name='PLAYERNAME'), (SELECT class_id FROM characters WHERE char_name='PLAYERNAME'), 1, 0, '');

and replace PLAYERNAME with your player name

[GizZ]

Well i tryed to do exacly like that but doesnt work

[SolidSnake]

But are you saving the modify? And when you are making it, is the server closed?

[GizZ]

yes and i tryed to restart the server but nothing is changing.
I am also trying to put the hero item time on the server but its a bit confuse on the post.

I dunno wich codes are right .
Cause i want to aplly that patch on my server aswell.

[SolidSnake]

yes and i tryed to restart the server

Restart? No, the server must be closed while you apply the modify.. If you're online and change those values, database cannot save them

[GizZ]

Well thanks for trying to help me but didnt work ....

[Naonah]

Guys, I dont know what is a problem?

Do as SolidSnake wrote. It must work ;p

[GizZ]

I did it and dosent work but probably is because the first cycle from the server didnt finish yet.
Maybe wean he is on the second cycle or something will work

[Naonah]

I did it and dosent work but probably is because the first cycle from the server didnt finish yet.
Maybe wean he is on the second cycle or something will work

Try to make manual heros. It should change period from 1 to 2.

[GizZ]

The funny thing is i use that manual hero thing on the character and wean i reboot the server it stills the same periode and the hero is a normal player again .
And i want to get a mod like i saw in the mod section that with one item a player get hero status but for a periode only.
Anyway for now i just want to put working the manual heros.
Maybe do manual heros and save olympiad ?

[GizZ]

well my last idea didnt work asweel ...

[SolidSnake]

Manual hero command give only the hero effects, so you have the aura, the skills, the chat and other privileges
Only the Olympiad system saves the heroes connecting to database

Anyway the table should be like this screen



charId -> You can find it in the 'characters' table
class_id -> as charId
count -> Must be 1 or more
played -> Try 1
message -> nothing

Close the table and when navicat ask you if 'Save - Don't save - Cancel', choose 'Save'..
Now re-open the table and see if your modify is really saved or not
If yes, start server, login and check if your pg is an hero