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