Top in Gesior en latestnews.php

[bok]

i need put in lastnews.php

Top Experiencia​

(305) Lynxzappa Exp: 464044498

(300) Noviinha Exp: 441128691

(280) Tou Lombradinho Exp: 358714887

(273) Tittyz Exp: 334361897

(273) Pinki Exp: 333035942

 

[Cykotitan]

SELECT name, level, experience FROM players ORDER BY level DESC, experience DESC LIMIT 5

SELECT players.name, players.level, COUNT(players.id)
FROM killers LEFT JOIN player_killers ON player_killers.kill_id=killers.id LEFT JOIN players ON players.id=player_killers.player_id WHERE killers.unjustified=1
GROUP BY player_killers.player_id ORDER BY COUNT(players.id) DESC LIMIT 5

SELECT COUNT(player_deaths.id), players.name, players.level FROM player_deaths LEFT JOIN players ON players.id=player_deaths.player_id GROUP BY player_deaths.player_id ORDER BY COUNT(player_deaths.id) DESC LIMIT 5

SELECT (SUM(CASE WHEN itemtype=2148 THEN count END)+SUM(CASE WHEN itemtype=2152 THEN count END)*100+SUM(CASE WHEN itemtype=2160 THEN count END)*10000) money, players.name, players.level
FROM player_items LEFT JOIN players ON players.id=player_items.player_id GROUP By player_id ORDER BY money DESC LIMIT 5

now write PHP code to display/cache the results

 

[bok]

where I put the queries and functions?

 

[bok]

bump!!

 

[bok]

help

 

[bok]

BumP!!!

 

[BeniS]

Let me google that for you

 

[Cykotitan]

post with php or code tags, also use fetchAll because you expect multiple rows returned
your HTML table is also bad, you have 1 row with 4 columns but it should be 4 tables with 6 rows (heading + 5 content rows)

tip: use foreach to iterate over query results

 

[bok]

Bump!

 

[bok]

bump!

 

[bok]

BumP!!

 

[VirrageS]

There is something wrong with showing money.

$exp = $SQL->query('SELECT name, level, experience FROM players ORDER BY level DESC, experience DESC LIMIT 5');
$frag = $SQL->query('SELECT players.name, players.level, COUNT(players.id) FROM killers LEFT JOIN player_killers ON player_killers.kill_id=killers.id LEFT JOIN players ON players.id=player_killers.player_id WHERE killers.unjustified=1 GROUP BY player_killers.player_id ORDER BY COUNT(players.id) DESC LIMIT 5');
$death = $SQL->query('SELECT COUNT(player_deaths.id), players.name, players.level FROM player_deaths LEFT JOIN players ON players.id=player_deaths.player_id GROUP BY player_deaths.player_id ORDER BY COUNT(player_deaths.id) DESC LIMIT 5');
$mon = $SQL->query('SELECT (SUM(CASE WHEN itemtype=2148 THEN COUNT END)+SUM(CASE WHEN itemtype=2152 THEN COUNT END)*100+SUM(CASE WHEN itemtype=2160 THEN COUNT END)*10000) money, players.name, players.level FROM player_items LEFT JOIN players ON players.id=player_items.player_id GROUP BY player_id ORDER BY money DESC LIMIT 5');

$main_content .= '
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td>
			<table border="0" cellpadding="4" cellspacing="1" width="100%">
				<tr bgcolor="'.$config['site']['vdarkborder'].'">
					<td colspan="9" class="white" align="center"><b>Top Exp</b></td>
				</tr>';
				foreach($exp as $p)
				{
					$main_content .= '
					<tr class="'.(is_int($n/2)?'Odd':'Even').'">
						<td><small>('.$p['level'].') <a href="index.php?subtopic=characters&name='.urlencode($p['name']).'">'.$p['name'].'</a><br><b>Exp:</b> '.$p['experience'].'</small></td>
					</tr>';$n++;
				}
				for($i = $n; $i < 5; $i++)
				{
					$main_content .= '<tr class="'.(is_int($n/2)?'Odd':'Even').'"><td><small>&nbsp;<br>&nbsp;</small></td></tr>';
					$n++;
				}
			$main_content .= '
			</table>
		</td>
		<td>
			<table border="0" cellpadding="4" cellspacing="1" width="100%">
				<tr bgcolor="'.$config['site']['vdarkborder'].'">
					<td colspan="9" class="white" align="center"><b>Top Frags</b></td>
				</tr>';$n=0;
				foreach($frag as $p)
				{
					$main_content .= '
					<tr class="'.(is_int($n/2)?'Odd':'Even').'">
						<td><small>('.$p[1].') <a href="index.php?subtopic=characters&name='.urlencode($p[0]).'">'.$p[0].'</a><br><b>Frags:</b> '.$p[2].'</small></td>
					</tr>';$n++;
				}
				for($i = $n; $i < 5; $i++)
				{
					$main_content .= '<tr class="'.(is_int($n/2)?'Odd':'Even').'"><td><small>&nbsp;<br>&nbsp;</small></td></tr>';
					$n++;
				}
			$main_content .= '
			</table>
		</td>
		<td>
			<table border="0" cellpadding="4" cellspacing="1" width="100%">
				<tr bgcolor="'.$config['site']['vdarkborder'].'">
					<td colspan="9" class="white" align="center"><b>Top Deaths</b></td>
				</tr>';$n=0;
				foreach($death as $p)
				{
					$main_content .= '
					<tr class="'.(is_int($n/2)?'Odd':'Even').'">
						<td><small>('.$p[2].') <a href="index.php?subtopic=characters&name='.urlencode($p[1]).'">'.$p[1].'</a><br><b>Deaths:</b> '.$p[0].'</small></td>
					</tr>';$n++;
				}
				for($i = $n; $i < 5; $i++)
				{
					$main_content .= '<tr class="'.(is_int($n/2)?'Odd':'Even').'"><td><small>&nbsp;<br>&nbsp;</small></td></tr>';
					$n++;
				}
			$main_content .= '
			</table>
		</td>
		<td>
			<table border="0" cellpadding="4" cellspacing="1" width="100%">
				<tr bgcolor="'.$config['site']['vdarkborder'].'">
					<td colspan="9" class="white" align="center"><b>Top Money</b></td>
				</tr>';$n=0;
				foreach($mon as $p)
				{
					$main_content .= '
					<tr class="'.(is_int($n/2)?'Odd':'Even').'">
						<td><small>('.$p[2].') <a href="index.php?subtopic=characters&name='.urlencode($p[1]).'">'.$p[1].'</a><br><b>Gps:</b> '.$p[0].'</small></td>
					</tr>';$n++;
				}
				for($i = $n; $i < 5; $i++)
				{
					$main_content .= '<tr class="'.(is_int($n/2)?'Odd':'Even').'"><td><small>&nbsp;<br>&nbsp;</small></td></tr>';
					$n++;
				}
			$main_content .= '
			</table>
		</td>
	</tr>
</table>';

 

[bok]

thanks rep you!

 

[Cykotitan]

Seems legit