Avatar Hack: Categories & Usergroups

[bad_madman]

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 (http://www.latriade.net/forum/misc.php?s=&action=showavatars)
- 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 (https://vborg.vbsupport.ru/attachment.php?s=&postid=152161)
- FAQ Page (http://www.securityzone.de/_badmadman/faqpage.jpg)
- Control Panel (https://vborg.vbsupport.ru/attachment.php?s=&postid=152163)
- Edit Avatar (http://www.securityzone.de/_badmadman/editavat.jpg)
- Modify Avatars (http://www.securityzone.de/_badmadman/modify.gif)
- Add Categories (http://www.securityzone.de/_badmadman/addcategory.gif)
- Edit user avatar (http://www.securityzone.de/_badmadman/useradmin.jpg)
- Avatar statistics (http://www.securityzone.de/_badmadman/avatarstats.gif)

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

Download:

[bad_madman]

here preview picture 1: categories view

[bad_madman]

here preview picture 2: control panel

[Freddie Bingham]

Is all of the code in avatar.php included in your new avatar.php file?

[bad_madman]

[QUOTE]Originally posted by freddie
Is all of the code in avatar.php included in your new avatar.php file?

[HalfBreed]

**BUMP**

[snyx]

I plan on testing it in 2.03 so I will get back to ya tonight.

[Lordmusic]

*sniff* you did it for me? *sniff*
Get it working in 2.03 and I will put ever such good use to it!

[bad_madman]

My test at version 2.0.3 was just successful. You can use also my new Script, which everything executes automatically (tested on V2.01 and 2.03).

Madman

Updates:
-Fixed MySQL query (sub routine call in avatar_categ.php) Error message "Warning: Supplied argument is not a valid MySQL result resource in /home/blabla/unixpath/vbPortal/forums/admin/db_mysql.php on line 154"
-Fixed function call "Fatal error: Can't redeclare already declared function in /home/blablabla/unixpath/forum/admin/avatar_categ.php3 on line 17"
-Fixed error in installation.txt (run avatar_hack_install.php instead sqltodos.php)
-08-24-20001: Fixed SQL error with Upload attempt of non-categorized Avatars.
-09-05-2001: Problems with avatar upload in avatar_categ.php fixed (Syntax error of me in the Script).
-Downloads up to 10-01-2001: 163
-10-01-2001: Because of to many problems provisionally download deactivated.

[SuitCase]

Great stuff, thank you! I can't wait to check this one out. :)

[floleb7]

when i want to go to modify

Fatal error: Can't redeclare already declared function in /home/latriade.net/www/forum/admin/avatar_categ.php3 on line 17

[snyx]

I get the same?

[bad_madman]

[QUOTE]Originally posted by floleb7
when i want to go to modify

Fatal error: Can't redeclare already declared function in /home/latriade.net/www/forum/admin/avatar_categ.php3 on line 17

[floleb7]

2.03

[bad_madman]

[QUOTE]Originally posted by floleb7
when i want to go to modify

Fatal error: Can't redeclare already declared function in /home/latriade.net/www/forum/admin/avatar_categ.php3 on line 17

[floleb7]

it works thks :)

[floleb7]

it's possible to have the same things for that page
http://www.latriade.net/forum/misc.php3?s=&action=showavatars

e.g selection of category and only XX avatars show per page

[orca]

I'm not sure whether I got the instructions right:

If admin/index.php and member.php are already modified from previous hacks, will this cause any trouble?

If the two templates headinclude and modifyoptions are already edited how can I apply the changes without loosing those edits?

[bad_madman]

[QUOTE]Originally posted by floleb7
it's possible to have the same things for that page
http://www.latriade.net/forum/misc.php3?s=&action=showavatars

e.g selection of category and only XX avatars show per page

[bad_madman]

[QUOTE]Originally posted by orca
I'm not sure whether I got the instructions right:

If admin/index.php and member.php are already modified from previous hacks, will this cause any trouble?

[snyx]

dood, excelent hack man, Im very pleased with it!
great job!

[Lordmusic]

Small idea, how about allowing sub Categories. IE categories of Street Fighter, then a link to Male/Female/All

[bad_madman]

[QUOTE]Originally posted by floleb7
it's possible to have the same things for that page
http://www.latriade.net/forum/misc.php3?s=&action=showavatars

e.g selection of category and only XX avatars show per page

[snyx]

you mean like you almost done one with actuall catigories? like when they edit avatar insted of showing 50 per page, there in sections, and you like click into them, ect?

(excuse my spelling)
snyx

[Lordmusic]

That's the plan. A drop down menu where you can select the sections.

However I suggest adding sub Categories.

You click on a selection, but then there is a link to more sections within the subject.

Like say you select star wars. Then it shows you a page that has links to people, bots, weapons... Stuff like that. Making stuff ever so sorted :)

[snyx]

Very cool, can't wait.
Got 2 questions, you don't have to answer em'
A) Will I be able to upgarde from THIS hack?
B) When ya think ya will have it? Week?
Thanks!

snyx

[Dakota]

Great hack, this is one that should definately be included with vB. I have wanted something like this for a long time. I can't wait to see what else you come up with. Also looking forward to the show avatars addition to it when you get it done.

[HalfBreed]

Wow! Impressive hack!

I am experiencing one issue though (although it's not mission critical it still is a concern) and that's within the control panel itself.

When I go to modify a particular category of avatars, it does list the avatars and everything just fine, however, at the top of the screen on EVERY category I get the same message:

Warning: Supplied argument is not a valid MySQL result resource in /home/hohavoc/public_html/vbPortal/forums/admin/db_mysql.php on line 154

if ( isset($this->query_id) ) {
line 154: $this->record = mysql_fetch_array($this->query_id);
} else {
if ( !empty($query_string) ) {
$this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
} else {
$this->halt("Invalid query id ".$this->query_id." specified");
}
}

Any idea what this means??

I'm using the latest mysql, php, apache and linux kernel on our host.
v 2.0.3 of jelsoft's bulletin board.

[Dakota]

I get the same error, but its really not a big deal, or atleast doesn't seem like it.

[bad_madman]

[QUOTE]Originally posted by HalfBreed
When I go to modify a particular category of avatars, it does list the avatars and everything just fine, however, at the top of the screen on EVERY category I get the same message:

Warning: Supplied argument is not a valid MySQL result resource in /home/hohavoc/public_html/vbPortal/forums/admin/db_mysql.php on line 154....

[HalfBreed]

Originally posted by Bad_Madman
test:

edit avatar_categ.php
search for:
$avatar_categs=$DB_site->query_first("SELECT * FROM avatar_categories WHERE avatar_categoriesid!=0");
and replace it with:

$avatar_categs=$DB_site->query("SELECT * FROM avatar_categories WHERE avatar_categoriesid!=0");

Hmmm. Apparently nevertheless still a few bugs :(

Yes!!! But, that fix worked like a champ so that means one less to contend with. :)

[dxb]

I know it's a dumb question but I got lost between your two posts Bad_Madman

so now we have two files to download one is

avatar_hack.zip

and the other one is

automatic_install.zip

so what exactly we are supposed to do

follow the instruction in the first zip or just upload the files in second zip file and use the sqltodos.php and then run the avatar_hack_install.php

please if it's possible clearify this :)

and thanks alot

[bad_madman]

[QUOTE]Originally posted by dxb
...follow the instruction in the first zip or just upload the files in second zip file and use the sqltodos.php and then run the avatar_hack_install.php

please if it's possible clearify this :)

and thanks alot...

[Dakota]

I am using vB 2.0.3 on another forum that I help, and when I installed I get this error when I try to go to Add or Modify

Fatal error: Cannot redeclare getrowbg() in /*/*/public_html/forum/admin/adminfunctions.php on line 83

Here is the code in that part of adminfunctions

// ###################### Start getrowbg #######################

function getrowbg () {

// returns the current alternating class for <TR> rows in the CP.

global $bgcounter;

if ($bgcounter++%2==0) {

return "firstalt";

} else {

return "secondalt";

}

}

[Dakota]

Ok, well I got rid of the error by deleting this part of avatar_categ.php

on line 5:

function getrowbg () {

global $bgcounter;

if ($bgcounter++%2==0) { return "firstalt";

} else {return "secondalt";}

}

[bad_madman]

[QUOTE]Originally posted by Dakota
Ok, well I got rid of the error by deleting this part of avatar_categ.php...

[bad_madman]

[QUOTE]Originally posted by floleb7
it's possible to have the same things for that page
http://www.latriade.net/forum/misc.php3?s=&action=showavatars

e.g selection of category and only XX avatars show per page

[Dakota]

I got this error.

Parse error: parse error in /(/*/*/*/bidforpower.com/htdocs/forum/misc.php on line 208

Line 208 is just
?>

using vB 2.0.1

[bad_madman]

[QUOTE]Originally posted by Dakota
I got this error.

Parse error: parse error in /(/*/*/*/bidforpower.com/htdocs/forum/misc.php on line 208

Line 208 is just
?>

using vB 2.0.1

[floleb7]

http://www.latriade.net/forum/misc.php3?s=&action=showavatars

great thks man ;)

[snyx]

I installed the first verison without the catigories, now I wanna upgarde from it kinda, but there are not inturctions on how? help?

[bad_madman]

[QUOTE]Originally posted by snyx
I installed the first verison without the catigories, now I wanna upgarde from it kinda, but there are not inturctions on how? help?

[snyx]

2.03

[bad_madman]

[QUOTE]Originally posted by snyx
2.03

[snyx]

eek, all I know is I have the zip, here thanks for the help btw man

[bad_madman]

[QUOTE]Originally posted by snyx
eek, all I know is I have the zip, here thanks for the help btw man

[SirSteve]

Got this while using the auto install. Am on 2.0.3:

...create template view_avatarcategories in Style Default...
...create template view_avatarcategoriesadd in Style Default...
...create template view_avatarcategoriesdis in Style Default...
...create template view_avatarcategorieslist in Style Default...
...add CSS-Styles for Navigation in template headinclude in Style Default...
...create template numbernav_own in Style Default...
...create template numbernav_pages_own in Style Default...
...change (for avatar categories) template modifyavatar in Style vB Original...

Template update complete.

Warning: fopen("index.php.backup","a") - Permission denied in /forums/admin/avatar_hack_install.php on line 245

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

Warning: Supplied argument is not a valid File-Handle resource in /forums/admin/avatar_hack_install.php on line 247
...make backup of file index.php...

Warning: fopen("index.php","w") - Permission denied in /forums/admin/avatar_hack_install.php on line 265

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

Warning: Supplied argument is not a valid File-Handle resource in /forums/admin/avatar_hack_install.php on line 271
...change menu entry in file index.php (Original avatar entry modified)...
...make backup of file member.php...

Warning: fopen("../member.php","w") - Permission denied in /forums/admin/avatar_hack_install.php on line 324
...Change (avatar hack - part 1) the file member.php in forum directory (original modified)...
...Change (avatar hack - part 1.1) the file member.php in forum directory (original modified)...
...Change (avatar hack - part 2) the file member.php in forum directory (original modified)...
...Change (avatar hack - part 3) the file member.php in forum directory (original modified)...
...Change (CSS and jump features) the file member.php in forum directory (original modified)...

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

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

Files update complete.

Warning: fopen("avatar_categ.php","w") - Permission denied in /forums/admin/avatar_hack_install.php on line 354

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

Warning: Supplied argument is not a valid File-Handle resource in /forums/admin/avatar_hack_install.php on line 356
...write file avatar_categ.php to your forums admin directory...

File management complete.

???????

[bad_madman]

[QUOTE]Originally posted by SirSteve
Got this while using the auto install. Am on 2.0.3:

...Warning: fopen("index.php.backup","a") - Permission denied in /forums/admin/avatar_hack_install.php on line 245....
....???????

[bad_madman]

@SirSteve...

[QUOTE]Originally posted by Bad_Madman
I don't know :confused: But I assume that the Script to writing does not have sufficient rights. Make the forums folder and the forums/admin folder 777 chmod. PHP required to have permission to write files to disk. If they do not have the neccessary permissions, it will fail.

[SirSteve]

I'll have to get back to you as when I manually CHMOD the directories, they don't stick.

[Dakota]

Ok I got another suggestion. In the admin CP when you are selecting an avatar for someone to use, like to reset it, or give them a custom avatar or something. Could you also add the hack to that part of it?

[bad_madman]

[QUOTE]Originally posted by Dakota
Ok I got another suggestion. In the admin CP when you are selecting an avatar for someone to use, like to reset it, or give them a custom avatar or something. Could you also add the hack to that part of it?

[lyn]

Originally posted by Bad_Madman
here preview picture 1: categories view

I'm terribly confused. :(

I installed the hack and while I can define categories in Admin just fine, when I go to change the avatar in my user CP, I don't get any sort of drop down menu of any sort.

I have followed the instructions PERFECTLY. So I don't understand what's wrong.

:(

Is there SUPPOSED to be a category drop down menu?

Thanks in advance for any help.

[lyn]

Okay, well I got the dropdown list to work (I think) however I had to go into the "modifyavatar" template and replace $avatcategorie with the contents of the view_avatarcategories template.

Why did I have to do this? What does the $avatcategorie variable call and why did it seem to completely ignore whatever it was supposed to do?

Will replacing it with the contents of the view_avatarcategories template cause any harm?

Thanks in advance.

[lyn]

Okay, I figured out what the problem was.

$avatcategorie is pulling up the template for view_avatarcategoriesdis instead of view_avatarcategories for some reason. I cannot figure out why.

In the PHP code it states the avatarcategoriesdis template will be called when, "$totalavatars=$totalavatars2" however I can't understand for the life of me WHY this isn't working for me or why the "totalavatars" and "totalavatars2" are equal to one another.

Is there something I'm not doing right? Please help

Thanks.

[bad_madman]

[QUOTE]Originally posted by lyn
$avatcategorie is pulling up the template for view_avatarcategoriesdis instead of view_avatarcategories for some reason. I cannot figure out why.

[lyn]

Okay, then the question remains, I guess . . . .

How do I activate the categories?

I have three so far . . . I don't see any option to "activate"

How would I go about doing that?

Thanks.

[lyn]

Oh!!

I got it. I had to go into options and select Yes for "Show up avatar categories" which for some reason was turned off.

Everything is working now and it's beautiful!!

Thanks for the great hack.

I'm really not this stupid, just my blonde roots showing through. :)

[bad_madman]

[QUOTE]Originally posted by lyn
Okay, then the question remains, I guess . . . .
How do I activate the categories?
I have three so far . . . I don't see any option to "activate"
How would I go about doing that?
Thanks.

[bad_madman]

[QUOTE]Originally posted by Bad_Madman
On the left side in the vB CP you find the point "Options" in the paragraph "Avatars / Categories". Then on right side: "Show up avatar categories" >> Yes/No (Categories activate/deactivate) ;)

[Admin]

Ever since I installed this hack, whenever I try to attach a file (with a permitted extension), I get error_avatarnotimage (The uploaded file is not a valid GIF or JPG file. Please ensure that it is an try again).

I installed this hack on a demo board as well, and the same thing happened. I undid everything (including the MySQL changes), but still it didn't help.

[huythuy]

sorry , but is this hack works with the hack " Save avatar as file" ? Or pictures are saved in database ? Because my databse size is limited to 25Mb :(

[bad_madman]

[QUOTE]Originally posted by huythuy
sorry , but is this hack works with the hack " Save avatar as file" ? Or pictures are saved in database ? Because my databse size is limited to 25Mb :(

[bad_madman]

[QUOTE]Originally posted by FireFly
Ever since I installed this hack, whenever I try to attach a file (with a permitted extension), I get error_avatarnotimage (The uploaded file is not a valid GIF or JPG file. Please ensure that it is an try again).

I installed this hack on a demo board as well, and the same thing happened. I undid everything (including the MySQL changes), but still it didn't help.

[Admin]

I'm using v2.0.3, and yes, I installed at least a dozen hacks.
But I'm not sure if it's this hack's fault, maybe something in the PHP configuration that got changed. Someone in the troubleshooting area is checking this now.
Thanks anyway. :)

[GameGalaxy]

Is there any way you can add so that each category can have different user titles?

This way Star Wars Male could have male titles like Han Solo etc
and Star Wars Female could have like Princess Leia?


Thank you :) this works great and will make it easier on me and my users to find a icon.

[HellRazor]

Ok, I've done the install, but for some reason I am not getting the dropdown menu of categories. And the avatars that appear in the list are all from the first category only.

Any idea what the problem might be?

HellRazor

[HellRazor]

I am using a stock VBulletin 2.0.3. My database mods have already been made successfully, but I'm having problems getting the drop-down category list to appear.

Can someone upload the modified files for 2.0.3 for me?

HellRazor

[lyn]

Razor,

Have you checked to make sure you didn't make the mistake I made?

Go click on Options under Avatars / Categories then make sure you have "Show up avatar categories" set to "Yes"

If that isn't the problem, hopefully another kind person here will be able to help. :)

[HellRazor]

Yep, had it set to "yes". But thanks for the tip!

HellRazor



Originally posted by lyn
Razor,

Have you checked to make sure you didn't make the mistake I made?

Go click on Options under Avatars / Categories then make sure you have "Show up avatar categories" set to "Yes"

If that isn't the problem, hopefully another kind person here will be able to help. :)

[bad_madman]

[QUOTE]Originally posted by HellRazor
I am using a stock VBulletin 2.0.3. My database mods have already been made successfully, but I'm having problems getting the drop-down category list to appear.
Can someone upload the modified files for 2.0.3 for me?
HellRazor

[HellRazor]

Well, not sure what I was doing wrong before, but I tried the install again and it worked this time. :) Thanks everyone!

HellRazor

[HellRazor]

Ok, got it installed, but now I have another problem.

Since I installed the hack, the custom avatars don't seem to work. It will let you enter a URL or upload the avatar, but the avatar itself never actually displays (the picture isn't being found wherever its trying to look). Any suggestions?

HellRazor

[HellRazor]

* Bump *

[bad_madman]

[QUOTE]Originally posted by HellRazor
Ok, got it installed, but now I have another problem.

Since I installed the hack, the custom avatars don't seem to work. It will let you enter a URL or upload the avatar, but the avatar itself never actually displays (the picture isn't being found wherever its trying to look). Any suggestions?

HellRazor

[HellRazor]

Here is the generated HTML, if it helps:

<font face="verdana, arial, helvetica" size="2" ><b>My Name</b></font><br>
<font face="verdana,arial,helvetica" size="1" >My Title</font><br>
<img src="avatar.php?userid=1&dateline=998615847" border="0" alt=""><p>

Is this the way it should be? HTML for the avatars added normally comes out like this:

<font face="verdana,arial,helvetica" size="1" >Royal Advisor</font><br>
<img src="images/avatars/Human Males/Human Male 064.jpg" border="0" alt=""><p>

HellRazor

[bad_madman]

[QUOTE]Originally posted by HellRazor
Here is the generated HTML, if it helps:
....
HellRazor

[HellRazor]

No I don't. This is the only hack I have installed.

[bad_madman]

[QUOTE]Originally posted by HellRazor
...
<font face="verdana, arial, helvetica" size="2" ><b>My Name</b></font><br>
<font face="verdana,arial,helvetica" size="1" >My Title</font><br>
<img src="avatar.php?userid=1&dateline=998615847" border="0" alt=""><p>
...

[bad_madman]

[QUOTE]Originally posted by huythuy
sorry , but is this hack works with the hack " Save avatar as file" ? Or pictures are saved in database ? Because my databse size is limited to 25Mb :(

[Aknowles]

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.

[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]

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.

[kfree]

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.

[~Mr NeMo~]

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:

http://216.171.70.87/avatar.jpg

:confused: :confused: :confused:

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

[Lordmusic]

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... :D

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 :confused:

[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... :D

@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.php?action=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/showthread.php?s=&postid=166776#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/showthread.php?s=&postid=166776#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/admin/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.

[magistr]

yhanx man it coll
it work 2.0.3

[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'
...

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

[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!

[Job_41:25]

I just installed this hack, works perfect for members changing their avatars, but I had a question about the avatar faq page. This may seem minor but are the categories supposed to show up under the avatar faq page? They show up when you go to change your avatar but not here. Any idea?:confused:

Here's the faq page (http://www.fragile-alliance.com/forums/misc.php?s=&action=showavatars)

[bad_madman]

@Job_41:25

Did you install this: http://www.vbulletin.com/forum/showthread.php?s=&threadid=24997&perpage=15&pagenumber=3#post154381 ?

[Job_41:25]

Musta missed that part. Works like a charm! Great hack, makes avatars so much easier to mantain.

Thanks for the support. :D

[YourHostSucks]

Works Great, Thanks! ;)

Never run auto_installs! always hand code it.. lol..
I ran the auto_install, and that just made the hand coding a wee harder, when the auto install failed with about 60% of the things
it was supposed to do... ;(
Because then you have to figure out what the auto-install did,
and then what you need to do.. (hehe)

Anyhow was very easy to setup and works great so far..

Is there a way to set what Category is displayed first?
(Order Categories)

[bad_madman]

[QUOTE]Originally posted by YourHostSucks
Is there a way to set what Category is displayed first?
(Order Categories)

[YourHostSucks]

The problem with auto install, is you would first have to give
the correct permissions to the files (777)..... :)
It did most everything but edit the files themself..
EX: It handled the MySQL end, and the template edits..
But did not edit the .php files.

*FYI*

[B0204520]

just wondering if there's option to choose either absolute path and relative path:

Since some ppl prefer to use other server for hosting images instead so that won't hog the forum's performance down

cheers.

[Diva]

I just finished putting together the avatar category hack [again.. heh heh] and when I uploaded, the picture wasn't there. Just a broken link. I scanned the files and found 3 lines in red in the avatar_category.php...

1.
echo "<img src='../$avatarpath/$FileArray[$x]' border=0 align='center'>";

2.
maketableheader("Edit Avatar:</b><i> $avatar[title]</i><img align=\"absmiddle\" src=\"../$avatar[avatarpath]\">","",0);

3.
echo "<td valign='bottom' nowrap align='center'><img src=\"".iif(substr($avatar['avatarpath'],0,7)!="http://" and substr($avatar['avatarpath'],0,1)!="/","../","")."$avatar[avatarpath]\"><br><b>$avatar[title]</b><br>$current_cat\n";

Anyone know the magic words? Please?

Thanks bunches!

[Diva]

Just ^ ^ BUMPING ^ ^ it up, in hopes someone can help... :)

[bad_madman]

Occurs with all avatars or only with certain avatars?

Did you upload the avatars in the CP (CP -> Avatars / Categories -> Modify -> add/upload -> Upload New Avatar) or beforehand by ftp did upload and then added in CP (CP -> Avatars / Categories -> Modify -> add/upload -> Add a single/multiple avatars)?

The red-marked lines are by the way ok. That is because of the fact that it is not a HTML code and your program cannot interpret other code (for example Perl or PHP) probably.

[Diva]

Hi! Thanks for answering. I tried uploading both ways. It happens with all of them. Does it recognize them as pictures, or as files? I saw that question asked earlier in the thread. I don't have that hack, in case you were wondering. Which way is best to attach the avatars, by the way?

[bad_madman]

[QUOTE]Originally posted by Diva
... Does it recognize them as pictures, or as files? I saw that question asked earlier in the thread...

[Diva]

Ummmmm... Am I supposed to have the hack to view them as files?

Actually, it was.. Now I know the best way to upload them... So, if the problem is that I need to have the hack to view pictures as files... them I'm set [I hope!]

[Diva]

Fasten your seatbelts, it's going to be a BUMP-Y night! ;)

[Diva]

and B*U*M*P*I*N*G ...

[bad_madman]

Excuse. But I have frequently few time and can answer therefore not always immediately.

You must hack 'avatars as files' specially to install, if you liked to have this functionality (avatars as files). I have so far however no information about whether hack 'avatars as files' with mine hack worked.

[Syphin]

Ack! It dont work for 2.2.0... *cries* lol anyways.. can someoen tell me whats diffrent? i kinda need this bad... ive got over 1500 avatars... >_<

thnx

-Syphin

[Syphin]

^bump^

[Syphin]

Nevermind, Fixed it myself... ^^

-Syphin

[floleb7]

so what change we have to do ?

(10 000 avatars and i don't want to show all in 1 page :D )

[Syphin]

I just changed what needed to be changed in the zip.. ^^

[floleb7]

thanks :)

[ixian]

Anyone got this to work with 2.20 yet? I have a weird issue. It installed fine, control panel works fine, I add catagories, then avatars to them (via the mass add from a folder), but then, when you go to change avatars, the catagories show up just fine BUT it won't switch pages. I.e. when you switch to say, Sci-Fi, it doesn't show the avatars available in that catagorie, just the same default ones.

I've gone through and re-checked and re-done permissions. Any ideas? Feel free to register on my board and check it out.

Thanks!

UPDATE

Thought I would add some more info:

I've tried it with and without the cascading style sheets mods
Avatar cats are turned on in the cp (remember, the catagorie selection does show up)
Avatar permissions - tried on and off

Still no go. When I choose a catagorie from the drop-down menu, the page refreshes but the same default avatars come up. It's not reading the image folders for some reason (I do have images for each catagory in their own folder under images/avatars/ )

[TheComputerGuy]

Originally posted by Syphin
I just changed what needed to be changed in the zip.. ^^


Ummm...like that is the 2.03 version...

[Syphin]

Originally posted by TheComputerGuy



Ummm...like that is the 2.03 version...


I had just edited the code.. not the wording in the top... But ive changed that now... lol


-Syphin

[ixian]

No ideas what's wrong with mine, by any chance?

[Syphin]

sry man... I dont know what is causing that.. im sure someone else more experienced in php then me can help... =/

-Syphin

[ixian]

As Elvis would say, "Dang, my ding-dang-do".

I'd be willing to donate an Amazon gift certificate or something for like $25 if somebody could help me figure this one out....

[amykhar]

Mine's doing the same thing ixian. I just registered on your board to take a peek.

I am relatively sure the problem is in the query that pulls up the avatars. I am going to play around with it a bit and see if I can't get it working.

I am not guaranteeing that I will be able to fix it today or any time soon. I'm too tired to think straight and have a lot of work that I should be doing. :(

Amy

[ixian]

Thank you!

The $25 Amazon offer still stands, even if you are fixing it for yourself too:)

[amykhar]

Keep your money. :) Mine is fixed. Here's how I fixed it.

I took a fresh copy of member.php and reapplied the hack. This time, I did not use the css navigation.

It just required me to be a bit more awake and careful.

Amy

[TheComputerGuy]

you mean use the non css???

[amykhar]

That's what's working for me.

Amy

[ixian]

Hmmm.....

I thought I had removed the css from member.php. I will take a fresh copy and try it from the beginning.....

[amykhar]

check your email ixian.

Amy

[ixian]

Haven't gotten any....crap, I hope my spam filter didn't trap it for some damn reason, I'm away from the machine it runs on. Could you try to resend? I will try to trap it (assuming it's the filter - it has snagged legit email before)

[ixian]

SCORE!

I dunno why, but when I re-downloaded a fresh copy of vb 2.20, and did the members.php update from scratch minus the css stuff, it now works. Go figure.

Whew! Thanks!

[Sweet Evil]

Ok, I had this had in 2.0.3, well I had to do alot of work.. but it sems to be working again (but) It is not switching to the category when it is selected from the drop down (when they goto modify avatar)...

Any Ideas? :)

[ixian]

Evil,

I had the exact same problem. You need to do what I did - start over with a fresh copy of members.php and DON'T use any of the css stuff. It worked like a charm.

[Sweet Evil]

Thanks, "It worked like a charm" :D

[LuBi]

So you guys are running it on 2.2? Good if so, but which download do I get..? Is the first one still ok or should I get the one back a page or two..? :confused: Thanks!

Edit* Well I went on by myself and installed the hack from a few pages back.. Problem is, I don't see thet pull down to select catagories. I didn't use the CSS or the jump like I read from previous posts... can anyone help me?

[ixian]

Did you add the db entries? I don't think that was in the modified one.

[LuBi]

I dunno.. I ran sqltodos.php ...? What else was there..?

**Edit - I don;t think I edited any of the templates except the one in the install.txt ..... There are other text files in the zip I didn't touch those. Could someone walk me through it or something..?

[Dark Blaze]

Very nice hack, well done :)

[ForYou]

Hello ...

vb 2.2.1

can't find this in index.php
-----------------------------------

4. Then modify "index.php" it the following way:

>>> Search for:
__________________________________________________ __________________

<?php maketableheader("Avatars"); ?>
</table>
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=upload"> Upload </a> |
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=add"> Add </a> |
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>

----------------------------

what can i do for that ?

regards

[Sadie Frost]

I'm having the same problem :) Any help would be much appreciated!

This may be the pertinent code that I see in my file (?): (I'm a newbie, so please ignore anything I say that's really stupid!)

makenavoption("Add","avatar.php?action=add","|");
makenavoption("Modify","avatar.php?action=modify","|");
makenavoption("Upload","avatar.php?action=upload");
makenavselect("Avatars");

Edit:
I think I got it!

For You, try using the instructions/download that Syphin posted here:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=24997&perpage=15&display=&pagenumber=11

It's working for me so far :) It's my first hack though, so I'm sure plenty could still go wrong! :)

[Dalius]

Is this hack stable on 2.2.1?

[ixian]

Originally posted by Dalius
Is this hack stable on 2.2.1?

It is for me.

[Dalius]

Ok Problem
1) Huge Blab of Text Ontop of Text Book

2)
Can't upload any avatars from Hard Drive without getting permission errors
Check Attached Pic for more details

I am :
using vb 2.2.1
followed instructions exactly /w css enabled

[Dalius]

pic of (1) and (2)

[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/admin/avatar_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 :D

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

[StarBuG]

And in the member.php the avatars are not listed so I can?t select any!

see screenshot!

I took imgs from the icons folder to test.

Sorry it?s german ;)

Any suggestions??

Greetings

StarBuG

[Smallville]

I'm not sure then. Try PMing Matt, or see if he responds to this. He helped me. He may have done something else I'm not sure of. Can't think of what else to do. I'm also not that great at PHP anyway.

[Smallville]

Checking what Matt did for me. He edited something in the Options link on the CP.

Click the Options link, the on the two column list, click avatars (or scroll down) and make sure the Show Up Avatars Catagories is clicked yes, and Show Up Not Catagorized Catagories is yes, and Avatar Catagories Permissions is no. See if that helps. Checking for more.

[Matt]

Starbug what is the address of your board so I can take a look, if you need me to I will install it for you ;)

[Smallville]

Matt, what all did you change from what I had uploaded? That way if I need to install this again for some reason, or help a friend I can. Thanks. I noticed you exported something in tbs.php (template backup system). What was that?

[Matt]

LOL! I didn't change a single thing you just hadn't followed the instructions properly ;)

The only thing we changed was the code you replace in admin/index.php to update it for 2.2.1 :D

[Smallville]

Oh. LOL

Why did you need to go into the tbs.php thing? That's not needed for this hack (since it isn't a regular file unless installed).

By the way, MY .COM FINALLY WORKS!!!

[StarBuG]

Matt!

Sorry I can?t give u the URL cause I have the hack installed only on my webserver not online (this is my normal practise so if anything goes wrong the online Board is not down or anything! :D) and my Board is not for Public view!
But I can send you the files and the templates as txt files if you want! Just give me your mail addy via pm and I?ll send it to you!

I have done all you said in the install file and the categories are just not there!
Maybe don?t using the CSS is the solution??
Or any other suggestions?

Thx for your help

Greetings

StarBuG

[Minimazz]

After i had follow the instructions, i obtain this on the user's profile

Parse error: parse error in /member.php on line 823

Someone can help me?

Thanks!

[Warlord]

I'm going to try and install this on 2.2.1 tonight or tomorrow..

[Liz]

Version 2.2.0 - 2.2.1
Hack is in. BUT when you go to Select Categories it is blank. What happened?
In the admin control panel all the categories are in..all the avatars are moved and show categories is selected yes under options.
Can anyone help? This is really frustrating and my memebers are getting antsy.

Minimazz - I had one of those errors too. But I fixed it..and I'm not sure how. After hours of doing the same coding you forget at times. I can always try sending you my member.php file......

This is what happends to my hack (It's a screen shot)...the avatar categories don't show. Does anyone know what's wrong?

[newvbuser]

Does this work with version 2.2.2 ??

[LuBi]

Originally posted by newvbuser
Does this work with version 2.2.2 ??

Yep! This is one of the most powerful hacks to date :eek:

Just wanted to give my thanks :p

[Liz]

I put the avatar categories hack into my board (vb 2.2.1) and it looks great EXCEPT that the very same 25 avatars show up for each category no matter which one you choose! And at the bottom of the screen where the # of av is listed, there is nothing for total # of avatars, just "showing 4 of 4".

Anyone have any idea what went wrong??

Its the first 25 avatars I had in there to begin with. And show categories is enabled.

Help help!!

Liz

[Justice]

still doesn't work with the "avatars as files" hack, huh?

[Jawelin]

Originally posted by Justice
still doesn't work with the "avatars as files" hack, huh? ... and what about 14 (fourteen) !!! attachments within a single thread to complete this hack, with lot of files overwriting each other ?

:stupid: :supwink:

[Jawelin]

--=^BUMP^=--

[LanciaStratos]

I can't seem to find the code I need to change in admin/index.php. It's just not there, and I'm using 2.2.0. :confused: Am I doing something wrong, or does this just not work for 2.2.0? :stupid:

[Rose]

Originally posted by LanciaStratos
I can't seem to find the code I need to change in admin/index.php. It's just not there, and I'm using 2.2.0. :confused: Am I doing something wrong, or does this just not work for 2.2.0? :stupid:


I'm having the same problems. I'm using 2.2.2 and can't find the right admin/index.php code.


BUMP!!! :D


Any help? ;)

[Liz]

I figured out what was wrong with mine, but forgot to post about it. Ooops? ;)

Rose and LanciaStratos - are you two scrolling down and reading every bit of code..looking for what you need to change? Yikes! That's a pain. I never did that, what I do is hit
CTRL and F and then type in part of the code I'm looking for...and it brings me directly to the code. ;)

Hope that helps!

Also..which index.php are you looking in? Maybe your editing the wrong one....

[Floris]

Anybody running this on 2.2.4 ? (and without problems?)

[HellRazor]

I'm running it on 2.2.4 with no problems.

[Stylez]

what about 2.2.5?

[ZiRu$]

this is a GR8 hack! I will test it out as soon as I get home! Congrats

[Jawelin]

I'm trying to investigate why some users has choosen an avatar in a category they shouldn't have seen ....
How could I go deeper ?

Thanks

[Jawelin]

Originally posted by Jawelin
I'm trying to investigate why some users has choosen an avatar in a category they shouldn't have seen ....
How could I go deeper ?


I think I've found the problem: register.php
Infact, many users choose category-unaccesible avatars at register time.
I think the quickest solution could be replace
if ($avatarenabled) { with if ($avatarenabled and !$avatarpermissions) {
... What do you think about ?

Thnx

[alanvo]

any luck with 2.2.5?

[LightBringer]

I'd like to know if anyone else has gotten this to work on 2.2.5 as well. ;)

[geniuscrew]

We are running it on 2.2.5 without any probs ;)

[nulltone]

Originally posted by Liz
Version 2.2.0 - 2.2.1
Hack is in. BUT when you go to Select Categories it is blank. What happened?
In the admin control panel all the categories are in..all the avatars are moved and show categories is selected yes under options.
Can anyone help? This is really frustrating and my memebers are getting antsy.

Minimazz - I had one of those errors too. But I fixed it..and I'm not sure how. After hours of doing the same coding you forget at times. I can always try sending you my member.php file......

This is what happends to my hack (It's a screen shot)...the avatar categories don't show. Does anyone know what's wrong?

I am using version 2.2.5, my problem is similar, but I dont even see a dropdown box to cycle through.

[Emma]

I am having a problem with , when the categories are viewable, new members can pick their avatar but then it comes up saying they aren't logged in, when in fact they are, and when they try to log in, it won't let them b/c it says they have the wrong password, when infact they have the right one.

Help!
Emma

[ZiRu$]

Is anyone running this fine with the STORE hack? Cause I heard there was problems

[Velocd]

Hey this looks like another excellent hack, can't believe I passed by it. By reading the above posts I'm not so sure its compatible with newer VB versions though..:(

[Brad]

i got problems under 2.2.5


the permisson to allow custom avatars in the cp is gone, that means users cant upload custom ones anymore, only us admins in the cp :(. they get this message, The uploaded file is not a valid GIF or JPG file. Please ensure that it is and try again.


the other admin installed it, newbie hacker, so id thought i ask for suport before i went intot he files/database

[Preasidium]

I have a problem.

I am running 2.2.5
I uploaded and ran the sqltodos.php with no problems.

Then i proceed to edit the index.php and I cant seem to find this:

<?php maketableheader("Avatars"); ?>
</table>
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=upload"> Upload </a> |
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=add"> Add </a> |
<a href="avatar.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>


What I see for avatars is this:

// *************************************************
makenavoption("Add","avatar.php3?action=add","|");
makenavoption("Modify","avatar.php3?action=modify","|");
makenavoption("Upload","avatar.php3?action=upload");
makenavselect("Avatars");
// ***

When i replace that with the first code I get a parse error. What exactly am I doing wrong here?

[scsa20]

hmm...seems like some (if not, most) people that's runny vb 2.2.5 had luck with it, I, for the other hand, didn't :( I don't know what's wrong, I put in everything, it doesn't categories the avatars, nor show the drop down box :(

any help can be help full, thanks

[Suspiria]

I have the same problem as these other folks do with 2.2.5 - not having the drop down menu appear in the user CP. Does anyone know how to fix this? :(

[ZiRu$]

I guess I'll wait till the bugs are cleared up

[Velocd]

I am having this problem also :( For some reason, and I have created all the neccesary templates and done everything correctly, the drop down list is not appearing! Somebody please help! Firefly or Logican perhaps? I am running version 2.2.4
If you have it working and you're running 2.2.4 or 2.2.5, PM me please!

[Velocd]

^ bump

somebody please help this is an awesome hack and vbulletin wouldn't be the same without it ^_^

[scsa20]

I don't know what's wrong with it eather, it's not showing up for me either :(

[Matt]

This is really odd, it works fine for me, and thats on 2.2.5. I just followed the instuctions as stated.

I have to go offline now but I will rewrite the file later and see if that helps, if not then people can send me links to their forums and I will see if I can spot the problem :)

[Sadie Frost]

It works fine for me on 2.2.4 - that is odd

I'll try to help if I can - I know of 2 people having problems installling this though

[Velocd]

thanks, any help would be greatly appreciated. I can be contacted on AIM at invincible box

;)

[bad_madman]

I have changed the old version a little. These new version works definitely with vB Version 2.2.5!
I also have enclosed a help file (firststeps.txt) which can help with first problems. Reading through the file at the best at problems after the installation once. Also notice every step in the installation instructions!

Madman

The file was removed.
The latest version is in the first post (https://vborg.vbsupport.ru/showthread.php?postid=152159#post152159).

[Sadie Frost]

Okay, I haven't looked at the new file just posted, but in case that doesn't work, I've just finished installing this on a friend's 2.2.5 board with no problems. Here's what I did in case it helps anyone. :)

I followed the directions bad madman gave, in a nutshell:

1) added each of the templates and made the changes as instructed to modifyavatar template

2) uploaded sqltodos and avatar_categ; ran http://www.yoursite.com/path/to/admin/sqltodos.php

3) Made change to index.php - this was different than in the directions I had (maybe I had an old copy):

Find:

makenavoption("Add","avatar.php?action=add","|");
makenavoption("Modify","avatar.php?action=modify","|");
makenavoption("Upload","avatar.php?action=upload");
makenavselect("Avatars");

and replace with:


makenavoption("Add","avatar_categ.php?s=&action=add","|");
makenavoption("Modify","avatar_categ.php?s=&action=modify","|");
makenavoption("Options","options.php?s=&action=options&settinggroupid=26#settinggroup26");
makenavselect("Avatars / Categories");


4) made changes to member.php - here I added the code after it says >>> Replace ist with (if you don't use CSS-Navigation - see further below):

That is all I did - I skipped all the other CSS stuff. Like I said, I might have an old copy of the directions, but what I did worked, so I figured it might help someone :)

[Velocd]

LOL! Bwahahahah, I just figured out why it never showed up before, and it is the stupidest mistake in the world. Funny thing is, everyone who can't get this hack to work 99% chance if you installed correctly its because of this problem (thanks to bad_madman).

In Admin -> Options -> Avatars

Make sure the following are marked yes:

- "Show up avatar categories"
- "Show up not categorized avatars"

Now your drop down list should show, for me it was default for "show up avatar categories" was off, and I never bothered to check that value. d'oh

Its all good now though, great hack and thanks ;)

[scsa20]

Originally posted by Velocd
LOL! Bwahahahah, I just figured out why it never showed up before, and it is the stupidest mistake in the world. Funny thing is, everyone who can't get this hack to work 99% chance if you installed correctly its because of this problem (thanks to bad_madman).

In Admin -> Options -> Avatars

Make sure the following are marked yes:

- "Show up avatar categories"
- "Show up not categorized avatars"

Now your drop down list should show, for me it was default for "show up avatar categories" was off, and I never bothered to check that value. d'oh

Its all good now though, great hack and thanks ;)

lol, I just noticed that after reading that post, my "Show up not categorized avatars" was set to yes as default but that other one "Show up avatar categories" was set to no, thanks for pointing that out to everyone :D

[bad_madman]

New version out: 1.25.1

Features/Updates
- 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 (http://www.latriade.net/forum/misc.php?s=&action=showavatars)
- 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.

Screenshots:
Screenshots in the first post (https://vborg.vbsupport.ru/showthread.php?postid=152159#post152159).

Download:
The latest version is in the first post (https://vborg.vbsupport.ru/showthread.php?postid=152159#post152159) of this thread.

Madman

[Velocd]

Excellent job ;)

[Velocd]

Rather odd problem. I'm on Version 2.2.6, and for some reason its giving me an error in the registration page when you first enter it. I'm not sure where the error can be found, but its defiantly linked to this hack. I have Microsoft Visual C++ installed that included a script debugging program that picked this error up, so maybe if you don't have MVC++ you may not even get the error on 2.2.6, but it's there I'm sure. Anyway, at first you can hit "no" to the alert, but then when you try to view your avatar on the forum homepage it does not show (in the welcome panel). From there I have noticed the users avatar does not show at all to themselves, but to others it does....

See attachment for picture of error, I hope you can fix it :D

edit:
Now that I overlook the error, a "runtime" error is usually cause from Javascript, is it not? That is the only other language used on my forum other than PHP/MySQL and HTML (which generally does not create those kind of errors).

[bad_madman]

You have a 2nd 'form' (<form.......>) on your registration page. Standard is ONE 'form'. You should change the JavaScript code in the Template registercoppa and registeradult.

Search in this templates for:document.images.avatarpic.src = document.forms[0].avatarsel[document.forms[0].avatarsel.selectedIndex].value;

Replace it with:document.images.avatarpic.src = document.forms[1].avatarsel[document.forms[1].avatarsel.selectedIndex].value;

This should work...

[bad_madman]

Known bug in Hack Version 1.25.1: :(
In User CP when anyone changes the avatar, when the pick a category it shows the same avatars from the first category. Thx @Genie for the informations!

I will publish this weekend an update! As provisional solution the problem can be removed as follows :nervous::
Go to the admin area (vB Control panel). Section "Avatars" -> "Options". Mark "No" behind "Avatar Category Permissions".

The update 1.25.2 will contain also new functions:
- Sorting order of the categories alterable.
- More options in the Avatar-Admin area.
- Extensive statistics to the Avatars/Categories.
- Bug Fixing in avatar_categ.php.
- and more... :bunny:

Madman

[Velocd]

You're fix in post #242 worked good getting rid of the error message in the registration page, but for somereason when any new user registers their avatar does not display on the forumhome page (in the welcome panel). I'm not sure why this is, or if its linked to avatar category hack, but I didn't have this problem before I installed the hack on 2.2.6

[bad_madman]

Hmm. I hadn't installed the "Welcome Panel Hack" yet.
But I will install the hack once. Perhaps I find what.
You have installed the final version of the "Welcome Panel Hack (http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=21)"?

Madman

[Velocd]

Yup ;)

I'm not sure why its not working but I'll troubleshoot more later today

[bad_madman]

Originally posted by Velocd
Yup ;)

I'm not sure why its not working but I'll troubleshoot more later today It works for me. I have the 'welcome panel hack' (http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=21) on vB 2.25 installed.
Registration works faultlessly. The Avatar is then also shown on the home page. If no user is logged in, then the guest avatar is shown. If the user hasn't selected any avatar, then the 'no avatar selected' picture is shown.
It must have any other reason with you that it doesn't work. I wanted to register me in your forum but you just install the Hacks newly ;)

[Colon33]

How can i make custom avatars not appear in teh general listing of avatars when someone wants to change there avatar. I dont want people having the ability to select custom avatars for themselves. All the features in this hack is getting me lost. So far i only see changes made in the admin area of the forum. Is there anything that goes into the user control panel or no?

But the most important is hiding custom avatars from the general public viewing.

[ixian]

If you want to see what this hack should look like, go over and register at my forums. I have it working as intended, with CSS navigation to boot.

All you have to do to hide custom avatars is assign them to a specific catagory and then set that catagory's permissions for use only by specific groups (such as admins or mods). You can also assign post counts a user must have in order to use certain avatars, although they will still show up - users just won't be able to use them.

I used to have a catagory called Admins which only admins and mods could see in the UserCP. It's currently disabled, because 1.25.1 of this hack has a bug when use permissions is activated. Madman has indicated this is fixed the the new version, which I am patiently awaiting:)

[Colon33]

please check out

http://forums.gamer-pit.com

am i doing something wrong people can still see all the avatars the ones with names underneath should be hidden.