Another Mysql question.

cashed · Post by **cashed** » Sun Jan 15, 2006 7:54 pm

ok I have a website that adds things to a mysql db now my question is what would be the best way for eggdrop to connect to this db and post in a channel when ever something new is added, and also make it be able to search the db and post the search results in chan with a search trigger from chan. FreeBSD 5.4 and mandrake is distros i have installed dont no if it would matter just FYI.

Maybe a Noob step by step page since i am a noob when it comes to this or point in the right direction sorry if i am posting this question in the wrong place.

Thanks-

demond · Post by **demond** » Sun Jan 15, 2006 10:31 pm

the best way for eggdrop to do this would be via mysqltcl

the best way for you to make your eggdrop to do this would be learning by example (i.e. find a mysqltcl script and see how others have done it)

cashed · Post by **cashed** » Sun Jan 15, 2006 10:37 pm

thank you i will do some research.. but if anyone else has a script in mind plz let me know.

BarkerJr · Post by **BarkerJr** » Sun Jan 15, 2006 10:44 pm

I think think my module is better than mysqltcl :)

cashed · Post by **cashed** » Sun Jan 15, 2006 10:49 pm

what is you mod?

demond · Post by **demond** » Sun Jan 15, 2006 11:00 pm

BarkerJr wrote:I think think my module is better than mysqltcl

well, it might be easier to use in eggdrop, but I doubt it provides some (or all) of the more advanced features of mysqltcl (variable binding, db info queries, SSL, etc.)

so you probably meant it's better for newbies, not better in general

BarkerJr · Post by **BarkerJr** » Sun Jan 15, 2006 11:09 pm

demond wrote:so you probably meant it's better for newbies, not better in general

Ok, I can accept that. It's also harder to mess up your DBMS, since there aren't resources to worry about.