Show Thread Enhancements - [AJAX] Post Groan Hack

Post Groan Hack 4.1

About this hack:
This hack was requested by users who like my "Post Thank You Hack". Both can run together on the same forum.

This hack adds a "groan" button to all posts. Any user can "groan" at a post. This will reduce the amount of "junk" posts your forum gets.

Features:

• Uses vBulletin easy Product installer/updater/uninstaller
• Uses AJAX technology so your users don't have to refresh when they groan at a post.
• Places an easy to use button next to the edit button
• Separate looks for postbit and postbit_legacy
• Places all Groans into one small box
• Uses only ONE query every time you view a showthread page!
• Users can't groan twice
• Guests don't see 'groan' button
• Counts how many groans a user gives
• Counts how many groans a post gets
• Shows how many groans a user gave in every post of his
• Shows how many groans a user gave in profile
• Shows how many groans a user got
• Shows info in profile
• Search for a users groaned at posts
• Search for all groaned at posts
• Administrator can remove all Groans from a single post
• Users can remove their own Groans (Option to turn it off)
• Turn on and off hack totally
• Turn on and off hack for only some forums
• Option to turn off hack view of date all forums
• Option to integrate hack with Post Thanks Hack
• Ban Usergroups
• Ban Users
• Uses Phrases
• Cache Templates

Installation information on hack:

• Files edited: 0
• Templates edited: 0
• Files to upload: 7
• Time to install: 1 minute max

Updates:

Version 4.0 (10/13/08):

• Release of this hack for vBulletin version 3.7
• All Features that my Post Thanks Hack has.

Version 4.1 (10/15/08):

• Added missing phrase
• Fixed one of the searches.

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

Pictures:

1. Showing the 'groan' button and stats in Postbit
2. Showing post after 'groan' (user view)
3. Showing post after 'groan' with legacy posts (admin view)
4. Stats in members profile
5. Hacks settings

[popular]

Originally Posted by Abe1

Yes. Check my profile.

yes the box or stats under the avatar , i figure most users won't be groaned so the stats under their name could be a little distracting.

[digicom]

Aprrciated Installed :up:

[bigtime]

Hi,

Thanks for the hack.

I don't have the thank you hack installed but yet I continue to get these errors:

PHP Code:

Invalid SQL:

            SELECT post_groan.postid AS postid
            FROM post_groan AS post_groan
            LEFT JOIN post AS post USING (postid)
            INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
            WHERE post_thanks.userid = 18555
                AND thread.forumid IN(72,18,1,87,2,3,4,5,6,88,89,30,32,78,31,73,74,77,20,8,10,19,7,75,21,9,22,33,85,11,13,36,25,29,42,46,45,47,82,79,80,15,17,81,61,62,63,64,65,66,56,57,58,59,60,48,49,50,51,52,53,54,55,67,68,69,70,71,34,37,38,39,40)
            ORDER BY post.dateline DESC
            LIMIT 1000;

MySQL Error   : Unknown column 'post_thanks.userid' in 'where clause'
Error Number  : 1054 


I have the following set to No: Integrate this hack with Post Thanks Hack?

Thanks,

Tim

[bigtime]

I opened post_groan.php and found the following on line 377:

PHP Code:

            WHERE post_thanks.userid = $user[userid] 


I changed it to:

PHP Code:

            WHERE post_groan.userid = $user[userid] 


That should stop the errors. Any drawbacks to doing that?

Thanks,

Tim

[BANDiT600]

User Profile. Has missed one phrase or...??? Any suggestion???

[BANDiT600]

Originally Posted by redlabour

Solved - changed the Order of processing the PlugIns.

What you did???

[Abe1]

Version 4.1 (10/15/08):

• Added missing phrase
• Fixed one of the searches.

[BANDiT600]

Thank you very much!

[redlabour]

Bug:

Watch the Screenshot (GREEN) - how to fix this to get this in a normal order?

Or please add a own Category in Quicklinks for Thanks and Groan.

And the Links do not work on vBadvanced installed in / and not in /forum/ because they are still not using the complete Path.

Suggestion:

Please add a Option to deactivate the Quicklink in AdminCP.

[Abe1]

Originally Posted by redlabour

Bug:

Watch the Screenshot (GREEN) - how to fix this to get this in a normal order?

Or please add a own Category in Quicklinks for Thanks and Groan.

And the Links do not work on vBadvanced installed in / and not in /forum/ because they are still not using the complete Path.

Suggestion:

Please add a Option to deactivate the Quicklink in AdminCP.

Sorry, i dont understand that language.