Lua Table

[ak47sigh]

How can I get the players from the database table using only names?


It looks like this code:
I want to get all the players from there, multiply.

GetNPlayers = CharDBQuery("SELECT * FROM table_name;") -- getting table
NPlayers = GetNPlayers:GetColumn(1):GetString() -- this column stores character name
 plr = GetPlayer(NPlayers)

if(NPlayers == nil) then
-- nothing
else
plr:SendBroadcastMessage("Hello")
end

I have tried with this too:

for k,v in ipairs(NPlayers) do
end

If anyone could help, I will appreciate

[stoneharry]

Well this is a really, really bad way to do this. Whatever you are using this for, you should think of redesigning the system.

However in answer to your question:

local GetNPlayers = CharDBQuery("SELECT `name` FROM `table_name`;") -- getting table
local NPlayers = GetNPlayers:GetColumn(1):GetString() -- this column stores character name

if NPlayers then
	local player = nil
	for _,plr in pairs(GetPlayersInWorld()) do
		if plr:GetName() == NPlayers then
			player = plr
			break
		end
	end
	if player then
		player:SendBroadcastMessage("Hello")
	end
end

[ak47sigh]

Using for a battleground que and solved. Thanks alot , Rochet helped me

[stoneharry]

Using for a battleground que and solved. Thanks alot , Rochet helped me

Why would you use SQL for a battleground queue?