aboutsummaryrefslogtreecommitdiffstats
path: root/admin/mailtousers.php
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--admin/mailtousers.php18
1 files changed, 10 insertions, 8 deletions
diff --git a/admin/mailtousers.php b/admin/mailtousers.php
index b1d402580..97cb51048 100644
--- a/admin/mailtousers.php
+++ b/admin/mailtousers.php
@@ -77,16 +77,18 @@ where
*/
function update_data_user_mail_notification()
{
-/* $query = '
-insert into '.USER_MAIL_NOTIFICATION_TABLE.'
- (user_id, enabled)
- (select id, \'false\' from '.USERS_TABLE.'
- where mail_address is not null and id not in (select user_id from '.USER_MAIL_NOTIFICATION_TABLE.'))
-;';
- pwg_query($query);*/
-
global $conf, $page;
+ // Set null mail_address empty
+ $query = '
+update
+ '.USERS_TABLE.'
+set
+ mail_address = null
+where
+ trim(mail_address) = \'\';';
+ pwg_query($query);
+
$query = '
select
id user_id, username, mail_address