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
ID
Unique key for each item
category
Identificator of category from itemshop_category
vnum
Identificator of item from item_proto
price
Price of item
price_type
List with type of currency
count
Count of item
bonus_type
List with the type of bonuses. To make the selection window visible, add two items with the same `ID` and separate `bonus_type`
socket0-socket5
Defined by administrator value of each socket
attrype0-attrtype6
Defined by administrator type of each attribute
attrvalue0-attrvalue6
Defined by administrator value of each attribute
fixed_count
If true, in game you can only buy set amount of item, if false, you can input this number
add_time
Time when item was added
discount
Value of which item is less expensive
discount_time
Time, when discount expires
additional_time
When you buy limited time item, administrator can define this time here
limited_time
How long the item is available
limited_count
Quantity for which the sale of the item is blocked
limited_buy_count
Number of items that players have already purchased (do not change!)
is_vip
If 1, the item is a VIP pack (extra experience, increased storage, etc), if 0, a normal item
limited_buy_time
If the value is set, the player can only purchase the item from time to time, specified here in seconds
itemshop_editor
name
Name of the character, that can manage sale in game
itemshop_statistics
id
Key of item from table itemshop_items
category
Key of group from table itemshop_items
count
Actual count of sold item
itemshop_wheel_group
id
Unique key of each wheel group
price
Price of spinning
price_type
If “cash” – you pay premium currency, if “yang” – you pay Yang, in any other case, you pay set item vnum
itemshop_wheel_item
group
Key of group from table itemshop_wheel_group
item_vnum
Identificator of item from item_proto
item_count
Count of item you get if win
chance
Chance of getting certain item
itemshop_daily_reward
day
Number of day in calendar, from 1 to 28
vnum
Identificator of item from item_proto
count
Count of item you get
itemshop_category
id
Unique key of each category
name
The 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.
