FUDforum: How To » Avatar Management Confusion

Home » FUDforum » How To » Avatar Management Confusion

Show: Today's Messages :: Polls :: Message Navigator

Avatar Management Confusion [message #6048]

Tue, 01 October 2002 16:11

Raven17

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

Report message to a moderator

Re: Avatar Management Confusion [message #6049 is a reply to message #6048]

Tue, 01 October 2002 16:12

Ilia

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

Report message to a moderator

Re: Avatar Management Confusion [message #6050 is a reply to message #6049]

Tue, 01 October 2002 16:16

Raven17

Messages: 32
Registered: September 2002
Location: Southern California

Karma: 0

Member

prottoss wrote on Tue, 01 October 2002 09:12

yes you do Wink

OK SQL wizards, anyone have an example on how to do this?
Embarassed

Report message to a moderator

Re: Avatar Management Confusion [message #6052 is a reply to message #6050]

Tue, 01 October 2002 16:26

Ilia

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

Report message to a moderator