public Group CreateGroup(GameClient creator, string name, string description, int roomID, int color1, int color2, List<Tuple<int, int, int>> badgeData) { // We call this method after doing all checks. int groupID; string badgeCode = Group.GenerateBadgeImage(badgeData); string createTime = DateTime.Now.ToString("d-M-yyyy"); using (IQueryAdapter dbClient = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { // Insert the group dbClient.setQuery("INSERT INTO guild(name,description,badge,users_id,rooms_id,color1,color2,date_created) VALUES(@name,@desc,@badge,@ownerid,@roomid,@color1,@color2,@date)"); dbClient.addParameter("name", name); dbClient.addParameter("desc", description); dbClient.addParameter("ownerid", creator.GetHabbo().Id); dbClient.addParameter("roomid", roomID); dbClient.addParameter("color1", color1); dbClient.addParameter("color2", color2); dbClient.addParameter("badge", badgeCode); dbClient.addParameter("date", createTime); groupID = (int)dbClient.insertQuery(); } Group group = new Group() { ID = groupID, Name = name, Description = description, RoomID = roomID, ColorID1 = color1, ColorID2 = color2, BadgeCode = badgeCode, DateCreated = createTime, }; return group; }
public Group CreateGroup(GameClient creator, string name, string description, int roomID, int color1, int color2, List<Tuple<int, int, int>> badgeData) { // We call this method after doing all checks. int groupID; //string badgeCode = Group.GenerateBadgeImage(badgeData); string createTime = DateTime.Now.ToString("d-M-yyyy"); using (IQueryAdapter dbClient = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { // Insert the group dbClient.setQuery("INSERT INTO groups(name,description,badge_data,users_id,rooms_id,color1,color2,date_created) VALUES(@name,@desc,@badge,@ownerid,@roomid,@color1,@color2,@date)"); dbClient.addParameter("name", name); dbClient.addParameter("desc", description); dbClient.addParameter("ownerid", creator.GetHabbo().Id); dbClient.addParameter("roomid", roomID); dbClient.addParameter("color1", color1); dbClient.addParameter("color2", color2); dbClient.addParameter("badge", Group.ConvertBadgeForDatabase(badgeData)); dbClient.addParameter("date", createTime); groupID = (int)dbClient.insertQuery(); // Create membership for owner dbClient.setQuery("INSERT INTO group_memberships VALUES(@id,@groupid,3,1)"); dbClient.addParameter("id", creator.GetHabbo().Id); dbClient.addParameter("groupid", groupID); dbClient.runQuery(); // Update room dbClient.runFastQuery("UPDATE rooms SET groups_id = " + groupID + " WHERE id = " + roomID); } Group group = new Group() { ID = groupID, Name = name, Description = description, RoomID = roomID, ColorID1 = color1, ColorID2 = color2, BadgeData = badgeData, DateCreated = createTime }; group.Members.Add(creator.GetHabbo().Id); string s = group.BadgeCode; return group; }
internal void LoadGroups(IQueryAdapter dbClient) { dbClient.setQuery("SELECT * FROM groups"); DataTable GroupTable = dbClient.getTable(); foreach (DataRow Group in GroupTable.Rows) { dbClient.setQuery("SELECT * FROM `group_memberships` WHERE `id` = @id"); dbClient.addParameter("id", (int)Group["id"]); Group group = new Group(Group, dbClient.getTable()); } }
internal bool LoadGroup(int id) { using (IQueryAdapter dbClient = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { dbClient.setQuery("SELECT * FROM guild WHERE id = @id"); dbClient.addParameter("id", id); DataRow row = dbClient.getRow(); if (row == null || row.ItemArray.Length == 0) return false; dbClient.setQuery("SELECT * FROM group_memberships WHERE id = @id"); dbClient.addParameter("id", id); Group group = new Group(row, dbClient.getTable()); Groups.Add(id, group); return true; } }
private void Initialize(UInt32 Id, string Name, string Description, string Owner, int OwnerId, int Category, int State, int UsersMax, string ModelName, int Score, List<string> pTags, bool AllowPets, bool AllowPetsEating, bool AllowWalkthrough, bool Hidewall, string Password, string Wallpaper, string Floor, string Landscape, RoomData RoomData, bool RightOverride, int walltickness, int floorthickness, Group group) { this.mDisposed = false; this.Id = Id; this.Name = Name; this.Description = Description; this.Owner = Owner; this.OwnerId = OwnerId; this.Category = Category; this.State = State; this.UsersNow = 0; this.UsersMax = UsersMax; this.ModelName = ModelName; this.Score = Score; tagCount = 0; this.Tags = new ArrayList(); foreach (string tag in pTags) { tagCount++; Tags.Add(tag); } this.AllowPets = AllowPets; this.AllowPetsEating = AllowPetsEating; this.AllowWalkthrough = AllowWalkthrough; this.Hidewall = Hidewall; this.Password = Password; this.Bans = new Dictionary<int, double>(); this.Wallpaper = Wallpaper; this.Floor = Floor; this.Landscape = Landscape; this.chatMessageManager = new ChatMessageManager(); this.ActiveTrades = new ArrayList(); this.mCycleEnded = false; this.mRoomData = RoomData; this.EveryoneGotRights = RightOverride; this.roomMessages = new Queue(); this.chatMessageQueue = new Queue(); this.rnd = new Random(); this.roomMessages = new Queue(); this.roomAlerts = new Queue(); this.roomBadge = new Queue(); this.roomKick = new Queue(); this.roomServerMessages = new Queue(); this.IdleTime = 0; this.RoomMuted = false; this.WallThickness = walltickness; this.FloorThickness = floorthickness; this.gamemap = new GameMap(this); this.roomItemHandling = new RoomItemHandling(this); this.roomUserManager = new RoomUnitManager(this); this.wiredHandler = new WiredHandler(this); this.Group = group; LoadRights(); GetRoomItemHandler().LoadFurniture(); wiredHandler.LoadWired(); GetGameMap().GenerateMaps(); LoadMusic(); //LoadBots(); using (IQueryAdapter dbClient = FirewindEnvironment.GetDatabaseManager().getQueryreactor()) { dbClient.runFastQuery("REPLACE INTO room_active VALUES (" + Id + ",1)"); } FirewindEnvironment.GetGame().GetRoomManager().QueueActiveRoomAdd(mRoomData); }