/// <summary>
/// Get Server Channel info by server id
/// </summary>
/// <param name="svId"></param>
/// <returns></returns>
public static List<Channel> GetServerChannel(int svId)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
List<Channel> list = new List<Channel>();
using (MySqlCommand command = connection.CreateCommand())
{
command.CommandText = "SRV_CHANNEL_INFO_GET";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@worldId", svId);
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Channel ch = new Channel()
{
wid = reader.GetInt32(0),
id = reader.GetInt32(1),
name = reader.GetString(2),
port = reader.GetInt32(3),
max_user = reader.GetInt32(4),
type = reader.GetInt32(5)
};
list.Add(ch);
}
}
reader.Close();
}
connection.Close();
return list;
}
}
public SpSelectSrv(int svid, int chid)
{
SrvInfo = AgentServer.SvrListInfo.Where(v => v.id == svid).FirstOrDefault();
ChnInfo = SrvInfo.channels.Where(v => v.id == chid).FirstOrDefault();
}
public SpSelectSrv(int svid, int chid)
{
SrvInfo = AgentServer.SvrListInfo.Where(v => v.id == svid).FirstOrDefault();
ChnInfo = SrvInfo.channels.Where(v => v.id == chid).FirstOrDefault();
}