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:

[bad_madman]

[QUOTE]Originally posted by SirSteve

It goes to Test Ouput 2 then when I hit continue, page not found.

It also says this:
Tables, fields and records in SQL-Database exists already...

but in myphpadmin it doesn't show any new tables. ??

[SirSteve]

Originally posted by Bad_Madman
Yes, that is correct. I let the table "settings" check only whether the avatar options are already entered there. That seems to be with you the case.

Ok. Delete please manually with phpMyAdmin the 3 entries in the table 'settings':
-varname='avataroptions' and
-varname='avatarpermissions' and
-varname='avatarselect1'
Start afterwards the file sqltodos.php again.

I don't have a table "settings" (plural) but I do have a "setting" table but there are no avatar fields in there. ??

[bad_madman]

Also no entry 'avataroptions' (in table 'setting' - not 'settings' - sorry)? This is checked in the script 'sqltodos.php'. If it exists then the script outputs that all tables would be already created ('Tables, fields and records in SQL-Database exists already...').

If this entry in the table 'setting' is available (and that would have it), then please also times to delete.

[SirSteve]

Originally posted by Bad_Madman
Also no entry 'avataroptions' (in table 'setting' - not 'settings' - sorry)? This is checked in the script 'sqltodos.php'. If it exists then the script outputs that all tables would be already created ('Tables, fields and records in SQL-Database exists already...').

If this entry in the table 'setting' is available (and that would have it), then please also times to delete.

Not sure what you are saying or asking but in the database "setting" there are these fields:

Database vforums - table setting
settingid
settinggroupid
title
varname
value
description
optioncode
displayorder

That is all.

[bad_madman]

If I incomprehensibly write then excuse please.
I mean: does in the table 'setting' an entry with the varname 'avataroptions' exist?

If this entry exists, delete then please.

Normally this entry must exist in your SQL-DB, since the Script outputs the message 'Tables, fields and records in SQL-Database exists already...'. Because the script 'sqltodos.php' seeks to check in the SQLDB only after this entry over whether the necessary modifications (for the avatar-hack) were already executed to the SQLDB.

[SirSteve]

Originally posted by Bad_Madman
[B]If I incomprehensibly write then excuse please.
I mean: does in the table 'setting' an entry with the varname 'avataroptions' exist?

If this entry exists, delete then please.

The entry does not exist.

[bad_madman]

There I am rather helpless. If you get the message 'Tables, fields and records in SQL-Database exists already...', then also the varname 'avataroptions' would have to exist.

Did you already try the fixed Script http://www.vbulletin.com/forum/showt...776#post166776 (with test output)? With this also the error should be fixed ('page not found'). Otherwise I have no more advice.

[SirSteve]

Originally posted by Bad_Madman
There I am rather helpless. If you get the message 'Tables, fields and records in SQL-Database exists already...', then also the varname 'avataroptions' would have to exist.

Did you already try the fixed Script http://www.vbulletin.com/forum/showt...776#post166776 (with test output)? With this also the error should be fixed ('page not found'). Otherwise I have no more advice.

Says this. Tables, fields and records in SQL-Database exists already...

So I click Remove and get this:

Database error in vBulletin Control Panel: Invalid SQL: DROP TABLE avatar_categories
mysql error: Unknown table 'avatar_categories'
mysql error number: 1051
Date: Friday 21st of September 2001 02:58:00 PM
Script: /forums/admin/sqltodos.php
Referer: http://www.sirstevesguide.com/forums.../sqltodos.php?

[MrLister]

why does it show nothing on my avatar screen. i followed the instructions and clicked on change avatar and nothing was there.

yhanx man it coll
it work 2.0.3