Question about using SQL/Web...

Jynxx · Post by **Jynxx** » Fri Jul 22, 2005 4:28 pm

Ok, so my main goal is to be able to publish who is in the IRC chatroom on my website... I was thinking of using a script to write the names from the chatroom to an SQL database, and then using php to post the contents of the databse on my site...
Does ANYONE know how I can do this? I'm ok at SQL, decent at PHP.... but I have NEVER EVER even TRIED to make anything for IRC.

ANY help would be greatly appreciated!

demond · Post by **demond** » Fri Jul 22, 2005 5:03 pm

if your website is on the same host your bot runs on, it's easier to generate that html page directly from the bot, using Tcl scripting

and if you are decent in PHP, you should be able to learn Tcl/eggdrop scripting pretty fast - yet another scripting language

Jynxx · Post by **Jynxx** » Fri Jul 22, 2005 5:17 pm

Its not on the same host, its on a completely different server...

And I dont even know where to begin with tcl, thats why i'm asking for help

demond · Post by **demond** » Fri Jul 22, 2005 5:30 pm

a good place to start is the very same website you read now; explore egghelp, you'll find tons of documents targeting eggdrop beginners

you'll need some kind of mysql interface for eggdrop, either mysql.mod or mysqltcl; these both require additional compilation & installation, they are not part of eggdrop

Galadhrim · Post by **Galadhrim** » Sat Jul 23, 2005 1:23 pm

I remember finding some programs on the Internet that were able to parse the log of the eggdrop (and also mIRC etcetc) into HTML pages. mircstats is one of them but there are more, some free, some lifetime key. They read the log, require some small preconfiguration as to how you want the HTML to be made, and write the pages. Some even upload the pages to your website..

http://www.mircstats.com <-- this site also lists other resembling programs...
Captain's Log

Quinie · Post by **Quinie** » Wed Jul 27, 2005 6:13 am

Jynxx wrote: was thinking of using a script to write the names from the chatroom to an SQL database, and then using php to post the contents of the databse on my site...
Does ANYONE know how I can do this?

Working on it but i think it can take a while before my script is completely done

http://84.107.6.213/Legna/welcome.php <- test output of the php working with mysql and tcl scripting

Quinie · Post by **Quinie** » Wed Jul 27, 2005 7:26 am

BTW if your any good at PHP maybe we can work together. The TCL part is almost done. But i still need to do alot of php. My script isn't tested other then the channel i'm on.

But if you like to i think we can work something out

the tcl scripts i made store in the mysql database:
Greets, Quotes, Urls, Use rmanagement, Topics, Kicks, Chanlog and more.
All modulair even the msg are coming from the DB so the bot can respond in any language.

egghelp/eggheads community

Question about using SQL/Web...

Question about using SQL/Web...

Re: Question about using SQL/Web...