Show Thread Enhancements - Show Full CMS Article in Comments Thread

This is more of an example than a modification. I wrote this quick plugin for someone and thought I would share it. It's something someone can take and build on. All it does is if you look at the CMS Article thread in your CMS Comments forum, the content of the CMS Article is shown under the blurb "You can view the page at.....". This is ONLY for Articles - not Static Pages or PHP Direct Evaluation content types. Someone can build on this and do those if they want. The person I wrote this for had forms in their articles and needed the submit button to be disabled, so this plugin does that also.

Like I said - this is more of an example. I don't plan to do anything more with it and I'm not helping with modifying it for your own use. Use it however you want.

This adds one query to the threads in the CMS Comments forum.

To install....

Create a Plugin
Hook Location - postbit_display_complete
Title - Show Full CMS Article
Plugin PHP Code -

PHP Code:

if (THIS_SCRIPT == 'showthread' AND $this->thread['forumid'] == $this->registry->options['vbcmsforumid'] AND $this->post['postcount'] == 1) {

$result = $this->registry->db->query_first("
    SELECT cms_article.pagetext, cms_article.threadid, cms_article.htmlstate 
    FROM " . TABLE_PREFIX . "cms_article AS cms_article 
    INNER JOIN " . TABLE_PREFIX . "cms_node AS cms_node ON (cms_node.contentid = cms_article.contentid) 
    INNER JOIN " . TABLE_PREFIX . "cms_nodeinfo AS cms_nodeinfo ON (cms_nodeinfo.nodeid = cms_node.nodeid) 
    WHERE cms_nodeinfo.associatedthreadid = ". $this->thread['threadid']. "
        ");

$bbcode_parser = new vBCms_BBCode_HTML(vB::$vbulletin,  vBCms_BBCode_HTML::fetchCmsTags());

$pagetext = fetch_censored_text($bbcode_parser->do_parse($result['pagetext'],true,$result['htmlstate']));

$find = 'type="submit"';
$replace = 'type="submit" disabled';
$pagetext = str_replace ($find, $replace, $pagetext);

$result['previewtext'] = $pagetext;
$this->post['message'] .= '<br />*********<br />'. $result['previewtext'];
} 


CMS Page:

CMS Comment Thread:


If you ONLY want to show the full article to users, not guests, then change this condition (thanks to mattysheff):

PHP Code:

if (THIS_SCRIPT == 'showthread' AND $this->thread['forumid'] ==  $this->registry->options['vbcmsforumid'] AND  $this->post['postcount'] == 1) 


to this:

PHP Code:

if (THIS_SCRIPT == 'showthread' AND $show['member'] AND  $this->thread['forumid'] == $this->registry->options['vbcmsforumid'] AND $this->post['postcount'] == 1) 


[Morrus]

This is great - been using it for a while. One issue is that inline image attachments do not show in the thread - you just get a URL link instead.

[Edit - ah, I see this has been mentioned plenty of times!]

[RichieBoy67]

I love this but am having a major issue.

I want to have certain article previews appear in other forums instead of the main forum but when I more the threads they automatically go back to default. Is there any way to get the previews to show in other forums as well?

After looking at the code I see I may be able add an array and list the forums but will this add a query for each forum I add for every page load or just when someone opens that forum? Will this change the forums the articles are posted in?

[RichieBoy67]

Originally Posted by Lynne

That is because of the condition I have at the top:

if (THIS_SCRIPT == 'showthread' AND $this->thread['forumid'] == $this->registry->options['vbcmsforumid'] AND $this->post['postcount'] == 1)

I have it set to only check for this in the specified vbcms comments forum. You could remove that part of the condition and see if it works. (Do you always move the threads to a specific other forum? If so, enter that forumid instead.)

Sorry I missed this--will try this.

Thanks guys


This has worked but I want to do a couple more things. if anyone has already done this please share.

#1 - I want to only show a preview and not the entire article..

#2 - I want to make the preview content not crawlable. I do not want it indexed from both the article page and the forum.(I don't think this is an issue because the content is being generated from the cms and not actually posted as a regular thread so disregard number 2--

#3 - Being able to add the images would also be cool..

Thanks--Love this!

[Toorak Times]

Glad I found this. Applied it tonight, Lynne's and the latest version, cheers!

It works very well with text on my 4.2.1 site, first few I looked at the pics didn't come through, and I don't expect the vBTubes to come thru but when I looked deeper pics were being feed into the thread.

It has fixed up hundreds of posts that NOW I can call an archive, wonderful, I'll definitely keep an eye on this thread hoping for further shared enhancements.

I was starting to build an archive in the CMS as the links didn't allow me to delete some of the dated. I presume I can delete the dated content from the CMS now as we have copy in this plugin.

Thanks again.

[Lynne]

Originally Posted by Toorak Times

I was starting to build an archive in the CMS as the links didn't allow me to delete some of the dated. I presume I can delete the dated content from the CMS now as we have copy in this plugin.

Thanks again.

No, you cannot delete the CMS article. If you do that, then there will be no text in the post. This modification does not actually copy it from the CMS part of the database into the post, it just shows the CMS content in place of the existing post.

[Toorak Times]

Originally Posted by Lynne

No, you cannot delete the CMS article. If you do that, then there will be no text in the post. This modification does not actually copy it from the CMS part of the database into the post, it just shows the CMS content in place of the existing post.

Thanks Lynne, I learnt today when I tried to edit one of them to replace the pictures the content also disappears.

[Morrus]

So I've done something silly, and I think it may have messed up something.

I had changed the phrase which says "You can view the page at X" a while back to something else. Yesterday, I went to change it again, and deleted the translation and saved it. Now I can't find the phrase! I usually find phrases by just searching for them, but I can't search for " ".

How do I find that phrase again? Does it have a Phrase Variable Name I can search for instead of the text?

--

Additionally, at the exact same time (it might be coincidence, but it might be linked to the above) the CMS has stopped putting the comment thread in the CMS comments forum altogether, and despite comments being set to YES in the article edit page, comments appear to be remaining switched off. I don't know if that's somehow connected to me accidentally removing a phrase (it seems unlikely, but the timing was pretty much exact).

[Lynne]

Originally Posted by Morrus

So I've done something silly, and I think it may have messed up something.

I had changed the phrase which says "You can view the page at X" a while back to something else. Yesterday, I went to change it again, and deleted the translation and saved it. Now I can't find the phrase! I usually find phrases by just searching for them, but I can't search for " ".

How do I find that phrase again? Does it have a Phrase Variable Name I can search for instead of the text?

The phrase name is "comment_thread_firstpost".

Originally Posted by Morrus

Additionally, at the exact same time (it might be coincidence, but it might be linked to the above) the CMS has stopped putting the comment thread in the CMS comments forum altogether, and despite comments being set to YES in the article edit page, comments appear to be remaining switched off. I don't know if that's somehow connected to me accidentally removing a phrase (it seems unlikely, but the timing was pretty much exact).

I can't see how the two are related.

[Morrus]

Originally Posted by Lynne

The phrase name is "comment_thread_firstpost".

Got it - thanks!

I can't see how the two are related.

They definitely are in some way, because reverting that phrase immediately turned comments back on again! Everything is working correctly again!

I just tested it and removed and then re-added the phrase again. Removing it immediately switches off CMS comments threads (and therefore comments); adding it back restores the functionality.

[RichieBoy67]

Originally Posted by TiKu

Here's another improvement:
Add a plugin called "Quote Full CMS Article", hook newreply_quote.

if (THIS_SCRIPT == 'ajax' AND $quote_post['forumid'] == $vbulletin->options['vbcmsforumid']) {
    $is_first_post = false;
    $result = $vbulletin->db->query_first("SELECT postid FROM " . TABLE_PREFIX . "post WHERE threadid=" . $quote_post['threadid'] . " ORDER BY dateline LIMIT 1");
    if($result) {
        $is_first_post = ($result['postid'] == $quote_post['postid']);
    }

    if($is_first_post) {
        $result = $vbulletin->db->query_first("
          SELECT cms_article.pagetext, cms_article.threadid, cms_node.nodeid, cms_node.userid
          FROM " . TABLE_PREFIX . "cms_article AS cms_article
          INNER JOIN " . TABLE_PREFIX . "cms_node AS cms_node ON (cms_node.contentid = cms_article.contentid)
          INNER JOIN " . TABLE_PREFIX . "cms_nodeinfo AS cms_nodeinfo ON (cms_nodeinfo.nodeid = cms_node.nodeid)
          WHERE cms_nodeinfo.associatedthreadid = ". $quote_post['threadid']. "
        ");

        if($result) {
            bootstrap_framework();
            $contenttypeid = vb_Types::instance()->getContentTypeID('vBCms_Article');
            $allow_html = vBCMS_Permissions::canUseHtml($result['nodeid'], $contenttypeid, $result['userid']);

            $bbcode_parser = new vBCms_BBCode_HTML($vbulletin, vBCms_BBCode_HTML::fetchCmsTags());
            $pagetext = $bbcode_parser->get_preview(fetch_censored_text($result['pagetext']), $vbulletin->options['default_cms_previewlength'], $allow_html);
        }
    }
}

This makes quotes of the first post of the comments thread quote the article's preview text instead of the link to the article.

Just what I needed!! Thanks!

Any clue how to get the image to display?