/**
    * Fetches the amount of moderated attachments associated with a posthash and user
    *
    * @param    string    Post hash
    * @param    integer    User ID associated with post hash (-1 means current user)
    *
    * @return    integer    Number of attachments
    */
    function fetch_mod_attachment_count($postid, $userid = -1)
    {
        if ($userid == -1)
        {
            $userid = $this->fetch_field('userid', 'post');
        }
        $userid = intval($userid);

        $attachcount = $this->dbobject->query_first("
            SELECT COUNT(*) AS count
            FROM " . TABLE_PREFIX . "attachment
            WHERE postid = '$postid'
                AND userid = $userid
                AND visible != 1
        ");

        return intval($attachcount['count']);
    }

    /**
    * Fetches the moderated attachments associated with a posthash and user
    *
    * @param    string    Post hash
    * @param    integer    User ID associated with post hash (-1 means current user)
    *
    * @return    array Moderated attachments IDs
    */
    function fetch_mod_attachment($postid, $userid = -1)
    {
        if ($userid == -1)
        {
            $userid = $this->fetch_field('userid', 'post');
        }
        $userid = intval($userid);

        $attachs = $this->dbobject->query_read_slave("
            SELECT attachmentid, filename
            FROM " . TABLE_PREFIX . "attachment
            WHERE postid = '$postid'
                AND userid = $userid
                AND visible != 1
        ");

        $modattach = array();
        while ($attach = $this->dbobject->fetch_array($attachs))
        {
            $modattach[$attach['attachmentid']] = array('attachmentid' => $attach['attachmentid'], 'filename' => $attach['filename'], 'postid' => $attach['postid'], 'dateline' => $attach['dateline']);
        }

        return $modattach;
    }

    function attach_email_moderators($fields, $attachcount, $attachs)
    {
        if ($this->info['skip_moderator_email'] OR !$this->info['forum'] OR in_coventry($this->fetch_field('userid', 'post'), true))
        {
            return;
        }

        $mod_emails = fetch_moderator_modattach_emails($fields, $this->info['forum']['parentlist'], $newpost_lang);

        if (!empty($mod_emails))
        {
            $foruminfo = $this->info['forum'];
            $foruminfo['title_clean'] = unhtmlspecialchars($foruminfo['title_clean']);

            $threadinfo = fetch_threadinfo($this->fetch_field('threadid'));

            $email = ($this->info['user']['email'] ? $this->info['user']['email'] : $this->registry->userinfo['email']);
            $browsing_user = $this->registry->userinfo['username'];

            // ugly hack -- should be fixed in the future
            $this->registry->userinfo['username'] = unhtmlspecialchars($this->info['user']['username'] ? $this->info['user']['username'] : $this->registry->userinfo['username']);

            $post = array_merge($this->existing, $this->post);
            if (!$post['postid'])
            {
                $post['postid'] = $this->thread['firstpostid'];
            }

            require_once(DIR . '/includes/functions_misc.php');

            foreach ($mod_emails AS $toemail)
            {
                if ($toemail != $email)
                {
                    if ($threadinfo['prefixid'])
                    {
                        // need prefix in correct language
                        $threadinfo['prefix_plain'] = fetch_phrase(
                            "prefix_$threadinfo[prefixid]_title_plain",
                            'global',
                            '',
                            false,
                            true,
                            isset($newpost_lang["$toemail"]) ? $newpost_lang["$toemail"] : 0,
                            false
                        ) . ' ';
                    }
                    else
                    {
                        $threadinfo['prefix_plain'] = '';
                    }

                    $attachdetails = "";
                    foreach ($attachs as $attach)
                    {
                        $attachdetails .= " * ID: " . $attach['attachmentid'] . ", Name: " . $attach['filename'] . "\n";
                    }

                    eval(fetch_email_phrases('moderator_attach', iif(isset($newpost_lang["$toemail"]), $newpost_lang["$toemail"], 0)));
                    vbmail($toemail, $subject, $message);
                }
            }

            // back to normal
            $this->registry->userinfo['username'] = htmlspecialchars_uni($browsing_user);
        }
    }