[Help]Problem with reg page

* White * · 08/11/2011, 17:00

ok i did all . But when i go to reg.htm i get this .

im using appserver.

Code:

>>>> YOUR_DATABASE <<<<< AND replace it with your database NAME! // Xsense ////////////////////////////////////////////////////////////////////////////////////// $mssql = array( 'host' => "N0601-SAN\SQLEXPRESS", //Your mssql host goes here 'user' => "sa", //Your mssql username goes here 'pass' => "1234" //Your mssql password goes here ); function anti_injection($sql) { $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql); $sql = trim($sql); $sql = strip_tags($sql); $sql = addslashes($sql); return $sql; } if($_POST['activ'] == '1') { $accname = anti_injection($_POST['accname']); $accpass1 = anti_injection($_POST['accpass1']); $accpass2 = anti_injection($_POST['accpass2']); $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']); $result1 = mssql_query("SELECT * FROM N0601-SAN\SQLEXPRESS.dbo.users WHERE id = '".$accname."'",$con); $row1 = mssql_num_rows($result1); if(empty($accname) || empty($accpass1) || empty($accpass2)|| empty($accname)) { echo "
You didnt fill in all fieldsGo Back"; } elseif($row1 > '0' || $row2 > '0') { echo "
This Account name already exists.Go Back"; } elseif($accpass1 != $accpass2) { echo "
The passwords did not matchGo Back"; } elseif($accpass1 == $accname) { echo "
Account name and password are the same.Go Back"; } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accname)) { echo "
Enter a account name only with 0-9 , a-z and A-Z.Go Back"; } elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accpass1)) { echo "
Enter a password only with 0-9 , a-z and A-Z.Go Back"; } elseif(strlen($accname) < 3 || strlen($accname) > 15) { echo "
Username Must be above 3 and lower then 15 Go Back"; } elseif(strlen($accpass1) < 3 || strlen($accpass1) > 15) { echo "
Password Must be above 3 and lower then 15 .Go Back"; } else { $accpass = md5($accpass1); $con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']); mssql_query("INSERT INTO N0601-SAN\SQLEXPRESS.dbo.users ( id, password, online, unknown, unknown2, silk, gold ) VALUES ( '".$accname."', '".$accpass."', '0', '0', '0', '0', '0' )",$con); ?>

here is my reg.htm

Code:

<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
	color: #FFFFFF;
}
body {
	background-color: #000000;
}
-->
</style>
<?php
//////////////////////////////////////////////////////////////////////////////////////
// IMPORTANT!!!!!!
// SEARCH FOR >>>>> N0601-SAN\SQLEXPRESS <<<<< AND replace it with your database NAME!
// Xsense
//////////////////////////////////////////////////////////////////////////////////////
$mssql = array(
		'host' => "N0601-SAN\SQLEXPRESS",		//Your mssql host goes here
		'user' => "sa",		//Your mssql username goes here
		'pass' => "1234"		//Your mssql password goes here
	);

function anti_injection($sql) {
   $sql 			= preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
   $sql 			= trim($sql);
   $sql 			= strip_tags($sql);
   $sql 			= addslashes($sql);
   return $sql;
}

if($_POST['activ'] == '1') {

		$accname 		= anti_injection($_POST['accname']);
		$accpass1 		= anti_injection($_POST['accpass1']);
		$accpass2 		= anti_injection($_POST['accpass2']);
		$con 			= mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
		$result1 		= mssql_query("SELECT * FROM N0601-SAN\SQLEXPRESS.dbo.users WHERE id = '".$accname."'",$con);
		$row1 			= mssql_num_rows($result1);
		
		if(empty($accname) || empty($accpass1) || empty($accpass2)|| empty($accname)) {
			echo "<br>You didnt fill in all fields<a href='javascript:history.back()'>Go Back</a>";
		} elseif($row1 > '0' || $row2 > '0') {
			echo "<br>This Account name already exists.<a href='javascript:history.back()'>Go Back</a>";
		} elseif($accpass1 != $accpass2) {
			echo "<br>The passwords did not match<a href='javascript:history.back()'>Go Back</a>";
		} elseif($accpass1 == $accname) {
			echo "<br>Account name and password are the same.<a href='javascript:history.back()'>Go Back</a>";
		} elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accname)) {
			echo "<br>Enter a account name only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
		} elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accpass1)) {
			echo "<br>Enter a password only with 0-9 , a-z and A-Z.<a href='javascript:history.back()'>Go Back</a>";
		} elseif(strlen($accname) < 3 || strlen($accname) > 15) {
			echo "<br>Username Must be above 3 and lower then 15 <a href='javascript:history.back()'>Go Back</a>";
		} elseif(strlen($accpass1) < 3 || strlen($accpass1) > 15) {
			echo "<br>Password Must be above 3 and lower then 15 .<a href='javascript:history.back()'>Go Back</a>";
		} else {

		$accpass 		= md5($accpass1);
		$con 			= mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
						  mssql_query("INSERT INTO N0601-SAN\SQLEXPRESS.dbo.users (
						  											id,
																	password,
																	online,
																	unknown,
																	unknown2,
																	silk,
																	gold
																)
														VALUES 	(
																	'".$accname."',
																	'".$accpass."',
																	'0',
																	'0',
																	'0',
																	'0',
																	'0'
																)",$con);
?>
	<center>
		<table width="500">
			<tr>
	  			<td colspan='2' align='center'><img src="top.jpg" width="500" height="300" /></td>
			</tr>
			<tr>
	  			<td colspan="2" align="center" bgcolor="#333333">
					Welcome to srevolution! Below are your details! Keep them safe!
				</td>
			</tr>
			<tr>
	  			<td bgcolor="#666666">
					Account name: 
				</td>
				<td bgcolor="#666666">
					<b><?php echo "".$accname.""; ?></b>
				</td>
			</tr>
			<tr>
	  			<td bgcolor="#333333">
					Your password: 
				</td>
				<td bgcolor="#333333">
					<b><?php echo "".$accpass1.""; ?></b>
				</td>
			</tr>
		</table>
	</center>

<?php
		}

} else {

	$con 			= mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
	$result1 		= mssql_query("SELECT * FROM N0601-SAN\SQLEXPRESS.dbo.users",$con);
	$row1 			= mssql_num_rows($result1);
?>	

	<form action='reg.php' method='POST'>
		<center>
			<table width="500">
				<tr>
	  				<td colspan='2' align='center'>
						<img src="top.jpg" width="500" height="300" />
					</td>
				</tr>
				<tr>
					<td bgcolor="#333333">Account Name</td>
					<td bgcolor="#333333">
						<input type='text' name='accname' maxlength='12'>
					</td>
				</tr>
				<tr>
					<td bgcolor="#666666">Password</td>
					<td bgcolor="#666666">
						<input type='password' name='accpass1' maxlength='12'>
					</td>
				</tr>
				<tr>
					<td bgcolor="#333333">Again pass.</td>
					<td bgcolor="#333333">
						<input type='password' name='accpass2' maxlength='12'>
					</td>
				</tr>
				<tr>
					<td align='center' bgcolor="#666666">
					</td>
	  				<td align='right' bgcolor="#666666">
						<input type='hidden' name='activ' value='1' />
        				<input name="submit" type='submit' value='Create Account' />
					</td>
				</tr>
			</table>
		</center>
	</form>
	
<?php
}
?>

IF i use other reg page. then here

i get Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\reg.php on line 115

soulmore · 08/11/2011, 17:07

which is the line 115? i can´t find it in your reg.php i copied it in editplus and get this one but not sure...

Code:

$con 			= mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

It seems to be a problem with your user and password in the database, check it and change in case it needs in your mysql.

If you can acces to your tables inside the database using phpmyadmin i can´t solve this.
Hope this clue helps you to solve the problem and sorry for my poor english

* White * · 08/11/2011, 17:50

guys i readded all . now i get this.

arning: mssql_query(): message: Invalid column name 'unknown'. (severity 16) in c:\appserv\www\reg.php on line 79

Warning: mssql_query(): message: Invalid column name 'unknown2'. (severity 16) in c:\appserv\www\reg.php on line 79

Warning: mssql_query(): Query failed in c:\appserv\www\reg.php on line 7

soulmore · 08/11/2011, 17:58

At the end of this guide you have a complete set for reg.php. Hope it helps credit to the author

* White * · 08/11/2011, 18:00

Quote:

Originally Posted by soulmore

At the end of this guide you have a complete set for reg.php. Hope it helps credit to the author

i used that guide.

soulmore · 08/11/2011, 18:05

I found the problem i think. PHP can´t connect to your database because you have this in your database

Code:

'host' => [b][color=red]"N0601-SAN\SQLEXPRESS"[/color][/b],		//Your mssql host goes here
		'user' => "sa",		//Your mssql username goes here
		'pass' => "1234"		//Your mssql password goes here

You should change it to your database host . Easy!!

* White * · 08/11/2011, 19:03

Quote:
Originally Posted by soulmore
I found the problem i think. PHP can´t connect to your database because you have this in your database
Code:
'host' => [b][color=red]"N0601-SAN\SQLEXPRESS"[/color][/b],		//Your mssql host goes here
		'user' => "sa",		//Your mssql username goes here
		'pass' => "1234"		//Your mssql password goes here
You should change it to your database host . Easy!!

what ? then what my database host

?

on line 90 i have this code

Code:

)",$con);
?>

here. when i start game andlogin server.

~~insertcoi~~ · 08/11/2011, 19:05

* White *
can you make a tutorial, how to make a server with new srx +reg .... a ? or you can upload you srx ?

* White * · 08/11/2011, 19:10

Quote:

Originally Posted by insertcoi

* White *
can you make a tutorial, how to make a server with new srx +reg .... a ? or you can upload you srx ?

there is tutorial lol ;D

someone help ..

. I opened server, status is good login and game server show on. But why i cant register ?

~~insertcoi~~ · 08/11/2011, 19:14

) i know ..

evolution007 · 08/11/2011, 19:22

your database host name:

in blue background

* White * · 08/11/2011, 19:26

i know this,its changed...
All good,stas,but when i press create acount then i got that eror

~~insertcoi~~ · 08/11/2011, 19:30

White you are use this srx ?

evolution007 · 08/11/2011, 19:38

Quote:

Originally Posted by insertcoi

White you are use this srx ?

this one is old srevo he is using srx

* White * · 08/11/2011, 19:39

Quote:

Originally Posted by insertcoi

White you are use this srx ?

Yea.but im waiting new Limex