vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   how to get avatar url? (https://vborg.vbsupport.ru/showthread.php?t=241111)

pein87 04-23-2010 07:25 PM
how to get avatar url?
 
I made a template and a custom page but right now it will not show the avatar. Could anyone help me out as to how I can get the avatar url?

This is the current code I'm using in the src attribute

image.php?u=$hallOfFameEntries[userid]

I use a custom query to get the user id.

brandondrury 05-02-2012 03:10 PM
It looks like this changed in vb4 as the image.php?u=$userid method worked fine for me in vB3.

Anyone know the URL/variable for this in vB4?

Brandon

BirdOPrey5 05-02-2012 05:21 PM
Actually I think it still works just like it did in 3.x- but the thing is it only works if avatars are stored in the database. If avatars are in the file system it won't work with either.

I'm pretty sure there is no URL- it is an often asked, never answered, question. Someone posted a function to get it (via a query) once but I don't remember anything else about it.


check out this link-
https://www.vbulletin.com/forum/show...o-CMS-Articles

souperman 05-02-2012 10:38 PM
You can get the user avatarrevision and locate the file if it's stored on the hdd.

Code:
$avatar = "http://www.domain.com/customavatars/thumbs/avatar".$vbulletin->userinfo['userid']."_".$vbulletin->userinfo['avatarrevision'].".gif";
That's just the gist, here how I would do it:
Check if the user has an avatarid
If user has avatarid, then get the fileurl of the avatar from the avatar table
if user doesn't have an avatarid (avatarid = 0), then check if user has an avatarrevision > 0
if avatarrevision > 0 then you can get the url path from my code above using the userid and avatarrevision
if avatarrevision == 0 and avatarid ==0, then user has no avatar and display the no avatar url

Hope my pseudo code helps you out.

--------------- Added [DATE]1336002405[/DATE] at [TIME]1336002405[/TIME] ---------------

Here's what I use in one of my external scripts:

Code:
function get_avatar_url($avatarid)
{
        if ($avatarid == 0)
        {
                $sql = "SELECT user.avatarrevision
                                FROM user 
                                JOIN customavatar
                                        ON user.userid = customavatar.userid
                                WHERE user.userid = '".mysql_real_escape_string($user_id)."'
                                LIMIT 1";
                $result = mysql_query($sql);
               
                if (mysql_num_rows($result) > 0)
                {
                        $data = mysql_fetch_array($result);
                        return "http://www.domain.com/customavatars/thumbs/avatar".$user_id."_".$data['avatarrevision'].".gif";
                }
                else
                {
                        return "http://www.domain.com/images/noavatarmini.gif";
                }
        }
        else
        {
                return "http://www.domain.com/images/avatars/thumbs/".$avatarid.".gif";
        }
}
In my case, the avartarid is the given. To make it fit your purpose I would do a LEFT join on the customavatar table to get the avatarid and any other useful info.

I would recommend to do the join on the query that's already getting your user information to save resources. If you post your query I can help you out with that.

BirdOPrey5 05-03-2012 11:27 AM
Why would all Avatars be .gif files?


All times are GMT. The time now is 02:50 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01093 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete