Author Topic: Online Active Users (Read 23141 times)

Exodus00FF · « **on:** May 12, 2010, 09:53:27 pm »

In the last few months I began developing a module which is activated by cron, which uploads a list of active online users to a website rpc server. This is not complete code, but it is the begging of a new project.

Attached to this post are 4 Files.

To begin installation you have to start with the rpc_server.zip file.

Begin by unzipping it to your where you host your php based website.
- I recommend placing the contents in a sub-folder named like xmlrpc.
Run the install.sql against your MySQL Database.
Set the Following Variables in your server.php file.
- $dbserver
- $db
- $dbuser
- $dbpassword

Now you should be able to Start Testing it.

Unzip the rpc_testclient.zip somewhere and make Change the following 2 Variables.
- $site = "Domain of where you have server.php installed"
- $location = "Absolute Path to where you have server.php installed including the leading slash"
  - /xmlrpc/server.php

If everthing works fine it you can move on to loading the Bebot Module

Just copy ActiveUsers.php to your modules/aoc directory.
- Restart the Bot
- Change the Site and Locations Settings
Now the bot should be uploading to the RPC server every 300 seconds.

Now the tricky part for those of you who don't use joomla. I'm providing the fourth part as a joomla mod. For any of you who are coders you shouldn't have any issues converting this into a module that will work with your website, others might have more problems if they don't know php, html, or sql.

Feel free to modify the code, and repost it here, and I'll update this post as modifications occur. Bear in mind this is an unfinished project.

Streak · « **Reply #1 on:** May 19, 2010, 04:20:37 pm »

For a simple Namelisting to be used in e.g. Burning Board just create a new PHP-Box,
copy this code and enter your user variables. Or copy this Code into whatever you are using.

<?

                          $hostname = "localhost";
                           $username = "username";
                          $password = "password";
                           $dbname = "yourDB";

                             mysql_pconnect ($hostname,$username,$password) or DIE ("not Connected");

                             mysql_select_db ($dbname) or DIE ("Database not found");


                             $query = "select * from bebot_users where is_online=1";
                             $result = mysql_query($query) or die ("Query died! Poor Query");



while ( $row = mysql_fetch_row ( $result ) )
{

echo $row[1] . '<br>';

}

?>

Kyr · « **Reply #2 on:** May 19, 2010, 08:51:44 pm »

I would love to have a way to access this list from guildlaunch.

Exodus00FF · « **Reply #3 on:** May 25, 2010, 11:36:36 pm »

Streak That only works if your Bot and Website are hosted on the Same Box or have access to the same database. This is for when your setup has your Bot on a VPS (Virtual Private Server) or local machine b/c your ISP does not allow you to use IRC Bots.

knutarn · « **Reply #4 on:** May 27, 2010, 04:45:12 pm »

Quote from: Streak on May 19, 2010, 04:20:37 pm

For a simple Namelisting to be used in e.g. Burning Board just create a new PHP-Box,
copy this code and enter your user variables. Or copy this Code into whatever you are using.

<?

                          $hostname = "localhost";
                           $username = "username";
                          $password = "password";
                           $dbname = "yourDB";

                             mysql_pconnect ($hostname,$username,$password) or DIE ("not Connected");

                             mysql_select_db ($dbname) or DIE ("Database not found");


                             $query = "select * from bebot_users where is_online=1";
                             $result = mysql_query($query) or die ("Query died! Poor Query");



while ( $row = mysql_fetch_row ( $result ) )
{

echo $row[1] . '<br>';

}

?>

Hi can you put rank on it? (Member,Officer,Guild Leader)

Riccarr · « **Reply #5 on:** May 27, 2010, 10:52:24 pm »

Quote from: Exodus00FF on May 25, 2010, 11:36:36 pm

Streak That only works if your Bot and Website are hosted on the Same Box or have access to the same database. This is for when your setup has your Bot on a VPS (Virtual Private Server) or local machine b/c your ISP does not allow you to use IRC Bots.

Well, if your of a mind to, you can open a port on your local bot machine (where database is) and connect/query it from the php/web server for live query when the page is hit. Your host connection just needs to include IP and port ...

$hostname = 'xxx.xxx.xxx.xxx:3306'

MrHaugen · « **Reply #6 on:** June 28, 2010, 12:09:51 pm »

Quote from: Riccarr on May 27, 2010, 10:52:24 pm

Quote from: Exodus00FF on May 25, 2010, 11:36:36 pm
Streak That only works if your Bot and Website are hosted on the Same Box or have access to the same database. This is for when your setup has your Bot on a VPS (Virtual Private Server) or local machine b/c your ISP does not allow you to use IRC Bots.

Well, if your of a mind to, you can open a port on your local bot machine (where database is) and connect/query it from the php/web server for live query when the page is hit. Your host connection just needs to include IP and port ...

$hostname = 'xxx.xxx.xxx.xxx:3306'

Perfect! I'll test it as soon as I can.

SudL · « **Reply #7 on:** July 07, 2010, 06:37:12 pm »

i forgott:
with the code from Streak:
there is a problem, when the bot is not online,
the forum is not reachable.

can anyone fix this problem?

thx

Drizzurdeen · « **Reply #8 on:** July 10, 2010, 01:37:45 am »

kk just some questions

i tried to test this but there must be a mistake between my two ears

here my configs
1.

Code: [Select]

/* Define variables to find the rpc server script */
$site = "http://gilde-obsidiancult.de/";
$location = "/srv/www/vhosts/gilde-obsidiancult.de/httpdocs/testumgebung/server.php";

all the files are in one directory ... called testumgebung the link would be http://gilde-osbsidiancult.de/testumgebung

i use joomla
when u look at http://gilde-obsidiancult.de there u will see the mod on the left side but no active user -.-
the bot should be configured correctly ... so i hope

here the log when u look at tes_client

Code: [Select]

Names
array(1) {
  [0]=>
  array(2) {
    [0]=>
    string(14) "XMLRPC_request"
    [1]=>
    string(1808) "

Received the following parameter list to send:

Array
(
    [0] => Array
        (
            [array] => Array
                (
                    [data] => Array
                        (
                            [value] => Array
                                (
                                    [0] => Array
                                        (
                                            [string] => Name1
                                        )

                                    [1] => Array
                                        (
                                            [string] => Name2
                                        )

                                    [2] => Array
                                        (
                                            [string] => Name3
                                        )

                                    [3] => Array
                                        (
                                            [string] => Name4
                                        )

                                    [4] => Array
                                        (
                                            [string] => Name5
                                        )

                                    [5] => Array
                                        (
                                            [string] => Name6
                                        )

                                    [6] => Array
                                        (
                                            [string] => Name7
                                        )

                                )

                        )

                )

        )

)


"
  }
}
Success
bool(false)
Response
array(2) {
  ["faultCode"]=>
  int(10532)
  ["faultString"]=>
  string(56) "Connection failed: Couldn't make the connection to http."
}

kk don't know where is the mistake ...

maybee the db is the reason ... couse we don't use bebot_users ... we use for example cultmeister_users and instead of alts we use just alts don't know if this would be case a confligt of ur mod ...

help would be nice ...

greetz drizz

WeZoN · « **Reply #9 on:** July 22, 2010, 09:52:33 pm »

I get this aswell

Warning: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: No such host is known. in "directory"\kd_xmlrpc.php on line 382

Warning: fsockopen() [function.fsockopen]: unable to connect to http:80 (php_network_getaddresses: getaddrinfo failed: No such host is known. ) in "directory"\xmlrpc\kd_xmlrpc.php on line 382

EDIT:

nvm.. i removed http:// in $site and it worked..

Drizzurdeen · « **Reply #10 on:** July 23, 2010, 10:57:34 am »

Quote

i removed http:// in $site and it worked..

doesn't work by me ...

Argothep · « **Reply #11 on:** August 30, 2010, 03:28:46 pm »

Can't get this running as well...

See my test-client here: http://2010.newrising.org/bebotmodul/test-client.php
The bot itself is running on my HD and working as intended, but if I copy the ActiveUsers.php in the modules directory and want to get the mod running, I get an error in the bot:

Warning: fsockopen(): php_network_getadresses: getaddrinfo failed: Der angegebene Host ist unbekannt. in C:\Users\MyUsername\Desktop\BeBot_Folder\modules\aoc\ActiveUsers.php on line 549

Warning: fsockopen(): unable to connect to http:80 (php_network_getadresses: getaddrinfo failed: Der angegebene Host ist unbekannt. ) in C:\Users\MyUsername\Desktop\BeBot_Folder\modules\aoc\ActiveUsers.php on line 549

Any ideas about a solution?

Regards

Khalem · « **Reply #12 on:** August 30, 2010, 09:34:32 pm »

Quote

Warning: fsockopen(): php_network_getadresses: getaddrinfo failed: Der angegebene Host ist unbekannt. in C:\Users\MyUsername\Desktop\BeBot_Folder\modules\aoc\ActiveUsers.php on line 549

Warning: fsockopen(): unable to connect to http:80 (php_network_getadresses: getaddrinfo failed: Der angegebene Host ist unbekannt. ) in C:\Users\MyUsername\Desktop\BeBot_Folder\modules\aoc\ActiveUsers.php on line 549

The script is reporting that it fails to lookup the server address given. And for some reason it has been told to lookup http:80 which obviously is not a valid address.

From a brief glance at the script, check your settings for domain and location for the activeuser module.

Argothep · « **Reply #13 on:** August 30, 2010, 11:56:00 pm »

Code: [Select]

	  $this -> bot -> core("settings") -> create("activeusers", "domain", "http://2010.newrising.org", "Domain to which the RPC Call will be made");
	  $this -> bot -> core("settings") -> create("activeusers", "location", "/bebotmodul/server.php", "Absolute Path to server.php");

Looks ok to me, any ideas?

Regards

Khalem · « **Reply #14 on:** September 01, 2010, 02:42:03 pm »

Changing info in the php file will only work if the setting does not exist on the bot.

You need to use the ingame !settings activeusers interface.

Author Topic: Online Active Users (Read 23141 times)

Exodus00FF

Online Active Users

Streak

Re: Online Active Users

Kyr

Re: Online Active Users

Exodus00FF

Re: Online Active Users

knutarn

Re: Online Active Users

Riccarr

Re: Online Active Users

MrHaugen

Re: Online Active Users

SudL

Re: Online Active Users

Drizzurdeen

Re: Online Active Users

WeZoN

Re: Online Active Users

Drizzurdeen

Re: Online Active Users

Argothep

Re: Online Active Users

Khalem

Re: Online Active Users

Argothep

Re: Online Active Users

Khalem

Re: Online Active Users