Miscellaneous Hacks - [CMS] Use original thread for comments

As of 4.1.11 this functionality is included in vbulletin. So you no longer need this mod.

What does this do?
This is a really simple hack that sets the thread for article comments to be the original thread for any thread that is promoted to an article.

What can I use it for?
This mod has two major uses:

1. If you have a wealth of information in your forums and you want to promote it into articles, this mod allows you to retain the rest of the thread as comments in the cms while adding any new comments as replies to the thread; essentially allowing it to function as both a forum thread and a CMS article.

2. If you want to use multiple fourms for CMS comments. This is a fairly none obvious use case, but probably a popular one. If you have three sections in your cms (for example) and want each section to feed into its own forum, the current cms dosn't allow you to do this. With this mod installed, you can. Instead of creating your new article directly in the cms create it in the forum you wish to use for comments. Write your article as the first post of the thread and promote it to a cms article. Fill out the extra information needed (eg publish date) and save. Comments will be saved into the original thread, in the forum you created it in.

Installation Vb 4.0.1 and later
1. Import product

Uninstallation
1. Disable the plugin "set thread id"

Full uninstallation
1. Move threads that have been promoted to articles into the vbcms comments forum.
2. COPY the threads back to their original forums
3. Remove product

Steps 1 and 2 are needed to retain cache functions on the comments threads. Without them new comments will not appear on the article.

Changelog

• 4.0-0.1 a2
  • Fixed bug causing original thread to be delete when the article was deleted
• 4.0-0.1 a1
  • Initial release

Notes

• I believe this is the first mod for the CMS (not including addon widgets/content types)
• Removing this product entirly will cause issues with the cache on any articles using the original thread. Follow the uninstall steps to remove functionallity while retaining the ability to comment on these articles this mod has altered.
• [S] Although its compatible with vbulletin 4.0 Rc 4, a bug in RC 4 and 4.0.0 Gold prevents it from acctually working. I have provided a replacement hooks_vbcms.xml file which corrects the issue in the interim.[/S] (fixed in vb4.0.1)
• [s]Deleting an article will remove the associated original thread This is considered a bug in this product and will hopefully be fixed with the next release. [/s] (fixed)
• The above bug has been fixed, however pending this request: http://www.vbulletin.com/forum/proje...?issueid=34188 Thread tags for the original thread will still be removed. There is /nothing/ I can do about that until the issue listed is resolved. (this has been marked as fixed in 4.0.2; will update further when i've tested that its fixed.)
• [S]If you hard delete the original thread without first removing the article you will be affected by this bug: http://www.vbulletin.com/forum/proje...?issueid=34187 the fix I posted to that issue needs to be applied BEFORE deleting the original thread. After more research, this only becomes an issue if you promote a thread more than once. If you've done this, you can fix the error by clearing the CMS cache.[/S] (fixed in 4.0.1)

As of 4.1.11 this functionality is included in vbulletin. So you no longer need this mod.

[sticky]

So when this becomes a part of 4.2 how will the upgrade work? Will I need to disable this mod/uninstall it before upgrading?

[Carnage]

Yes, they do. Do you have a work-around?

I've just had a quick look at the new posts block. The main db query that generates it strips out the threads which are associated with a CMS article. The work around would be to remove that condition in the query. You may then want to limit the forum(s) selected to not select from the normal cms comments forum.

So when this becomes a part of 4.2 how will the upgrade work? Will I need to disable this mod/uninstall it before upgrading?

I really couldn't say at this point. Since I'm using this on my own forums I will need an upgrade path myself so will be planning + developing one once vb 4.2 is available to me.

[carrlos]

Originally Posted by Carnage-

I've just had a quick look at the new posts block. The main db query that generates it strips out the threads which are associated with a CMS article. The work around would be to remove that condition in the query. You may then want to limit the forum(s) selected to not select from the normal cms comments forum.

Can you give some help on how to do this?

[Carnage]

ok, go into includes/block/newposts.php

Find:

PHP Code:

            $posts = $this->registry->db->query_read_slave("
                SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
                    thread.threadid, thread.title, thread.prefixid, post.attach,
                    forum.forumid,
                    user.*
                    " . ($this->registry->options['avatarenabled'] ? ",avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight" : "") . "
                FROM " . TABLE_PREFIX . "post AS post
                JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
                JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)
                LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
                "  . ($this->registry->products['vbcms'] ? " LEFT JOIN " . TABLE_PREFIX . "cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid \n" :  '')
            . ($this->registry->options['avatarenabled'] ? "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)" : "") . "
            WHERE 1=1
                $forumsql
                AND thread.visible = 1
                AND post.visible = 1
                AND thread.open <> 10
                AND post.dateline > $datecut
                $globalignore
                " . ($this->userinfo['ignorelist'] ? "AND post.userid NOT IN (" . implode(',', explode(' ', $this->userinfo['ignorelist'])) . ")": '')
            . ($this->registry->products['vbcms'] ? " AND info.associatedthreadid IS NULL " :  '') . "
            ORDER BY post.dateline DESC
            LIMIT 0," . intval($this->config['newposts_limit']) . "
            "); 


remove this line:

. ($this->registry->products['vbcms'] ? " AND info.associatedthreadid IS NULL " : '')

but leave the ." on the end.

[carrlos]

Thanks. I'll give it a try. Will it be the same for threads?

Edit:
It worked for both, thanks!

[apaydin2148]

When i publish article (forum thread) , forum thread have a "Article:" tag. I don't want this. For example: if the topic is "x" when i publish that topic as a article and someone write a comment this topic, thread is "article: x" how can i fix this issue?

[apaydin2148]

any ideas?

[sticky]

Is this working in 4.1?

[mitch84]

Originally Posted by sticky

Is this working in 4.1?

yes, work fine for me on vb4.1.pl2

[apaydin2148]

Originally Posted by apaydin2148

When i publish article (forum thread) , forum thread have a "Article:" tag. I don't want this. For example: if the topic is "x" when i publish that topic as a article and someone write a comment this topic, thread is "article: x" how can i fix this issue?

...?