Miscellaneous Hacks - [AJAX] Thumbs Up?

Thumbs up/down system for all content of vBulletin!

This mod gives a simple thumbs system for:

• Forum posts
• Pictures
• Picture comments
• Profile visitor messages
• Social group messages
• vBCMS articles
• vBCMS article comments
• vBBlog entries
• vBBlog comments

Features

• Thumbs up/down rating system
• Ability to turn off "thumbs down" votes
• Uses AJAX technology (= no page refresh when voting)
• Ability to turn off system on each section
• Show who vote feature (with ability to turn it off for up or/and down thumbs)
• Postbit statistics
• Top X rated contents in latest 7 days
• Notification system for new thumbs (with ability to turn it off via usercp)
• Only first post feature
• Ban user/usergroup feature
• Turn off system on individual forums
• Importers from Post Thanks/Groans/vBSEO Likes, included!
• Thumbs Up? Center:

• - latest thumbs on "my" content
• - latest thumbs "I sent"
• - top rated contents
• - statistics

Credits to my friend Lea Verou for designing the appearance of this hack!

Language packs
German

How to install?
Read the documents inside the *zip file.

How to upgrade?
1. Upload and replace the new files.
2. Import XML product with "Allow overwrite" to YES.

Changelog:
v1.0 - first release
v1.5.2 - 1 bug fixed (only first post function issue), 2 phrase edits
v1.8.0
- new feature: support for vBCMS articles & comments
- whos online locations added
- new feature: top rated (in latest 7 days) contents page
- new feature: postbit statistics
- change: only one button when "thumbs down" are disabled
- new feature: ability to change the color of the thumbs box and the color of amount font via admincp
v1.9.0
- new feature: support for vBBlog entries & comments
- small fix to box template (thanks to Valter)
update 22/12/2012
- bug fixed: guests could not show the thumbs number (shows a zero for all posts)
- to install this fix just upload and replace the updated file includes/functions_sc_thumbs.php. It is not necessary to re-upload all files or upgrade the product xml


If you like this hack, nominate it for MOTM!

-Scandal

[gsk8]

Thanks for help! I think I know the problem

[gsk8]

So it appears after I uninstalled and reinstalled, I can't "restore" the following tables to myPHP

sc_thumbs_post
sc_thumbs_visitormessage
sc_thumbs_groupmessage
sc_thumbs_picturecomment
sc_thumbs_picture
sc_thumbs_stats

Provider says my backup tables are innodb and what I currently have is myisam.

[Munkholm]

Did you find a solution to this ? Just ran into the same problem.

[gsk8]

Yes, but I had to hire a coder and also work with my host provider (I pay for management) to fix the tables. It was a pain in the butt.

[Dave]

Originally Posted by gsk8

Yes, but I had to hire a coder and also work with my host provider (I pay for management) to fix the tables. It was a pain in the butt.

I hope you didn't get ripped off because converting tables between engines in a database only takes several minutes. (unless you have millions of records in these tables)

[gsk8]

It was a little more complicated as I had this mod "re-modified" for my purposes

[mangmel]

Database Error
]]> Database error in vBulletin 4.2.5
Invalid SQL: SELECT * FROM sc_thumbs_post WHERE postid IN () ORDER BY username ASC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY username ASC' at line 1
Error Number : 1064
Request Date : Monday, November 11th 2019 @ 05:54:20 AM
Error Date : Monday, November 11th 2019 @ 05:54:20 AM

MySQL Version :
]]>

[mangmel]

Originally Posted by mangmel

Database Error
]]> Database error in vBulletin 4.2.5
Invalid SQL: SELECT * FROM sc_thumbs_post WHERE postid IN () ORDER BY username ASC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY username ASC' at line 1
Error Number : 1064
Request Date : Monday, November 11th 2019 @ 05:54:20 AM
Error Date : Monday, November 11th 2019 @ 05:54:20 AM

MySQL Version :
]]>

solved line 109:
$thumbs = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "sc_thumbs_". $contenttype ." WHERE $data_id IN (" . implode(',', $ids) . ") ORDER BY username ASC");

[DeanoUK]

Originally Posted by gsk8

Hey, not sure what I did but get an error when trying to give thumbs up?

Just as a note. As previous suggestion you need to change line 97 to:

PHP Code:

function fetch_thumbs($id = 0, $ids = [], $contenttype, $data_id, $fetch_again = false) 


Then line 106 to:

PHP Code:

$ids = array();
$ids[] = $id; 


[Enrico1954]

I change back from PHP 7.1 to 7.0 and now the Add work again