iemand enig iedee waarom hij het bij "dit is 1" wel doen en waarom hij het bij "dit is 2" niet
(bij code 2 heb ik op regel 192 tot regel 196 dat stukje toegevoegd) iemand enig iedee ? dankje
Dit is 1
PHP
<?php
include("_config2006.php");
if(! isset($_SESSION['login'])) {
header("Location: login.php");
exit;
}
include("_include-gevangenis.php");
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="<? echo $sitelink;?>/layout/layout<?php echo $page->layout; ?>/css/css.css">
</head>
<table width=100%>
<?php /* ------------------------- */
if(isset($_GET['x'])) {
$dbres = mysql_query("SELECT * FROM `[clans]` WHERE `name`='{$_GET['x']}'");
if($clan = mysql_fetch_object($dbres)) {
print " <tr><td class=\"subTitle\"><b>{$clan->name}</b></td></tr>\n";
print " <tr><td class=\"mainTxt\"><i>{$clan->info}</i></td></tr>\n";
print " <tr><td class=\"mainTxt\"><table width=100%>\n";
print <<<ENDHTML
<table align="right"><p><img src="{$clan->avatarc}" width="220" height="180"></p></tr></td>
<table align="left">
ENDHTML;
print " <tr><td width=100>Owner:</td> <td><a href=\"profile.php?x={$clan->owner}\">{$clan->owner}</a></td></tr>\n";
$dbres = mysql_query("SELECT `attack`,`defence`,`clicks`,`type` FROM `[users]` WHERE `clan`='{$clan->name}'");
print " <tr><td width=100>Members:</td> <td>". (mysql_num_rows($dbres)) ."</td></tr>\n";
while($member = mysql_fetch_object($dbres))
$power += round(($member->attack+$member->defence)/2+$member->clicks*5);
$power += ($clan->def_lvl1*1500)/2;
$power += ($clan->def_lvl4*20000)/2;
print " <tr><td width=100>Power:</td> <td>".number_format($power,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Land:</td> <td>".number_format($clan->land,0,',','.')."m<sup>2</sup></td></tr>\n";
print " <tr><td width=100>Contant:</td> <td>€".number_format($clan->cash,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Bank:</td> <td>€".number_format($clan->bank,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Clicks:</td> <td>".number_format($clan->clicks,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Clicks vandaag:</td> <td>{$clan->clickstoday}</td></tr>\n";
print " <tr><td width=100>Opgericht:</td> <td>{$clan->started}</td></tr>\n";
print " </table></td></tr>\n";
print " <tr><td align=\"right\"><table><tr><td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clan.php?p=join&clan={$clan->name}\">Join</a></td>";
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clanbezit.php?x={$clan->name}\">Bezittingen</a></td>";
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clan-donate.php?x={$clan->name}\">Doneren</a></td>";
if($data->clanlevel >= 7)
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clanwar.php?x={$clan->name}\">Attack</a></td>";
print "</tr></table></td></tr>\n <tr><td><br></td></tr>\n\n";
print <<<ENDHTML
<tr><td><table width=100%>
<tr><td align="center" class="subTitle" width=15><b>#</b></td>
<td class="subTitle" style="letter-spacing: normal;" align="center"><a href="clan.php?x={$clan->name}&s=login"><b>Nick</a></b></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=125><a href="clan.php?x={$clan->name}&s=rank"><b>Rank</b></a></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><a href="clan.php?x={$clan->name}&s=money"><b>Geld</b></a></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=75><a href="clan.php?x={$clan->name}&s=power"><b>Power</b></a></td></tr>
ENDHTML;
$begin = ($_GET['p'] >= 0) ? $_GET['p']*15 : 0;
if($_GET['s'] == "login")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `login` LIMIT $begin,15");
else if($_GET['s'] == "money")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `cash`+`bank` DESC,`login` ASC LIMIT $begin,15");
else if($_GET['s'] == "power")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY (`attack`+`defence`)/2+`clicks`*5 DESC,`login` ASC LIMIT $begin,15");
else
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `clanlevel` DESC,`login` ASC LIMIT $begin,15");
for($j=$begin+1; $member = mysql_fetch_object($dbres); $j++) {
$rank = Array("","Member","Recruiter","","","","Manager","Generaal","Leader","Owner");
$rank = $rank[$member->clanlevel];
$power = number_format(round(($member->attack+$member->defence)/2+$member->clicks*5),0,',','.');
$money = number_format($member->cash+$member->bank,0,',','.');
print <<<ENDHTML
<tr><td align="center" class="mainTxt">$j</td>
<td class="mainTxt"><a href="profile.php?x={$member->login}">{$member->login}</a></td>
<td align="center" class="mainTxt">$rank</td>
<td align="center" class="mainTxt">€$money</td>
<td align="center" class="mainTxt">$power</td></tr>
ENDHTML;
}
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='{$clan->name}'");
print "</table>\n\n<table width=100%>\n <tr><td class=\"mainTxt\" align=\"center\">";
if(mysql_num_rows($dbres) <= 15)
print "| 1 |</td></tr></table>\n";
else {
if($begin/15 == 0)
print "<< ";
else
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=". ($begin/15-1) ."\"><<</a> ";
for($i=0; $i<mysql_num_rows($dbres)/15; $i++) {
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=$i\">". ($i+1) ."</a> ";
}
if($begin+15 >= mysql_num_rows($dbres))
print ">> ";
else
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=". ($begin/15+1) ."\">>></a>";
print " </table></td></tr>\n";
}
}
}
else if($_GET['p'] == "list") {
print " <tr><td><table width=100%>\n";
print " <tr><td class=\"subTitle\" style=\"letter-spacing: normal;\"><b>Clan</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>Members</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` 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) {
arsort($info);
foreach($info as $name => $power) {
$dbres = mysql_query("SELECT `name`,`owner`,`type` 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);
$type2 = Array("","Drugsdealers","Wetenschappers","Politie");
$type2 = $type2[$clan->type];
print " <tr><td class=\"mainTxt\"><a href=\"?x=$name\">$name</a></td> <td class=\"mainTxt\" width=125><a href=\"profile.php?x={$clan->owner}\">{$clan->owner}</a></td> <td class=\"mainTxt\" align=\"center\" width=75>$nummembers</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</td></tr>\n";
else
print "</tr>\n";
$lasttype = $type;
}
}
print " </table></td></tr>\n";
$db = mysql_query("SELECT `name` FROM `[clans]`");
$num = mysql_num_rows($db);
echo "<tr><td class=Maintxt>Er zijn momenteel <b>$num</b> clans in het spel</tr></td>";
}
else if($_GET['p'] == "join") {
if($data->clanlevel == 0) {
print " <tr><td class=\"subTitle\"><b>Meld je aan bij een clan</b></td></tr>\n";
if(isset($_POST['clan'])) {
$dbres2 = mysql_query("SELECT * FROM `[clanban]` WHERE `clan`='{$_POST['clan']}' AND `speler`='$data->login'");
if(mysql_num_rows($dbres2) != 0){
print "<table width=100%><tr><td class=\"mainTxt\"><b> {$data->login} </b> je bent verbannen uit die clan!<br>daar kun je niet meer in..</td></tr></table>\n";
exit;
}
$dbres2 = mysql_query("SELECT * FROM `[users]` WHERE `clan`='{$_POST['clan']}' OR `clan`='{$_POST['clan']}-[recruit]' AND `clanlevel` > 0");
if(mysql_num_rows($dbres2) > 29){
print "<table width=100%><tr><td class=\"mainTxt\">Er zitten al 30 leden in die clan!<br> of er zijn al meer aanmeldingen geweest die eerst moeten worden gedaan</td></tr></table>\n";
exit;
}
$clan = substr($_POST['clan'],0,32);
$dbres = mysql_query("SELECT `name`,`owner`,`type` FROM `[clans]` WHERE `name`='{$_POST['clan']}'");
if($clan = mysql_fetch_object($dbres)) {
$data->clan = "{$clan->name}-[recruit]";
mysql_query("UPDATE `[users]` SET `clan`='{$clan->name}-[recruit]' WHERE `login`='{$data->login}'");
print " <tr><td class=\"mainTxt\">Je hebt je aangemeld bij {$clan->name}</td></tr>\n";
}
else
print " <tr><td class=\"mainTxt\"><b>Die clan bestaat niet!</b></td></tr>\n";
exit;
}
print " <tr><td class=\"mainTxt\" align=\"left\"><form method=\"post\"> <b>Clan: </b><input type=\"text\" name=\"clan\" value=\"{$_GET['clan']}\" maxlength=32> <input type=\"submit\" value=\"Meld aan\"></td></tr>\n";
}
else
print " <tr><td class=\"mainTxt\">Je zit al in een clan</td></tr>\n";
}
else if($_GET['p'] == "new" && $data->clanlevel == 9) {
print " <tr><td class=\"subTitle\"><b>Clan oprichten</b></td></tr>\n";
if(isset($_POST['name'])) {
$_POST['name'] = substr($_POST['name'],0,16);
if(preg_match('/^[A-Za-z0-9_\- ]+$/',$_POST['name'])) {
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
$dbres = mysql_query("SELECT `name` FROM `[clans]` WHERE `name`='{$_POST['name']}'");
if(mysql_num_rows($dbres) == 0) {
$dbres = mysql_query("SELECT `land` FROM `[clans]`");
$land = 0;
while($clan = mysql_fetch_object($dbres))
$land += $clan->land;
if(9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 - $land >= 300) {
$data->clan = $_POST['name'];
$data->clanlevel = 9;
mysql_query("UPDATE `[users]` SET `clan`='{$_POST['name']}',`clanlevel`=9 WHERE `login`='{$data->login}'");
mysql_query("INSERT INTO `[clans]`(`name`,`owner`,`started`,`type`) values('{$_POST['name']}','{$data->login}',NOW(),1)");
print " <tr><td class=\"mainTxt\"><b>Je hebt een clan opgericht!</b><br><i>Je word nu terug gestuurd naar je hoofdkwartier!</i></td></tr>\n<script language=\"javascript\">\nsetTimeout(\"parent.window.location.reload()\",1000)\n</script>\n";
exit;
}
else
exit;
}
else
print " <tr><td class=\"mainTxt\">Er is al een clan met die naam</td></tr>\n";
exit;
}
else
print " <tr><td class=\"mainTxt\">Er mogen alleen letters, nummers, _ - en spaties in de clan-name zitten</td></tr>\n";
}
else if($data->gold > 122 && $data->login != Webbie){
print "<tr><td class=maintxt>Alleen Gold accounts mogen een eigen clan oprichten!<br><a href=gold.php><b>Klik hier</b></a> om een Gold account te nemen! <i>Automatisch!</i>";
exit;
}
echo " <tr><td class=maintxt align=left>Als je een clan maakt, gebruik dan een normale naam!<BR>Geen scheldwoorden, beledigingen, ziekte's enz.<br>Word dat wel gedaan? Dan word ja clan verwijderd. <br>En bij meerdere overtredingen word je account verbannen";
}
else if($_GET['p'] == "quit" && $data->clanlevel > 0 && $data->clanlevel < 9) {
print " <tr><td class=\"subTitle\"><b><font color=red>FOUT</font></b></td></tr>\n";
if(isset($_POST['quit'])) {
$data->clan = "";
$data->clanlevel = 0;
mysql_query("UPDATE `[users]` SET `clan`='',`clanlevel`=0 WHERE `login`='{$data->login}'");
print <<<ENDHTML
<tr><td class="mainTxt">Je bent uit de clan gestapt</td></tr>
<script language="javascript">
setTimeout("parent.window.location.reload()",2000);
</script>
ENDHTML;
}
else if(isset($_POST['cancel'])) {
print <<<ENDHTML
<script language="javascript">
document.location = "hq.php";
</script>
ENDHTML;
}
else {
print <<<ENDHTML
<tr><td class="mainTxt" align="center"><form method="post"><br><br>
<font color=red> Fout ga terug </font>
</form></td></tr>
ENDHTML;
}
}
else if($_GET['p'] == "delete" && $data->clanlevel == 9) {
print " <tr><td class=\"subTitle\"><b>Verwijder de clan</b></td></tr>\n";
if(isset($_POST['delete'])) {
$dbres = mysql_query("SELECT `login` FROM `[users]` WHERE `clan`='{$data->clan}' OR `clan`='{$data->clan}-[recruit]'");
while($member = mysql_fetch_object($dbres))
mysql_query("UPDATE `[users]` SET `clan`='',`clanlevel`=0 WHERE `clan`='{$data->clan}' OR `clan`='{$data->clan}-[recruit]'");
mysql_query("DELETE FROM `[clans]` WHERE `name`='{$data->clan}'");
$data->clan = "";
$data->clanlevel = 0;
print <<<ENDHTML
<tr><td class="mainTxt">De clan is opgeheven</td></tr>
<script language="javascript">
setTimeout("parent.window.location.reload()",2000);
</script>
ENDHTML;
}
else if(isset($_POST['cancel'])) {
print <<<ENDHTML
<script language="javascript">
document.location = "hq.php";
</script>
ENDHTML;
}
else {
print <<<ENDHTML
<tr><td class="mainTxt" align="center"><form method="post">
Weet je zeker dat je de clan op wilt verwijderen?<br><br>
<input type="submit" name="delete" value="Ja" style="width: 100px;">
<input type="submit" name="cancel" value="Nee" style="width: 100px;">
</form></td></tr>
ENDHTML;
}
}
/* ------------------------- */ ?>
</table>
</body>
</html>
<noscript><noscript><plaintext><plaintext>
<?php mysql_close($MySQL); ?>Dit is 2
PHP
<?php
include("_config2006.php");
if(! isset($_SESSION['login'])) {
header("Location: login.php");
exit;
}
include("_include-gevangenis.php");
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="<? echo $sitelink;?>/layout/layout<?php echo $page->layout; ?>/css/css.css">
</head>
<table width=100%>
<?php /* ------------------------- */
if(isset($_GET['x'])) {
$dbres = mysql_query("SELECT * FROM `[clans]` WHERE `name`='{$_GET['x']}'");
if($clan = mysql_fetch_object($dbres)) {
print " <tr><td class=\"subTitle\"><b>{$clan->name}</b></td></tr>\n";
print " <tr><td class=\"mainTxt\"><i>{$clan->info}</i></td></tr>\n";
print " <tr><td class=\"mainTxt\"><table width=100%>\n";
print <<<ENDHTML
<table align="right"><p><img src="{$clan->avatarc}" width="220" height="180"></p></tr></td>
<table align="left">
ENDHTML;
print " <tr><td width=100>Owner:</td> <td><a href=\"profile.php?x={$clan->owner}\">{$clan->owner}</a></td></tr>\n";
$dbres = mysql_query("SELECT `attack`,`defence`,`clicks`,`type` FROM `[users]` WHERE `clan`='{$clan->name}'");
print " <tr><td width=100>Members:</td> <td>". (mysql_num_rows($dbres)) ."</td></tr>\n";
while($member = mysql_fetch_object($dbres))
$power += round(($member->attack+$member->defence)/2+$member->clicks*5);
$power += ($clan->def_lvl1*1500)/2;
$power += ($clan->def_lvl4*20000)/2;
print " <tr><td width=100>Power:</td> <td>".number_format($power,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Land:</td> <td>".number_format($clan->land,0,',','.')."m<sup>2</sup></td></tr>\n";
print " <tr><td width=100>Contant:</td> <td>€".number_format($clan->cash,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Bank:</td> <td>€".number_format($clan->bank,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Clicks:</td> <td>".number_format($clan->clicks,0,',','.')."</td></tr>\n";
print " <tr><td width=100>Clicks vandaag:</td> <td>{$clan->clickstoday}</td></tr>\n";
print " <tr><td width=100>Opgericht:</td> <td>{$clan->started}</td></tr>\n";
print " </table></td></tr>\n";
print " <tr><td align=\"right\"><table><tr><td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clan.php?p=join&clan={$clan->name}\">Join</a></td>";
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clanbezit.php?x={$clan->name}\">Bezittingen</a></td>";
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clan-donate.php?x={$clan->name}\">Doneren</a></td>";
if($data->clanlevel >= 7)
print "<td class=\"mainTxt\" width=100 align=\"center\"><a href=\"clanwar.php?x={$clan->name}\">Attack</a></td>";
print "</tr></table></td></tr>\n <tr><td><br></td></tr>\n\n";
print <<<ENDHTML
<tr><td><table width=100%>
<tr><td align="center" class="subTitle" width=15><b>#</b></td>
<td class="subTitle" style="letter-spacing: normal;" align="center"><a href="clan.php?x={$clan->name}&s=login"><b>Nick</a></b></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=125><a href="clan.php?x={$clan->name}&s=rank"><b>Rank</b></a></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><a href="clan.php?x={$clan->name}&s=money"><b>Geld</b></a></td>
<td class="subTitle" style="letter-spacing: normal;" align="center" width=75><a href="clan.php?x={$clan->name}&s=power"><b>Power</b></a></td></tr>
ENDHTML;
$begin = ($_GET['p'] >= 0) ? $_GET['p']*15 : 0;
if($_GET['s'] == "login")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `login` LIMIT $begin,15");
else if($_GET['s'] == "money")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `cash`+`bank` DESC,`login` ASC LIMIT $begin,15");
else if($_GET['s'] == "power")
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY (`attack`+`defence`)/2+`clicks`*5 DESC,`login` ASC LIMIT $begin,15");
else
$dbres = mysql_query("SELECT `login`,`attack`,`defence`,`clicks`,`bank`,`cash`,`clanlevel`,`type` FROM `[users]` WHERE `clan`='{$clan->name}' ORDER BY `clanlevel` DESC,`login` ASC LIMIT $begin,15");
for($j=$begin+1; $member = mysql_fetch_object($dbres); $j++) {
$rank = Array("","Member","Recruiter","","","","Manager","Generaal","Leader","Owner");
$rank = $rank[$member->clanlevel];
$power = number_format(round(($member->attack+$member->defence)/2+$member->clicks*5),0,',','.');
$money = number_format($member->cash+$member->bank,0,',','.');
print <<<ENDHTML
<tr><td align="center" class="mainTxt">$j</td>
<td class="mainTxt"><a href="profile.php?x={$member->login}">{$member->login}</a></td>
<td align="center" class="mainTxt">$rank</td>
<td align="center" class="mainTxt">€$money</td>
<td align="center" class="mainTxt">$power</td></tr>
ENDHTML;
}
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`='{$clan->name}'");
print "</table>\n\n<table width=100%>\n <tr><td class=\"mainTxt\" align=\"center\">";
if(mysql_num_rows($dbres) <= 15)
print "| 1 |</td></tr></table>\n";
else {
if($begin/15 == 0)
print "<< ";
else
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=". ($begin/15-1) ."\"><<</a> ";
for($i=0; $i<mysql_num_rows($dbres)/15; $i++) {
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=$i\">". ($i+1) ."</a> ";
}
if($begin+15 >= mysql_num_rows($dbres))
print ">> ";
else
print "<a href=\"clan.php?x={$clan->name}&s={$_GET['s']}&p=". ($begin/15+1) ."\">>></a>";
print " </table></td></tr>\n";
}
}
}
else if($_GET['p'] == "list") {
print " <tr><td><table width=100%>\n";
print " <tr><td class=\"subTitle\" style=\"letter-spacing: normal;\"><b>Clan</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>Members</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` 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) {
arsort($info);
foreach($info as $name => $power) {
$dbres = mysql_query("SELECT `name`,`owner`,`type` 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);
$type2 = Array("","Drugsdealers","Wetenschappers","Politie");
$type2 = $type2[$clan->type];
print " <tr><td class=\"mainTxt\"><a href=\"?x=$name\">$name</a></td> <td class=\"mainTxt\" width=125><a href=\"profile.php?x={$clan->owner}\">{$clan->owner}</a></td> <td class=\"mainTxt\" align=\"center\" width=75>$nummembers</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</td></tr>\n";
else
print "</tr>\n";
$lasttype = $type;
}
}
print " </table></td></tr>\n";
$db = mysql_query("SELECT `name` FROM `[clans]`");
$num = mysql_num_rows($db);
echo "<tr><td class=Maintxt>Er zijn momenteel <b>$num</b> clans in het spel</tr></td>";
}
else if($_GET['p'] == "join") {
if($data->clanlevel == 0) {
print " <tr><td class=\"subTitle\"><b>Meld je aan bij een clan</b></td></tr>\n";
if(isset($_POST['clan'])) {
$dbres2 = mysql_query("SELECT * FROM `[clanban]` WHERE `clan`='{$_POST['clan']}' AND `speler`='$data->login'");
if(mysql_num_rows($dbres2) != 0){
print "<table width=100%><tr><td class=\"mainTxt\"><b> {$data->login} </b> je bent verbannen uit die clan!<br>daar kun je niet meer in..</td></tr></table>\n";
exit;
}
$dbres2 = mysql_query("SELECT * FROM `[users]` WHERE `clan`='{$_POST['clan']}' OR `clan`='{$_POST['clan']}-[recruit]' AND `clanlevel` > 0");
if(mysql_num_rows($dbres2) > 29){
print "<table width=100%><tr><td class=\"mainTxt\">Er zitten al 30 leden in die clan!<br> of er zijn al meer aanmeldingen geweest die eerst moeten worden gedaan</td></tr></table>\n";
exit;
}
$clan = substr($_POST['clan'],0,32);
$dbres = mysql_query("SELECT `name`,`owner`,`type` FROM `[clans]` WHERE `name`='{$_POST['clan']}'");
if($clan = mysql_fetch_object($dbres)) {
$data->clan = "{$clan->name}-[recruit]";
mysql_query("UPDATE `[users]` SET `clan`='{$clan->name}-[recruit]' WHERE `login`='{$data->login}'");
print " <tr><td class=\"mainTxt\">Je hebt je aangemeld bij {$clan->name}</td></tr>\n";
}
else {
$type = Array("","drugsdealers","wetenschappers","agenten");
$type = $type[$clan->type];
print " <tr><td class=\"mainTxt\">Alleen $type kunnen zich aanmelden bij {$clan->name}</td></tr>\n";
}
}
else
print " <tr><td class=\"mainTxt\"><b>Die clan bestaat niet!</b></td></tr>\n";
exit;
}
print " <tr><td class=\"mainTxt\" align=\"left\"><form method=\"post\"> <b>Clan: </b><input type=\"text\" name=\"clan\" value=\"{$_GET['clan']}\" maxlength=32> <input type=\"submit\" value=\"Meld aan\"></td></tr>\n";
}
else
print " <tr><td class=\"mainTxt\">Je zit al in een clan</td></tr>\n";
}
else if($_GET['p'] == "new" && $data->clanlevel == 9) {
print " <tr><td class=\"subTitle\"><b>Clan oprichten</b></td></tr>\n";
if(isset($_POST['name'])) {
$_POST['name'] = substr($_POST['name'],0,16);
if(preg_match('/^[A-Za-z0-9_\- ]+$/',$_POST['name'])) {
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
if($_POST['name'] == ' ')
{
$_POST['name'] = str_replace(" ","*",$_POST['name']);
}
else
{
}
$dbres = mysql_query("SELECT `name` FROM `[clans]` WHERE `name`='{$_POST['name']}'");
if(mysql_num_rows($dbres) == 0) {
$dbres = mysql_query("SELECT `land` FROM `[clans]`");
$land = 0;
while($clan = mysql_fetch_object($dbres))
$land += $clan->land;
if(9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 - $land >= 300) {
$data->clan = $_POST['name'];
$data->clanlevel = 9;
mysql_query("UPDATE `[users]` SET `clan`='{$_POST['name']}',`clanlevel`=9 WHERE `login`='{$data->login}'");
mysql_query("INSERT INTO `[clans]`(`name`,`owner`,`started`,`type`) values('{$_POST['name']}','{$data->login}',NOW(),1)");
print " <tr><td class=\"mainTxt\"><b>Je hebt een clan opgericht!</b><br><i>Je word nu terug gestuurd naar je hoofdkwartier!</i></td></tr>\n<script language=\"javascript\">\nsetTimeout(\"parent.window.location.reload()\",1000)\n</script>\n";
exit;
}
else
exit;
}
else
print " <tr><td class=\"mainTxt\">Er is al een clan met die naam</td></tr>\n";
exit;
}
else
print " <tr><td class=\"mainTxt\">Er mogen alleen letters, nummers, _ - en spaties in de clan-name zitten</td></tr>\n";
}
else if($data->gold > 122 && $data->login != Webbie){
print "<tr><td class=maintxt>Alleen Gold accounts mogen een eigen clan oprichten!<br><a href=gold.php><b>Klik hier</b></a> om een Gold account te nemen! <i>Automatisch!</i>";
exit;
}
echo " <tr><td class=maintxt align=left>Als je een clan maakt, gebruik dan een normale naam!<BR>Geen scheldwoorden, beledigingen, ziekte's enz.<br>Word dat wel gedaan? Dan word ja clan verwijderd. <br>En bij meerdere overtredingen word je account verbannen";
}
else if($_GET['p'] == "quit" && $data->clanlevel > 0 && $data->clanlevel < 9) {
print " <tr><td class=\"subTitle\"><b><font color=red>FOUT</font></b></td></tr>\n";
if(isset($_POST['quit'])) {
$data->clan = "";
$data->clanlevel = 0;
mysql_query("UPDATE `[users]` SET `clan`='',`clanlevel`=0 WHERE `login`='{$data->login}'");
print <<<ENDHTML
<tr><td class="mainTxt">Je bent uit de clan gestapt</td></tr>
<script language="javascript">
setTimeout("parent.window.location.reload()",2000);
</script>
ENDHTML;
}
else if(isset($_POST['cancel'])) {
print <<<ENDHTML
<script language="javascript">
document.location = "hq.php";
</script>
ENDHTML;
}
else {
print <<<ENDHTML
<tr><td class="mainTxt" align="center"><form method="post"><br><br>
<font color=red> Fout ga terug </font>
</form></td></tr>
ENDHTML;
}
}
else if($_GET['p'] == "delete" && $data->clanlevel == 9) {
print " <tr><td class=\"subTitle\"><b>Verwijder de clan</b></td></tr>\n";
if(isset($_POST['delete'])) {
$dbres = mysql_query("SELECT `login` FROM `[users]` WHERE `clan`='{$data->clan}' OR `clan`='{$data->clan}-[recruit]'");
while($member = mysql_fetch_object($dbres))
mysql_query("UPDATE `[users]` SET `clan`='',`clanlevel`=0 WHERE `clan`='{$data->clan}' OR `clan`='{$data->clan}-[recruit]'");
mysql_query("DELETE FROM `[clans]` WHERE `name`='{$data->clan}'");
$data->clan = "";
$data->clanlevel = 0;
print <<<ENDHTML
<tr><td class="mainTxt">De clan is opgeheven</td></tr>
<script language="javascript">
setTimeout("parent.window.location.reload()",2000);
</script>
ENDHTML;
}
else if(isset($_POST['cancel'])) {
print <<<ENDHTML
<script language="javascript">
document.location = "hq.php";
</script>
ENDHTML;
}
else {
print <<<ENDHTML
<tr><td class="mainTxt" align="center"><form method="post">
Weet je zeker dat je de clan op wilt verwijderen?<br><br>
<input type="submit" name="delete" value="Ja" style="width: 100px;">
<input type="submit" name="cancel" value="Nee" style="width: 100px;">
</form></td></tr>
ENDHTML;
}
}
/* ------------------------- */ ?>
</table>
</body>
</html>
<noscript><noscript><plaintext><plaintext>
<?php mysql_close($MySQL); ?>