pre.tcl
Code: Select all
package require mysqltcl
set db_handle [mysqlconnect -host localhost -user root -password pass -db pre]
bind pub - !NEW pre_proc
set _version 0.2
proc insert {section name timestamp} {
global db_handle
set sql "INSERT INTO releases VALUES (null, '$section', '$name', '$timestamp', null, null, '0', null)"
set result [mysqlexec $db_handle $sql]
if {$result == 1} {
return 1
} else {
putlog "FAILURE - $sql"
return 0
}
}
proc pre_proc { nick host handle channel text } {
set section [lindex [split $text] 1]
set release [lindex [split $text] 3]
set timestamp "[lindex [split $text] 4] "
append timestamp [lindex [split $text] 5]
putlog "PRE $release"
set result [insert $section $release $timestamp]
if {$result == 1} {
puthelp "PRIVMSG #lfs-pre :PRE in $section :: $release $timestamp"
}
}
putlog "pre.tcl v$_version loaded."Code: Select all
package require mysqltcl
set db_handle [mysqlconnect -host localhost -user root -password pass -db pre]
bind pub - !FIX fix_proc
set _version 0.2
proc fix_size {name size files} {
global db_handle
set sql "UPDATE releases SET size='$size', files='$files' WHERE name='$name'"
set result [mysqlexec $db_handle $sql]
if {$result == 1} {
return 1
} else {
putlog "SIZE FAILURE - $sql"
return 0
}
}
proc fix_proc { nick host handle channel text } {
putlog "FIX [lindex [split $text] 1]"
set fixtype [lindex [split $text] 0]
if {$fixtype == "size"} {
fix_size [lindex [split $text] 1] [lindex [split $text] 2] [lindex [split $text] 3]
}
}
putlog "fix.tcl v$_version loaded."