aboutsummaryrefslogtreecommitdiffstats
path: root/admin/mailtousers.php
diff options
context:
space:
mode:
authorrub <rub@piwigo.org>2006-03-08 23:14:53 +0000
committerrub <rub@piwigo.org>2006-03-08 23:14:53 +0000
commitb263f0c996eac52afc222b99fb1e9bcb6b064d65 (patch)
tree2cb3716ad84764801710483ab7538589c177a6a6 /admin/mailtousers.php
parentcba56c06ede13f30483ca587f0c79cb0e4d82aaa (diff)
Step 1 improvement issue 0000301:
o Change status of table #_user_infos o Don't send password to webmaster, guest, generic Next Step: o Functions Check of status o Restricted Access for user generic git-svn-id: http://piwigo.org/svn/trunk@1070 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/mailtousers.php')
-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