easyhp.org

Code: Alles auswählen

<?php
define("IN_EASYHP", true);

include "includes/mysql.php";
include "common.php";
include "includes/website.php";

print make_message(SITE_IMG, "Userlist", "Diese Homepage besitzt folgende User:", '', '');

print "<div id='content'>";

function search()
{
   print "<table>";
   
  $sql = 'SELECT * FROM '.USERS_TABLE.' ORDER BY `id` ASC';

  $result = mysql_query($sql);
   if (!$result) {
      die ('Etwas stimmte mit dem Query nicht: '.mysql_error());
   }

   
   while ($row = mysql_fetch_assoc($result))
   {
      $userid = $row['id'];

      {
         print "<tr><td>";
         print "<font size='3'><a href='profile.php?mode=view&user_id=".$userid."'>".$row['name']."</a></font>";
         $gefunden = 1;
         $ergebnisse[] = $row['id'];
      }
   }
   
   print "</table>";
}

search();

print "</div>";

footer(0);

?>

Code: Alles auswählen

<?php
define("IN_EASYHP", true);
include "includes/mysql.php";
include "common.php";
include "includes/website.php";

echo make_message(SITE_IMG, "Userlist", "Diese Homepage besitzt folgende User:", '', '');

echo "<div id='content'>";
    $users = mysql_query('SELECT id FROM ' . USERS_TABLE);
		$amount_users = mysql_num_rows($users);

		echo '<b>Diese Seite besitzt ' . $amount_users . ' Mitglieder</b>';
		
function search()
{
   echo "<table width='625px'>";
   echo "<tr><td><h2>Adminisatoren</h2></td></tr>";
   
  $sql1 = 'SELECT * FROM '.USERS_TABLE.' WHERE `level`=1 ORDER BY `name` ASC';

  $result1 = mysql_query($sql1);
   if (!$result1) {
      die ('Etwas stimmte mit dem Query nicht: '.mysql_error());
   }

   
   while ($row1 = mysql_fetch_assoc($result1))
   {
      $userid1 = $row1['id'];

      {
         echo "<tr><td>";
         echo "<font size='3'><a href='profile.php?mode=view&user_id=".$userid1."'>".$row1['name']."</a></font>";
         $gefunden = 1;
         $ergebnisse[] = $row1['id'];
		 echo "</td></tr>";
      }
   }
   echo "<tr><td><h2>Moderatoren</h2></td></tr>";
   
  $sql2 = 'SELECT * FROM '.USERS_TABLE.' WHERE `level`=2 ORDER BY `name` ASC';

  $result2 = mysql_query($sql2);
   if (!$result2) {
      die ('Etwas stimmte mit dem Query nicht: '.mysql_error());
   }

   
   while ($row2 = mysql_fetch_assoc($result2))
   {
      $userid2 = $row2['id'];

      {
         echo "<tr><td>";
         echo "<font size='3'><a href='profile.php?mode=view&user_id=".$userid2."'>".$row2['name']."</a></font>";
         $gefunden = 1;
         $ergebnisse[] = $row2['id'];
		 echo "</td></tr>";
      }
   }   
   echo "<tr><td><h2>Mitglieder</h2></td></tr>";
   
  $sql3 = 'SELECT * FROM '.USERS_TABLE.' WHERE `level`=0 ORDER BY `name` ASC';

  $result3 = mysql_query($sql3);
   if (!$result3) {
      die ('Etwas stimmte mit dem Query nicht: '.mysql_error());
   }

   
   while ($row3 = mysql_fetch_assoc($result3))
   {
      $userid3 = $row3['id'];

      {
         echo "<tr><td>";
         echo "<font size='3'><a href='profile.php?mode=view&user_id=".$userid3."'>".$row3['name']."</a></font>";
         $gefunden = 1;
         $ergebnisse[] = $row3['id'];
		 echo "</td></tr>";
      }
   }   
   
   echo "</table>";
}

search();

echo "</div>";

footer(0);

?>

Code: Alles auswählen

-- kein Ergebnis gefunden --