[davide101]

Hi everyone,

I'm trying to display a user's avatar outside of vBulletin. I have it working for users that have created their own avatar - but I can't figure out how to grab the image when someone's using one of the forum's defaults.

Here's the getavatar.php that searches the database and returns a link to the appropriate file:

<?php

$config_filename = dirname(__FILE__) . "/includes/config.php";

require_once $config_filename;
define( 'TABLE_PREFIX', $config['Database']['tableprefix'] );

$userid = $_REQUEST['userid'];

$conn = mysql_connect( $config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password'] );
if (!$conn)
    die ("Could not connect to server.");

if (!mysql_select_db( $config['Database']['dbname'], $conn ))
    die ("Database not found.");

$sql = "SELECT filedata, dateline, filename 
            FROM vb_customavatar
            WHERE userid = $userid";
$results = mysql_query($sql, $conn); 
if (!$results)
    die ("Error running query.");

$row=mysql_fetch_array($results); 

header('Cache-control: max-age=31536000');
header('Expires: ' . gmdate('D, d M Y H:i:s', (TIMENOW + 31536000)) . ' GMT');
header('Content-disposition: inline; filename=' . $row['filename']);
header('Content-transfer-encoding: binary');
header('Content-Length: ' . strlen($row['filedata']));
header('Last-Modified: ' . gmdate('D, d M Y H:i:s', $row['dateline']) . ' GMT');
$extension = trim(substr(strrchr(strtolower($row['filename']), '.'), 1));
if ($extension == 'jpg' OR $extension == 'jpeg')
    header('Content-type: image/jpeg');
else if ($extension == 'png')
    header('Content-type: image/png');
else
    header('Content-type: image/gif');

echo $row['filedata'];  

?>

You can see it work correctly here:
http://www.diabetesdaily.com/forum/g...r.php?userid=1

Any ideas on how expand this to grab the other images?

David