-
[help] Registration
Hello, i used this registration form:
[php]
<html>
<head>
<title>Serenety Gunz - Registration</title>
<style>
body {
color: #003300;
font-family: Verdana, Arial, Serif;
font-size: 10pt;
}
input {
border: 1px solid #003300;
color: #003300;
background: #DDDDDD;
font-family: Verdana, Arial, Serif;
font-size: 10pt;
}
tr {
font-size: 10pt;
}
a:link {
text-decoration: none;
color: #003300;
}
a:visited {
text-decoration: none;
color: #003300;
}
a:active {
text-decoration: none;
color: #003300;
}
a:hover {
text-decoration: none;
color: #FF6600;
}
</style>
</head>
<body>
<div align="center">
<?php
$srvip = "serenetygunz.no-ip.biz";
$srvport = "6000";
$mssql_user = "";
$mssql_pass = "";
$mssql_database = "GunzDB";
$mssql_host = "HOME-KVH92QTYTG\SQLEXPRESS";
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
<FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?act=register">
<table cellspacing=0 border=0>
<tr>
<td colspan=2 style="border: 1px solid #003300; background: #DDDDDD;"><CENTER><A HREF="#">DarkGamers Gunz Registration</A></CENTER></td>
</tr>
<tr>
<td style="border-left: 1px solid #003300"> Login ID:</td>
<td style="border-right: 1px solid #003300"><input type="text" name="login" ></td>
</tr>
<tr>
<td style="border-left: 1px solid #003300"> Password:</td>
<td style="border-right: 1px solid #003300"><INPUT TYPE="password" NAME="senha1"> </td>
</tr>
<tr>
<td style="border-left: 1px solid #003300"> Confirm Password: </td>
<td style="border-right: 1px solid #003300"><INPUT TYPE="password" NAME="senha2"> </td>
</tr>
<tr>
<td style="border-left: 1px solid #003300"> E-mail:</td>
<td style="border-right: 1px solid #003300"><INPUT TYPE="text" NAME="email"> </td>
</tr>
<tr>
<td style="border: 1px solid #003300; border-top: 0px;" colspan=2><CENTER><INPUT NAME="Cadastrar" VALUE="Register!" TYPE="submit"></CENTER></td>
</tr>
</table>
</FORM>
<?php
if ($_GET['act'] == 'register')
{
$user = anti_injection($_POST['login']);
$pass1 = anti_injection($_POST['senha1']);
$pass2 = anti_injection($_POST['senha2']);
$email = anti_injection($_POST['email']);
if (valida(Array($user,$pass1,$pass2,$email)) == true)
{
if ($pass1 == $pass2)
{
if (ereg("([0-9,a-z,A-Z])", $user))
{
if (ereg("^([0-9,a-z,A-Z]+)([.,_]([0-9,a-z,A-Z]+))*[@]([0-9,a-z,A-Z]+)([.,_,-]([0-9,a-z,A-Z]+))*[.]([0-9,a-z,A-Z]){2}([0-9,a-z,A-Z])?$", $email))
{
$query = mssql_query("SELECT * FROM Accounts WHERE UserID='$user'");
$num_rows = mssql_num_rows($query);
if ($num_rows == 0)
{
$query = mssql_query("SELECT * FROM Accounts WHERE E_Mail='$email'");
$num_rows = mssql_num_rows($query);
if ($num_rows == 0)
{
$query = mssql_query("INSERT INTO Accounts (UserID, Password, E_Mail) VALUES ('$user','$pass1','$email')");
if (!$query)
{
echo ":: Error occured! Please try again later. ::<br>";
}
else
{
echo ":: Congratulations! The registration had completed successfully! ::<br>";
}
}
else
{
echo ":: E-mail in use. ::<br>";
}
}
else
{
echo ":: Login ID in use, please try again. ::<br>";
}
}
else
{
echo ":: Invalid E-mail. ::<br>";
}
}
else
{
echo ":: Only use NUMBERS and LETTERS in Login ID! ::<br>";
}
}
else
{
echo ":: The Password you typed DOESN't MATCH! ::<br>";
}
}
}
$query = mssql_query("SELECT * FROM Accounts");
$num_rows = mssql_num_rows($query);
echo "Total Accounts: ".$num_rows."<br>";
echo "<br><B>Serenety Gunz is:</B> ";
$fp = @fsockopen($srvip, $srvport, $errno, $errstr, 1);
if (!$fp) {
echo "<font style='color: #FF3300'><B>Offline</B></font></br>";
} else {
echo "<font style='color: #009933'><B>Online</B></font></br>";
fclose($fp);
}
// Fun
-
Re: [help] Registration
You have hosted it on an external server..
Then its almost impossible to connect to the mssql server on your pc. Only possible when you have mssql server enterprice or workgroup edition.
-
Re: [help] Registration
Rotana, you are wrong
click on your wamp icon > php settings > PhP extensions > tick Mssql
-
Re: [help] Registration
Damm i'm not wrong awardspace.com look there its an hosting provider.
and his page serenetygunzstatus.awardspace.com is hosted there.
-
Re: [help] Registration
-
Re: [help] Registration
k, i use server managmtn express, hence rotana is wrong, and btw, u need an sa and password.
