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!