<?php
session_start();
$mssql_host = "127.0.0.1,1433";
$mssql_user = "c9";
$mssql_pass = "Tlskdls";
$mssql_db = "C9Unity";
$ip = $_SERVER['REMOTE_ADDR'];
function cl($text)
{
$a = str_replace("'","/",$text);
return $a;
}
function popup($text)
{
echo "<script>alert('".$text."');</script>";
}
include_once $_SERVER['DOCUMENT_ROOT'] . '/securimage/securimage.php';
$securimage = new Securimage();
mssql_connect($mssql_host,$mssql_user,$mssql_pass) or die("Cannot connect to SQL Server");
mssql_select_db($mssql_db) or die("Cannot selected database.");
if($_POST['submit'])
{
// Check User
$chk_user = mssql_query("SELECT cAccId FROM Auth.TblAccount WHERE cAccId = '".cl($_POST['account'])."'");
$chk = mssql_fetch_array($chk_user);
if(trim($_POST['account']) == "" || $_POST['password'] == "" || $_POST['repass'] == "" || $_POST['captcha_code'] == "")
{
popup("Please fill all field.");
}
else if(trim($_POST['account']) == $chk['cAccId'])
{
popup("Account name is already used.");
}
else if($_POST['password'] != $_POST['repass'])
{
popup("Password is not match");
}
else if ($securimage->check($_POST['captcha_code']) == false)
{
popup("Security code wrong.");
}
else
{
$username = cl($_POST['account']);
$password = cl($_POST['repass']);
$auth = (int)1;
$stmt = mssql_init('Admin.UspAddAccount');
mssql_bind($stmt, '@pAccId', $username, SQLVARCHAR, false, false, 32);
mssql_bind($stmt, '@pPassword', $password, SQLVARCHAR, false, false, 32);
mssql_bind($stmt, '@pAuthLevel', $auth, SQLVARCHAR, false, false, 32);
mssql_bind($stmt, '@pIpAddr', $ip, SQLVARCHAR, false, false, 32);
mssql_execute($stmt) or die ("<strong>Error occurred while executing the statement.</strong>");
mssql_free_statement($stmt);
popup("Welcome ".$username.". Enjoy the game.");
}
}
?>
<form name="register" method="post" action="">
<table width="500" align="center">
<tr>
<td align="right">Account Name :</td>
<td><label for="account"></label>
<input type="text" name="account" id="account" autocomplete="off"></td>
</tr>
<tr>
<td align="right">Password :</td>
<td><label for="password"></label>
<input type="password" name="password" id="password"></td>
</tr>
<tr>
<td align="right">Re-Password :</td>
<td><label for="repass"></label>
<input type="password" name="repass" id="repass"></td>
</tr>
<tr>
<td align="right" valign="top">Security :</td>
<td><img src="/securimage/securimage_show.php" alt="CAPTCHA Image" width="148" height="49" id="captcha" /><br><input type="text" name="captcha_code" autocomplete="off" size="10" maxlength="6" />
<a href="#" onclick="document.getElementById('captcha').src = '/securimage/securimage_show.php?' + Math.random(); return false">[ Different Image ]</a></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" id="submit" value="Register"></td>
</tr>
</table>
</form>