[help] Register.php erorr
Help for config register.php fatal erorr : Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\register.php on line 58
plase help for config register rf 2.2.3.2
====================================================
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
<?php
//MSSQL settings
$sql_user = 'rf'; // SQL ID
$sql_pwd = '112233'; // SQL PASSWORD (change it to your password mssql)
$base = "RF_User"; // SQL BASE name (don't change it's by default)
$host = "202.031.211.82"; // SQL HOST (change it to your IP ex : 127.0.0.1)
$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>';
}
?>
Re: [help] Register.php erorr
omg please dude search first before you post, ive answer this problem already. Go to your php.ini find ;extension=php_mssql.dll<<< now make it like this >>extension=php_mssql.dll<<< erase the semi column then next search for mssql.secure_connection = off <<< make it on >>mssql.secure_connection = On<<<
Re: [help] Register.php erorr
use older php version. 5.2.9 is the last one that natively has mssql support, any newer supports sqlsrv instead.
Re: [help] Register.php erorr
if im make double post plase give me link :) and warning me, sory about double post
Quote:
Originally Posted by
lifestream
use older php version. 5.2.9 is the last one that natively has mssql support, any newer supports sqlsrv instead.
appserver version 5.2.9 ?
Re: [help] Register.php erorr
forget appserv.
get WAMP.
WampServer, the web development platform on Windows - Apache, MySQL, PHP
then download what ever php , mysql, apache tc version u need and install then enable the roper version in the task bar icon.
alot easier and more comf. then appserv.
get php 5.29 as a extra module and apache 2.0.58 - that combo worked best.
then once done and its all green and enabled, u can just go to php menu - extensions and look for the mssql modules and enable - no need to edit php.ini
Re: [help] Register.php erorr
you can also use Bitnami stack
BitNami Stacks
it really usefull choose your stack and do some test :)
Re: [help] Register.php erorr
Quote:
Originally Posted by
lifestream
forget appserv.
get WAMP.
WampServer, the web development platform on Windows - Apache, MySQL, PHP
then download what ever php , mysql, apache tc version u need and install then enable the roper version in the task bar icon.
alot easier and more comf. then appserv.
get php 5.29 as a extra module and apache 2.0.58 - that combo worked best.
then once done and its all green and enabled, u can just go to php menu - extensions and look for the mssql modules and enable - no need to edit php.ini
ok im try ty my friend
Quote:
Originally Posted by
magenik
you can also use Bitnami stack
BitNami Stacks
it really usefull choose your stack and do some test :)
im try too ^^, sir magenik, can give me some tutorial for your web and game cp plase >.<
Re: [help] Register.php erorr
$mssql['panel']['host'] = '(local)';
$mssql['panel']['db'] = 'RF_PANEL';
$mssql['panel']['username'] = 'rfserver';
$mssql['panel']['password'] = 'rfserver';
$mssql['user']['host'] = '(local)';
$mssql['user']['db'] = 'RF_USER';
$mssql['user']['username'] = 'rfserver';
$mssql['user']['password'] = 'rfserver';
$mssql['billing']['host'] = '(local)';
$mssql['billing']['db'] = 'BillCruxRF';
$mssql['billing']['username'] = 'rfserver';
$mssql['billing']['password'] = 'rfserver';
i have question my server 2.2.3.2 without BillCruxRF
so im edit like this :
$mssql['panel']['host'] = '127.0.0.1\SQLEXPRESS';
$mssql['panel']['db'] = 'RF_PANEL';
$mssql['panel']['username'] = 'sa';
$mssql['panel']['password'] = 'rfserver';
$mssql['user']['host'] = '127.0.0.1\SQLEXPRESS';
$mssql['user']['db'] = 'RF_USER';
$mssql['user']['username'] = 'sa';
$mssql['user']['password'] = 'rfserver';
// nhvvvbbv$mssql['billing']['host'] = '127.0.0.1\SQLEXPRESS';
//$mssql['billing']['db'] = 'BillCruxRF';
//$mssql['billing']['username'] = 'sa';
//$mssql['billing']['password'] = 'rfserver';
erorr cant connect to data base >.< im use Magenik register form plase help me
Re: [help] Register.php erorr
try localhost or host and not 127.0.0.1\SQLEXPRESS.
Re: [help] Register.php erorr
Check again your MSSQL, change the false to true.
Re: [help] Register.php erorr
Quote:
Originally Posted by
fyurith
Check again your MSSQL, change the false to true.
at RF_Panel om change to true :3
ty it is work ty
ok now have problem again after im clik submid have arorr :
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'tblUser'. (severity 16) in C:\xampp\htdocs\controls\register\no_captcha.php on line 131
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\controls\register\no_captcha.php on line 131
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'tblUser'. (severity 16) in C:\xampp\htdocs\controls\register\no_captcha.php on line 132
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\controls\register\no_captcha.php on line 132
Warning: mssql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\controls\register\no_captcha.php on line 133
Re: [help] Register.php erorr
Invalid object name 'tblUser'
that mean the table doesnt exist
you didn't even import the db lolll ><
well as my script work with billcruxRF and seems you don't have it
then why you try install my script if you can't even edit it as you don't use what it's needed ?
i wont support that man try make same as i do then we talk
Re: [help] Register.php erorr
on my appeared this error:
Warning: mssql_query() [function.mssql-query]: message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblUser_tblCodeUserStatus". The conflict occurred in database "BillCruxRF", table "dbo.tblCodeUserStatus", column 'userStatusId'. (severity 16) in C:\AppServ\www\Website\controls\register\no_captcha.php on line 131
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\Website\controls\register\no_captcha.php on line 131
Re: [help] Register.php erorr
well guys i use my own BillcruxRF that i have since 2.2.1
atm i'm working on it for make a basic billcrux for all but it's not so easy due i use the first billcruxrf ever shared from levelup games
so u have to edit some table due Key
Re: [help] Register.php erorr
Quote:
Originally Posted by
magenik
well guys i use my own BillcruxRF that i have since 2.2.1
atm i'm working on it for make a basic billcrux for all but it's not so easy due i use the first billcruxrf ever shared from levelup games
so u have to edit some table due Key
Do you have a fix register.php?, my register PHP always error, im using Wamp Bitnami
