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.

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

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

?????

(using v2.0.3)

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

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

yes.

[QUOTE]Originally posted by SirSteve
yes.

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

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

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

[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

Yes and the install all from the admin directory.

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

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:

http://216.171.70.87/avatar.jpg

:confused: :confused: :confused:

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

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

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

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?

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

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

sqltodos_test.php

[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

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

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

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

Need help still..

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

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

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

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

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.

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.

The entry does not exist.

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?

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