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..
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