local STORE_SYSTEM_VERSION = "1.0.0"
print(">> Loaded Store System v" .. STORE_SYSTEM_VERSION)
-- Premium Store System
-- Configuration for store items
local storeItems = {
["/shop1"] = {itemId = 2160, price = 1, name = "Crystal Coin"}, -- Example item
["/shop2"] = {itemId = 2400, price = 1, name = "Magic Sword"}, -- Example item
["/shop3"] = {itemId = 2195, price = 1, name = "Boots of Haste"}, -- Example item
["/shop4"] = {itemId = 2493, price = 1, name = "Demon Helmet"} -- Example item
}
-- Improved premium points getter function
function Player.getPremiumPoints(self)
if not self then
return 0
end
local accountId = self:getAccountId()
if not accountId then
return 0
end
local query = string.format("SELECT `premium_points` FROM `accounts` WHERE `id` = %d", accountId)
local resultId = db.storeQuery(query)
if not resultId then
return 0
end
local points = result.getNumber(resultId, "premium_points")
result.free(resultId)
return points or 0
end
-- Function to update premium points
function Player.removePremiumPoints(self, points)
if not self or points <= 0 then
return false
end
local accountId = self:getAccountId()
if not accountId then
return false
end
local query = string.format("UPDATE `accounts` SET `premium_points` = `premium_points` - %d WHERE `id` = %d", points, accountId)
return db.query(query)
end
-- Helper function to check if player can carry the item
function Player.canCarryItem(self, itemId)
if not self or not itemId then
return false
end
-- Check if player has a backpack and enough slots
local backpack = self:getSlotItem(CONST_SLOT_BACKPACK)
if not backpack or backpack:getEmptySlots(false) < 1 then
return false
end
-- Check weight capacity using ItemType
local itemType = ItemType(itemId)
if not itemType then
return false
end
return self:getFreeCapacity() >= itemType:getWeight()
end
-- Main store function handler
local function handleStoreCommand(player, words, param)
if not player:isPlayer() then
return false
end
-- Remove the '/' from the command to match our storeItems keys
local command = words:lower()
local storeItem = storeItems[command]
if not storeItem then
player:sendTextMessage(MESSAGE_STATUS_SMALL, "This store command does not exist.")
return false
end
-- Check premium points
local playerPoints = player:getPremiumPoints()
if playerPoints < storeItem.price then
player:sendTextMessage(MESSAGE_STATUS_SMALL, string.format("You need %d premium points to buy %s. You have only %d points.",
storeItem.price, storeItem.name, playerPoints))
return false
end
-- Check if player can carry the item
if not player:canCarryItem(storeItem.itemId) then
player:sendTextMessage(MESSAGE_STATUS_SMALL, "Your main backpack is full or you don't have enough capacity. You need at least 1 free slot.")
return false
end
-- Create item and remove points
local item = player:addItem(storeItem.itemId, 1)
if not item then
player:sendTextMessage(MESSAGE_STATUS_SMALL, "Failed to create the item.")
return false
end
-- Remove premium points
if not player:removePremiumPoints(storeItem.price) then
-- If points removal fails, remove the item
item:remove()
player:sendTextMessage(MESSAGE_STATUS_SMALL, "Transaction failed. Please try again.")
return false
end
player:sendTextMessage(MESSAGE_INFO_DESCR, string.format("You have successfully purchased %s for %d premium points.",
storeItem.name, storeItem.price))
return true
end
-- Register each store command individually
for command, _ in pairs(storeItems) do
local commandName = command:sub(2) -- remove the '/' from the command
local talkAction = TalkAction(command)
talkAction:separator(" ")
talkAction:onSay(function(player, words, param)
return handleStoreCommand(player, command, param)
end)
talkAction:register()
end
but I cannot get it to work.
