alias mmtime { return $chr(91) $+ $date(dd/mm) $time $+ $chr(93) }
alias mmysql_echo { if (!$window(@MySQL)) { window -ezk0 @MySQL } | echo @MySQL $mmtime $1- }
alias mmysql_info { return 212.97.134.5 zaider_zikkan zikkantour zaider_tour }
alias mmysql_info2 { return 212.97.134.5, zaider_zikkan, zikkantour, zaider_tour }

alias start { return --> }

alias mmysql_connect {
  var %info = $mmysql_info2 | set %sql_conn $mysql_connect(212.97.134.5, zaider_zikkan, zikkantour, zaider_tour)
  if (%sql_conn) { describe $chan $start Connection opened successfully ( Connection ID: SECRET sql_conn ) | .timermmysql_paste 1 2 mmysql_paste } | else { describe $chan $start 4Error connecting: %mysql_errstr (aborting..) | unset %mysql* | unset %sql* }
}
alias mmysql_query { if ($1) { write mysql.txt $1- } | .timermmysql_paste 1 3 mmysql_paste }
alias mmysql_paste {
  if (%sql_conn) {
    if ($mysql_ping(%sql_conn)) {
      if ($read(mysql.txt,1)) { var %sql = $ifmatch | write -dl1 mysql.txt | .timermmysql_paste 1 1 mmysql_paste
        if ($mysql_exec(%sql_conn, %sql)) {
          var %row_id = $mysql_insert_id(%sql_conn) | mmysql_echo Query: %sql
          mmysql_echo Query: Executed succesfully. $iif(%row_id,$chr(40) Inserted ID: %row_id $chr(41))
        }
        else { mmysql_echo 4Error executing query: %sql (saved in mmysql.txt) | mmysql_echo 4Error executing query type: %mysql_errstr | write mmysql.txt %sql }
      }
      else { mmysql_echo Closing connection: No more query's to send.. | mysql_close %sql_conn | unset %mysql* | unset %sql* }
    }
    else { mmysql_echo 4Connection error: %mysql_errstr (reconnecting..) | mysql_close %sql_conn | .timer 1 1 mmysql_connect }
  }
  else { mmysql_echo Connecting to MySQL.. | mmysql_connect }
}