egghelp/eggheads community

problem witch a function in a c modul

2002-01-01T08:02:00-04:00

On 2001-12-31 14:16, guppy wrote:
Why is no one sharing their mysql modules with the rest of the community?

I am, but mine is not just ready yet. Right now if you want mine, just mail me. I will put up a snapshot of it when I feel it's ready for testing.

My homepage is http://joakim.gissberg.nu/, as shown below.

Statistics: Posted by Guest — Tue Jan 01, 2002 8:02 am

problem witch a function in a c modul

2001-12-31T17:16:00-04:00

Why is no one sharing their mysql modules with the rest of the community?

Statistics: Posted by guppy — Mon Dec 31, 2001 5:16 pm

problem witch a function in a c modul

2001-12-31T05:49:00-04:00

My Makefile for my mod mod.mysql looks like this:

Code:

# Makefile for src/mod/mysql.mod/# $Id: Makefile,v 1.9 2000/07/09 14:10:49 fabian Exp $srcdir = .doofus:@echo ""@echo "Let's try this from the right directory..."@echo ""@cd ../../../ && makestatic: ../mysql.omodules: ../../../mysql.$(MOD_EXT)../mysql.o:$(CC) $(CFLAGS) $(CPPFLAGS) -I/usr/local/mysql/include/mysql -DMAKING_MODS -c $(srcdir)/mysql.c@rm -f ../mysql.omv mysql.o ../../../../mysql.$(MOD_EXT): ../mysql.o$(LD)  -L/usr/local/mysql/lib/mysql -lmysqlclient -o ../../../mysql.$(MOD_EXT) ../mysql.o$(STRIP) ../../../mysql.$(MOD_EXT)depend:$(CC) $(CFLAGS) $(CPPFLAGS) -MM $(srcdir)/mysql.c > .dependclean:@rm -f .depend *.o *.$(MOD_EXT) *~distclean: clean#safety hash../mysql.o: .././mysql.mod/mysql.c ../../../src/mod/module.h  ../../../src/main.h ../../../src/lang.h ../../../src/eggdrop.h  ../../../src/flags.h ../../../src/proto.h ../../../lush.h  ../../../src/misc_file.h ../../../src/cmdt.h ../../../src/tclegg.h  ../../../src/tclhash.h ../../../src/chan.h ../../../src/users.h  ../../../src/compat/compat.h ../../../src/compat/inet_aton.h  ../../../src/compat/snprintf.h ../../../src/compat/memset.h  ../../../src/compat/memcpy.h ../../../src/compat/strcasecmp.h  ../../../src/mod/modvals.h ../../../src/tandem.h

_________________
http://joakim.gissberg.nu/ | joakim@gissberg.nu

[ This Message was edited by: tajson on 2001-12-31 02:50 ]

Statistics: Posted by Guest — Mon Dec 31, 2001 5:49 am

problem witch a function in a c modul

2001-12-16T11:55:00-04:00

I have fix it but nothing now i have a question about the Makefile. I must insert this lines for the compiler:

Code:

 -L/usr/lib/mysql -lmysqlclient -lnsl

This is needed for the mysql database. Where is the right location in the Makefile i think this is maybe the error...

[ This Message was edited by: Majesticc on 2001-12-16 08:56 ]

Statistics: Posted by Guest — Sun Dec 16, 2001 11:55 am

problem witch a function in a c modul

2001-12-16T09:25:00-04:00

Well I didn't look at all of it, but right away I noticed this:

strcat(query,table);

You can't do that, there's no room in the query array for more data the way it's defined.

Statistics: Posted by stdragon — Sun Dec 16, 2001 9:25 am

problem witch a function in a c modul

2001-12-16T05:53:00-04:00

Hello,
I have a little problem with a c funtion with my stand alone program it will be work but included in the eggdrop modul i get a sigint on sending the bind. I have reached the error function but i dont find any error. Here is the fuction code:

Code:

static char*** get_table_data(char *table){  MYSQL_RES *result;   MYSQL_ROW row;  unsigned int i;   int numrows;  int numfields;  int rowcount;  int fieldcount;  int rowi;  char ***erow;  char query[] = "SELECT * from ";  strcat(query,table);   mysql_query(dbh,query);  result = mysql_store_result(dbh);   numrows = mysql_num_rows(result);  numfields = mysql_num_fields(result);  erow=(char ***)nmalloc(numrows*sizeof(char *));  for(rowi=0;rowiname);    }  */  //printf("n");  rowcount = 0;  //printf("R:%d F:%dn",numrows,numfields);  while ((row = mysql_fetch_row(result)) != NULL)     {      fieldcount = 0;      //printf("n");      for (i=0; i

I hope anyone can help me.



[ This Message was edited by: Majesticc on 2001-12-16 02:54 ]Statistics: Posted by Guest — Sun Dec 16, 2001 5:53 am