Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
  • 0

[Help]Navicat

phantoml2

Asked by phantoml2,

 Share

Question

phantoml2 Newbie

phantoml2

Posted
Posted

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?

23 answers to this question

Recommended Posts

  • 0
Solomun Rookie

Solomun

Posted
Posted

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;

  • 0
SQL Developer Newbie

SQL Developer

Posted
Posted

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

  • 0
phantoml2 Newbie

phantoml2

Posted
  • Author
Posted

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

  • 0
phantoml2 Newbie

phantoml2

Posted
  • Author
Posted

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

  • 0
phantoml2 Newbie

phantoml2

Posted
  • Author
Posted

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)

  • 0
Solomun Rookie

Solomun

Posted
Posted

 

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

  • 0
phantoml2 Newbie

phantoml2

Posted
  • Author
Posted 
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 ?

  • 0
Solomun Rookie

Solomun

Posted
Posted (edited)

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
  • 0
Solomun Rookie

Solomun

Posted
Posted

Did python accept type casting?

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

  • 0
phantoml2 Newbie

phantoml2

Posted
  • Author
Posted

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

  • 0
Solomun Rookie

Solomun

Posted
Posted

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

 

 

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

  • 0
melron Community Regular

melron

Posted
Posted (edited)

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
  • 0
Solomun Rookie

Solomun

Posted
Posted

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)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • Constellation
      JewStor Service ➤ Verified Accounts, Drop Service etc.

      By Constellation · Posted

      Inventory restock: Premium business accounts are now available.   ✔ Wallester Business EU 🇪🇺|💳 Unlimited virtual cards, physical cards, 🏦 multi-currency IBAN, ₿ crypto & stablecoin deposits. ✔ Stripe Business UK 🇬🇧|💳 Instant virtual cards (Visa/Mastercard), high-conversion checkout, multi-currency payouts, ₿ crypto payments, no-code payment links. ✔ Mercury Business US 🇺🇸|🏦 US checking & savings, 💳 unlimited virtual cards, domestic & International wires, native stablecoin settlement. ✔ Payset Business EU 🇪🇺|🏦 Multiple IBANs, UK sort code, SEPA Instant, 💳 unlimited virtual cards, multi-currency accounts. ✔ Novo Business US 🇺🇸|🏦 Business checking account, ACH payments & invoicing, 💳 virtual & physical cards, novo boost.
    • THEFINK
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By THEFINK · Posted

      Let me see if I understand correctly, older gentlemen, when a newcomer shows up to create modern things with the help of AI, doing what you charge them to do, you point the finger and laugh. I believe that's why everything is stagnant. The product isn't for programming experts, it's for newcomers. Don't buy from you if they can do it themselves using this base. You're going to deliver a similar product, maybe even worse than this one, so why are you complaining? PowerShell, as you well know, started with it, then came new platforms and new apps, new creation models, all with different languages; I chose the simplest one for my taste. This is about being organized and knowing how to choose the right words for each situation. It's not 100%, but it already gives a good impression. Nothing is 100%, so a topic written by AI, and all the code that you charge an absurd amount for to prohibit and sell hacks, could be open source so that everyone can create new practices, new models, new information for passing packets, prohibiting the use of cheats that cause server owners to break so much. Let's remember that the Admin doesn't always shut down the server; it's the players who find problems and take advantage by buying and reselling items, and they say that the GM shuts down the server every week, but that's a lie. What they do is duplicate items with packages and sell them, but perhaps this could give some future developers a starting point to create their own protection following the model in the initial documentation. Because none of you answer a question from a newbie, you think you're superior because you have knowledge, but with AI, people like that can have the same knowledge as you, but with less practice. And if they practice a lot, 10,000 hours, they can be as good as all of you older developers in the L2J field.
    • 911reg
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By 911reg · Posted

      even the fucking post is AI, insane
    • BoostLike
      Boost-Like Store>GitHub Services: Followers, Stars, Forks

      By BoostLike · Posted

      ✨ Exclusive Offer for Marketplace Growth 🔥 Elevate your performance with a premium bonus. 💲 Top up your balance with $100 or more and receive an additional $5 credit — seamlessly added to your account. ⭐️ Designed for those who value efficiency, scale, and results. ⚡️ Effortless. Refined. Effective. 💥 Enhance your strategy today 💥
    • `Sanctus
      🧵 [FREE RELEASE] L2Updater + AntiCheat + Build System + Ful

      By `Sanctus · Posted

      Common AI Brazilian Slop

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..