- Joined
- Feb 26, 2010
- Messages
- 62
- Reaction score
- 17
I modified my original registration script to have the ability to use in game cashshop as it adds the information into the billcruxrf database (tbl.user and tbl.userinfo). Atm its set to add 5000 in game cash shop points, just change the value to what you want.
You need to add a column to RF_USER dbo.tbl_LUAccount (left click on Column and then click add column) and call it Email and set value= varchar(255)
copy and paste the registration script into notepad and save it as register.php (has to be put on your serverbox in the www folder)
<--- Registration Script --->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
<?php error_reporting (E_ALL ^ E_NOTICE);
//MSSQL settings
$db_user = 'MSSQL USER NAME'; // SQL ID
$db_pass = 'MSSQL PASSWORD!'; // SQL PASSWORD (change it to your password mssql)
$db_base = "RF_USER"; // SQL BASE name (don't change it's by default)
$db_base2 = "BillcruxRF"; // SQL BASE name (don't change it's by default)
$db_host = "YOUR IP HERE"; // SQL HOST (change it to your IP ex : 127.0.0.1)
$reg_open = true;
$tabelka = '<form action=register.php method=post><body margin="center" scroll="no" bgcolor="#1A1A1A" text="#FFFFFF">
<table width="305" border="0" align="center">
<tr>
<td width="277"><span class="Style4">Username: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=text name=login value="'.$_POST['login'].'"></td>
</tr>
<tr>
<td><span class="Style4">Password: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=password name=pass></td>
</tr>
<tr>
<td><span class="Style4">Repeat Password: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=password name=cpass></td>
</tr>
<tr>
<td><span class="Style4">E-mail:</span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=text name=mail value="'.$_POST['mail'].'"></td>
</tr>
<tr>
<td height="41" valign="top">
<div align="left">
<INPUT type="submit" value="Register Now">
</div></td>
</tr>
</table>
<br><br><br><br><br><br>
<font color ="#FFFFFF"><center>
Account Creation script adapted by Merritt.
<font color ="#FFFFFF"></center>
<br>
</form>';
if($reg_open AND isset($_POST['login']))
{
$connectsql=mssql_connect($db_host, $db_user, $db_pass) or die('<center><b>'.$lang_error_cant_connect1.'</b><br>'.$lang_error_cant_connect2.'<br><br><a href="register.php">Back</a></center>');
$connectsql=mssql_connect($db_host, $db_user2, $db_pass) or die('<center><b>'.$lang_error_cant_connect1.'</b><br>'.$lang_error_cant_connect2.'<br><br><a href="register.php">Back</a></center>');
$login = $_POST['login'];
$pw = $_POST['pass'];
$cpw = $_POST['cpass'];
$email = $_POST['mail'];
$login = trim($login);
$pw = trim($pw);
$cpw = trim($cpw);
if(ereg("[^0-9a-zA-Z_-]", $login, $str))
{
echo '<body><center>Illegal characters, Username must only contain a-z, A-Z è 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif(ereg("[^0-9a-zA-Z_-]", $pw, $str))
{
echo '<body><center>Illegal Characters, Password must only contain a-z, A-Z è 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif (empty($login) || empty($email) || empty($pw) || empty($cpw))
{
echo '<body><center>One or more fields are empty<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strpos($email,'\''))
{
echo '<body><center>E-mail '.$email.' is not a valid email adress.<br><br><a href="register.php">Back</a></center></body>';
}
else
{
$login_test = strtolower($login);
$resultx = mssql_query('SELECT * FROM rf_user.dbo.tbl_LUAccount WHERE id = CONVERT(binary,\''.$login.'\')') or die("Query failed '.$resultx.'");
//$resultx = mssql_query('SELECT * FROM tbl_RFTestAccount WHERE id = 'akademon'')
if ((mssql_num_rows($resultx)) > 0)
{
echo '<body><center>The Username "<b>'.$login.'</b>" is already in use. Please pick-up another user name.<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) < 4)
{
echo '<body><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) < 4)
{
echo '<body><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) > 10)
{
echo '<body><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) > 10)
{
echo '<body><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif ($pw != $cpw)
{
echo '<body><center>The passwords do not match<br><br><a href="register.php">Back</a></center></body>';
}
else
{
mssql_query("INSERT INTO RF_User.dbo.tbl_LUAccount (id,password,BCodeTU,Email) VALUES ((CONVERT(binary, '$login')), (CONVERT(binary, '$pw')),'1', '$email');");
mssql_query("INSERT INTO BillCruxRF.dbo.tblUser (userId,userPwd,gameServiceId) VALUES ('$login','$pw',6)");
$query = mssql_query("SELECT userNumber FROM BillCruxRF.dbo.tblUser WHERE userId='$login'");
$query = mssql_fetch_array($query);
$usernum = $query['userNumber'];
mssql_query("INSERT INTO BillCruxRF.dbo.tblUserInfo (userNumber,userId,userPwd,gameServiceId,email,cashBalance) VALUES ('$usernum','$login','$pw',6,'$email','5000')") or die('<center>Registration failed.<br><br><a href=register.php>Back</a></center>');
echo '<body bgcolor="#1A1A1A" text="#FFFFFF"> <center>Your account was successfully created.<br><br><a href="index.html">Back</a></center></body>';
}
}
}
elseif($reg_open)
{
echo $tabelka;
}
else
{
echo '<center>Registration is currently closed. Please try again later<br></center>';
}
?>
Now copy and paste the Index.html into notepad and save as index.html
(has to be put on your serverbox in the www folder)
<--- Index.html --->
<html>
<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.YOUR SITE HERE.com/">
</html>
You need to add a column to RF_USER dbo.tbl_LUAccount (left click on Column and then click add column) and call it Email and set value= varchar(255)
copy and paste the registration script into notepad and save it as register.php (has to be put on your serverbox in the www folder)
<--- Registration Script --->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
<?php error_reporting (E_ALL ^ E_NOTICE);
//MSSQL settings
$db_user = 'MSSQL USER NAME'; // SQL ID
$db_pass = 'MSSQL PASSWORD!'; // SQL PASSWORD (change it to your password mssql)
$db_base = "RF_USER"; // SQL BASE name (don't change it's by default)
$db_base2 = "BillcruxRF"; // SQL BASE name (don't change it's by default)
$db_host = "YOUR IP HERE"; // SQL HOST (change it to your IP ex : 127.0.0.1)
$reg_open = true;
$tabelka = '<form action=register.php method=post><body margin="center" scroll="no" bgcolor="#1A1A1A" text="#FFFFFF">
<table width="305" border="0" align="center">
<tr>
<td width="277"><span class="Style4">Username: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=text name=login value="'.$_POST['login'].'"></td>
</tr>
<tr>
<td><span class="Style4">Password: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=password name=pass></td>
</tr>
<tr>
<td><span class="Style4">Repeat Password: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=password name=cpass></td>
</tr>
<tr>
<td><span class="Style4">E-mail:</span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=text name=mail value="'.$_POST['mail'].'"></td>
</tr>
<tr>
<td height="41" valign="top">
<div align="left">
<INPUT type="submit" value="Register Now">
</div></td>
</tr>
</table>
<br><br><br><br><br><br>
<font color ="#FFFFFF"><center>
Account Creation script adapted by Merritt.
<font color ="#FFFFFF"></center>
<br>
</form>';
if($reg_open AND isset($_POST['login']))
{
$connectsql=mssql_connect($db_host, $db_user, $db_pass) or die('<center><b>'.$lang_error_cant_connect1.'</b><br>'.$lang_error_cant_connect2.'<br><br><a href="register.php">Back</a></center>');
$connectsql=mssql_connect($db_host, $db_user2, $db_pass) or die('<center><b>'.$lang_error_cant_connect1.'</b><br>'.$lang_error_cant_connect2.'<br><br><a href="register.php">Back</a></center>');
$login = $_POST['login'];
$pw = $_POST['pass'];
$cpw = $_POST['cpass'];
$email = $_POST['mail'];
$login = trim($login);
$pw = trim($pw);
$cpw = trim($cpw);
if(ereg("[^0-9a-zA-Z_-]", $login, $str))
{
echo '<body><center>Illegal characters, Username must only contain a-z, A-Z è 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif(ereg("[^0-9a-zA-Z_-]", $pw, $str))
{
echo '<body><center>Illegal Characters, Password must only contain a-z, A-Z è 0-9';
echo '<br><br><a href="register.php">Back</a></center></body>';
}
elseif (empty($login) || empty($email) || empty($pw) || empty($cpw))
{
echo '<body><center>One or more fields are empty<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strpos($email,'\''))
{
echo '<body><center>E-mail '.$email.' is not a valid email adress.<br><br><a href="register.php">Back</a></center></body>';
}
else
{
$login_test = strtolower($login);
$resultx = mssql_query('SELECT * FROM rf_user.dbo.tbl_LUAccount WHERE id = CONVERT(binary,\''.$login.'\')') or die("Query failed '.$resultx.'");
//$resultx = mssql_query('SELECT * FROM tbl_RFTestAccount WHERE id = 'akademon'')
if ((mssql_num_rows($resultx)) > 0)
{
echo '<body><center>The Username "<b>'.$login.'</b>" is already in use. Please pick-up another user name.<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) < 4)
{
echo '<body><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) < 4)
{
echo '<body><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) > 10)
{
echo '<body><center>Password must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) > 10)
{
echo '<body><center>Username must contain 4-10 characters<br><br><a href="register.php">Back</a></center></body>';
}
elseif ($pw != $cpw)
{
echo '<body><center>The passwords do not match<br><br><a href="register.php">Back</a></center></body>';
}
else
{
mssql_query("INSERT INTO RF_User.dbo.tbl_LUAccount (id,password,BCodeTU,Email) VALUES ((CONVERT(binary, '$login')), (CONVERT(binary, '$pw')),'1', '$email');");
mssql_query("INSERT INTO BillCruxRF.dbo.tblUser (userId,userPwd,gameServiceId) VALUES ('$login','$pw',6)");
$query = mssql_query("SELECT userNumber FROM BillCruxRF.dbo.tblUser WHERE userId='$login'");
$query = mssql_fetch_array($query);
$usernum = $query['userNumber'];
mssql_query("INSERT INTO BillCruxRF.dbo.tblUserInfo (userNumber,userId,userPwd,gameServiceId,email,cashBalance) VALUES ('$usernum','$login','$pw',6,'$email','5000')") or die('<center>Registration failed.<br><br><a href=register.php>Back</a></center>');
echo '<body bgcolor="#1A1A1A" text="#FFFFFF"> <center>Your account was successfully created.<br><br><a href="index.html">Back</a></center></body>';
}
}
}
elseif($reg_open)
{
echo $tabelka;
}
else
{
echo '<center>Registration is currently closed. Please try again later<br></center>';
}
?>
Now copy and paste the Index.html into notepad and save as index.html
(has to be put on your serverbox in the www folder)
<--- Index.html --->
<html>
<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.YOUR SITE HERE.com/">
</html>