public static mysql_results pre_program(string id) { cmd.CommandText = "SELECT * FROM `pre_program` WHERE `masterID` = " + id; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); mysql_todo[] list = new mysql_todo[50]; mysql_results res = new mysql_results(); TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)); double unixTime = ts.TotalSeconds; int i = 0, j = 0; res.result = false; while (reader.Read()) { if (reader.GetString(2).Length > 2) { list[i] = new mysql_todo(); list[i].sql = "INSERT `log_current_session` SET `type`='cmd', `message`='" + reader.GetString(2) + "',`when`=" + (reader.GetInt32(1) + unixTime).ToString().Replace(',', '.') + ",`who_ID`=" + reader.GetUInt32(5); res.result = true; i++; } } reader.Close(); for (j = 0; j < i; j++) { QueryCommand(list[j].sql); } return(res); }
public static void check() { TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)); double unixTime = ts.TotalSeconds; mysql_results res = new mysql_results(); nxt_result result = new nxt_result(); //check mysql conntection if (mysql.connection.State == ConnectionState.Open || mysql.connection.State == ConnectionState.Connecting) { res = mysql.QueryCommand("SELECT `ID`,`message`,`when` FROM `log_current_session` WHERE `status`='' AND `when`< '" + unixTime.ToString().Replace(',', '.') + "' AND `when`> '" + (unixTime - 100).ToString().Replace(',', '.') + "' AND `type`='cmd' ORDER BY `when` ASC LIMIT 0,1"); if (res.result) { IrcBot.log += DateTime.Now + "checking(" + res.msg + ")..."; result = NXT_ROVER_CONTROL.command_translation(res.msg); if (result.result) { //true cmd.CommandText = "UPDATE `log_current_session` SET `status`='" + result.value + "', `when`='" + unixTime.ToString().Replace(',', '.') + "' WHERE `ID`=" + res.ID; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); reader.Close(); IrcBot.log += "succed\n"; } else { //false cmd.CommandText = "UPDATE `log_current_session` SET `status`='" + result.value + "' WHERE `ID`=" + res.ID; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); reader.Close(); IrcBot.log += "faild\n"; } } } else { //make connecion IrcBot.log += "Mysql connection faild"; mysql.connect(); } }
public static nxt_result run_program_mysql(int name) { nxt_result result = new nxt_result(); mysql_results result_mysql = new mysql_results(); result_mysql = mysql.pre_program(Convert.ToString(name)); if (result_mysql.result == true) { result.result = true; result.value = "succed"; } else { result.result = false; result.value = "Faild"; } return(result); }
public static mysql_results QueryCommand(string sql) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); mysql_results res = new mysql_results(); res.result = false; while (reader.Read()) { res.ID = reader.GetInt32(0); res.msg = reader.GetString(1); res.when = reader.GetDouble(2); res.result = true; } reader.Close(); return(res); }
public static mysql_results QueryCommand(string sql) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); mysql_results res = new mysql_results(); res.result = false; while (reader.Read()) { res.ID = reader.GetInt32(0); res.msg = reader.GetString(1); res.when = reader.GetDouble(2); res.result = true; } reader.Close(); return res; }
public static mysql_results pre_program(string id) { cmd.CommandText = "SELECT * FROM `pre_program` WHERE `masterID` = " + id; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); mysql_todo[] list = new mysql_todo[50]; mysql_results res = new mysql_results(); TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)); double unixTime = ts.TotalSeconds; int i=0,j=0; res.result = false; while (reader.Read()) { if (reader.GetString(2).Length > 2) { list[i] = new mysql_todo(); list[i].sql = "INSERT `log_current_session` SET `type`='cmd', `message`='" + reader.GetString(2) + "',`when`=" + (reader.GetInt32(1) + unixTime).ToString().Replace(',', '.') + ",`who_ID`=" + reader.GetUInt32(5); res.result = true; i++; } } reader.Close(); for (j = 0; j < i; j++) { QueryCommand(list[j].sql); } return res; }
public static void check() { TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)); double unixTime = ts.TotalSeconds; mysql_results res = new mysql_results(); nxt_result result = new nxt_result(); //check mysql conntection if (mysql.connection.State == ConnectionState.Open || mysql.connection.State == ConnectionState.Connecting) { res = mysql.QueryCommand("SELECT `ID`,`message`,`when` FROM `log_current_session` WHERE `status`='' AND `when`< '" + unixTime.ToString().Replace(',', '.') + "' AND `when`> '" + (unixTime-100).ToString().Replace(',', '.') + "' AND `type`='cmd' ORDER BY `when` ASC LIMIT 0,1"); if (res.result) { IrcBot.log += DateTime.Now + "checking(" + res.msg + ")..."; result = NXT_ROVER_CONTROL.command_translation(res.msg); if (result.result) { //true cmd.CommandText = "UPDATE `log_current_session` SET `status`='" + result.value + "', `when`='" + unixTime.ToString().Replace(',', '.') + "' WHERE `ID`=" + res.ID; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); reader.Close(); IrcBot.log += "succed\n"; } else { //false cmd.CommandText = "UPDATE `log_current_session` SET `status`='" + result.value + "' WHERE `ID`=" + res.ID; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); reader.Close(); IrcBot.log += "faild\n"; } } } else { //make connecion IrcBot.log += "Mysql connection faild"; mysql.connect(); } }
public static nxt_result run_program_mysql(int name) { nxt_result result = new nxt_result(); mysql_results result_mysql = new mysql_results(); result_mysql = mysql.pre_program(Convert.ToString(name)); if (result_mysql.result == true) { result.result = true; result.value = "succed"; } else { result.result = false; result.value = "Faild"; } return result; }
public static mysql_results QueryCommand(string sql) { while (in_use == true) { Thread.Sleep(1); } in_use = true; cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 1; mysql_results res = new mysql_results(); try { MySqlDataReader reader = cmd.ExecuteReader(); res.result = false; while (reader.Read()) { res.ID = reader.GetInt32(0); res.msg = reader.GetString(1); res.when = reader.GetDouble(2); res.result = true; } reader.Close(); } catch { res.ID = 0; res.msg = ""; res.when = 0.0; res.result = false; in_use = false; return res; } in_use = false; return res; }