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

[Sparkz]

Originally posted by Sasq


Sorry I replied while tired, as far as I know, our host (forum) only allows localhost connects to the DB, and personally for security I prefer it that way as well. - yes i am aware of locking down the ip ranges etc for logins but i'm trying to keep this hack simple.

How the DB security is maintained has little to do with your hack. It's simply a matter of knowing how to do a GRANT in MySQL.

[Sasq]

Sparkz, the db atm has little to do with my hack period

[Sparkz]

They way you commented on the other guys comment (nice sentence, eh? ) made it sound like that

Don't mind me, though... I'm just being an a$$ like usual

[Sasq]

hehe no problem I'm currently most of the way through an alpha version of the second release. In this version the bot calls home to the forum via a html/php script saves a small text file.
The idea being to save bandwidth. and load times.
If people really want it to go into the db, I'll look at that in a later release

Dan

[Sparkz]

My own version (the one sending names to vb.org) calls home. The code should be here somewhere. Not very pretty or anything, but it sorta works

[Sasq]

This is defiently not on the pretty side - but hey if it works , It'll be ready for beta release once i work out how to do some "better" error handling in the tcl script for the bot.

[PBC]

Originally posted by Sasq
What does the error say?

Dan

[20:21] wrong # args: no script following "{[string compare [li" argument
while compiling
"if {[string compare [lindex $j 1] i2h:make] == 0} "
("foreach" body line 1)
while compiling
"foreach j [utimers] {if {[string compare [lindex $j 1] i2h:make] == 0}
{return [lindex $j 2]}}"
(compiling body of proc "utimerexists", line 2)
invoked from within
"utimerexists """
(procedure "i2h:make" line 17)
invoked from within
"i2h:make"
(file "scripts/online.tcl" line 47)
invoked from within
"source scripts/online.tcl"
(file "paintballchannel.conf" line 159)
[20:21] * CONFIG FILE NOT LOADED (NOT FOUND, OR ERROR)

[Sasq]

hmmm I'll double check that. I have no problem here, which version of tcl are you using?

This weekend I will be releasing version 2 of the beta.

Lots of extra funtions, including options
Bot side
-> for the current forum calls the bot option
-> bot calls home to the fori with an update (small text file stored on the forum server) - you will need the http library installed.

-> forum side
a small (secure I think) call home php script for the bot (option 2 above)
->either the current online user display or
->user table lookup in the db to match (in this order) handle on the bot, nick, host name.
- This script will also keep users hidden if their user option is to be hidden on the forum (admin can still see).
- added funtions for users to overide the lookup like the '[on]' at the end of the nick to overide the hidden flag and '[me]' to overide if the user db lookup looks up the wrong person.


I just have a minor bug to fix and need to write the documentation for install.


edit here is the code from my running bot, double check to see if there is a difference

if {[utimerexists ""] == ""} {utimer 60 i2h:make}
return 1
}

proc utimerexists {i2h:make} {
foreach j [utimers] {if {[string compare [lindex $j 1] i2h:make] == 0} {return [lindex $j 2]}}
return
}

Dan

[PBC]

edit here is the code from my running bot, double check to see if there is a difference

There was no real difference that I could see, but I c/p'd the code and it works fine now...go figure.

Thanks!

[thakikka]

hi,

i just installed this hack and it seems to work perfectly.

thakikka
http://forum.ksgemeinde.de