$email = $mysqli->real_escape_string($_POST['ufemail']); $getEmail = $mysqli->prepare('SELECT people_name FROM people WHERE people_email=?') or die('Couldn\'t check the email'); $getEmail->bind_param('s', $email); $getEmail->execute(); $getEmail->store_result(); $countRows = $getEmail->num_rows; if ($countRows == 1) { $getEmail->bind_result($name_user); while ($getEmail->fetch()) { $usr = $name_user; } $token = md5(uniqid(mt_rand(), true) . $usr); // generate token $insert_row = $mysqli->query('UPDATE people SET people_forget_key="' . $token . '" WHERE people_email="' . $email . '";') or die($mysqli->error . __LINE__); // store token // sending email $message = '<p> Hi ' . $usr . ', <br><br> You requested a password change , please click on the link below or paste it onto your address bar. <br><br><center><a href="' . S_PATH . 'reset.php?token=' . $token . '">' . S_PATH . 'reset.php?token=' . $token . '</a> <br><br><br><br> <a href="' . S_PATH . 'reset.php?token=' . $token . '" style="text-align:center;text-decoration:none; padding:10px;font-size:1.2em; color:#FFF; background: linear-gradient(#830C0C, #830C0C) repeat scroll 0% 0% #1B5898; box-shadow: 0px -2px 0px rgba(0, 0, 0, 0.5) inset, 0px 2px 0px rgba(0, 0, 0, 0.1);">Click here to reset your password </a></center> <br><br>If this was not you, please notify us, by clicking <a href="' . S_PATH . 'reset.php?token=' . substr($token, -1) . substr($token, 0, -1) . '">here</a>.'; $mail_flag = stuch_mail($email, 'Reset Password Request - STUCH Web-Console (no-reply)', $message); } echo $mail_flag;
$send['people_dp'] = 'img/profiles/' . $link; $re = do_sql('people', $send, 'insert', $mysqli, $where); $mail_flag = stuch_mail($send['people_email'], 'You have been registered at STUCHx', $msg); if ($re == 'Duplicate Entry') { header('Location:users.php?error=dup'); } else { header('Location:users.php?done=1'); } } else { header('Location:users.php?error=img'); } } else { if ($_POST['uname'] != "" && $_POST['urefno'] != "" && $_POST['uemail'] != "" && $_POST['external'] == 'true') { $send['people_addedBy'] = '-1'; $re = do_sql('people', $send, 'insert', $mysqli, $where); $mail_flag = stuch_mail($send['people_email'], 'You have been registered at STUCHx', $msg); // Position $send['position_name'] = 'Contributor'; $send['position_code'] = 'OTH'; $send['position_people_id'] = $re; $send['position_addedBy'] = '-1'; echo do_sql('position', $send, 'insert', $mysqli); if ($re == 'Duplicate Entry') { header('Location:login.php?alert=dup'); } else { header('Location:login.php?alert=reg'); } } else { echo '<script>alert("There was an error.Retry.");window.location.assign("' . S_PATH . 'users.php");</script>'; exit; }