You last visited: Today at 01:53
Advertisement
PHP problem
Discussion on PHP problem within the Shaiya Private Server forum part of the Shaiya category.
09/21/2011, 11:37
#1
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
PHP problem
Well on my server the registration and top GRB guilds scripts work fine... but other scrips like the login script from ProfNerwosol
PHP Code:
<?php
= $_ENV [ 'LOCAL_DOMAIN' ];
$dbuser = 'Shaiya' ;
$dbpwd = 'Shaiya123' ;
// connect to SQL server
if (! $link = @ mssql_connect ( " $dbhost " , " $dbuser " , " $dbpwd " ))
"Failed to connect to MSSQL server." ;
// select database
if (!@ mssql_select_db ( "PS_GameData" , $link ))
"Failed to select database." ;
// check who's online
$result = @ mssql_query ( "SELECT LoginStatus, Family FROM Chars WHERE LoginStatus=1" , $link );
// initialize veriables
$online = @ mssql_num_rows ( $result );
$human = 0 ;
$elf = 0 ;
$vail = 0 ;
$nordein = 0 ;
// fill variables with data (who's online)
while( $row = @ mssql_fetch_array ( $result , MSSQL_NUM ))
mssql_num_rows ( $result )== 0 ) return;
$row [ 1 ])
0 : $human ++;break;
1 : $elf ++;break;
2 : $vail ++;break;
3 : $nordein ++;break;
mssql_free_result ( $result );
// Print number of online players
print "<table style=\"border: 1px solid black;\">
. $online . "</td></tr>
. $human . "</td></tr>
. $elf . "</td></tr>
. $vail . "</td></tr>
. $nordein . "</td></tr>
;
mssql_close ( $link );
?>
it leaves me with a blank page.
also the rank script from Bulgaria.
PHP Code:
<?php
//here you must to replace data with your
$server = 'l127.0.0.1' ;
$dbuser = 'Shaiya' ;
$dbpass = 'Shaiya123' ;
$count = 1 ;
$rimg = 0 ;
$cimg = 0 ;
$kdr = 0 ;
//joker's remake : variable "$topcount" defined rows (1~N) in the table of top(N) players.
$topcount = 100 ;
//connection with database
$conn = mssql_connect ( $server , $dbuser , $dbpass )
"Couldn't connect to SQL Server on $myServer " );
$query = "SELECT * FROM PS_GameData.dbo.chars ORDER BY k1 desc" ;
$result = mssql_query ( $query );
"<html><head><STYLE TYPE=\"text/css\">
;
"<body><center>
;
//joker's remake : check the end of table
while( $count != ( $topcount + 1 ))
//joker's remake : get status of the player
$row = mssql_fetch_array ( $result );
$status = mssql_query ( " SELECT UserUID,Status FROM PS_UserData.dbo.Users_Master WHERE UserUID = $row [ 2 ] " , $conn );
$row1 = mssql_fetch_array ( $status );
//joker's remake : check that status=0 ,so eliminate all banned players ,GM,GMA
if( $row1 [ 1 ] == 0 )
$row [ 39 ] >= 200000 )
$rimg = 16 ;
$row [ 39 ] >= 150000 )
$rimg = 15 ;
$row [ 39 ] >= 130000 )
$rimg = 14 ;
$row [ 39 ] >= 110000 )
$rimg = 13 ;
$row [ 39 ] >= 90000 )
$rimg = 12 ;
$row [ 39 ] >= 70000 )
$rimg = 11 ;
$row [ 39 ] >= 50000 )
$rimg = 10 ;
$row [ 39 ] >= 40000 )
$rimg = 9 ;
$row [ 39 ] >= 30000 )
$rimg = 8 ;
$row [ 39 ] >= 20000 )
$rimg = 7 ;
$row [ 39 ] >= 10000 )
$rimg = 6 ;
$row [ 39 ] >= 5000 )
$rimg = 5 ;
$row [ 39 ] >= 1000 )
$rimg = 4 ;
$row [ 39 ] >= 300 )
$rimg = 3 ;
$row [ 39 ] >= 50 )
$rimg = 2 ;
$row [ 39 ] >= 1 )
$rimg = 1 ;
$rimg = 0 ;
$cimg = $row [ 13 ]+ 17 ;
$row [ 40 ]=== 0 )
$kdr = number_format ( $row [ 39 ]/ 1 , 3 , '.' , '' );
$kdr = number_format ( $row [ 39 ]/ $row [ 40 ], 3 , '.' , '' );
"<tr style=\"color:white\">" ;
"<td> $count </td><td>" . $row [ 4 ] . "</td><td class=\"i $cimg \"></td><td>" . $row [ 15 ] . "</td><td>" . $row [ 39 ] . "</td><td>" . $row [ 40 ] . "</td><td>" . $kdr . "</td><td class=\"i $rimg \"></td>" ;
"</tr>" ;
$count ++;
"</table>" ;
"</html>" ;
mssql_close ( $conn );
?>
this one leaves me with this.
Code:
Call to undefined function mssql_fetch_array() in C:\inetpub\wwwroot\rank.php on line 65
I tried to reinstall PHP (wasnt easy) but I got the same error. My guess is tehre is an extension or settings that is off. Anyone have an idea?
09/21/2011, 11:46
#2
elite*gold: 169
Join Date: Jul 2011
Posts: 395
Received Thanks: 261
Quote:
Call to undefined function mssql_fetch_array() in C:\inetpub\wwwroot\rank.php on line 65
Mean that your SQL Query don't work.
You do not have to reinstall your PHP, just have a look to your Querys..
Quote:
$row = mssql_fetch_array($result);
Better:
Quote:
$row = mssql_fetch_array($result);' $row[2]' ",$conn);
09/21/2011, 13:16
#3
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
now I get this lol
09/22/2011, 03:08
#4
elite*gold: 0
Join Date: Jun 2011
Posts: 108
Received Thanks: 269
not exactly shure without adding the line to one of my php scripts what is causeing the error as i am no master php coder but here is my PVP rank script fill free to use it if you like just change
---->(include "db_connect.php"; )<------ this section at top of quary to however you code your quarys to conect to your db.
PHP Code:
<?php
include "db_connect.php" ;
$count = 1 ;
$rank = 0 ;
$cimg = 0 ;
$kdr = 0 ;
$query = "SELECT top 25* FROM PS_GameData.dbo.Chars C INNER JOIN PS_UserData.dbo.Users_Master U ON U.UserUID = C.UserUID WHERE U.Status = 0 and C.Del = 0 ORDER BY k1 desc " ;
$result = mssql_query ( $query );
"<html><head><STYLE TYPE=\"text/css\">
;
"<body><center>
;
$row = mssql_fetch_array ( $result ))
$row [ 40 ] >= 200000 )
$rank = 16 ;
$row [ 40 ] >= 150000 )
$rank = 15 ;
$row [ 40 ] >= 130000 )
$rank = 14 ;
$row [ 40 ] >= 110000 )
$rank = 13 ;
$row [ 40 ] >= 90000 )
$rank = 12 ;
$row [ 40 ] >= 70000 )
$rank = 11 ;
$row [ 40 ] >= 50000 )
$rank = 10 ;
$row [ 40 ] >= 40000 )
$rank = 9 ;
$row [ 40 ] >= 30000 )
$rank = 8 ;
$row [ 40 ] >= 20000 )
$rank = 7 ;
$row [ 40 ] >= 10000 )
$rank = 6 ;
$row [ 40 ] >= 5000 )
$rank = 5 ;
$row [ 40 ] >= 1000 )
$rank = 4 ;
$row [ 40 ] >= 300 )
$rank = 3 ;
$row [ 40 ] >= 50 )
$rank = 2 ;
$row [ 40 ] >= 1 )
$rank = 1 ;
$rank = 0 ;
$row [ 41 ]=== 0 )
$kdr = number_format ( $row [ 40 ]/ 1 , 3 , '.' , '' );
$kdr = number_format ( $row [ 40 ]/ $row [ 41 ], 3 , '.' , '' );
"<tr style=\"color:white\">" ;
" <td> $count </td><td>" . $row [ 4 ] . "</td><td>" . $row [ 16 ] . "</td><td>" . $row [ 5 ] . "</td><td>" . $row [ 40 ] . "</td><td>" . $row [ 41 ] . "</td><td>" . $kdr . "</td><td> $rank </td>" ;
"</tr>" ;
$count ++;
"</table>" ;
"</html>" ;
?>
<?php
= 1 ;
$query = "SELECT top 25* FROM PS_GameData.dbo.Chars C INNER JOIN PS_UserData.dbo.Users_Master U ON U.UserUID = C.UserUID WHERE U.Status = 0 and C.Del = 0 and C.Level > 30 ORDER BY k1 desc " ;
$result = mssql_query ( $query );
"<html><head><STYLE TYPE=\"text/css\">
;
"<body><center>
;
$row = mssql_fetch_array ( $result ))
$row [ 40 ] >= 200000 )
$rank = 16 ;
$row [ 40 ] >= 150000 )
$rank = 15 ;
$row [ 40 ] >= 130000 )
$rank = 14 ;
$row [ 40 ] >= 110000 )
$rank = 13 ;
$row [ 40 ] >= 90000 )
$rank = 12 ;
$row [ 40 ] >= 70000 )
$rank = 11 ;
$row [ 40 ] >= 50000 )
$rank = 10 ;
$row [ 40 ] >= 40000 )
$rank = 9 ;
$row [ 40 ] >= 30000 )
$rank = 8 ;
$row [ 40 ] >= 20000 )
$rank = 7 ;
$row [ 40 ] >= 10000 )
$rank = 6 ;
$row [ 40 ] >= 5000 )
$rank = 5 ;
$row [ 40 ] >= 1000 )
$rank = 4 ;
$row [ 40 ] >= 300 )
$rank = 3 ;
$row [ 40 ] >= 50 )
$rank = 2 ;
$row [ 40 ] >= 1 )
$rank = 1 ;
$rank = 0 ;
$row [ 41 ]=== 0 )
$kdr = number_format ( $row [ 40 ]/ 1 , 3 , '.' , '' );
$kdr = number_format ( $row [ 40 ]/ $row [ 41 ], 3 , '.' , '' );
"<tr style=\"color:white\">" ;
"<td> $count1 </td><td>" . $row [ 4 ] . "</td><td>" . $row [ 16 ] . "</td><td>" . $row [ 5 ] . "</td><td>" . $row [ 40 ] . "</td><td>" . $row [ 41 ] . "</td><td>" . $kdr . "</td><td> $rank </td>" ;
"</tr>" ;
$count1 ++;
"</table>" ;
"</html>" ;
?>
<?php
= 1 ;
$query = "SELECT top 25* FROM PS_GameData.dbo.Chars C INNER JOIN PS_UserData.dbo.Users_Master U ON U.UserUID = C.UserUID WHERE U.Status = 0 and C.Del = 0 and C.Level = 30 ORDER BY k1 desc " ;
$result = mssql_query ( $query );
"<html><head><STYLE TYPE=\"text/css\">
;
"<body><center>
;
$row = mssql_fetch_array ( $result ))
$row [ 40 ] >= 200000 )
$rank = 16 ;
$row [ 40 ] >= 150000 )
$rank = 15 ;
$row [ 40 ] >= 130000 )
$rank = 14 ;
$row [ 40 ] >= 110000 )
$rank = 13 ;
$row [ 40 ] >= 90000 )
$rank = 12 ;
$row [ 40 ] >= 70000 )
$rank = 11 ;
$row [ 40 ] >= 50000 )
$rank = 10 ;
$row [ 40 ] >= 40000 )
$rank = 9 ;
$row [ 40 ] >= 30000 )
$rank = 8 ;
$row [ 40 ] >= 20000 )
$rank = 7 ;
$row [ 40 ] >= 10000 )
$rank = 6 ;
$row [ 40 ] >= 5000 )
$rank = 5 ;
$row [ 40 ] >= 1000 )
$rank = 4 ;
$row [ 40 ] >= 300 )
$rank = 3 ;
$row [ 40 ] >= 50 )
$rank = 2 ;
$row [ 40 ] >= 1 )
$rank = 1 ;
$rank = 0 ;
$row [ 41 ]=== 0 )
$kdr = number_format ( $row [ 40 ]/ 1 , 3 , '.' , '' );
$kdr = number_format ( $row [ 40 ]/ $row [ 41 ], 3 , '.' , '' );
"<tr style=\"color:white\">" ;
"<td> $count2 </td><td>" . $row [ 4 ] . "</td><td>" . $row [ 16 ] . "</td><td>" . $row [ 5 ] . "</td><td>" . $row [ 40 ] . "</td><td>" . $row [ 41 ] . "</td><td>" . $kdr . "</td><td> $rank </td>" ;
"</tr>" ;
$count2 ++;
"</table>" ;
"</html>" ;
?>
<?php
= 1 ;
$query = "SELECT top 25* FROM PS_GameData.dbo.Chars C INNER JOIN PS_UserData.dbo.Users_Master U ON U.UserUID = C.UserUID WHERE U.Status = 0 and C.Del = 0 and C.Level < 16 ORDER BY k1 desc " ;
$result = mssql_query ( $query );
"<html><head><STYLE TYPE=\"text/css\">
;
"<body><center>
;
$row = mssql_fetch_array ( $result ))
$row [ 40 ] >= 200000 )
$rank = 16 ;
$row [ 40 ] >= 150000 )
$rank = 15 ;
$row [ 40 ] >= 130000 )
$rank = 14 ;
$row [ 40 ] >= 110000 )
$rank = 13 ;
$row [ 40 ] >= 90000 )
$rank = 12 ;
$row [ 40 ] >= 70000 )
$rank = 11 ;
$row [ 40 ] >= 50000 )
$rank = 10 ;
$row [ 40 ] >= 40000 )
$rank = 9 ;
$row [ 40 ] >= 30000 )
$rank = 8 ;
$row [ 40 ] >= 20000 )
$rank = 7 ;
$row [ 40 ] >= 10000 )
$rank = 6 ;
$row [ 40 ] >= 5000 )
$rank = 5 ;
$row [ 40 ] >= 1000 )
$rank = 4 ;
$row [ 40 ] >= 300 )
$rank = 3 ;
$row [ 40 ] >= 50 )
$rank = 2 ;
$row [ 40 ] >= 1 )
$rank = 1 ;
$rank = 0 ;
$row [ 41 ]=== 0 )
$kdr = number_format ( $row [ 40 ]/ 1 , 3 , '.' , '' );
$kdr = number_format ( $row [ 40 ]/ $row [ 41 ], 3 , '.' , '' );
"<tr style=\"color:white\">" ;
"<td> $count3 </td><td>" . $row [ 4 ] . "</td><td>" . $row [ 16 ] . "</td><td>" . $row [ 5 ] . "</td><td>" . $row [ 40 ] . "</td><td>" . $row [ 41 ] . "</td><td>" . $kdr . "</td><td> $rank </td>" ;
"</tr>" ;
$count3 ++;
"</table>" ;
"</html>" ;
?>
this one actyaly calls 4 difrent sets of ranks 1 for overall 1 for lvl 70 1 for lvl 30 and 1 for lvl 15 and displaye all in sepret sets on the page
09/22/2011, 11:42
#5
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
Found out it was an extension error but its not fixed yet... might have to reboot the server then it needs to wait for next maint/update. I didnt have the mssql.dll extension.
All times are GMT +2. The time now is 01:54 .
![[ADMIN]Cryptic's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar3857950_1.gif){kind=avatar}
![[ADMIN]Cryptic is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
