Reply to thread

Message

<blockquote data-quote="Kodys" data-source="post: 390598" data-attributes="member: 71959">Your post was the most pointless and retarded shit you've posted, yet.. you copied and pasted what he wrote and posted it back and claimed you was helping.. k[spoiler=Bad attempt at tutorial kinda shit idk][USER=18160]@JMG[/USER] I've not tested this although I'm sure this should work, it also needs a new permission command_convert_diamonds but if you want use command_convert_credits tbh.[code=c#]using System;using System.Linq;using System.Text;using System.Collections.Generic;using System.Data;using Plus.HabboHotel.Items;using Plus.Communication.Packets.Outgoing.Inventory.Purse;using Plus.Database.Interfaces;namespace Plus.HabboHotel.Rooms.Chat.Commands.User{&nbsp; &nbsp; class ConvertDiamondsCommand : IChatCommand&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string PermissionRequired&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;command_convert_diamonds&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Parameters&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Description&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;Convert your exchangeable furniture into actual diamonds.&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int TotalValue = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable Table = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&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` WHERE `user_id` = '&quot; + Session.GetHabbo().Id + &quot;' AND (`room_id`=&nbsp; '0' OR `room_id` = '')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table = dbClient.getTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Table == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;You currently have no items in your inventory!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow Row in Table.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Item Item = Session.GetHabbo().GetInventoryComponent().GetItem(Convert.ToInt32(Row[0]));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Item == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; continue;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!Item.GetBaseItem().ItemName.StartsWith(&quot;what the diamond furniture starts with&quot;) &amp;&amp; !Item.GetBaseItem().ItemName.StartsWith(&quot;is there any other diamond furniture maybe&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; continue;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Item.RoomId &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; continue;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string[] Split = Item.GetBaseItem().ItemName.Split('_');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int Value = int.Parse(Split[1]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbClient.RunQuery(&quot;DELETE FROM `items` WHERE `id` = '&quot; + Item.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.GetHabbo().GetInventoryComponent().RemoveItem(Item.Id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TotalValue += Value;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Value &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.GetHabbo().Diamonds += Value;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendMessage(new HabboActivityPointNotificationComposer(Session.GetHabbo().Diamonds, Value, 5));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (TotalValue &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendNotification(&quot;All diamonds have successfully been converted!\r\r(Total value: &quot; + TotalValue + &quot; diamonds!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendNotification(&quot;It appears you don't have any exchangeable items!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendNotification(&quot;Oops, an error occoured whilst converting your diamonds!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/code]There are some strings that you'll need to change - I'd advice you to name all your diamond furniture something along the lines D_%VALUE%.For example if you wanted to create a furni that's worth 250 diamonds and is a suitcase you'd run a query along the lines of... (I'm not good with furniture so I apologise if the query I supplied doesn't work)[code=MySQL]INSERT INTO `furniture` (`item_name`, `public_name`, `sprite_id`) VALUES ('D_250_suitcase', 'D_250_suitcase', '5461')[/code]As you can see it's named D_250_suitcase, the D_ is what the command would search for (if you've set it to that) in the furniture so it knows it's an exchangeable diamond furni, the _ are used to split up the name 250 being the price which is converted to an int and the _suitcase is there in case you'd like to have other diamond exchangeable furni that exchanges into 250 diamonds, you'd name those things such as D_250_throne, D_250_duck.Btw be sure to change the strings in if (!Item.GetBaseItem().ItemName.StartsWith(&quot;what the diamond furniture starts with&quot;) &amp;&amp; !Item.GetBaseItem().ItemName.StartsWith(&quot;is there any other diamond furniture maybe&quot;)) to something like &quot;D_&quot; if you're using my query shit.TLDR: Command checks for furni including whatever you want at the start, uses _ to split the string, grabs number after first _ in the furni name and puts that into the users purse. Name the furni something to easily identify it's exchangeable diamond furni using _ to split it up.[/spoiler]Tbh just PM me if that was too confusing - confusing myself a bit.</blockquote>

[QUOTE="Kodys, post: 390598, member: 71959"] Your post was the most pointless and retarded shit you've posted, yet.. you copied and pasted what he wrote and posted it back and claimed you was helping.. k [spoiler=Bad attempt at tutorial kinda shit idk] [USER=18160]@JMG[/USER] I've not tested this although I'm sure this should work, it also needs a new permission command_convert_diamonds but if you want use command_convert_credits tbh. [code=c#] using System; using System.Linq; using System.Text; using System.Collections.Generic; using System.Data; using Plus.HabboHotel.Items; using Plus.Communication.Packets.Outgoing.Inventory.Purse; using Plus.Database.Interfaces; namespace Plus.HabboHotel.Rooms.Chat.Commands.User { class ConvertDiamondsCommand : IChatCommand { public string PermissionRequired { get { return "command_convert_diamonds"; } } public string Parameters { get { return ""; } } public string Description { get { return "Convert your exchangeable furniture into actual diamonds."; } } public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { int TotalValue = 0; try { DataTable Table = null; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id` FROM `items` WHERE `user_id` = '" + Session.GetHabbo().Id + "' AND (`room_id`= '0' OR `room_id` = '')"); Table = dbClient.getTable(); } if (Table == null) { Session.SendWhisper("You currently have no items in your inventory!"); return; } foreach (DataRow Row in Table.Rows) { Item Item = Session.GetHabbo().GetInventoryComponent().GetItem(Convert.ToInt32(Row[0])); if (Item == null) continue; if (!Item.GetBaseItem().ItemName.StartsWith("what the diamond furniture starts with") && !Item.GetBaseItem().ItemName.StartsWith("is there any other diamond furniture maybe")) continue; if (Item.RoomId > 0) continue; string[] Split = Item.GetBaseItem().ItemName.Split('_'); int Value = int.Parse(Split[1]); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.RunQuery("DELETE FROM `items` WHERE `id` = '" + Item.Id + "' LIMIT 1"); } Session.GetHabbo().GetInventoryComponent().RemoveItem(Item.Id); TotalValue += Value; if (Value > 0) { Session.GetHabbo().Diamonds += Value; Session.SendMessage(new HabboActivityPointNotificationComposer(Session.GetHabbo().Diamonds, Value, 5)); } } if (TotalValue > 0) Session.SendNotification("All diamonds have successfully been converted!\r\r(Total value: " + TotalValue + " diamonds!"); else Session.SendNotification("It appears you don't have any exchangeable items!"); } catch { Session.SendNotification("Oops, an error occoured whilst converting your diamonds!"); } } } } [/code] There are some strings that you'll need to change - I'd advice you to name all your diamond furniture something along the lines D_%VALUE%. For example if you wanted to create a furni that's worth 250 diamonds and is a suitcase you'd run a query along the lines of... (I'm not good with furniture so I apologise if the query I supplied doesn't work) [code=MySQL] INSERT INTO `furniture` (`item_name`, `public_name`, `sprite_id`) VALUES ('D_250_suitcase', 'D_250_suitcase', '5461') [/code] As you can see it's named [B]D_250_suitcase[/B], the [B]D_[/B] is what the command would search for (if you've set it to that) in the furniture so it knows it's an exchangeable diamond furni, the _ are used to split up the name [B]250[/B] being the price which is converted to an int and the [B]_suitcase[/B] is there in case you'd like to have other diamond exchangeable furni that exchanges into 250 diamonds, you'd name those things such as [B]D_250_throne[/B], [B]D_250_duck[/B]. Btw be sure to change the strings in [I]if (!Item.GetBaseItem().ItemName.StartsWith("what the diamond furniture starts with") && !Item.GetBaseItem().ItemName.StartsWith("is there any other diamond furniture maybe")) [/I]to something like "D_" if you're using my query shit. TLDR: Command checks for furni including whatever you want at the start, uses _ to split the string, grabs number after first _ in the furni name and puts that into the users purse. Name the furni something to easily identify it's exchangeable diamond furni using _ to split it up. [/spoiler] Tbh just PM me if that was too confusing - confusing myself a bit. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members