When i do on talk actions !guildinfo, i get
But when i write the guild name i dont get error i dont want any errors it should come! (Guild Does Not Exist) if i doesnt write the guild name
[20/02/2010 17:11:28] data/talkactions/scripts/guildinfo.lua:6: attempt to concatenate local 'guildid' (a boolean value)
[20/02/2010 17:11:28] stack traceback:
[20/02/2010 17:11:28] data/talkactions/scripts/guildinfo.lua:6: in function <data/talkactions/scripts/guildinfo.lua:4>
But when i write the guild name i dont get error i dont want any errors it should come! (Guild Does Not Exist) if i doesnt write the guild name
--Adam 2008
--Collapser OT
function onSay(cid, words, param)
local guildid = getGuildId(param)
local guild = db.getResult("SELECT `id`,`guild_id`,`name` FROM `guild_ranks` WHERE `guild_id` = "..guildid.." ;")
if(guild:getID() ~= -1) then
local guildname = db.getResult("SELECT `name` FROM `guilds` WHERE id = '"..guildid.."' ;")
guildlist = guildname:getDataString("name")
while (true) do
local guild_id = guild:getDataInt("guild_id")
local id = guild:getDataInt("id")
local rankname = guild:getDataString("name")
local players = db.getResult("SELECT `name`,`guildnick` FROM `players` WHERE `rank_id` = "..id.." ORDER BY `name` ;")
if(players:getID() ~= -1) then
guildlist = guildlist.."\n\n"..rankname
while (true) do
local pname = players:getDataString("name")
local guildnick = players:getDataString("guildnick")
if guildnick ~= "" then
guildlist = guildlist.."\n "..pname.." ("..guildnick..")"
else
guildlist = guildlist.."\n "..pname
end
if not(players:next()) then
break
end
end
players:free()
end
if not(guild:next()) then
break
end
end
guild:free()
guildname:free()
doShowTextDialog(cid, 5958, guildlist)
else
doPlayerSendCancel(cid, "Guild Does Not Exist.")
end
return TRUE
end