my $select = $db->prepare( "INSERT INTO memberlog (username, gamename, host, date) VALUES (?, ?, ?, ?)" );
        $select->execute( $userauth, $gamename, $host, $date);

        my $update = $db->prepare("UPDATE vault SET gamecounter=gamecounter+1 WHERE gamename=?");
        $update->execute($gamename);

        my $select = $db->prepare("SELECT * from vault WHERE gamename=?");
        $select->execute($gamename);

        return $select->fetchrow_hashref();