0){ $dbres = mysql_query("SELECT `name`,`owner`,`def_lvl1` FROM `[clans]` ORDER BY `type`"); while ($clan = mysql_fetch_assoc($dbres)) { $power = 0; $dbres2 = mysql_query(" SELECT `attack`,`defence`,`clicks` FROM `[users]` WHERE `clan`='".$clan['name']."' "); while ($member = mysql_fetch_assoc($dbres2)) $power += round(($member['attack'] + $member['defence'])); $power += ($clan['def_lvl1'] * 1500) / 2; $clanpower[$clan['type']][$clan['name']] = $power; } $lasttype = 1; foreach ($clanpower as $type => $info) { arsort($info); foreach($info as $name => $power) { $dbres = mysql_query("SELECT `name`,`owner`,`type` FROM `[clans]` WHERE `name`='$name'"); $clan = mysql_fetch_assoc($dbres); $dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='$name'"); $nummembers = mysql_num_rows($dbres); ?> = 7) { ?> "; } ?>
Clan Lijst
Hieronder zie je een lijst van de clans.
Er zijn momenteel clan’s.
Naam Eigenaar Leden Actie
Aanvallen
Er zijn nog geen clans