PoRnosJH Posted November 11, 2010 Share Posted November 11, 2010 Hello Guys i have a ''Top Online Players'' Npc....and i see the onlinetime of each player in seconds... i want to change it to see it as Hours... How i can do that? Here is my code... # ************** # * Top onlinetime * # ************** if event == "1" and check_money >= 7000 : st.takeItems(Money_ID,7000) total_asesinados = 0 htmltext_ini = "<html><head><title>Top Online Players</title></head><body><table width=300><tr><td><font color =\"63B2FF\">N°</td><td><center><font color =\"FFFF00\">.:: Player ::.</color></center></td><td><center>.:: Time ::.</center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE onlinetime>0 order by onlinetime desc limit 20") rs = pks.executeQuery() while (rs.next()) : min_con = 60 char_name = rs.getString("char_name") char_onlinetime = rs.getString("onlinetime") / int(min_con) total_asesinados = total_asesinados + int(char_onlinetime) pos = pos + 1 posstr = str(pos) if color == 1: color_text = "<font color =\"00FFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"63B2FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_onlinetime + "</center></td></tr>" elif color == 2: color_text = "<font color =\"C00000\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"63B2FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_onlinetime + "</center></td></tr>" htmltext_end = "</table><center><font color=\"FFFFFF\">" + "Total: " + str(total_asesinados) + " Hours.</center></body></html>" htmltext_onlinetime = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_onlinetime elif event == "1" and check_money < 7000 : htmltext = "<html><head><title>Top Online Players</title></head><body><font color =\"FF0000\">Sorry but you need to pay a small fee (7k adena) in order to see the list.<br>Get 7000 adena and come again.</body></html>" return htmltext ty..for your time Quote Link to comment Share on other sites More sharing options...
Question
PoRnosJH
Hello Guys i have a ''Top Online Players'' Npc....and i see the onlinetime of each player in seconds...
i want to change it to see it as Hours...
How i can do that?
Here is my code...
ty..for your time
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.