[RELEASE] Simple register (Works 100%)

It works on Xampp and appserv 100%, i have tested it out!
I know there is like this, but this is based on BR (Lg, Kekku) Database

Its made by Wizkidje

He gaved it to me, so i release it for thouse ppl who needs!

good job.

how do you use it? zz instructions please~

Quote:

---

Originally Posted by sherwinlfc

how do you use it? zz instructions please~

---

Download Xampp

Then edit index.php with notepad, put your information!
Then put it to htdocs folder in Xampp folder!

Then open web browser and type localhost or 127.0.0.1

So if it is 127.0.0.1.. hoow the hell do other people register

[quote=Jaycub;3244541]So if it is 127.0.0.1.. hoow the hell do other people register

The host should be Jacob\SQLEXPRESS

There rlly isnt a password for it..

When i connect to database it just says
connecting to server : Laptop1/sqlexpress
user : Laptop1/Jacob
password:

The password is blank

works for me on Wamp and Xampp

Nice release thnx :D. =p.

Quote:

---

Originally Posted by Antv912

The host should be Jacob\SQLEXPRESS

---

Yeah, thanks for correct my mistake :P

Ty for giving credits.

you should of made the password when you installed mssql lol. and it should be on sql auth not windows.

Zzzz, it must be that otherwise your whole gunzserver will not work.

IS THEIR A WAY TO RE-GET MY PASSWORD FOR MYSQL BACK ? COZ I DONT THINK I CAN REMEMBER IT !

Error :

Code:

---

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\wamp\www\index.php on line 5
Couldn't connect to the database, we're sorry...

---

In index :

Code:

---

<?php
$dns="GunZDB";
$user="Jacob\SQLEXPRESS";
$pass="";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");

function antisql($bericht){
$bericht = stripslashes($bericht);
$bericht = htmlspecialchars($bericht);
$bericht = nl2br($bericht);
return $bericht;
}

if(isset($_GET['action']) AND $_GET['action'] == "register"){

if(empty($_POST['username'])){
$error.="No username filled!<br>";
}

if(empty($_POST['password'])){
$error.="No password filled!<br>";
}

if(empty($_POST['email'])){
$error.="No e-mail filled!<br>";
}

if(empty($_POST['name'])){
$error.="No name filled!<br>";
}

if(empty($_POST['age'])){
$error.="No age filled!<br>";
}

if($error == TRUE){
echo "<br><br><center>There are some troubles while registering your account:<br>".$error."</center><br>";
die();
}

else
{
$regdate = date("Y-m-d H:i:s");
$email = antisql($_POST['email']);
$reg = "INSERT INTO Account (UserID, UGradeID, PGradeID, RegDate, Email, Age, Name) VALUES ('".antisql($_POST['username'])."', '1', '1', '$regdate', '$email', '".antisql($_POST['age'])."', '".antisql($_POST['name'])."')";
$query = odbc_exec($connect,$reg);
$gebruiker1 = "SELECT AID FROM Account WHERE UserID='".antisql($_POST['username'])."'";
$gebruiker = odbc_exec($connect,$gebruiker1);
$i=1;
while (odbc_fetch_row($gebruiker, $i)){
$aid = odbc_result($gebruiker, 'AID');
$i++;
}
if (!$aid)
{
die ("Oeps, something's wrong with the database");
}
$reg2 = "INSERT INTO Login (UserID, AID, Password) VALUES ('".antisql($_POST['username'])."', '$aid', '".antisql($_POST['password'])."')";
$query = odbc_exec($connect,$reg2);
print ("<center>Your account is succesfully created!</center>");
}
}
?>
<center><b>You can register a IMP Gunz account right here:</b><br><br>
<?php echo "<form action='".$_SERVER['PHP_SELF']."?action=register' method='POST'>"; ?>
<tr>
<td align=center height='24'>Username</td>
<td align=center height='24'><input type='text' name='username'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Password</td>
<td align=center height='24'><input type='password' name='password'></td>
</tr>
<br>
<tr>
<td align=center height='24'>E-mail&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='email'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='name'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='age'></td>
</tr>
<br>
<tr>
<td align=center height='24'></td>
<td align=center height='24'><input type='submit' value='Register!'></td>
</tr>
</form>

---