Grab IPB User Avatars - Snippet

[Tutu]

Well, for some odd reason the IPB api makes all user-info besides their avatars easily accessible, and it was somewhat necessary for a 3rd party app. I was working on. Long story short, the following code snippet will allow you to easily grab a user's avatar location,

 

connect.php

<?php

    $mysql_hostname = '...';
    $mysql_user = '...';
    $mysql_password = '...';
    $mysql_database = '...';
    $prefix = "";
    $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die('Could not connect database');
    mysql_select_db($mysql_database, $bd) or die('Could not select database');
?>

user.php

class User {
    
    function avatar($user) {
        
        require_once('connect.php');
        try {
            
            $sql = "SELECT * FROM members WHERE name='$user'";
            $query = mysql_query($sql);
            if(!$query) {
                exit('Fail');
            }
            $member = mysql_fetch_assoc($query);
            $id = $member['member_id'];
            
            $sql_2 = "SELECT * FROM profile_portal WHERE pp_member_id='$id'";
            $query = mysql_query($sql_2);
            $profile = mysql_fetch_assoc($query);
            $avatar = $profile['pp_main_photo'];
            if(!isset($avatar) || $avatar=='') {
                exit('Fail');
            }
            exit('http://myforum.com/uploads/'.$avatar);
        } catch(Exception $ex){ 
            exit('Fail');
        }
    }
}

Usage,

<?php

$user = new User;
$name = 'USERNAME';
$user->avatar($name);

[GROTiUS]

Its possible to ask: If a user uploaded a custom avatar or not ? So if a user dont have a avatar uploaded, a message will displayed "Please costumize your profile, by uploading a avatar"

[Arif]

Its possible to ask: If a user uploaded a custom avatar or not ? So if a user dont have a avatar uploaded, a message will displayed "Please costumize your profile, by uploading a avatar"

I also want to have this is it possible?

[CyberLord]

Nice..

[M0L0Z]

Its possible to ask: If a user uploaded a custom avatar or not ? So if a user dont have a avatar uploaded, a message will displayed "Please costumize your profile, by uploading a avatar"

 

Yeah! That is something I would use too...

[Jeiko]

maybe any preview to check what we will do here?

[cl45]

thanks for it.

[Droid]

Awesome.

[thekid490]

Looks interesting. not sure what you used this for i would just copy and paste or copy the image and get the link and download it.

 

seems nifty though.

[Generic User 121514]

oh thanks you man

[m000]

Use PDO instead of mysql_*

Don't grab everything from tables members and profile_portal when you need only one column.

[Bogdan.]

Awesome.

[Wifi123]

Awesome tut, man.  Thanks.