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();

##</code><code>##

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

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

	my ($select) = $db->selectrow_array('SELECT * from vault WHERE gamename=?',
	undef, $gamename);

        return $select->selectrow_hashref;