Reply to thread

Message

<blockquote data-quote="Damien" data-source="post: 447141" data-attributes="member: 72299">Someone asked me to code this into plus for them, thought I'd share it for everyone. [USER=1553]@Meap[/USER][SPOILER=&quot;RandomNumber.cs&quot;]Firstly add this method:[CODE]public static void Shuffle&lt;T&gt;(this List&lt;T&gt; list){&nbsp; &nbsp; int n = list.Count;&nbsp; &nbsp; while (n &gt; 1)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; n--;&nbsp; &nbsp; &nbsp; &nbsp; int k = r.Next(n + 1);&nbsp; &nbsp; &nbsp; &nbsp; T value = list[k];&nbsp; &nbsp; &nbsp; &nbsp; list[k] = list[n];&nbsp; &nbsp; &nbsp; &nbsp; list[n] = value;&nbsp; &nbsp; }}[/CODE]Don't forget the reference:[CODE]using System.Collections.Generic;[/CODE][/SPOILER][SPOILER=&quot;CatalogItem.cs&quot;]Replace the constructor with this:[CODE]public CatalogItem(int id, int itemId, ItemData data, string catalogName, int pageId, int costCredits, int costPixels,&nbsp; &nbsp; int costDiamonds, int amount, int limitedEditionSells, int limitedEditionStack, bool hasOffer, string extraData, string badge, int offerId)&nbsp; &nbsp; int costDiamonds, int amount, List&lt;int&gt; limitedNumbers, int limitedEditionStack, bool hasOffer, string extraData, string badge, int offerId){&nbsp; &nbsp; Id = id;&nbsp; &nbsp; Name = catalogName;&nbsp; &nbsp; ItemId = itemId;&nbsp; &nbsp; Data = data;&nbsp; &nbsp; PageID = pageId;&nbsp; &nbsp; CostCredits = costCredits;&nbsp; &nbsp; CostPixels = costPixels;&nbsp; &nbsp; CostDiamonds = costDiamonds;&nbsp; &nbsp; Amount = amount;&nbsp; &nbsp; LimitedEditionSells = limitedEditionSells;&nbsp; &nbsp; LimitedNumbers = limitedNumbers;&nbsp; &nbsp; LimitedEditionSells = limitedEditionStack - limitedNumbers.Count;&nbsp; &nbsp; LimitedEditionStack = limitedEditionStack;&nbsp; &nbsp; IsLimited = (limitedEditionStack &gt; 0);&nbsp; &nbsp; IsLimited = limitedEditionStack &gt; 0;&nbsp; &nbsp; HaveOffer = hasOffer;&nbsp; &nbsp; ExtraData = extraData;&nbsp; &nbsp; Badge = badge;&nbsp; &nbsp; OfferId = offerId;}[/CODE]Making sure to add the variable[CODE]public List&lt;int&gt; LimitedNumbers { get; private set; }[/CODE][/SPOILER][SPOILER=&quot;CatalogManager.cs&quot;]Add this method:[CODE]private List&lt;int&gt; GetLimitedNumbers(int itemId, int size){&nbsp; &nbsp; List&lt;int&gt; availableNumbers = new List&lt;int&gt;();&nbsp; &nbsp; List&lt;int&gt; takenNumbers = new List&lt;int&gt;();&nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;SELECT `number` FROM `catalog_items_limited` WHERE `item_id` = @itemId&quot;);&nbsp; &nbsp; &nbsp; &nbsp; dbClient.AddParameter(&quot;itemId&quot;, itemId);&nbsp; &nbsp; &nbsp; &nbsp; DataTable limitedNumbers = dbClient.GetTable();&nbsp; &nbsp; &nbsp; &nbsp; if (limitedNumbers != null)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow row in limitedNumbers.Rows)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int numberId = Convert.ToInt32(row[&quot;number&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!takenNumbers.Contains(numberId))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; takenNumbers.Add(numberId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; for (int i = 1; i &lt;= size; i++)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if (!takenNumbers.Contains(i))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; availableNumbers.Add(i);&nbsp; &nbsp; }&nbsp; &nbsp; return availableNumbers;}[/CODE]Then change this script:[CODE]_items[PageId].Add(Convert.ToInt32(Row[&quot;id&quot;]), new CatalogItem(...));[/CODE]To this:[CODE]List&lt;int&gt; limitedNumbers = GetLimitedNumbers(&nbsp; &nbsp; Convert.ToInt32(Row[&quot;id&quot;]),&nbsp; &nbsp; Convert.ToInt32(Row[&quot;limited_stack&quot;]));limitedNumbers.Shuffle();_items[PageId].Add(Convert.ToInt32(Row[&quot;id&quot;]), new CatalogItem(Convert.ToInt32(Row[&quot;id&quot;]), Convert.ToInt32(Row[&quot;item_id&quot;]),&nbsp; &nbsp; Data, Convert.ToString(Row[&quot;catalog_name&quot;]), Convert.ToInt32(Row[&quot;page_id&quot;]), Convert.ToInt32(Row[&quot;cost_credits&quot;]), Convert.ToInt32(Row[&quot;cost_pixels&quot;]), Convert.ToInt32(Row[&quot;cost_diamonds&quot;]),&nbsp; &nbsp; Convert.ToInt32(Row[&quot;amount&quot;]), Convert.ToInt32(Row[&quot;limited_sells&quot;]), Convert.ToInt32(Row[&quot;limited_stack&quot;]), PlusEnvironment.EnumToBool(Row[&quot;offer_active&quot;].ToString()),&nbsp; &nbsp; Convert.ToInt32(Row[&quot;amount&quot;]), limitedNumbers, Convert.ToInt32(Row[&quot;limited_stack&quot;]), PlusEnvironment.EnumToBool(Row[&quot;offer_active&quot;].ToString()),&nbsp; &nbsp; Convert.ToString(Row[&quot;extradata&quot;]), Convert.ToString(Row[&quot;badge&quot;]), Convert.ToInt32(Row[&quot;offer_id&quot;])));[/CODE]Making sure to add the appropriate references:[CODE]using Plus.Utilities;[/CODE][/SPOILER][SPOILER=&quot;CatalogDeal.cs&quot;]Change this script:[CODE]ItemDataList.Add(new CatalogItem(...));[/CODE]To this:[CODE]ItemDataList.Add(new CatalogItem(0, itemId, data, string.Empty, 0, 0, 0, 0, Amount, new List&lt;int&gt;(), 0, false, &quot;&quot;, &quot;&quot;, 0));[/CODE][/SPOILER][SPOILER=&quot;PurchaseFromCatalogEvent.cs&quot;]Find this if statement:[CODE]if (item.IsLimited){&nbsp; &nbsp; ....}[/CODE]And change it to this:[CODE]if (item.IsLimited){&nbsp; &nbsp; if (item.LimitedNumbers.Count &lt;= 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; session.SendNotification(&quot;This item has sold out!\n\n&quot; + &quot;Please note, you have not recieved another item (You have also not been charged for it!)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; session.SendPacket(new CatalogUpdatedComposer());&nbsp; &nbsp; &nbsp; &nbsp; session.SendPacket(new PurchaseOKComposer());&nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; }&nbsp; &nbsp; limitedEditionNumber = item.LimitedNumbers[0];&nbsp; &nbsp; limitedEditionStack = item.LimitedEditionStack;&nbsp; &nbsp; item.LimitedEditionSells++;&nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; dbClient.SetQuery(&quot;INSERT INTO `catalog_items_limited` (`number`, `item_id`) VALUES (@number, @itemId)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; dbClient.AddParameter(&quot;number&quot;, limitedEditionNumber);&nbsp; &nbsp; &nbsp; &nbsp; dbClient.AddParameter(&quot;itemId&quot;, item.Id);&nbsp; &nbsp; &nbsp; &nbsp; dbClient.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; item.LimitedNumbers.Remove(limitedEditionNumber);&nbsp; &nbsp; }}[/CODE]Then change every reference for:[CODE]limitedEditionSells[/CODE]To this:[CODE]limitedEditionNumber[/CODE][/SPOILER][SPOILER=&quot;Database Table&quot;][CODE]CREATE TABLE `catalog_items_limited`&nbsp; (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `number` int(11) NOT NULL DEFAULT 0,&nbsp; `item_id` int(11) NOT NULL DEFAULT 0,&nbsp; PRIMARY KEY (`id`) USING BTREE,&nbsp; UNIQUE INDEX `number, item_id`(`number`, `item_id`) USING BTREE,&nbsp; INDEX `item_id`(`item_id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;[/CODE][/SPOILER]And you're done.</blockquote>

[QUOTE="Damien, post: 447141, member: 72299"] Someone asked me to code this into plus for them, thought I'd share it for everyone. [USER=1553]@Meap[/USER] [SPOILER="RandomNumber.cs"] Firstly add this method: [CODE] public static void Shuffle<T>(this List<T> list) { int n = list.Count; while (n > 1) { n--; int k = r.Next(n + 1); T value = list[k]; list[k] = list[n]; list[n] = value; } } [/CODE] Don't forget the reference: [CODE] using System.Collections.Generic; [/CODE] [/SPOILER] [SPOILER="CatalogItem.cs"] Replace the constructor with this: [CODE] public CatalogItem(int id, int itemId, ItemData data, string catalogName, int pageId, int costCredits, int costPixels, int costDiamonds, int amount, int limitedEditionSells, int limitedEditionStack, bool hasOffer, string extraData, string badge, int offerId) int costDiamonds, int amount, List<int> limitedNumbers, int limitedEditionStack, bool hasOffer, string extraData, string badge, int offerId) { Id = id; Name = catalogName; ItemId = itemId; Data = data; PageID = pageId; CostCredits = costCredits; CostPixels = costPixels; CostDiamonds = costDiamonds; Amount = amount; LimitedEditionSells = limitedEditionSells; LimitedNumbers = limitedNumbers; LimitedEditionSells = limitedEditionStack - limitedNumbers.Count; LimitedEditionStack = limitedEditionStack; IsLimited = (limitedEditionStack > 0); IsLimited = limitedEditionStack > 0; HaveOffer = hasOffer; ExtraData = extraData; Badge = badge; OfferId = offerId; } [/CODE] Making sure to add the variable [CODE] public List<int> LimitedNumbers { get; private set; } [/CODE] [/SPOILER] [SPOILER="CatalogManager.cs"] Add this method: [CODE] private List<int> GetLimitedNumbers(int itemId, int size) { List<int> availableNumbers = new List<int>(); List<int> takenNumbers = new List<int>(); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `number` FROM `catalog_items_limited` WHERE `item_id` = @itemId"); dbClient.AddParameter("itemId", itemId); DataTable limitedNumbers = dbClient.GetTable(); if (limitedNumbers != null) { foreach (DataRow row in limitedNumbers.Rows) { int numberId = Convert.ToInt32(row["number"]); if (!takenNumbers.Contains(numberId)) takenNumbers.Add(numberId); } } } for (int i = 1; i <= size; i++) { if (!takenNumbers.Contains(i)) availableNumbers.Add(i); } return availableNumbers; } [/CODE] Then change this script: [CODE] _items[PageId].Add(Convert.ToInt32(Row["id"]), new CatalogItem(...)); [/CODE] To this: [CODE] List<int> limitedNumbers = GetLimitedNumbers( Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["limited_stack"])); limitedNumbers.Shuffle(); _items[PageId].Add(Convert.ToInt32(Row["id"]), new CatalogItem(Convert.ToInt32(Row["id"]), Convert.ToInt32(Row["item_id"]), Data, Convert.ToString(Row["catalog_name"]), Convert.ToInt32(Row["page_id"]), Convert.ToInt32(Row["cost_credits"]), Convert.ToInt32(Row["cost_pixels"]), Convert.ToInt32(Row["cost_diamonds"]), Convert.ToInt32(Row["amount"]), Convert.ToInt32(Row["limited_sells"]), Convert.ToInt32(Row["limited_stack"]), PlusEnvironment.EnumToBool(Row["offer_active"].ToString()), Convert.ToInt32(Row["amount"]), limitedNumbers, Convert.ToInt32(Row["limited_stack"]), PlusEnvironment.EnumToBool(Row["offer_active"].ToString()), Convert.ToString(Row["extradata"]), Convert.ToString(Row["badge"]), Convert.ToInt32(Row["offer_id"]))); [/CODE] Making sure to add the appropriate references: [CODE] using Plus.Utilities; [/CODE] [/SPOILER] [SPOILER="CatalogDeal.cs"] Change this script: [CODE] ItemDataList.Add(new CatalogItem(...)); [/CODE] To this: [CODE] ItemDataList.Add(new CatalogItem(0, itemId, data, string.Empty, 0, 0, 0, 0, Amount, new List<int>(), 0, false, "", "", 0)); [/CODE] [/SPOILER] [SPOILER="PurchaseFromCatalogEvent.cs"] Find this if statement: [CODE] if (item.IsLimited) { .... } [/CODE] And change it to this: [CODE] if (item.IsLimited) { if (item.LimitedNumbers.Count <= 0) { session.SendNotification("This item has sold out!\n\n" + "Please note, you have not recieved another item (You have also not been charged for it!)"); session.SendPacket(new CatalogUpdatedComposer()); session.SendPacket(new PurchaseOKComposer()); return; } limitedEditionNumber = item.LimitedNumbers[0]; limitedEditionStack = item.LimitedEditionStack; item.LimitedEditionSells++; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("INSERT INTO `catalog_items_limited` (`number`, `item_id`) VALUES (@number, @itemId)"); dbClient.AddParameter("number", limitedEditionNumber); dbClient.AddParameter("itemId", item.Id); dbClient.RunQuery(); item.LimitedNumbers.Remove(limitedEditionNumber); } } [/CODE] Then change every reference for: [CODE] limitedEditionSells [/CODE] To this: [CODE] limitedEditionNumber [/CODE] [/SPOILER] [SPOILER="Database Table"] [CODE] CREATE TABLE `catalog_items_limited` ( `id` int(11) NOT NULL AUTO_INCREMENT, `number` int(11) NOT NULL DEFAULT 0, `item_id` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `number, item_id`(`number`, `item_id`) USING BTREE, INDEX `item_id`(`item_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; [/CODE] [/SPOILER] And you're done. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members