1
script_fu
Avatar default. How to change in the database????

By marktwain
Re: Is there a User Registration Template somewhere?
The easiest way to set a default timezone and avatar at registration is go into your MySQL database ("Users" table) using phpMyAdmin or some other MySQL management program, and set those defaults.

For example, change the default value in the "user_avatar" field to "youravatar.gif" (your avatar image file name) and then make sure you have that image file in your uploads folder. Change the default value in the "timezone_offset" field to -5.0 or +2.0 or whatever you want the offset to be.

Then, whenever someone registers, those default values will automatically get inserted into that users record.



I tryied this and I found blank.gif in the xoops_users table in phpMyAdmin. I changed the blank.gif to another picture in the uploads folder and saved in phpMyAdmin and nothin happened??? Can anyone else hepl on this...

2
script_fu
Re: Avatar problems need to assign a default...

Table xoops_users has been altered.

SQL-query : [Edit] [Create PHP Code]
ALTER TABLE `xoops_users` CHANGE `user_avatar` `user_avatar` VARCHAR( 30 ) DEFAULT 'savt3fdce6a2ad590.gif' NOT NULL


Structure
Browse
SQL
Select
Insert
Export
Operations
Empty
Drop



Field Type Attributes Null Default Extra Action
uid mediumint(8) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
name varchar(60) No Change Drop Primary Index Unique Fulltext
uname varchar(25) No Change Drop Primary Index Unique Fulltext
email varchar(60) No Change Drop Primary Index Unique Fulltext
url varchar(100) No Change Drop Primary Index Unique Fulltext
user_avatar varchar(30) No savt3fdce6a2ad590.gif Change Drop Primary Index Unique Fulltext

3
script_fu
Re: Avatar problems need to assign a default...

Also a lil note. I changed the blank.gif in the uploads folder to an avatar with a bag over its head on some of my other sites. I just renamed the picture avatar blank.gif and uploaded to uploads. Now what happened was the webmasters avatar was changed to that blank.gif

Members and Top posters stayed blank... Now what do I need to change to have the whole system use one avatar.

I wish the avatar system was still intact. I didn't care if the download was a lil bit more. This is alot of work and a pain in the arse to mess with on each site. The avatar system was fine in 2.0.2 what was the reason for ripping it out? Can the XOOPS team put back the system please...

4
script_fu
Re: Avatar problems need to assign a default...

Re looking at this post --->I think one avatar installed with XOOPS from the get go would be a wonderful thing. Maybe the admin should be able to toggle on or off that one avatar as they see fit. Again it is a pain in the butt to fix the system when working with lots of sites.

Login

Who's Online

146 user(s) are online (65 user(s) are browsing Support Forums)


Members: 0


Guests: 146


more...

Donat-O-Meter

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

Latest GitHub Commits