getGuildNameById(id)

[PHBS]

getGuildNameById(id):

function getGuildNameById(id)
local Info = db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. id .. ";")
        if Info:getID() ~= LUA_ERROR then
        local Name= Info:getDataString("name")
                                Info:free()
                return Name
        end
        return LUA_ERROR
end

:thumbup:

 

[Shawak]

	getPlayerNameByGUID(guid)

 

[Syntax]

Shawak you misread it, he wants the opposite of this

	getGuildId(guildName)

I'm sure you don't really need it, there could be a work around, mind posting your script, then we could help you more.

 

[Shawak]

Shawak you misread it, he wants the opposite of this

	getGuildId(guildName)

I'm sure you don't really need it, there could be a work around, mind posting your script, then we could help you more.

I just read "getplayer...id" ah fucked .

 

[Syntax]

^.^ Its ok I won't judge you...this time.

 

[Darkhaos]

function getGuildNameById(id)
local query = db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. id .. ";")
	if(query:getID() ~= -1) then
		return query:getDataString("name")
		query:free()
	end
	return LUA_ERROR
end

Untested.

 

[PHBS]

function getGuildNameById(id)
local query = db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. id .. ";")
	if(query:getID() ~= -1) then
		return query:getDataString("name")
		query:free()
	end
	return LUA_ERROR
end

Untested.

Don't work ;/

 

[PHBS]

HaHa!
This works...

function getGuildNameById(id)
local Info = db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. id .. ";")
        if Info:getID() ~= LUA_ERROR then
        local Name= Info:getDataString("name")
                                Info:free()
                return Name
        end
        return LUA_ERROR
end

Thanks, ALL!

 

[Colandus]

function getGuildNameById(id)
local query = db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. id .. ";")
	if(query:getID() ~= -1) then
		return query:getDataString("name")
		query:free()
	end
	return LUA_ERROR
end

Untested.

query:free() cant be ran after returning.