|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
I would like to use PhPmyadmin to change all current users to receive emails form Admin. I would also like to know how to change the default setting for this to yes “I would like to receive emails from the Admin” I have made some changes to my forums that everyone needs to know about and I think this will be the quickest way to get the info out. I’m not the best at Myadmin but I hope I can fig this out with some of your help.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
UPDATE `ubbt_USER_PROFILE` SET `USER_ACCEPT_ADMIN_EMAILS` = 'On'
Note that the above query assumes your db prefix is "ubbt_" I'd also like to state that by changing users who've opted out of mailings from your site, you may run into spam issues with your host... but to each their own.
|
|
|
|
Joined: May 2008
Posts: 753 Likes: 1
Old Hand
|
Old Hand
Joined: May 2008
Posts: 753 Likes: 1 |
I think the better way is to update your site rules and include the update that you want everyone to be aware of, and then check the box that forces everyone to read and accept the new rules the next time they log on.
by changing everyones setting to accept admin email, you may be in violation of some privacy rules.
"No matter where you go, there you are." "If you can't do something smart, Do something right" "There are three kinds of people in the world, those who can count, and those who can't"
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
I think the better way is to update your site rules and include the update that you want everyone to be aware of, and then check the box that forces everyone to read and accept the new rules the next time they log on. Agreed by changing everyones setting to accept admin email, you may be in violation of some privacy rules. Exactly
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
Ok how do I make it a default for new users?
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
I believe the default is set to yes already for v7.5.3 . I may be wrong but ?
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
I set up a new "test" account last night and it came up as no?
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
UPDATE `ubbt_USER_PROFILE` SET `USER_ACCEPT_ADMIN_EMAILS` = 'On'
Note that the above query assumes your db prefix is "ubbt_" I'd also like to state that by changing users who've opted out of mailings from your site, you may run into spam issues with your host... but to each their own. I can't view the code?
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Okay maybe not. I think the default is yes if you enable the field to show for registration submitting. But then the user has the ability to opt out. I believe you need to edit the table USER_PROFILE and set the default field for USER_ACCEPT_ADMIN_EMAILS to on instead of null. I think it is due to this is set from the install/upgrade script and not part of a registration script
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
UPDATE `ubbt_USER_PROFILE` SET `USER_ACCEPT_ADMIN_EMAILS` = 'On'
Note that the above query assumes your db prefix is "ubbt_" I'd also like to state that by changing users who've opted out of mailings from your site, you may run into spam issues with your host... but to each their own. I can't view the code? This could be due to IE8. If you try Firefox it may display better. Or using IE8 select the quote function and see if you can view it without posting.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
OK I have been working with the USER_PROFILE - USER_ACCEPT_ADMIN_EMAILS and have tested about 10 new accounts tonight and not one of them has been created with a yes!! So is the Null set as Null or Not Null? and is the default set as yes, No, 0, or 1??
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Try a default of ON not YES. Make that On
Last edited by Ruben; 09/15/2009 8:40 PM. Reason: Added comment
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
Try a default of ON not YES I just did the on and I got this... Warning: Cannot modify header information - headers already sent by (output started at /home/www/html/phpMyAdmin/header.inc.php:189) in /home/www/html/phpMyAdmin/libraries/common.lib.php on line 1416
Last edited by DougMM; 09/15/2009 8:37 PM.
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Okay try the not null as null and the default as On not ON. and you may need to rebuild from the control panel options.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
Well I guess the default is "no" I just installed a test 7.4.1 and with a test user on that new set up this is what I got...
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Yea like I said before if you elect to show the setting in the registration it will show yes as a default which =on in the table. Try what I suggested last if that don't work open a support ticket.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2008
Posts: 81
journeyman
|
journeyman
Joined: Jan 2008
Posts: 81 |
Yea like I said before if you elect to show the setting in the registration it will show yes as a default which =on in the table. Try what I suggested last if that don't work open a support ticket. Thank you Ruben, that did it..........
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
What I'd do is edit the registration template and change what the default is there to "yes" vs "no" vs mucking in the
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (1 invisible),
875
guests, and
141
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|