WOI been working on Mysql
<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/shengui?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBi tIsBoolean=true" username="root" password="root"/>
PHP an example of account registration
<title> Registration| WOI</title>
<head>
<meta http-equiv="content-type" content="text/html"; charset="UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<center>
<form id="register" action="?do=register" method=post>
<br><h3> </h3><br>
<center>Registration on the server
Login:<br>
<input class="input_box" type=text name=login><br>
1:<br>
<input class="input_box" type=password name=passwd><br>
1:<br>
<input class="input_box" type=password name=repasswd><br>
E-Mail:<br>
<input class="input_box" type=text name=email><br>
<input class="input_submit" type=submit name=submit value="Registration "><br>
</table>
</form>
<?php
$config = array
(
'host' => 'localhost', // Host
'user' => 'root', //
'pass' => 'root', // pass
'name' => 'shengui', // name db
'gold' => '999', // zen
);
if (isset($_POST['login']))
{
$link = mysql_connect($config['host'], $config['user'], $config['pass']) or die ("1");
mysql_select_db($config['name'], $link) or die ("1 ".$DBName." 1o_O");
$Login = $_POST['login'];
$Pass = $_POST['passwd'];
$Repass = $_POST['repasswd'];
$Email = $_POST['email'];
$Login = StrToLower(Trim($Login));
$Pass = StrToLower(Trim($Pass));
$Repass = StrToLower(Trim($Repass));
$Email = Trim($Email);
if (empty($Login) || empty($Pass) || empty($Repass) || empty($Email))
{
echo "Please Don't Leave Blank Field";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Login, $Txt))
{
echo "Not valid login";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Pass, $Txt))
{
echo ""; "Not valid password"
}
elseif (ereg("[^0-9a-zA-Z_-]", $Repass, $Txt))
{
echo "Not the right format repeat password";
}
elseif (StrPos('\'', $Email))
{
echo "Not the right format E-Mail";
}
elseif ((StrLen($Login) < 4) or (StrLen($Login) > 10))
{
echo ".";
}
else
{
$Result = MySQL_Query("SELECT name FROM users WHERE name='$Login'") or ("Can't execute query.");
if (MySQL_Num_Rows($Result))
{
echo "<font color='red'>1</font> <b>".$Login."</b> <font color='red'>уже есть в базе -_-</font>";
}
elseif ((StrLen($Pass) < 4) or (StrLen($Pass) > 10))
{
echo ".";
}
elseif ((StrLen($Repass) < 4) or (StrLen($Repass) > 10))
{
echo "1";
}
elseif ((StrLen($Email) < 4) or (StrLen($Email) > 25))
{
echo "1";
}
else
{
$Result = MySQL_Query("SELECT name FROM users WHERE name='$Email'") or ("Can't execute query.");
if (MySQL_Num_Rows($Result))
{
echo "<font color='red'>E-Mail</font> <b>".$Email."</b> <font color='red'>already have in the database -_-</font>";
}
elseif ($Pass != $Repass)
{
echo "1";
}
else
{
$Salt = $Login.$Pass;
$Salt = md5($Salt);
$Salt = "0x".$Salt;
MySQL_Query("call adduser('$Login', $Salt, '0', '0', '0', '0', '$Email', '0', '0', '0', '0', '0', '0', '0', '', '', $Salt)") or die ("Can't execute query.");
$mysqlresult=MySQL_Query("select * from `users` WHERE `name`='$Login'");
$User_ID=MySQL_result($mysqlresult,0,'ID');
MySQL_Query("call usecash({$User_ID},904,0,9,0,".$config['gold'].",1,@error)") or die ("1");
echo "<font color='green'>Аккаунт <b>".$Login."</b> Successfully registered :) 1 ID: ".$User_ID." <br/> ".$config['gold']." ";Golda accrued. Gold will come within 5-10 minutes
}
}
echo $Data;
php?>
request for GM
call addGM (ID, 904)