Lua Mysql database

[mayel]

Hello,


How do i get information from my mysql database with a mysql query?
I mean theres no point of having a database if you can't get the information later in scripts and so on.
I mean the getplayerpremiumdays function must get the pacc days information from my database somehow and i want to figure out how.

Please help.
If i could figure it out, it would be very helpful.

Thanks in advance and i'll for sure rep++ all helpful comments.

 

[chojrak]

local ids, info = {}, db.getResult('SELECT `id` FROM `players`;')
if info:getID() ~= -1 then
	while info:next() do
		table.insert(ids, info:getDataInt('id'))
	end
	info:free()
end

print('>> Stored '.. #ids ..' IDs.')

 

[mayel]

My question wasn't to store the data, so which part of that is the actual "recieving" of the data?

 

[chojrak]

My question wasn't to store the data, so which part of that is the actual "recieving" of the data?

I know, just posted example with receiving and storing data. db.getResult stores data in variable.

 

[mayel]

Ok, i'll try thanks
rep++ (Like u need it ;P)

 

[chojrak]

Np, here's some other example that returns premium points of player:

function getPlayerPremiumPoints(cid)
	local points, res = 0, db.getResult('SELECT `premium_points` FROM `accounts` WHERE `id` = '.. getPlayerAccountId(cid) ..';')

	if res:getID() ~= -1 then
		points = res:getDataInt('premium_points')
		res:free()
	end

	return points
end

 

[mayel]

Never mind, thank you

 

[SzukamLaya]

@ first example
Wrong Kamil ;<

local ids, info = {}, db.getResult('SELECT `id` FROM `players`;')
if info:getID() ~= -1 then
	while (true)  do
		table.insert(ids, info:getDataInt('id'))
                if not(info:next()) then
                     break
                end

	end
	info:free()
end

print('>> Stored '.. #ids ..' IDs.')

 

[chojrak]

@ first example
Wrong Kamil ;<

local ids, info = {}, db.getResult('SELECT `id` FROM `players`;')
if info:getID() ~= -1 then
	while (true)  do
		table.insert(ids, info:getDataInt('id'))
                if not(info:next()) then
                     break
                end

	end
	info:free()
end

print('>> Stored '.. #ids ..' IDs.')

local ids, info = {}, db.getResult('SELECT `id` FROM `players`;')
if info:getID() ~= -1 then
	repeat
		table.insert(ids, info:getDataInt('id'))
	until info:next()
	info:free()
end

print('>> Stored '.. #ids ..' IDs.')

'<_<'

 

[SzukamLaya]

Ucz sie Kamil ucz bo nauka to potegi klucz ;/

'<_<'