[Help]Navicat

phantoml2 · March 27, 2017

hello i have top online npc n my server and it takes the online time from navicat
but it navicat it count per seconds i want it counts per hours or days how can i do it?

phantoml2 · March 28, 2017

there isn't script error

melron · March 28, 2017

thats what i did...right?

((int)char_onlinetime)

no you have to declare a new int and save it inside..

Python doesnt accept int,string etc

so (my opinion) is :

# - - - - - - - -

# + Online Time +

# - - - - - - - -

if event == "6" and price >= PriceCount :

st.takeItems(PriceID,PriceCount)

htmltext_ini = "<html><head><center></head><body> <img src=\"l2ui.bbs_lineage2\" width=78 height=13><br1> <table width=280><tr><td width=40><center>Rank</color></center></td><td width=160><center>Name</color></center></td><td width=80><center>Online</color></center></td></tr><tr></tr>"

htmltext_info =""

color = 1

pos = 0

con = L2DatabaseFactory.getInstance().getConnection()

pks = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE onlinetime>0 and accesslevel=0 order by onlinetime desc limit 20")

rs = pks.executeQuery()

while (rs.next()) :

char_name = rs.getString("char_name")

char_onlinetime = rs.getString("onlinetime")

int_char_onlinetime = int(char_onlinetime)

pos = pos + 1

posstr = str(pos)

if color == 1:

color_text = ""

color = 2

htmltext_info = htmltext_info + "<tr><td><center>" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + int_char_onlinetime + "</center></td></tr>"

elif color == 2:

color_text = ""

color = 1

htmltext_info = htmltext_info + "<tr><td><center>" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + int_char_onlinetime + "</center></td></tr>"

htmltext_end = "</table></center></body></html>"

htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end

con.close()

return htmltext_pklist

elif event == "6" and price < PriceCount :

htmltext = "<html><body><center>Sorry! You do not have the necessary items.</center></body></html>"

return htmltext

QUEST = Quest(QuestId,str(QuestId) + "_" + QuestName,QuestDesc)

for npcId in NPC:

QUEST.addStartNpc(npcId)

QUEST.addTalkId(npcId)

Edited March 28, 2017 by melron

Solomun · March 28, 2017

So u have to save it in a variable before u use it? Seems weird, but i wont insist since i have no idea...Like i said, years..

melron · March 28, 2017

So u have to save it in a variable before u use it? Seems weird, but i wont insist since i have no idea...Like i said, years..

im not using too (Google answered not me :P)

Solomun · March 28, 2017

im not using too (Google answered not me :P)

[GR] λολ τώρα είδα τη διάφορα στις παρενθέσεις....τι αναπηρος :P

phantoml2 · March 28, 2017

any other advice?

Solomun · March 28, 2017

any other advice?

Did u try what melron suggested you?

phantoml2 · March 28, 2017

y

Did u try what melron suggested you?

yes script error

[Help]Navicat

Question

phantoml2

23 answers to this question

Recommended Posts

phantoml2

melron

Solomun

melron

Solomun

phantoml2

Solomun

phantoml2

Join the conversation

Posts

Topics

Browse

Activity

Store