\n";
$dbres = mysql_query("SELECT `name`,`url` FROM `[weapons]` WHERE `area`=8 OR `area`=8+{$clan->type} ORDER BY `area`,`costs`");
while($weapon = mysql_fetch_object($dbres)) {
$name = $weapon->name;
$type = Array("Huis" => "homes",
"Muur" => "def_lvl1",
"Coffeeshop" => "money_lvl1",
"Chemie Lab" => "money_lvl1",
"Aandeel" => "money_lvl1");
$type = $type[$weapon->name];
print " {$weapon->name}
![](\"images/{$weapon-) url}.gif\" height=75 width=100> | ". ($clan->{"$type"}) ." |
| \n";
$lastarea = $weapon->area;
}
print " | \n
| \n\n";
print <<
| # |
Nick |
Rank |
Geld |
Power |
ENDHTML;
$begin = ($_GET['p'] >= 0) ? $_GET['p']*30 : 0;
if($_GET['s'] == "login")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' AND `activated`=1 ORDER BY `login` LIMIT $begin,30");
else if($_GET['s'] == "money")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' AND `activated`=1 ORDER BY `cash`+`bank` DESC,`login` ASC LIMIT $begin,30");
else if($_GET['s'] == "power")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' AND `activated`=1 ORDER BY (`attack`+`defence`)/2+`clicks`*5 DESC,`login` ASC LIMIT $begin,30");
else
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' AND `activated`=1 ORDER BY `clanlevel` DESC,`login` ASC LIMIT $begin,30");
for($j=$begin+1; $member = mysql_fetch_object($dbres); $j++) {
$rank = Array("","Member","Recruiter","","","","Manager","Generaal","Leader","Owner");
$rank = $rank[$member->clanlevel];
$power = round(($member->attack+$member->defence)/2+$member->clicks*5);
$money = $member->cash+$member->bank;
print <<$j |
{$member->login} |
$rank |
\$$money |
$power |
ENDHTML;
}
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='{$clan->name}' AND `activated`=1");
print " \n\n\n | ";
if(mysql_num_rows($dbres) <= 30)
print "< 1 > | \n";
else {
if($begin/30 == 0)
print "<< ";
else
print "name}&s={$_GET['s']}&p=". ($begin/30-1) ."\"><< ";
for($i=0; $iname}&s={$_GET['s']}&p=$i\">". ($i+1) ." ";
}
if($begin+30 >= mysql_num_rows($dbres))
print ">> ";
else
print "name}&s={$_GET['s']}&p=". ($begin/30+1) ."\">>>";
print " | |
\n";
}
}
}
else if($_GET['p'] == "list") {
print " \n";
print " | Clan | Owner | Members | Power | \n";
$dbres = mysql_query("SELECT `name`,`owner`,`type`,`def_lvl1` FROM `[clans]` ORDER BY `type`");
while($clan = mysql_fetch_object($dbres)) {
$power = 0;
$dbres2 = mysql_query("SELECT `attack`,`defence`,`clicks`,`type` FROM `[users]` WHERE `clan`='{$clan->name}'");
while($member = mysql_fetch_object($dbres2))
$power += round(($member->attack+$member->defence)/2+$member->clicks*5);
$power += ($clan->def_lvl1*1500)/2;
$clanpower[$clan->type][$clan->name] = $power;
}
$lasttype = 1;
foreach($clanpower as $type => $info) {
if($type != $lasttype)
print "
| \n";
arsort($info);
foreach($info as $name => $power) {
$dbres = mysql_query("SELECT `name`,`owner` FROM `[clans]` WHERE `name`='$name'");
$clan = mysql_fetch_object($dbres);
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='$name'");
$nummembers = mysql_num_rows($dbres);
print " | $name | owner}\">{$clan->owner} | $nummembers | $power | ";
if($data->clanlevel >= 7)
print " Attack | \n";
else
print "\n";
$lasttype = $type;
}
}
print " |
\n";
}
else if($_GET['p'] == "join") {
if($data->clanlevel == 0) {
print "