[Talkactions] problema con script

Descripcion escribió:hola, tengo un problema con el siguiente script

Código:

function getPremiumPoints(cid)
    local player = Player(cid)
    local query = db.storeQuery("SELECT `premium_points` FROM `accounts` WHERE `id` =" ..player:getAccountId()..";")
 
    if query ~= false then
        local points = result.getNumber(query, 'premium_points')
        print("Has points:" ..points)
        result.free(query)
        return points
    else
        print("Internal database load error.")
        return 0
    end 
end

local function addPlayerPremiumPoints(cid, count)
    db.query('UPDATE accounts SET premium_points = premium_points+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
    print("Points have been set. Now has: " ..getPremiumPoints(cid))
end

function onSay(cid, words, param, channel)
local player = Player(cid)
local cost = 10

    if (getPremiumPoints(cid) >= cost) then
        player:addItem(2390, 1)
        addPlayerPremiumPoints(cid, -cost)
        player:sendTextMessage(MESSAGE_INFO_DESCR, "You have " ..getPremiumPoints(cid).." remaining")
    else
        player:sendTextMessage(MESSAGE_INFO_DESCR, "You only have " .. getPremiumPoints(cid) .. " out of " ..cost.. " required points.")
    end
end

captura del error:

[Tienes que estar registrado y conectado para ver este vínculo]

Captura del Error escribió:Imagen del error:
El error radica en: Consola

Código:


local function getAccountPoints(cid)
    local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE id = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end

local function doAccountAddPoints(cid, count)
    return db.query("UPDATE `znote_accounts` SET `points` = '".. getAccountPoints(cid) + count .."' WHERE id = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")
end

function onSay(cid, words, param, channel)
local cost = 10

    if (getPremiumPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
        doAccountAddPoints(cid, -cost)
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getPremiumPoints(cid).." remaining")
    else
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getPremiumPoints(cid).." out of "..cost.." required points.")
    end
end


Código:






local function getAccountPoints(cid)

   
   local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")

   
   
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end

local function doAccountAddPoints(cid, count)
    return db.query("UPDATE `znote_accounts` SET `points` = '".. getAccountPoints(cid) + count .."' WHERE id = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")
end

function onSay(cid, words, param, channel)
local cost = 10

    if (getPremiumPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
        doAccountAddPoints(cid, -cost)
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getPremiumPoints(cid).." remaining")
    else
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getPremiumPoints(cid).." out of "..cost.." required points.")
    end
end


Código:


local function getAccountPoints(cid)

 
  local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")

 
 
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end

local function doAccountAddPoints(cid, count)
    return db.query("UPDATE `znote_accounts` SET `points` = '".. getAccountPoints(cid) + count .."' WHERE id = " .. getAccountNumberByPlayerName(getCreatureName(cid))..";")
end

function onSay(cid, words, param, channel)
local cost = 10

    if (getAccountPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
        doAccountAddPoints(cid, -cost)
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getAccountPoints(cid).." remaining")
    else
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getAccountPoints(cid).." out of "..cost.." required points.")
    end
end


akane escribió:al parecer funciona, pero no me descuenta los puntos

Código:



local function getAccountPoints(cid)

  
   local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getPlayerAccountId(cid)..";")

  
  
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end

local function doAccountAddPoints(cid, count)
    return db.executeQuery("UPDATE `znote_accounts` SET `points` = `points` + " .. getAccountPoints(cid) + count .. " WHERE `account_id` = " .. getPlayerAccountId(cid))

end

function onSay(cid, words, param, channel)
local cost = 10

    if (getAccountPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
         doAccountAddPoints(cid, -cost)
         doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getAccountPoints(cid).." remaining")
    else
         doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getAccountPoints(cid).." out of "..cost.." required points.")
     end
    return true
end


Código:

local function getAccountPoints(cid)

  
   local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getPlayerAccountId(cid)..";")

  
  
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end

local function doRemovePoints(cid, count)
    return db.executeQuery("UPDATE `znote_accounts` SET `points` = `points` + " .. getAccountPoints(cid) + count .. " WHERE `account_id` = " .. getPlayerAccountId(cid))

end

function onSay(cid, words, param, channel)
local cost = 10

    if (getAccountPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
         doRemovePoints(cid, cost)
         doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getAccountPoints(cid).." remaining")
    else
         doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getAccountPoints(cid).." out of "..cost.." required points.")
     end
    return true
end

Código:



local function getAccountPoints(cid)

 
  local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getPlayerAccountId(cid)..";")

 
 
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end



 local function doRemovePoints(cid, count)
  local Info = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
  if Info:getID() ~= LUA_ERROR then
  db.executeQuery("UPDATE znote_accounts SET points = - " .. count .. " WHERE id=" .. getPlayerAccountId(cid) .. ";")
  Info:free()
  return 1
  end
 end




function onSay(cid, words, param, channel)
local cost = 10

    if (getAccountPoints(cid) >= cost) then
        doPlayerAddItem(cid, 2390, 1)
        doRemovePoints(cid, cost)
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getAccountPoints(cid).." remaining")
    else
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getAccountPoints(cid).." out of "..cost.." required points.")
    end
    return true
end


akane escribió:[Tienes que estar registrado y conectado para ver este vínculo] error

Código:


local function getAccountPoints(cid)

 
  local res = db.getResult("SELECT `points` FROM `znote_accounts` WHERE `account_id` = " .. getPlayerAccountId(cid)..";")

 
 
    if(res:getID() ~= -1) then
        repeat
              return res:getDataInt("points")
          until not(res:next())
        res:free()
    end
end



 
 function doRemovePoints(cid, count)
        return db.executeQuery("UPDATE `znote_accounts` SET `points` = '".. getAccountPoints(cid) - count .."' WHERE `name` ='"..getPlayerAccount(cid).."'")
end




function onSay(cid, words, param, channel)
local cost = 10

    if getAccountPoints(cid) >= cost then
        doPlayerAddItem(cid, 2390, 1)
        doRemovePoints(cid, cost)
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have " ..getAccountPoints(cid).." remaining")
    else
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You only have " ..getAccountPoints(cid).." out of "..cost.." required points.")
    end
    return true
end