public static bool Exists(string gamePath)
{
return(DB.Instance.Execute("SELECT 1 FROM {0} WHERE path='{1}'", TABLE_NAME, DB.Encode(gamePath)).Rows.Count > 0);
}
public void SaveGamePlayInfo()
{
DB.Instance.Execute("UPDATE {0} SET grade={1}, playcount={2}, latestplay='{3}', favourite='{4}', LaunchFile='{5}', currentdisc={6}, emuprofile={7} WHERE path='{8}'",
TABLE_NAME,
grade, playcount, latestplay.ToString("s"), favourite, DB.Encode(launchFile), currentDiscNum, selectedProfileId, DB.Encode(path)
);
}
public void SaveInfoCheckedStatus()
{
DB.Instance.Execute("UPDATE {0} SET infochecked='{1}' WHERE path='{2}'", TABLE_NAME, isInfoChecked, DB.Encode(path));
}
public void SaveGameDetails()
{
DB.Instance.Execute("UPDATE {0} SET title='{1}', company='{2}', description='{3}', genre='{4}', yearmade={5}, grade={6}, infochecked='{7}' WHERE path='{8}'",
TABLE_NAME,
DB.Encode(title), DB.Encode(company), DB.Encode(description), DB.Encode(genre), yearmade, grade, isInfoChecked, DB.Encode(path)
);
}