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); }