getDBPlayersCount() : -[

[hodleo]

function getDBPlayerCount()
    local Count = db.getResult("SELECT `id` FROM `players`;")
return table.maxn(Count)
end

function onSay(cid, words, param)
    local DB_BEFORE = table.maxn(db.getResult("SELECT `id` FROM `players`;").id)
    doPlayerSendCancel(cid, ""..DB_BEFORE.."")
end

:[ i need it to return me the number of players in database

 

[Cykotitan]

function onSay(cid, words, param)
    return doPlayerSendCancel(cid, tostring(db.getResult("Select COUNT(id) from players;")))
end

 

[Sync]

function onSay(cid, words, param)
    return doPlayerSendCancel(cid, tostring(db.getResult("Select COUNT(id) from players;"))
end

Haha nice cyko~

 

[Cykotitan]

Haha nice cyko~

if it works.

 

[Darkhaos]

Maybe this works

function getPlayersCountInDB()

	query = db.executeQuery("select name from players")
	if(query ~= -1) then
		query:free()
		return #query:getDataString("name")
	end
	return LUA_ERROR
end

 

[elf]

It may give wrong results if you delete players, because id field just returns auto increment state, not the real count.

function getDBPlayersCount()
    local result = db.getResult("SELECT COUNT(`id`) as `count` FROM `players` WHERE `deleted` = 0;")
    local tmp = result:getDataInt("count")

    result:free()
    return tmp
end

 

[hodleo]

elf wins i used SELECT COUNT first, but i just needed another piece of code to get the number
thanks cykotitan and darkkhaos
i will use this to develop a necessary script to cleanup database