[Help] Website Online Count

[TheRealMadara]

Hello! greetings epvp. there is a problem with my online count in website. its not going up. it always says zero. I investigated the inc files.


and this is the code. from website online count
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');

<td>Online User:</td>
<td><?php echo odbc_result($online, 'count'); ?></td>

then. I go to my database in account_dbf. I check the isuse. and all are T even tho I am online.
also, the multiverse in character_table always stay at zero. even tho im online. omg.

what to do with this? thanks guys!

[xTwiLightx]

Better use the Multiserver column in the CHARACTER_TBL of the CHARACTER_01_DBF.

[TheRealMadara]

Originally Posted by xTwiLightx

Better use the Multiserver column in the CHARACTER_TBL of the CHARACTER_01_DBF.

Hello xTwilight! thanks for the reply, I checked the multiserver column in CHARACTER_TBL. it always stays at 0 even when im logged in or logged out. any clue on why that is? thanks again!

[Tamus]

Originally Posted by TheRealMadara

Hello xTwilight! thanks for the reply, I checked the multiserver column in CHARACTER_TBL. it always stays at 0 even when im logged in or logged out. any clue on why that is? thanks again!

check your function if its local ip or online ip

[TheRealMadara]

Originally Posted by Tamus

check your function if its local ip or online ip

thanks for the reply tamus. what file do I need to check for the ip? thanks

[aqwp]

Use this

[TheRealMadara]

Originally Posted by aqwp

Use this

Thanks. I will try to run this script in my database and update you what hapenned

Lifesaver man! it worked for me! you got my thanks!

[aqwp]

You're welcome, had this issue myself a while back, cost me some days to find out where the issue came from aswell.

[Tamus]

Originally Posted by TheRealMadara

thanks for the reply tamus. what file do I need to check for the ip? thanks

here

PHP Code:

    $_CONFIG['allg_user_online'] =  [MENTION=311501]ODB[/MENTION]c_result [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, 'SELECT     COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0'), 'OnlineCount'); 


[Wezzy_Dev]

Originally Posted by TheRealMadara

Hello! greetings epvp. there is a problem with my online count in website. its not going up. it always says zero. I investigated the inc files.


and this is the code. from website online count
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');

<td>Online User:</td>
<td><?php echo odbc_result($online, 'count'); ?></td>

then. I go to my database in account_dbf. I check the isuse. and all are T even tho I am online.
also, the multiverse in character_table always stay at zero. even tho im online. omg.

what to do with this? thanks guys!

ONLINE COUNT PHP CODE

 Spoiler

$onlineplayer = odbc_exec($odbc_connect, 'SELECT COUNT([m_szName]) as count FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0 AND [isblock] != \'D\'');

$c = odbc_result($onlineplayer, 'count');

echo = $c;

[Tamus]

Originally Posted by Wezzy_Dev

ONLINE COUNT PHP CODE

 Spoiler

$onlineplayer = odbc_exec($odbc_connect, 'SELECT COUNT([m_szName]) as count FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0 AND [isblock] != \'D\'');

$c = odbc_result($onlineplayer, 'count');

echo = $c;

welcome back rjay bacaya

[rdenheijer]

i begin to wonder if this is right or wrong and/or i miss something
$_CONFIG['allg_user_online'] = odbc_result(odbc_exec($odbc_connect, 'SELECT COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] !=0; '), 'OnlineCount');

what ever i do its stay 0 also in the sql manager is see multiserver but stays 0

Originally Posted by Tamus

here

PHP Code:

    $_CONFIG['allg_user_online'] =   [MENTION=311501]ODB[/MENTION]c_result  [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, 'SELECT     COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0'), 'OnlineCount'); 


if have try this however am sorry but it doesnt work
i have this: $_CONFIG['allg_user_online'] = odbc_result(odbc_exec($odbc_connect, 'SELECT COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] !=0; '), 'OnlineCount');
and player online well still 0

okay i tryed this $_CONFIG['allg_user_online'] = @c_result @c_exec($odbc_connect, 'SELECT COUNT([MultiServer]) as OnlineCount FROM [' . $_CONFIG['db_databases']['chr'] . '].[dbo].[CHARACTER_TBL] WHERE [MultiServer] > 0'), 'OnlineCount');
but got this error : Parse error: syntax error, unexpected '=', expecting ']' in C:\xampp\htdocs\includes\xinc_config.php on line 76