So the solution is

    $db->do('INSERT INTO memberlog (username, gamename, host, date) VA
+LUES (?, ?, ?, ?)',
    undef, $userauth, $gamename, $host, $date);

    $db->do('UPDATE vault SET gamecounter=gamecounter+1 WHERE gamename
+=?',
    undef, $gamename);

    return $db->selectrow_hashref('SELECT * FROM vault WHERE gamename=
+?',
    undef, $gamename);
[download]

Or if you just want the updated gamecounter,

    $db->do('INSERT INTO memberlog (username, gamename, host, date) VA
+LUES (?, ?, ?, ?)',
    undef, $userauth, $gamename, $host, $date);

    $db->do('UPDATE vault SET gamecounter=gamecounter+1 WHERE gamename
+=?',
    undef, $gamename);

    return (
        $db->selectrow_array('SELECT gamecounter FROM vault WHERE game
+name=?',
            undef, $gamename)
    )[0];
[download]