11
Bender
Re: avatars wont work?
  • 2005/10/3 14:40

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


This is not the query when you click on submit, right?

I mean you select the avator you wish and then press submit. Right after that you should get all these querries:

Quote:
Queries
SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC

SELECT sess_data FROM xoops_20131___session WHERE sess_id = '********************************'

SELECT * FROM xoops_20131___users WHERE uid=1

SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '2') ORDER BY conf_order ASC

SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC

UPDATE xoops_20131___users SET uname = 'testuser', name = '', email = '***@**************.de', url = 'http://***url***/', user_avatar = 'savt43410c7aeb671.jpg', user_icq = '', user_from = '', user_sig = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', posts = 0, pass = '********************************', attachsig = 0, rank = 7, level= 5, theme = 'default', timezone_offset = 0.00, umode = 'thread', last_login = 1128350098, uorder = 0, notify_method = 1, notify_mode = 0, user_occ = '', bio = '', user_intrest = '', user_mailok = 0 WHERE uid = 1

SELECT a.*, COUNT(u.user_id) AS count FROM xoops_20131___avatar a LEFT JOIN xoops_20131___avatar_user_link u ON u.avatar_id=a.avatar_id WHERE avatar_file = 'savt43410c7aeb671.jpg' GROUP BY a.avatar_id ORDER BY avatar_weight, avatar_id

DELETE FROM xoops_20131___avatar_user_link WHERE user_id = 1

INSERT INTO xoops_20131___avatar_user_link (avatar_id, user_id) VALUES (1, 1)

Total: 9 queries
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

12
SERB-4-LIFE
Re: avatars wont work?

Yeh well thats the problem, coz i only get the text i showed u before.

How do i fix that?

13
erzon
Re: avatars wont work?
  • 2005/10/9 7:21

  • erzon

  • Quite a regular

  • Posts: 211

  • Since: 2005/1/1 3


even i can't upload avatar in 2.0.13.1 version.. even i set the options to allow users to upload custom avatar i dont see the upload link

Login

Who's Online

382 user(s) are online (316 user(s) are browsing Support Forums)


Members: 0


Guests: 382


more...

Donat-O-Meter

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

Latest GitHub Commits