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:

5. Open the template "modifyavatar"

>>> Search for:

erm..excuse me for being stupid - but where is this template? Me using 2.0.3. I ran sqltodos.php and this has made changes to the avatar control page - but I can't add new avatar categories at the moment. Is this because I need to complete the rest of the installation?

Thanks.

[bad_madman]

[QUOTE]Originally posted by Aknowles
erm..excuse me for being stupid - but where is this template? Me using 2.0.3. I ran sqltodos.php and this has made changes to the avatar control page - but I can't add new avatar categories at the moment. Is this because I need to complete the rest of the installation?
Thanks.

Thanks for that pointer - now carried out all the changes in the .txt apart from the ones marked 'CSS/Jump menu only'.

I still have the situation as yesterday though, that clicking 'modify' in the Avatars/Categories section takes me to what appears the right page .. then I click through to the uncategorised Avatars, and that's fine too .. but there's a text 'link' near the bottom that says 'New Avatar Category'. This isn't in fact a link and clicking it does nothing. I need to reate new categories in order to put my avatars in them, so any idea how I can fix this or why that link isn't working?

Thanks!

[SirSteve]

When I run the sqltodos.php, it returns a blank gray page. No tables where created in the database.

?????

(using v2.0.3)

[bad_madman]

[QUOTE]Originally posted by SirSteve
When I run the sqltodos.php, it returns a blank gray page. No tables where created in the database.

?????

(using v2.0.3)

[bad_madman]

[QUOTE]Originally posted by Aknowles
Thanks for that pointer - now carried out all the changes in the .txt apart from the ones marked 'CSS/Jump menu only'.

I still have the situation as yesterday though, that clicking 'modify' in the Avatars/Categories section takes me to what appears the right page .. then I click through to the uncategorised Avatars, and that's fine too .. but there's a text 'link' near the bottom that says 'New Avatar Category'. This isn't in fact a link and clicking it does nothing. I need to reate new categories in order to put my avatars in them, so any idea how I can fix this or why that link isn't working?

Thanks!

[SirSteve]

Originally posted by Bad_Madman
Do you get however the following message:
"Start with changes on SQL-Database (add tables, records and fields) ...... yes / no"

yes.

[bad_madman]

[QUOTE]Originally posted by SirSteve
yes.

[SirSteve]

Originally posted by Bad_Madman
Hmm. I experimented somewhat. However to no solution came. Did you store and did start sqltodos.php there in the admin directory?

It started and when I hit submit, it went to a grey page. Yes, sqltodos.php is in the admin directory.

[bad_madman]

[QUOTE]Originally posted by SirSteve


It started and when I hit submit, it went to a grey page. Yes, sqltodos.php is in the admin directory.

Has anyone used this hack on v2.0.0 final?

I would love to use it on my board.

[LuBi]

Used the auto install and I keep getting this erroer

Warning: Supplied argument is not a valid File-Handle resource in /www/htdocs/forums/admin/avatar_hack_install.php on line 349

[bad_madman]

[QUOTE]Originally posted by LuBi
Used the auto install and I keep getting this erroer

Warning: Supplied argument is not a valid File-Handle resource in /www/htdocs/forums/admin/avatar_hack_install.php on line 349

[LuBi]

Yes and the install all from the admin directory.

[bad_madman]

[QUOTE]Originally posted by LuBi
Yes and the install all from the admin directory.

[Tarion]

I got the same problem, but you must give the rigth permissions (CHMOD 777) to all files of the Hack an any other files from VBB, but i don't know it at the moment, i think it is index.php an any other file.

+++German+++

Das selbe Problem hatte ich auch, nachdem ich allen Dateien in meinem Admin Verzeichnis CHMOD 777 gab war alles IO, nur ich hab die Kategorien im USER CP nicht gesehen, obwohl die Option show up the categorie aktiv war, es war eigetlich alles aktiv was die anzeigenoptionen anging, es wolte aber nicht so recht.

Ich hoffe du kannst mir weiterhelfen.

can you help me???

i dont get all the catagorie's i only can see the custom and al the other members can see al the catagories.

and i am the builder of the board and also tester for that board from my friend.

see picture below:

[bad_madman]

@LuBi
[QUOTE]Originally posted by Tarion
I got the same problem, but you must give the rigth permissions (CHMOD 777) to all files of the Hack an any other files from VBB, but i don't know it at the moment, i think it is index.php an any other file.

[bad_madman]

@Tarion
[QUOTE]Originally posted by Tarion ...
+++German+++

Das selbe Problem hatte ich auch, nachdem ich allen Dateien in meinem Admin Verzeichnis CHMOD 777 gab war alles IO, nur ich hab die Kategorien im USER CP nicht gesehen, obwohl die Option show up the categorie aktiv war, es war eigetlich alles aktiv was die anzeigenoptionen anging, es wolte aber nicht so recht.

Ich hoffe du kannst mir weiterhelfen.

[bad_madman]

[QUOTE]Originally posted by ~Mr NeMo~

i dont get all the catagorie's i only can see the custom and al the other members can see al the catagories.

I got an interesting error. I can change the categories and everything via admin and all looks good, it's just I had Keir's custom avatars as files hack installed and somehow with this I get this error.

I have since upgraded to 2.0.3 and install this hack having Keir's previously installed. I don't have any of the old files with Keir?s code in there, but I think his install made me do stuff to the SQL. Incidentally I can no longer allow my users (or myself) to change avatars. As they hit the button Change Avatar, they get a blank page. I can still change their avatars via the control panel by manually finding their name, but that is it. There has to be a relation somewhere. Please help.

www.magi-forums.com is the forum?s url.

[LuBi]

I've installed the hack, today and I do not see the catagorie when I go to change my avatar. I have modified and changed everything on the admin side of this hack but my users cannot change their avatars from their user cps. How can I fix this?

[Tarion]

@Bad_Madman: Also Adminseitig ist alles iO, ich kann Kategorien anlegen und speichern. NUr bei der Ausgabe, sehe ich gar keine Kategroien, obwohl unter Optionen im Admin CP alles aktiviert wurde, ich hab schon alles mögliche und Unmögliche getestet, komme aber nicht hinter das geheimnis.

[SirSteve]

Originally posted by Bad_Madman
I am somewhat helpless.
Try please the following: Use the attached file, copy it (sqltodos.php in zip-archiv) also into the admin directory and execute it. Proceed exactly the same, like otherwise also. Tell me please afterwards, what you see as the latter. For example 'SirSteve: test output xx'. Thanks for your preparatory work Do I talk complicated? Sorry...

Madman

It tried to go to a page that did not exist (404 File not found. The page is:

sqltodos_test.php

[bad_madman]

[QUOTE]Originally posted by SirSteve
It tried to go to a page that did not exist (404 File not found. The page is:

sqltodos_test.php

[bad_madman]

@Tarion
I did not mention unfortunately anywhere that empty categories are not displayed. Perhaps that is a reason for the problem

[SirSteve]

Originally posted by Bad_Madman
I am somewhat helpless.
Try please the following: Use the attached file, copy it (sqltodos.php in zip-archiv) also into the admin directory and execute it. Proceed exactly the same, like otherwise also. Tell me please afterwards, what you see as the latter. For example 'SirSteve: test output xx'. Thanks for your preparatory work Do I talk complicated? Sorry...

@SirSteve: Sorry! Error fixed.

Madman

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. ??

[LuBi]

Go here to check out my problem. The jumop buttons worked below. I don't think I like those but I do not have al ist of catagories. All avatars are in a group and I can't explain why the ones that show, show but someone help me..

http://forums.suprascene.com/member....ion=editavatar

[LuBi]

Need help still..

Can't get the catagorie selecting thing to show up. So my users can select. Somone help..

[bad_madman]

[QUOTE]Originally posted by LuBi
Need help still..

Can't get the catagorie selecting thing to show up. So my users can select. Somone help..

[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