[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?

Solomun · March 27, 2017

days = num_seconds / (60 * 60 * 24);
num_seconds -= days * (60 * 60 * 24);
hours = num_seconds / (60 * 60);
num_seconds -= hours * (60 * 60);
minutes = num_seconds / 60;

SQL Developer · March 27, 2017

You can create a new variable into the source to calculate the table value (seconds) with * / 60 * so the variable will get the minutes,then send the variable value to the npc dialog

phantoml2 · March 27, 2017

days = num_seconds / (60 * 60 * 24);

num_seconds -= days * (60 * 60 * 24);

hours = num_seconds / (60 * 60);

num_seconds -= hours * (60 * 60);

minutes = num_seconds / 60;

yes but how can i do it

phantoml2 · March 27, 2017

You can create a new variable into the source to calculate the table value (seconds) with * / 60 * so the variable will get the minutes,then send the variable value to the npc dialog

i really dont know how :S

Solomun · March 27, 2017

Then give us the code and will do it for you...Simple as that

phantoml2 · March 28, 2017

Then give us the code and will do it for you...Simple as that

it's not java code it's a rank npc but if you mean the init here it 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")

 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>" + 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>" + 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)

QUEST.addTalkId(npcId)

Solomun · March 28, 2017

# - - - - - - - -
 # + 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")

char_onlinetime = char_onlinetime/(60*60)
 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>" + 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>" + 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)
QUEST.addTalkId(npcId)

try this and make sure the line you add starts with TAB character, not spaces like i did

phantoml2 · March 28, 2017

import sys
from com.l2jfrozen.gameserver.model.actor.instance import L2PcInstance
from java.util import Iterator
from com.l2jfrozen.gameserver.datatables import SkillTable
from com.l2jfrozen.util.database import L2DatabaseFactory
from com.l2jfrozen.gameserver.model.quest import State
from com.l2jfrozen.gameserver.model.quest import QuestState
from com.l2jfrozen.gameserver.model.quest.jython import QuestJython as JQuest
#===================================================
qn = "2003_Ranking"
#===================================================
NPC=[9]
PriceID = 57
PriceCount = 0
QuestId     = 2003
QuestName   = "Ranking"
QuestDesc   = "custom"
InitialHtml = "1.htm"
#===================================================
print "(Added NPC Ranking SMZ & RTZ successfully)"
#===================================================
class Quest (JQuest) :

	def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)

	def onTalk (self,npc,player):
		return InitialHtml

	def onEvent(self,event,st):
		htmltext = event
		price = st.getQuestItemsCount(PriceID)
		
		# - - - - - - - - -
		# +  PvP Ranking  +
		# - - - - - - - - -
		if event == "1" and price >= PriceCount :
			st.takeItems(PriceID,PriceCount)
			total_asesinados = 0
			htmltext_ini = "<html><head><center></head><body><br><img src=\"l2ui.bbs_lineage2\" width=78 height=13><br1><br><br><table width=280><tr><td width=40><center><font color =\"FF0000\">Rank</center></td><td width=180><center>Name</center></td><td width=60><center>PVP's</color></center></td></tr><tr></tr>"
			htmltext_info =""			
			color = 1
			pos = 0
			con = L2DatabaseFactory.getInstance().getConnection()
			pks = con.prepareStatement("SELECT char_name,pvpkills FROM characters WHERE pvpkills>0 and accesslevel=0 order by pvpkills desc limit 20")
			rs = pks.executeQuery()
			while (rs.next()) :
				char_name = rs.getString("char_name")
				char_pkkills = rs.getString("pvpkills")
				total_asesinados = total_asesinados + int(char_pkkills)
				pos = pos + 1
				posstr = str(pos)
				if color == 1:
					color_text = "<font color =\"FFFFFF\">"
					color = 2
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
				elif color == 2:
					color_text = "<font color =\"00FF00\">"
					color = 1
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"00FF00\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
			htmltext_end = "</table></center></body></html>"
			htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end
			con.close()
			return htmltext_pklist
		elif event == "1" and price < PriceCount :
			htmltext = "<html><title>Rankings</title><body><center>Sorry!<br><br>You do not have the necessary items.</center></body></html>"
			return htmltext
		
		# - - - - - - - - -
		# +  PK Ranking   +
		# - - - - - - - - -
		if event == "2" and price >= PriceCount :
			st.takeItems(PriceID,PriceCount)
			total_asesinados = 0
			htmltext_ini = "<html><head><center></head><body><br><img src=\"l2ui.bbs_lineage2\" width=78 height=13><br1><br><br><table width=280><tr><td width=40><center><font color =\"FF0000\">Rank</center></td><td width=180><center>Name</center></td><td width=60><center>PK's</color></center></td></tr><tr></tr>"
			htmltext_info =""			
			color = 1
			pos = 0
			con = L2DatabaseFactory.getInstance().getConnection()
			pks = con.prepareStatement("SELECT char_name,pkkills FROM characters WHERE pkkills>0 and accesslevel=0 order by pkkills desc limit 20")
			rs = pks.executeQuery()
			while (rs.next()) :
				char_name = rs.getString("char_name")
				char_pkkills = rs.getString("pkkills")
				total_asesinados = total_asesinados + int(char_pkkills)
				pos = pos + 1
				posstr = str(pos)
				if color == 1:
					color_text = "<font color =\"FFFFFF\">"
					color = 2
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
				elif color == 2:
					color_text = "<font color =\"00FF00\">"
					color = 1
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"00FF00\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
			htmltext_end = "</table></center></body></html>"
			htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end
			con.close()
			return htmltext_pklist
		elif event == "2" and price < PriceCount :
			htmltext = "<html><title>Rankings</title><body><center>Sorry!<br><br>You do not have the necessary items.</center></body></html>"
			return htmltext
			
		# - - - - - - - - - - - - - -
		# + Clan Reputation ranking +
		# - - - - - - - - - - - - - -
		if event == "5" and price >= PriceCount :
			st.takeItems(PriceID,PriceCount)
			htmltext_ini = "<html><head><center></head><body><br><img src=\"l2ui.bbs_lineage2\" width=78 height=13><br1><br><br><table width=230><tr><td><font color =\"FF0000\">Rank</color></td><td><center><font color =\"FF0000\">Level</color></center></td><td><center><font color =\"FF0000\">Name</color></center></td><td><center><font color =\"FF0000\">Reputation</color></center></td></tr><tr></tr>"
			htmltext_info =""
			color = 1
			pos = 0
			con = L2DatabaseFactory.getInstance().getConnection()
			clan = con.prepareStatement("SELECT clan_name,clan_level,reputation_score FROM clan_data WHERE clan_level>0 order by reputation_score desc limit 5")
			rs = clan.executeQuery()
			while (rs.next()) :
				clan_name = rs.getString("clan_name")
				clan_level = rs.getString("clan_level")
				clan_score = rs.getString("reputation_score")
				pos = pos + 1
				posstr = str(pos)
				if color == 1:
					color_text = "<font color =\"FFFFFF\">"
					color = 2
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFF00\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + clan_score + "</center></td></tr>"
				elif color == 2:
					color_text = "<font color =\"FFFFFF\">"
					color = 1
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFF00\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + clan_score + "</center></td></tr>"
			htmltext_end = "</table></center></body></html>"
			htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end
			con.close()
			return htmltext_pklist
		elif event == "5" and price < PriceCount :
			htmltext = "<html><body><center>Sorry!<br><br>You do not have the necessary items.</center></body></html>"
			return htmltext
            
		 # - - - - - - - -
		 # + Online Time +
	     # - - - - - - - -					
		if event == "6" and price >= PriceCount :
			st.takeItems(PriceID,PriceCount)
			htmltext_ini = "<html><head><center></head><body><br><img src=\"l2ui.bbs_lineage2\" width=78 height=13><br1><br><br><table width=280><tr><td width=40><center><font color =\"FF0000\">Rank</color></center></td><td width=160><center><font color =\"FF0000\">Name</color></center></td><td width=80><center><font color =\"FF0000\">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")
				pos = pos + 1
				posstr = str(pos)
				if color == 1:
					color_text = "<font color =\"FFFFFF\">"
					color = 2
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_onlinetime + "</center></td></tr>"
				elif color == 2:
					color_text = "<font color =\"00FF00\">"
					color = 1
					htmltext_info = htmltext_info + "<tr><td><center><font color =\"00FF00\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + 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!<br><br>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)
 QUEST.addTalkId(npcId)

it's not java it's python and i tried the way you suggest me but when i press show me top online it opens a windows and writes script error any other suggest ?

Solomun · March 28, 2017

Change:

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

to

htmltext_info = htmltext_info + "<tr><td><center>" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + (((int)char_onlinetime)/(60*60))+ "</center></td></tr>"

Try this...(Ignore my previous suggestion, i did not see that the script takes the onlinetime as a string).

According to google, cast should be ok :P

In case of script error, can u post the error?

Edited March 28, 2017 by Solomun

melron · March 28, 2017

Did python accept type casting?

Solomun · March 28, 2017

Did python accept type casting?

Google said yes....And fuck, 5 years since i write something in python :(

phantoml2 · March 28, 2017

Change:

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

to

htmltext_info = htmltext_info + "<tr><td><center>" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + (((int)char_onlinetime)/(60*60))+ "</center></td></tr>"

Try this...(Ignore my previous suggestion, i did not see that the script takes the onlinetime as a string).

According to google, cast should be ok :P

In case of script error, can u post the error?

i did but it still remains the same nothing change and no error

Solomun · March 28, 2017

i did but it still remains the same nothing change and no error

In case of script error, can u post the error?

melron · March 28, 2017

Typecast in python:

To convert from a numeric type to a string:

number = 2

word = str(number )

To convert from a string type to an int:

test = "test"

number = int(test )

Edited March 28, 2017 by melron

Solomun · March 28, 2017

Typecast in python:

To convert from a string type to an int:

test = "test"

number = int(test )

thats what i did...right?

((int)char_onlinetime)

[Help]Navicat

Question

phantoml2

23 answers to this question

Recommended Posts

Solomun

SQL Developer

phantoml2

phantoml2

Solomun

phantoml2

Solomun

phantoml2

Solomun

melron

Solomun

phantoml2

Solomun

melron

Solomun

Join the conversation

Posts

Topics

Browse

Activity

Store