[digitalpoint]

Originally Posted by The Vegan Forum

Hi, we had to deinstall this product yesterday, since non-public posts from moderated users showed up in the Spy-window.

It's actually by design... the Spy is intended to show things happening in real-time (including things like a deleted post).

It does NOT show anything from a forum/section that the user does not have permission to view, but if something is posted and sent to a moderation queue (or a post is deleted) from a section that can access it will show the preview clip of that post as it rolls by.

It wouldn't be hard to suppress things that weren't visible normally if you wanted though. In the spy.php file, just change this:

PHP Code:

    $events = $db->query_read_slave("
        SELECT spy.*, user.username, thread.title, thread.forumid, post.pagetext AS preview
        FROM " . TABLE_PREFIX . "digitalpoint_spy AS spy
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = spy.userid)
        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = spy.threadid)
        LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = spy.postid)
        WHERE (thread.forumid IS NULL OR (thread.forumid IN ($forumids)$sql_subscribed))
            $extra
        ORDER BY dateline DESC
        LIMIT 25
    "); 


to this:

PHP Code:

    $events = $db->query_read_slave("
        SELECT spy.*, user.username, thread.title, thread.forumid, post.pagetext AS preview
        FROM " . TABLE_PREFIX . "digitalpoint_spy AS spy
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = spy.userid)
        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = spy.threadid)
        LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = spy.postid)
        WHERE (thread.forumid IS NULL OR (thread.forumid IN ($forumids)$sql_subscribed))
            AND (thread.visible IS NULL OR thread.visible = 1)
            AND (post.visible IS NULL OR post.visible = 1)
            $extra
        ORDER BY dateline DESC
        LIMIT 25
    ");