on *:INPUT:*: {
  if (!%database) { %database = mirc }
  if ($regex(sql,$1,/(/|/{2})/)) { return }
  if ($1 == ~createtable) && ($2) {
    %db = $2
    var %info_db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass), %db)
    if (%info_db) {
      var %sql = CREATE TABLE $3-
      var %stmt = $mysql_exec(%info.db, %sql)
      if (!%stmt) {
        details
      }
      else {
        mysql_exec %info.db %stmt
      }
    }
  }

  if ($1 == ~insert) && ($2) {
    %db = $2
    %insertdata = $3-
    var %x = 1
    %testvar = $numtok(%insertdata,32)
    while (%x <= %testvar) {
      set %testvar_result $instok(%testvar_result,$mysql_qt($gettok(%insertdata,%x,32)),0,44)
      inc %x
    }
    %db = $3
    var %info.db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass), %db)
    if (%info.db) {
      %sql = INSERT INTO $2 VALUES ( %testvar_result );
      var %stmt = $mysql_exec(%info.db, %sql)
      unset %testvar* %insertdata
      if (!%stmt) {
        details
      }
      else {
        mysql_exec %info.db %stmt
        $mysql_insert_id(%db)
      }

    }
  }
  if ($1 == ~createdb) && ($2) {
    var %info.db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass))
    if (%info.db) {
      %sql = CREATE DATABASE $2
      %res = $mysql_query(%info.db, %sql)
      mysql_exec %info.db %res
      mysql_close %info.db
    }
    else {
      details
    }
  }
  if ($1 == ~get) && ($2) {
    %db = $2
    %table = $3
    var %info = $+($replace($4-,*,%,?,_)), %name = $iif($4-,$4-, $4-)
    echo -a $iif($4-,$4-, $4-)
    var %info.db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass), %db)
    %sql = SELECT name, entry, ItemLevel, RequiredLevel, description, quality FROM %db $+ . $+ %table WHERE name LIKE $mysql_qt(%info) ORDER BY ItemLevel DESC
    var %res = $mysql_query(%info.db, %sql, %info)
    echo -a %name
    if (%info.db) && (%res) {
      var %i = 1
      msg $chan Found: $mysql_num_rows(%res) items matching your query: $4-
      while ($mysql_fetch_row(%res, row)) {
        if ($hget(row, quality) == 5) {
          echo -a Item Name:07 $hget(row, name) Item ID:07 $hget(row, entry) Item Level:07 $hget(row, ItemLevel)
          inc %i
        }
        if ($hget(row, quality) == 4) {
          echo -a Item Name:6 $hget(row, name) Item ID:06 $hget(row, entry) Item Level:06 $hget(row, ItemLevel)
          inc %i
        }
        if ($hget(row, quality) == 3) {
          echo -a Item Name:12 $hget(row, name) Item ID:12 $hget(row, entry) Item Level:12 $hget(row, ItemLevel)
          inc %i
        }
        if ($hget(row, quality) == 2) {
          echo -a Item Name:09 $hget(row, name) Item ID:09 $hget(row, entry) Item Level:09 $hget(row, ItemLevel)
          inc %i
        }
        if ($hget(row, quality) == 1) {
          echo -a Item Name:00 $hget(row, name) Item ID:00 $hget(row, entry) Item Level:00 $hget(row, ItemLevel)
          inc %i
        }
        if ($hget(row, quality) == 0) {
          echo -a Item Name:15 $hget(row, name) Item ID:15 $hget(row, entry) Item Level:15 $hget(row, ItemLevel)
          inc %i
        }
      }
      mysql_free %res
      mysql_close %info.db
    }
    else {
      details
    }

  }
}