Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Need help with Admin cp and user cp

Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
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 :D
 
Newbie Spellweaver
Joined
Sep 6, 2008
Messages
15
Reaction score
0
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).
 
Upvote 0
Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
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 ?
 
Upvote 0
Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
you can make a Reg page?

Yh my reg pafe is working is this how its configd

PHP:
<?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>
 
Upvote 0
Newbie Spellweaver
Joined
Sep 6, 2008
Messages
15
Reaction score
0
You must restart the server so that the changes take place.
 
Upvote 0
Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
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
 
Upvote 0
Skilled Illusionist
Joined
Aug 27, 2008
Messages
349
Reaction score
25
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
 
Upvote 0
Newbie Spellweaver
Joined
Sep 6, 2008
Messages
15
Reaction score
0
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.
 
Upvote 0
Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
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 :D
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,
 
Upvote 0
Newbie Spellweaver
Joined
Dec 31, 2007
Messages
23
Reaction score
0
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
 
Upvote 0
Newbie Spellweaver
Joined
Sep 6, 2008
Messages
15
Reaction score
0
"INFORM-832402C4\SQLEXPRESS" you got this on your config.php, change it to INFORM-832402C4 and see if that works.
 
Upvote 0
Skilled Illusionist
Joined
Aug 27, 2008
Messages
349
Reaction score
25
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
 
Upvote 0
Sultan of Yolo
Loyal Member
Joined
May 21, 2008
Messages
1,225
Reaction score
110
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
 
Upvote 0
Back
Top