Need help with Online count [WEBSITE]

[laitila]

Alright so i have a problem with my online count. i use the sapphire 2.2 website

as you see here my world server has 1 player connected but the website doesn't show any players online. this is the script



$_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] > 1'), 'OnlineCount');


is theres something wrong? please website coders help me

[Sedrika]

Change [MultiServer] > 1 to [MultiServer] != 0

[laitila]

Originally Posted by Sedrika

Change [MultiServer] > 1 to [MultiServer] != 0

Thanks for replying but no it didn't work

$_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 else should i try:/? can it be something wrong in the database?

[Aspire7730]

$_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');

Change the red marked != to this > if you still have your Problem

[XYZ-Cannon]

Originally Posted by Aspire7730

Change the red marked != to this > if you still have your Problem

Doesn't make a difference.

[xTwiLightx]

Originally Posted by XYZ-Cannon

Doesn't make a difference.

It does in logic, because with > 1 there will be only shown the usercount of users in channels greater than 1 (which lots of servers don't even have) - != (or even > 0) is the right choice.

Originally Posted by laitila

Thanks for replying but no it didn't work

$_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 else should i try:/? can it be something wrong in the database?

Remove the @'s in that statement (@ suppresses errors in PHP functions) - the query itself looks fine.

[XYZ-Cannon]

Originally Posted by xTwiLightx

It does in logic, because with > 1 there will be only shown the usercount of users in channels greater than 1 (which lots of servers don't even have) - != (or even > 0) is the right choice.



Remove the @'s in that statement (@ suppresses errors in PHP functions) - the query itself looks fine.

You should look whom I quoted. I said between != 0 and > 0 is no difference in that function.

[xTwiLightx]

Originally Posted by XYZ-Cannon

You should look whom I quoted. I said between != 0 and > 0 is no difference in that function.

If the MultiServer is negative, e.g. -1 (which won't happen, I know), it will also count. But while programming we should always be precise with what we want to achieve.

So to be exact, there IS a difference, even if it won't be noticed at all.

[XYZ-Cannon]

Originally Posted by xTwiLightx

If the MultiServer is negative, e.g. -1 (which won't happen, I know), it will also count. But while programming we should always be precise with what we want to achieve.

So to be exact, there IS a difference, even if it won't be noticed at all.

That's why I wrote in this function. Things which will never happen shouldn't be implemented, otherwise you would programm thousands of lines of code for an easy function.