Avatar As Link2

This hack display avatar through link... and not stored avatar in your database or server.

This hack is completely various from the first version , now it is integrated with the function avatar of vbulletin.

To integrate with welcome pannel
in index.php
instead
############################
if ($bbuserinfo[userid]!=0) {
$avatarurl=getavatarurl($bbuserinfo[userid]);
if ($avatarurl=='') {
$avatarurl='images/avatars/noavatar.gif';
}
$avatarimage='<a href="member.php?s='.$session[sessionhash].'&action=editavatar"><img src="'.$avatarurl.'" border="0">';
} else {
$avatarimage='<a href="register.php?s='.$session[sessionhash].'&action=signup"><img src="images/avatars/guestavatar.gif" border="0"></a>';
}
############################

put

############################
if ($bbuserinfo[userid]!=0) {


$avatarurl=getavatarurl($bbuserinfo[userid]);
if ($avatarurl=='') {
$avatarlink=$DB_site->query_first("SELECT avatar2 FROM avatarlink WHERE userid=$bbuserinfo[userid]");
$avatar2=$avatarlink[avatar2];
if ($avatar2=='') {
$avatarurl='images/noavatar.gif';
}else{
$avatarurl=$avatar2;
}
}
$avatarimage='<a href="member.php?s='.$session[sessionhash].'&action=editavatar"><img src="'.$avatarurl.'" border="0">';
} else {
$avatarimage='<a href="register.php?s='.$session[sessionhash].'&action=signup"><img src="images/guestavatar.gif" border="0"></a>';
}
############################

[Koneko]

I installed that hack and it works great. Except that in the admin control panel the avatar does not show as it normally would, and if I try to edit a members avatar through the control panel I get this error:

------------

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT userid
FROM user
WHERE username='Koneko'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Monday 08th of July 2002 09:30:53 PM
Script: http://forums.firefly.nu/admin/user.php
Referer: http://forums.firefly.nu/admin/user....=edit&userid=1

------------

Oh yes... I get a mysql whenever I try to edit ANYTHING about a user in the admin control panel. There is also this error as well...

When there is a member that has made posts but they have been deleted and changed to a "Guest" instead of an actual member, they are now on everyones ignore list and I have no idea to change this. This only started happening after I installed this hack.

edit:

I'm also receiving this error as now well... if you remove your avatar yourself and then try to add it back in, it won't let you.

Here's the error:

------------
Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO avatarlink (userid, avatar2) VALUES (1,'http://firefly.nu/stuff/koavatar.gif')
mysql error: Duplicate entry '1' for key 1

mysql error number: 1062

Date: Monday 08th of July 2002 10:02:52 PM
Script: http://spam.dreamwater.nu/member.php
Referer: http://spam.dreamwater.nu/member.php...ion=editavatar
-------------

[DraX]

I too had this problem whereas users got the error that the file was not a valid jpg or gif.

I've come to the conclusion it's simply broken, and I hope that at some time in the future it gets fixed. Until then, I simply cannot recommend this hack.