Show Full CMS Article in Comments Thread

[Lynne]

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 -

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:
https://vborg.vbsupport.ru/attachment.php?attachmentid=123944&stc=1&d=1290890523
CMS Comment Thread:
https://vborg.vbsupport.ru/attachment.php?attachmentid=123945&stc=1&d=1290890523

If you ONLY want to show the full article to users, not guests, then change this condition (thanks to mattysheff (https://vborg.vbsupport.ru/member.php?u=244012)):
if (THIS_SCRIPT == 'showthread' AND $this->thread['forumid'] == $this->registry->options['vbcmsforumid'] AND $this->post['postcount'] == 1)to this:
if (THIS_SCRIPT == 'showthread' AND $show['member'] AND $this->thread['forumid'] == $this->registry->options['vbcmsforumid'] AND $this->post['postcount'] == 1)

[Dr.osamA]

installed

but i have broplem with cms as default

[Lynne]

installed

but i have broplem with cms as default
Sorry, but I don't understand what you mean.

[jimfries]

After I put in this plug-in, activate it then reload my website I get this Error:
==================
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT cms_article.pagetext, cms_article.threadid, cms_article.htmlstate
FROM distortedforumscms_article AS cms_article
INNER JOIN distortedforumscms_node AS cms_node ON (cms_node.contentid = cms_article.contentid)
INNER JOIN distortedforumscms_nodeinfo AS cms_nodeinfo ON (cms_nodeinfo.nodeid = cms_node.nodeid)
WHERE cms_nodeinfo.associatedthreadid = 570;

MySQL Error : Unknown column 'cms_article.htmlstate' in 'field list'
Error Number : 1054
Request Date : Wednesday, December 29th 2010 @ 08:37:48 PM
Error Date : Wednesday, December 29th 2010 @ 08:37:48 PM
Script : http://www.distortedguild.com/showthread.php?570-Article-Guild-Update-12-30-2010
Referrer : http://www.distortedguild.com/forumdisplay.php?5-Guild-Chat
IP Address : 76.125.212.129
Username : Guadah
Classname : vB_Database
MySQL Version : 4.1.24-max-log


Here is the code I put into the Plug-in. I just copied and pasted it.
==================
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'];
}

[Lynne]

After I put in this plug-in, activate it then reload my website I get this Error:
==================
Database error in vBulletin 4.0.1:

Invalid SQL:

.....

MySQL Error : Unknown column 'cms_article.htmlstate' in 'field list'

I just wrote this recently, so I've only been able to test it on 4.0.8 and up. There may not have been a field called htmlstate in the cms_article table back in 4.0.1. If so, then I'm not sure if this will work for you without modifying the query and the do_parse call.

[jimfries]

oh man, what a bummer.

I'm not sure I can upgrade, I think one or two addons will stop working if I do. I'll backup the website and try to upgrade this weekend when I have time.

Thanks for the work done in it regardless! It's an awesome modification.

[jimfries]

I removed ", cms_article.htmlstate" and submitted it. The addon is working now :)

Thank you again for this modification!

[GamerPerfection]

Tagged.... will try later today.... hope it works on 4.1.0 :)

[GamerPerfection]

It works. :)

One problem I have though, which is not an issue with it as it is, but more with how I personally do things on my forum. Once I publish an article, I then go to the forum and I move the thread from vBCMS Comments to a more relevant section of the forum. When I move it the article content in the thread disappears and i'm left with the standard "you can view the page here".

The way around it I have at the moment is I copy the content from the auto created thread, then I move the thread, then edit the thread and paste in the content. It works, but it means a little more work on my behalf. :)

[Lynne]

It works. :)

One problem I have though, which is not an issue with it as it is, but more with how I personally do things on my forum. Once I publish an article, I then go to the forum and I move the thread from vBCMS Comments to a more relevant section of the forum. When I move it the article content in the thread disappears and i'm left with the standard "you can view the page here".

The way around it I have at the moment is I copy the content from the auto created thread, then I move the thread, then edit the thread and paste in the content. It works, but it means a little more work on my behalf. :)
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.)

[GamerPerfection]

Awesome, removing the bit in red works! When I move it to anywhere in the forum it still keeps the content.

And no I don't move them to the same specific area, it can vary.

But thanks for helping me fix it. :)

[mattysheff]

Thanks for releasing this Lynne, its just what I've been looking for.

One question though, is it possible and if so how would I to it to only get it to show the text to signed in members. I've been trying to figure out how to do it myself but getting nowhere, as while its a user friendly feature, I don't want search engines to be able to see it as I don't want duplicated content listed in the search engines.

[Lynne]

Just add a condition to the plugin to only do it if the user is logged in - you can probably use the $show['member'] variable for that.

[mattysheff]

Thanks that works perfect.

[tokenyank]

This looks like a great mod - however, wouldn't this count against your SEO by having duplicate content?

Tagged for further investigation when it isn't 00:40! ;)

[Lynne]

This looks like a great mod - however, wouldn't this count against your SEO by having duplicate content?

Tagged for further investigation when it isn't 00:40! ;)
According to mattysheff, yes, which is why he asked the question and I told him to put the condition around it.

[mattysheff]

I've added this to the first bit:

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

It works perfect and only shows the content to members. I'm not currently using it though because I've got comment threads hidden because of the bug in vbulletin where if you future publish a article the comment thread is created immediately.

[deverill2010]

Hi Lynne and thanks for the mod but what exactly do you mean by -

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.

The ability to reply is removed??

[Lynne]

Hi Lynne and thanks for the mod but what exactly do you mean by -

The ability to reply is removed??
No. This mod only effect the post text, nothing else.

[traen]

Installed, works great thank you Lynne! This should be default in vbulletin.

[whitedd]

Thnx Lynn ...but i wonder...is it posible that shows a attacment too...
...couse...article is showing,but in every article i have one image...
...thats images is not showing...only text and link to attachments...:(

can check here : http://www.braniteljski-forum.info/forum/showthread.php?p=208345

[Lynne]

Thnx Lynn ...but i wonder...is it posible that shows a attacment too...
...couse...article is showing,but in every article i have one image...
...thats images is not showing...only text and link to attachments...:(

can check here : http://www.braniteljski-forum.info/forum/showthread.php?p=208345
You are welcome to modify the plugin however you want. As I said at the beginning, it's more of an example of how to do this and you may modify it to suite your own needs.

[deverill2010]

Whitedd if you do edit it to allow attachments, can you please share as I also need to show attachments.

Thanks!

[whitedd]

...i try..but...hmmm...iam not a Coder...
...if anybody know how to do that,share with us...
...i realy need this... :(

[YkudzA]

Whitedd if you do edit it to allow attachments, can you please share as I also need to show attachments.

Thanks!
Yes, it will be very useful !

[deverill2010]

Lynne pretty please? If I could code I'd do it and share but I'm not a coder and have no hope of learning how to code.

Please :D

[Lynne]

Sorry, I never even needed this mod in the first place but wrote it for someone who did. I posted at the beginning that it's more of an example of what can be done and how to do it.

[apaydin2148]

Is it working with 4.1.3?

[Lynne]

Is it working with 4.1.3?
Works fine on my 4.1.3 test site.

[deverill2010]

Same here works perfectly fine on my live site :)

[Alp Ozdemir]

youtube links rendered in the messages but images is not, how can I show the images?

[Lynne]

youtube links rendered in the messages but images is not, how can I show the images?
You would need to modify the code to actually get the images to show. As I said at the top of the thread - this is more of an example of how you can do this. So, modify the code however you need it for your needs.

[GamersChallenge]

lol at everyone asking for the attachments, I guess I'll join the team.

please please please :(

[deverill2010]

Lynne as you've put reusable code, I have made a request for someone to modify it to show images - https://vborg.vbsupport.ru/showthread.php?p=2236659#post2236659

I hope you don't mind as I really need this.

[Lynne]

Lynne as you've put reusable code, I have made a request for someone to modify it to show images - https://vborg.vbsupport.ru/showthread.php?p=2236659#post2236659

I hope you don't mind as I really need this.
I don't mind at all. It is reusable for that reason. I only got so far with it in order to help someone else out with a specific request and just posted this in case if would help someone else get started to do something similar, or even more. :)

[brad_irc]

I don't mind at all. It is reusable for that reason. I only got so far with it in order to help someone else out with a specific request and just posted this in case if would help someone else get started to do something similar, or even more. :)

Thanks for your snippet Lynne. I do many vB mods that are never published, but your code snippet helped -- so here is the solution for users wanting [ATTACH] bbcode parsed properly. :D

Let me explain so users can better understand the code and why it appears as a link.

Deep inside /includes/class_bbcode.php, line 2581 "if (!empty($this->attachments["$attachmentid"]))" checks if the $bbcode_parser object has an array defined with details about the image attachment (ie; size, contenttype, placement, thumbnail, etc). If that data is not present, it defaults to creating a link to the attachment.

I backtracked through the function where CMS article calls the bbcode parser, see file /packages/vbcms/item/content/article.php, line 428 which shows how it fetches the attachment data using the content nodeid.

The snippet below has nodeid added to the query, and the block populating the $attachments array. Enjoy :)

Also to be noted, Tapatalk users cannot view articles on main page, now they will be able to view the content using the forum


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

$result = $this->registry->db->query_first("
SELECT cms_article.pagetext, cms_article.threadid, cms_article.htmlstate, cms_node.nodeid
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']. "
");

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

$attach = new vB_Attach_Display_Content(vB::$vbulletin, 'vBCms_Article');
$attachments = $attach->fetch_postattach(0, $result['nodeid']);
$bbcode_parser->attachments = $attachments;
$bbcode_parser->unsetattach = true;

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

}
}


PS: If anyone else has noticed that [ATTACH] is not properly parsed in RSS feeds, I will find a solution and post it in the next couple days.

[Lynne]

Thank you, Brad!

[GamersChallenge]

thanx brad, works great

[deverill2010]

Brad much appreciated!!!!! xxx

[BearOlympic]

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.)

Thanks a lot for this mod!
Just one thing - if you remove this condition - you will get text "*********" displayed in every first message of every topic. Because almost every topic meets other conditions.

As for me - i don't mind it, and i don't need a divider between auto-created text and article. so i just replaced that code with " ". not good - but fast )

[krustyx]

THIS IS THE BEST MOD EVER... thank you very much

This is how it should be integrated in CMS/VBulletin... seriously!

Thank you again!

[Mark.B]

Thanks for this Lynne;

I have done some tweaks (as usual!) and come up with this, which sort of sets the article into a post within its own box, so to speak.

http://www.bowlandcentral.com/forum/showthread.php?t=98178

[Lynne]

Very nice, Mark. I always enjoy seeing your tweeks. I am like you with modifications - I never use one straight out of the box. :)

[starman?]

...sets the article into a post within its own box, so to speak.

Very nice it is too. Would you be willing to share?

[Mark.B]

Very nice, Mark. I always enjoy seeing your tweeks. I am like you with modifications - I never use one straight out of the box. :)

Yep, I always use them as a basis to build upon. Some need very little but I almost always change bits and bobs, it's good practice too..."oh, this bit of code does THAT!....." :)

[Mark.B]

Very nice it is too. Would you be willing to share?
Have a play with this....

Change the plugin code to the below (the attachments part is commented out here, uncomment if you want attachments to embed)

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

$result = $this->registry->db->query_first("
SELECT cms_article.pagetext, cms_article.threadid, cms_article.htmlstate, cms_node.nodeid
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']. "
");



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

//$attach = new vB_Attach_Display_Content(vB::$vbulletin, 'vBCms_Article');
//$attachments = $attach->fetch_postattach(0, $result['nodeid']);
//$bbcode_parser->attachments = $attachments;
//$bbcode_parser->unsetattach = true;

$result['previewtext'] = $pagetext;
$this->post['message'] .= '<br /><br /><div class="blockhead"><a href="content.php?r='. $result ['nodeid'] . '"><b>' . $this->thread['title'] .'</b></a></div><div class="article_post">'. $result['previewtext'];
$this->post['message'] .= fetch_censored_text($bbcode_parser->do_parse($result['pagetext'], true, $result['htmlstate']));
$this->post['message'] .= '</div>';


}
}

Then add this to additional.css:
.article_post
{
border: {vb:stylevar mid_border};
border-top: 0;
background: {vb:stylevar postbit_userinfo_background};
padding: 6px;
}


The only issue I have at present is that the CMS Article URL doesn't have the SEO part after it. Also my URL formatting will probably only work with "standard" URLs and not the "Friendly" URL system, as I have never worked with that. Shouldn't take much tweaking though, I just don't know how any of that works.

[starman?]

Cheers my friend. I shall have a play this weekend.

[C.Birch]

Great edit Mark!

[darrenjdoc1]

Is it possible when someone clicks the url of the article or Read More it takes them straight to the forum post?

[darrenjdoc1]

Got it sorted :)

[deverill2010]

This seems to of stopped working for me.

If I move the article out of my dedicated vbcms forum it reverts back to the link and the article disappears out of the post?

[Mark.B]

This seems to of stopped working for me.

If I move the article out of my dedicated vbcms forum it reverts back to the link and the article disappears out of the post?
I think the code is specific to the CMS comments forum - it isn't designed to work if the thread is moved elsewhere.

[deverill2010]

I think the code is specific to the CMS comments forum - it isn't designed to work if the thread is moved elsewhere.

Now that is really annoying lol.

It's fine I'll just delete it, post it as thread then promote it. Sigh, bleeding CMS.

[Mark.B]

You could always amend the code:

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

I imagine if you took the last bit out of that it might work....
if (THIS_SCRIPT == 'showthread' AND $this->post['postcount'] == 1) {

[deverill2010]

Thank you mark works perfectly :)

Now If only I'd known that ages ago lol.

[Kaishi]

anyone know how to get this to work with 4.1.11 now that the comments are made to forums other than the cms comments forum?

[Lynne]

You can remove this from the if statement:
AND $this->thread['forumid'] == $this->registry->options['vbcmsforumid']

Unfortunately, there isn't any flag in the thread table to say the thread is an articles comment thread. I suppose you may be able to look at the thread title and see if it has the word"Article:" at the beginning and use that in the if statement so the query isn't run for every thread.

[Kaishi]

You know what's funny? Promoting from a thread to article only worked once for me. It worked and kept the original thread and prefixed it with Article:. After that 1 time, whenever I try to promote another thread, it would refuse to keep the original thread. I'm stumped.

[Lynne]

You know what's funny? Promoting from a thread to article only worked once for me. It worked and kept the original thread and prefixed it with Article:. After that 1 time, whenever I try to promote another thread, it would refuse to keep the original thread. I'm stumped.
This isn't really a suppor thread for the new CMS options. You do have three new settings on the page that you need to select before you promote the article if you want it to keep the original thread, so don't forget to set those correctly.

If you have more problems, you really should post over on vbulletin.com.

[whitedd]

...;)...now is perfect ;) ;) ;) ....thnx ;)

[CAG CheechDogg]

You could always amend the code:

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

I imagine if you took the last bit out of that it might work....
if (THIS_SCRIPT == 'showthread' AND $this->post['postcount'] == 1) {

Man, I did this but when I move it somewhere else it removes the article and only the link shows up. Am I missing something here?

Note: I did use your file Mark.B to have the article in its own box, does affect it at all?

[CAG CheechDogg]

To be honest, I wouldn't know....I have not moved to 4.1.11 at this stage, I am still on 4.1.10.

I will probably wait now until 4.1.12, after that I will need to revisit my amendments to this add on and will share what transpires.

Sorry. :(

I am still on 4.1.10 so I don't know why this wouldn't work, I finally gave up and disabled it. Sucks cuz its a pretty cool addon.

[BoardWizard]

is there a way to get "You can view the page at 'url'", so that all it does is just show the article in the preview?

[Lynne]

Huh? I don't understand the question. If you want to remove the line about the url, then just change the plugin to replace the full $pagetext instead of adding to it.

[BoardWizard]

i probably should have proofread my post. i meant get rid of. so where in the code do i replace instead of add to it?

[Lynne]

Just change this line:
$this->post['message'] .= '<br />*********<br />'. $result['previewtext'];
to something like this:
$this->post['message'] = $result['previewtext'];

[BoardWizard]

thanks but all that did was get rid of the line ******
now it says You can view the page at (Url) then the beginning of the article right next to it.

[Lynne]

Did you may sure to change the .= to a = ?

[astdirect]

Lynne, great addition and i am using it with no problems. Howeve i just want to ask a related question on whether it is possible to do the same for when you promote a blog ?

[BoardWizard]

Did you may sure to change the .= to a = ?

ah, no i did not. just did and it works now. thanks!

[Lynne]

Lynne, great addition and i am using it with no problems. Howeve i just want to ask a related question on whether it is possible to do the same for when you promote a blog ?
I'm not sure I understand what you want. If you promote a blog and then have a comments thread for it, then you can do this same sort of thing for that thread. You do need to modify my original code here if you allow comment threads in several forums though. When I originally wrote it, all comments threads were in one forum.

[astdirect]

I am on 4.1.9

When i promote a thread to a blog the thread continues to take comments but the actual blog page only shows the first post. I would like the blog to also be interacting with the thread and contain the comments...... but it doesn't.

[Lynne]

I am on 4.1.9

When i promote a thread to a blog the thread continues to take comments but the actual blog page only shows the first post. I would like the blog to also be interacting with the thread and contain the comments...... but it doesn't.
This mod will not help with that at all. You will have to code something to do what you want.

[jesfro]

Also to be noted, Tapatalk users cannot view articles on main page, now they will be able to view the content using the forum

Hey Brad,
first of all: fantastic work (based on Lynnes)!
It works great in the web browser.
But:
Regarding your Tapatalk statement... this does not work (for us... www.apfeltalk.de). There is no full CMS article in forum via Tapatalk. Anyone else noticed the problem?
Is there something i could set up in the plugin ( hook, order etc.)? Is this a vbulletin or a vbcms?

Thanks a lot in advance ;-)

[TiKu]

I've modified this add-on to display the preview text only. First you need a template called full_cms_in_comments_thread:
{vb:raw previewtext}<br />
<span class="cms_article_readmore"><a href="{vb:raw page_url}">{vb:rawphrase read_more_phrase} <img src="{vb:stylevar imgdir_cms}/read_more-{vb:stylevar right}.png" alt="{vb:rawphrase read_more_phrase}" /></a>
</span>
And this is the new hook 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, cms_node.nodeid, cms_node.userid, cms_node.url
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']. "
");

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

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

$attach = new vB_Attach_Display_Content(vB::$vbulletin, 'vBCms_Article');
$attachments = $attach->fetch_postattach(0, $result['nodeid']);
$bbcode_parser->attachments = $attachments;
$bbcode_parser->unsetattach = true;

$templater = vB_Template::create('full_cms_in_comments_thread') ;
$templater->register('previewtext', fetch_censored_text($bbcode_parser->do_parse($result['previewtext'],true,$result['htmlstate'])));
$templater->register('page_url', vB_Route::create('vBCms_Route_Content', $result['nodeid'] . ($result['url'] == '' ? '' : '-' . $result['url']))->getCurrentURL());
$this->post['message'] = $templater->render();
}
}

[Lynne]

Thanks for sharing!

[imported_dfmafia]

I'm actually trying to get the article/comments forum to post a preview of the thread on vBAdvancec cmps news feed. currently I have been unsuccessful. the comment forums look great with this mod but when I go to cmps it is still displaying "You can view the page at..." instead of the preview

[TiKu]

Thanks for sharing!Same to you. :)
One thing I still don't like, is that if you quote the first post of the comments thread, it quotes only the link to the article. This happens because the mod doesn't actually replace the post text in the database - which I like, because this way you don't have to edit the thread if you edit the article.
Does anyone have an idea how we could make quotations work while keeping the current approach of not replacing the post text in the database?

[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.

[datoneer]

Thanks Lynne awesome mod!

[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]

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]

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]

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]

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".

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]

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]

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?

[MissKalunji]

Great! it works, :) thank you!

[MissKalunji]

i have uncached template...how do i cache it? :)

[Lynne]

This modification doesn't use a template. So what template is it that you need to cache?

[MissKalunji]

scratch that comment lol I think i was just too tired last night lol i could swear I saw a comment something template uncached. ^_^ sorry

[RichieBoy67]

Has anyone figured out how to get images from the cms imported to show here as well?

[DemOnstar]

Has anyone figured out how to get images from the cms imported to show here as well?

Not sure if I know what you mean but I interpreted it to mean this..

https://vborg.vbsupport.ru/showpost.php?p=2244655&postcount=36

Hope that helps..

[Toorak Times]

Thanks for your snippet Lynne. I do many vB mods that are never published, but your code snippet helped -- so here is the solution for users wanting [ATTACH] bbcode parsed properly. :D

Let me explain so users can better understand the code and why it appears as a link.

Deep inside /includes/class_bbcode.php, line 2581 "if (!empty($this->attachments["$attachmentid"]))" checks if the $bbcode_parser object has an array defined with details about the image attachment (ie; size, contenttype, placement, thumbnail, etc). If that data is not present, it defaults to creating a link to the attachment.

I backtracked through the function where CMS article calls the bbcode parser, see file /packages/vbcms/item/content/article.php, line 428 which shows how it fetches the attachment data using the content nodeid.

The snippet below has nodeid added to the query, and the block populating the $attachments array. Enjoy :)

Also to be noted, Tapatalk users cannot view articles on main page, now they will be able to view the content using the forum


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

$result = $this->registry->db->query_first("
SELECT cms_article.pagetext, cms_article.threadid, cms_article.htmlstate, cms_node.nodeid
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']. "
");

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

$attach = new vB_Attach_Display_Content(vB::$vbulletin, 'vBCms_Article');
$attachments = $attach->fetch_postattach(0, $result['nodeid']);
$bbcode_parser->attachments = $attachments;
$bbcode_parser->unsetattach = true;

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

}
}


PS: If anyone else has noticed that [ATTACH] is not properly parsed in RSS feeds, I will find a solution and post it in the next couple days.

That worked a treat!

I have an issue where if someone makes a comment the CMS article disappears but the this Forum remains intact, not sure if 2 are connected