public bool UpdatePlayerEntry(SQLPlayerID _PlayerID, SQLUploadID _UploadID)
{
if (_PlayerID.IsValid() == false || _UploadID.IsValid() == false)
{
return(false);
}
int affectedRows = 0;
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("UPDATE playertable SET latestuploadid = :LatestUploadID WHERE id = :ID", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("ID", NpgsqlDbType.Integer)).Value = (int)_PlayerID;
cmd.Parameters.Add(new NpgsqlParameter("LatestUploadID", NpgsqlDbType.Integer)).Value = (int)_UploadID;
affectedRows = cmd.ExecuteNonQuery();
}
}
finally
{
CloseConnection();
}
if (affectedRows == 1)
{
return(true);
}
if (affectedRows > 1)
{
VF_RealmPlayersDatabase.Logger.ConsoleWriteLine("Error, UpdatePlayerEntry somehow modified more than 1 line. This is pretty weird and unexpected!!!");
}
return(false);
}
