API tools faq
paste
Advertisement
marcopennekamp

A script of a browsergame I wrote years ago

marcopennekamp
Feb 9th, 2012
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 20.90 KB | None | 0 0
raw download clone embed print report
  1. // Or: What little kids do with PHP :D
  2.  
  3. <?php
  4.  
  5. if ($userally == '') {
  6.  
  7. $prfbews = "SELECT * FROM ally_bews WHERE usrid=$userid";
  8.  $prfbewsq = mysql_query($prfbews);
  9. $bews = mysql_num_rows($prfbewsq);
  10.  
  11. if ($bews == 0) {
  12.  
  13.  if ($urlloc == '' OR $urlloc == 'sally' OR $urlloc == 'gally') {
  14. echo "<table id='chtable'><tr>";
  15.  if ($urlloc == 'sally') {
  16.  
  17.  echo "<td style='background-image: url(\"style/interface/chtable-bg.png\");'>
  18.       <a href='?ally,sally'>Ally Suchen</a></td>&nbsp;&nbsp;";
  19.  }else{
  20.  echo "<td><a href='?ally,sally'>Ally Suchen</a></td>&nbsp;&nbsp;";
  21.  }
  22.  
  23.  if ($urlloc == 'gally') {
  24.  
  25.  echo "<td style='background-image: url(\"style/interface/chtable-bg.png\");'>
  26.       <a href='?ally,gally'>Ally Gründen</a></td>&nbsp;&nbsp;";
  27.  }else{
  28.  echo "<td><a href='?ally,gally'>Ally Gründen</a></td>&nbsp;&nbsp;";
  29.  }
  30.  echo "</tr></table>";
  31.  
  32. if ($urlloc == 'sally') {
  33.  
  34.     echo "<table id='suche' style='top: 200px;'><tr><td><form action='". $_SELF['PHP'] ."' method='POST'></td>
  35.          <td><select name='allyskat'>
  36.                         <option value='tag'>Tag</option>
  37.                         <option value='name'>Name</option>
  38.          </select></td>
  39.          <td><input type='text' class='input_text' name='sallyv'></td>
  40.          <td><input type='submit' class='sbutton' name='search' value='Suchen'></td></tr></form></table>";
  41.  
  42. if (isset($_POST['search'])) {
  43. $allyskat = $_POST['allyskat'];
  44. $sallyfor = $_POST['sallyv'];
  45. echo "<table id='table' style='top: 250px;'>";
  46. $ulsql = "SELECT * FROM allys WHERE ". $allyskat ." LIKE '%". $sallyfor ."%'";
  47.  $ulq = mysql_query($ulsql);
  48. while ($ulrow= mysql_fetch_assoc($ulq)) {
  49.  
  50.     $ulid = $ulrow['id'];
  51.     $ulname = $ulrow['name'];
  52.     $ulally = $ulrow['tag'];
  53.  
  54. echo "<tr><td><a href='?ally,bewerben,". $ulid . "'>" . $ulally . "</a></td>
  55.      <td>" . $ulname . "</td></tr>";
  56.  
  57.     }
  58. echo "</table>";
  59.   }
  60.  }else if ($urlloc == 'gally') {
  61.  
  62.     echo "<table id='table'><tr><form action='". $_SELF['PHP'] ."' method='POST' id='gcon'>
  63.          <td>Name:</td><td><input type='text' class='input_text' name='Name'></td></tr>
  64.          <td>Tag:</td><td><input type='text' class='input_text' name='Tag'  onchange='checkLength(this.value.length, \"4\",
  65.          \"<small>Das Tag darf <br>max 4 Zeichen haben</small>\", \"taglenghterror2\", \"g\");'
  66.          name='allytag'><p id='taglenghterror2'></td></tr>
  67.          <td></td><td><input type='submit' class='sbutton' name='g' id='g' value='Gründen'></td></tr></form></table>";
  68.  
  69.  
  70. if (isset($_POST['g'])) {
  71.  
  72.     $allytag = htmlentities($_POST['Tag']);
  73.     $allyname = htmlentities($_POST['Name']);
  74.    
  75.      
  76. $gallysql = "INSERT INTO allys VALUES('', '$allyname', '$allytag', '', '', '', '')";
  77.   mysql_query($gallysql);
  78.  
  79. $adaasql = "SELECT * FROM allys WHERE name='$allyname'";
  80.   $adaaq = mysql_query($adaasql);
  81. while ($adaarow= mysql_fetch_assoc($adaaq)) {
  82.  
  83.     $allyid = $adaarow['id'];
  84.  
  85. }  
  86.  
  87.  
  88. $memallysql = "INSERT INTO ally_member VALUES('$userid', '$allyid', 'Leader')";
  89. $rangallysql = "INSERT INTO ally_ränge VALUES('$allyid', 'Leader', '5')";
  90. $updtuserdata = "UPDATE userdata SET ally='$allyname' WHERE id='$userid'";
  91. mysql_query($memallysql);
  92. mysql_query($rangallysql);
  93. mysql_query($updtuserdata);
  94.  
  95.   }
  96.  }else if ($urlloc == 'bewerben') {
  97.  
  98.   $bewbsql = "SELECT * FROM allys WHERE id='$urlnum'";
  99.     $bewbq = mysql_query($bewbsql);
  100.  while ($bewbrow= mysql_fetch_assoc($bewbq)) {
  101.  
  102.   $bewaname = htmlentities($bewbrow['name']);
  103.   $bewatag = htmlentities($bewbrow['tag']);
  104.  
  105.  }
  106.  
  107.     echo "<table id='table'>
  108.          <form action='". $_SELF['PHP'] ."' method='POST'>
  109.          <tr><td> Allyname: </td><td> ". $bewaname ." [". $bewatag ."]&nbsp;</td></tr>
  110.          <tr><td>Bewerbungstext:</td><td>
  111.          <textarea name='btext' rows='10' cols='30'>". $muster ."</textarea></td></tr>
  112.          <tr><td><input type='button' value='Muster'></td>
  113.          <td><input type='submit' name='abs' value='Bewerben'></td></tr>
  114.          </form></table>";
  115.  
  116.     if (isset($_POST['abs'])) {
  117.    
  118.         $btext = nl2br(htmlentities($_POST['btext']));
  119.        
  120.        $insbewsql = "INSERT INTO ally_bews VALUES ('$urlnum', '$userid', '$btext')";
  121.         mysql_query($insbewsql);
  122.        
  123.         echo "<script type=\"text/javascript\">
  124.                   window.location.href=\"./game.php?ally\";
  125.              </script>";
  126.    
  127.     }
  128.  
  129.  
  130.   }
  131.  }  
  132. }
  133. }else if ($userally != '') {
  134.  
  135.   $absql = "SELECT * FROM allys WHERE name='$userally'";
  136.     $abq = mysql_query($absql);
  137. while ($abrow= mysql_fetch_assoc($abq)) {
  138.  
  139.   $abid = $abrow['id'];  
  140.   $abname = $abrow['name'];
  141.   $abtag = $abrow['tag'];
  142.   $abde = wordwrap(functionBBCode($abrow['descext'], 70 , "<br>", 1));
  143.   $abdi = wordwrap(functionBBCode($abrow['descint'], 70 , "<br>", 1));
  144.   $abpoints = $abrow['punkte'];
  145.   $abplace = $abrow['place'];
  146.  
  147.  }
  148.  
  149.  
  150.  
  151.  $umemsql = "SELECT * FROM ally_member WHERE usrid='$userid' AND allyid='$abid'";
  152.   $umemq = mysql_query($umemsql);  
  153. while ($umemrow= mysql_fetch_assoc($umemq)) {
  154.  
  155.     $allyusrrang = $umemrow['rang'];
  156.  
  157. }
  158.  
  159.   $rbsql = "SELECT * FROM ally_ränge WHERE allyid='$abid' AND rangname='$allyusrrang'";
  160.    $rbq = mysql_query($rbsql);
  161.  while ($rbrow= mysql_fetch_assoc($rbq)) {
  162.  
  163.     $rbrname = $rbrow['rangname'];
  164.     $rbrights = $rbrow['rangrights'];
  165.     $usrrights = $rbrow['rangrights'];
  166.  
  167.  }
  168.  
  169.   $bewssql = "SELECT * FROM ally_bews WHERE allyid='$abid'";
  170.     $bewsq = mysql_query($bewssql);
  171.      $bewsc = mysql_num_rows($bewsq);
  172.    
  173.       if ($bewsc == '') {
  174.      
  175.        $bewsc = '0';
  176.       }
  177.  
  178.   $countmsql = "SELECT * FROM ally_member WHERE allyid='$abid'";
  179.     $countmq = mysql_query($countmsql);
  180.    $countm = mysql_num_rows($countmq);
  181.  
  182. if ($urlloc == '') {
  183.  echo "<div><table><tr><td class='overtd' style='background-image: url(style/tables/ally-overdesc.png);'>
  184.      <b style='font-size: 15px; color: white;'>Ihre Allianz<b></td></tr></table>
  185.      
  186.      <table id='allytable1'><tr><td>Name:</td></tr>
  187.      <tr><td>Tag:</td></tr>
  188.      <tr><td>Mitglieder:</td></tr>
  189.      <tr><td>Punkte:</td></tr>
  190.      <tr><td>Ihr Rang:</td></tr>
  191.      </table>
  192.      
  193.      <table id='allytable2'>
  194.      <tr><td>" . $abname . "</td></tr>
  195.      <tr><td>". $abtag ."</td></tr>
  196.      <tr><td>". $countm; if ($userally == $abname) {
  197.       echo "<a href='?ally,members'>  (Memberliste)</a>";
  198.       }
  199.       echo "</td></tr>
  200.      <tr><td>". $abpoints ." (Platz: <b>". $abplace ."</b> )</td></tr>
  201.      <tr><td>". $allyusrrang; if ($usrrights > 3) {
  202.       echo "<a href='?ally,bally'> (Ally bearbeiten)</a>";
  203.      
  204.       }
  205.       echo "</td></tr>
  206.      </table>
  207.      
  208.      <table style='background-image: url('interface/button-drop.png');'>
  209.      <tr><td style='text-align: center; background-image: url(style/tables/ally-overdesc.png); height: 20px;
  210.      padding: 5px; width: 542px;'>
  211.      <b style='font-size: 15px; color: white;'>Externe Page<b></td></tr></table>
  212.      <table style='margin-top: -5px;' id='descext'>
  213.      <tr style='margin-top: -200px;'><td style='border-bottom: 5px solid black; border-top: 5px solid black;'>
  214.      <div style='min-height: 100px;'>". $abde ."</div></td></tr>
  215.      </table>
  216.      <br><br><br><br>
  217.      
  218.      <table><tr><td style='text-align: center; background-image: url(style/tables/ally-overdesc.png); height: 20px;
  219.      padding: 5px; width: 542px;'>
  220.      <b style='font-size: 15px; color: white;'>Interne Infos<b></td></tr></table>
  221.      <table style='margin-top: -5px;' id='descext'><tr><td style='border-bottom: 5px solid black; border-top: 5px solid black;'>
  222.      <div style='min-height: 100px;'>". $abdi ."</div></td></tr>
  223.      </table></div>";
  224. }else if ($urlloc == 'bally' && $usrrights >= '3') {
  225.  
  226.  
  227.     echo "<div style='position: relative; left: 80px; top: 25px;'>
  228.          ";
  229.           if ($rbrights == 5) {
  230.           echo "<a href='?ally,brang' class='typlink'>Ränge bearbeiten&nbsp;||</a>";
  231.           }
  232.           echo " </div>
  233.          <div style='min-height: 500px;'><table id='table'><tr><form action='". $_SELF['PHP'] ."' method='POST' id='allybscon'>
  234.          <td>Name:</td><td>". $abname ."</td></tr>
  235.          <tr><td>Tag:</td><td><input class='input_text' value='". $abtag ."' onkeyup='checkLength(this.value.length, \"4\",
  236.          \"<small>Das Tag darf <br>max 4 Zeichen haben</small>\", \"taglenghterror\", \"allybs\");'
  237.          name='newtag'><p id='taglenghterror'></td></tr>
  238.          <tr><td></td><td><a href='?ally,mbews'>Bewerbungen(". $bewsc .")</a></td></tr>
  239.          <tr><td><small>(max 1000 Zeichen)</small></td><td><textarea name='newdescext' cols='40' rows='10'
  240.          onkeyup='checkLength(this.value.length, \"1000\",
  241.          \"<small>Der externe Text darf <br>max 1000 Zeichen haben</small>\", \"delenghterror\", \"allybs\");'
  242.          name='newde'>". strip_tags($abde) ."</textarea><p id='delenghterror'></td></tr>
  243.          <tr><td><small>(max 500 Zeichen)</small></td><td><textarea name='newdescint' cols='40' rows='10'
  244.          onkeyup='checkLength(this.value.length, \"500\", \"<small>Der interne Text darf <br>max 500 Zeichen haben</small>\",
  245.          \"dilenghterror\", \"allybs\");'>". strip_tags($abdi) ."</textarea><p id='dilenghterror'></td></tr>
  246.          <tr><td></td><td><input type='submit' value='Ändern' name='allybs' id='allybs'><p id='aerror'></p></td></tr>
  247.          </table></div>";
  248.  
  249.  
  250. if (isset($_POST['allybs'])) {
  251.  
  252.     $newtag = $_POST['newtag'];    
  253.     $newde = nl2br(htmlentities($_POST['newdescext']));
  254.     $newdi = nl2br(htmlentities($_POST['newdescint']));
  255.   if (strlen($newde) < 1001 && strlen($newdi) < 501) {
  256.     if (strlen($newtag) < 5) {  
  257.       $updtallysql = "UPDATE allys SET tag='$newtag', descext='$newde', descint='$newdi'
  258.      WHERE allyid='$abid'";
  259.        mysql_query($updtallysql);
  260.        
  261.        
  262.     echo "<script type=\"text/javascript\">
  263.              window.location.href=\"./game.php?ally\";
  264.          </script>";        
  265.          
  266.       }else{
  267.      echo "<script type='text/javascript'>
  268.          writeInto('Das Tag hat zu viele Zeichen, max 4!', 'aerror');
  269.          </script>";
  270.     }      
  271.    }else{
  272.     echo "<script type='text/javascript'>
  273.          writeInto('Zu viele Zeichen im Text', 'aerror');
  274.          </script>";
  275.    }
  276.   }
  277.  
  278.  
  279.  }else if ($urlloc == 'bmem' && $usrrights == '5') {
  280.  
  281.     $mlbsql = "SELECT * FROM ally_member WHERE allyid='$abid' && usrid='$urlnum'";
  282.      $mlbq = mysql_query($mlbsql);
  283. while ($mlbrow= mysql_fetch_assoc($mlbq)) {
  284.       $memid = $mlbrow['usrid'];
  285.       $memrang = $mlbrow['rang'];
  286.  
  287.         $mlusrsql = "SELECT * FROM userdata WHERE id='$memid'";
  288.          $mlusrq = mysql_query($mlusrsql);  
  289.     while ($mlusrrow= mysql_fetch_assoc($mlusrq)) {
  290.      
  291.         $memname = $mlusrrow['name'];
  292.         $mempoints = round($mlusrrow['punkte']);    
  293.     }
  294.    
  295.       $rangchecksql = "SELECT * FROM ally_ränge WHERE allyid='$abid' AND rangname='$memrang'";
  296.         $rangcheckq = mysql_query($rangchecksql);
  297.    while ($rcrow= mysql_fetch_assoc($rangcheckq)) {
  298.        
  299.         $mrangrights = $rcrow['rangrights'];
  300.   }
  301.  
  302.  
  303.  
  304.  
  305.     echo "<div style='min-height: 500px;'><table id='table'><tr><form action='". $_SELF['PHP'] ."' method='POST'>
  306.          <td>Name:</td><td>". $memname ."</td></tr>
  307.          <tr><td>Rechte:</td><td><select name='aerang'>";
  308.           $arnsql = "SELECT * FROM ally_ränge WHERE allyid='$abid'";
  309.    $arnq = mysql_query($arnsql);
  310. while ($arnrow= mysql_fetch_assoc($arnq)) {
  311.   $arang = $arnrow['rangname'];
  312.  
  313.   echo "<option value=" . $arang . ">" . $arang . "</option>";
  314.  
  315. }
  316.          
  317.           echo "</select></td></tr>
  318.          <tr><td></td><td><input type='submit' value='Ändern' name='memb'></td></tr>
  319.          </table></div>";
  320.  
  321.  
  322. if (isset($_POST['memb'])) {
  323.  
  324.       $aerang = $_POST['aerang'];
  325.  
  326.           $memupdt = "UPDATE ally_member SET rang='$aerang' WHERE allyid=$abid AND usrid=$memid";
  327.           mysql_query($memupdt);
  328.          
  329.         echo "<script type=\"text/javascript\">
  330.              window.location.href=\"./game.php?ally,members\";
  331.          </script>";  
  332.      
  333.     }
  334.  
  335.  
  336.  
  337.  
  338.   }
  339.  }else if ($urlloc == 'brang' && $usrrights == '5') {
  340.  
  341.     if ($urlnum != '') {
  342.      
  343.       $srangsql = "SELECT * FROM ally_ränge WHERE allyid='$abid' && rangname='$urlnum'";
  344.         $srangq = mysql_query($srangsql);
  345.     while ($srangrow= mysql_fetch_assoc($srangq)) {
  346.    
  347.           $rname = $srangrow['rangname'];
  348.           $rrights = $srangrow['rangrights'];
  349.          
  350.           if ($rrights == '1') {
  351.           $rrights = 'Member';
  352.           }else if ($rrights == '2') {
  353.           $rrights = 'eMember';
  354.           }else if ($rrights == '3') {
  355.           $rrights = 'Verwalter';
  356.           }else if ($rrights == '4') {
  357.           $rrights = 'Co-Leader';
  358.           }else if ($rrights == '5') {
  359.           $rrights = 'Leader';
  360.           }
  361.          
  362.           echo "<table id='table'><form method='POST' action='". $SELF['PHP'] ."'>
  363.                <tr><td>Name:</td><td><input class='input_text' type='text' name='rname' value='". $rname ."'></td></tr>
  364.                <tr><td>Rechte:</td><td>  &nbsp;". $rrights ."&nbsp;&nbsp;<select name='rrights'>
  365.                <option value='1'>Member</option>
  366.                <option value='2'>eMember</option>
  367.                <option value='3'>Verwalter</option>
  368.                <option value='4'>CoLeader</option>
  369.                <option value='5'>Leader</option></td></tr>
  370.                <tr><td>Löschen?<input type='checkbox' name='del' value='del'></td><td><input type='submit' name='bearbrange' value='Ändern'></td></tr>
  371.                </form></table>";
  372.    
  373.           if (isset($_POST['bearbrange'])) {
  374.           echo "PASS 1";
  375.               $nrname = $_POST['rname'];
  376.               $nrrights = $_POST['rrights'];
  377.               $del = $_POST['del'];
  378.          
  379.                   if (isset($del)) {
  380.                  
  381.                       $delrang = "DELETE FROM ally_ränge WHERE allyid='$abid' AND rangname='$rname'";
  382.                         mysql_query($delrang);
  383.                  
  384.                   echo "<script type=\"text/javascript\">
  385.                               window.location.href=\"./game.php?ally,brang\";
  386.                           </script>";
  387.                   }
  388.          
  389.         }
  390.       }    
  391.     }else if ($urlnum == '') {
  392.      
  393.      echo "<div style='position: relative; left: 80px; top: 25px;'>
  394.           <a href='?ally' class='typlink'>Zurück&nbsp;||</a>
  395.           <a href='?ally,rangadd' class='typlink'>Rang hinzufügen&nbsp;||</a>
  396.           </div>
  397.           <table id='table'><tr><td>Rangname</td><td>Rangrechte</td><td>Aktionen</td></tr>";
  398.        
  399.       $rbsql = "SELECT * FROM ally_ränge WHERE allyid='$abid' ORDER BY rangrights DESC";
  400.         $rbq = mysql_query($rbsql);
  401.      while ($rbrow= mysql_fetch_assoc($rbq)) {
  402.      
  403.         $rbrname = $rbrow['rangname'];
  404.         $rbrrights = $rbrow['rangrights'];
  405.        
  406.         if ($rbrrights == 1){
  407.           $rbrrights = "<span onmouseover='Tip(\"Memberliste ansehen\");' onmouseout='UnTip();'>Member</span>";
  408.         }else if ($rbrrights == 2){
  409.           $rbrrights = "<span onmouseover='Tip(\"+Rundmails schreiben\");' onmouseout='UnTip();'>eMember</span>";
  410.         }else if ($rbrrights == 3){
  411.           $rbrrights = "<span onmouseover='Tip(\"+Ally bearbeiten\");' onmouseout='UnTip();'>Verwalter</span>";
  412.         }else if ($rbrrights == 4){
  413.           $rbrrights = "<span onmouseover='Tip(\"+Bewerbungen bearbeiten\");' onmouseout='UnTip();'>Co-Leader</span>";
  414.         }else if ($rbrrights == 5){
  415.           $rbrrights = "<span onmouseover='Tip(\"+Member bearbeiten,<br>kicken,Ränge bearbeiten\");' onmouseout='UnTip();'>
  416.          Leader</span>";
  417.         }
  418.        
  419.        
  420.         echo "<tr><td>". $rbrname . "</td><td>". $rbrrights . "</td><td>" . "<a href='?ally,brang,". $rbrname . "'>bearbeiten</a></td></tr>";
  421.      
  422.      
  423.      }
  424.      echo "</table>";  
  425.     }
  426.  }else if ($urlloc == 'rangadd') {
  427.   if ($usrrights == '5') {
  428.     echo "<table id='table'>
  429.          <form method='POST' action='". $_SELF['PHP'] ."'>
  430.          <tr><td>Name</td><td><input class='input_text' type='text' name='raddname'></td></tr>
  431.          <tr><td>Rechte</td><td><select name='raddrights'>
  432.          <option value='1' onmouseover='Tip(\"Memberliste ansehen\");' onmouseout='UnTip();'>Member</option>
  433.          <option value='2' onmouseover='Tip(\"+Rundmails schreiben\");' onmouseout='UnTip();'>eMember</option>
  434.          <option value='3' onmouseover='Tip(\"+Ally bearbeiten\");' onmouseout='UnTip();'>Verwalter</option>
  435.          <option value='4' onmouseover='Tip(\"+Bewerbungen bearbeiten\");' onmouseout='UnTip();'>Co-Leader</option>
  436.          <option value='5' onmouseover='Tip(\"+Member bearbeiten,<br>kicken,Ränge bearbeiten\");' onmouseout='UnTip();'>
  437.          Leader</option></td></tr>
  438.          <tr><td></td><td><input type='submit' name='addrange' value='Hinzufügen'></td></tr>
  439.          </form></table>";
  440.        }  
  441.          
  442.      if (isset($_POST['addrange'])) {
  443.        echo "PASS 1";
  444.         $addrname = htmlentities($_POST['raddname']);
  445.         $addrrights = $_POST['raddrights'];
  446.        
  447.           if ($addrname != '') {
  448.          
  449.             $addrsql = "INSERT INTO ally_ränge VALUES ('$abid', '$addrname', '$addrrights')";
  450.               mysql_query($addrsql);    
  451.              
  452.            echo "<script type=\"text/javascript\">
  453.                               window.location.href=\"./game.php?ally,brang\";
  454.                           </script>";  
  455.          
  456.          
  457.       }
  458.      }    
  459.  
  460.  
  461.  
  462.  }else if ($urlloc == 'mbews' && $usrrights >= 4) {
  463.  
  464.  echo "<table id='table'><tr><td>Name:</td><td>Bewerbung:</td><td>Aktionen:</td></tr>";
  465.  
  466.     $bewssql = "SELECT * FROM ally_bews WHERE allyid='$abid'";
  467.     $bewsq = mysql_query($bewssql);
  468.   while ($bewsrow= mysql_fetch_assoc($bewsq)) {
  469.  
  470.       $bewusrid = $bewsrow['usrid'];
  471.       $bewtext = $bewsrow['btext'];
  472.  
  473.    $bewusrsql = "SELECT * FROM userdata WHERE id='$bewusrid'";
  474.     $bewusrq = mysql_query($bewusrsql);
  475.   while ($burow= mysql_fetch_assoc($bewusrq)) {
  476.  
  477.       $bewusrname = $burow['name'];
  478.       $bewusrid = $burow['id'];
  479.  
  480.    }
  481.    
  482.          echo "<tr><td>". $bewusrname ."</td><td>". $bewtext ."</td>
  483.         <td><a href='?ally,del,". $bewusrid ."'>Delete</a>
  484.         <form action='". $_SELF['PHP'] ."' method='POST'>
  485.         <input type='submit' name='annmn' value='OK'>
  486.         </form>
  487.         </td></tr>";
  488.          
  489.       if (isset($_POST['annmn'])) {
  490.      
  491.         $insmemsql = "INSERT INTO ally_member VALUES ('$bewusrid', '$abid', '')";
  492.         $insudsql = "UPDATE userdata SET ally='$abname' WHERE id='$bewusrid'";
  493.         $delbewssql = "DELETE FROM ally_bews WHERE allyid='$abid' AND usrid='$bewusrid'";  
  494.           mysql_query($insmemsql);
  495.           mysql_query($insudsql);
  496.           mysql_query($delbewssql);
  497.          
  498.         echo "<script type=\"text/javascript\">
  499.              window.location.href=\"./game.php?ally\";
  500.          </script>";  
  501.      
  502.     }
  503.   }
  504.  echo "</table>";
  505.  
  506.  
  507.  }else if ($urlloc == 'members') {
  508.  
  509. echo "<table id='table'><tr><td>Name</td><td>Rang</td><td>Punkte</td><td>Aktionen</td></tr>
  510.      <tr><td></td><td></td><td> </td><td></td></tr>";
  511.  
  512.     $mlbsql = "SELECT * FROM ally_member WHERE allyid='$abid'";
  513.      $mlbq = mysql_query($mlbsql);
  514. while ($mlbrow= mysql_fetch_assoc($mlbq)) {
  515.  
  516.       $memid = $mlbrow['usrid'];
  517.       $memrang = $mlbrow['rang'];
  518.  
  519.         $mlusrsql = "SELECT * FROM userdata WHERE id='$memid'";
  520.          $mlusrq = mysql_query($mlusrsql);  
  521.     while ($mlusrrow= mysql_fetch_assoc($mlusrq)) {
  522.      
  523.         $memname = $mlusrrow['name'];
  524.         $mempoints = round($mlusrrow['punkte']);    
  525.     }
  526.    
  527.       $rangchecksql = "SELECT * FROM ally_ränge WHERE allyid='$abid' AND rangname='$memrang'";
  528.         $rangcheckq = mysql_query($rangchecksql);
  529.    while ($rcrow= mysql_fetch_assoc($rangcheckq)) {
  530.        
  531.         $rangrights = $rcrow['rangrights'];
  532.   }  
  533.  
  534.       echo "<tr><td>". $memname ."</td><td>". $memrang ."</td>
  535.            <td>". $mempoints ."</td>";
  536.             if ($rbrights == 5) {
  537.             echo "<td><a href='?ally,bmem,". $memid ."'>Bearbeiten</a></td>";
  538.             }
  539.             echo "</tr>";
  540.   }
  541.       echo "</table>";
  542.  }
  543. }
  544.  
  545. if ($urlloc == 'anz') {
  546.  
  547.     $aanzsql = "SELECT * FROM allys WHERE id='$urlnum'";
  548.      $aanzq = mysql_query($aanzsql);
  549. while ($aanzrow= mysql_fetch_assoc($aanzq)) {
  550.  
  551.     $anzaname = $aanzrow['name'];
  552.      $anzatag = $aanzrow['tag'];
  553.      $anzadesc = wordwrap(functionBBCode($aanzrow['descext'], 70 , "<br>", 1));
  554.    
  555.     echo "<div><table><tr><td class='overtd' style='background-image: url(style/tables/ally-overdesc.png);'>
  556.      <b style='font-size: 15px; color: white;'>". $anzaname ."[". $anzatag ."]<b></td></tr></table>
  557.      
  558.      <table id='descext' style='margin-top: -5px;'>
  559.      <tr><td style='border-bottom: 5px solid black; border-top: 5px solid black;'>
  560.      <div style='min-height: 100px;'>". $anzadesc ."</div></td></tr>
  561.      </table>";
  562. }    
  563.  
  564.  
  565. }
  566. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!