yo, i got a problem:
Code:Warning : mssql_query() [function.mssql-query]: message: Invalid column name 'Opened'. (severity 16) in C:\AppServ\www\stats\playerstat.php on line 2 Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\stats\playerstat.php on line 2 Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\stats\playerstat.php on line 4]
Looks like it cant find the serverstatus , this is my playerstat.php:
My Serverstatus.dbo only shows 4 rows:Code:<? $res = mssql_query("SELECT * FROM ServerStatus WHERE Opened = '1'"); $servercount = 0; while($srv = mssql_fetch_assoc($res)){ $servercount = $servercount + $srv['CurrPlayer']; } function Acortar($cadena){ return substr($cadena,0,12) ."..."; } ?><body topmargin="0"> <table width="400" height="75" border="0" align="center" background="img/bn_onpl.png" style="background-repeat:no-repeat; opacity:0.9;filter:alpha(opacity=90)"> <tr> <td width="47"></td> <td width="39"></td> <td width="22"></td> <td width="204"></td> </tr> <tr> <td></td> <td><span class="Estilo2"> <?=$servercount?> </span></td> <td></td> <td><span class="Estilo2">Player's Online //</span></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> </table> </body>
ServerID/ServerName/PlayerCount/MaxPlayer.
I got this file/website from: X-Weaver.
Anyone know a fix? (Server does not show up either in login screen)
Reply With Quote
