Version: , by Cocomiel
Developer Last Online: Mar 2005
Version: 2.2.x
Rating:
Released: 09-17-2001
Last Update: Never
Installs: 17
No support by the author.
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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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.
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
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+
Originally posted by cocomiel 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.
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.