public TournamentChannelManager GetChannelManager(MySqlConnection conn, ulong tourn_id)
{
string q = string.Format("SELECT * from tournaments WHERE ID='{0}'", tourn_id);
MySqlDataReader rdr = ExecuteQuery(conn, q);
if (!rdr.HasRows)
{
return(null);
}
TournamentChannelManager mgr = new TournamentChannelManager();
while (rdr.Read())
{
mgr.RoleID = rdr.GetUInt64(rdr.GetOrdinal("role_id"));
mgr.AnnouncementChannelID = rdr.GetUInt64(rdr.GetOrdinal("announcement_channel_id"));
mgr.CategoryChannelID = rdr.GetUInt64(rdr.GetOrdinal("category_id"));
mgr.RegistationChannelID = rdr.GetUInt64(rdr.GetOrdinal("registration_channel_id"));
mgr.ManagementChannelID = rdr.GetUInt64(rdr.GetOrdinal("management_channel_id"));
mgr.ScoreReportChannelID = rdr.GetUInt64(rdr.GetOrdinal("scorereport_channel_id"));
}
rdr.Close();
return(mgr);
}
public void ApplyChannelManagerChanges(MySqlConnection conn, TournamentChannelManager mgr, ulong guild_id, ulong tourn_id)
{
string q = string.Format("UPDATE tournaments SET announcement_channel_id = '{0}', registration_channel_id = '{1}', management_channel_id = '{2}', scorereport_channel_id = '{3}', role_id = '{4}' WHERE guild_id = '{5}' AND ID = '{6}'",
mgr.AnnouncementChannelID, mgr.RegistationChannelID, mgr.ManagementChannelID, mgr.ScoreReportChannelID, mgr.RoleID, guild_id, tourn_id);
MySqlDataReader rdr = ExecuteQuery(conn, q);
rdr?.Close();
}