Help Olympic Ranking Update - Acys 368

[nortim]

Good afternoon mxc I found this mod in a forum, where it updates the ranking of the olympiadas daily, I wanted to modify it so that it updates every 1 hour during the period of the olympiads, how would it have to stay?

 

 

- private static final String GET_EACH_CLASS_LEADER = "SELECT characters.char_name from olympiad_nobles_eom, characters WHERE characters.obj_Id = olympiad_nobles_eom.char_id AND olympiad_nobles_eom.class_id = ? AND olympiad_nobles_eom.competitions_done >= " + Config.ALT_OLY_MIN_MATCHES + " 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.obj_Id = olympiad_nobles.char_id AND olympiad_nobles.class_id = ? "
"AND olympiad_nobles.competitions_done >= 9 "
"ORDER BY olympiad_nobles.olympiad_points DESC, olympiad_nobles.competitions_done DESC LIMIT 10";

 

- PreparedStatement statement = con.prepareStatement(GET_EACH_CLASS_LEADER);

+ PreparedStatement statement = con.prepareStatement(GET_EACH_CLASS_LEADER_CURRENT);