- 0
-
Posts
-
-
-
By tomlondon12 · Posted
Accepting new orders, contact us for consulting! -
-
By UTCHIHAmkt · Posted
DISCORD : https://discord.com/users/325653525793210378 utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/uthciha-services https://campsite.bio/utchihaamkt
-
-
-
-
Topics
-
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
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.