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

[Abe1]

Originally Posted by redlabour

No they are not - this is the Problem :

THANKS at Projectsection

GROAN at Blogsection

This makes no Sense

How do you want it to be then?

[redlabour]

Originally Posted by Abe1

How do you want it to be then?

Beneath each other - maybe in a own Category.

[Abe1]

Originally Posted by redlabour

Beneath each other - maybe in a own Category.

They will both be together in their next versions right under the regular search.

[redlabour]

Originally Posted by Abe1

They will both be together in their next versions right under the regular search.

Great! :up:

[Bounce]

Taking ages to install... is this normal?

Edit: Must be as installed now lol...

Wee problem thou, the thanks button is now not showing

And I've set the option that the 2 can be used together

Edit (AGAIN) LOL :

Silly me had the Disable Giving Thanks if Post is X Days Old set for 1 day

DOH!!! all working fantastic, thanks Abe1

[GreigScott]

this is like "+rep" or "-rep" -ing someone,

[MarkoP]

Abe can I pay you to add something to this?

Here's what I'd like to see...

If X number of members with XXX number of posts groan a post then the post or thread goes into "unmoderated" status, so members can't see it.

Like say if 6 members who each have 300 posts or more groan a post then it vanishes, goes into unmoderated status.

You should be able to choose how many members needs to groan a post plus how many posts each have before it will unmoderate the groaned post.

Does this make any sense?

We currently have a system like this that uses the report a post function but I think this would be much easier...

It creates a "member moderated forum" and although many thought it wouldn't work it DOES work fantastic....since we've had a member moderated system our moderator work load dropped to almost nothing. All we do now is clean up WHEN we feel like it.

And if any post was removed that we feel should not have been we just bring it back...no problem, but that happens very rarely.

I'll gladly pay you to add this feature...

[Firestar.chkn]

Hi Abe, and thanks for an excellent hack(s). I'm using both thanks and groan hack at the moment, but I have a problem.

I make use of a custom Core Admin group that's above Admin in status. However, I cannot remove all groans/thanks from a post. I cannot find an option anywhere to add this Core Admin group to the list of admins that can remove groans/thanks.

Also, is there a way to only remove a specific groan/thanks from a post?

[Leo Brazil]

Abe,

It works really great on my board, thank you for that. But there's something I'm getting here that I'd like you to take a look into.

I'm getting a Database error like below. I'm used Groan Hack combined with Post Thanks and I notice this error only with Googlebots. See the IP ? All of them belongs to Google bots.

Any idea why ?

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT post_groan.postid AS postid
FROM vbpost_groan AS post_groan
LEFT JOIN vbpost AS post USING (postid)
INNER JOIN vbthread AS thread ON(thread.threadid = post.threadid)
WHERE post_thanks.userid = 207
AND thread.forumid
IN(6,7,127,8,10,9,11,78,119,118,79,122,120,121,123 ,16,22,35,36,37,38,39,40,30,41,42,43,44,45,46,
47,48,49,124,31,18,34,26,28,27,24,25,29,23,32,116, 33,17,54,53,57,56,55,51,50,52,58,12,80,81,76,77,
14,15,112,13,75,59,99,100,101,60,71,72,73,74,61,67 ,68,70,69,63,94,95,64,66,117,125,65,62,82,88,89,
90,91,83,92,93,84,102,103,85,104,105,106,107,113,1 14,115,86,108,109,87,110,111,96,97,98)
ORDER BY post.dateline DESC
LIMIT 1000;

MySQL Error : Unknown column 'post_thanks.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 1st 2008 @ 07:06:23 PM
Error Date : Saturday, November 1st 2008 @ 07:06:23 PM
Script :
http://www.mysite.com/forums/post_gr...ser_gave&u=207
Referrer :
IP Address : 66.249.71.230
Username : Not Registred
Classname : vB_Database
MySQL Version :

[albibak]

Thanks Abe1 for this hack
Is it possible to have the psd button?