[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

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store