phpBB.de

Code: Alles auswählen

#-----[ OPEN ]------------------------------------------ 
# 
index.php 

# 
#-----[ FIND ]------------------------------------------ 
# 
//
// Generate the page

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
$sql = "SELECT u.username, u.user_level, u.user_id
FROM ". CONNECTIONS ." c, ". USERS_TABLE ." u
WHERE u.user_id = c.userid
ORDER BY u.username ASC";
if ( !($result = $db->sql_query($sql)) )
{
  message_die(GENERAL_ERROR, 'Could not get user data', '', __LINE__, __FILE__, $sql);
}
  $chatnums = $db->sql_numrows($result);
  $user = array();
  while ( $row = $db->sql_fetchrow($result) )
  {
    $user[] = $row;
  }

  for($i = 0; $i < count($user); $i++)
  {
    $style_color = '';
		if ( $user[$i]['user_level'] == ADMIN )
		{
		  $user[$i]['username'] = '<b>' . $user[$i]['username'] . '</b>';
			$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
		}
		else if ( $user[$i]['user_level'] == MOD )
		{
			$user[$i]['username'] = '<b>' . $user[$i]['username'] . '</b>';
			$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
		}

		$user_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $user[$i]['user_id']) . '"' . $style_color .'>' . $user[$i]['username'] . '</a>';
		$userlist .= ( $userlist != '' ) ? ', ' . $user_link : $user_link;
    
   }
  
    if ( $chatnums == 0 )
    {
      $l_chat_user_s = $lang['None_Chatuser'];
    }
    else if ( $chatnums == 1 )
    {
      $l_chat_user_s = $lang['One_Chatuser'];
    }
    else
    {
      $l_chat_user_s = $lang['More_Chatuser'];
    }
    
    $template->assign_vars(array(
      'USERNAMES' => $userlist,
      'CHATCOUNT' => sprintf($l_chat_user_s, $chatnums))
    ); 

Code: Alles auswählen

Could not get user data

DEBUG MODE

SQL Error : 1146 Table 'DB168096.phpbb_connections' doesn't exist

SELECT u.username, u.user_level, u.user_id FROM phpbb_connections c, phpbb_users u WHERE u.user_id = c.userid ORDER BY u.username ASC

Line : 562
File : index.php