egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2007-01-16T15:38:55-04:00 https://forum.eggheads.org/app.php/feed/topic/12943 2007-01-16T15:38:55-04:00 2007-01-16T15:38:55-04:00 https://forum.eggheads.org/viewtopic.php?p=69661#p69661 <![CDATA[datas from mysql in irc chan!]]> Had a look at dbsearch.tcl? Think it would be quite possible to modify the queries in it to suite your needs...
Might also wish to search in the tcl archive..

And please, don't post such huge images, when the information (database, table, and field-names) could've easily been written on a single line of text.

As for your issue with multiple hits, with a proper sql-query it would merely be an issue of repeatedly picking a row from the result-set and posting, until the result-set is depleted..

Statistics: Posted by nml375 — Tue Jan 16, 2007 3:38 pm

]]> 2007-01-16T13:09:50-04:00 2007-01-16T13:09:50-04:00 https://forum.eggheads.org/viewtopic.php?p=69660#p69660 <![CDATA[datas from mysql in irc chan!]]> Statistics: Posted by philipp — Tue Jan 16, 2007 1:09 pm

]]> 2007-01-10T15:20:01-04:00 2007-01-10T15:20:01-04:00 https://forum.eggheads.org/viewtopic.php?p=69586#p69586 <![CDATA[datas from mysql in irc chan!]]>


so we have a mysql data base which is build like that!

Image

now we would like to input in the irc channel

!player gentleman

so the bot should connect du the db (showed at the pictur) of the tool and search throught the part which is calles "spielernamen" and if the input in the channel is found in spielernamen so the coordinates will be past and if in the same row "mond" = 1 then it should be postet in the channel like that:

"gentleman; 2:420:11 M,"
^ ^ ^
spielername;coordinates;mond yes/no

the next problem is if the tool found one it should not stop searching! because there can be 9 "coordinates" per "spielernamen"!

I hope i could told all my problems if there are questions you ask me please

Statistics: Posted by philipp — Wed Jan 10, 2007 3:20 pm

]]>