End-User Options - Starred Posts

Overview:

This product is designed to give your users the ability to create/manage a list of starred/favorite posts so they can easily locate them in the future. Some users may have limited time when browsing your site, and wish to earmark posts to which they will want to reply later when they have more time. This product will allow them to tag these posts and easily find them later.

Upon installing the product a new table is added to your database to store the data pertaining to the user lists, and a new column is added to your user table to store the number of posts in each user's list.

Users with permission to use the system will see a star icon in the postbits just above the signature and to the far right that allows them to add the posts to their list. Once a post has been added, a checkmark appears next to the star icon to indicate that that post is already on their list, and if this is clicked the post is removed from the list. The icons have tooltips to indicate what will happen upon clicking them, as do all buttons and checkboxes used by the system.



In the search results and forum thread listings, an icon is shown to users to indicate which threads have posts in their starred list, and the icon has a tooltip indicates how many posts in the thread are in the user's starred list.



Under the "Quick Links" menu, users who have permission to use the system, will find a link titled "My Starred Posts" which will take them to a custom page which displays their starred posts and allow for posts to be removed. Each post has detailed information regarding the post, with links to the forum, thread and to the post itself. There are controls that allow the user to select posts for removal from the list, and to expand the post content so they can review the entire post(s) right there and to reply to the post with a quote. Post content can be expanded/collapsed one a per post basis, or all at once. Each postbit can be collapsed as well.



Users who have a limit imposed on the number of posts in their list will be shown additional information in the redirect messages that tell them how many additional posts they can add to their list. Once a user has added the maximum number of posts in their list, they will no longer see the star icon in the postbits with threads to add posts...they will only see the icon fro removing posts from their list.

In the product settings, you may select the usergroups that have permission to use the system, set a limit to the number of posts a user may have in their list, excempt usergroups from this limit, give limits based on usergroups, and set the persistence of user lists so that users who are inactive for longer than the number of days you have set will have their list removed from the database via a daily cron job. You may also set the maximum height of the elements containing the list of posts, and the post content within each list postbit.



This product is fully phrased, and stylevars are used so that the CSS for the custom page can be customized per style.

Updates:

Version 1.1:

• Added reply button.
• Online location processed.

Version 1.2:

• Fixed issue with postbit star icon not displaying.
• Added icon to threadbits to show users which threads haev posts in the starred list.

Version 1.3:

• Fixed Reply Button height inconsistency issue.
• Added StyleVar for position control of collapse button.
• Fixed issue causing PHP deprecation warning.
• Added support for displaying inline attached images in post content.
• Added support for BBCode For Username HTML Markup [v1.2.1].
• Added support for Abbreviations/Acronyms (MathJax Compatible) [v1.3].

Version 1.3.1:

• Fixed Thread/Post authors in postbits.

Version 1.4:

• Deleted posts removed from the lists of all users.
• Posts moved to areas where users do not have permission to view are removed from the lists of those users.
• User lists are updated when posts/threads are merged.
• Unapproved posts and posts within unapproved threads are removed from the lists of users who are not moderators of the forum in which the affected posts reside.
• Stylevar added for the margins of the postbit icon.

Version 1.5:

• Usernames escaped to avoid db errors.
• Postbit icon now appears at the lower right of the post content element when using legacy postbit, regardless of the post length.
• Postbit icon CSS moved to template.

Version 1.6:

• Added setting to allow for limits per usergroup.

Version 1.6.1:

• Guests shown no permission message if trying to access the external script.

Version 1.6.2:

• Users not part of the allowed usergroups shown no permission message if trying to access the external script.

Compatibility:

Tested and working on VB 4.2.x and may work on all 4.x versions of vBulletin.

Backup/Warning:

This product does alter your database, however it is always good practice to make regular backups and you should make a backup before installing ANY new mod.

As always, products are USE AT YOUR OWN RISK. I will provide support and do my best to help but no absolute guarantee is offered.

To Install:

1. Download and extract the attached .zip file.
2. Upload the files from the "upload" folder to your root folder on your server.
3. Follow AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product.
4. Click on "Choose File" and browse to the product .xml file that was packaged in the .zip file.
5. Click "Import."
6. You MUST enable the product in the settings before it will function.
7. Configure the remaining settings to your liking. Each setting has a detailed explanation of its use.

Special acknowledgement goes to the administrators of Christianity Haven for the general idea of this product and for their feedback and testing through all phases of development. :up:

Support for this product can be found here:

• MHB - Starred Posts
• TAZ - Starred Posts

[IggyP]

installed and thank you...

my only thought was the the quick links can be easily overlooked for some....if it was in profile section with tags, quotes, likes etc....would be a better order....

not sure how difficult but just an idea

[djbaxter]

I was experiencing intermittent very slow posting and double posting after transfer to a new VPS.

We were able to identify some problem plugins in investigating this and it turns out this was one of them.

From the host tech support:

It looks like there's a specific query being ran that's really slowing down your server.

SELECT * FROM `filedata`;
# Time: 171007 13:22:30
# User@Host: ###### @ localhost []
# Thread_id: 318579  Schema: #####  QC_hit: No
# Query_time: 7.152743  Lock_time: 0.000120  Rows_sent: 31  Rows_examined: 558
# Rows_affected: 0
SET timestamp=1507396950;
SELECT  post.pagetext AS preview,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.$
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread$
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
                        user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlis$
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible


                        , (SELECT COUNT(*) FROM starposts AS starposts WHERE starposts.userid = 0 AND starposts.threadid = thread.threadid) $
                FROM thread AS thread
                        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
                        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid$


                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

                WHERE thread.threadid IN (0,32490,26504,31904,31744,31657,31635,31567,27852,31374,31276,27962,31157,30175,29848,29692,29680,29$
                ORDER BY thread.sticky DESC, lastpost DESC;

The reason it's taking so long, is that it's using LEFT JOIN commands that will take information from a previous query, and use it into that specific query which can really slow your server down.

[MarkFL]

In that particular query, my product is not adding any LEFT JOIN commands. If the problems began after moving to a new host, I would think that's where the issue really is, although host techs, from what I've read at least, are notorious for trying to lay blame on scripts. I have run this product on multiple sites with no slowdown issues.

[djbaxter]

So the LEFT JOIN parts are from something else? Meaning the part they quoted was from more than one database query?

And yes, the issues began after downsizing from a dedicated server to a VPS.

[MarkFL]

Yes, my product's contribution to that query can be found in the plugin hooked at "forumdisplay_query" which reads:

PHP Code:

global $vbulletin;

if ($vbulletin->options['markfl_starpost_active'])
{
    $hook_query_fields .= ', (SELECT COUNT(*) FROM ' . TABLE_PREFIX . 'starposts AS starposts WHERE starposts.userid = ' . $vbulletin->userinfo['userid'] . ' AND starposts.threadid = thread.threadid) AS starcount';
} 


The rest of the query (assuming no other products are adding to that query) can be found in the core vB script "forumdisplay.php" here:

PHP Code:

    ($hook = vBulletinHook::fetch_hook('forumdisplay_query')) ? eval($hook) : false;

    $threads = $db->query_read_slave("
        SELECT $votequery $previewfield
            thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
            thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, $tachy_columns,
            thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
            user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
            user.lastactivity, user.lastvisit, IF(user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ", 1, 0) AS invisible
            " . ($fetchavatar ? "
                ,avatar2.avatarpath AS api_avatarpath, NOT ISNULL(customavatar2.userid) AS api_hascustomavatar, customavatar2.dateline AS api_avatardateline, customavatar2.width AS api_avwidth, customavatar2.height AS api_avheight,
                user2.adminoptions AS api_adminoptions, user2.userid AS api_userid, user2.usergroupid AS api_usergroupid, user2.membergroupids AS api_membergroupids, user2.infractiongroupids AS api_infractiongroupids, user2.avatarrevision AS api_avatarrevision
            " : "") . "
            " . (($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid']) ? ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed" : "") . "
            " . ($deljoin ? ", deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason" : "") . "
            " . (($vbulletin->userinfo['userid']) ? ", threadread.readtime AS threadread" : "") . "
            " . ($redirectjoin ? ", threadredirect.expires" : "") . "
            $hook_query_fields
        FROM " . TABLE_PREFIX . "thread AS thread
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = thread.lastposterid)
            LEFT JOIN " . TABLE_PREFIX . "userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = " . $vbulletin->userinfo['userid'] . ")
            " . ($fetchavatar ? "
                LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (thread.postuserid = user2.userid)
                LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar2 ON(avatar2.avatarid = user2.avatarid)
                LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar2 ON(customavatar2.userid = user2.userid)
            " : "") . "
            $deljoin
            " . (($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid']) ?  " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . " AND canview = 1)" : "") . "
            " . (($vbulletin->userinfo['userid']) ? " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")" : "") . "
            $previewjoin
            $tachyjoin
            $redirectjoin
            $hook_query_joins
        WHERE thread.threadid IN (0$ids) $hook_query_where
        ORDER BY thread.sticky DESC, $sqlsortfield $sqlsortorder" . (!empty($sqlsortfield2) ? ", $sqlsortfield2 $sqlsortorder" : '') . "
    "); 


[MarkFL]

It does appear that this plugin does not need to run except when a registered user is browsing the site, so I will update this product at the designated support sites.

[djbaxter]

Thank you, MarkFL.

[Mike-D]

Excellent work :up:

That's what I've been looking for a long time. Keep it up, Mark