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.

EXCELLENT HACK !!! :D :D :D

WORKS GREAT!

THANKS MAN :cool:

There seems to have been a slight problem with the database, etc etc

I backed it up first and then started from scratch, still got the same error.

I admit I don't know anything about php, but I'm curious about the coding in the instructions. For example, you say to find:
and replace with:


As I say, I don't know PHP, but every instance I've seen of else is enclosed as } else {, but not in your script. Could this cause the error?

thanks :)

Ah, received my tech error email, it shows:

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD
avatarrevision INT (6) UNSIGNED DEFAULT '0' not null AFTER avatarid
mysql error: Duplicate column name 'avatarrevision'
mysql error number: 1060

:confused:

Grumpy:

if - else statements are not necessary enclosed by '}{'

I recommend you start from the original VB version ( unhacked ), and follow the instructions carefully.

The second error you get is because you have the hack already installed, i will add code handle this in the next release.

If someone else is getting that error please tell.
Thanks, Cocomiel

Not sure if this will help, but the error I posted from the tech email was from the first attempt.


thanks for your help :)

Ok, that explains everything.

The error appears because you already have an avatarrevision field in your database, that is because you already instaled another hack that added that field.

if you have phpMyAdmin instaled, select to your database
and in the USER table delete the 'avatarrevision' field

then go to the SETTINGS table and delete the last two fields

But, as previously was mentioned I suggest you to begin installing the hack with a clean VB.

Hi,

Great work on this hack cocomiel.

I have not get into this or installed yet, but I was wandering if this hack could be made compatible or is already compatible with the avatar categories hack posted.

I dunno if its got anything to do with the code involved but I would like to know if both hacks could be installed to work together.

Thank you.

Xtrim, I dont know anything about that hack, but i will try to make it compatible in the next release

I've looked into the installation.txt of that hack and since it only applies to avatars uploaded by the admin should work with my hack without problems.

Installation took about 20 minutes(I forgot to download the files from the server, so I was using old versions - different comp:)) and it worked perfectly.

Thanks! :)

Would other hacks interfere with this one? I want to know before I install it.

As long as i know it will no interfere with any other hacks.

Ok. :) Just asking because I saw this statement:Also, is the step involving the "chmod" vital? Because I can't do that for the time being.

Well, i made that recommendation because normally when you can't install a hack is because the lines you must find in the code are changed or do not exist product of a previous installed hack.

Was just a recomendation, and applies to any hack, not specially this.

The chmod step is necessary if you want to create a new folder to store the custom avatars, if you already have one you want to use dont need to do so. Just type the path in the installation and it will work

Note: The path should not include previous or final backslashes

for example if you want to use the '/images/avatars/' folder
you should type images/avatars in the path

Hope that helps. :)

Perfect, thanks. :)

i get this error ehat should i do?

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD avatarrevision INT (6) UNSIGNED DEFAULT '0' not null AFTER avatarid
mysql error: Duplicate column name 'avatarrevision'
mysql error number: 1060
Date: Tuesday 25th of September 2001 01:54:18 PM
Script: /admin/install_fileavatar.php?action=Install&path=custom_ avatars+
Referer: http://ww..com/admin/install_fileava...ustom_avatars+

Ok, I deleted the 2 tables, Optioncode and Displayoder as above. I also made sure Avatarrevision was deleted. The install script recreates Avatarrevision, but gives this error:


Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO setting
(settingid, settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES
('', '26', 'Store Custom Avatars as Files?', 'usefileavatar', '0', 'Would you like to store your avatars in the database, or as static files in a directory?', 'yesno', '9')
mysql error: Unknown column 'optioncode' in 'field list'
mysql error number: 1054
Date: Saturday 29th of September 2001 08:43:10 AM
Script: /admin/install_fileavatar.php?action=Install&path=images% 2Fcustom&s=
Referer: http://www.animegathering.com/admin/...mages%2Fcustom


Can someone help? I have the Avatars as Categories hack installed.

It works perfect-thanks!!

could you possibly help me with the photo upload hack?

that hack WILL NOT let me upload anything-yet your hack DOES!!!

i would REALLY appreciate it...

Again-tx 4 a great hack

cocomiel, since this system is file-based, is there any way to allow members to use hot linked images for custom avatars? This would be a great feature, giving members more freedom and saving the host bandwidith.

So far, the only way I can think of using this would be to add an extra profile field for avatars, and add the image url in postbits. But that would require me to turn off the other avatars all together, losing all of the features and options that come with the system. :(

Any ideas?

I have installed the hack, but i have some trouble with it. The installationscript worked great etc, and users avatars are showing. But, when I want to change my avatar in 'my profile' or add one i just recieve a blank page :\. I tried to upload the 2.0.3 orginal files on to the server but still the same thing happens.

The forum is at http://www.sweclockers.com/forum

Could you please help me?


Edit: I found the error, It was not because of this hack. My members.php had been modified ealier and when upgrading to v2.0.3 it stopped working.

[QUOTE]Originally posted by Justice
cocomiel, since this system is file-based, is there any way to allow members to use hot linked images for custom avatars? This would be a great feature, giving members more freedom and saving the host bandwidith.

So far, the only way I can think of using this would be to add an extra profile field for avatars, and add the image url in postbits. But that would require me to turn off the other avatars all together, losing all of the features and options that come with the system. :(

Any ideas?

thanks

Does it check for the maximum dimensions of the avatar when using this hack? Because I installed it and set the max. dimensions to be 65 and someone used an image with 173x200 but it was smaller than the max. file size.

Thanks

I tried it on my computer and it works. So the problem is with my host. I also can't change others' avatars via the Admin CP in my host. It says changed but it doesn't. It's an unix machine with apache and plesk software installed. What can cause this problem? Bad permissions or what?

Any help will be greatly appreciated.

Thanks

I got the same error as grumpy, and followed your directions here...

Now the options in my CP don't load, and I get this error:

Database error in vBulletin Control Panel: Invalid SQL: SELECT settingid,title,varname,value,description,optionco de,displayorder FROM setting WHERE settinggroupid=1 ORDER BY displayorder
mysql error: Unknown column 'optioncode' in 'field list'
mysql error number: 1054

I've been to some threads on my board, and the hack actually seems to work. But I just can't seem to log into my CP. I think I need to add two fields or rows back into my Settings table. I should have backed up, I know... but my forum isn't live yet, so I'm just testing.

Thats because you deleted the wrong fields

I will release Custom Avatars As Files for 2.2.0 in a moment, DONT download Kier's hack because it will not work, its for 2.0.0

Hey, good to see VB.org back and running...

I was looking for the attachment for this great hack that I'm currently using, but it appears to have been edited out. Does Cocomiel or anyone have the hack file or at least offer up some insight on why it was taken down? ^_^

I, too, need this hack, but can't find the attachment...help!

Attachment go bye bye :confused:

ditto:(

I would also be VERY interested in downloading this hack if it can be made available again.

Also, I would like to know if it is compatible with 2.2.1??

YES PLEASE DO THIS :D
Everyone will be happy!!!!

Am I the only one having problems with this download?

It downloaded fine for me :D

What is the difference to Kier's excellet Custom Avatars as Files hack? :confused:

../member.php not modified ( chmod 777 this file and try again ).
Warning: fopen("../private.php","w") - Permission denied in *MYPATH*/admin/install_fileavatar.php on line 15

I chmod the file to 777 and hit reload and it doesnt work what should i do?

nope...i am too. downloaded the file, but got gibberish instead :(