Remotely Hosted Avatars

It works on my 2.2.6 board, I'm not sure about 2.2.7, most likely will work

This hack prevents remote avatars from being loaded into the database, it saved both bandwidth and space. Instead it'll load the avatar directly from the link the user gives

The other remote avatar hacks I've tried didn't work, so I decided to do it myself

Have Fun, if there's any problems, ask.
Make a backup of the files before you mod them, I'm not responsible for any damages

[Unknown553]

Well I finally got around to installing this, and it actually works. I've been trying for weeks to get avatars working (stupid server) but to no avail, but this hack did the trick, thanks!

[Storm]

Does this hack work with the welcome panel?

[nabeel]

it should, i havent looked at the welcome panel. ill download it and take a look

[Odil]

Will this remove the ability to be able to upload avatars to the database at all? I would like that option avaiable still.

Thanks

Odil

[aLuCaRD]

How do I undo this query..?

ALTER TABLE `fragblast`.`user` ADD `avatar2` TEXT NOT NULL;

I adjusted it to the database I wanted to modify but upon further looking it seems this has mess with the way my welcome panel shows avatars..?

Anyhelp would be apreciated, thankyou.

[nabeel]

Originally posted by Odil
Will this remove the ability to be able to upload avatars to the database at all? I would like that option avaiable still.

Thanks

Odil

yeah itll remove it

to undo the query, replace ADD with DELETE, i think

i still havent had a chance to look at the welcome panel, but i dont think it will cause any problem

[TECK]

Originally posted by aLuCaRD
How do I undo this query..?

<?php
error_reporting(7);
require('./global.php');

cpheader('Run a Query');

$doquery="ALTER TABLE `fragblast`.`user` ADD `avatar2` TEXT NOT NULL";

$DB_site->query($doquery);

echo 'Query successful.<br><font face="Courier New" size="1">' . $doquery . '</font>';

cpfooter();
?>

save it to a file, called runquery.php, upload it to your /admin folder and run it.
any hacker should include this type of extra hack to make everyone's life easy.

some of us will never install phpmyadmin (i dont) just to run little queries like that, when they can be done with vBulletin.

[Rushy]

Editing Avatars

I have installed the hack and it works fine ut there is no way to edit/remove an avatar from a user in the admin CP. Any ideas?

[aLuCaRD]

Originally posted by TECK

<?php
error_reporting(7);
require('./global.php');

cpheader('Run a Query');

$doquery="ALTER TABLE `fragblast`.`user` ADD `avatar2` TEXT NOT NULL";

$DB_site->query($doquery);

echo 'Query successful.<br><font face="Courier New" size="1">' . $doquery . '</font>';

cpfooter();
?>

save it to a file, called runquery.php, upload it to your /admin folder and run it.
any hacker should include this type of extra hack to make everyone's life easy.

some of us will never install phpmyadmin (i dont) just to run little queries like that, when they can be done with vBulletin.

This will add it wont it..? I want to delete "avatar2" as now my avatars arent working. (2.2.7)

[ButtKnocker]

Has anyone tried this hack for VB 2.2.8? I'm not new to board hacking but I'm new to VB. My version 2.2.8 does not have a members.php. It has member.php and member2.php.

Also, the reason I am looking for this hack is because 2.2.8 has the option for custom avatars from a different url but it always gives a invalid jpeg and gif error. I'm not interested in hosting my own avatars (ie - having the actual files on my server). I'm interested in letting the users do the custom url avatar only.

I read a ton of threads on vbulletin.com about this subject but there seems to be no clear cut answer to why it will not work. Most of the answers are to fix the regular avatar problem of letting users upload their own or use the ones that the board admin hosts on his own server.

I believe I read something over there that the only way to get custom url avatars to work was to look here at vbulletin.org for the hack.

I guess my biggest question is why would VB put an option in there software that does not work without a hack?