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 ?
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
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
Question
ucko1991
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 ?
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 htmltext2 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now