phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

################################################################# 
## MOD Title:	AbTrack BT-Tracker MOD
## MOD Author:	Aaru Bui < rogerhmui@hotmail.com > (N/A) http://sourceforge.net/projects/abtrack/
## MOD Description:
##      Most advanced phpBB interegrated BitTorrent Tracker.
## MOD Version:	1.0.2a

Код: Выделить всё

 
Could not query users

DEBUG MODE

SQL Error : 1052 Column: 'user_id' in field list is ambiguous

SELECT user_cf_iso3661_1, user_from_flag_cf_iso3661_1, username, phpbb_users.user_points, user_id, user_viewemail, user_posts, user_regdate, user_lastlogon, user_allow_viewonline, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, u_up_total, u_down_total, user_allow_viewonline, user_session_time FROM phpbb_users LEFT JOIN phpbb_bt_users ON phpbb_users.user_id = phpbb_bt_users.user_id WHERE phpbb_users.user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 25

Line : 208
File : memberlist.php 

Код: Выделить всё

$sql = "SELECT username, " . USERS_TABLE . ".user_id, user_viewemail, user_posts, user_regdate, user_lastlogon, user_allow_viewonline, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, u_up_total, u_down_total, user_allow_viewonline, user_session_time 
	FROM " . USERS_TABLE . "
	LEFT JOIN " . BT_USERS_TABLE . " ON " . USERS_TABLE . ".user_id = " . BT_USERS_TABLE . ".user_id
	WHERE " . USERS_TABLE . ".user_id <> " . ANONYMOUS . "
	ORDER BY $order_by";
//-- mod : IP Country Flag II ----------------------------------------------
// add
$sql = str_replace ('SELECT ', 'SELECT user_cf_iso3661_1, user_from_flag_cf_iso3661_1, ' . $sql_where, $sql);
//-- end mod : IP Country Flag II ------------------------------------------
$cm_memberlist->generate_columns($template,$sql,8);

if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}