on *:TEXT:!test:#: {
  top
  msg $chan || test message. ||
}
alias top {
  echo -a $dll(mysql.dll,Connect,res -huwd server user pw db)
  echo -a $dll(MySQL.dll,Query,res SELECT * FROM test_table ORDER BY label2 ASC) 
  var %i = 1  
&Acirc;&nbsp; while (%i < 6) { 
&Acirc;&nbsp; &Acirc;&nbsp; set %search.result $dll(MySQL.dll,FetchRow,res %i) 
&Acirc;&nbsp; &Acirc;&nbsp; if ($gettok(%search.result,1,9)) && ($gettok(%search.result,2,9)) { 
&Acirc;&nbsp; &Acirc;&nbsp; &Acirc;&nbsp; echo -a TEMP: $gettok(%search.result,1,9) - $gettok(%search.result,2,9)
&Acirc;&nbsp; &Acirc;&nbsp; &Acirc;&nbsp; inc %i 
&Acirc;&nbsp; &Acirc;&nbsp; } 
&Acirc;&nbsp; }
}

Add a code snippet to your website: www.paste.org