HELP! I know its easy for you lua scripters!

[scarface77]

hello I got VIP coins script (when you use it gives you 1 point to SQL database and the item dissapear) and it works good, but I want to make it able to use only if you have 10+ vip coins and it takes 10 vip voins and adds 10 points to SQL.

the script

function onUse(cid, item, fromPosition, itemEx, toPosition)
	if item.itemid >= 1 then
local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")

local points = query:getDataInt("premium_points")

db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points + 1).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")



doSendMagicEffect(getThingPos(cid), CONST_ME_GIFT_WRAPS)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have added 1 points to site shop.")


end

doRemoveItem(cid, item.uid, 1)
return true
end

 

[Bogart]

function onUse(cid, item, fromPosition, itemEx, toPosition)
    if item.type >= 10 then
    local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
      local points = query:getDataInt("premium_points")
      db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points + 10).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")
                        doSendMagicEffect(getThingPos(cid), CONST_ME_GIFT_WRAPS)
                                    doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have added 10 points to site shop.")
                             doRemoveItem(cid, item.itemid, 10)
                  elseif item.type <= 9 then
                      doSendMagicEffect(getThingPos(cid), CONST_ME_PUFF)
                      doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You don\'t have the required items.")
                 end
      
return true
end

 

[DukeeH]

my fault, i thought wrong.

 

[Shinmaru]

@OP
Is the Item stackable?

@Bogart

item.itemid >= 10?   item.type >= 10 <<< only if the item is stackable, if not then you have to use
getPlayerItemCount(cid, item.itemid) >= 10 then

 

[Bogart]

hes talking about coins, so I thought he may be using golden nuggets or something like that

 

[scarface77]

yeah using king of coins, but how can i add
"getPlayerItemCount(cid, item.itemid) >= 10 then"
to my script?

 

[scarface77]

got this error:
[18/04/2011 19:31:29] [Error - LuaScriptInterface::loadFile] data/actions/scripts/other/pkt.lua:16: 'end' expected (to close 'function' at line 2) near '<eof>'
[18/04/2011 19:31:29] [Warning - Event::loadScript] Cannot load script (data/actions/scripts/other/pkt.lua)
[18/04/2011 19:31:29] data/actions/scripts/other/pkt.lua:16: 'end' expected (to close 'function' at line 2) near '<eof>'

and lua script:

function onUse(cid, item, fromPosition, itemEx, toPosition)
if getPlayerItemCount(cid, item.itemid) >= 10 then
local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
local points = query:getDataInt("premium_points")
db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points + 10).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")
doSendMagicEffect(getThingPos(cid), CONST_ME_GIFT_WRAPS)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have added 10 points to site shop.")
doRemoveItem(cid, item.itemid, 10)
else
doSendMagicEffect(getThingPos(cid), CONST_ME_PUFF)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You don\'t have the required items.")
end

return true

 

[scarface77]

Ok it works!

Edit:
function onUse(cid, item, fromPosition, itemEx, toPosition)
if item.type >= 100 then
local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
local points = query:getDataInt("premium_points")
db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points + 100).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")
doSendMagicEffect(getThingPos(cid), CONST_ME_GIFT_WRAPS)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have added 100 points to site shop.")
doRemoveItem(cid, item.uid, 100)
elseif item.type <= 99 then
doSendMagicEffect(getThingPos(cid), CONST_ME_PUFF)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You need 100 VIP coins to add it to shop.")
end

return true
end

 

[Bogart]

got this error:
[18/04/2011 19:31:29] [Error - LuaScriptInterface::loadFile] data/actions/scripts/other/pkt.lua:16: 'end' expected (to close 'function' at line 2) near '<eof>'
[18/04/2011 19:31:29] [Warning - Event::loadScript] Cannot load script (data/actions/scripts/other/pkt.lua)
[18/04/2011 19:31:29] data/actions/scripts/other/pkt.lua:16: 'end' expected (to close 'function' at line 2) near '<eof>'

and lua script:

function onUse(cid, item, fromPosition, itemEx, toPosition)
if getPlayerItemCount(cid, item.itemid) >= 10 then
local query = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
local points = query:getDataInt("premium_points")
db.executeQuery("UPDATE `accounts` SET `premium_points`= "..(points + 10).." WHERE `id`= " .. getPlayerAccountId(cid) .. "; ")
doSendMagicEffect(getThingPos(cid), CONST_ME_GIFT_WRAPS)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have added 10 points to site shop.")
doRemoveItem(cid, item.itemid, 10)
else
doSendMagicEffect(getThingPos(cid), CONST_ME_PUFF)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You don\'t have the required items.")
end

return true

fail copying and pasting