Olly problem

[fokys]

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

Hello i have issue with heros!

Problem is: 2 players who were ranked as 1st in olly ranking were not heros instead somebody else was hero!

Example: Player 1 has 20 points and Player 2 has 15 points but hero is player 2 with less points!

All of them have more then 9 fights and 1 win!

Any suggestion?i was not editing anything in olly files!

[_DS_]

You should check olympiad log for hero generation.

[fokys]

looked on it and it does not make any sense

There is 1st Character: 268760280,103,20,25 he has 20 fighst and 25 points

There is 2nd Character: 268546384,103,40,8 he has 40 fights and 8 points

And hero was give to one with 8 points!

[_DS_]

Post non-cutted log entries for both chars and generation.

[fokys]

01/02/2011 12:00:00,Noble,charid,classid,compDone,points
01/02/2011 12:00:00,Torch,268739412,94,20,37
01/02/2011 12:00:00,Aurion,269052751,94,10,20


01/02/2011 12:00:00,Hero Aurion,269052751,94


In total now i have 4 wrong heros!

[_DS_]

Post entries for those chars from olympiad_nobles_eom.

[fokys]

ChardID,Class ID,Points,Comp.done,Comp Won,Comp Lost,Comp Drawn!

268739412 94 37 20 16 4 0

269052751 94 20 10 3 7 0

[_DS_]

MyISAM ? Try to run repair on olympiad_nobles.

[fokys]

Can i lose any data?
Is there anyway i can manualy solve this problem?
It is only 4 characters!

[fokys]

Anyway main question is,why is it doing that?

Because when you check rankings with Olly Manager it is correct,however Hero is given to somebody else!

[_DS_]

Probably table was damaged, search can give inpredictable results then. Heroes generated by simple sql query.

[fokys]

ok which would be the best way to set Heros who supose to be Heros?
Can i use in game command from admin panel?

[_DS_]

Stop server, set them in table and start. But you already lost other bonuses - points for hero, crp, etc.

[fokys]

ok so i guess it is table Heroes

I have Values: CharID,Class_Id,Count,played,message!

I was just wondering how to set it up because in this table i have more then one character with same class_id!

Or there is another way?

[fokys]

does it have to be set to 1 in field played to make character hero?

Because i have lets say 3 players with class ID 94 and only one has value 1 in played field!