Share L2J Acis Register/password Change Scripts Php

[wongerlt]

Me created scripts for web.

 

Register script nude:

<?php
$error = "";
if(isset($_POST['register'])) {
$conn = new mysqli("server_host", "db_user_name", "db_user_password", "db_database");
$id = mysqli_real_escape_string($conn, $_POST['id']);
$password = base64_encode(sha1($_POST['password'], true));
if($_POST['password']!=$_POST['rpassword']){
$error .= "Password does not match the repeat password.<br>"; 
}
if(mb_strlen($id)<4){
$error .= "User ID must be more than 3 symbol.<br>";
}
$sql = "SELECT `login` FROM `accounts` WHERE `login`='".$id."'";
$result = $conn->query($sql);
if ($result->num_rows!=0) {
$error .= "User ID already exist. Please chose other User ID.<br>";	
}
if(empty($error)){
$sql = "INSERT INTO `accounts` VALUES('".$id."','".$password."','0','0','1','','".date("Y-m-d H:i:s")."')";
$result = $conn->query($sql);
$error = "Account created, now you can login!!!!";
}
}
echo '<form id="register" method="post" action="#">';
echo (!empty($error)?"<label><strong>".$error."</strong></label>":'');
echo '<label for="userid">User ID</label>
<input id="userid" name="id" type="text">
<label for="userpass">Password</label>
<input id="userpass" name="password" type="password">
<label for="userpassr">Repeat password</label>
<input id="userpassr" name="rpassword" type="password">
<input id="submit" name="register" type="submit" value="Register">
</form>';
?>

Change password script nude:

<?php
$error = "";
if(isset($_POST['changepass'])) {
$conn = new mysqli("server_host", "db_user_name", "db_user_password", "db_database");
$id = mysqli_real_escape_string($conn, $_POST['id']);
$password = base64_encode(sha1($_POST['password'], true));
$newp = $_POST['newp'];
$renewp = $_POST['renewp'];
$pass = base64_encode(sha1($_POST['newp'], true));
$sql = "SELECT `login` FROM `accounts`,`characters` WHERE accounts.login='".$id."' AND accounts.password='".$password."' AND characters.account_name='".$id."' AND characters.online=0";
$result = $conn->query($sql);
if ($result->num_rows==0) {
$error .= "User ID or Password is wrong or you are online in game, please check and try again.";
}
if($newp!=$renewp){
$error .= "New password does not match the confirm password, please check and try again.";
}
if(empty($error)) {
mysqli_query($conn,"UPDATE `accounts` SET `password`='".$pass."' WHERE `login`='".$id."'");
$error = "Password changed.";
}
}
echo '<form id="change-password" method="post" action="#">';
echo (!empty($error)?"<label><strong>".$error."</strong></label>":'');
echo '<label for="cpw">User ID</label>
<input id="userid" name="id" type="text">
<label for="userpass">Current password</label>
<input id="userpass" name="password" type="password">
<label for="newpass">New password</label>
<input id="newpass" name="newp" type="password">
<label for="newpassr">Confirm new password</label>
<input id="newpassr" name="renewp" type="password">
<input id="submit" name="changepass" type="submit" value="Change Password">
</div>
</form>';
?>

Edited April 20, 2016 by wongerlt