Custom Avatars as Files (updated for vBulletin 2.2.2)

Updated for vBulletin 2.2.2, 5th February 2002

Since there has been so much demand for this, I wrote a hack that will allow you to store all your custom avatars as files, rather than in the mySQL database.



Doing this will have the following benefits:

• Avatars folder can be protected by .htaccess (Apache only) to prevent bandwidth stealing
• No SQL queries or PHP code required to display custom avatars - server load decreases
• No cacheing issues with Internet Explorer 5.5, so server bandwidth use should decrease

The install script will make the necessary modifications to your database, install a control panel option to switch the file-based avatars on, and convert your existing custom avatars from the database into files.

All avatar options that are present when using the standard mySQL avatar system are still present, and users will not notice a difference in the interface.

Full instructions for altering your PHP files are included in the zip file.

Once you have made the necessary modifications to the PHP scripts, you should run the enclosed install_favatar.php script from your admin/ folder.

[dost]

two days passed :P how is it going?

[Cocomiel]

you should look here :


http://www.vbulletin.com/forum/showt...threadid=28337

[DarkReaper]

How can I get this to work with 2.2.0?

[psico]

Not work with 2.2.0 !!!!

this code not exist!!!

showthread.php
and
private.php
and
announcement.php find this:

if ($post[hascustomavatar] and $avatarenabled) {
$avatarurl="avatar.php?s=$session[sessionhash]&userid=$post[userid]";
replace with this:

if ($post[hascustomavatar] and $avatarenabled) {
if ($usefileavatar) $avatarurl="custom_avatars/avatar$post[userid]_$post[avatarrevision].gif";
else $avatarurl="avatar.php?userid=$post[userid]";

[Cocomiel]

This hack was for 2.0, i dont have idea why they put 2.2.0

[eva2000]

must of been devine intervention since twice i tried to install this hack and when i read this thread my browser frooze and forced me to reboot my pc

[eg_92901]

Is this supported on vBulletin 2.2.0? I see different code than what is in the instructions for the function.php file.

[ladyfyre]

I would also be quite interested in the answer to that question

Since our database is already over 300MB it takes FOREVER to do a dump.sql file, and i will have to move to another server AGAIN in a few days, since we are finally ready to ship our colo box.

[SirSteve]

What about 2.2.1?

[bira]

OK, for those wishing to install this in 2.2.1:

Follow the instructions in post #1 except for the following change:

the instructions for file admin/functions.php should be:

Find:

PHP Code:

// ###################### Start getavatarurl #######################
function getavatarurl($userid) {
  global $DB_site,$session;

  if ($avatarinfo=$DB_site->query_first("SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
                                         FROM user
                                         LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                                         LEFT JOIN customavatar ON customavatar.userid=user.userid
                                         WHERE user.userid='$userid'")) {
    if ($avatarinfo[avatarpath]!="") {
      return $avatarinfo[avatarpath];
    } else if ($avatarinfo['hascustom']) {
      return "avatar.php?userid=$userid&dateline=$avatarinfo[dateline]";
    } else {
      return '';
    }
  }
} 


Replace with:

PHP Code:

// ###################### Start getavatarurl #######################
function getavatarurl($userid) {
  global $DB_site,$session, $usefileavatar;

  if ($avatarinfo=$DB_site->query_first("SELECT user.avatarid,avatarpath,avatarrevision,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
                                         FROM user
                                         LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                                         LEFT JOIN customavatar ON customavatar.userid=user.userid
                                         WHERE user.userid='$userid'")) {
    if ($avatarinfo[avatarpath]!="") {
      return $avatarinfo[avatarpath];
    } else if ($avatarinfo['hascustom']) {
        if ($usefileavatar) {
            return "custom_avatars/avatar$userid"."_$avatarinfo[avatarrevision].gif";
        } else {
            return "avatar.php?userid=$userid";
        }
    } else {
      return '';
    }
  }
} 


Find:

PHP Code:

            if ($post[hascustomavatar] and $avatarenabled) {
                $avatarurl="avatar.php?userid=$post[userid]&dateline=$post[avatardateline]"; 


Replace with:

PHP Code:

            if ($post[hascustomavatar] and $avatarenabled) {
                   if ($usefileavatar) {                   
                       $avatarurl="custom_avatars/avatar$post[userid]_$post[avatarrevision].gif";
                } else {
                    $avatarurl="avatar.php?userid=$post[userid]&dateline=$post[avatardateline]";
                } 


And, no changes should be made to showthread.php.


That's it. All other instructions remain the same.

Cheers,

Bira