1
kiwiguy
Avator Upload
  • 2004/5/15 9:51

  • kiwiguy

  • Friend of XOOPS

  • Posts: 295

  • Since: 2004/4/19


I have about 200 Avators I like to upload to my site but do not want to do it through the admin section how do I go about just uploading them to the upload file and it recognising it as avators?

As I uploaded them but they never showed up to be avators!!

Please help!

cheers
kiwiguy

2
alain01
Re: Avator Upload
  • 2004/5/15 12:25

  • alain01

  • Just can't stay away

  • Posts: 528

  • Since: 2003/6/20


see this article

exemples of xoops_avatar table :
DROP TABLE IF EXISTS `xoops_avatar`;
CREATE TABLE `xoops_avatar` (
  `
avatar_idmediumint(8unsigned NOT NULL auto_increment,
  `
avatar_filevarchar(30NOT NULL default '',
  `
avatar_namevarchar(100NOT NULL default '',
  `
avatar_mimetypevarchar(30NOT NULL default '',
  `
avatar_createdint(10NOT NULL default '0',
  `
avatar_displaytinyint(1unsigned NOT NULL default '0',
  `
avatar_weightsmallint(5unsigned NOT NULL default '0',
  `
avatar_typechar(1NOT NULL default '',
  
PRIMARY KEY  (`avatar_id`),
  
KEY `avatar_type` (`avatar_type`,`avatar_display`)
TYPE=MyISAM AUTO_INCREMENT=204 ;

#
# Contenu de la table `xoops_avatar`
#

INSERT INTO `xoops_avatar` (`avatar_id`, `avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_created`, `avatar_display`, `avatar_weight`, `avatar_type`) VALUES
(1'savtavatar001.gif''avatar''image/gif'108346002610'S'),
(
2'savtavatar002.gif''avatar''image/gif'108346002910'S'),

...
...
(
202'savtavatar202.gif''avatar''image/gif'108346062910'S'),
(
203'savtavatar203.gif''avatar''image/gif'108346063210'S');

";" for the last, not ","
for 203 avatars

3
Catzwolf
Re: Avator Upload
  • 2004/5/15 12:42

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


I wrote a hack to allow multi atavar uploads in one, I will have a look for it and post it here.

4
kiwiguy
Re: Avator Upload
  • 2004/5/15 14:36

  • kiwiguy

  • Friend of XOOPS

  • Posts: 295

  • Since: 2004/4/19


Thanks CatsWolf I would appreciate it if you could mate.

alain01 your post was not helpful at all as it does not give me the answer that i need please could you be a lot clearer as I do not understand php very well at all.

To anybody else please i still need help on this.

thanks
kiwiguy

5
cptwinky
Re: Avator Upload
  • 2004/5/15 15:20

  • cptwinky

  • Just popping in

  • Posts: 37

  • Since: 2004/5/1 2


I would love that hack as well catzwolf

6
alain01
Re: Avator Upload
  • 2004/5/16 6:25

  • alain01

  • Just can't stay away

  • Posts: 528

  • Since: 2003/6/20


Quote:

alain01 your post was not helpful at all as it does not give me the answer that i need please could you be a lot clearer as I do not understand php very well at all.

ok,
this exemple is a excel file that i have built in order to add 203 avatars in 1 click.
i rename this exccel file in avatars.sql (query file) and import this table in my database with phpmyadmin.
Then i copied my 203 avatars in upload directory (files begins with savt***.gif or jpg).
That's all. no php.
But you should know phpmyadmin, the interface to manipulate the database...
Please don't use my method if you 're not used phpmyadmin...

Login

Who's Online

153 user(s) are online (96 user(s) are browsing Support Forums)


Members: 0


Guests: 153


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits