Reply to thread

Message

<blockquote data-quote="Kashi" data-source="post: 461944" data-attributes="member: 47548">[CODE=cpp]&nbsp; &nbsp; &nbsp;&nbsp; public static RoomItem PlaceItemToRoomReturn(uint BaseId, int X, int Y, double Z, int Rot, bool FromInventory, uint roomid, bool ToDB = true)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter dbClient = Plus.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Room Room = GenerateRoom(roomid);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int ItDemId = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; uint ItemId = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (ToDB)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;INSERT INTO items_rooms (user_id,base_item) VALUES (1, &quot; + BaseId + &quot;)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;SELECT id FROM items_rooms WHERE user_id = '1' AND room_id = 0 AND base_item = '&quot; + BaseId + &quot;' ORDER BY id DESC LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ItDemId = dbClient.GetInteger();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ItemId = Convert.ToUInt32(ItDemId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;SELECT id FROM items_rooms WHERE user_id = '1' AND room_id = 0 ORDER BY id DESC LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ItDemId = dbClient.GetInteger();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ItemId = Convert.ToUInt32(ItDemId) + 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RoomItem RoomItem = new RoomItem(ItemId, Room.RoomId, BaseId, &quot;&quot;, X, Y, Z, Rot, Room, Convert.ToUInt32(Room.RoomData.OwnerId), 0, 3537, &quot;&quot;, false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Room.GetRoomItemHandler().SetRockItem(RoomItem, X, Y, Rot, true, false, true, false, false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return RoomItem;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]Here was the snippet for PlaceItemToRoom found in RoleplayManager.cs</blockquote>

[QUOTE="Kashi, post: 461944, member: 47548"] [CODE=cpp] public static RoomItem PlaceItemToRoomReturn(uint BaseId, int X, int Y, double Z, int Rot, bool FromInventory, uint roomid, bool ToDB = true) { using (IQueryAdapter dbClient = Plus.GetDatabaseManager().GetQueryReactor()) { Room Room = GenerateRoom(roomid); int ItDemId = 0; uint ItemId = 0; if (ToDB) { dbClient.SetQuery("INSERT INTO items_rooms (user_id,base_item) VALUES (1, " + BaseId + ")"); dbClient.RunQuery(); dbClient.SetQuery("SELECT id FROM items_rooms WHERE user_id = '1' AND room_id = 0 AND base_item = '" + BaseId + "' ORDER BY id DESC LIMIT 1"); ItDemId = dbClient.GetInteger(); ItemId = Convert.ToUInt32(ItDemId); } else { dbClient.SetQuery("SELECT id FROM items_rooms WHERE user_id = '1' AND room_id = 0 ORDER BY id DESC LIMIT 1"); ItDemId = dbClient.GetInteger(); ItemId = Convert.ToUInt32(ItDemId) + 1; } RoomItem RoomItem = new RoomItem(ItemId, Room.RoomId, BaseId, "", X, Y, Z, Rot, Room, Convert.ToUInt32(Room.RoomData.OwnerId), 0, 3537, "", false); Room.GetRoomItemHandler().SetRockItem(RoomItem, X, Y, Rot, true, false, true, false, false); return RoomItem; } } [/CODE] Here was the snippet for PlaceItemToRoom found in RoleplayManager.cs [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members