Jump to content
  • 0

Grand Olympiad Manager


Question

Posted (edited)

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

 

147d1e091e94830a6d562dd53069c632885.png

 

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 by Novamatus

2 answers to this question

Recommended Posts

  • 0
Posted (edited)

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

Edited by Novamatus

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...