Previous Thread
Next Thread
Print Thread
Hop To
#229219 09/14/2009 9:38 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
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.

DougMM #229220 09/14/2009 11:02 PM
Joined: Jun 2006
Posts: 16,071
Likes: 72
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,071
Likes: 72
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
Code
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 am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #229229 09/15/2009 10:41 AM
Joined: May 2008
Posts: 741
Likes: 1
Old Hand
Offline
Old Hand
Joined: May 2008
Posts: 741
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,071
Likes: 72
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,071
Likes: 72
Originally Posted by Bad Frog
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

Originally Posted by Bad Frog
by changing everyones setting to accept admin email, you may be in violation of some privacy rules.
Exactly


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #229251 09/15/2009 6:14 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
Joined: Jan 2008
Posts: 81
Ok how do I make it a default for new users?

DougMM #229252 09/15/2009 7:11 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
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
Ruben #229253 09/15/2009 7:29 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
Joined: Jan 2008
Posts: 81
I set up a new "test" account last night and it came up as no?

Gizmo #229254 09/15/2009 8:00 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
Joined: Jan 2008
Posts: 81
Originally Posted by Gizmo
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
Code
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?

DougMM #229255 09/15/2009 8:11 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
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
DougMM #229256 09/15/2009 8:19 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
Originally Posted by DougMM
Originally Posted by Gizmo
Well, you could use use the "dbtools" section of the CP (CP -> Tools & Info -> Database Tools -> SQL Command -> Query) and execute:
Code
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
Ruben #229257 09/15/2009 8:30 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
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??

[Linked Image from i87.photobucket.com]

DougMM #229258 09/15/2009 8:33 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
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
Ruben #229259 09/15/2009 8:35 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
Joined: Jan 2008
Posts: 81
Originally Posted by Ruben
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.
DougMM #229260 09/15/2009 8:47 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
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
Ruben #229261 09/15/2009 8:51 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
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...

[Linked Image from i87.photobucket.com]

DougMM #229262 09/15/2009 8:56 PM
Joined: Dec 2003
Posts: 6,361
Likes: 52
Online Yawn
Joined: Dec 2003
Posts: 6,361
Likes: 52
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
Ruben #229263 09/15/2009 9:04 PM
Joined: Jan 2008
Posts: 81
D
DougMM Offline OP
journeyman
OP Offline
journeyman
D
Joined: Jan 2008
Posts: 81
Originally Posted by Ruben
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..........

DougMM #229264 09/15/2009 9:14 PM
Joined: Jun 2006
Posts: 16,071
Likes: 72
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,071
Likes: 72
What I'd do is edit the registration template and change what the default is there to "yes" vs "no" vs mucking in the


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Scroll Up Button
by JAISP - 04/28/2021 7:39 AM
[Cannot Replicate] Unapprove Post Bug
by Larry Miller - 04/26/2021 10:07 AM
Just popping in
by Harold - 04/25/2021 9:05 PM
Moving Forum/Category location
by ECNet - 04/25/2021 12:11 PM
7.7.5 become member issue
by Ruben - 04/15/2021 10:06 AM
Who's Online Now
1 members (Ruben), 84 guests, and 55 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5