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

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.



×
×
  • Create New...