HOW DO I ......................

04/18/2010 01:03 karnyge#1

Dumb question here folks lol

How do i get the 'Top Players' list on a website to indicate the players by pot, rather than experience, (or whatever it uses).

I am not asking for myself because i know nothing about webpage design. I ask because i have yet to see anything on this site resembling this particular query and thought some people would like to know.

04/18/2010 01:50 .Ash#2

Quote:

Originally Posted by karnyge

Dumb question here folks lol

How do i get the 'Top Players' list on a website to indicate the players by pot, rather than experience, (or whatever it uses).

I am not asking for myself because i know nothing about webpage design. I ask because i have yet to see anything on this site resembling this particular query and thought some people would like to know.

Well, you need a a source saying that this person have this much Potency, Then you can make an page for it to display, Example is provided below.

Code:

<?php
mysql_select_db($mydb);
	$rank = mysql_query("SELECT name,level,profession,[COLOR="Lime"]power[/COLOR] FROM cq_user WHERE name NOT LIKE '%[PM]%' AND  name NOT LIKE '%[GM]%' ORDER by [COLOR="Lime"]power[/COLOR] desc limit 50;");

	$i=1;
	while($row = mysql_fetch_array($rank)){
	if($row['profession']==10){
		$profesion='Mage';
	}
        if($row['profession']==30){
		$profesion='Paladin';
	}
	if($row['profession']==20){
		$profesion='Warrior';
	}
		echo '
    <td>'.$i.'-</td>
    <td><div align="center">'.$row['name'].'</td>
    <td><div align="center">'.$profesion.'</td>
    <td><div align="center">'.$row['[COLOR="Lime"]power[/COLOR]'].'</td>
    <td><div align="center">'.$row['level'].'</td>
  </tr> ';
  $i=$i+1;
	}


?>

I used power in cq_user. Replace the Green Color word to the Potency source.

04/18/2010 02:16 karnyge#3

So if i understand you correctly power = pot.
Yes?

thanks for the help.

04/18/2010 03:21 .Ash#4

no no lol i was just making power an example, Potency cant be in a DB, because its gained by Eudemons.

04/18/2010 04:47 karnyge#5

So how do i get it to display the, as an example, top ten players based on the pot available to them. I understand that bit about it based on the pets.
Do you know how this can be achieved?
Would it mean having the website codes point to cq_eudemon, or could there be another way?