phpBB.de

Code: Alles auswählen

<?php
define('IN_PHPBB', true); 

$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 

include($phpbb_root_path . 'includes/page_header.'.$phpEx); 
include($phpbb_root_path . 'config.' . $phpex);

//Tabellen:

$tab1 = 'phpbb_users';

//Zählvariablen:

$a=0;
$b=0;
$c=0;


//connection:

$con = mysql_connect($dbhost,$dbuser,$dbpasswd);
if (!$con) { echo "Keine Verbindung möglich!\n"; exit; }

$sel  = "select * from $tab1 order by user_rank";
$resa = mysql_db_query($dbname, $sel);

$resb = mysql_db_query($dbname, $sel);

$resc = mysql_db_query($dbname, $sel);


echo "<center><table width=100% cellpadding=2 cellspacing=1 border=0 class=forumline>
         <tr>
      	  <td class=catHead height=25><span class=genmed>";

echo "<center>";
echo "<b>Administratoren</b></center></span></td></tr><tr><td class=row1 align=left><span class=gensmall><center>";
while ($dataa = mysql_fetch_row($resa))
{
 if ($dataa[29]==1) { echo "$dataa[2]<br>"; $a++;}
}
echo "<br><br>($a gesamt)</center></td></tr><tr><td class=catHead height=25><span class=genmed><center>";

echo "<b>Moderatoren</b></center></span></td></tr><tr><td class=row1 align=left><span class=gensmall><center>";
while ($datab = mysql_fetch_row($resb))
{
 if ($datab[29]==2 or $datab[29]==3) { echo "$datab[2]<br>";$b++;}
}
echo "<br><br>($b gesamt)</center></td></tr><tr><td class=catHead height=25><span class=genmed><center>";

echo "<b>Newsschreiber</b></center></span></td></tr><tr><td class=row1 align=left><span class=gensmall><center>";
while ($datac = mysql_fetch_row($resc))
{
 if ($datac[29]==3 or $datab[29]==4){ echo "$datac[2]<br>";$c++;}
}

echo "<br><br>($c gesamt)</center></td></tr></table></center>";

mysql_close($con);

?>