| 21 |
header("Content-Type:application/json; charset=utf-8"); |
header("Content-Type:application/json; charset=utf-8"); |
| 22 |
|
|
| 23 |
// Validate input data |
// Validate input data |
| 24 |
if (!preg_match("/^[A-Za-z][A-Za-z0-9]{4,11}$/", $username)) |
if (!preg_match("/^[A-Za-z][A-Za-z0-9_]{2,11}$/", $username)) |
| 25 |
{ |
{ |
| 26 |
$result_set["return"]["code"] = -1; |
$result_set["return"]["code"] = -1; |
| 27 |
array_push($result_set["return"]["errorFields"], array( |
array_push($result_set["return"]["errorFields"], array( |
| 55 |
mysqli_close($db_conn); |
mysqli_close($db_conn); |
| 56 |
exit(json_encode($result_set)); |
exit(json_encode($result_set)); |
| 57 |
} |
} |
| 58 |
|
|
| 59 |
$rs = mysqli_query($db_conn, "BEGIN"); |
$rs = mysqli_query($db_conn, "BEGIN"); |
| 60 |
if ($rs == false) |
if ($rs == false) |
| 61 |
{ |
{ |
| 66 |
exit(json_encode($result_set)); |
exit(json_encode($result_set)); |
| 67 |
} |
} |
| 68 |
|
|
| 69 |
$sql = "SELECT user_list.UID, username, temp_password, email FROM user_list |
$sql = "SELECT user_list.UID, username, email FROM user_list |
| 70 |
INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID |
INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID |
| 71 |
WHERE user_list.enable AND username = '$username' and email = '$email'"; |
WHERE user_list.enable AND username = '$username' and email = '$email'"; |
| 72 |
|
|
| 84 |
{ |
{ |
| 85 |
$uid = $row["UID"]; |
$uid = $row["UID"]; |
| 86 |
$username = $row["username"]; |
$username = $row["username"]; |
|
$temp_password = $row["temp_password"]; |
|
| 87 |
$email = $row["email"]; |
$email = $row["email"]; |
| 88 |
} |
} |
| 89 |
else |
else |
| 100 |
|
|
| 101 |
mysqli_free_result($rs); |
mysqli_free_result($rs); |
| 102 |
|
|
| 103 |
if ($temp_password == null || $temp_password == "") |
$temp_password = gen_passwd(10); |
|
{ |
|
|
$temp_password = gen_passwd(10); |
|
|
} |
|
| 104 |
|
|
| 105 |
$sql = "UPDATE user_list SET temp_password = '$temp_password' |
$sql = "UPDATE user_list SET temp_password = SHA2('$temp_password', 256) |
| 106 |
WHERE UID = $uid"; |
WHERE UID = $uid"; |
| 107 |
|
|
| 108 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 164 |
|
|
| 165 |
mysqli_close($db_conn); |
mysqli_close($db_conn); |
| 166 |
exit(json_encode($result_set)); |
exit(json_encode($result_set)); |
|
?> |
|