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 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;
}