Page 1 of 2

Olly problem

Posted: Tue Feb 01, 2011 12:40 pm
by 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!

Re: Olly problem

Posted: Tue Feb 01, 2011 12:44 pm
by _DS_
You should check olympiad log for hero generation.

Re: Olly problem

Posted: Tue Feb 01, 2011 12:59 pm
by 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!

Re: Olly problem

Posted: Tue Feb 01, 2011 2:02 pm
by _DS_
Post non-cutted log entries for both chars and generation.

Re: Olly problem

Posted: Tue Feb 01, 2011 2:17 pm
by 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!

Re: Olly problem

Posted: Tue Feb 01, 2011 2:24 pm
by _DS_
Post entries for those chars from olympiad_nobles_eom.

Re: Olly problem

Posted: Tue Feb 01, 2011 2:38 pm
by 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

Re: Olly problem

Posted: Tue Feb 01, 2011 3:07 pm
by _DS_
MyISAM ? Try to run repair on olympiad_nobles.

Re: Olly problem

Posted: Tue Feb 01, 2011 3:15 pm
by fokys
Can i lose any data?
Is there anyway i can manualy solve this problem?
It is only 4 characters!

Re: Olly problem

Posted: Tue Feb 01, 2011 3:19 pm
by 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!

Re: Olly problem

Posted: Tue Feb 01, 2011 4:03 pm
by _DS_
Probably table was damaged, search can give inpredictable results then. Heroes generated by simple sql query.

Re: Olly problem

Posted: Tue Feb 01, 2011 4:20 pm
by 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?

Re: Olly problem

Posted: Tue Feb 01, 2011 4:37 pm
by _DS_
Stop server, set them in table and start. But you already lost other bonuses - points for hero, crp, etc.

Re: Olly problem

Posted: Tue Feb 01, 2011 4:43 pm
by 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?

Re: Olly problem

Posted: Tue Feb 01, 2011 4:47 pm
by 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!