Avatar Hack: Categories & Usergroups

With this hack it is possible to use categories for avatars.

Latest version: 1.31 (9-29-2002)

Features:
- Tested with vBulletin 2.2.5, 2.2.6 RC, 2.2.6 Final
- categories can be activated and deactivated
- hide single categories general (v1.25.2)
- hide single categories on FAQ page (v1.25.2)
- sorting order of the categories (v1.25.2)
- browse custom avatars (v1.25.2)
- add multiple avatar categories (v1.25.2)
- avatar statistics (v1.25.2)
- Provide definite custom avatars also for other users (v1.30)
- category permissions (Usergroups) for each individual group adjustable
- all (global) categories permissions enabled/disable
- show up 'not categorized avatars' enable/disable
- hide empty categories
- category selection per select menue
- no select menue, if no categories or categories deactivated
- bug fixing in original member.php: "0 to 0 of 0" instead "1 to 0 of 0"
- show up 'no avatars available' instead nothing if 0 avatars
- replace avatar name by avatar filename (without file extension).
- upload/add: Set default Avatarname to Filename (without file extension)
- remove all avatar names.
- tip,if different minimum post settings for individual avatars in categories
- edit avatar option: with view of avatar / list of users (v1.25.2)
- mass move avatars
- move/remove selected avatars (v1.25.1)
- move/mass move in NEW category (v.1.25.2)
- dynamic display width: If number avatars on screen < display width then display width = number avatars
- screen name AND category name. if you select a screen name, then show up the screen name instead category name
- how many User use a definite Avatar (Control Panel) (v1.25.1)
- show up counter for avatars for each category in Control Panel
- show up counter for avatars in select menu (v1.25.1)
- if you do not have categories, nevertheless applicable
- categories for the FAQ page (Help-View on vBulletin) (v1.25.1)
- categories now also in Control Panel -> Users administration (v1.25.1)
- jump feature and CSS Navigation (Cascade Style Sheets), if you like.
- installation instructions are contained in sqltodos.php now (v1.25.2)

Updates 1.31 (9-29-2002):
- Bug fixed: New users (registration process) can choose avatars from not permitted or hidden categories.

Updates 1.30 (6-29-2002):
- Bug fixed: Page navigation is missing, if avatars are in a category between 100 and 249
- Faster statistics routine
- Provide definite custom avatars also for other users
- Small bug in user.php eliminated (if you use 'categories in Control Panel -> Users administration')

Updates 1.25.2 (6-09-2002):
- Tested with vBulletin 2.2.5, 2.2.6 RC, 2.2.6 Final
- Hide single categories general
- Hide single categories on FAQ page
- Sorting order of the categories
- Browse custom avatars (v1.25.2)
- Add multiple avatar categories
- Avatar statistics
- Modify avatars in Admin CP: move/mass move in NEW category
- Bug fixed: The same avatars from first category show up in every category.
- Bug fixed: SQL-Error in Admin CP, if the 'minimum posts' setting isn't a number.
- Bug fixed: If avatars are moved, the number avatars isn't actualized in the current category. (MSIE cache problem)
- Bug fixed: SQL-Error, if user avatar was deleted (Admin CP -> edit user avatar).
- Bug fixed: Remove deleted avatars in User settings in SQL DB (Admin CP).
- Smaller changes in avatar_categ.php
- The complete installation instructions, 'firststeps' and updateinfos are contained in sqltodos.php now. You must copy and execute only the file into your forums admin directory.

Updates 1.25.1 (5-27-2002):
- Bug fixed: User can call categories, which wasn't opened for the Usergroup.
- Total number avatars in a category (select menue).
- Categories now also for the FAQ page (Help-View on vBulletin) possible. e.g. Link
- Categories now also in Control Panel -> Users administration
- More options in Control Panel / Bug fixing in HTML Source
- How many Users use a definite Avatar (+list of Users) (CP).
- Adminlog function enabled (avatar_categ.php)
- Config/Admin-File (avatar_categ.php) for .php3 including now.

Updates 1.25:
- Adaptation to new version (2.2.5) in admin/index.php. @Syphin had already changed this - thx!
- Installation instructions enlarges.
- First steps after installation added. Please, read firststeps.txt!

Screenshots:
- Categories view
- FAQ Page
- Control Panel
- Edit Avatar
- Modify Avatars
- Add Categories
- Edit user avatar
- Avatar statistics

Installation:
- Read !readme.txt in ZIP-ARCHIV!
- Proceeding also for an update of a previous version so!

Download:

[MrLister]

i still need help. i installed it the way it says a couple of times over even on a new installation and no categories show. i see i'm not the only one who this happened to. if you could take a look at your code and see if there's anything wrong i'd greatly appriciate it. this hack is really good and i'l love to have it but it doesn't seem to work.. please help me asap.

[bad_madman]

[QUOTE]Originally posted by mrlister
i still need help. i installed it the way it says a couple of times over even on a new installation and no categories show. i see i'm not the only one who this happened to. if you could take a look at your code and see if there's anything wrong i'd greatly appriciate it. this hack is really good and i'l love to have it but it doesn't seem to work.. please help me asap.

[bad_madman]

[QUOTE]Originally posted by SirSteve
...Database error in vBulletin Control Panel: Invalid SQL: DROP TABLE avatar_categories
mysql error: Unknown table 'avatar_categories'
...

Ever since I installed this hack any members that don't have their cookies enabled haven't been able to change their avatar. Any solution for that?

[MrLister]

i did do the installation manually.. i did select yes to show up avatar categories and no to avatar category permissions. i'm also using 2.0.3
[QUOTE]Originally posted by Bad_Madman
Could you create categories in the CP?
Did you execute the automatic or the manual installation?
Did you adjust Show up avatar categories in the CP -> Avatars / Categories -> Options to yes? Place for testing also Avatar Category Permissions to no and Show up not categorized avatars to yes!
Your version is 2.03? Try that out first times everything. I hope help me somewhat.

[SirSteve]

Originally posted by Bad_Madman
The problem described by you brings me almost to despairing. Hmmm. Please try times this particularly modified Script and legend, which occurs then.

Ok, no message of existing table data and when I clicked Start, the blank gray page came up.

[bad_madman]

@mrlister
I cannot find serious errors. I tested it under 2.01 and 2.03. Works without problems.
Are all avatars (despite missing categories) displayed or are missing also avatars? Appear on the page, does where the avatars can be selected, below (xxx avatars total)?

[bad_madman]

[QUOTE]Originally posted by Matt*is*thick
Ever since I installed this hack any members that don't have their cookies enabled haven't been able to change their avatar. Any solution for that?

[bad_madman]

[QUOTE]Originally posted by SirSteve
Ok, no message of existing table data and when I clicked Start, the blank gray page came up.

[SirSteve]

Originally posted by Bad_Madman
Sorry SirSteve. one I had inserted an error by mistake. Download please again! See 6 posts further above.

...create field avatarcat in table avatar...
...create table avatar_categories...
...record avatarpermissions in table setting exists already...
...record avataroptions in table setting exists already...
...record avatarselect1 in table setting exists already...
...create record in table avatar_categories...
...Set all avatars to 'category 1 = not categorized' with permissions for
- Unregistered / Not Logged In
- Registered
- Users Awaiting Email Confirmation
- (COPPA) Users Awaiting Moderation
- Super Moderator
- Administrator
- Moderators
- Staff

Important: Do not manipulate the sql-database in table avatar_categories
by hand (do not delete NEVER record with id '1' in table avatar_categories)!

...Update avatar counter for 'not categorized avatars' to 107


Database update complete.That's all!
You can call this Script several times to make over still modifications

Have fun

I believe that did it!! Thanks for your patience and this wonderful hack!