package Common::DB::Item::Flattery;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::DB::ItemCollection;
use Common::DB::Item;
use base 'Common::DB::Item';

use constant kTable => 'flattery';
use constant kDB    => Common::DB::Item::kCommonDB;

sub GetMaxFlatteryID {
    my ($class) = @_;

    my $dbo = Common::RSApp::GetCommonDB();

    my $sql = "SELECT MAX(flattery_id) AS max_id FROM " . kTable;

    my $sth = $dbo->DoCmd($sql);
    my $hr  = $sth->fetchrow_hashref();
    return $hr->{max_id};
}

sub ResetFlattery {
    my ($class) = @_;

    my $dbo = Common::RSApp::GetCommonDB();

    my $sql = "UPDATE " . kTable . " SET position_mask = 0";

    $dbo->DoCmd($sql);

    return 1;
}

1;