Remotely Hosted Avatars

Adapted from here

**NO SUPPORT GIVEN**
**USE AT YOUR OWN RISK**

=======

This has been tested, and works on VB3 RC4

not sure about other browsers.

This checks the image dimensions and if its a real image, but does NOT check the file size as the image is not being uploaded to the server, it is eing linked remotely.

Dimension checking is so that it can't screw up layouts.

=======

If A user already has an avatar that is NOTremotely hosted - it will be displayed, else the remotely hsoted avatar will be displayed.

to include the avatar in other places on your site, add an if statement:

PHP Code:

if ($post[avatar2] != '' AND $post[avatar2] != "http://www." AND $post[avatar2] != "http://"  AND $post[avatar2] != "www.") {
        $post['avatarurl'] = $post[avatar2];
} 


Another alternative (which unfortunatly adds another query) if you only have the userid is:

PHP Code:

$pic = $DB_site->query("SELECT * FROM `". TABLE_PREFIX ."user` WHERE userid = ".$userid);
$piccy = $DB_site->fetch_array($pic) ;
if ($piccy['avatar2'] != '' AND $piccy['avatar2'] != "http://www." AND $piccy['avatar2'] != "http://"  AND $piccy['avatar2'] != "www.") {
        $avatarurl = $piccy['avatar2'];
} 


(Replace $avatarurl with whatever the variable is for the url of the avatar to show )
=======
Requires:

File Modifications: 6
File Uploads: 0
SQL Queries: 1
Template additions: 0
Template Changes: 0

=======
Enjoy

-DF

Edit: Attatched

Edit: Fixed Small bugs
- Incomplete lines from editing in pico
- if avatar2 was "http://www." for some reason - it displayed no avatar, rather than the old avatar.

Edit: Added Ability for users to still use predefined avatars or no avatar (In last 2 If statements made it set avatar2 to http://www.)

if user enters NONE in the customavatar URL field - it also sets their avatar to no avatar. (Its up to you to change the phrase if you want your members to know - else they can use the "no avatar" setting above as normal)

Works in member.php aswell now

Edit: Fixed more Pico erros and added example of getting avatar url direclty from DB

[AndyW]

ALTER TABLE `df_forum`.`PREFIX_user` ADD `avatar2` TEXT NOT NULL;

Replace “df_forum” with the name of the database where your ‘user’ table is stored
Replace “PREFIX_” with the prefix of your tables, (or just remove it)

Can someone translate this into English for me?????

Not sure what I am supposed to do here???

[Warlord]

Originally Posted by AndyW

ALTER TABLE `df_forum`.`PREFIX_user` ADD `avatar2` TEXT NOT NULL;

Replace ?df_forum? with the name of the database where your ?user? table is stored
Replace ?PREFIX_? with the prefix of your tables, (or just remove it)


Can someone translate this into English for me?????

Not sure what I am supposed to do here???

In phpMyAdmin if you look on the left side of your screen you will see a whole bunch of menut titles which are the names of your tables. What this tells you to do is replace df_forum with the name of your database.

The name of your database will be at the very top of the left side of your screen in the list that shows all your tables in phpMyAdmin.

If your tables all look like this:

vb_user
vb_postbit
vb_header
vb_footer

etc. etc. then you're prefix is vb. Replace PREFIX_ with vb_ (or whatever your prefix might be), if you have no prefix to your tables then just remove the word PREFIX_ and drive on soldier.

[Rawhide]

Very useful modification, has anyone upgraded it to vBulletin 3.6.3?

[bigM]

Originally Posted by Rawhide

Very useful modification, has anyone upgraded it to vBulletin 3.6.3?

word!

I need this plugin also for 3.6.x .....