Lua Function query[Solved]

[Scrappy Coco]

when to click on the item . throws this error


script:

function getPlayerFrags(cid)
    local player = Player(cid)
    local resultId = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = " ..getCreatureName(cid) ..db.escapeString(frags))
    if resultId ~= false then
        local accountId = result.getDataInt(resultId, "frags")
        result.free(resultId)
        return accountId
    end
    return 0
end
function onUse(cid, item)
   local Player = Player(cid)
    Player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "Frags:"..getplayerfrags()..".")
    Player:getPosition():sendMagicEffect(CONST_ME_MAGIC_GREEN)
    return true
end

Tenks

 

[Nothxbye]

Player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "Frags:"..getPlayerFrags(cid)..".")

 

[Scrappy Coco]

does not work, the same error keeps coming.

 

[whitevo]

CaPiTal letters matter!!
And put "cid" inside parameters

 

[Scrappy Coco]

Testing and not result the same error keeps coming.

 

[whitevo]

Testing and not result the same error keeps coming.

funny that its not possible to get same error.

 

[imkingran]

Testing and not result the same error keeps coming.

EDIT: Sorry, same thing as whitevo said, we posted in like the same second.

Are you sure you changed the script? The original error was because you used lower cased letter and you didn't include (cid) inside the function.

It's impossible to have the SAME ERROR unless you didn't change the script.

 

[Scrappy Coco]

Look @imkingran @whitevo


this is script:

function getPlayerFrags(cid)
    local player = Player(cid)
    local resultid = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = " ..getCreatureName(cid) ..db.escapeString(frags))
    if resultid ~= false then
        local accountid = result.getDataInt(resultid, "frags")
        result.free(resultid)
        return accountid
    end
    return 0
end

function onUse(cid, item)
   local Player = Player(cid)
    Player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "Frags:"..getPlayerFrags(cid)".")
    Player:getPosition():sendMagicEffect(CONST_ME_MAGIC_GREEN)
    return true
end

 

[whitevo]

result.getDataInt
this function gives you nil value

 

[Scrappy Coco]

How do I fix use or that function ?

 

[Elgenady]

function getPlayerFrags(cid)
    local player = Player(cid)
    local resultid = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = " ..getCreatureName(cid) ..db.escapeString(frags))
    if resultid ~= false then
        local accountid = result.getDataInt(resultid, "frags")
        result.free(resultid)
        return accountid
    end
    return 0
end

function onUse(cid, item)
   local Player = Player(cid)
    Player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "Frags:"..getPlayerFrags(cid)".")
    Player:getPosition():sendMagicEffect(CONST_ME_MAGIC_GREEN)
    return true
end

 

[Scrappy Coco]

@heba


fuck

 

[Elgenady]

try its now ?

 

[StreamSide]

change

local resultId = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = " ..getCreatureName(cid) ..db.escapeString(frags))

to

local resultId = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = " ..player:getName()")

 

[Scrappy Coco]

@StreamSide @heba



still not working : / have something to do database

 

[whitevo]

result.getDataInt()
is this a global function??

Show us what does it do with the id and string.

 

[Scrappy Coco]

not solved whitevo

Bump!

 

[imkingran]

You're using TFS 1.0 I presume?

function onSay(cid, words, param)
    local player = Player(cid)
    local resultId = db.storeQuery("SELECT `frags` FROM `players` WHERE `name` = '" .. player:getName() .."';")
    if (resultId ~= false) then
        fragCount =  tonumber(result.getDataInt(resultId, "frags"))
        result.free(resultId)
    else
        fragCount = 0
    end
   
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "Frags: "..fragCount..".")
    player:getPosition():sendMagicEffect(CONST_ME_MAGIC_GREEN)
    return false
end

 

[Scrappy Coco]

@whitevo @imkingran @StreamSide @heba
@Nothxbye
thanks everyone for your help [PROBLEM SOLVED]