Help Grand Olympiad Manager

Novamatus · September 22, 2018

Hello. I'm using online olympiad ranking script on l2jfrozen. I want to make it load every match.

For example this is Duelist from __init__py file:

# Duelist
        if event == "88":

            INITIAL_HTML = "<html><head><title>Grand Olympiad Manager</title></head><body><center><font color=66cc00></font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td><center>Position</center></td><center><td>|</td></center><td><center>Player Name</center></td><center><td>|</td></center><td><center>Points</center></td><center><td>|</td></center><td><center>Participated</center></td></tr>"
            HTML_INFO =""            
            POSITION_VALUE_INITIAL = 0
            CONNECTION = L2DatabaseFactory.getInstance().getConnection()
            pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=88 and competitions_done>=1 order by olympiad_points desc, competitions_done desc");
            rs = pts.executeQuery()
            while (rs.next()) :
                CHAR_NAME = rs.getString("char_name")
                POINTS = rs.getString("olympiad_points")
                COMP_DONE = rs.getString("competitions_done")
                POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
                STRING_POSITION = str(POSITION_VALUE_INITIAL)
                HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
            HTML_END = "</table></body></html>"
            HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
            CONNECTION.close()
            return HTML_OLY

And this is from Olympiad.properties:

# The winners are updated only after the end of the Olympiad period
# Like L2OFF is True
AltOlyShowMonthlyWinners = False

I try to make it False and True, still not loading. Only after restart show on statistics. How can i make it load every match from 1 fight? Please help me.

Edited September 22, 2018 by Novamatus

Novamatus · September 22, 2018

Meh, how i see its loading, but not every match, loading around 20-25min. How to make load every fight?

Edited September 22, 2018 by Novamatus

Novamatus · September 23, 2018

Anyone?

Help Grand Olympiad Manager

Question

Novamatus

2 answers to this question

Recommended Posts

Novamatus

Novamatus

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store