| 1 |
<? |
<?php |
| 2 |
require_once "../lib/common.inc.php"; |
require_once "../lib/common.inc.php"; |
| 3 |
require_once "../lib/str_process.inc.php"; |
require_once "../lib/str_process.inc.php"; |
| 4 |
require_once "../lib/vn_gif.inc.php"; |
require_once "../lib/vn_gif.inc.php"; |
| 130 |
)); |
)); |
| 131 |
} |
} |
| 132 |
|
|
| 133 |
if ((!isset($_SESSION["BBS_reg_vn_str"])) || $_SESSION["BBS_reg_vn_str"] == "" || VN_check($_SESSION["BBS_reg_vn_str"], $vn_str) != 0) |
if ((!isset($_SESSION["BBS_vn_str"])) || $_SESSION["BBS_vn_str"] == "" || strcasecmp($_SESSION["BBS_vn_str"], $vn_str) != 0) |
| 134 |
{ |
{ |
| 135 |
$result_set["return"]["code"] = -1; |
$result_set["return"]["code"] = -1; |
| 136 |
array_push($result_set["return"]["errorFields"], array( |
array_push($result_set["return"]["errorFields"], array( |
| 171 |
} |
} |
| 172 |
|
|
| 173 |
// Check availability of username and nickname |
// Check availability of username and nickname |
| 174 |
$sql = "SELECT UID FROM user_list WHERE username = '$username'"; |
$sql = "SELECT UID FROM user_list WHERE username = '$username' FOR UPDATE"; |
| 175 |
|
|
| 176 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 177 |
if ($rs == false) |
if ($rs == false) |
| 193 |
} |
} |
| 194 |
mysqli_free_result($rs); |
mysqli_free_result($rs); |
| 195 |
|
|
| 196 |
$sql = "SELECT UID FROM user_nickname WHERE nickname = '$nickname'"; |
$sql = "SELECT UID FROM user_nickname WHERE nickname = '$nickname' FOR UPDATE"; |
| 197 |
|
|
| 198 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 199 |
if ($rs == false) |
if ($rs == false) |
| 215 |
} |
} |
| 216 |
mysqli_free_result($rs); |
mysqli_free_result($rs); |
| 217 |
|
|
| 218 |
$sql = "SELECT UID FROM user_pubinfo WHERE email = '$email'"; |
$sql = "SELECT UID FROM user_pubinfo WHERE email = '$email' FOR UPDATE"; |
| 219 |
|
|
| 220 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 221 |
if ($rs == false) |
if ($rs == false) |
| 334 |
exit(json_encode($result_set)); |
exit(json_encode($result_set)); |
| 335 |
} |
} |
| 336 |
|
|
| 337 |
$_SESSION["BBS_reg_vn_str"] = ""; |
$_SESSION["BBS_vn_str"] = ""; |
| 338 |
|
|
| 339 |
mysqli_close($db_conn); |
mysqli_close($db_conn); |
| 340 |
exit(json_encode($result_set)); |
exit(json_encode($result_set)); |