FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Avatar Management Confusion
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Avatar Management Confusion [message #6048] Tue, 01 October 2002 16:11 Go to next message
Raven17 is currently offline  Raven17   United States
Messages: 32
Registered: September 2002
Location: Southern California
Karma: 0
Member
I trawled the Internet and found about 100 or so files I want to use as avatars for my users.

I copy them into $BROWSABLEFORUMS/images/avatars.

The file perms looks fine:

-rw------- 1 apache apache 369 Oct 1 08:24 003.gif
-rw------- 1 apache apache 275 Oct 1 08:24 004.gif
-rw------- 1 apache apache 285 Oct 1 08:24 006.gif
-rw------- 1 apache apache 241 Oct 1 08:24 007.gif

However, when I bring up the 'Profile' button and click on "choose avatar" -> "Use Builtin" -> "Choose Avatar"; it comes back with "NO Avatars Available".

When I go under the Control Panel as the administrator and select "Avatar Manager" and then click on "Select Avatar", I can see them all.

I don't have to manually upload these 100 files in through the Avatar Manager do I?

That would make me VERY sad. Crying or Very Sad Crying or Very Sad Crying or Very Sad
Re: Avatar Management Confusion [message #6049 is a reply to message #6048] Tue, 01 October 2002 16:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
yes you do Wink
Otherwise it cannot reference them from the SQL table. Of course not all is lost, you can write a small script that would loop through the directory and insert each avatar image into the avatars SQL table.


FUDforum Core Developer
Re: Avatar Management Confusion [message #6050 is a reply to message #6049] Tue, 01 October 2002 16:16 Go to previous messageGo to next message
Raven17 is currently offline  Raven17   United States
Messages: 32
Registered: September 2002
Location: Southern California
Karma: 0
Member
prottoss wrote on Tue, 01 October 2002 09:12

yes you do Wink
Otherwise it cannot reference them from the SQL table. Of course not all is lost, you can write a small script that would loop through the directory and insert each avatar image into the avatars SQL table.


OK SQL wizards, anyone have an example on how to do this?
Embarassed
Re: Avatar Management Confusion [message #6052 is a reply to message #6050] Tue, 01 October 2002 16:26 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
for every image inside the directory run the following query:

INSERT INTO {SQL_TABLE_PREFIX}avatar (img,descr) VALUES('{IMG_NAME}', '{IMG_NAME}');

replace {SQL_TABLE_PREFIX} with your SQL table prefix and replace
{IMG_NAME} with the avatar file name.

nice and simple.


FUDforum Core Developer
icon14.gif  Re: Avatar Management Confusion [message #6063 is a reply to message #6052] Tue, 01 October 2002 17:12 Go to previous message
Raven17 is currently offline  Raven17   United States
Messages: 32
Registered: September 2002
Location: Southern California
Karma: 0
Member
Muchas Gracias!

Worked like a champ. 622 avatars imported. THAT is probably not such a hot idea. Hahahahahahahahaha

Laughing Shocked

[Updated on: Tue, 01 October 2002 21:34]

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Very slow response times
Next Topic: Problem with uploads
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 03 16:42:45 GMT 2024

Total time taken to generate the page: 0.03665 seconds