MVCore 0 online players.

[itaialroy]

I've had that donation problem with MuCore 1.0.8, so I switched to MVCore.
Everything's working fine there, except that even when people are logged in, it shows 0 online players.
GS port is good, how can I fix that?

[MentaL]

[KarLi]

show us the script/file (php) that shows how many players are online

[itaialroy]

show us the script/file (php) that shows how many players are online

$sql = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = 1");
?>
<?php if($_SESSION['db_in_use'] == '1') { ?>
<div id="srv-0">
<p>Status:<span><?php if ($check=@fsockopen($mvcore['db_host'],$mvcore['gs_port_1'],$ERROR_NO,$ERROR_STR,(float)0.2)) { fclose($check); $server_s = '<font color="green">Online</font>'; }else { $server_s = '<font color="red">Offline</font>'; } echo''.$server_s.''; ?></span></p>
<p>Server:<span><?php echo $mvcore['s_name_1'];?></span></p>
<p>In Game:<span><?php echo $acr1;?></span></p>
<p>Top Player:<span><?php echo''.$checked_user_top.'';?></span></p>
<p>Top Guild:<span><?php echo''.$checked_guild_top.'';?></span></p>
</div>
<?php } ?>
<?php if($_SESSION['db_in_use'] == '2') { ?>
<div id="srv-1">
<p>Status:<span><?php if ($check=@fsockopen($mvcore['db_host'],$mvcore['gs_port_2'],$ERROR_NO,$ERROR_STR,(float)0.2)) { fclose($check); $server_s = '<font color="green">Online</font>'; }else { $server_s = '<font color="red">Offline</font>'; } echo''.$server_s.''; ?></span></p>
<p>Server:<span><?php echo $mvcore['s_name_2'];?></span></p>
<p>In Game:<span><?php echo $acr1;?></span></p>
<p>Top Player:<span><?php echo''.$checked_user_top.'';?></span></p>
<p>Top Guild:<span><?php echo''.$checked_guild_top.'';?></span></p>
</div>
<?php } ?>
<?php if($_SESSION['db_in_use'] == '3') { ?>
<div id="srv-2">
<p>Status:<span><?php if ($check=@fsockopen($mvcore['db_host'],$mvcore['gs_port_3'],$ERROR_NO,$ERROR_STR,(float)0.2)) { fclose($check); $server_s = '<font color="green">Online</font>'; }else { $server_s = '<font color="red">Offline</font>'; } echo''.$server_s.''; ?></span></p>
<p>Server:<span><?php echo $mvcore['s_name_3'];?></span></p>
<p>In Game:<span><?php echo $acr1;?></span></p>
<p>Top Player:<span><?php echo''.$checked_user_top.'';?></span></p>
<p>Top Guild:<span><?php echo''.$checked_guild_top.'';?></span></p>
</div>
<?php } ?>
<p>Server Time:<span><span id="timecontainer"></span><script type="text/javascript">new showLocalTime("timecontainer", "server-php", 0, "short")</script></span></p>
</div>
</div>

I believe it's this one. I'm using database 1.

I returned all "Memb_Stat" rows, and they were all empty, even when people are on. maybe that can help...
MuCore showed correctly how many are on btw.

[itaialroy]

show us the script/file (php) that shows how many players are online

Nevermind I fixed it.
I just had to recreate the table Memb_Stat

[itaialroy]

how to fix it?

Recreate the table Memb_Stat and the procedures connected to it.
Use this tut : http://forum.ragezone.com/f196/fix-memb_stat-410099/