Coder Forum

PHP Quellcode

<?php
require_once(WCF_DIR.'lib/system/auth/UserAuthDefault.class.php');
 
class UserAuthFacebook extends UserAuthDefault {
	/**
	 * Loads instance of UserAuthFacebook instead of UserAuthDefault
	 *
	 */
	public static function loadInstance() {
		if (self::$instance === null) self::$instance = new UserAuthFacebook();
	}
 
	public static function loginManuallyFacebook($facebookID, $userClassname = 'UserSession') {
	  $user = null;
 
	$sql = "SELECT userID FROM wcf".WCF_N."_user
        	WHERE facebookIdentifier = '".escapeString($facebookID)."'";
	$row = WCF::getDB()->getFirstRow($sql);
 
	if (!$row['userID']) {
			require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
			throw new NamedUserException('Die angegebene Facebook-Verbindung konnte keinem Benutzer zugeordnet werden.');
	}
 
	$user = new $userClassname($row['userID']);
	return $user;
	}
 
	public function storeAccessDataFacebook(User $user) {
		HeaderUtil::setCookie('userID', $user->userID, TIME_NOW + 365 * 24 * 3600);
		HeaderUtil::setCookie('facebookIdentifier', $user->facebookIdentifier, TIME_NOW + 365 * 24 * 3600);
	}
 
	/**
	 * @see UserAuth::loginAutomatically()
	 */
	public function loginAutomatically($persistent = false, $userClassname = 'UserSession') {
	if (!$persistent) return null;
	$user = null;
 
	if (isset($_COOKIE[COOKIE_PREFIX.'userID']) && isset($_COOKIE[COOKIE_PREFIX.'facebookIdentifier'])) {
  	$facebookID = $_COOKIE[COOKIE_PREFIX.'facebookIdentifier'];
 
  	if ($facebookID) {
    	$user = new $userClassname($_COOKIE[COOKIE_PREFIX.'userID']);
    	HeaderUtil::setCookie('facebookIdentifier', '');
			} else {
    	$user = new $userClassname($_COOKIE[COOKIE_PREFIX.'userID']);
				if ($user->facebookIdentifier == $_COOKIE[COOKIE_PREFIX.'facebookIdentifier']) {
					HeaderUtil::setCookie('facebookIdentifier', $user->facebookIdentifier, TIME_NOW + 600);
				}# else {
				#	return null;
				#}
  	}
		} else {
  	$user = parent::loginAutomatically($persistent, $userClassname);
	}
 
		return $user;
	}
}
?>

Source code

Fatal error: Invalid SQL: SELECT wbb_user.*, avatar.*, wbb_user.userID AS wbbUserID, GROUP_CONCAT(DISTINCT whitelist.whiteUserID ORDER BY whitelist.whiteUserID ASC SEPARATOR ',') AS buddies, GROUP_CONCAT(DISTINCT blacklist.blackUserID ORDER BY blacklist.blackUserID ASC SEPARATOR ',') AS ignoredUser, (SELECT COUNT(*) FROM wcf1_user_whitelist WHERE whiteUserID = user.userID AND confirmed = 0 AND notified = 0) AS numberOfInvitations, GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs, GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*, user.* FROM wcf1_user user LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = user.userID) LEFT JOIN wcf1_user_whitelist whitelist ON (whitelist.userID = user.userID AND whitelist.confirmed = 1) LEFT JOIN wcf1_user_blacklist blacklist ON (blacklist.userID = user.userID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID) LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user.userID = GROUP BY user.userID LIMIT 1

You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1064
Information:

error message: Invalid SQL: SELECT wbb_user.*, avatar.*, wbb_user.userID AS wbbUserID, GROUP_CONCAT(DISTINCT whitelist.whiteUserID ORDER BY whitelist.whiteUserID ASC SEPARATOR ',') AS buddies, GROUP_CONCAT(DISTINCT blacklist.blackUserID ORDER BY blacklist.blackUserID ASC SEPARATOR ',') AS ignoredUser, (SELECT COUNT(*) FROM wcf1_user_whitelist WHERE whiteUserID = user.userID AND confirmed = 0 AND notified = 0) AS numberOfInvitations, GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs, GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*, user.* FROM wcf1_user user LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = user.userID) LEFT JOIN wcf1_user_whitelist whitelist ON (whitelist.userID = user.userID AND whitelist.confirmed = 1) LEFT JOIN wcf1_user_blacklist blacklist ON (blacklist.userID = user.userID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID) LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user.userID = GROUP BY user.userID LIMIT 1
error code: 1064
sql type: MySQLDatabase
sql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY user.userID LIMIT 1' at line 13
sql error number: 1064
sql version:
file: XYZ/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.2.6-1+lenny4
wcf version: 1.1.1 pl 2 (Tempest)
date: Fri, 01 Jan 2010 20:43:38 +0000
request: /
referer:
Stacktrace:

#0 XYZ/wcf/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT ??wbb_us...', 1, 0)
#1 XYZ/wcf/lib/data/user/User.class.php(63): Database->getFirstRow('SELECT ??wbb_us...')
#2 XYZ/wcf/lib/system/session/UserSession.class.php(33): User->__construct('', NULL, NULL, NULL)
#3 XYZ/lib/data/user/WBBUserSession.class.php(51): UserSession->__construct('', NULL, NULL)
#4 XYZ/wcf/lib/system/auth/UserAuthFacebook.class.php(48): WBBUserSession->__construct('')
#5 XYZ/wcf/lib/system/session/CookieSessionFactory.class.php(37): UserAuthFacebook->loginAutomatically(true, 'WBBUserSession')
#6 XYZ/wcf/lib/system/session/SessionFactory.class.php(73): CookieSessionFactory->create()
#7 XYZ/lib/system/WBBCore.class.php(200): SessionFactory->get()
#8 XYZ/wcf/lib/system/WCF.class.php(98): WBBCore->initSession()
#9 XYZ/global.php(18): WCF->__construct()
#10 XYZ/index.php(7): require_once('XYZ/ht...')
#11 {main}