phpBB.de

Code: Alles auswählen

        // Get user...
        $sql = 'SELECT *
            FROM ' . USERS_TABLE . '
            WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");
        $result = $db->sql_query($sql);
        $member = $db->sql_fetchrow($result);
        $db->sql_freeresult($result);
 

Code: Alles auswählen

        // Get user...
        $sql = 'SELECT *
            FROM ' . USERS_TABLE . '
            LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " pf
                ON pf.user_id = user_id
            WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");
        $result = $db->sql_query($sql);
        $member = $db->sql_fetchrow($result);
        $db->sql_freeresult($result);
 

Code: Alles auswählen

            $poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height']);
      

Code: Alles auswählen

            $poster_avatar = get_user_avatar($member['user_avatar'], $member['user_avatar_type'], $member['user_avatar_width'], $member['user_avatar_height'], $member['user_id'], $member['pf_gender']);
      

Code: Alles auswählen

SQL ERROR [ mysql4 ]

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 '" . PROFILE_FIELDS_DATA_TABLE . " pf ON pf.user_id = user_id WHE' at line 3 [1064]

SQL

SELECT * FROM phpbb3_users LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " pf ON pf.user_id = user_id WHERE user_id = 58

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: memberlist.php
LINE: 421
CALL: dbal_mysql->sql_query()

Code: Alles auswählen

$sql = 'SELECT *
            FROM ' . USERS_TABLE . '
            LEFT JOIN ' . PROFILE_FIELDS_DATA_TABLE . ' pf
                ON pf.user_id = user_id
            WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id");
        $result = $db->sql_query($sql);

Code: Alles auswählen

SQL ERROR [ mysql4 ]

Column 'user_id' in where clause is ambiguous [1052]

SQL

SELECT * FROM phpbb3_users LEFT JOIN phpbb3_profile_fields_data pf ON pf.user_id = user_id WHERE user_id = 58

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: memberlist.php
LINE: 421
CALL: dbal_mysql->sql_query()

Code: Alles auswählen

        // Get user...
        $sql = 'SELECT *
            FROM ' . USERS_TABLE . ' u
            LEFT JOIN ' . PROFILE_FIELDS_DATA_TABLE . ' pf
                ON pf.user_id = u.user_id
            WHERE ' . (($username) ? "u.username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "u.user_id = $user_id");
        $result = $db->sql_query($sql);
        $member = $db->sql_fetchrow($result);
        $db->sql_freeresult($result);