Printable View
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 ?
are you using v16 files?
I'm using Etioom's rev 7 Files. Is it a problem ?
No one have the solution ?
the CCU value is the count of how many people are online. have you tried logging in 2 characters?
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.
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.
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
Quote:
Originally Posted by ShadowDragon42
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.Quote:
Originally Posted by Spitfire76
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.
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
Rofl then Use the first method u nigger...Quote:
Originally Posted by Spitfire76
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 ShadowDragon42
I tried this too, the value in "isuse" column stay at T.Quote:
Originally Posted by Jomex
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
: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..Quote:
Originally Posted by theliteyes
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
Thanks a lot ! With this new databse, all works !
cool, nice to know what the cause was