public static void Execute_SelectMembersforGuilds(int guildID)
{
try
{
int GuildPosition = -1;
for (int i = 0; i < GameServer.GuildList.Count; i++)
{
if (GameServer.GuildList[i].Id == guildID)
{
GuildPosition = i;
}
}
if (GuildPosition == -1)
{
return;
}
DataSet data_0 = new DataSet();
GameServer.Sql.Exec(data_0, "SELECT * FROM GuildUser WHERE GuildID = '{0}'", guildID);
for (int i = 0; i < data_0.Tables[0].Rows.Count; i++)
{
DataSet data_1 = GameServer.Sql.Command("SELECT * FROM users WHERE Login = '******'", data_0.Tables[0].Rows[i]["login"].ToString());
DataSet data_2 = GameServer.Sql.Command("SELECT Nick FROM Nicknames WHERE Login = '******'", data_0.Tables[0].Rows[i]["login"].ToString());
GameServer.AddMember(
GuildPosition,
data_1.Tables[0].Rows[i]["login"].ToString(),
data_2.Tables[0].Rows[i]["Nick"].ToString(),
Convert.ToInt32(data_1.Tables[0].Rows[i]["LoginUID"].ToString())
);
}
}
catch (Exception e)
{
Log.Write("\n{0}\n\n", e.ToString());
}
}