Channel stats and MySQL

[Fuzzy]

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.

[Quinie]

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

[Alban]

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 !

[Fuzzy]

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

[pelefanten]

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: Select all

* 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

[KevKev]

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

[MacDaddy[IRC]]

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

hope it gets done soon

[Satras]

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

[caesar]

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

[pelefanten]

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

[pelefanten]

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

[Satras]

oh

but thanx for the answer !