Thread Starter
Anonymous User 8295407
(@anonymized-8295407)
<?php echo get_avatar( get_the_author_meta( 'user_email' ), '50' ); ?>
Okay so that’s what is displaying the image.
[Code moderated as per the Forum Rules. Please use the pastebin]
That’s the function that is grabbing the commenter’s avatar. I have a feeling the issue is with
$qr = "SELECT u.user_avatar, u.user_avatar_typeFROM” . $table_prefix . “usersu WHERE u.user_email= '" . $comment->comment_author_email . "'";
specifically
$comment->comment_author_email . "'";`
I can’t find where $comment is getting filled. It’s working for comments no problem, but what I see, $comment is only getting passed “50”. Any pointers?
Thread Starter
Anonymous User 8295407
(@anonymized-8295407)
Alright.. I got it working. I had to create a new function and then edit the theme a bunch. got it working!
Any chance you can post the solution? Cheers
Thread Starter
Anonymous User 8295407
(@anonymized-8295407)
No! It’s a secret!
Okay so I’m not a php programmer but I know enough to figure things out. I couldn’t figure out a way to make it work within the same function because they have to call different variables from the SQL database. So what I did was copy the function, and then just change the variable..
function get_forum_author_avatar($authemail, $size)
{
global $user;
$phpbb_config = trim(get_option('wpb_path'));
$phpbb_config = trim(get_option('wpb_path'));
require($phpbb_config);
$cn = mysql_pconnect($dbhost . ":" . $dbport, $dbuser, $dbpasswd);
if($cn)
{
if(@mysql_select_db($dbname))
{
$qr = "SELECT u.<code>user_avatar</code>, u.<code>user_avatar_type</code> FROM <code>" . $table_prefix . "users</code> u WHERE u.<code>user_email</code> = '" . $authemail . "'";
$rs = @mysql_query($qr, $cn);
}
while($i = mysql_fetch_assoc($rs))
{
$avatar = "<img class=\"avatar photo\" src=\"" . wpb_get_avatar($i['user_avatar'], $i['user_avatar_type']) . "\" alt=\"\" />";
}
}
return $avatar;
}
I put this right after the get_forum_avatar function. Then to make it work, I manually edited the theme file wherever it called for get_avatar for the author avatar, I changed it to get_forum_author_avatar. That was it!
for me not work, need help 🙁
i don’t find get_avatar work with get_forum_author_avatar, can u help me mbazdell,
Thanks.
