/[LeafOK_CVS]/fenglin/bbs/reg_user_service.php
ViewVC logotype

Diff of /fenglin/bbs/reg_user_service.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.5 by sysadm, Thu Apr 10 10:22:44 2025 UTC Revision 1.6 by sysadm, Wed Apr 16 01:51:52 2025 UTC
# Line 171  Line 171 
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)
# Line 193  Line 193 
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)
# Line 215  Line 215 
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)

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1