While executing query "SELECT AS avatar_url FROM `MySQL_Databasename`.users WHERE user_id='2'" on Resource id #16
mySQL 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 'AS avatar_url FROM `MySQL_Databasename`.users WHERE user_id='2'' at line 1
While executing query "SELECT AS avatar_url FROM `MySQL_Databasename`.users WHERE user_id='2'" on Resource id #16
mySQL 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 'AS avatar_url FROM `MySQL_Databasename`.users WHERE user_id='2'' at line 1
Mini Tabs enabled? | Yes |
Mini Tabs set to the same size as avatars in PhpBB? | Yes |
Any problems in the past with Stephen's Bridge, Coppermine or PhpBB? | No |
PhpBB file for avatars: | images/avatars/upload |
PhpBB file for avatar gallery | images/avatars/gallery |
define('AVATAR_PATH', $BRIDGE['relative_path_to_config_file'].'/download/file.php?avatar='.$BRIDGE['avatar_path'].'/');
.$BRIDGE['avatar_path'].'/'
'avatar_url' => 'user_avatar'
);
//mod define Avatar path
define('AVATAR_PATH', $BRIDGE['relative_path_to_config_file'].'/download/file.php?avatar=');
change the /download/file.php?avatar= to the file phpbb3.0.2 acesses to load avatars (minus the relative path at the begining and the #_##########.gif part at the end) (if you don't know what file this is, go to your phpbb forum and right click on any avatar you see then click "properties" to see where it is being loaded from. The path you see will look something like this:"http://www.domain.com/phpbbfile/download/file.php?avatar=[/u]1_9999999999.gif" the part you will use is in bold and underlined). // Table field names
$this->field = array(
'username' => 'username', // name of 'username' field in users table
'user_id' => 'user_id', // name of 'id' field in users table
'password' => 'user_password', // name of 'password' field in users table
'email' => 'user_email', // name of 'email' field in users table
'regdate' => 'user_regdate', // name of 'registered' field in users table
'active' => 'user_active', // is user account active?
'lastvisit' => 'user_lastvisit', // name of 'location' field in users table
'location' => 'user_from', // name of 'location' field in users table
'website' => 'user_website', // name of 'website' field in users table
'usertbl_group_id' => 'group_id', // name of 'group id' field in users table
but before this section: // Pages to redirect to
$this->page = array(
// Table field names
$this->field = array(
'username' => 'username', // name of 'username' field in users table
'user_id' => 'user_id', // name of 'id' field in users table
'password' => 'user_password', // name of 'password' field in users table
'email' => 'user_email', // name of 'email' field in users table
'regdate' => 'user_regdate', // name of 'registered' field in users table
'active' => 'user_active', // is user account active?
'lastvisit' => 'user_lastvisit', // name of 'location' field in users table
'location' => 'user_from', // name of 'location' field in users table
'website' => 'user_website', // name of 'website' field in users table
'usertbl_group_id' => 'group_id', // name of 'group id' field in users table
'avatar_url' => 'user_avatar'
);
//mod define Avatar path
define('AVATAR_PATH', $BRIDGE['relative_path_to_config_file'].'/download/file.php?avatar=');
// Pages to redirect to
$this->page = array(
Thanks agian for all your help on getting this little mod to work, Stramm!And by that, I mean the help with getting my tweak to your huge modpack to work, of course.