public override int CreateGuild(string guildName, string leaderId)
{
int id = 0;
MySQLRowsReader reader = ExecuteReader("INSERT INTO guild (guildName, leaderId) VALUES (@guildName, @leaderId);" +
"SELECT LAST_INSERT_ID();",
new MySqlParameter("@guildName", guildName),
new MySqlParameter("@leaderId", leaderId));
if (reader.Read())
{
id = (int)reader.GetUInt64(0);
}
if (id > 0)
{
ExecuteNonQuery("UPDATE characters SET guildId=@id WHERE id=@leaderId",
new MySqlParameter("@id", id),
new MySqlParameter("@leaderId", leaderId));
}
return(id);
}
public override int CreateParty(bool shareExp, bool shareItem, string leaderId)
{
int id = 0;
MySQLRowsReader reader = ExecuteReader("INSERT INTO party (shareExp, shareItem, leaderId) VALUES (@shareExp, @shareItem, @leaderId);" +
"SELECT LAST_INSERT_ID();",
new MySqlParameter("@shareExp", shareExp),
new MySqlParameter("@shareItem", shareItem),
new MySqlParameter("@leaderId", leaderId));
if (reader.Read())
{
id = (int)reader.GetUInt64(0);
}
if (id > 0)
{
ExecuteNonQuery("UPDATE characters SET partyId=@id WHERE id=@leaderId",
new MySqlParameter("@id", id),
new MySqlParameter("@leaderId", leaderId));
}
return(id);
}
