hey nml375, thnx for responding again! Option 1: Move the mysqlconnect command inside the proc, calling it at the beginning of the proc. Would probably be a good idea to close the connection manually at the end of the proc to preserve resources (don't remember if myslqtcl reuses existing connections...
One option may be to open the sql-connection on each invocation of the command. Another would be to use the mysqlping command to check the status of the connection upon each invocation... About 1st option - how to do that? (ie. what modifications need to be made to the code above) About 2nd option ...
hello everyone, after weeks of googling and trying different combinations with the code, i'm out of ideas and need your help :) i'm using a simple script to invite users to a channel using the MySQL db.. user sends his password and username in exchange for a channel invite it all works nice, until d...