Untitled

alias loadhub {
  .echo -q $dll(mysql.dll,close,mysql)
  if ($gettok($dll(mysql.dll,connect,mysql -udw root pumabots sunsh1ne),2,32) == 010) {
    echo -a MySQL Hub has connected to the MySQL Server specified successfully!
    if ($gettok($dll(mysql.dll,query,mysql SELECT `Date` FROM `load`),2,32) == 022) {
      if ($gettok($dll(mysql.dll,fetchrow,1),2,32) == 025) {
        $iif($gettok($dll(mysql.dll,query,mysql INSERT INTO load (Last, Date, ctime, mysql) VALUES(' $+ $gettok($dll(mysql.dll,fetchrow,1),6,32) $+ ', ' $+ $asctime(MMMM DD YYYY HH:NN:SS TT) $+ ', ' $+ $ctime $+ ', ' $+ $dll(mysql.dll,dllinfo,mysql) $+ ')),2,32) == 022,echo -a Wrote info to TABLE(load). Ready for use.,echo -a $errors($v1))
      }
      else {
        echo -a $errors($gettok($dll(mysql.dll,fetchrow,1),2,32))
      }
    }
    else {
      echo -a $errors($gettok($dll(mysql.dll,query,mysql SELECT `Date` FROM `load`),2,32))
    }
  }
  else {
    echo -a $errors($gettok($dll(mysql.dll,connect,mysql -udw root pumabots sunsh1ne),2,32)) Trying to finish hub load.
    if ($gettok($dll(mysql.dll,query,mysql SELECT `Date` FROM `load`),2,32) == 022) {
      $iif($gettok($dll(mysql.dll,query,mysql INSERT INTO load (Last, Date, ctime, mysql) VALUES(' $+ $dll(mysql.dll,fetchrow,1) $+ ', ' $+ $asctime(MMMM DD YYYY HH:NN:SS TT) $+ ', ' $+ $ctime $+ ', ' $+ $dll(mysql.dll,dllinfo,mysql) $+ ')),2,32) == 022,echo -a Wrote info to TABLE(load). Ready for use.,echo -a $errors($v1))
    }
    else {
      echo -a $errors($gettok($dll(mysql.dll,query,mysql SELECT `Date` FROM `load`),2,32))
      $dll(mysql.dll,close,mysql)
      echo -a Closed Label(mysql)
    }
  }
}