Custom Avatars as Files

Custom Avatars As Files Hack for VB 2.2.1
BASED ON THE KIER'S HACK

Description: This hack lets you store custom avatars in a separate folder rather than in the VBulletin database, saving space & querys in your MySQL database

Here are some of the features:

• Allows to switch between file mode & database mode on the fly
  
• You can specify the custom avatar folder
  
• No SQL queries or PHP code required to display custom avatars
  
• If you use the Apache Web Server, the avatars folder can be protected by .htaccess thus preventing bandwidth stealing
  
• No cacheing issues with Internet Explorer 5.5
  
• 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.

Intructions:
Upload install_fileavatar.php to your ADMIN directory and open it in your browser, then follow the screen instructions.

[mvigod]

Cocomiel,

Thanks for the reupload and prompt reply....code looks good and looking forward to installing it!

Great job by the way!

marc

[Jawelin]

As I have a very hacked 2.2.1 board, the installer is able to modify only 2 files.
It could be possible to have a txt procedure ?

Thanks a lot

[Cocomiel]

If the installer is unable to modify the files, please edit the files manually following the attached instructions

[Jawelin]

Thanks a lot.
Very appreciated such a fast and solving answer.

I'll do it by hand asap.
Bye

[Jawelin]

Sorry, but I think your .txt procedure just attached is old or inaccurate. :dead:

For instance, the replacement

PHP Code:

        if ($usefileavatar) $avatarurl="images/avatars/custom/avatar$post[userid]_$post[avatarrevision].gif"; 


is absolutely a static link much different from the one explained many posts above here.


How could it work in 'abs' ?
Thanks.

[Jawelin]

Also in member.php, you suggest to replace:

PHP Code:

        if ($avexists=$DB_site->query_first("SELECT userid FROM customavatar WHERE userid=$bbuserinfo[userid]")) {
          $DB_site->query("UPDATE customavatar SET filename='".addslashes($avatarfile_name)."',dateline='".time()."',avatardata='".addslashes($filestuff)."' WHERE userid=$bbuserinfo[userid]");
        } else {
          $DB_site->query("INSERT INTO customavatar (userid,avatardata,dateline,filename) VALUES ($bbuserinfo[userid],'".addslashes($filestuff)."','".time()."','".addslashes($avatarfile_name)."')");
        } 


with:

PHP Code:

        if ($avexists=$DB_site->query_first("SELECT userid FROM customavatar WHERE userid=$bbuserinfo[userid]"))
          $DB_site->query("UPDATE customavatar SET avatardata='".addslashes($filestuff)."' WHERE userid=$bbuserinfo[userid]");
        else
          $DB_site->query("INSERT INTO customavatar (userid,avatardata) VALUES ($bbuserinfo[userid],'".addslashes($filestuff)."')"); 


It seems absolutely inaccurate, as you say to replace a different piece of code (than Kier's/Bira's VB 2.0.x version), because in 2.2.1 that's the actual code, WITH THE SAME piece they specified...

I got many many more confused !


Is it possible after SIX MONTHS of challenge, none of you gave a DECENT version of this hack ?

Sorry for my phrases, but I think it isn't acceptable from coder or people they want to help some other.

Thanks.

[Jawelin]

^BUMP^

[newvbuser]

Hi what's the performance issue prob if I use the default method which stores custom avatars into the database?? I have about 40 users who would want custom avatars.

[c-pr0mpt]

How do I uninstall the things this hack did? I did the install and the editing all errored, and when i went bck to the board the avatars were all still hosted via database.

[newvbuser]

Hmm it seems people here are releasing lots of unfinished hacks that do not work with the new versions of vB and they are called "finished" hacks