Show Thread Enhancements - [AJAX] Post Thank You Hack

Post Thank You Hack

STAFF EDIT:
Note - The mod author has been unreachable for some time, but the vbulletin.org community has stepped up to provide a number of individual fixes over the years. ForceHSS, Hippy, and Seven Skins have all combined many of these fixes into product files.

ALL CREDIT STILL GOES TO ABE1 And this is still 'his' mod. Please still mark the mod as installed if you use any version of it.

That said so you don't need to apply a dozen + small fixes yourself you should consider downloading one of the updated packages below:

Hippy has one in this post.

AND / OR

ForceHSS has one in this post.

AND/OR

Seven Skins has one in this post.


- Original File Specs: post_thanks_7_82.zip (26.4 KB, 24844 downloads) - Original file removed, replaced with patched files including search fix (some admins noticed hackers attempting to use outdated code to exploit search in attempt to gain administrator password or similar).
- There are five total patched versions available, some with and without the search fix - I've replaced the main file with the patched versions... please be sure to download and install the correct version, the main mod post contains links to additional information and patched files!
- If Abe1 returns he can request these packages be removed.


About this hack:
One of the biggest problems on forums as you may know is 'posts boosting'. There are users who LOVE to say 'thanks' when ever they can. How can it hurt? Their post count goes up, they have nothing to loose.

There are also users who really like to express their thanks to post but don't like posting a post that looks like they're post boosting.

Then comes the moderators who have to delete people's thanks yous so a thread can look readable with out the thanks yous thrown around.

Finally comes the posters of these useful posts. They have no idea how many people really likes their posts if only some people say 'thanks'.

What this hack does is fix ALL these problems - except those users who like post boosting. This places a button called 'thanks.' When a user clicks on it, it places his username in a box right under the post saying that so-and-so says 'thanks' for the post. Every-one who clicks is placed in one box.

By giving your users the extra feature, you forum will look allot nice and organized. It is a guaranteed liking by ALL the members of your forum.


Features:

• Uses vBulletin easy Product installer/updater/uninstaller
• Uses AJAX technology so your users don't have to refresh when they thank.
• Places an easy to use button next to the edit button
• Separate looks for postbit and postbit_legacy
• Places all Thanks into one small box
• Uses only ONE query every time you view a showthread page!
• Users can't thank twice
• Option to not allow users to thank their own post
• Guests don't see 'thanks' button
• Counts how many thanks a user gives
• Counts how many thanks a post gets
• Shows how many thanks a user gave in every post of his
• Shows how many thanks a user gave in profile
• Shows how many thanks a user got
• Shows how many posts or a user are thanked
• Shows info in profile
• Search for a users thanked posts
• Search for all thanked posts
• Administrator can remove all Thanks from a single post
• Users can remove their own Thanks
• Turn on and off hack totally
• Turn on and off hack for only some forums
• Option to turn off hack for all but the first post of a thread
• Option to turn off hack for all but the first post of a thread in specific forums
• Option to turn off hack view of date for specific or all forums
• Option to add to post count when someone clicks 'thanks'.
• Option to give a user who receives thanks reputation points.
• Ban Usergroups
• Ban Users
• Uses Phrases
• Cache Templates
• Guaranteed to be liked by ALL users on your forum!

Installation information on hack:

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

Updates:


Version 7.80 (12/30/09):

• Release of this hack for vBulletin version 4.0

Version 7.81 (01/02/10):

• Fixed some install and uninstall database errors.
• Made styling for postbit legacy a little better.
• Fixed the "separator" issue.
• Javascript file updated.

Version 7.82 (01/03/10):

• Fixed info alignment issues in the postbit for custom edited phrases.

NOTE: *** Offer for paid services removed ***

[billstelling]

Only one of dbtech's mods worked correctly on my forums. and when I updated the one thing that was yestwrday it ++++ed up my forums. So no more of their stuff for my site. Now sstab won't work to hide the what's new tab on the cmps home page. Had to remove my blog tab for now untill i can figure out what's causing it. Just that tab.. it will still hide the forum tab in the cmps if i toggle it and the what's new on the forum, just not in the cmps.. go figure..
anyone know what code to remove in navtab to get rid of the whats new altogether?

[sadiq6210]

DragonByte Tech
Thanks for your effort, this is your work and you can promote it as you want even by 1 million .. this is your mod and you are free

I have few questions for you please
I am using Abe mod and I am going to buy your pro release to convert it just to get two awesome features (Notifications and searching "Who thanked your post and where?")

But before that, can I make the "pro" release exactly same Abe mod which I am using now (I mean just in appearance)
https://vborg.vbsupport.ru/attachmen...1&d=1305396113

Also,I don't want (like/dislike) or any additional features, I want it simple in function and appearance just like Abe mod


2-

Uses only ONE query every time you view a showthread page!

What about your mod?

3-

Uses AJAX technology so your users don't have to refresh when they thank

What about your mod?

Thanks and appreciate your effort again

[djbaxter]

Originally Posted by billstelling

Only one of dbtech's mods worked correctly on my forums. and when I updated the one thing that was yestwrday it ++++ed up my forums. So no more of their stuff for my site.

Similar experience: I had to restore my forum from a day old backup after uninstalling one of their mods.

Originally Posted by billstelling

Now sstab won't work to hide the what's new tab on the cmps home page. Had to remove my blog tab for now untill i can figure out what's causing it. Just that tab.. it will still hide the forum tab in the cmps if i toggle it and the what's new on the forum, just not in the cmps.. go figure.. anyone know what code to remove in navtab to get rid of the whats new altogether?

One option is to try https://vborg.vbsupport.ru/showthread.php?t=228507 instead of SSTab. I found that to be a little less finicky.

To change it manually, I think this should do it:

1. Admin CP >> Styles & Templates >> Style Manager >> {your style} >> Edit Templates

2. Find and edit Navigation / Breadcrumb Templates >> navbar

3. Find and comment out or delete:

PHP Code:

<li><a href="search.php?{vb:raw session.sessionurl}do=getnew&amp;contenttype=vBForum_Post">{vb:rawphrase new_posts_nav}</a></li> 


4. Save

[Gradonil_Ral]

Originally Posted by Vaira

You have missed the point. You have included the importer which reads abe1's tables into your paid version with the intention to make more profit. You know that abe1 has canceled support and that many of us are using his hack already.
To get paid for own work is out of question. Compared to your free version it is almost no effort to write a script that reads tables. Almost no effort to have most profit. Profit made because of the fact that we are using abe1's tables already.

If I am wrong than just provide the importer at your free version as well.
Anything else is pointless arguing to me.
If you would provide the importer at the free version as well, your profit will decrease. I know that and you know that and hence it is available at your paid version only

Why don't you learn SQL a bit? You only need basic knowledge to run a query that'll import thanks from Abe's hack to DBTech's.
The only problem, for a newbie, might be importing stuff from 2 different tables (yeah DBTech's table doesn't match Cyb's table).

Cyb's "_post_thanks" table has columns:
id
userid
username
date
postid

DBTech's "_dbtech_thanks_entry" table has columns:
entryid <-- you copy Cyb's id here
varname <-- you write "thanks" here
userid <-- you copy Cyb's userid here
contenttype <-- you write "post" here
contentid <-- you copy Cyb's postid here
dateline <-- you copy Cyb's date here
receiveduserid <-- the only problematic column - you need to copy userid from the '_post' table, from the postids matching the contentid that you've just copied.

And no, I'm not gonna write the query here - if you don't wanna buy the DBTech's Pro version, then you should write the query yourself. With my explanation it should be easy enough, anyways.

[djbaxter]

Originally Posted by sadiq6210

DragonByte Tech
Thanks for your effort, this is your work and you can promote it as you want even by 1 million .. this is your mod and you are free

I have few questions for you please
I am using Abe mod and I am going to buy your pro release to convert it just to get two awesome features (Notifications and searching "Who thanked your post and where?")

But before that, can I make the "pro" release exactly same Abe mod which I am using now (I mean just in appearance)
https://vborg.vbsupport.ru/attachmen...1&d=1305396113

Also,I don't want (like/dislike) or any additional features, I want it simple in function and appearance just like Abe mod


2-
What about your mod?

3-
What about your mod?

Thanks and appreciate your effort again

Originally Posted by Gradonil_Ral

Why don't you learn SQL a bit? You only need basic knowledge to run a query that'll import thanks from Abe's hack to DBTech's.
The only problem, for a newbie, might be importing stuff from 2 different tables (yeah DBTech's table doesn't match Cyb's table).

Cyb's "_post_thanks" table has columns:
id
userid
username
date
postid

DBTech's "_dbtech_thanks_entry" table has columns:
entryid <-- you copy Cyb's id here
varname <-- you write "thanks" here
userid <-- you copy Cyb's userid here
contenttype <-- you write "post" here
contentid <-- you copy Cyb's postid here
dateline <-- you copy Cyb's date here
receiveduserid <-- the only problematic column - you need to copy userid from the '_post' table, from the postids matching the contentid that you've just copied.

And no, I'm not gonna write the query here - if you don't wanna buy the DBTech's Pro version, then you should write the query yourself. With my explanation it should be easy enough, anyways.

Please note: This is NOT the support thread for the DBTech mod. This is the thread for Abe1's Thank you mod.

[Gradonil_Ral]

Originally Posted by djbaxter

Please note: This is NOT the support thread for the DBTech mod. This is the thread for Abe1's Thank you mod.

Which doesn't work with the current vBulletin, yeah.

[djbaxter]

1. It DOES work. I'm using it quite happily with 4.13.

2. Whether or not it works for you, this isn't the place to promote other mods. If you like the DBTech mod, go over to that thread and promote it there. Those of us who are using Abe1's mod are here to try to help support and troubleshoot issues for others who are using it.

[Gradonil_Ral]

Oh, right. Someone uploaded the updated version recently, but it didn't work ~2months ago so I switched to DBTech's. And no, I'm not a fan of this mod at all - I just decided to reply to Vaira's post.
But ok, let's stop here, cuz like it or not we're both making an OT.

[Paul M]

Originally Posted by Gradonil_Ral

But ok, let's stop here

Yes, I think its time to do exactly that.

[gnrx]

In some days, I received a email of my forum with database error.

The error is that, a google agent (for example) search old tables of old version of this mod, for example, I received this notification by mail of my forum:

Database error in vBulletin 4.1.3:

Invalid SQL:

			REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
			VALUES (0, '66.249.71.19', 1, 'abdo70', '', 'post.dateline', 'DESC', 0.06050, 1, '150333,139614,139554,138804,133802', 1305382860, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:7022;s:6:\"abdo70\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'c6eb59e052c1124968f5ed830e05dd4a');

MySQL Error   : Table 'mydatabase_myusername.search' doesn't exist
Error Number  : 1146
Request Date  : Saturday, May 14th 2011 @ 09:21:00 AM
Error Date    : Saturday, May 14th 2011 @ 09:21:00 AM
Script        : http://www.myforum.com/foro/post_thanks.php?do=findthanks_user_gave&u=7022

Its possible make for not search this old tables (googleboots and others)?

Thanks and regards!