datas from mysql in irc chan!

philipp · Post by **philipp** » Wed Jan 10, 2007 3:20 pm

hey gays! sry for my bad english

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

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

philipp · Post by **philipp** » Tue Jan 16, 2007 1:09 pm

why nobody help me *cry*

Post by **nml375** » Tue Jan 16, 2007 3:38 pm

Bumping generally won't help.
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..