Goedemiddag,
Ik beheer zoals vele van jullie mijn eigen Criminals game.
Nu heb ik alleen een probleem ik heb een familie lijst alleen zijn de leden niet gesorteerd op power van de familie wat wel zo moet zijn.
En ik kom er ook echt niet uit.
Is er misschien iemand die mij hiermee kan helpen?
PHP
<?php /* ------------------------- */
include("_config2006.php");
if(! check_login()) {
header("Location: login.php");
exit;
}
if($data->clanlevel == 9) {
if(isset($_POST['change_owner']) && $_POST['owner'] != $data->login) {
$dbres = mysql_query("SELECT `login`,`level`,`clan` FROM `[users]` WHERE `login`='{$_POST['owner']}'");
if(($owner = mysql_fetch_object($dbres)) && $owner->clan == $data->clan && $owner->level & 0x01) {
mysql_query("UPDATE `[users]` SET `clanlevel`=1 WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `clanlevel`=9 WHERE `login`='{$owner->login}'");
mysql_query("UPDATE `[clans]` SET `owner`='{$owner->login}' WHERE `name`='{$data->clan}'");
header("Location: /clan.php?x={$data->clan}\n");
}
}
}
mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");
include("_include-gevangenis.php");
/* ------------------------- */ ?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="../layout/layout001/css/css.css">
</head>
<table width=100%>
<?php /* ------------------------- */
print " <tr><td><table width=100%>\n";
print " <tr><td class=\"subTitle\" style=\"letter-spacing: normal;\"><b>Familie</b></td> <td class=\"subTitle\" style=\"letter-spacing: normal;\" width=125><b>Owner</b></td> <td class=\"subTitle\" width=75 style=\"letter-spacing: normal;\"><b>Power</b></td></tr>\n";
$dbres = mysql_query("SELECT `name`,`owner`,`type`,`def_lvl1`,`homes` FROM `[clans]` ORDER BY `def_lvl1`");
while($clan = mysql_fetch_object($dbres)) {
$power = 0;
$dbres2 = mysql_query("SELECT `attack`,`defence`,`clicks` 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*3000)/2;
$power += ($clan->homes*1250)/2;
$clanpower[$clan->type][$clan->name] = $power;
}
$lasttype = 1;
foreach($clanpower as $type => $info) {
if($power != $clanpower)
print "";
arsort($info);
foreach($info as $name => $power) {
$dbres = mysql_query("SELECT `name`,`owner` FROM `[clans]` WHERE `name`='$name'");
$clan = mysql_fetch_object($dbres);
print " <tr><td class=\"mainTxt\"><a href=\"clan.php?x={$clan->name}\">{$clan->name}</a></td> <td class=\"mainTxt\" width=125><a href=\"profile.php?x={$clan->owner}\">{$clan->owner}</a></td> <td class=\"mainTxt\" align=\"right\" width=75>$power </td>";
if($data->clanlevel >= 7)
print " <td align=\"center\" class=\"mainTxt\" width=75><a href=\"clanwar.php?x=$name\">Attack</a></td></tr>\n";
else
print "</tr>\n";
}
}
print " </table></td></tr>\n";
/* ------------------------- */ ?>
</table>
</body>
</html>
<?
mysql_close();
ob_flush();
?>De bedoeling is dus om de families (clans) te sorteren op power van hoog naar laag.
Alvast bedankt!
