• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Top Guild

A

AnimeX

New Member
Joined
Feb 23, 2016
Messages
8
Reaction score
0
and I wanted someone puts up this top guild is to show the owner of the guild (leader)

<?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>';
?>

add something like this:

<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>
<td width="15%"><b><font color=white><center>Leader</center></b></font></td>

Pos/Logo/Guild Name /Kills/Leader
1 /Img.gif/ Heros / 123/ Atrix

Can anyone do this to me
 
Sort by date Sort by votes
AnimeX said:
Help
Click to expand...

PHP: 
<?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>
<td width="30%"><b><font color=white><center>Leader</center></b></font></td>
</tr>';


$i = 0;
foreach($SQL->query('SELECT `g`.`id` AS `id`, (SELECT `p`.`name` FROM `players` p WHERE `g`.`ownerid` = `p`.`id`) AS leader, `g`.`name` AS `name` , `g`.`guild_logo` 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>
<td>
<center><a href="?subtopic=characters&name='.urlencode($guild['leader']).'">'.htmlspecialchars($guild['leader']).'</a></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>';
?>

Edit: ---> Demo, i did one for myself :p
 
Last edited:
Upvote 0 Downvote
Musztang said:
PHP: 
<?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>
<td width="30%"><b><font color=white><center>Leader</center></b></font></td>
</tr>';


$i = 0;
foreach($SQL->query('SELECT `g`.`id` AS `id`, (SELECT `p`.`name` FROM `players` p WHERE `g`.`ownerid` = `p`.`id`) AS leader, `g`.`name` AS `name` , `g`.`guild_logo` 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>
<td>
<center><a href="?subtopic=characters&name='.urlencode($guild['leader']).'">'.htmlspecialchars($guild['leader']).'</a></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>';
?>

Edit: ---> Demo, i did one for myself :p
Click to expand...

Mate you have add some to SQL?

just with this code, i have error Warning: Invalid argument supplied for foreach() in E:\xampp\htdocs\pages\topguilds.php on line 24
 
Upvote 0 Downvote
Vladimir Glebov said:
Mate you have add some to SQL?

just with this code, i have error Warning: Invalid argument supplied for foreach() in E:\xampp\htdocs\pages\topguilds.php on line 24
Click to expand...

For a 8.6, i dont think so... in my case i had to remake the query cuz i'm using a different frag system with storages.

Which TFS version r u? or if you have a clean database would be perfect.
 
Upvote 0 Downvote
Back
Top