Jump to content
  • 0

[Question] For Clan Ranking


Question

Posted

Hello i have problem and i don't know how to fix it i try to make npc who show clans by rank something like top 10 clans

i make

Rank/Clan lvl/Clan name but i want add and for crest but something not happen show only crest_id but not and crest any idea how can i make it to show crest not crest_id ?

 

4a9db395ec1a18295529e1595f84997f

 

	if event == "5" and count >= 10000 :
		st.takeItems(ADENA_ID,10000)
		htmltext_ini = "<html><head><title>Clan Information</title></head><body><table width=290><tr><td><center>Rank</center></td><td><center>Level</center></td><td><center>Clan Name</center></td><td><center>Crest</center></td></tr>"
		htmltext_info =""
		color = 1
		pos = 0
		con = L2DatabaseFactory.getInstance().getConnection()
		pks = con.prepareStatement("SELECT clan_name,clan_level,crest_id FROM clan_data WHERE clan_level>0 order by reputation_score desc limit 15")
		rs = pks.executeQuery()
		while (rs.next()) :
			clan_name = rs.getString("clan_name")
			clan_level = rs.getString("clan_level")
			crest_id = rs.getString("crest_id")
			pos = pos + 1
			posstr = str(pos)
			if color == 1:
				color_text = "<font color =\"effe00\">"
				color = 2
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"effe00\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + crest_id + "</center></td></tr>"
			elif color == 2:
				color_text = "<font color =\"06db33\">"
				color = 1
				htmltext_info = htmltext_info + "<tr><td><center><font color =\"06db33\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + crest_id + "</center></td></tr>"
		htmltext_pklist = htmltext_ini + htmltext_info
		con.close()
		return htmltext_pklist
	elif event == "5" and count < 10000 :
		htmltext = "<html><head><title>Clan Information</title></head><body><font color =\"FF0000\">You don't have enought adena.</body></html>"
		return htmltext

2 answers to this question

Recommended Posts

  • 0
Posted

crests are done via packets.. u cant invoke them in a html string.. lineages2's html engine dose not support it >.> also as i said before its done via user/char info packets ^^

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


  • Posts

    • do you happen to know which dll loads the files?
    • Big vouch for Splicho. He’s been one of the best guys in the L2 scene for a long time, always helping out and providing what’s needed. Solid dude and easy to work with.   If anyone wants to work with him, make sure you’re serious and don’t waste his time. He really wants to build something good that brings back the real Lineage 2 feeling and gives the community a good vibe. Transparency is important to him and that’s rare these days.   Before hitting him up, be honest with yourself if you actually want to commit. Too many people nowadays come with stupid ideas and end up ruining projects and wasting the time and effort others put in.   I 100% recommend working with this guy.
    • Dragonic 2 – High Five is a fully custom private server, built with an original visual identity and integrated premium systems. We offer a stable, modern, and optimized experience, combining classic High Five gameplay with new features created especially for the community. The server is live and available to all players. You can access the official website here: 👉 https://dragonic2.ddns.net/ If you encounter any bugs or issues, please report them so we can fix them as quickly as possible. Join the adventure and discover Dragonic 2 — High Five.
    • Yes I know that sounds hilarious, but I am looking for 1-2 passionate people that are down to team up on a project I wanted to "revive". We had a server up and running in 2023 and closed the same year due to the team splitting up for personal differences. However, thought of bringing it back.   What we have (In terms of infrastructure): - Website is up and running - Launcher is done - Dedicated server is up and running - Control Panel (Web) is in development, almost finished. We'll use my own one (https://nimeracp.com/)   What expansion did we pick? Well our project was based on Interlude, but we could expand anytime later with alternative servers/chronicles.   Who are we? Basically it's me and @protoftw at the moment. I've been dealing with the website + launcher and maybe java development (For now), proto with datapack/textures/htmls/npcs/zones etc.   What we're looking for: Just one or two people that love what they do and got the required expertise/skills to be a part of this. Whatever you're into, if you just want to be GM, Event GM, help with development or whatever, we look for any kind of addition to the team.   Reach out by adding me on discord. ID: splicho
  • 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