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:

[CFF RA's]

Database error in vBulletin Control Panel 2.3.8:

Invalid SQL: SELECT * FROM avatar_categories
mysql error: Table 'thewbsch_cff.avatar_categories' doesn't exist

mysql error number: 1146

Date: Tuesday 03rd of January 2006 09:56:49 PM
Script: http://thewbs-charmed.net/admin/sqltodos.php
Referer: http://thewbs-charmed.net/admin/sqlt...p?action=page2

[CFF RA's]

I have been asking for support for the Avatars Categories Hack for the longest time now, I've also emailed vBulletin and Jelsoft regarding the lack of support...

The error message I got when I tried adding tables to the database via the sqltodos.php is as follows...

Database error in vBulletin Control Panel 2.3.8:

Invalid SQL: SELECT * FROM avatar_categories
mysql error: Table 'thewbsch_cff.avatar_categories' doesn't exist

mysql error number: 1146

Good day!

[CFF RA's]

It's actually version 2.3.7

[CFF RA's]

How bout you guys give soe support if thats why your here?!?

[CFF RA's]

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT * FROM avatar WHERE $where1 AND minimumposts<='$bbuserinfo[posts]' ORDER BY title LIMIT ".($limitlower-1).",$perpage
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '".($limitlower-1).",$perpage' at line 1

mysql error number: 1064

[CFF RA's]

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT * FROM avatar WHERE $where1 AND minimumposts<='$bbuserinfo[posts]' ORDER BY title LIMIT ".($limitlower-1).",$perpage
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '".($limitlower-1).",$perpage' at line 1

mysql error number: 1064

========================================

Can you please give me the code to correct this, thank you.

[Saskia]

As noted by the hack creator: this hack is not supported. This guy hasn't been online in months and the hack is almost 5 years old.

vBulletin and Jelsoft have nothing to do with hack support, so emailing them is quite useless actually.

Personally I suggest upgrading to a vBulletin 3. I didn't get this hack to work either a few months ago on a vBulletin 2.3.x version and since it's implemented in the newer vBulletin versions, I just upgraded to vBulletin 3 and did my thing there. I would highly suggest doing that, trust me you'll benefit from it eventually. You can get the looks of vBulletin 2 done with vBulletin 3 if you want, so there's no real pressing reason to stay on vBulletin 2 these days.

Good luck.