im working on the code. i believe its done but am going to setup a test website in a closed environment on backup server to test if it works.
You will need to setup a website either locally on your server where you can access it (do NOT enable the internet to access it)
I might make a tutorial, but just in case I dont, start reading and learning. You will need to install xampp without mariadb, and enable php for windows mssql server. once that is done, come back here and I should have some code for you
does anyone have any tips?PHP CODE try nr.1: Do not Work!
<?php
$serverName = "DESKTOP-4TAN2UH\SQLEXPRESS";
$connectionInfo = array( "Database"=>"ROM_Account" ),
"UID"=>"romuser",
"PWD" => "Password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
if(isset($_GET['action']))
{
if($_GET['action'] == 'add')
{
/*Insert data.*/
$insertSql = "INSERT INTO [ROM_Account].[dbo].[PlayerAccount]
([Account_ID],[Password],[IsMd5Password],[IsAutoConvertMd5])
VALUES
('accountname','password',0,1)
GO";
$params = array(&$_POST['username'],
&$_POST['pass']);
$stmt = sqlsrv_query($conn, $insertSql, $params);
}
}
?><?php
$serverName = "DESKTOP-4TAN2UH\SQLEXPRESS";
$connectionInfo = array( "Database"=>"ROM_Account", "UID"=>"romuser", "PWD"=>"Password" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
if(isset($_GET['action']))
{
if($_GET['action'] == 'add')
{
/*Insert data.*/
$insertSql = "INSERT INTO Playeraccount (Accountname, Password)
VALUES (?,?)";
$params = array(&$_POST['Accountname'],
&$_POST['Password']);
$stmt = sqlsrv_query($conn, $insertSql, $params);
if($stmt === false)
{
/*Handle the case of a duplicte Accountname.*/
$errors = sqlsrv_errors();
if($errors[0]['code'] == 2601)
{
echo "The Accountname you entered has already been used.</br>";
}
/*Die if other errors occurred.*/
else
{
die(print_r($errors, true));
}
}
else
{
echo "Registration complete.</br>";
}
}
}
?><?php
$connection_string = 'DRIVER={SQL Server};SERVER=localhost;DATABASE=ROM_Account';
$user = 'romuser';
$pass = 'romuser';
$conn = odbc_connect( $connection_string, $user, $pass );
if(isset($_POST['username']))
{ $username = $_POST['username'];
}
if(isset($_POST['username']))
{ $passwd = md5($_POST['password']);
}
/*Insert data.*/
$insertSql = "INSERT INTO [ROM_Account].[dbo].[PlayerAccount] ([Account_ID],[Password],[IsMd5Password],[IsAutoConvertMd5])
VALUES ('".$username."','".$passwd."','True','True')";
$stmt = odbc_do($conn, $insertSql);
if($stmt === false) { echo "The Accountname you entered has already been used.</br>"; } else {
echo "Registration complete.</br>";
}
?><!DOCTYPE HTML>
<html>
<link rel="stylesheet" type="text/css" href="css/style.css">
<head>
<title>Example</title>
</head><body id="body-style">
<div id="Register">
<fieldset style="width:30%">
<legend>Account Creation</legend>
<form method="POST" action="register.php">
<table border="0">
<tr><td>Accoutname</td><td>
<input type="text" name="username" required></td>
</tr>
<tr><td><label for="pass">Password (8 characters minimum):</label></td><td>
<input type="password" name="password" id="pass" minlength="12" required></td></tr>
<tr><td><input id="button" type="submit" name="submit" value="Register"></td></tr></table>
</form>
</fieldset>
</div>
</html>/*CSS for REGISTER.HTML*/
#body-style{background-color:#00bddd;
/*background-image:url('bg.png');*/
}
#Register{background-image:url('default.png');
background-size:500px 500px;
background-repeat:no-repeat;
background-attachment:fixed;
background-position:center;
margin-top:150px;
margin-bottom:150px;
margin-right:150px;
margin-left:450px;
padding:9px 35px;
}
#button{border-radius:5px;width:100px;
height:40px;background:#ffffff
/*background-image:url('bg.png');*/
font-weight:bold;font-size:20px;
}