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

[Alex@bulletin]

Originally Posted by AURFSCAN

I didnt want the thumbs box in each post displaying a '0'

I only wanted it to display a number if someone thumbed up/down.

Heres how to,

edit sc_thumbs_box template

find

{vb:raw amount}

and replace with

<vb:if condition="$amount !=0 ">{vb:raw amount}</vb:if>

thanks again for a great mod Scandal

I also would like this modification of the code. Maybe something to make available in the options of the hack. ^^

[Scandal]

Originally Posted by Mr_Running

I like the idea :up:
Current I only have this mod set up for Album Pictures and Picture Comments.
The above template change does not seem to work as it is displaying (zero) 0...
at least for me.

May you have disabled the thumbs down votes, so works only the counter of thumbs up votes
($amount is an overall counter).

So the template edit for you is to find:

{vb:raw amount}<vb:else />{vb:raw list.users_plus_num}</vb:if>

.. and replace with:

{vb:raw amount}<vb:else /><vb:if condition="$list['users_plus_num'] !=0 ">{vb:raw list.users_plus_num}</vb:if></vb:if>

(notice: there are two "</vb:if>" at the end)

Coming soon: Thumbs Up? available for vBulletin Blog entries and comments.

[Scandal]

Originally Posted by sandboa

Great mod. But can you help me get the Name field above the thumbs up/down field?

The "Real Name" field is there automatically or by the edit of your postbit_legacy template manually?

[paulket]

This is a great mod! It's one of the best in some time on vBulletin.org... Nominated for mod of the month.

[socialteenz]

For some reasons i am not able to run the Rebuild Statistics.

I am getting a database error!

Database error in vBulletin 4.2.0:

Invalid SQL:

                  SELECT SUM(if(thumb = 1, 1, 0)) AS thumbsup, SUM(if(thumb = -1, 1, 0)) AS thumbsdown
                  FROM vb_sc_thumbs_node;

MySQL Error   : Table 'xxxxxx_smf1.vb_sc_thumbs_node' doesn't exist

[Barbaro]

It's the same

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE user
SET sc_thumbs_up_received = sc_thumbs_up_received - 1
WHERE userid = 743258;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`foooooo_com`.`user`.`sc_thumbs_up_received` - 1)'
Error Number : 1690

[Mr_Running]

Originally Posted by Scandal

May you have disabled the thumbs down votes, so works only the counter of thumbs up votes
($amount is an overall counter).

So the template edit for you is to find:

{vb:raw amount}<vb:else />{vb:raw list.users_plus_num}</vb:if>

.. and replace with:

{vb:raw amount}<vb:else /><vb:if condition="$list['users_plus_num'] !=0 ">{vb:raw list.users_plus_num}</vb:if></vb:if>

(notice: there are two "</vb:if>" at the end)

Thanks, If this is fixed in the next update I will wait.
I will not need to do a template change.

[Scandal]

Originally Posted by socialteenz

For some reasons i am not able to run the Rebuild Statistics.

I am getting a database error!

Database error in vBulletin 4.2.0:

Invalid SQL:

                  SELECT SUM(if(thumb = 1, 1, 0)) AS thumbsup, SUM(if(thumb = -1, 1, 0)) AS thumbsdown
                  FROM vb_sc_thumbs_node;

MySQL Error   : Table 'xxxxxx_smf1.vb_sc_thumbs_node' doesn't exist

Are you sure you have installed the *xml product during the upgrade to v1.8?
Look at your admincp page with your products. What version of Thumbs Up? it says that you have installed?
How to upgrade?
1. Upload and replace the new files.
2. Import XML product with "Allow overwrite" to YES.

Originally Posted by Barbaro

It's the same

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE user
SET sc_thumbs_up_received = sc_thumbs_up_received - 1
WHERE userid = 743258;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`foooooo_com`.`user`.`sc_thumbs_up_received` - 1)'
Error Number : 1690

What you try to do and appears this db error?
Also, can you see and tell me how many thumbs up "received" your user with ID 743258?

[Barbaro]

Increasingly, issues are cleared of any user masse or deleting a user.

[socialteenz]

Originally Posted by Scandal

Are you sure you have installed the *xml product during the upgrade to v1.8?
Look at your admincp page with your products. What version of Thumbs Up? it says that you have installed?
How to upgrade?
1. Upload and replace the new files.
2. Import XML product with "Allow overwrite" to YES.

Thanks you, it worked!