Olly problem

[Ralm]

Isnt the hero chossen by his Wins Vs Loses??? Instead of points??

Everyone allways say that is chossen by the points, but I dont think so. See this examples:

Guy A: 50 matchs 30 wins 20 loses 0 Ties 20 points (win/lose : +10)
Guy B: 35 matchs 15 wins 20 loses 0 Ties 25 points (win/lose : -5)

I think guy A should be hero because have more matchs and more wins over his loses. And if you notice at the "Monument Of Heros" NPC, when you chose "I want to verify who is the hero of the era." and you chose an hero an press "View History" it wont show you what points have he made. Instead of that he show Win/Ties/Losses. And that makes more sence, because the points you win/lose varies too much on your oponent.

You may be asking: so what are points for?? So you can keep participating at Ollympiads.

[fokys]

If you read rules with olly manager it says hero is calculated by points as long as they have 9 matches and at least 1 win!

[SolidSnake]

Isnt the hero chossen by his Wins Vs Loses??? Instead of points??

Everyone allways say that is chossen by the points, but I dont think so. See this examples:

Guy A: 50 matchs 30 wins 20 loses 0 Ties 20 points (win/lose : +10)
Guy B: 35 matchs 15 wins 20 loses 0 Ties 25 points (win/lose : -5)

I think guy A should be hero because have more matchs and more wins over his loses. And if you notice at the "Monument Of Heros" NPC, when you chose "I want to verify who is the hero of the era." and you chose an hero an press "View History" it wont show you what points have he made. Instead of that he show Win/Ties/Losses. And that makes more sence, because the points you win/lose varies too much on your oponent.

You may be asking: so what are points for?? So you can keep participating at Ollympiads.

Grand Olympiad Operator:
You must earn Grand Olympiad Points in order to become a hero. The person who acquires the most points in each class is selected to become the hero of that period. If you participate in a certain number of games, you can also exchange Grand Olympiad Points for Olympiad Tokens.

This html is the same on official servers.

[bareta]

the issue is not about what the tiebreakers, if at the end of the month two or more players are on the same score?

[_DS_]

Guys, did you try to read code instead of discussing ?

Code: Select all

    private static final String GET_EACH_CLASS_LEADER = "SELECT characters.char_name from olympiad_nobles_eom, characters "        + "WHERE characters.charId = olympiad_nobles_eom.charId AND olympiad_nobles_eom.class_id = ? "        + "AND olympiad_nobles_eom.competitions_done >= 9 "        + "ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_CURRENT = "SELECT characters.char_name from olympiad_nobles, characters "        + "WHERE characters.charId = olympiad_nobles.charId AND olympiad_nobles.class_id = ? "        + "AND olympiad_nobles.competitions_done >= 9 "        + "ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC, olympiad_nobles.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_SOULHOUND = "SELECT characters.char_name from olympiad_nobles_eom, characters "        + "WHERE characters.charId = olympiad_nobles_eom.charId AND (olympiad_nobles_eom.class_id = ? OR olympiad_nobles_eom.class_id = 133) "        + "AND olympiad_nobles_eom.competitions_done >= 9 "        + "ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_CURRENT_SOULHOUND = "SELECT characters.char_name from olympiad_nobles, characters "        + "WHERE characters.charId = olympiad_nobles.charId AND (olympiad_nobles.class_id = ? OR olympiad_nobles.class_id = 133) "        + "AND olympiad_nobles.competitions_done >= 9 "        + "ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC, olympiad_nobles.competitions_won DESC LIMIT 10"; 

[fokys]

like u sad it could be damaged sql table because in Ranking List when u speak with Olly manager everything was correct but heros were given to different characters!

One other thing i could think of was my website,because i had all olly points displayed on my page maybe this could cause that problem!

[Ralm]

Guys, did you try to read code instead of discussing ?

Code: Select all

    private static final String GET_EACH_CLASS_LEADER = "SELECT characters.char_name from olympiad_nobles_eom, characters "        + "WHERE characters.charId = olympiad_nobles_eom.charId AND olympiad_nobles_eom.class_id = ? "        + "AND olympiad_nobles_eom.competitions_done >= 9 "        + "ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_CURRENT = "SELECT characters.char_name from olympiad_nobles, characters "        + "WHERE characters.charId = olympiad_nobles.charId AND olympiad_nobles.class_id = ? "        + "AND olympiad_nobles.competitions_done >= 9 "        + "ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC, olympiad_nobles.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_SOULHOUND = "SELECT characters.char_name from olympiad_nobles_eom, characters "        + "WHERE characters.charId = olympiad_nobles_eom.charId AND (olympiad_nobles_eom.class_id = ? OR olympiad_nobles_eom.class_id = 133) "        + "AND olympiad_nobles_eom.competitions_done >= 9 "        + "ORDER BY olympiad_nobles_eom.olympiad_points DESC, olympiad_nobles_eom.competitions_done DESC, olympiad_nobles_eom.competitions_won DESC LIMIT 10";    private static final String GET_EACH_CLASS_LEADER_CURRENT_SOULHOUND = "SELECT characters.char_name from olympiad_nobles, characters "        + "WHERE characters.charId = olympiad_nobles.charId AND (olympiad_nobles.class_id = ? OR olympiad_nobles.class_id = 133) "        + "AND olympiad_nobles.competitions_done >= 9 "        + "ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC, olympiad_nobles.competitions_won DESC LIMIT 10"; 

ok Ds Thanks. Ok now I beleive that is from points.
About the Code, I dont really know where stuff is yet. I havent search around, I need to win some practice. =)

[dark911_ro]

@ ralm , the code is in java/com/l2jserver/gameserver/model/olympiad/olympiad.java


@DS
I'm still not getting it ... what's wrong with this code ? looks fine by me....

If a player is playing 9 or more oly matches than hero is calculated by points , than by matches played than by matches won ..


or maybe this ?

private static final String GET_EACH_CLASS_LEADER_CURRENT = "SELECT characters.char_name from olympiad_nobles_eom, characters "

We are a bunch of nabs that understand nothing or idk ...

[_DS_]

Nothing wrong with code.