[Gesior ACC] Top Guilds

[vmAth 40]

 

Abra o arquivo topguilds.php, apague tudo e coloque lá:

 

<?PHP
$main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top 15 guilds on ' . $config['server']['serverName'] . '</h2></div>
<center><table border="0" cellspacing="1" cellpadding="4" width="80%">
<tr bgcolor="'.$config['site']['vdarkborder'].'">
	<td width="10%"><b><font color=white><center>Pos</font></center></b></td>
	<td width="20%"><b><font color=white><center>Logo</center></b></font></td>
	<td width="30%"><b><font color=white><center>Guild Name</center></b></font></td>
	<td width="20%"><b><font color=white><center>Kills</center></b></font></td>
</tr>';
$i = 0;
foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
  WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 15;') as $guild)
{
$i++;
$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '">
	<td>			
		<center>'.$i.'</center>
	</td>
	<td>			
		<center><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></center>
	</td>
	<td>
		<center><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></center>
	</td>
	<td>
		<center>' . $guild['frags'] . ' kills</center>
	</td>
</tr>';
}
$main_content .= '</table><br />';
$main_content .= '<div style="text-align: right; font-size: 10;">Based on <a href=http://otland.net/members/elf>Elf\'s</a> code. System  made by <a href=http://otland.net/members/kekox>Kekox.</a></div>';
?>

 

Créditos: Kekox

[shutup 10]

Hum... nunca tinha visto o script avulso. obrigado por trazer ao XTIBIA.

rep +

[AlexandreKG 134]

Legal já estive atrás desse sistema,obrigado por disponibilizar.

[AsLima 1]

 

Abra o arquivo topguilds.php, apague tudo e coloque lá:

 

<?PHP
	$main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top 15 guilds on ' . $config['server']['serverName'] . '</h2></div>
<center><table border="0" cellspacing="1" cellpadding="4" width="80%">
	<tr bgcolor="'.$config['site']['vdarkborder'].'">
		<td width="10%"><b><font color=white><center>Pos</font></center></b></td>
		<td width="20%"><b><font color=white><center>Logo</center></b></font></td>
		<td width="30%"><b><font color=white><center>Guild Name</center></b></font></td>
		<td width="20%"><b><font color=white><center>Kills</center></b></font></td>
	</tr>';
$i = 0;
foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
	`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
	FROM `killers` k
	LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
	LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
	LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
	LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
   WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
	GROUP BY `name`
	ORDER BY `frags` DESC, `name` ASC
	LIMIT 0, 15;') as $guild)
{
	$i++;
	$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '">
		<td>			
			<center>'.$i.'</center>
		</td>
		<td>			
			<center><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></center>
		</td>
		<td>
			<center><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></center>
		</td>
		<td>
			<center>' . $guild['frags'] . ' kills</center>
		</td>
	</tr>';
}
$main_content .= '</table><br />';
$main_content .= '<div style="text-align: right; font-size: 10;">Based on <a href=http://otland.net/members/elf>Elf\'s</a> code. System  made by <a href=http://otland.net/members/kekox>Kekox.</a></div>';
?>

Créditos: Kekox

 

 

Muito show!

 

Mas eu gostaria que fosse assim em meu otserv.

 

POS --------- LOGO ------------ GUILD ----------- PONTOS ----------- KILLs

 

Onde cada war system ganho, a guild levaria 3 pontos. Em caso de empate o desempate seria os kills.

 

Teria como fazer pra mim?

 

Grato.