function GetGuildID2(Player)
local Name = GetChaDefaultName(Player)
local String = "SELECT guild_id FROM GameDB.dbo.character WHERE cha_name = '"..Name.."'"
local Connect, ConnectID = LuaSQL("connect", SQL.GameDB.Host, SQL.GameDB.User, SQL.GameDB.Password)
if Connect == SQL_SUCCESS_WITH_INFO then
local Success, Query = LuaSQL("query", ConnectID, String)
if Success == SQL_SUCCESS_WITH_INFO then
local Data = LuaSQL("fetch", ConnectID, Query)
LuaSQL("freehandle", ConnectID, Query)
LuaSQL("close", ConnectID)
return Data["guild_id"]
end
end
end
function GuildLeaderID(Player)
local Guild_ID = GetGuildID2(Player)
local String = "SELECT leader_id FROM GameDB.dbo.guild WHERE name = '"..GuildID.."'"
local Connect, ConnectID = LuaSQL("connect", SQL.AccServer.Host, SQL.AccServer.User, SQL.AccServer.Password)
if Connect == SQL_SUCCESS_WITH_INFO then
local Success, Query = LuaSQL("query", ConnectID, String)
if Success == SQL_SUCCESS_WITH_INFO then
local Data = LuaSQL("fetch", ConnectID, Query)
LuaSQL("freehandle", ConnectID, Query)
LuaSQL("close", ConnectID)
return Data["leader_id"]
end
end
end
function GetChaGuildLeaderID(Player)
local leader = GetLeaderID(Player)
local cha_id = GetChaID(Player)
if leader == cha_id then
return 1
else
LG("LuaSqlErr", "GetLeaderID Failed", "\n")
return 0
end
end
**UPTADE**