Skip to content
Home » Systems » Itemshop


    Short description

    Itemshop is a place, where player can buy some exclusive items by premium currency. Bought goods go straight into inventory.

    • Why would I have this system in game?
      • Opening web browser while farming might be irritating. In addition to that, you have to take out items from store. With my solution you get it done with just a few clicks.
    • How is this different to other’s solutions?
      • Developing this beauty, I did buckle down to optimization and security. It has been developed since 2018 with different successions, but this version is like a well-cut suit. I won’t stop on that, there are new things to be added.
    • Is this tried and true?
      • I spend a lot of time finding errors not visible at the first glance. All functions are tested well and secure. You can go and see system in action on live servers.

    Some of the functions

    Let’s have a look at certain parts of the window.

    Just a banner and 9 of most bought items.

    Here you can see a list of items splitted to certain categories. Search bar will help with finding desirable item.

    Those, who love the thrill would be happy here. On the left, you can see buttons for each group of items, in the middle sits The Wheel, on the right list of items you can actually get. At the bottom just a small tip for you to inform you how much does it cost to spin and how much you are left with.

    We all love to see a discount. You are able to set so.

    Hard-bitten players would be rewarded with new items when they login and get a reward daily. Don’t forget to click, one day off and your streak is gone.

    Ability to choose which bonuses you want the purchased item to have

    Items available in limited quantities and/or for a limited time.

    VIP packets to be purchased in-game, available without re-logging.

    In-game notification when a new item is on sale

    By opening the items tab, the player can filter items by currency.

    Button for automatic spinning

    Some geeky stuff

    Some info about database structure for system.

    • itemshop_items
    IDUnique key for each item
    categoryIdentificator of category from itemshop_category
    vnumIdentificator of item from item_proto
    pricePrice of item
    price_typeList with type of currency
    countCount of item
    bonus_typeList with the type of bonuses. To make the selection window visible, add two items with the same `ID` and separate `bonus_type`
    socket0-socket5Defined by administrator value of each socket
    attrype0-attrtype6Defined by administrator type of each attribute
    attrvalue0-attrvalue6Defined by administrator value of each attribute
    fixed_countIf true, in game you can only buy set amount of item, if false, you can input this number
    add_timeTime when item was added
    discountValue of which item is less expensive
    discount_timeTime, when discount expires
    additional_timeWhen you buy limited time item, administrator can define this time here
    limited_timeHow long the item is available
    limited_countQuantity for which the sale of the item is blocked
    limited_buy_countNumber of items that players have already purchased (do not change!)
    is_vipIf 1, the item is a VIP pack (extra experience, increased storage, etc), if 0, a normal item
    limited_buy_timeIf the value is set, the player can only purchase the item from time to time, specified here in seconds
    • itemshop_editor
    nameName of the character, that can manage sale in game
    • itemshop_statistics
    idKey of item from table itemshop_items
    category Key of group from table itemshop_items
    countActual count of sold item
    • itemshop_wheel_group
    idUnique key of each wheel group
    pricePrice of spinning
    price_typeIf “cash” – you pay premium currency, if “yang” – you pay Yang, in any other case, you pay set item vnum
    • itemshop_wheel_item
    groupKey of group from table itemshop_wheel_group
    item_vnum Identificator of item from item_proto
    item_countCount of item you get if win
    chanceChance of getting certain item
    • itemshop_daily_reward
    dayNumber of day in calendar, from 1 to 28
    vnum Identificator of item from item_proto
    count Count of item you get
    • itemshop_category
    idUnique key of each category
    nameThe name of the category, the client will try to find this value in the localeInfo, so setting “ITEMSHOP_CATEGORY_01” will get the translated text.

    Price: 200€