Jump to content
  • 0

[Help]Navicat


phantoml2

Question

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?

Link to comment
Share on other sites

Recommended Posts

  • 0

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;

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

 

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

                char_onlinetime = char_onlinetime/(60*60)
                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)

 

 

 

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

Link to comment
Share on other sites

  • 0
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 ?

Link to comment
Share on other sites

  • 0

Change:

 

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

 

to

 

htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + 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 by Solomun
Link to comment
Share on other sites

  • 0

Change:

 

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

 

to

 

htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + 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

Link to comment
Share on other sites

  • 0

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 by melron
Link to comment
Share on other sites

  • 0

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)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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...