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