[2.0.6] Per-User Avatar/Sig Disable

The cleanup is complete. This forum is now read only.
Post Reply

Rating:

Excellent!
15
44%
Very Good
9
26%
Good
3
9%
Fair
3
9%
Poor
4
12%
 
Total votes: 34

j t
Registered User
Posts: 20
Joined: Thu Jan 29, 2004 2:42 am
Contact:

Post by j t »

Sorry... my SQL isn't good enough to do it off the top of my head, so I had to wait for a friend to message back.

To change the field for all existing users, get into an SQL program (mysql, or using phpMyAdmin, or whatever) and...

Code: Select all

UPDATE phpbb_users SET show_avatars=1 WHERE 1
The "WHERE" clause will match all records, because the expression "1" will always be true.


To alter the default value for new users...

Code: Select all

ALTER TABLE phpbb_users ALTER COLUMN show_avatars SET DEFAULT 1
reddem0n
Registered User
Posts: 94
Joined: Thu Nov 27, 2003 2:46 am

Post by reddem0n »

that column doesn't exist...thats what i get for both of them
j t
Registered User
Posts: 20
Joined: Thu Jan 29, 2004 2:42 am
Contact:

Post by j t »

Oops. Sorry 'bout that. I was going from memory on the item names which were added by this mod.

Code: Select all

UPDATE phpbb_users SET user_showavatars=1 WHERE 1 

ALTER TABLE phpbb_users ALTER COLUMN user_showavatars SET DEFAULT 1 

It's the same column that you added at the beginning of all this.
icedawg
Registered User
Posts: 23
Joined: Sun Nov 09, 2003 7:32 pm
Contact:

Post by icedawg »

Jorram wrote: function display_avatar_gallery($mode,

and then after the $allowsmilies, add

$showavatars, $showsignatures,


Yes, that will partially fix it (although those should read &$showavatars, &$showsignatures), but you also need to add

'showavatars', 'showsignatures',

into the $params array after 'allowsmilies', near the end of that function.
User avatar
Latinus
Registered User
Posts: 175
Joined: Mon Jul 08, 2002 7:25 pm
Location: Fr
Contact:

Post by Latinus »

Hi,

I've tried to install this MOD on my 2.0.7phpBB forum.
After uploading the "moded files" (and alter table on mysql), there was some problems : the topic viewing was completly corrupted :?

How can I know if I made mistake or not ?


thx,
Lat
User avatar
Latinus
Registered User
Posts: 175
Joined: Mon Jul 08, 2002 7:25 pm
Location: Fr
Contact:

Post by Latinus »

I can show you "my" moded files... if needed...
mdbw
Registered User
Posts: 63
Joined: Fri Jun 27, 2003 9:12 pm
Location: Bahamas, CT
Contact:

Post by mdbw »

this might sound foolish, but I have never seen this in a mod before..... what does this mean?
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD COLUMN user_showavatars tinyint(1) default '1';
ALTER TABLE phpbb_users ADD COLUMN user_showsignatures tinyint(1) default '1';
#


:oops: Thanks!
User avatar
Latinus
Registered User
Posts: 175
Joined: Mon Jul 08, 2002 7:25 pm
Location: Fr
Contact:

Post by Latinus »

mdbw wrote: this might sound foolish, but I have never seen this in a mod before..... what does this mean?
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD COLUMN user_showavatars tinyint(1) default '1';
ALTER TABLE phpbb_users ADD COLUMN user_showsignatures tinyint(1) default '1';
#


:oops: Thanks!


This is 2 mysql commands, they add 2 columns to the "phpbb_users" table.
You have to run this code in phpmyadmin :
- select your forum database
- go to "sql" tab
- copy/paste this code in the "Run SQL query/queries..." field
- "GO"
mdbw
Registered User
Posts: 63
Joined: Fri Jun 27, 2003 9:12 pm
Location: Bahamas, CT
Contact:

Post by mdbw »

thanks, luckily, I figured it out anyway, and it works great. EXCELLENT MOD!
TeMPeST
Registered User
Posts: 100
Joined: Fri May 03, 2002 7:45 pm
Contact:

Post by TeMPeST »

hi...

is this mod 2.0.8 compatible?

thanks.
User avatar
tmhall
Registered User
Posts: 26
Joined: Thu May 08, 2003 5:40 pm

Post by tmhall »

Latinus wrote: Hi,
I've tried to install this MOD on my 2.0.7phpBB forum.
After uploading the "moded files" (and alter table on mysql), there was some problems : the topic viewing was completly corrupted :?
How can I know if I made mistake or not ?

thx,
Lat

I had that problem too, as did others. The solution is mentioned a couple times earlier in this thread, like here.
User avatar
Latinus
Registered User
Posts: 175
Joined: Mon Jul 08, 2002 7:25 pm
Location: Fr
Contact:

Post by Latinus »

Yes, I've seen this "precision" after I've posted my question.
Thanks ;)

Lat
User avatar
kender
Registered User
Posts: 109
Joined: Fri Apr 02, 2004 11:32 pm
Location: Great Lakes Region, USA

Post by kender »

has all the bugs been ironed out of this mod? is it working now?

in other words.. is it still on ver 1.0.0.. or is it been fixed?
Sick of overpaying for cable?
free dish network
chris_blessing
Registered User
Posts: 15
Joined: Mon Apr 05, 2004 2:50 pm

Post by chris_blessing »

sany wrote:
ayn wrote:I installed this mod and the edit user page in Admin shows wrong value of $showsignature... the user profile edit page has the correct value... strangely enough, $showavatar's at both pages are the same and correct... any ideas? thanks!

--Andrew

have noticed this as well.
found typo - now it works.
#
#-----[ FIND ]------------------------------------------
#
$allowsmilies = $this_userdata['user_allowsmile'];
#
#-----[ AFTER, ADD ]------------------------------------------
#
$showavatars = $this_userdata['user_showavatars'];
$showsigatures = $this_userdata['user_showsignatures'];

see, it says "showsigatures" not "showsigNatures.

to fix this, goto admin_users.php
search for "$showsigatures"
and instert the missing "n"
;)

sanyacid - brain-hack.org


Just reiterating this, it took me a while to hunt this thread back down and read through the posts. Props to you for your good eye!! 8O
Heinle
Registered User
Posts: 7
Joined: Tue Apr 13, 2004 2:56 am
Contact:

Post by Heinle »

I also got a problem with this mod : (
Didn't find and answer to this on the last pages.
I hope you can help me, thanks in advance :)

This error message occurs after setting either avatars or signatures to 'yes' in profil:

edit: Hm maybe the pic was too big, isn't showing up anymore, i'll write the error down then.

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_showavatars' in 'field list'

UPDATE users SET user_email = '[email protected]', user_icq = '132416654', user_website = '', user_occ = 'Pupil', user_from = 'Germany/Munich', user_interests = 'playing basketball, snowboarding, online games, going out with friends and of course laughing : )', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_showavatars = 1, user_showsignatures = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = 4, user_active = 1, user_actkey = '' WHERE user_id = 6

Line : 463
File : /var/www/html/phpbb/includes/usercp_register.php
Post Reply

Return to “[2.0.x] MOD Database Cleanup”