[PLUS] Randomly numbered Limited Edition.

[Damien]

Someone asked me to code this into plus for them, thought I'd share it for everyone. @Meap

Spoiler: RandomNumber.cs

Firstly add this method:

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;
    }
}

Don't forget the reference:

using System.Collections.Generic;

Spoiler: CatalogItem.cs

Replace the constructor with this:

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;
}

Making sure to add the variable

public List<int> LimitedNumbers { get; private set; }

Spoiler: CatalogManager.cs

Add this method:

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;
}

Then change this script:

_items[PageId].Add(Convert.ToInt32(Row["id"]), new CatalogItem(...));

To this:

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"])));

Making sure to add the appropriate references:

using Plus.Utilities;

Spoiler: CatalogDeal.cs

Change this script:

ItemDataList.Add(new CatalogItem(...));

To this:

ItemDataList.Add(new CatalogItem(0, itemId, data, string.Empty, 0, 0, 0, 0, Amount, new List<int>(), 0, false, "", "", 0));

Spoiler: PurchaseFromCatalogEvent.cs

Find this if statement:

if (item.IsLimited)
{
    ....
}

And change it to this:

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);
    }
}

Then change every reference for:

limitedEditionSells

To this:

limitedEditionNumber

Spoiler: Database Table

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;

And you're done.

 

[Meap]

CREATE TABLE `catalog_items_limited` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(55) NOT NULL DEFAULT '',
  `item_id` varchar(85) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

@Damien

 

[Joe]

What does it do? Randomly give you the #number from the Limited Edition on offer?

 

[Meap]

What does it do? Randomly give you the #number from the Limited Edition on offer?

Its how habbo do their LTD's
instead of it giving you an LTD in increment order so like if theres 20/20 and you buy the first itll give you #1
itll give you a random number out of those 20 available so that way its random at what number you get and it makes getting #1 or whatever number you want a bit more challenging and fun
and everyone gets a chance at getting the #1 LTD

 

[Joe]

Its how habbo do their LTD's
instead of it giving you an LTD in increment order so like if theres 20/20 and you buy the first itll give you #1
itll give you a random number out of those 20 available so that way its random at what number you get and it makes getting #1 or whatever number you want a bit more challenging and fun
and everyone gets a chance at getting the #1 LTD

Thank you. I thought so, when did Habbo change to this style? I always thought first come first server.

It's a good idea, not sure why they didn't do this from the beginning.

 

[Meap]

Thank you. I thought so, when did Habbo change to this style? I always thought first come first server.

It's a good idea, not sure why they didn't do this from the beginning.

think its been like that for a while tbh
pretty sure arcturus also has their LTD's setup like that and it got requested by a user of mine so I tried and failed LOL
then asked the big boss himself if he could do it

 

[Sledmore]

Spooky timing, was literally planning to do this today, what a time saver - thanks for the release.

I'd probably just consider adding a foreign key to the table in relation to the items table, and probably adding two indexes, for example:

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;

 

[Damien]

Spooky timing, was literally planning to do this today, what a time saver - thanks for the release.

I'd probably just consider adding a foreign key to the table in relation to the items table, and probably adding two indexes, for example:

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;

No worries, thanks for the updated sql.

The commit can be located here for convenience to anyone who finds this easier. Just ignore the assembly changes, since I was too lazy to install the correct framework.

https://github.com/DamienJolly/PlusEMU/commit/75d246f5c7a0d7b4c7c24995b867adc6b2d9ba3a

 

[Moonstar]

whats this based on?

 

[Joe]

whats this based on?

If you mean what emulator it’s Plus. My guess R2.

 

[Moonstar]

If you mean what emulator it’s Plus. My guess R2.

Thanks bro,

 

[Damien]

whats this based on?

Should work on most Plus Emulator edits. If you need further help, just make another post and I'll update the main thread with the required changes.