egghelp/eggheads community

caesar wrote:@ pelefanten:
I get a 404 on http://www.cau.se/mystats/

Thats mainly because of

pelefanten wrote: ... I'm focusing on the pgstats.mod module from now on since postgresql has the features I'm looking for ...

I've kinda dropped the developement of mystats.

So far the installation runs fine (eaven for a n00b like me !) But i dont get any Stats from the Bot [07:08pm] [Satras] !top10 [07:08pm] (..notice..) |Bot|: No users in database. Does this means, i have to add every user to the Database ??? Maybe i missunderstood this script. I thought it is like a...

Well at this time i'm using a windrop with fastbase dll to support the connection to mysql. I'm sorry but I dont know what fastbase is. The only way I know of, correct me if I'm wrong here, is to compile the module againts the mysql headers and library. But i have a problem. The module doesn't add ...

This one should take care of text == NULL and text = ""
Or if you dont want to use strlen

Check this out: http://www.eggheads.org/news/2004/04/10/26

I doubt that it will work with any other SQL server. As for supporting other SQL servers I've rewritten the module with PostreeSQL support. However, this "version" is not quite stable yet.

For anyone who wants to try the pgSQL module out, download it from http://www.cau.se/dev/pgstats

From eggdrop.conf : # statuslog # Log the channel status line every 5 minutes? This shows the bot's # status on the channel (op, voice, etc.), the channel's modes, and # the number of +m/+o/+v/+n/+b/+e/+I users on the channel. A sample # status line follows: # # [01:40] @#lamest (+istn) : [m/1 o/1 v...

Adding users needs to be done manually. But, since this module basically has nothing to do with channel security you can add people by their nick. Or if you want to be somewhat strict: New version out, http://www.cau.se/dev/mystats/

What this project lack tho, is a webbased interface for viewing the stats. I have one, using phpBB frontend style, at http://www.cau.se/mystats . Allthough, it only shows channel stats and stats for whomever is online.

Awesome, if it works that would be slick.

Latest version 1.58 is considered stable. But if you have any probs dont hesitate to message me.
http://www.cau.se/dev/mystats/mystats-1.58.tar.gz

What you're looking for is probably not a public-command trigger, but rather a public message trigger. static int mymod_pubm(char *nick, char *host, char *handle, char *channel, char *text) { return 0; } static cmd_t mymod_pubm_tbl[] = { {"*", "", mymod_pubm, NULL}, {NULL, NULL, ...

Well, you will need the mySQL headers and librarys if you wanna compile a module using mySQL. This should show you where the libraries are at, maybe there's something wrong with the Makefile, maybe...

And then theres mystats.mod (like stats.mod) at http://www.cau.se/dev/mystats ,
myexpl.mod at http://www.tty0.org/page/myexpl (with a pgsql version at http://www.tty0.org/page/pgexpl )

I dont know if its such a good thing to rename the lines-counter to "lines" since its a reserved word by mysql.

http://www.mysql.com/doc/en/Reserved_words.html

Glad it worked, and I'd be happy to explain what some of the table colums holds (you may have figured some out already). chans.status can either be -1,0,1 or 2. -1 Once you join a channel a record is beeing created with this default It means that you dont keep stats for this channel. Inactive mode. ...