Staff can Post Hidden Posts

Alright, this Modification is a port of my 3.0.0 Version here.

Short description:

This mod allows you and your moderators, to post hidden posts, which will be visible just to your staff, but not to the users, which will allow you to have comfortable conversations about an issue directly within a thread, withoput users noticing.

There is no more to say. The modification is installed here since a long time and no problems appeared, but i still consider it as a beta version, right now, until usertest have approved it as well

Enjoy

[dakuda]

Originally Posted by kall

Probably due to the can_moderate thing being called for people who can moderate.

(The confusion arises when you refer to a product as a plugin.)

One of these days I will get the whole product/plugin thing straight in my head. I see things in the plugin section and that just sticks in my head... ANyway:

I used the code from post 35, and did not use the navbar changes at all.

So, since a missing index seems to be the suggested fix, uh, this is where I sound stupid.

Is there an easy way to fix the missing index?

[Xenon]

well, it's a question what index is missing

most likely it's on dateline or the visible field

[Pyrix]

Anyone had any luck getting this to work with 3.6.0?

[Paul M]

It won't work with 3.6 without a modification to one of the plugins - the deletionlog table has had a dateline column added to it in 3.6 - therefore you will get an sql error.

[Pyrix]

Got it working ok... Only main difference is, as Paul said, one of the queries needs to be changed otherwise you get a problem with ambiguity.

PHP Code:

    $posts = $db->query_first("
        SELECT COUNT(postid) AS count
        FROM " . TABLE_PREFIX . "post AS post
        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE visible = 0 AND dateline > " . $vbulletin->userinfo[lastvisit] . "
            AND deletionlog.primaryid IS NULL
    "); 


becomes...

PHP Code:

    $posts = $db->query_first("
        SELECT COUNT(postid) AS count
        FROM " . TABLE_PREFIX . "post AS post
        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE visible = 0 AND post.dateline > " . $vbulletin->userinfo[lastvisit] . "
            AND deletionlog.primaryid IS NULL
    "); 


[kall]

Originally Posted by Pyrix

Got it working ok... Only main difference is, as Paul said, one of the queries needs to be changed otherwise you get a problem with ambiguity.

PHP Code:

    $posts = $db->query_first("
        SELECT COUNT(postid) AS count
        FROM " . TABLE_PREFIX . "post AS post
        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE visible = 0 AND dateline > " . $vbulletin->userinfo[lastvisit] . "
            AND deletionlog.primaryid IS NULL
    "); 


becomes...

PHP Code:

    $posts = $db->query_first("
        SELECT COUNT(postid) AS count
        FROM " . TABLE_PREFIX . "post AS post
        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE visible = 0 AND post.dateline > " . $vbulletin->userinfo[lastvisit] . "
            AND deletionlog.primaryid IS NULL
    "); 


Pyrix,

Those 2 code blocks are the same..

[Shahed]

you must open product-xen_hidden_posts.xml with a plane text editor.
find:

PHP Code:

WHERE visible = 0 AND dateline > " . $vbulletin->userinfo[lastvisit] . " 


and replace with :

PHP Code:

WHERE visible = 0 AND post.dateline > " . $vbulletin->userinfo[lastvisit] . " 


Now you can Upload the new Product File and apply Template Modifications.

Enjoy it with 3.6 !

[rms-2004]

Is there any port of "Hidden Posts advanced" with editpost (make it visible/invisible)?
How to set a color to the hidden posts to warn a staff member? Thanks.

[rms-2004]

Anyone have the editpost part for this mod?

[tspepper]

THANK YOU! With the changes below, I am able to have this run perfectly in 3.6!

Originally Posted by Zachery

I'd suggest moving the bit of code to below the regular options, as $threadinfo[open] is not avaible in the showthread_quickreply template

find in the showthread template.

<label for="qr_quickreply"><input type="checkbox" name="quickreply" value="1" id="qr_quickreply" accesskey="w" tabindex="4" />$vbphrase[quote_message_in_reply]</label>
						</div>

Add after

<if condition="is_member_of($bbuserinfo, 5,6,7)"><fieldset class="fieldset" style="margin:$stylevar[formspacer]px 0px 0px 0px"><legend>Moderatory Options</legend>	<div>
	<label for="cb_hidepost" style="float:$stylevar[left]"><input type="checkbox" name="hidepost" value="1" id="cb_hidepost" />Hide Post?</label>
	<div style="float:$stylevar[right]">
		<label for="cb_openclose"><input type="checkbox" name="openclose" value="1" id="cb_openclose" /><if condition="$threadinfo['open']">Close<else />Open</if> Thread</label>$threadinfo[open]
	</div>
</div></fieldset></if>

Originally Posted by Shahed

you must open product-xen_hidden_posts.xml with a plane text editor.
find:

PHP Code:

WHERE visible = 0 AND dateline > " . $vbulletin->userinfo[lastvisit] . " 


and replace with :

PHP Code:

WHERE visible = 0 AND post.dateline > " . $vbulletin->userinfo[lastvisit] . " 


Now you can Upload the new Product File and apply Template Modifications.

Enjoy it with 3.6 !