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

[Snowhog]

Totally understand. It isn't a big deal.

[MarkFL]

Originally Posted by Snowhog

Totally understand. It isn't a big deal.

When I get some time, I will install DBTech's product on my local dev site and see if I can resolve the conflict.

[Snowhog]

That would be great. Thank you.

[DSemen]

Help me please. DB Error. Very good and useful mod, for a long time can someone tell me how to make it work on 4.1.3

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.postercount AS threadpostercount, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
FROM starposts AS starposts
LEFT JOIN post AS post
ON post.postid = starposts.postid
LEFT JOIN thread AS thread
ON thread.threadid = post.threadid
LEFT JOIN forum AS forum
ON forum.forumid = thread.forumid
WHERE starposts.userid = 1
ORDER BY starposts.dateline ASC;

MySQL Error : Unknown column 'thread.postercount' in 'field list'
Error Number : 1054
Request Date : Friday, March 31st 2017 @ 09:35:00 PM
Error Date : Friday, March 31st 2017 @ 09:35:00 PM
Script : http://forum.mysite.net/mystarpost.php

[MarkFL]

Originally Posted by DSemen

Help me please. DB Error. Very good and useful mod, for a long time can someone tell me how to make it work on 4.1.3

I don't have access to vB 4.1.x to test, but that column is a part of the thread table by default in vB 4.2.x.

After a quick check, I see it is not present in vB 3.8.11, so perhaps it was added in vB 4.2.x.

The quickest solution here would be for you to update to vB 4.2.4 (or vB 4.2.5 if you want to upgrade to PHP 7.x)

[DSemen]

Unfortunately it will not be possible to update. Many mods require a serious alteration. I already tried several times to update myself and it always ended in failure. I ask you, I am ready to pay, help me.

[MarkFL]

Originally Posted by DSemen

Unfortunately it will not be possible to update. Many mods require a serious alteration. I already tried several times to update myself and it always ended in failure. I ask you, I am ready to pay, help me.

Locate the following code in the file "mystarpost.php":

PHP Code:

$posts = $vbulletin->db->query_read("
    SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.postercount AS threadpostercount, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
    FROM " . TABLE_PREFIX . "starposts AS starposts
    LEFT JOIN " . TABLE_PREFIX . "post AS post
    ON post.postid = starposts.postid
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread
    ON thread.threadid = post.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum
    ON forum.forumid = thread.forumid
    WHERE starposts.userid = " . $vbulletin->userinfo['userid'] . "
    ORDER BY starposts.dateline ASC
"); 


Change if to read:

PHP Code:

$posts = $vbulletin->db->query_read("
    SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
    FROM " . TABLE_PREFIX . "starposts AS starposts
    LEFT JOIN " . TABLE_PREFIX . "post AS post
    ON post.postid = starposts.postid
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread
    ON thread.threadid = post.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum
    ON forum.forumid = thread.forumid
    WHERE starposts.userid = " . $vbulletin->userinfo['userid'] . "
    ORDER BY starposts.dateline ASC
"); 


Now, in the template "markfl_starpost_postbit", locate the line:

<tr><td>Poster Count</td><td>{vb:raw post.threadpostercount}</td><tr>

And remove it.

Let me know if this works.

[DSemen]

DB error has disappeared. But nowhere is there a reference to mystarpost.php
Also, when clicking on a link that is also not found anywhere (enter in the address bar) on the starpost.php forum posts:

vBulletin Message
DSe, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

"Go To Post" - Does not lead to a message, but leads to the first page

[MarkFL]

The file "mystarpost.php" is accessed via the navbar, under "Quick Links." It could be that vB 4.1.x is incompatible with this...this is one of many reasons I marked this product for vB 4.2.x.

I'm sorry, but I just don't have the time to rewrite this product for vB 4.1.x. There are simply too few people still using it to make it worth the effort for me. vB 4.1.x is obsolete, and I would recommend anyone still using it to upgrade.

[DSemen]

Adding to the navigation bar is not a problem at all, I'll do it myself. The problem remains that by clicking the transfer is done not to the selected post, but to the first message in the topic.