hello on board again ... lunch time, some water to a garden (spring time!) ...
well, i had to test out with a custom avatar for an user that had an avatar in phpBB, to see that really all working fine, and not only apparently.
https://plugins.trac.wordpress.org/brow ... tion/trunk
on class.wp.w3all-phpbb.php (that has patched already on
trunk about this)
Code: Select all
$uavatars = $w3db_conn->get_results( $w3db_conn->prepare("SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(%d) ORDER BY user_id DESC", $w3unames ));
has been replaced by
Code: Select all
$uavatars = $w3db_conn->get_results( "SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(".$w3unames.") ORDER BY user_id DESC" );
on the updated file:
Code: Select all
// this not work by email_hash, but were necessary by username
// $uavatars = $w3db_conn->get_results( $w3db_conn->prepare("SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(%d) ORDER BY user_id DESC", $w3unames ));
$uavatars = $w3db_conn->get_results( "SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(".$w3unames.") ORDER BY user_id DESC" );
i had to rename also vars, it is little confusing maybe, username or what remind to it into avatars functions are sometime email_hashes instead. But all now should work as expected.
All the code about avatars, is wrapped on bottom of file
class.wp.w3all-phpbb.php
inside comments
//#######################
// START ABOUT AVATARS
//#######################
... .... ...
//#######################
// END ABOUT AVATARS
//#######################
hello on board again ... lunch time, some water to a garden (spring time!) ...
well, i had to test out with a custom avatar for an user that had an avatar in phpBB, to see that really all working fine, and not only apparently.
[url]https://plugins.trac.wordpress.org/browser/wp-w3all-phpbb-integration/trunk[/url]
on class.wp.w3all-phpbb.php (that has patched already on [i]trunk[/i] about this)
[code]$uavatars = $w3db_conn->get_results( $w3db_conn->prepare("SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(%d) ORDER BY user_id DESC", $w3unames ));[/code]
has been replaced by
[code]$uavatars = $w3db_conn->get_results( "SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(".$w3unames.") ORDER BY user_id DESC" );
[/code]
on the updated file:
[code]// this not work by email_hash, but were necessary by username
// $uavatars = $w3db_conn->get_results( $w3db_conn->prepare("SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(%d) ORDER BY user_id DESC", $w3unames ));
$uavatars = $w3db_conn->get_results( "SELECT username, user_avatar, user_avatar_type FROM ".$config["table_prefix"]."users WHERE user_email_hash IN(".$w3unames.") ORDER BY user_id DESC" );
[/code]
i had to rename also vars, it is little confusing maybe, username or what remind to it into avatars functions are sometime email_hashes instead. But all now should work as expected.
All the code about avatars, is wrapped on bottom of file
[b]class.wp.w3all-phpbb.php[/b]
inside comments
//#######################
// START ABOUT AVATARS
//#######################
... .... ...
//#######################
// END ABOUT AVATARS
//#######################