egghelp/eggheads community

Channel stats and MySQL

2004-11-02T19:23:47-04:00

oh

but thanx for the answer !

Statistics: Posted by Satras — Tue Nov 02, 2004 7:23 pm

Channel stats and MySQL

2004-11-02T13:28:41-04:00

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

Thats mainly because of

... 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.

Statistics: Posted by pelefanten — Tue Nov 02, 2004 1:28 pm

Channel stats and MySQL

2004-11-02T13:26:00-04:00

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 chanstats script

help plz

You have to add you users manually

Statistics: Posted by pelefanten — Tue Nov 02, 2004 1:26 pm

Channel stats and MySQL

2004-10-28T08:40:38-04:00

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

Statistics: Posted by caesar — Thu Oct 28, 2004 8:40 am

Channel stats and MySQL

2004-10-27T13:13:34-04:00

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 chanstats script

help plz

Statistics: Posted by Satras — Wed Oct 27, 2004 1:13 pm

anyone got it to work with windrop's yet ?

2004-08-24T14:24:50-04:00

i have tryed to compile it with Cygwin as well with no luck

hope it gets done soon

Statistics: Posted by Guest — Tue Aug 24, 2004 2:24 pm

Channel stats and MySQL

2004-06-26T08:39:42-04:00

fastbase is a TCL Library. That would not be applicable to a module i don;t believe.

Statistics: Posted by KevKev — Sat Jun 26, 2004 8:39 am

Channel stats and MySQL

2004-06-25T20:34:22-04:00

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 the user who join the channel , so the module don't make the stats for the new users... I need add this users manually. It's very boring.

Correct, the module does not add users automatically. However, this feature will be added to the pgstats.mod module in the next release. I have the autoadding working (sort'a) but it needs some further testing and tuning. I plan to add this feature to the mysql.mod module whenever I get time.

I've discovered that postgresql is more powerful than mysql (i know, mysql might be more common) but nevertheless, I'm focusing on the pgstats.mod module from now on since postgresql has the features I'm looking for such as key references and triggers with the plpgsql language too keep data valid. This allows to several bots (and maby a website) to alternate the information in the database and the bots to still be synced with the latest user information.

Currently I've added these features to the up and comming version of pgstats:

Code:

* Added a sync-table with triggers to log userdb changes* Added suport for multiple bots using same userdb* Added function to verify pgstats-database version* Added autoadding and autodeleting* Added more options in configuration file* Added url logger* Extended the PHP5 web API

Statistics: Posted by pelefanten — Fri Jun 25, 2004 8:34 pm

Channel stats and MySQL

2004-06-23T21:35:00-04:00

I've just set up a new shell and have no problems installing the mystats module any more. I also didn't need to do the #define HAVE_STDARG_H 1 work around.

This makes me very happy

Statistics: Posted by Guest — Wed Jun 23, 2004 9:35 pm

Channel stats and MySQL

2004-06-23T08:33:56-04:00

I'm not english , sorry for my english !

This module is very good. I prefer him at stats.mod because he uses an mysql table.

But i have a problem. The module doesn't add the user who join the channel , so the module don't make the stats for the new users... I need add this users manually. It's very boring.

Is There a solution to add user automaticaly ?

Thank you and very good work !

Statistics: Posted by Guest — Wed Jun 23, 2004 8:33 am

Channel stats and MySQL

2004-06-22T15:48:06-04:00

Well at this time i'm using a windrop with fastbase dll to support the connection to mysql. With that i can help.
As for the error i had the same. The sollution is to copy the files from your mysql install package. There are multiple files you have to copy. look for the : mysql.h: No such file or directory

But after that i get different errors
Tryed Cygwin also but didn't help.

But then again i'm not used to work on linux.
Haven't had the time to test any futher. But when i get anyfuther i will post it

Statistics: Posted by Quinie — Tue Jun 22, 2004 3:48 pm

Channel stats and MySQL

2004-06-22T01:14:01-04:00

I've been trying for some time to get an eggdrop compiled with mysql support, I've pulled out an incredible amount of hair as I attempted to get a seemingly endless list of tcl and modules working.

With the release of 1.6.16 I decided to give it another shot.

This is exactly what I've done:

Extracted eggdrop1.6.16.tar.gz to ~/eggdrop1.6.16
Extracted mystats-1.77.tar.gz to ~/eggdrop1.6.16/src/mod/mystats.mod
./configure --with-mysql=/usr/lib/mysql
Edited config.h and added #define HAVE_STDARG_H 1 (as per here)
make config
make

Then I recieve this error (which is followed by pages and pages of similar junk):

make[2]: Entering directory `/home/fuzzy/eggdrop1.6.16/src/mod/mystats.mod'
gcc -pipe -fPIC -g -O2 -Wall -I. -I../../.. -I../../.. -I../../../src/mod -DHAVE_CONFIG_H -I'/usr/include' -DMAKING_MODS -c .././mystats.mod/mystats.c
cc1: warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
../mystats.mod/mystats.c:28:19: mysql.h: No such file or directory
In file included from ../mystats.mod/mystats.c:45:
../mystats.mod/settings.c:23: parse error before "mysql"
../mystats.mod/settings.c:23: warning: type defaults to `int' in declaration of `mysql'

Here's my mysql info:

# mysql_config --libs --cflags
-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm
-I'/usr/include'

Any tips? I figure there's something wack with my mysql set up, because I have similar problems with mysql.mod too.

Statistics: Posted by Guest — Tue Jun 22, 2004 1:14 am

Channel stats and MySQL

2004-06-18T13:38:36-04:00

I think you didn't get what i mean and maybe i didn't get what you meant to say.

i will try to explain meself but englisch isn't my native language.
I'm a user of windrop and i'm making tcl files that connect to mysql. These scripts work with a sollution a company called fastbast made.

I was hoping that when compiling this module in cygwin i could make a windrop out of it. I tought the first problem would be the syntax of your code. Would it respond to the fastbase syntax. So i wasn't meaning another sql server version.

Well i just put it to the test today. But i could not compile the your module (using cygwin on win2000).
Would you like me to send you the log ?

Statistics: Posted by Quinie — Fri Jun 18, 2004 1:38 pm

Other SQL Servers

2004-05-04T10:02:07-04:00

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

Statistics: Posted by pelefanten — Tue May 04, 2004 10:02 am

Channel stats and MySQL

2004-04-28T05:12:39-04:00

pelefanten you have mail.

Sorry for responding so late. I Had some problems. But i would still love to test this module. Mostly because i'm wondering is you're sql implemetation works with fastbase mysql dll's.

So you can port this to windrop also

Statistics: Posted by Quinie — Wed Apr 28, 2004 5:12 am