Help me Register config

[wagnerwsc]

Good afternoon someone could help me with this error I am Fatal error: Call to undefined function mssql_connect () in C: \ AppServ \ www \ register.php on line 58

 

[dpman]

you are in a wrong section..
for your problem, you need to enable your mssql extension in your php.ini

 

[wagnerwsc]

already checked in php ini folder in windows everything is correct
I use hamachi can this be?

 

[Ron]

No.

You need to install the MSSQL plugin for Apache. PHP 5.3+ no longer supports mssql_ so you'll need to either use PHP 5.2 or compile Apache with PHP 5.3 + your own mods yourself.

 

[wagnerwsc]

I'm using php 2.5.9 appserve 5.2 and sql server 2008 only registration does not work

apache/2.2.4 (Win32) PHP/5.2.3


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 25.189.10.193 in C:\AppServ\www\register.php on line 58
Критическая ошибка
Невозможно подключиться к базе






<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>

<?php

//MSSQL settings
$sql_user = 'rfonline'; // SQL ID
$sql_pwd = 'xxxxxx'; // SQL PASSWORD (change it to your password mssql)
$base = "RF_User"; // SQL BASE name (don't change it's by default)
$host = "25.189.10.193,61433"; // SQL HOST (change it to your IP ex : 127.0.0.1)my ip hamachi serve


$reg_open = true;

$tabelka = '<form action=register.php method=post><body topmargin="0" leftmargin="0" bottommargin="0" rightmargin="0" scroll="no" bgcolor="#1f1f1f" text="#a0a0a0">
<table width="305" border="0">
<tr>
<td width="277"><span class="Style4">Ëîãèí: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=text name=login value="'.$_POST['login'].'"></td>
</tr>
<tr>
<td><span class="Style4">Ïàðîëü: </span></td>
</tr>
<tr>
<td height="35" valign="top"><input type=password name=pass></td>
</tr>
<tr>
<td><span class="Style4">Ïîâòîðèòå ïàðîëü: </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>
</form>';

if($reg_open AND isset($_POST['login']))
{


$conn=mssql_connect($host,$sql_user,$sql_pwd) or die("<center><b>Êðèòè÷åñêàÿ îøèáêà</b><br>Íåâîçìîæíî ïîäêëþ÷èòüñÿ ê áàçå<br><br><a href=register.php>Back</a></center>");

@mssql_select_db($base, $conn) or die("<center><b>Êðèòè÷åñêàÿ îøèáêà</b><br>Áàçà íå ñóùåñòâóåò, ëèáî íåò äîñòóïà<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>Ëîãèí äîëæåí ñîñòîÿòü ÒÎËÜÊÎ èç ñèìâîëîâ 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>Ïàðîëü äîëæåí ñîñòîÿòü ÒÎËÜÊÎ èç ñèìâîëîâ 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>Çàïîëíèòå âñå ïîëÿ<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strpos('\'',$email))
{
echo '<body><center>E-mail '.$email.' èìååò íåïðàâèëüíûé ôîðìàò.<br><br><a href="register.php">Back</a></center></body>';
}
else
{
$login_test = strtolower($login);


if (mssql_num_rows($resultx))
{
echo '<body><center>Ëîãèí '.$login.' óæå ñóùåñòâóåò<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) < 4)
{
echo '<body><center>Ëîãèí äîëæåí ñîäåðæàòü áîëåå 4 ñèìâîëîâ<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) < 4)
{
echo '<body><center>Ïàðîëü äîëæåí ñîäåðæàòü áîëåå 4 ñèìâîëîâ<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($pw) > 10)
{
echo '<body><center>Ïàðîëü äîëæåí ñîäåðæàòü ìåíåå 10 ñèìâîëîâ<br><br><a href="register.php">Back</a></center></body>';
}
elseif (strlen($login) > 10)
{
echo '<body><center>Ëîãèí äîëæåí ñîäåðæàòü ìåíåå 10 ñèìâîëîâ<br><br><a href="register.php">Back</a></center></body>';
}
elseif ($pw != $cpw)
{
echo '<body><center>Ïàðîëè íå ñîâïàäàþò<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');")or die('<center>Òàêîé àêêàóíò óæå ñóùåñòâóåò<br><br><a href=register.php>Back</a></center>');

echo '<body bgcolor="000000"><center>Àêêàóíò óñïåøíî ñîçäàí!<br><br><a href=rfweb/list.htm>Back</a></center></body>';
}
}
}
elseif($reg_open)
{
echo $tabelka;
}
else
{
echo '<center>Ðåãèñòðàöèÿ çàêðûòà. Ïîïðîáóéòå ïîçæå.<br></center>';
}
?>

 

[Ron]

Try this,

$host = "25.189.10.193:61433";

Otherwise make sure 61433 is open for outgoing on your webserver. If its on the same server as the game, use 127.0.0.1 or localhost.