verifyTicket(); $whereSql = ''; $bindVars = [ $gBitSystem->getConfig('users_validate_email_role') ]; if( !empty( $_REQUEST['start_user_id'] ) ) { $whereSql = " AND user_id>?"; $bindVars[] = $_REQUEST['start_user_id']; } $selectSql = "SELECT uu.user_id,uu.email FROM users_users uu WHERE user_id NOT IN (SELECT user_id FROM users_roles_map WHERE role_id = ?) $whereSql ORDER BY uu.user_id"; $users = $gBitDb->getAssoc($selectSql, $bindVars ); $errors; foreach ( $users as $id=>$email ){ print date( "Y-m-d H:i:s" )." Verifying $email ( $id ) .... "; flush(); $emailStatus = $gBitUser->verifyMx($email,$errors); if( $emailStatus === true){ $gBitUser->addUserToRole( $id , $gBitSystem->getConfig('users_validate_email_role') ); print "valid"; } elseif( $emailStatus === -1 ) { print "MX connection failed"; } else { print " --INVALID-- "; } print "
\n"; flush(); }