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

[Leo Brazil]

Originally Posted by Leo Brazil

Database error in vBulletin 3.7.3:

Invalid SQL:

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 :

Just some more details I've notice, may be to help you out to find a fix for this.

I get this error only when Googlebots are cheking users profiles as I have enabled "show stats at profile".

I've noticed visitor can have an answer if they try to use "Find All Posts Groaned by" the answer for the search is always "Sorry, no matches were found" but as a regular visitor despite of the getting any results I don't have the same MySQL error. If I just log in I can get results using the same script. So far so good because I believe visitors don't need such info.
Why am I getting this error only with Googlebots ?

Tks.

[albibak]

You can find the french translation here for the version 4.1 and in attachement (with the french button).

[Abe1]

Originally Posted by 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 :

Upload the latest files. This bug was fixed already.

[Abe1]

Originally Posted by albibak

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

Sorry, I dont have one.

[bigtime]

Originally Posted by Leo Brazil

Abe,


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 Version :

Upgrade or do the following:

https://vborg.vbsupport.ru/showpost....6&postcount=24

[Leo Brazil]

Originally Posted by Abe1

Upload the latest files. This bug was fixed already.

Originally Posted by bigtime

Upgrade or do the following:

https://vborg.vbsupport.ru/showpost....6&postcount=24

Thanks guys. In fact I was using the current version but the dumb one here forgot to upgrade one file...
Never happended this to me before....

[Dragonsys]

can this be integrated with vBExperience, like the Post Thank You is?
So any posts with groans, would lose vBExperience points.

[Blumy]

Is there any way to change the name from Groan to something else? For some reason my users really like shenanigans...could i make it display as shenanigans in the postbit?

[vktechnology]

for my website i rename as DISAGREE button instead of goan button

[vktechnology]

How can i place this goan button manully ?
i wan tto change possition.

I donlt want to palce near by thank button it easy to make mebers to press wrong button..