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

Diff of /fenglin/bbs/update_profile_service.php

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

Revision 1.6 by sysadm, Thu Apr 10 07:54:36 2025 UTC Revision 1.7 by sysadm, Wed Apr 16 01:51:52 2025 UTC
# Line 135  Line 135 
135                  exit(json_encode($result_set));                  exit(json_encode($result_set));
136          }          }
137    
138          $sql = "SELECT nickname, email FROM user_pubinfo WHERE UID = " . $_SESSION["BBS_uid"];          $sql = "SELECT nickname, email FROM user_pubinfo WHERE UID = " . $_SESSION["BBS_uid"] .
139                            " FOR UPDATE";
140    
141          $rs = mysqli_query($db_conn, $sql);          $rs = mysqli_query($db_conn, $sql);
142          if ($rs == false)          if ($rs == false)
# Line 266  Line 267 
267          // Update email          // Update email
268          if ($old_email != $email)          if ($old_email != $email)
269          {          {
270                  $sql = "SELECT UID FROM user_pubinfo WHERE email = '$email'";                  $sql = "SELECT UID FROM user_pubinfo WHERE email = '$email' FOR SHARE";
271    
272                  $rs = mysqli_query($db_conn, $sql);                  $rs = mysqli_query($db_conn, $sql);
273                  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