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

Diff of /fenglin/bbs/preference_service.php

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

Revision 1.2 by sysadm, Tue Apr 8 01:58:33 2025 UTC Revision 1.3 by sysadm, Tue Apr 8 09:27:26 2025 UTC
# Line 92  Line 92 
92          $sign_2 = mysqli_real_escape_string($db_conn, $sign_2);          $sign_2 = mysqli_real_escape_string($db_conn, $sign_2);
93          $sign_3 = mysqli_real_escape_string($db_conn, $sign_3);          $sign_3 = mysqli_real_escape_string($db_conn, $sign_3);
94    
         // Begin transaction  
         $rs = mysqli_query($db_conn, "SET autocommit=0");  
         if ($rs == false)  
         {  
                 $result_set["return"]["code"] = -2;  
                 $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);  
   
                 mysqli_close($db_conn);  
                 exit(json_encode($result_set));  
         }  
           
         $rs = mysqli_query($db_conn, "BEGIN");  
         if ($rs == false)  
         {  
                 $result_set["return"]["code"] = -2;  
                 $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);  
   
                 mysqli_close($db_conn);  
                 exit(json_encode($result_set));  
         }  
   
95          $sql = "UPDATE user_pubinfo SET user_timezone = '$user_tz', introduction = '$introduction', ".          $sql = "UPDATE user_pubinfo SET user_timezone = '$user_tz', introduction = '$introduction', ".
96                  "photo = $photo, sign_1 = '$sign_1', sign_2 = '$sign_2', sign_3 = '$sign_3'".                  "photo = $photo, sign_1 = '$sign_1', sign_2 = '$sign_2', sign_3 = '$sign_3'".
97                  " WHERE UID=" . $_SESSION["BBS_uid"];                  " WHERE UID=" . $_SESSION["BBS_uid"];
# Line 124  Line 103 
103                  exit();                  exit();
104          }          }
105    
         // Commit transaction  
         $rs = mysqli_query($db_conn, "COMMIT");  
         if ($rs == false)  
         {  
                 $result_set["return"]["code"] = -2;  
                 $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);  
   
                 mysqli_close($db_conn);  
                 exit(json_encode($result_set));  
         }  
   
106          // Update user_tz in session data          // Update user_tz in session data
107          $_SESSION["BBS_user_tz"] = new DateTimeZone($user_tz);          $_SESSION["BBS_user_tz"] = new DateTimeZone($user_tz);
108    

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