Miscellaneous Hacks - [Eggdrop Addon] iRC UserStats for vB3 [/Repec]

General Info

**EDIT**
Before anyone starts *****ing about copyright **** etc, I had some examples but I wrote and figured this out myself!
**/EDIT**

Not to sure where I had to post this cuz it isnt really a hack for vB3 itself, it just pulls info out of the vB3 dbase and post it in iRC.

First off you need a few things before this can work for your board.
If you dont have one of the required elements or dont have the access to install it you can stop reading. This is what you need:

Eggdrop bot (d0h :p )
Mysqltcl library (you can find it here http://www.xdobry.de/mysqltcl/)
Location to your mysql.sock file (depends on the *nix installation but usually its in /tmp/)
Abit of knowledge about coding in tcl (in case you wanna change colours and such)

Configuration of tcl explained

On line 1 of the tcl file you will see:

You must first be a registered member to view any code.

This must be path to where libmysqltcl.so.2 is stored so it could be different on your box. If you dont know where to find it ask your shell provider.

On line 10 you will find:

You must first be a registered member to view any code.

This is the path to where your mysql.sock file is stored, like above it could be different on your box.
*NOTE* You only have to use this line if you get an error without it. Thus first try the script with that line commented out, if it generates an mysql.sock error you will have to get the path to your mysql.sock file.

On line 15 you will find the actual line which makes the connection to your database.

You must first be a registered member to view any code.

I think this line is self explanatory but if you commented out the db(socket) on line 10 you will have to remove this part from the line.

On line 20 is the the command trigger, change it to what you like, standard its !user

On line 31 is the query which will be run on your database you will have to edit this line!! In the line I have my counters stored in the user table of the database with my own column names. Just make sure you edit this.

On line 35 to 44 you must change the variables to your column names.
On line 46 to 50 you also must change the variables and optionally the colors and layout.

Line 32 and line 45 are just partyline log files you can ignore those.

Think thats about all of the info you need to know to succesfully run this script.

Installation instruction

Upload the file vbuserstats.tcl to your bots scripts directory and add this line to the end of your bots config file: source scripts/vbuserstats.tcl
Telnet into your bot and do a .rehash
In iRC just type !user Ausernamehere and it will show you the info.

Enjoy

/Repec

*Cronic* · 10-06-2004, 08:14 AM

Nice Work Man

been lookin for something like this for a while :thumbs_up

Installed!!! Works Great

*tomer_shim* · 10-06-2004, 09:03 AM

On line 1 of the tcl file you will see:

Code:
load /usr/local/lib/tcl8.3/mysqltcl/libmysqltcl.so.2
This must be path to where libmysqltcl.so.2 is stored so it could be different on your box. If you dont know where to find it ask your shell provider.

On line 10 you will find:

Code:
set db(socket) "path/to/where/your/mysql.sock/file/is/located/"
This is the path to where your mysql.sock file is stored, like above it could be different on your box.
*NOTE* You only have to use this line if you get an error without it. Thus first try the script with that line commented out, if it generates an mysql.sock error you will have to get the path to your mysql.sock file.

i couldnt find these 2 files, i dont really know where i can get them/ where they are. plz help me

* tomer_shim clicks install

*Repec* · 10-06-2004, 10:07 AM

in order to know where those files are you need:
A) A dedicated or colocated server
B) ask your shell provider if they have it installed
C) If you have your eggdrop on a diff server then your board u have to change localhost to your boards ip adress

*Paul* · 10-06-2004, 06:12 PM

just do a find libmysql* or locate libmysql* and look for the file. SOME servers are secure so this won't work, but on most you should be able to find it.

ShavedApe · 10-06-2004, 08:05 PM

I dont mean to be rude but its easier and doesnt require the bot needing access to the mysql if you use the http functions of tcl combined with a simple php page.

This hack is fine btw and and im sure it does the job very well but not everyone will be able to use it.

MaTtIaSkE · 10-10-2004, 02:27 PM

gonna try this one out pal

MaTtIaSkE · 10-17-2004, 11:02 AM

hmm i got this strange error
when i do .rehash it doesn't respond
and when i quit the bot and restart it
it won't restart :S

can someone help me ?

*Arcade* · 11-14-2004, 03:14 PM

if your bot doesn`t start there is an error in the loading of an tcl script maybe the last added.

show into your eggdrop.conf and delete the line with the last tcl script and restart your bot, then you can connect to your bot via telnet and if you type into the telnet ..restart you should see what the problem is

ruizit0 · 10-10-2005, 04:27 PM

Quote:

[20:17] Userinfo: executing SELECT userid,username,joindate,lastvisit,posts,Stros,Rac es,Scans,Hacks,requestsfilled FROM `user` WHERE username='trancepsicadelico'

[20:17] Tcl error [pub_userlookup]: mysqlsel/db server: Unknown column 'Stros' in 'field list'

errr. ..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IRC userstats	Hyper	vBulletin Modification Requests	12	09-29-2004 03:03 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)