RevCMS - Online Players Bug

[Blasteh]

Hello RZ,
When I first setup this CMS, it was displaying players online, now it's not for some reason. Yes, the emulator is running and I am online. (I'm using Sledmores Plus Emulator, with the latest Database, swfs, etc)

You must be registered for see images attach

Any fix?

 

[Wickd]

Depends from what table is the cms grabbing data.

 

[Berk]

(I'm using Sledmores Plus Emulator, with the latest Database, swfs, etc)

can you pm or skype them please if they are working please?

 

[Zac]

This is caused by your server_status table.

 

[Yadz]

The mysql query might be wrong, post it here and I'll check it for you.

 

[Modo]

{online} grabs the info from server_status table, problem is PlusEMU does not send anything to that table. I'm sure there is an easier way that this but what I did was made a PHP file called online.php

<?php
    $con = mysql_connect("localhost","root","password");
    mysql_select_db("newdb", $con);

    $q = mysql_query("select online, count(*) from users group by online;");
    $row = mysql_fetch_assoc($q);
    echo $row['online'];
?>

 

[Blasteh]

can you pm or skype them please if they are working please?

Use google...

The mysql query might be wrong, post it here and I'll check it for you.

Where do I find that?

{online} grabs the info from server_status table, problem is PlusEMU does not send anything to that table. I'm sure there is an easier way that this but what I did was made a PHP file called online.php

<?php
    $con = mysql_connect("localhost","root","password");
    mysql_select_db("newdb", $con);

    $q = mysql_query("select online, count(*) from users group by online;");
    $row = mysql_fetch_assoc($q);
    echo $row['online'];
?>

Where would I put this? Just create a online.php?

Edit: Not sure if this is a factor or not, but in server_status, when players are online, it doesn't update when I refresh the database.

You must be registered for see images attach

 

[Zac]

PlusEMU does send information to the server_status table to be able to grab the {online} but you're just using the wrong database. Download the boon.sql from this link;

You must be registered for see links

and then add {online} to your header/pages.

 

[Blasteh]

PlusEMU does send information to the server_status table to be able to grab the {online} but you're just using the wrong database. Download the boon.sql from this link;

You must be registered for see links

and then add {online} to your header/pages.

Will this overwrite any data? And to clear things up, it was working at first, then suddenly just stopped working. So there's nothing really wrong with my database, it's the database that Sledmore provided with his Emulator.

 

[Zac]

I would just create a new database and then test it that way. If it shows the amount of users online then you know that it was your old database or the emulator causing a bug.

 

[Blasteh]

I would just create a new database and then test it that way. If it shows the amount of users online then you know that it was your old database or the emulator causing a bug.

That database you provided doesn't even import, a lot of errors.

 

[Kods]

If you're using RevCMS it's due to the emulator not updating your server_status table, inside app/class.core.php you will find final public function getOnline() from there change the query to not get the online status from your server_status table.

 

[Blasteh]

If you're using RevCMS it's due to the emulator not updating your server_status table, inside app/class.core.php you will find final public function getOnline() from there change the query to not get the online status from your server_status table.

Where would I set it to get it from?

    final public function getOnline()
    {
        global $engine;
        return $engine->result("SELECT users_online FROM server_status");
    }

 

[Kods]

I'm pretty weak with MySQL and PHP so here's me having a shot at it.

    final public function getOnline()
    {
        global $engine;
        return $engine->result("SELECT online FROM users WHERE online='0'");
    }

If you keep getting problems private message me your Skype? I can reply faster there.

 

[MadMonsterMan]

Drop the table "server_status"
And import this into your database after deleting the table "server_status":

CREATE TABLE `server_status` (
  `users_online` int(11) NOT NULL DEFAULT '0',
  `loaded_rooms` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Data dump for tabellen `server_status`
--

INSERT INTO `server_status` (`users_online`, `loaded_rooms`) VALUES
(0, 0);

This SQL came straight from the boon.sql this will fix your problem.

 

[iGlenn]

Drop the table "server_status"
And import this into your database after deleting the table "server_status":

CREATE TABLE `server_status` (
  `users_online` int(11) NOT NULL DEFAULT '0',
  `loaded_rooms` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Data dump for tabellen `server_status`
--

INSERT INTO `server_status` (`users_online`, `loaded_rooms`) VALUES
(0, 0);

This SQL came straight from the boon.sql this will fix your problem.

worked, you're a lifesaver