aanmelden clan

febol · 18 September 2011

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&nbsp;</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;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<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); ?>

Toon Meer

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&nbsp;</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;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<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); ?>

Toon Meer

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

228 Nieuwe domeinnamen Mei 2025

Hulp bij instalatie Mafia Source

193 Nieuwe domeinnamen April 2025

aanmelden clan

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Delen