Need help with Admin cp and user cp

[magical884]

Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\Gunz\Website\_inc\config.php on line 13<?php
//Data Base Stuff!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$DBHost = 'RICKY-PC\FORUM'; //The host of your DB (I.E: MACHINE\SQL2005)
$DBUser = 'sa'; //Your DB User
$DBPass = '************'; //Your DB Password
$DB = 'GunzDB'; //Your GunZ DB
//Web Site Stuff!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$Top = '10'; //The total numbers on the list exp 10 will show the top 10



// Dont change any think below this!!!
$conn = mssql_connect($DBHost, $DBUser, $DBPass);
mssql_select_db($DB);
@mssql_select_db($DB);
$query = @mssql_query ("SELECT ID, Store, Register, Stats, LastReg, Status, Name, Servername From websettings");
for($i='';$i < @mssql_num_rows($query);++$i){
$row = @mssql_fetch_row($query);
$rank = $i+1;
$idw = $row[0];
$Storew = $row[1];
$Registerw = $row[2];
$Statsw = $row[3];
$LastRegw = $row[4];
$Statusw = $row[5];
$Namew = $row[6];
$Servernamew = $row[7];}
$Server = $row[6];
$SN = $row[7];
if ($row[1] >= '0') { $Store = '1'; }
if ($row[2] >= '1') { $allow_register = '1'; }
if ($row[3] >= '1') { $stats = '1'; }
if ($row[4] >= '1') { $lastreg = '1'; }
if ($row[5] >= '1') { $status = '1'; } ?>







<?php
//Data Base Stuff!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$DBHost = '******\FORUM'; //The host of your DB (I.E: MACHINE\SQL2005)
$DBUser = 'sa'; //Your DB User
$DBPass = '************'; //Your DB Password
$DB = 'GunzDB'; //Your GunZ DB
//Web Site Stuff!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$Top = '10'; //The total numbers on the list exp 10 will show the top 10



// Dont change any think below this!!!
$conn = mssql_connect($DBHost, $DBUser, $DBPass);
mssql_select_db($DB);
@mssql_select_db($DB);
$query = @mssql_query ("SELECT ID, Store, Register, Stats, LastReg, Status, Name, Servername From websettings");
for($i='';$i < @mssql_num_rows($query);++$i){
$row = @mssql_fetch_row($query);
$rank = $i+1;
$idw = $row[0];
$Storew = $row[1];
$Registerw = $row[2];
$Statsw = $row[3];
$LastRegw = $row[4];
$Statusw = $row[5];
$Namew = $row[6];
$Servernamew = $row[7];}
$Server = $row[6];
$SN = $row[7];
if ($row[1] >= '0') { $Store = '1'; }
if ($row[2] >= '1') { $allow_register = '1'; }
if ($row[3] >= '1') { $stats = '1'; }
if ($row[4] >= '1') { $lastreg = '1'; }
if ($row[5] >= '1') { $status = '1'; } ?>



I dnt know what im doing wrong i believe my information coronet im using IIS sever host my sever and i have PHP 5.2 installed Do i need to change anything in php.ini? thanks

 

[eele]

you can make a Reg page?

 

[m1n05]

Start->Run->C:\Windows\php.ini and search for mssql dll. It's gonna have a ; at the beggining, just take it out.

*Note* If it's not on C:\Windows\php.ini just search for the file manually (php.ini that is).

 

[magical884]

Start->Run->C:\Windows\php.ini and search for mssql dll. It's gonna have a ; at the beggining, just take it out.

*Note* If it's not on C:\Windows\php.ini just search for the file manually (php.ini that is).

i changed that but still no use o.0, have you got any other suggestions ?

 

[magical884]

you can make a Reg page?

Yh my reg pafe is working is this how its configd

<?php 
$dns="GunzDB";
$user="sa";
$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 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     </td>
<td align=center height='24'><input type='text' name='email'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Name     </td>
<td align=center height='24'><input type='text' name='name'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Age        </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>
<p align="center"><a href="http://sil3nt884.no-ip.biz/download/">Download client</a></p>
<p align="center"><a href="http://sil3nt884.no-ip.biz/download/Patch.zip">Patch</a></p>
<p align="center"><a href="http://sil3nt884.no-ip.biz/forum">Forum</a></p>
<p align="center"><a href="http://megaupload.com/?d=F1XNA9EA">Download client 
link 2</a></p>

 

[m1n05]

You must restart the server so that the changes take place.

 

[magical884]

You must restart the server so that the changes take place.

I have restarted the sever im still getting error ?, Are there database settings to be configed or maybe the page is not supported , my reggae is connected to my database using odic

 

[Kyuma]

i have problem with admin pannel cant acess always saying

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: INFORM-832402C4\SQLEXPRESS in C:\wamp\www\AdminCp\config.php on line 19

Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\wamp\www\AdminCp\config.php on line 20

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\wamp\www\AdminCp\config.php on line 20

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\AdminCp\index.php on line 37

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\AdminCp\index.php on line 37

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\AdminCp\index.php on line 38
Usuario y/o Contrase

 

[m1n05]

Perhaps you don't have the dll for the MSSQL. You could download the whole package from PHP.net and then search for the specific DLL and then paste it on the PHP folder.

And Kyuma you should try doing the same thing. Open up php.ini as i have explained on past posts and modify the line with the mssql dll and then restart server. If that still doesn't work download the whole package (and not the installer from php.net) and extract the mssql dll to PHP bin folder.

 

[magical884]

Perhaps you don't have the dll for the MSSQL. You could download the whole package from PHP.net and then search for the specific DLL and then paste it on the PHP folder.

And Kyuma you should try doing the same thing. Open up php.ini as i have explained on past posts and modify the line with the mssql dll and then restart server. If that still doesn't work download the whole package (and not the installer from php.net) and extract the mssql dll to PHP bin folder.

ya i had the extentiosn in the wrong folder thanks you
But now get another when i try to log on admin panel i get wrong password and id error i do believe my password and id is right,

 

[magical884]

i have problem with admin pannel cant acess always saying

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: INFORM-832402C4\SQLEXPRESS in C:\wamp\www\AdminCp\config.php on line 19

Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\wamp\www\AdminCp\config.php on line 20

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\wamp\www\AdminCp\config.php on line 20

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\AdminCp\index.php on line 37

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\AdminCp\index.php on line 37

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\AdminCp\index.php on line 38
Usuario y/o Contrase

 

[Kyuma]

can someone help me ... i dun understand lool..

ADD ME --> [email protected]

thx

 

[m1n05]

"INFORM-832402C4\SQLEXPRESS" you got this on your config.php, change it to INFORM-832402C4 and see if that works.

 

[Kyuma]

Ok ^^

 

[Kyuma]

Same Error --'


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: INFORM-832402C4 in C:\wamp\www\TEST\config.php on line 19

Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\wamp\www\TEST\config.php on line 20

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\wamp\www\TEST\config.php on line 20

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\TEST\index.php on line 37

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\TEST\index.php on line 37

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\TEST\index.php on line 38
Usuario y/o Contrase

 

[Demantor]

Same Error --'


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: INFORM-832402C4 in C:\wamp\www\TEST\config.php on line 19

Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\wamp\www\TEST\config.php on line 20

Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\wamp\www\TEST\config.php on line 20

Warning: mssql_query() [function.mssql-query]: Unable to connect to server: (null) in C:\wamp\www\TEST\index.php on line 37

Warning: mssql_query() [function.mssql-query]: A link to the server could not be established in C:\wamp\www\TEST\index.php on line 37

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\TEST\index.php on line 38
Usuario y/o Contrase