vb.org Archive - Show Thread Enhancements - [AJAX] Post Thank You Hack

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=122944)

Quote:

Originally Posted by Abe1 (Post 1396588)

Can you please explain more.

I think I can explain that problem. In reputation.php, not only the reputation points of a user are updated, but also the reputationlevelid. That way, the reputation level of a user is updated instantly. You just give the reputation points, but do not update the reputationlevelid. So if a user gets 1000 reputation points by post thank you hack, but does not get any reputation the normal way, his reputationlevel will not update.

To fix this problem, a minor change to function add_thanks() is sufficent i think

PHP Code:


		
			
    if ($vbulletin->options['post_thanks_reputation'])

    {

        $vbulletin->db->query_write("

            INSERT IGNORE INTO ". TABLE_PREFIX ."reputation

                (postid, userid, reputation, whoadded, reason, dateline)

            VALUES

                ('".$postinfo['postid']."', '".$postinfo['userid']."', '" . $vbulletin->options['post_thanks_reputation'] . "', '" . $vbulletin->userinfo['userid'] . "', '$vbphrase[post_thanks_thanked_post]', " . TIMENOW . ")

        ");



        if ($vbulletin->db->affected_rows() != 0)

        {

            ////////////////////////////////////////////////

            // BEGIN FIX

            ////////////////////////////////////////////////

            // Query copied from reputation.php

            // Determine this user's reputationlevelid.

            $reputationlevel = $vbulletin->db->query_first_slave("

                SELECT reputationlevelid

                FROM " . TABLE_PREFIX . "reputationlevel

                WHERE " . ($postinfo['reputation'] + $vbulletin->options['post_thanks_reputation']) . "  >= minimumreputation

                ORDER BY minimumreputation

                DESC LIMIT 1

            ");

            // I do not store the new reputation calculated for the query above and use it here again to avoid a potential race condition

            $set_user_got .= ", reputation = " . $vbulletin->options['post_thanks_reputation'] . " + reputation, reputationlevelid = " . intval($reputationlevel['reputationlevelid']);

            ////////////////////////////////////////////////

            // END FIX

            ////////////////////////////////////////////////



        }

    }

I hope that small note helps you improving that great hack further!

Hack has been generating errors.... :confused:

Here's a typical one ...

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM post_thanks 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
Date : Friday, January 18th 2008 @ 06:25:54 AM
Script : http://www.xxxxx.com/post_thanks.php...sing_ajax=1&p=
Referrer :
IP Address : xx.xx.xx.xxxx
Username : Badger
Classname : vB_Database

Some information XXX'd out for privacy...

Regards,
Badger

It's such a good hack.

Quote:

Originally Posted by BadgerDog (Post 1423689)

Hack has been generating errors.... :confused:

Here's a typical one ...

Some information XXX'd out for privacy...

Regards,
Badger

Do you know where you are getting this error from? It seems like some is clicking to remove their thanks and the link is not good. The postID is not being sent. Please check the post thanks templates.

Quote:

Originally Posted by Abe1 (Post 1428400)

Ok, will check.... :up:

I haven't seen another one since I posted the message here ...

Thanks :)

Regards,
Badger

How do you change the VIEWS column to show the amount of thanks a thread has?

Because, we all know that the number of views a thread has doesn't mean anything compare to the amount of thanks it has. It would make it easier for users to find old quality threads when surfing the forum.

Thanks!

Can I set an additional 'thanks' button? For "job well done" or some such thing? How do I go about adding a button -- I can do the graphics, but is there a problem with having two "thanks" hacks on a forum?

:)

Is there anything besides the thank you and the groan hack? Or a "how to" for writing my own?

Quote:

Originally Posted by alphamarc (Post 1437425)

This is a good idea! https://vborg.vbsupport.ru/external/2008/02/15.gif

However rather than having a forumdisplay column, I would suggest adding icon in the thread title column, ala the rating graphics, that shows up if there is any thanks for any post on the thread with tool tip with "Thread contains x posts that where thanked a total of Y times".

Note that thanks are registered on the post level rather than the thread level. Still it is easy enough to find out if any posts on that thread have been thanked.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02995 seconds Memory Usage 1,764KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: