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:

[Sadie Frost]

This hack had been working fine for weeks, but now I have some major problems. I added some avatars last night, and then when I tried to do more this morning, I got this error:

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: INSERT INTO avatar (title,minimumposts,avatarpath,avatarcat) VALUES
('Monster','0','images/avatars/Buffy the Vampire Slayer/monster.jpg',3)
mysql error: Duplicate entry '208' for key 1

mysql error number: 1062

Date: Friday 28th of December 2001 05:24:55 PM
Script: http://britpack.com/forums/forums/ad...atar_categ.php
Referer: http://britpack.com/forums/admin/avatar_categ.php

So, I checked over the files and I've been having a problem with the last few lines of my files being cut off, and my member.php was like that, so I added the missing lines and uploaded in ASCII.

Now, when I even go to my main page, I get this error:

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT user.avatarid,avatarpath,avatarrevision,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='1'
mysql error: Can't open file: 'avatar.MYD'. (errno: 145)

mysql error number: 1016

Date: Friday 28th of December 2001 05:46:05 PM
Script: http://britpack.com/forums/forums/
Referer:

Can anyone help me? I have no idea what to try next.

Does anyone know what this 'avatar.MYD' file is?

[Sadie Frost]

Well, I ran admin/repair.php which (or so it says) repaired the avatar table.

But I got this from it:

Checking table template:

Table Operation Type Text
britpack.template check status OK

Optimizing table template:

template optimize error 28 when writing to datafile
britpack.template optimize status Operation failed

Now the problem is that I'm now getting this error:

"There seems to have been a slight problem with the database."

without any specifics on what the problem is. And where I could before get into my admin cp, I now can't.

Arrrggghhhh!

EDIT: Okay, it is the template.myd that's causing the problem. Anyone know how I can manually re-create that table?

[GrphicImprssion]

I am pretty new to the BB thing, I have my board up and running and would love to be able to allow avatars for vertain usegroups. Is this posible with this hack? If so, could one of you please contact me with instructions on which files to download, and how to install them on 2.2.1 Please.

Thank you in advance, hope to hear from someone.

[StarBuG]

I need help too

I have installed the hack on my vBB 2.2.1g and there are no errors BUT

I don?t can define ANY categories! There is just no option for it!
I used the css version (normaly CSS works for me (IE 6.0.2600))

What?s the problem or do I missed the solution by flying over the replys??

Greetings

StarBuG

[Smallville]

Could somebody redo this hack (no offense) for v 2.21. I installed it last night, then uninstalled it, and installed it again. Same thing as StarBuG. I can't define any catagories, and in the user CP where they pick an avatar, there isn't a dropdown box or anything.

This is a great feature, but it doesn't work for 2.21, which I think a lot of people are using.

Thanks.

[Matt]

It works perfectly well for 2.21 providing you follow all the instructions.

A common mistake that is made is that some don't add the new templates which come in the .txt files. As long as you add all of those and have followed everything properly it will work

[Smallville]

I did all of that the second time, after realizing, and it still doesn't work.

Matt, could you sign on AIM and help me? Thanks. Haven't seen you on lately.

[StarBuG]

ÄI´m not a newbie in hacking my board!

I hack my Board nearly every Day and I have done everything as you said including adding the new templates!

There where no errors but I can´t define any Categories!
Maybe there is something wrong with the CSS Style cheets ???

Greetings

StarBuG

[Smallville]

With a little help from Matt (a lot) I've rewritten the install file for v2.21 of vB. I did this for a friend of mine, and deleted all CSS-Navigation instructions so I wouldn't confuse them. All you really need from this new version is the admin/index.php changes. After that it's the same as before. So if you use CSS-Nav, use my version up to admin/index.php, and after that the regular one.

Hope this helps. IM me if you need help (names at the bottom of the file). Credit DEFINITELY goes to Matt and Bad Madman. Thanks. This works fine on my boards (coming soon).

[StarBuG]

I used your "new" install File (the only change you made is that you translated the admin/index link in new 2.2.1 code right?)

AND the problem is still the same!
In the Admin Panel I can´t create any Categories cause there is no option!

See the screenshot