I am looking on a way to make some new features with my egdrops i Actualy run 4 eggdrops in my irc network as IRCop with suces using self made script on outo baning and akicking malicious ip and users what i am trying to do is take it in a more advanced step by implementing mysql in this metter. what i want to do is have a central database where i can store my safe ip's like ips that i dont want to be banned from network also have like a "[censored] liste" and also give the ability to my ircop to check ip over the net. i know this is going to be a long proces but i will appretiate any one who can give me tips on starting this project its gona be the first time i write a mysql related tcl script
sincerely
Thnx Papillon that would be a good start for me new in mysql tcl scripting. I want to know also some more tips like would be better or posibe to write a separate mysqltcl script to call the database and other scripts for actions like calling the proc`s from the tcl and easly to ad more features later on this are the kind of tips I am looking for. Thnx again guys
set db [mysqlconnect -user USER -password PASSWORD -db DATABASE]
#example of connect
set test [mysqlexec "INSERT INTO table (text1, text2) VALUES ('$text1', '$text2'"]
#example of INSERT query