1.6
Pali Cannon Database Studio PCD Studio

: 64
:
:
: 64
: 128
>
"; echo "Login"; ?> "; } if(empty($password)){ echo "Error:Password Is Empty!
"; } if(!empty($username) && !empty($password)){ $md5_password=md5($password); $db_file = $_file_db_userinfo; PDO_Connect("sqlite:$db_file"); $query = "select * from user where \"username\"=".$PDO->quote($username)." and \"password\"=".$PDO->quote($md5_password); $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){//username is exite $uid=$Fetch[0]["id"]; $username=$Fetch[0]["username"]; $userid=$Fetch[0]["userid"]; $nickname=$Fetch[0]["nickname"]; $email=$Fetch[0]["email"]; ?> "; } echo "Ok
"; echo "Enter"; ?> "; echo "Try Again"; } } else{ echo "Try Again"; } break; case "new": $username=$_POST["username"]; $password=$_POST["password"]; $nickname=$_POST["nickname"]; $email=$_POST["email"]; if(empty($username)){ echo "Error:User Name Is Empty!
"; } if(empty($password)){ echo "Error:Password Is Empty!
"; } if(empty($nickname)){ echo "Error:Nickname Is Empty!
"; } if(!empty($username) && !empty($password) && !empty($nickname)){ $md5_password=md5($password); $userid=GUIDv4(); $db_file = $dir_db_userinfo.$file_db_userinfo; PDO_Connect("sqlite:$db_file"); $query = "select * from user where \"username\"=".$PDO->quote($username); $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){//username is exite echo "user name is exite
"; echo "Try Again"; } else{ $query="INSERT INTO user ('id','userid','username','password','nickname','email') VALUES (NULL,".$PDO->quote($userid).",".$PDO->quote($username).",".$PDO->quote($md5_password).",".$PDO->quote($nickname).",".$PDO->quote($email).")"; $stmt = @PDO_Execute($query); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); print_r($error[2]); echo "Try Again"; break; } $newUserPath=$dir_user_base.$userid; $userDirApp=$newUserPath.$dir_myApp; $userDirDict=$newUserPath.$dir_dict_user; $userDirMyDocument=$newUserPath.$dir_mydocument; $userDirMyPaliCanon=$newUserPath.$dir_myPaliCannon; if(!file_exists($newUserPath)){ if(mkdir($newUserPath)){ mkdir($userDirApp); mkdir($userDirDict); mkdir($userDirMyDocument); //copy($dir_user_templet.$dir_myApp."/config.js",$userDirApp."/config.js"); //copy($dir_user_templet.$dir_myApp."/dictlist.json",$userDirApp."/dictlist.json"); //copy($dir_user_templet.$dir_myApp."/style.css",$userDirApp."/style.css"); //copy($dir_user_templet.$dir_myApp."/userinfo.js",$userDirApp."/userinfo.js"); //copy($dir_user_templet.$dir_myApp."/userinfo.php",$userDirApp."/userinfo.php"); //copy($dir_user_templet.$dir_dict_user."/wbw.db",$userDirDict."/wbw.db"); //copy($dir_user_templet.$dir_dict_user."/default.db",$userDirDict."/default.db"); } else{ echo "create dir fail
"; } } echo "Create Succecful
"; echo "User Name:$username
"; echo "Nickname:$nickname
"; echo "Email:$email
"; echo "Login"; } } else{ echo "Try Again"; } break; } } else{ ?>
: 64
:
>