Users in IRC - with eggdrop. html access

################################################## #########
Users in IRC - with eggdrop. html access
Tested on vB 2.2.5 and 2.2.9
Hack Verson: 2.0.2 Beta
################################################## #########


This hack is an enhanced version of the one by sas1911 - details of which can be found here
https://vborg.vbsupport.ru/showthrea...threadid=40855

This hack uses an eggdrop bot to provide information to vB about who is online.
NEW IN BETA 2
This hack now comes in two main flavours on the bot side.
1) writes the user list to a local file, vB then can access it local (if the bot is on the vB server)
or the file can be access remotely via http
2) This is the new bit, the bot now has the ability to contact the server directly via http (using the http tcl library)
- more on the vB side later - it updates when someone joins the channel, changes nick and after a set period of time

On the vB side the two main choices are...
1) simple display of user names with the ability to hide certain users, ie the bot. also allows a '_' or whatever at the
end of a nick to show the user is offline
2) Accesses the user DB to try to match the user 1st by bot handle, then nick, user name (host) and link them the same way
as online forum users. it will also hide users if their forum invisible setting is turned on.
it provides the same overides as the first script as well as additional flags of [me] (overide the db lookup) and
[on](override the invisible flag)

The callhome script needs an access code that you set in both the bot and the script as well as the ip range for the bot.
if the access code and the ip range don't the script will give the user a 404 error - see instructions

The script for index.php has the two subsets for either a local file or remote file.
each different flavor for the index file i have placed in seperate files, so please read that file for install instructions


All files are included as well as the old ver 1 of this hack.

Known bugs:
None at the moment

Known quirks:
With using the db, online users number may display higher then the list of users displayed, but vB works the same way,
if this really bugs people I'll tweak it.
Sometimes the the script just doesn't get the user right - again db lookup, my solve for this is regular users I add to the bot, if there is enough interest I'll do a user cp hack or something
to either get vB to contact the bot and add the user, (and handle to the bot) or hack a way around so that the user can register
their nick and/or user name (host) into the db

TODO:
anything anyone suggests thats reasonable

Fixed Bugs:
Resolved the Excess db queries, now its only 1 query 2.0.1
Fixed a bug where it would hang if the server went offline or refused to answer, now set at a 7 second time out.
Fixed a small glitch where the script showed a warning if the file was unreachable.
- refixed this glitch should all be working now. 1.1.2
Multiple instances of the timer bug resolved. 1.1.1


Added functions:
See above for main changes to ver 2
Now strips all php and html tags from the file - just to be on the safe side.
Added commas after names

Modified files
2.0.2 index.php only
2.0.1 Both db access scripts have been updated
2.0.0 All files need to be updated
1.2.0 index.php only
1.1.2 index.php only
1.1.1 index.php only
1.1 usc.tcl only

You can see this hack in action at MURC
Thanks for you time, any questions/ideas/sugestions please don't hesitate to contact me via pm or email (email is in the file).

Dan

[Sasq]

possible, yes. And if your not using the DB lookup I can churn out something fairly soon. (damn last week of work and busy as all .....)
If you want intergration to the db lookup as well, I'll need a little longer.

Dan

[Bumpaneer]

Nope, not using DB lookup

Thanks,
~Bumpaneer

[aibon]

great hack. thx sasq.

i use the nodblocal method, but changed it to store the data in th db instead of writing a local file. post it here, perhaps someone finds this useful.

here's the code for call.php:

PHP Code:

$accessip = "255.255.255.255"; //accepts wildcards so '255.255.255.*' is ok
$ip = getenv("REMOTE_ADDR");
$accesscode = "passwd";

if (($HTTP_POST_VARS[access] == $accesscode)&&(ereg($accessip, $ip))&&(!empty($HTTP_POST_VARS)))
{
   include("./admin/config.php");
   include('./admin/db_mysql.php');
   $DB_site=new DB_Sql_vb;
   $DB_site->database=$dbname;
   $DB_site->server=$servername;
   $DB_site->user=$dbusername;
   $DB_site->password=$dbpassword;
   $DB_site->connect();
   $dbpassword="";
   $DB_site->password="";

   unset ($HTTP_POST_VARS[access]);
   $posuf = $HTTP_POST_VARS[users];
   $posuf = str_replace(" ", "%20", $posuf);

   $DB_site->query("UPDATE irconline SET data='".addslashes($posuf)."', timestamp='".time()."' WHERE id=1");
} 


2 changes for index.php (no matter if db or nodb):

replace:

PHP Code:

if ((!file_exists($onlinefile))||(filemtime($onlinefile)<(time()-($ircfaulttime*60)))) { //check the existance and time out of the file 


with

PHP Code:

$checkdate = time()-($ircfaulttime*60);
if (!($users = $DB_site->query_first("SELECT * FROM irconline WHERE id=1 AND timestamp>='$checkdate'"))) { 


replace

PHP Code:

$file = fopen($onlinefile, "r");
while (!feof($file)) {
        $buffer .= fgets($file, 4096);
}
        fclose($file);
$buffer = strip_tags ($buffer);   //get rid of any php or html tags etc
$buffer = chop($buffer);          //get rid of the white space

/// routine for placeing the user details into an array and getting online numbers
        $temparray = explode ("%20", $buffer); 


with

PHP Code:

   $temparray = explode ("%20", $users[data]); 


the sql:

PHP Code:

CREATE TABLE irconline (
  id int(10) unsigned NOT NULL auto_increment,
  data text NOT NULL,
  timestamp int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO irconline VALUES (1,'empty',0) 


that's all, everything else stays the same.

[Sasq]

Cool thanks, I've been meaning to do an sql version of it. I've just been busy with a site upgrade.

Just installed a rather hacked version of vbportal, with all the insuing mods etc.

I have more time from next week end, so I'll intergrate you mod into the install package (with credits of course)

One week of the slave pit to go - woohoo

Dan

[Bumpaneer]

Any progress?

~Bumpaneer

[Sasq]

A little, Only finished work on monday - yay I'm free, however the wife wants some QT first.

Dan

[Bumpaneer]

Ok, take care of the woman

[Bumpaneer]

Another question.... Can this be modified to keep track of what the max numbers of users was, and when? Kinda like the online users does now.

Thanks,
~Bumpaneer

[Sasq]

Ok, just so you know I'm thinking of you..
I just played with the bot, and I can't get it to supply the nicks with an Op etc atm - it could just be my ancient bot - I'll do some more research.

max numbers etc... doable just thinking about the best way to do it.

Integrate the hack into the db, or keep it all as a flat file.

I'll see what i can come up with

Dan

[Bumpaneer]

Cool, thanks