Code: Select all
set userChan "#dev.null"
set accesschan "#dev.null"
bind join - * joins
proc joins {nick host hand chan} {
global userChan mysql_ db_
if {$chan == $userChan } {
#mysqluse $mysql_(handle) $mysql_(database)
set sql [mysqlsel $mysql_(handle) "SELECT * FROM $mysql_(table) WHERE username='[mysqlescape $nick]' AND db_(accessclass) = '$class' "]
set result [mysqlsel $mysql_(handle) $sql -list]
if {$result > 0 } {
set result [mysqlsel $mysql_(handle) $sql -list]
putserv "NOTICE $userChan Welcome $nick $class"
}
} else {
putserv "kick $userChan $nick :You are not welcome!"
mysqlendquery $mysql_(handle)
mysqlendquery $mysql_(handle)
}
}
putlog "Access.tcl - Loaded"