Forums Scripts & Popups Timer Problem

/timer1 1 5 echo test

on *:JOIN:#:{
  /timer1 1 5 {
    var %mask =  $address($nick,5)
    var %mask_1 = $remove($mask(%mask,2),*!*)
    var %mask_2 = $mask(%mask,0)
    var %mask_final $replace(%mask_2,%mask_1,@*)
    ; Check if the nick has used this address before
    var %sql = SELECT ff_id FROM voice WHERE channel = ? AND nick = ? AND address = ?
    var %res = $mysql_query(%track.db, %sql, $chan, $nick, %mask_final)
    ; Check the result
    if ($mysql_num_rows(%res) > 0) {
      ; Found an existing row, just update the time
      ;var %id = $mysql_fetch_single(%res)
      ;%sql = UPDATE track SET time = NOW() WHERE id = %id
      ;mysql_exec %track.db %sql
      mode $chan +v $nick
    }
    else {
      ; No existing row, insert a new one
      ;var %sql = INSERT INTO track (network, nick, address, time) VALUES (?, ?, ?, NOW())
      ;noop $mysql_exec(%track.db, %sql, $network, $nick, $address)
      return
    }
    ; Free the result
    mysql_free %res
  }
}
 

on !*:JOIN:#:.timer 1 5 check_nick $nick $chan $fulladdress $network $address

alias check_nick {
var %mask = $+(*!,$gettok($gettok($3,1,64),2,33),@*)
; Check if the nick has used this address before
var %sql = SELECT ff_id FROM voice WHERE channel = ? AND nick = ? AND address = ?
var %res = $mysql_query(%track.db, %sql, $2, $1, %mask)
; Check the result
if ($mysql_num_rows(%res) > 0) {
; Found an existing row, just update the time
;var %id = $mysql_fetch_single(%res)
;%sql = UPDATE track SET time = NOW() WHERE id = %id
;mysql_exec %track.db %sql
mode $chan +v $nick
}
else {
      ; No existing row, insert a new one
      ;var %sql = INSERT INTO track (network, nick, address, time) VALUES (?, ?, ?, NOW())
      ;noop $mysql_exec(%track.db, %sql, $4, $1, $5)
      return
    }
    ; Free the result
    mysql_free %res
  }
}