There is a few. puthelp which will only send 1 line at a time, you could also looking into using timer or even time if you wanted to do it in minuets. timer uses seconds, so you could do after each line [expr lineNumber +1]
thanks for the info here is what i am actually using the real proc i mean - cos i am not sure how to use your suggested code. I was looking for timer as I need the time delay to be say 10 - 15 seconds
TCL_no_TK wrote:There is a few. puthelp which will only send 1 line at a time, you could also looking into using timer or even time if you wanted to do it in minuets. timer uses seconds, so you could do after each line [expr lineNumber +1]
proc pub:send_nfo {nick host hand chan text} {
global mysql
set output [mysqlsel $mysql "SELECT * FROM nfo_cache WHERE status = '0'" -list]
set c 10
foreach row $output {
set c [expr $c +5]
utimer $c putserv "PRIVMSG #pre.nfo-feed :!fetch_nfo [lindex $row 0] [lindex $row 1] [lindex $row 2]"
}; mysqlexec $mysql "UPDATE nfo_cache SET status = '1'"
}
set site [lindex $row 0]
set section [lindex $row 1]
set rls [lindex $row 2]
That should send the data to the channel every 10,15,20,25,30 mins ...etc
P.S i dont know the first thing about mysql, n stuff but as i haven't changed anything other than the lindex(s); it shouldn't affect anything mysql related.
proc pub:send_nfo {nick host hand chan text} {
global mysql
set output [mysqlsel $mysql "SELECT * FROM nfo_cache WHERE status = '0'" -list]
set c 10
foreach row $output {
set c [expr $c +5]
utimer $c putserv "PRIVMSG #pre.nfo-feed :!fetch_nfo [lindex $row 0] [lindex $row 1] [lindex $row 2]"
}; mysqlexec $mysql "UPDATE nfo_cache SET status = '1'"
}
set site [lindex $row 0]
set section [lindex $row 1]
set rls [lindex $row 2]
That should send the data to the channel every 10,15,20,25,30 mins ...etc
P.S i dont know the first thing about mysql, n stuff but as i haven't changed anything other than the lindex(s); it shouldn't affect anything mysql related.