I am working on a script letting eggdrop do certain functions on a mysql database by evoking the unix shell command mysql. Executing works perfect but I am wondering how I can reuse the output delivered. For example I am doing a search on the DB and get a list. Hence it is multiple lines I can just put it into a variable.
At the moment I would be happy if I can reroute the output to a PRIVMSG.
Is it possible to populate an array holding the various lines of the comamnd output?
you can pipe the shell command output to your script, but the proper way to interface mysql database from tcl would be to use an appropriate externsion/package, for example mysqltcl (or mysql.mod eggdrop module)