Player Online Count Script
Hello,
I'm doing a website for my flyff private server and I want show the amount of online players.
To do this, I used this guide : http://forum.ragezone.com/f457/playe...t-bugs-772109/
But $mssql stay at 0. I gone in Microsoft SQL Server and I saw that the value in MultiServer column stay at 0.
World server's CCU value change (it's 0 or 1 when I login) but MultiServer stay at 0.
Can someone help me ?
Re: Player Online Count Script
Re: Player Online Count Script
I'm using Etioom's rev 7 Files. Is it a problem ?
Re: Player Online Count Script
No one have the solution ?
Re: Player Online Count Script
the CCU value is the count of how many people are online. have you tried logging in 2 characters?
Re: Player Online Count Script
Yes, I have CCU:2, but the value MultiServer doesn't change in CHARACTER_TBL, so, I can't insert a Player Online Count module in my server.
Re: Player Online Count Script
No one now ? The problem is easy to understand : MultiServer value doesn't change in CHARACTER_TBL. So, $mssql (from this guide) return 0, even if characters are logged on.
Re: Player Online Count Script
omg you are so stupid..
I'm going to say this in all caps so you'll understand
THE CCU VALUE IS THE PLAYERS ONLINE COUNT
the script checks how many players in the database have a MultiServer value that ISN'T 0. a MultiServer value of 1 means that character is online on server 1. a value of 2 means they're on server 2. and so on. if a player has a MultiServer value of 0, that means they're offline.
once again, I will say this in all caps
SINCE A MULTISERVER VALUE OF 0 MEANS THEY'RE OFFLINE, CHECKING HOW MANY CHARACTERS HAVE A MULTISERVER VALUE THAT ISN'T 0 IS HOW YOU FIND THE PLAYERS ONLINE COUNT
1 Attachment(s)
Re: Player Online Count Script
Quote:
Originally Posted by
ShadowDragon42
the CCU value is the count of how many people are online. have you tried logging in 2 characters?
Quote:
Originally Posted by
Spitfire76
Yes, I have CCU:2, but the value MultiServer doesn't change in CHARACTER_TBL, so, I can't insert a Player Online Count module in my server.
The CCU value which is in WorldServer Window change. (0 when no one is logged on, 1 when a player is connected, 2 when they are two players ...) BUT MultiServer doesn't change.
When I login, MultiServer DOESN'T change.
1 character is logged on :
- WorldServer return 1
- Multi server doesn't return 1 on logged-character's line, it stay at 0.
Re: Player Online Count Script
omg, you are so stupid. after logging in, have you tried closing the character table, right-clicking it and clicking refresh, then reopening the character table?
besides, the CCU value I was talking about, is the one referred to in the website script. not the one that shows in world server window
Re: Player Online Count Script
Quote:
Originally Posted by
Spitfire76
- Multi server doesn't return 1 on logged-character's line, it stay at 0.
Rofl then Use the first method u nigger...
Re: Player Online Count Script
Quote:
Originally Posted by
ShadowDragon42
omg, you are so stupid. after logging in, have you tried closing the character table, right-clicking it and clicking refresh, then reopening the character table?
besides, the CCU value I was talking about, is the one referred to in the website script. not the one that shows in world server window
Please, stop saying that i am stupid. I refreshed the table many times but the value doesn't change. I have the same problem that him, I think.
Quote:
Originally Posted by
Jomex
Rofl then Use the first method u nigger...
I tried this too, the value in "isuse" column stay at T.
Re: Player Online Count Script
well then, I don't know if the problem is your source files or your database, but the stored procedure CHARACTER_01_DBF.dbo.uspChangeMultiServer is not getting run, cause that's what updates MultiServer and isuse columns
I suggest using this database (it's the one I'm using): http://forum.ragezone.com/f457/aio-o...v15-v3-697494/
Quick note: Open that with MSSQL Server Management Studio and run the query. It will clear all your databases though..
If that doesn't fix the problem, then it's your source files
Re: Player Online Count Script
:scared:
i don't know the flyff db so do it at this example
from example
PHP Code:
$online = mssql_fetch_array (mssql_query ("SELECT COUNT(*) FROM users WHERE online=1") );
echo $online[0]
Re: Player Online Count Script
Quote:
Originally Posted by
theliteyes
:scared:
i don't know the flyff db so do it at this example
from example
PHP Code:
$online = mssql_fetch_array (mssql_query ("SELECT COUNT(*) FROM users WHERE online=1") );
echo $online[0]
read the first post..
he posted the link for where the php script is
he's having a problem with it though, which is either caused by his server/source files or his db
Re: Player Online Count Script
Thanks a lot ! With this new databse, all works !
Re: Player Online Count Script
cool, nice to know what the cause was