Lua getPlayerCap

[Erick Lua]

Hello everyone, I got a problem with this function that returns the player total capacity but it returns me a nil value, can anyone help me?

function getPlayerCap(cid)
	query = db.getResult("SELECT `cap` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")
	if(query:getID() < 1) then
		return nil
	end
	cap = query:getDataInt("cap")
	query:free()
	return cap
end

 

[Guiaki]

function getPlayerCap(cid)
	local v = db.getResult("SELECT `cap` FROM `players` WHERE `id` = "..getPlayerGUID(cid)..";")
	local cap = v:getDataInt("cap", getPlayerGUID(cid))
	return cap
end

Tested and working, but it will send the player max capacity, know this.

I'll be glad if you rep++

 

[Erick Lua]

works like a charm, thanks
rep ++

 

[Cykotitan]

this is done faster with getPlayerVocation and formulas for each voc