public static GroupsManager AddGuild(int id, string name, int ownerid, string ownername, string description, int roomid, string image, int customcolor1, int customcolor2, int guildbase, int guildbasecolor, List <int> guildstates, string htmlcolor1, string htmlcolor2, string datecreated, Dictionary <int, string> members, List <int> petitions, int type, int rightstype) { using (DatabaseClient dbClient = Essential.GetDatabase().GetClient()) { try { try { id = dbClient.ReadInt32("SELECT ID FROM groups ORDER BY ID DESC LIMIT 1") + 1; } catch { id = 1; } string str = ""; foreach (int num in guildstates) { str = str + num + ";"; } str = str.Substring(0, str.Length - 1); dbClient.AddParamWithValue("id", id); dbClient.AddParamWithValue("name", name); dbClient.AddParamWithValue("ownerid", ownerid); dbClient.AddParamWithValue("description", description); dbClient.AddParamWithValue("roomid", roomid); dbClient.AddParamWithValue("image", image); dbClient.AddParamWithValue("htmlcolor1", htmlcolor1); dbClient.AddParamWithValue("htmlcolor2", htmlcolor2); dbClient.AddParamWithValue("datecreated", datecreated); dbClient.AddParamWithValue("guildstates", str); dbClient.AddParamWithValue("guildbase", guildbase); dbClient.AddParamWithValue("guildbasecolor", guildbasecolor); dbClient.ExecuteQuery("INSERT INTO groups (`id`,`name`,`ownerid`,`desc`,`roomid`,`badge`,`color_one`,`color_two`,`created`,`GuildStates`,`GuildBase`,`GuildBaseColor`) VALUES (@id, @name, @ownerid, @description, @roomid, @image, @htmlcolor1, @htmlcolor2, @datecreated,@guildstates,@guildbase,@guildbasecolor);"); dbClient.ExecuteQuery("INSERT INTO group_memberships (groupid, userid) VALUES (" + id + "," + ownerid + ")"); }catch (Exception ex) { Console.WriteLine(ex.ToString()); } GroupsManager newGuild = new GroupsManager(id, dbClient.ReadDataRow("SELECT * FROM groups WHERE id=" + id + " LIMIT 1"), dbClient); Groups.GroupsManager.Add(id, newGuild); return(newGuild); } }
public static void RemoveGroup(GroupsManager guild) { using(DatabaseClient dbClient = Essential.GetDatabase().GetClient()) { dbClient.ExecuteQuery("DELETE FROM groups WHERE id=" + guild.Id); dbClient.ExecuteQuery("DELETE FROM group_memberships WHERE groupid=" + guild.Id); dbClient.ExecuteQuery("DELETE FROM group_requests WHERE groupid=" + guild.Id); dbClient.ExecuteQuery("UPDATE user_stats SET groupid=0 WHERE groupid=" + guild.Id); //dbClient.ExecuteQuery("UPDATE items SET guild_data='0;0;0' WHERE guild_data LIKE '" + guild.Id + ";%'"); foreach(GameClient gc in Essential.GetGame().GetClientManager().GetClients()) { if(gc != null && gc.GetHabbo() != null&& gc.GetHabbo().InGuild(guild.Id)) { if (gc.GetHabbo().FavouriteGroup == guild.Id) gc.GetHabbo().FavouriteGroup = 0; gc.GetHabbo().RefreshGuilds(); } } Groups.GroupsManager.Remove(guild.Id); } }
public static void UpdateGroup(DatabaseClient class6_0, int int_0) { GroupsManager @class = Groups.GetGroupById(int_0); if (@class != null) { DataRow Row = class6_0.ReadDataRow("SELECT * FROM groups WHERE Id = " + int_0 + " LIMIT 1"); @class.Name = (string)Row["name"]; @class.Badge = (string)Row["badge"]; @class.RoomId = (uint)Row["roomid"]; @class.Description = (string)Row["desc"]; @class.Locked = (string)Row["locked"]; @class.ColorOne = (string)Row["color_one"]; @class.ColorTwo = (string)Row["color_two"]; @class.Created = Essential.TimestampToDate(double.Parse((string)Row["created"])).ToShortDateString(); @class.Members.Clear(); DataTable dataTable = class6_0.ReadDataTable("SELECT userid FROM group_memberships WHERE groupid = " + int_0 + ";"); foreach (DataRow dataRow2 in dataTable.Rows) { @class.JoinGroup((int)dataRow2["userid"]); } } }
public static void RemoveGroup(GroupsManager guild) { using (DatabaseClient dbClient = Essential.GetDatabase().GetClient()) { dbClient.ExecuteQuery("DELETE FROM groups WHERE id=" + guild.Id); dbClient.ExecuteQuery("DELETE FROM group_memberships WHERE groupid=" + guild.Id); dbClient.ExecuteQuery("DELETE FROM group_requests WHERE groupid=" + guild.Id); dbClient.ExecuteQuery("UPDATE user_stats SET groupid=0 WHERE groupid=" + guild.Id); //dbClient.ExecuteQuery("UPDATE items SET guild_data='0;0;0' WHERE guild_data LIKE '" + guild.Id + ";%'"); foreach (GameClient gc in Essential.GetGame().GetClientManager().GetClients()) { if (gc != null && gc.GetHabbo() != null && gc.GetHabbo().InGuild(guild.Id)) { if (gc.GetHabbo().FavouriteGroup == guild.Id) { gc.GetHabbo().FavouriteGroup = 0; } gc.GetHabbo().RefreshGuilds(); } } Groups.GroupsManager.Remove(guild.Id); } }
public static GroupsManager AddGuild(int id, string name, int ownerid, string ownername, string description, int roomid, string image, int customcolor1, int customcolor2, int guildbase, int guildbasecolor, List<int> guildstates, string htmlcolor1, string htmlcolor2, string datecreated, Dictionary<int, string> members, List<int> petitions, int type, int rightstype) { using (DatabaseClient dbClient = Essential.GetDatabase().GetClient()) { try { try { id = dbClient.ReadInt32("SELECT ID FROM groups ORDER BY ID DESC LIMIT 1") + 1; } catch { id = 1; } string str = ""; foreach (int num in guildstates) { str = str + num + ";"; } str = str.Substring(0, str.Length - 1); dbClient.AddParamWithValue("id", id); dbClient.AddParamWithValue("name", name); dbClient.AddParamWithValue("ownerid", ownerid); dbClient.AddParamWithValue("description", description); dbClient.AddParamWithValue("roomid", roomid); dbClient.AddParamWithValue("image", image); dbClient.AddParamWithValue("htmlcolor1", htmlcolor1); dbClient.AddParamWithValue("htmlcolor2", htmlcolor2); dbClient.AddParamWithValue("datecreated", datecreated); dbClient.AddParamWithValue("guildstates", str); dbClient.AddParamWithValue("guildbase", guildbase); dbClient.AddParamWithValue("guildbasecolor", guildbasecolor); dbClient.ExecuteQuery("INSERT INTO groups (`id`,`name`,`ownerid`,`desc`,`roomid`,`badge`,`color_one`,`color_two`,`created`,`GuildStates`,`GuildBase`,`GuildBaseColor`) VALUES (@id, @name, @ownerid, @description, @roomid, @image, @htmlcolor1, @htmlcolor2, @datecreated,@guildstates,@guildbase,@guildbasecolor);"); dbClient.ExecuteQuery("INSERT INTO group_memberships (groupid, userid) VALUES (" + id + "," + ownerid + ")"); }catch(Exception ex) { Console.WriteLine(ex.ToString()); } GroupsManager newGuild = new GroupsManager(id, dbClient.ReadDataRow("SELECT * FROM groups WHERE id=" + id + " LIMIT 1"), dbClient); Groups.GroupsManager.Add(id, newGuild); return newGuild; } }