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


×
×
  • 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