Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

[help]Top Online Players

Absolute®

Asked by Absolute®,

 Share

Question

Absolute® Newbie

Absolute®

Posted
Posted

Καλημερα. Θελω να φτιαξω ενα script για τον server μου που να λεει τους πιο Active παιχτες (Top Online) μηπως γινεται κανεις να βοηθησει?

π.χ

#PK Info

	if event == "1" and cantidad_pago >= 0 :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Pk Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Kills</center></td></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 30")
		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 =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
		htmltext_end = "</table><center><font color=\"FFFFFF\">" + "A Total of " + str(total_asesinados) + " Pk's.</center></body></html>"
		htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_pklist
	elif event == "1" and cantidad_pago < 0 :
		htmltext = "<html><head><title>PK info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 0 adenas.</body></html>"
		return htmltext

 

σε αυτον τον τυπο αλλα για τους Top Online του server

 

ευχαριστω για την προσοχη σας :)

περιμενω οπωσδηποτε!!!

11 answers to this question

Recommended Posts

  • 0
valanths1990 Rookie

valanths1990

Posted
Posted

den kserw an ksexasa kati den to ekana test, se txt to ekana tis allages

#Top Online Info

	if event == "1" and cantidad_pago >= 0 :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Top Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Online Time</center></td></tr>"
		htmltext_info =""			
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		ontime = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE accesslevel=0 order by onlinetime desc limit 30")
		rs = ontime.executeQuery()
		while (rs.next()) :
			char_name = rs.getString("char_name")
			char_ontime = rs.getString("onlinetime")
			total_asesinados = total_asesinados + int(char_ontime)
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
		htmltext_end = "</table><center><font color=\"FFFFFF\">" + "A Total of " + str(total_asesinados) + " Pk's.</center></body></html>"
		htmltext_toponlinelist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_toponlinelist
	elif event == "1" and cantidad_pago < 0 :
		htmltext = "<html><head><title>=Online Info</title></head><body><font color =\"FF0000\">Primero pagame...!! son 0 adenas.</body></html>"
		return htmltext

  • 0
Absolute® Newbie

Absolute®

Posted
  • Author
Posted

den kserw an ksexasa kati den to ekana test, se txt to ekana tis allages

#Top Online Info

	if event == "1" and cantidad_pago >= 0 :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Top Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Online Time</center></td></tr>"
		htmltext_info =""			
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		ontime = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE accesslevel=0 order by onlinetime desc limit 30")
		rs = ontime.executeQuery()
		while (rs.next()) :
			char_name = rs.getString("char_name")
			char_ontime = rs.getString("onlinetime")
			total_asesinados = total_asesinados + int(char_ontime)
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
		htmltext_end = "</table><center><font color=\"FFFFFF\">" + "A Total of " + str(total_asesinados) + " Pk's.</center></body></html>"
		htmltext_toponlinelist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_toponlinelist
	elif event == "1" and cantidad_pago < 0 :
		htmltext = "<html><head><title>=Online Info</title></head><body><font color =\"FF0000\">Primero pagame...!! son 0 adenas.</body></html>"
		return htmltext

θα το δοκιμασω και θα σου πω σε ευχαριστω πολυ

  • 0
valanths1990 Rookie

valanths1990

Posted
Posted

ekei pou leei if event="1"

prepei na to tairiakseis me ton ipolipo kodika

diladi to if event="1" antistixi sto top pk px to event="2" sto top pvp

ara afto 8a prepei na ginei if event = "3" an me katalaves

 

kai an sou einai efkolo kane post olo ton kodika mazi me to eero pou sou evgale

  • 0
Absolute® Newbie

Absolute®

Posted
  • Author
Posted

ekei pou leei if event="1"

prepei na to tairiakseis me ton ipolipo kodika

diladi to if event="1" antistixi sto top pk px to event="2" sto top pvp

ara afto 8a prepei na ginei if event = "3" an me katalaves

 

kai an sou einai efkolo kane post olo ton kodika mazi me to eero pou sou evgale

3 το ειχα βαλει μου λεει Script Error

  • 0
Absolute® Newbie

Absolute®

Posted
  • Author
Posted

kane ligo post to arxeio me to error na dw pou ekana to la8os

 

 

#Top Online Info

	if event == "1" and cantidad_pago >= 0 :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Top Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Online Time</center></td></tr>"
		htmltext_info =""			
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		ontime = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE accesslevel=0 order by onlinetime desc limit 30")
		rs = ontime.executeQuery()
		while (rs.next()) :
			char_name = rs.getString("char_name")
			char_ontime = rs.getString("onlinetime")
			total_asesinados = total_asesinados + int(char_ontime)
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
		htmltext_end = "</table><center><font color=\"FFFFFF\">" + "A Total of " + str(total_asesinados) + " Pk's.</center></body></html>"
		htmltext_toponlinelist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_toponlinelist
	elif event == "1" and cantidad_pago < 0 :
		htmltext = "<html><head><title>=Online Info</title></head><body><font color =\"FF0000\">Primero pagame...!! son 0 adenas.</body></html>"
		return htmltext

αυτο ειναι το δικο σου

  • 0
valanths1990 Rookie

valanths1990

Posted
Posted

dokimase afto 

#Top Online Info

	if event == "1" :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Top Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Online Time</center></td></tr>"
		htmltext_info =""			
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		ontime = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE accesslevel=0 order by onlinetime desc limit 30")
		rs = ontime.executeQuery()
		while (rs.next()) :
			char_name = rs.getString("char_name")
			char_ontime = rs.getString("onlinetime")
			total_asesinados = total_asesinados + int(char_ontime)
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
		htmltext_end = "</table></body></html>"
		htmltext_toponlinelist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_toponlinelist

 

edit

  • 0
Absolute® Newbie

Absolute®

Posted
  • Author
Posted

dokimase afto 

#Top Online Info

	if event == "1" :
		st.takeItems(Precio_ID,0)
		total_asesinados = 0
		htmltext_ini = "<html><head><title>Top Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\"></td><td><center><font color =\"FFFF00\">Player</color></center></td><td><center>Online Time</center></td></tr>"
		htmltext_info =""			
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		ontime = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE accesslevel=0 order by onlinetime desc limit 30")
		rs = ontime.executeQuery()
		while (rs.next()) :
			char_name = rs.getString("char_name")
			char_ontime = rs.getString("onlinetime")
			total_asesinados = total_asesinados + int(char_ontime)
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"00FFFF\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"FF0000\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_ontime + "</center></td></tr>"
		htmltext_end = "</table></body></html>"
		htmltext_toponlinelist = htmltext_ini + htmltext_info + htmltext_end
		con.close()
		return htmltext_toponlinelist

 

edit

Σε ευχαριστω παρα πολυ

το δοκιμασα και δουλευει jet

εισαι τελειος :Ρ

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

×
 Share
Go to question listing


  • Posts

    • SocNet
      SOCNET | The Social Media acocunts at low prices!

      By SocNet · Posted

      Top Up the Way You Like — PayPal is Back with Us! We're excited to announce that we now accept PayPal again! That means even more ways to fund your balance in our store Available Payment Methods: ➡ Cryptocurrency (USDT, BTC, ETH, LTC, and more) ➡ Crypto Bot in Telegram ➡ Telegram Stars ➡ Bank Cards ➡ Lolz Balance ➡ Binance Pay ➡ Crystal Pay — crystalpay.io ➡ Wata (Bank Cards) ➡ Payeer ➡ AliPay ➡ PayPal (Friends & Family only) Also Available on the Website: ➡ Binance Gift Cards ➡ Google Pay/Apple Pay Promo Code: PAYPAL5 (5% Discount) How to Buy: ➡ Online Store: Click ➡ Telegram Bot: Click Other Services: ➡ SMM Panel: Click Returning customers enjoy extra discounts and promo codes! Support: ➡ Telegram: https://t.me/solomon_bog ➡ Telegram Channel: https://t.me/accsforyou_shop ➡ Discord: https://discord.gg/y9AStFFsrh ➡ WhatsApp: https://wa.me/79051904467 ➡ ✉ Email: solomonbog@socnet.store You can also use these contacts to: — Get consultation on wholesale purchases — Establish a partnership (Current partners: https://socnet.bgng.io/partners) — Become our supplier SocNet — Your Store for Digital Goods & Premium Subscriptions
    • SocNet
      SOCNET | The Social Media acocunts at low prices!

      By SocNet · Posted

      Top Up the Way You Like — PayPal is Back with Us! We're excited to announce that we now accept PayPal again! That means even more ways to fund your balance in our store Available Payment Methods: ➡ Cryptocurrency (USDT, BTC, ETH, LTC, and more) ➡ Crypto Bot in Telegram ➡ Telegram Stars ➡ Bank Cards ➡ Lolz Balance ➡ Binance Pay ➡ Crystal Pay — crystalpay.io ➡ Wata (Bank Cards) ➡ Payeer ➡ AliPay ➡ PayPal (Friends & Family only) Also Available on the Website: ➡ Binance Gift Cards ➡ Google Pay/Apple Pay Promo Code: PAYPAL5 (5% Discount) How to Buy: ➡ Online Store: Click ➡ Telegram Bot: Click Other Services: ➡ SMM Panel: Click Returning customers enjoy extra discounts and promo codes! Support: ➡ Telegram: https://t.me/solomon_bog ➡ Telegram Channel: https://t.me/accsforyou_shop ➡ Discord: https://discord.gg/y9AStFFsrh ➡ WhatsApp: https://wa.me/79051904467 ➡ ✉ Email: solomonbog@socnet.store You can also use these contacts to: — Get consultation on wholesale purchases — Establish a partnership (Current partners: https://socnet.bgng.io/partners) — Become our supplier SocNet — Your Store for Digital Goods & Premium Subscriptions
    • tomlondon12
      ✅ Mass DM Panel | Instagram, Twitter, Telegram and Discord!

      By tomlondon12 · Posted

      We are taking new orders. Kindly DM us on Telegram!
    • Noveria
      [L2PTS] Elmorelab

      By Noveria · Posted

      Dear friends, Just a reminder - our Open Beta Test begins today at 18:00! Join us to explore the world together, test the update, and help us make it even better. See you in game!    The Chronicle 4 client is now available for download.
    • SoftKill
      LineageII Freya H5 FakePlayer Single-Player(L2JServer)

      By SoftKill · Posted

      I tried mate with a fresh Freya, H5, H5 part 5, and always the same issue. I can't enter inside the Game, as it appears black. I. Can hear sound and so on from the starting location and quest, but I can't see a thing I installed the chinese language on windows, and still does not work , I always get black screen when i try to enter into the game after selecting the characters. I hear sounds, environment and so on, but i can see anything Also tried with a fresh freya client as well, i can see the english words and so on, but i cant enter inside the game...i dont understand whats going wrong

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock