Avatars and image.php Default

[fusionxx]

Hey i am trying to put latest postings on an external page on my website and i would like to do this with displaying the users avatars in the post. My problem is that users that do not have an avatar, it's displaying just a vbulletin image which can be seen here...

http://ocroom.net/forums/image.php?u=

How can i change this image, so that if users do not have an avatar, i can have another image that will fit more better into my website.

Or does anybody have a script that will allow you to display posts with avatars on a separate page!

I am guessing that vbulletin does not store the images on the server and its all done through this image.php file!

Any help would be great!

Thanks.

[Lynne]

You may store images (avatars/attachments/etc) in the file system - it's an option in your admin cp.

As for the avatar, you can probably do a quick condition - if no avatar, then display a different image. Why don't you post that part of your code if you need help (use the php tags or else it is too hard to read).

[fusionxx]

Ohh okay i did not know you could store as images as an option! Did that and this is my code i used to display latest threads with avatars on an external page...

PHP Code:

<?php

$selectpost = mysql_query("SELECT * FROM post ORDER by postid DESC LIMIT 5");
while ($row = mysql_fetch_array($selectpost)){
$forumid = $row["postid"];
$threadid = $row["threadid"];
$cat = $row["pagetext"];
$poster = $row["username"];
$lastpost = $row["dateline"];
$date = date('m-d-Y', $lastpost);
$useridmain = $row["userid"];


$selectthread = mysql_query("SELECT * FROM thread WHERE threadid='$threadid'");
while ($row = mysql_fetch_array($selectthread)){
$threadid2 = $row["threadid"];
$title = $row["title"];
}


$spic = mysql_query("SELECT * FROM customavatar WHERE userid='$useridmain'");
while ($row = mysql_fetch_array($spic)){
$userid = $row["userid"];
$filename = $row["dateline"];


}

if (mysql_num_rows($spic) == 0){

$picurl = "http://ocroom.net/images/none.jpg";

} else {

$picurl = "http://ocroom.net/forums/image.php?u=$userid";

}

$newcat = strlen($cat);

if ($newcat > 400)
{ $cat = substr($cat, 0, 400) . '...'; }
echo "
             <div class='newspic'><img src='$picurl' width='79' height='79' alt='$poster' /></div>
            <div class='newsauthor'><span class='author'>Author:</span> $poster<br />
              <span class='author'>Date:</span> $date<br />
          <span class='author'>Category:</span> $title</div>
            <div class='newstext'>$cat</div>
            <div class='newssep'></div>
";

}

?>

Thanks for your help

[Dismounted]

If possible, you should include vBulletin's global.php and use the available avatar fetching functions (fetch_avatar_url, fetch_avatar_from_userinfo).