Joywork/updateUserPasswords.php
2026-05-22 21:21:54 +03:00

41 lines
1.9 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
if($_SESSION['id'] != 93 && $_SESSION['id'] != 117) { header("location:index.php"); die("Доступ запрещён!");}
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
//SELECT * FROM `users` WHERE `id_manager` != 0 and agent = 1 and is_pwd = 0 ORDER BY `id` DESC
require_once($_SERVER['DOCUMENT_ROOT'] . "/engine/mailer/PHPMailerAutoload.php");
$sql="SELECT id, fio, phone, email FROM users WHERE id = 93";
$rez = mysql_query($sql);
while($user = mysql_fetch_assoc($rez)) {
$pwd = generatePass();
$pwd_enc = md5($pwd . SALT);
echo $user['id']." ".trim($user['last_name'] . ' ' . $user['first_name'] . ' ' . $user['middle_name'])." ".$user['phone']." ".$user['email']." ".$pwd."<br>";
$sql = "UPDATE users SET pwd='$pwd_enc', is_pwd = 1 WHERE id=$user[id]";
mysql_query($sql);
$mail = new PHPMailer();
$mail->From = "robot@joywork.ru";
$mail->FromName = "JoyWork.ru";
$mail->isHTML(true);
$mail->AddCustomHeader('X-Mailru-Msgtype: ' . md5($lg) . ';');
$mail->AddCustomHeader('X-Postmaster-Msgtype: ' . md5($lg) . ';');
$mail->AddCustomHeader('Date: ' . date("D, d M y H:i:s O") . ';');
$mail->CharSet = "utf-8";
$mail->addAddress($user['email']);
$mail->Subject = "Изменение способа авторизации на сайте " . $_SERVER['SERVER_NAME'];
$mail->Body = "Уважаемый пользователь. <br/> С настоящего момента для входа на сайт используйте номер телефона $user[phone] и пароль $pwd. Пароль Вы можете изменить в разделе настройки.";
$mail->AltBody = "Это письмо сгенерировано в формате HTML. Ваш клиент не поддерживает HTML или эта функция выключена.";
$mail->Send();
}