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_NICKPAGELIST, $session_length); 
init_userprefs($userdata); 

include('includes/page_header.'.$phpEx); 

   $template->set_filenames(array( 
      'body' => 'nickpagelist_body.tpl') 
   ); 
$zaehler = 0; 
$verbindung = mysql_connect($dbhost, $dbuser, $dbpasswd); 
mysql_select_db($dbname); 

$select = "SELECT uid FROM ".$table_prefix."nickpagemod ORDER BY uid ASC"; 
$select = mysql_query($select); 
WHILE($ergebnis = mysql_fetch_array($select)) { 
   $select2 = "SELECT username FROM ".$table_prefix."users WHERE user_id = '$ergebnis[uid]'"; 
   $select2 = mysql_query($select2); 
   $ergebnis2 = mysql_fetch_array($select2); 
   $zaehler++; 
   //echo $ergebnis2[username].'<br>'; 
                

$template->assign_block_vars('nickpagelist',   array( 
'NAME' => $ergebnis2[username], )); 

$template->assign_vars(array( 
'L_USERNAME' => $lang['Username'], 
'L_NICKPAGELIST' => $lang['Nickpagelist'], 
'L_NICKPAGELISTMODS' => $lang['Nickpagelistmods'], )); 

} 
mysql_close($verbindung); 

$template->assign_block_vars('nickpagelist2',   array( 
'EINTRAEGE' => $zaehler, )); 

$template->pparse('body'); 

include('includes/page_tail.'.$phpEx); 
?>

Code: Alles auswählen

$verbindung = mysql_connect($dbhost, $dbuser, $dbpasswd); 
mysql_select_db($dbname); 

Code: Alles auswählen

mysql_close($verbindung);