public static List <XHERO> GetAllHeroesFromID(int id_idx) { List <XHERO> Heroes = new List <XHERO>(); //Console.WriteLine("Gettind characters!"); if (conn.State == ConnectionState.Open) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "select hero_order, serial, class, name, hero_type, baselevel, avatar_head, status, status_time from u_hero WHERE id_idx = @id ORDER BY hero_order asc;"; cmd.Parameters.AddWithValue("@id", id_idx); MySqlDataReader reader = cmd.ExecuteReader(); //Console.WriteLine("Columns:" + reader.FieldCount); while (reader.Read()) { XHERO temp = new XHERO(); temp.id_idx = id_idx; temp.hero_order = reader.GetInt32(0); temp.serial = reader.GetInt64(1); temp.hero_class = reader.GetInt32(2); temp.name = reader.GetString(3); temp.hero_type = reader.GetInt32(4); temp.baselevel = reader.GetInt32(5); temp.avatar_head = reader.GetInt32(6); temp.status = reader.GetInt32(7); DateTime status_time = reader.GetDateTime(reader.GetOrdinal("status_time")); temp.status_time = (int)ClientFunctions.GetTotalSecondsFromDateTime(status_time); // Console.WriteLine("Status_time: " + ClientFunctions.GetTotalSecondsFromDateTime(status_time)); //Console.WriteLine("Status_time: " + status_time.ToString("yyyy - MM - dd HH: mm:ss")); Heroes.Add(temp); } reader.Close(); } return(Heroes); }