Windows Is it possible to check how much money...

[Xeo]

Is it possible to check how much money every player has?like sql command or something?
Thanks.

 

[devianceone]

Yes its possible.

 

[president vankk]

function onSay(cid, words, param)

local config = {
        bankSystemEnabled = getBooleanFromString(getConfigInfo('bankSystem')),
        playerIsFighting = hasCondition(cid, CONDITION_INFIGHT)
}

if config.bankSystemEnabled == TRUE then
        if config.playerIsFighting == FALSE then

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your account balance is " .. getPlayerBalance(cid) .. ".")
        return TRUE
else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Bank can not be used in fight.")
        return TRUE
end
else
        return FALSE
        end
end

 

[Xeo]

function onSay(cid, words, param)

local config = {
        bankSystemEnabled = getBooleanFromString(getConfigInfo('bankSystem')),
        playerIsFighting = hasCondition(cid, CONDITION_INFIGHT)
}

if config.bankSystemEnabled == TRUE then
        if config.playerIsFighting == FALSE then

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your account balance is " .. getPlayerBalance(cid) .. ".")
        return TRUE
else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Bank can not be used in fight.")
        return TRUE
end
else
        return FALSE
        end
end

Isnt that bank system code? what if the player doesnt uses it and the money is inside his depot

 

[devianceone]

@up are you talking about getting the players money for a website or ingame? try getPlayerMoney(cid) ?

 

[Xeo]

@up are you talking about getting the players money for a website or ingame? try getPlayerMoney(cid) ?

Hm,Ingame ..but I don't know how to

 

[Tairens]

Try this function

function getPlayerMoneyEx(cid)
	local pid = getPlayerGUID(cid)
	if(pid == nil) then
		error("Cannot load player.")
	end
	local count, moneyInItems, moneyInDp = 0, 0, 0
	local ids = {{2160, 10000}, {2152, 100}, {2148, 1}}
	for i = 1, 3 do
		moneyInItems = db.getResult("SELECT `count` FROM `player_items` WHERE `player_id` = " ..pid.. " AND `itemtype` = " ..ids[i][1]..";")
		moneyInDp = db.getResult("SELECT `count` FROM `player_depotitems` WHERE `player_id` = " ..pid.. " AND `itemtype` = " ..ids[i][1]..";")
		if(money:getID() >= 0) then
			count = count + moneyInItems:getDataInt('count') * ids[i][2]
		end
		if(moneyInDp:getID() >= 0) then
			count = count + moneyInDp:getDataInt('count') * ids[i][2]
		end
		moneyInItems:free()
		moneyInDp:free()
	end
return count	
end

 

[Xeo]

Try this function

function getPlayerMoneyEx(cid)
	local pid = getPlayerGUID(cid)
	if(pid == nil) then
		error("Cannot load player.")
	end
	local count, moneyInItems, moneyInDp = 0, 0, 0
	local ids = {{2160, 10000}, {2152, 100}, {2148, 1}}
	for i = 1, 3 do
		moneyInItems = db.getResult("SELECT `count` FROM `player_items` WHERE `player_id` = " ..pid.. " AND `itemtype` = " ..ids[i][1]..";")
		moneyInDp = db.getResult("SELECT `count` FROM `player_depotitems` WHERE `player_id` = " ..pid.. " AND `itemtype` = " ..ids[i][1]..";")
		if(money:getID() >= 0) then
			count = count + moneyInItems:getDataInt('count') * ids[i][2]
		end
		if(moneyInDp:getID() >= 0) then
			count = count + moneyInDp:getDataInt('count') * ids[i][2]
		end
		moneyInItems:free()
		moneyInDp:free()
	end
return count	
end

How can I implement this? it's a talkaction?

 

[Xeo]

bump!