I really cant find a good website
For MMSQL . A register page site is also good
I already used the search button and spitted though all the threads.
Please, share with me : )
Sincerely,
Aagib
Printable View
I really cant find a good website
For MMSQL . A register page site is also good
I already used the search button and spitted though all the threads.
Please, share with me : )
Sincerely,
Aagib
get a look by this thread
http://forum.ragezone.com/f457/guide...s-only-650120/
The basic registration script says:
Parse error: parse error in C:\wamp\www\register.php on line 76
maybe u did something wrong
So I need to fill in this right?:Code:<?php
$link = @mssql_connect("SERVER IP", "USER", "PASSWORD") or die ("Server is not available!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM dbo.ACCOUNT_TBL WHERE account='$name'");
if(mssql_num_rows($result) != 0){
$exit = TRUE;
}
else{
$exit = FALSE;
}
return $exit;
}
if(!isset($_POST['submit'])){
printSign("");
}
else if(isset($_POST['submit'])){
$userRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$passRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
$day = (int) $_POST['day'];
$month = (int) $_POST['month'];
$year = (int) $_POST['year'];
$email = $_POST['email'];
if(empty($_POST['username'])){
printSign("Please enter an account name.");
}
else if(empty($_POST['email'])){
printSign("Please enter an e-mail address.");
}
else if(empty($_POST['password'])){
printSign("Please enter a password.");
}
else if(empty($day) || empty($month) || empty($year) || strlen($day) > 2 || strlen($month) > 2 || strlen($year) != 4 || $day == 00 || $month == 00 || $year == 0000){
printSign("Please enter your birth day.");
}
else if(strlen($_POST['username']) > 15){
printSign("Your username cannot contain more than 15 characters!");
}
else if(strlen($_POST['password']) > 36){
printSign("Your password cannot contain more than 36 characters!");
}
else if($_POST['username'] != $userRev){
printSign("Your username contains illegal characters and/or words!");
}
else if($_POST['password'] != $passRev){
printSign("Your password contains illegal characters!");
}
else if(strlen(filter_var($email, FILTER_VALIDATE_EMAIL)) == 0){
printSign("Your is e-mail is incorrect, please check it!");
}
else {
if ($resp->is_valid) {
$userRev = strtolower($userRev);
$passRev = strtolower($passRev);
$bday = $month.'/'.$day.'/'.$year;
$email = $_POST['email'];
$salt = "gamingsync";
$passRev = md5($salt.$passRev);
if(!doesUsernameExist($userRev)){
$stmt = mssql_init('dbo.webCreateAcc', $link);
mssql_bind($stmt, '@account', $userRev, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@password', $passRev, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120);
mssql_bind($stmt, '@email', $email, SQLVARCHAR, false, false, 120);
mssql_execute($stmt) or die ("Error with the execution.");
mssql_free_statement($stmt);
printSign('<font color="black">Thank you for registering with the name '.$userRev.'.</font>');
}
else {
printSign("Username is already taken!");
}
}
}
}
}
function printSign($alert){
?>
<html>
<body>
<div align="center">
<h1><u>ENTER SERVER NAME</u></h1>
<?php if($alert != ''){ echo '<h2><font color="red">'.$alert.'</font></h2>'; } ?>
<form action="flyffregister.php" method="post">
<table>
<tr>
<td>Username :</td>
<td><input size="20" name="username" maxlength="15" type="text"></td>
<td>(A-Z, a-z, 1-9)</td>
</tr>
<tr>
<td>Password :</td>
<td><input size="20" name="password" maxlength="35" type="password"></td>
<td>(A-Z, a-z, 1-9)</td>
</tr>
<tr>
<td>E-mail :</td>
<td><input size="20" name="email" maxlength="255" type="text"></td>
</tr>
<tr>
<td>Birth day :</td>
<td><input size="1" name="month" maxlength="2" type="text" value="MM"> <input size="1" name="day" maxlength="2" type="text" value="DD"> <input size="3" name="year" maxlength="4" type="text" value="YYYY"></td>
</tr>
</table>
<input type="submit" name="submit" value="register" />
</form>
Copyright 2009 © <a href="http://forum.furiazone.com/newthread.php?do=postthread&f=74"><b>Rick</b></a>.
</div>
</body>
</html>
<?php } ?>
Server IP = 127.0.0.1
User = SA
Pass = MyPass
What do I do wrong?
Code:<?php
$link = @mssql_connect("SERVER IP", "I THINK HRE IS YOUR SERVER DB", "PASSWORD OF THE DB") or die ("Server is not available!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM dbo.ACCOUNT_TBL WHERE account='$name'");
if(mssql_num_rows($result) != 0){
$exit = TRUE;
}
else{
$exit = FALSE;
}
return $exit;
}
if(!isset($_POST['submit'])){
printSign("");
}
else if(isset($_POST['submit'])){
$userRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$passRev = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
$day = (int) $_POST['day'];
$month = (int) $_POST['month'];
$year = (int) $_POST['year'];
$email = $_POST['email'];
if(empty($_POST['username'])){
printSign("Please enter an account name.");
}
else if(empty($_POST['email'])){
printSign("Please enter an e-mail address.");
}
else if(empty($_POST['password'])){
printSign("Please enter a password.");
}
else if(empty($day) || empty($month) || empty($year) || strlen($day) > 2 || strlen($month) > 2 || strlen($year) != 4 || $day == 00 || $month == 00 || $year == 0000){
printSign("Please enter your birth day.");
}
else if(strlen($_POST['username']) > 15){
printSign("Your username cannot contain more than 15 characters!");
}
else if(strlen($_POST['password']) > 36){
printSign("Your password cannot contain more than 36 characters!");
}
else if($_POST['username'] != $userRev){
printSign("Your username contains illegal characters and/or words!");
}
else if($_POST['password'] != $passRev){
printSign("Your password contains illegal characters!");
}
else if(strlen(filter_var($email, FILTER_VALIDATE_EMAIL)) == 0){
printSign("Your is e-mail is incorrect, please check it!");
}
else {
if ($resp->is_valid) {
$userRev = strtolower($userRev);
$passRev = strtolower($passRev);
$bday = $month.'/'.$day.'/'.$year;
$email = $_POST['email'];
$salt = "gamingsync";
$passRev = md5($salt.$passRev);
if(!doesUsernameExist($userRev)){
$stmt = mssql_init('dbo.webCreateAcc', $link);
mssql_bind($stmt, '@account', $userRev, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@password', $passRev, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120);
mssql_bind($stmt, '@email', $email, SQLVARCHAR, false, false, 120);
mssql_execute($stmt) or die ("Error with the execution.");
mssql_free_statement($stmt);
printSign('<font color="black">Thank you for registering with the name '.$userRev.'.</font>');
}
else {
printSign("Username is already taken!");
}
}
}
}
}
function printSign($alert){
?>
<html>
<body>
<div align="center">
<h1><u>ENTER SERVER NAME</u></h1>
<?php if($alert != ''){ echo '<h2><font color="red">'.$alert.'</font></h2>'; } ?>
<form action="flyffregister.php" method="post">
<table>
<tr>
<td>Username :</td>
<td><input size="20" name="username" maxlength="15" type="text"></td>
<td>(A-Z, a-z, 1-9)</td>
</tr>
<tr>
<td>Password :</td>
<td><input size="20" name="password" maxlength="35" type="password"></td>
<td>(A-Z, a-z, 1-9)</td>
</tr>
<tr>
<td>E-mail :</td>
<td><input size="20" name="email" maxlength="255" type="text"></td>
</tr>
<tr>
<td>Birth day :</td>
<td><input size="1" name="month" maxlength="2" type="text" value="MM"> <input size="1" name="day" maxlength="2" type="text" value="DD"> <input size="3" name="year" maxlength="4" type="text" value="YYYY"></td>
</tr>
</table>
<input type="submit" name="submit" value="register" />
</form>
Copyright 2009 © <a href="http://forum.furiazone.com/newthread.php?do=postthread&f=74"><b>Rick</b></a>.
</div>
</body>
</html>
<?php } ?>
Nah the database is below that.
User = sa
What is mssql
---------- Post added at 08:33 PM ---------- Previous post was at 08:29 PM ----------
Nah the database is below that.
User = sa
What is mssql
mssql is the program u will need to execute the tables of the db of the official server files lol
I know, the previous post got kinda wrong submitted.
But the site you gave me really doesnt work :/