internal void RunDBUpdate() { //DateTime Start = DateTime.Now; try { if (mRemovedItems.Count > 0 || mAddedItems.Count > 0 || InventoryPets.Count > 0) { QueryChunk queries = new QueryChunk(); if (mAddedItems.Count > 0) //This should be checked more carefully { foreach (UserItem Item in mAddedItems.Values) { queries.AddQuery("UPDATE items_users SET user_id = " + UserId + " WHERE item_id = " + Item.Id); //parameters.Add("extra_data" + Item.Id, Item.ExtraData); //QueryBuilder.Append("UPDATE user_items SET user_id = " + UserId + " , base_item =" + Item.BaseItem + ", extra_data = @extra_data" + Item.Id + " WHERE id = " + Item.Id + "; "); } mAddedItems.Clear(); } if (mRemovedItems.Count > 0) { foreach (UInt32 ItemID in mRemovedItems.ToArray()) { queries.AddQuery("DELETE FROM items_users WHERE item_id=" + ItemID + " AND user_id=" + UserId); } mRemovedItems.Clear(); } foreach (Pet pet in InventoryPets.Values) { if (pet.DBState == DatabaseUpdateState.NeedsUpdate) { queries.AddParameter(pet.PetId + "name", pet.Name); queries.AddParameter(pet.PetId + "race", pet.Race); queries.AddParameter(pet.PetId + "color", pet.Color); queries.AddQuery("UPDATE user_pets SET room_id = " + pet.RoomId + ", name = @" + pet.PetId + "name, race = @" + pet.PetId + "race, color = @" + pet.PetId + "color, type = " + pet.Type + ", expirience = " + pet.Expirience + ", " + "energy = " + pet.Energy + ", nutrition = " + pet.Nutrition + ", respect = " + pet.Respect + ", createstamp = '" + pet.CreationStamp + "', x = " + pet.X + ", Y = " + pet.Y + ", Z = " + pet.Z + " WHERE id = " + pet.PetId); } pet.DBState = DatabaseUpdateState.Updated; } using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor()) { queries.Execute(dbClient); } } } catch (Exception e) { Logging.LogCacheError("FATAL ERROR DURING USER INVENTORY DB UPDATE: " + e.ToString()); } }
internal void RunDBUpdate() { //DateTime Start = DateTime.Now; try { if (mRemovedItems.Count > 0 || mAddedItems.Count > 0 || InventoryPets.Count > 0) { QueryChunk queries = new QueryChunk(); if (mAddedItems.Count > 0) { foreach (UserItem Item in mAddedItems.Values) { queries.AddQuery("UPDATE items_users SET user_id = " + UserId + " WHERE item_id = " + Item.itemID); } mAddedItems.Clear(); } if (mRemovedItems.Count > 0) { foreach (UInt32 ItemID in mRemovedItems.ToArray()) { queries.AddQuery("DELETE FROM items_users WHERE item_id=" + ItemID + " AND user_id=" + UserId); } mRemovedItems.Clear(); } lock (InventoryPets) { foreach (Pet pet in InventoryPets.Values) { if (pet.databaseState == DatabaseUpdateState.PendingUpdate) { queries.AddParameter(pet.petID + "name", pet.name); queries.AddParameter(pet.petID + "race", pet.race); queries.AddParameter(pet.petID + "color", pet.color); queries.AddQuery("UPDATE user_pets SET room_id = " + pet.roomID + ", name = @" + pet.petID + "name, race = @" + pet.petID + "race, color = @" + pet.petID + "color, type = " + pet.petType + ", expirience = " + pet.experience + ", " + "energy = " + pet.energy + ", nutrition = " + pet.nutrition + ", respect = " + pet.respect + ", createstamp = '" + pet.creationStamp + "', x = " + pet.X + ", Y = " + pet.Y + ", Z = " + pet.Z + " WHERE id = " + pet.petID); } pet.databaseState = DatabaseUpdateState.Syncronized; } } using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor()) { queries.Execute(dbClient); } } } catch (Exception e) { Logging.LogCacheError("FATAL ERROR DURING USER INVENTORY DB UPDATE: " + e.ToString()); } }
internal ServerMessage SerializeNavigator(GameClient session, int mode) { if (mode > -1) return SerializeActiveRooms(mode); ServerMessage reply = PacketHandelingManager.GetRecycledItem(OutputCode.GuestRoomSearchResultEvent); switch (mode) { case -5: { reply.AddInt32(mode); List<RoomData> activeFriends = session.GetHabboDataContainer().GetChatMessenger().GetActiveFriendsRooms().OrderByDescending(p => p.UsersNow).ToList(); SerializeNavigatorRooms(ref reply, activeFriends); return reply; } case -4: { reply.AddInt32(mode); List<string> FriendsNames = session.GetHabboDataContainer().GetChatMessenger().GetFriendUsernames().ToList(); if (FriendsNames.Count == 0) { SerializeNavigatorRooms(ref reply, new List<RoomData>()); return reply; } QueryChunk Query = new QueryChunk("SELECT rooms.*, room_active.active_users FROM rooms LEFT JOIN room_active ON (room_active.roomid = rooms.id) WHERE"); int i = 0; foreach (string Name in FriendsNames) { if (i > 0) Query.AddSpecialRawQuery(" OR"); Query.AddSpecialRawQuery(" owner = '" + ButterflyEnvironment.FilterInjectionChars(Name, true) + "'"); i++; } Query.AddQuery(" ORDER BY room_active.active_users DESC LIMIT 40;"); using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor()) { Query.Execute(dbClient); DataTable dTable = dbClient.getTable(); List<RoomData> parsedRoomData = new List<RoomData>(); foreach (DataRow dRow in dTable.Rows) { RoomData data = new RoomData(); data.Fill(dRow); bool any = false; foreach (RoomData p in parsedRoomData) { if (p.Id == data.Id) { any = true; break; } if (p.Name == data.Name) { any = true; break; } } if (any) continue; parsedRoomData.Add(data); } SerializeNavigatorRooms(ref reply, parsedRoomData); Query.Dispose(); } FriendsNames = null; return reply; } case -3: { reply.AddInt32(mode); SerializeNavigatorRooms(ref reply, session.GetHabbo().UsersRooms); return reply; } case -2: { reply.AddInt32(mode); int count = 0; ISortable<RoomData>[] rooms = ButterflyEnvironment.GetGame().GetRoomManager().GetActiveRooms(out count); SerializeNavigatorRooms(reply, rooms, count); rooms = null; return reply; } case -1: { reply.AddInt32(mode); int count = 0; ISortable<RoomData>[] rooms = ButterflyEnvironment.GetGame().GetRoomManager().GetActiveRooms(out count); SerializeNavigatorRooms(reply, rooms, count); rooms = null; return reply; } } return reply; }
internal void SaveFurniture(IQueryAdapter dbClient) { //if (dbClient.dbType == Database_Manager.Database.DatabaseType.MSSQL) //{ // SaveFurnitureToMSSQL(dbClient); // return; //} try { if (mAddedItems.Count > 0 || mRemovedItems.Count > 0 || mMovedItems.Count > 0 || room.GetRoomUserManager().PetCount > 0) { QueryChunk standardQueries = new QueryChunk(); QueryChunk itemInserts = new QueryChunk("REPLACE INTO items_rooms (item_id,room_id,x,y,n) VALUES "); QueryChunk extradataInserts = new QueryChunk("REPLACE INTO items_extradata (item_id,data) VALUES "); foreach (RoomItem Item in mRemovedItems.Values) { standardQueries.AddQuery("DELETE FROM items_rooms WHERE item_id = " + Item.Id + " AND room_id = " + room.RoomId); //Do join + function } if (mAddedItems.Count > 0) { foreach (RoomItem Item in mAddedItems.Values) { if (!string.IsNullOrEmpty(Item.ExtraData)) { extradataInserts.AddQuery("(" + Item.Id + ",@data_id" + Item.Id + ")"); extradataInserts.AddParameter("@data_id" + Item.Id, Item.ExtraData); } if (Item.IsFloorItem) { double combinedCoords = TextHandling.CombineDBVal(Item.GetX, Item.GetY); itemInserts.AddQuery("(" + Item.Id + "," + Item.RoomId + "," + TextHandling.GetString(combinedCoords) + "," + TextHandling.GetString(Item.GetZ) + "," + Item.Rot + ")"); } else { itemInserts.AddQuery("(" + Item.Id + "," + Item.RoomId + "," + TextHandling.GetString(Item.wallCoord.GetXValue()) + "," + TextHandling.GetString(Item.wallCoord.GetYValue()) + "," + Item.wallCoord.n() + ")"); } } } foreach (RoomItem Item in mMovedItems.Values) { if (!string.IsNullOrEmpty(Item.ExtraData)) { standardQueries.AddQuery("UPDATE items_extradata SET data = @data" + Item.Id + " WHERE item_id = " + Item.Id); standardQueries.AddParameter("data" + Item.Id, Item.ExtraData); } if (Item.IsWallItem) { standardQueries.AddQuery("UPDATE items_rooms SET x=" + TextHandling.GetString(Item.wallCoord.GetXValue()) + ", y=" + TextHandling.GetString(Item.wallCoord.GetYValue()) + ", n=" + Item.wallCoord.n() + " WHERE item_id = " + Item.Id); } else { double combinedCoords = TextHandling.CombineDBVal(Item.GetX, Item.GetY); standardQueries.AddQuery("UPDATE items_rooms SET x=" + TextHandling.GetString(combinedCoords) + ", y=" + TextHandling.GetString(Item.GetZ) + ", n=" + Item.Rot + " WHERE item_id = " + Item.Id); } } room.GetRoomUserManager().AppendPetsUpdateString(dbClient); mAddedItems.Clear(); mRemovedItems.Clear(); mMovedItems.Clear(); standardQueries.Execute(dbClient); itemInserts.Execute(dbClient); extradataInserts.Execute(dbClient); standardQueries.Dispose(); itemInserts.Dispose(); extradataInserts.Dispose(); standardQueries = null; itemInserts = null; extradataInserts = null; } } catch (Exception e) { Logging.LogCriticalException("Error during saving furniture for room " + room.RoomId + ". Stack: " + e.ToString()); } }
internal void AppendPetsUpdateString(IQueryAdapter dbClient) { QueryChunk inserts = new QueryChunk("INSERT INTO user_pets (id,user_id,room_id,name,type,race,color,expirience,energy,createstamp,nutrition,respect,z,y,z) VALUES "); QueryChunk updates = new QueryChunk(); List<uint> petsSaved = new List<uint>(); foreach (Pet pet in GetPets()) { if (petsSaved.Contains(pet.PetId)) continue; petsSaved.Add(pet.PetId); if (pet.DBState == DatabaseUpdateState.NeedsInsert) { inserts.AddParameter(pet.PetId + "name", pet.Name); inserts.AddParameter(pet.PetId + "race", pet.Race); inserts.AddParameter(pet.PetId + "color", pet.Color); inserts.AddQuery("(" + pet.PetId + "," + pet.OwnerId + "," + pet.RoomId + ",@" + pet.PetId + "name," + pet.Type + ",@" + pet.PetId + "race,@" + pet.PetId + "color,0,100,'" + pet.CreationStamp + "',0,0,0,0,0)"); } else if (pet.DBState == DatabaseUpdateState.NeedsUpdate) { updates.AddParameter(pet.PetId + "name", pet.Name); updates.AddParameter(pet.PetId + "race", pet.Race); updates.AddParameter(pet.PetId + "color", pet.Color); updates.AddQuery("UPDATE user_pets SET room_id = " + pet.RoomId + ", name = @" + pet.PetId + "name, race = @" + pet.PetId + "race, color = @" + pet.PetId + "color, type = " + pet.Type + ", expirience = " + pet.Expirience + ", " + "energy = " + pet.Energy + ", nutrition = " + pet.Nutrition + ", respect = " + pet.Respect + ", createstamp = '" + pet.CreationStamp + "', x = " + pet.X + ", Y = " + pet.Y + ", Z = " + pet.Z + " WHERE id = " + pet.PetId); } pet.DBState = DatabaseUpdateState.Updated; } inserts.Execute(dbClient); updates.Execute(dbClient); inserts.Dispose(); updates.Dispose(); inserts = null; updates = null; }