Mini Mods - Recent Thanks for [AJAX] Post Thank You Hack

Info:

• This mod works with the hack "[AJAX] Post Thank You Hack" as an addon and a) provides a page with the latest X (default: 25) "Thank You" the user has received b) notify the user via vbulletin notification menu (on navbar)
• Very useful for users who want to keep up with the "Thank You" votes on their posts.

System Requirements:

• [AJAX] Post Thank You Hack - for vB4
• vBulletin 4.x

Installation information on hack:

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

How to install:

1. Upload the file "recent_thanks.php" to your forum directory.
2. Import XML file (as product): AdminCP > Plugin System > Manage Products > [Add/Import Product]
3. (Optional if you enable the notifications) Add the link "http://www.yourforum.com/recent_thanks.php" where you want (for example to navbar).

Notice (not a bug): The system doesn't decrease the notifications' count for new "Thank you" when the admin push the "Remove all" of a post (rare but ok). So the user will notified but he will not see the removed votes on the page.

How to upgrade:

1. Upload the new file recent_thanks.php
2. Import XML file (as product): AdminCP > Plugin System > Manage Products > [Add/Import Product] with set of "Allow Overwrite" to YES

How to upgrade from vB3 version:
This hack developed from zero for vB4, so if you upgrade your forum from vB3 to vB4 with the vB3 version of this hack on it, you must uninstall first this older version and to do a clean install of this hack (product install and new file upload).

Changelog:

• v2.5 - First release for vB4
• v2.6 - updated file, linkable usernames, admincp phrase changed, 1 bug fix
• V2.6.2 - add: who's online location (thanks to Hippy), 1 css fix

Tested on: vBulletin 4.1.11 - Post Thank You Hack 7.83

-> Don't forget to click INSTALL!

[stevieb]

Lol yea I know but can we make an option in user cp that is individual choice and not forum wide?

[Hippy]

I'm sure you can be but there was no demand for it it was never done.
Sorry if scandal likes the idea he may.

[stevieb]

Fair enough. Thanks mate

[Zoul]

Hello
a little help please

I am running vb 4.2.1
and I use Post Thank You Hack 7.82 (I did not find the 7.83 version marked test above)

I have no Recent_Thanks that appears in the party while I made two actions.
Yet the addon is enabled

My navbar is completely created and I introduced them the link to the page: recent_thanks.php

I let you look:



it several times I got the xml file without success.
Do you have an idea please?

[evelynpriscilla]

if ($vbulletin->options['recent_thanks_notif'] AND $vbulletin->options['recent_thanks_on_off']){
$quer = "SELECT recent_thankact FROM " . TABLE_PREFIX . "user WHERE userid = ".$vbulletin->userinfo['userid']." AND recent_thankact=1";
$temp = $db->query_read($quer) or die("Error: ". mysql_error(). " with query ". $quer);
$isthere = mysql_num_rows($temp);
if($isthere){
$recent_thankact_checked = 'checked="checked"';
}
else {$recent_thankact_checked='';
}

$templater = vB_Template::create('recent_thanks_ufield');
$templater->register('recent_thankact_checked', $recent_thankact_checked);
$templater->register_page_templates();
$template_hook[usercp_options_messaging] .= $templater->render();

}

Getting this error message in vb4.2.1

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in [path]/profile.php(2083) : eval()'d code on line 4

Originally Posted by Scandal

Try another one replace to the plugin with:

PHP Code:

if ($vbulletin->options['recent_thanks_notif'] AND $vbulletin->options['recent_thanks_on_off']){
    $isthere = $db->num_rows($db->query_read("SELECT recent_thankact FROM " . TABLE_PREFIX . "user WHERE userid = ".$vbulletin->userinfo['userid']." AND recent_thankact=1"));
    if($isthere){
    $recent_thankact_checked = 'checked="checked"';
    }
    else {$recent_thankact_checked='';
    }

       $templater = vB_Template::create('recent_thanks_ufield');    
   $templater->register('recent_thankact_checked', $recent_thankact_checked);
$templater->register_page_templates();  
   $template_hook[usercp_options_messaging] .= $templater->render();

} 


Hope it will fix the problem.

Parse error: syntax error, unexpected '<' in /home1/******************/profile.php(2083) : eval()'d code on line 15

Thanks for the mod and support.

[jimnyc]

I am running version 4.2.0 and am using this with version 7.83 of the thank you hack, with all the updates through the thread. All was fine until a few days ago, of course with 0 changes to my site or this hack.

Anyway, when someone clicks on "recent_thanks", much of the time it hangs or takes forever. Then while it's hanging, I get a SQL database error emailed to me that the "server has gone away". Nothing else on my site causes this to happen.

I assume when someone click on this, it does a query for the last 25 thanks received and displays them. Somehow this script is causing the SQL server to hang. I did recently move between providers.

Could this be a database problem? Or maybe something with a file? This is the email I receive, with personal stuff redacted. Thanks to anyone that can point me in right direction!!

Database error in vBulletin 4.2.0:

Invalid SQL:

      SELECT post_thanks.postid, post_thanks.date, post_thanks.username, post_thanks.userid, thread.title 
      FROM post_thanks AS post_thanks
      LEFT JOIN post AS post
      ON post_thanks.postid = post.postid
      LEFT JOIN thread AS thread
      ON thread.threadid = post.threadid      
      WHERE post.userid = '23'
      ORDER BY post_thanks.id DESC
      LIMIT 25;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Friday, December 6th 2013 @ 09:15:16 AM
Error Date    : Friday, December 6th 2013 @ 09:16:18 AM
Script        : http://www.***.com/recent_thanks.php
Referrer      : http://www.***.com/forum.php
IP Address    : 208.102.*.*

[jimnyc]

^^ In addition to the above, I just uninstalled this hack, re-uploaded all of the PHP files and re-installed the XML. I also changed the results page from 25 thanks to 15. The results are the same, very, very slow. Everything else on my site loads quickly.

[Hippy]

Changing host is definitely the cause.

Did you try optimizing the database from phpmyadmin?

Did you try the recounter in the admincp for post thanks?

Something is screwy with the count causing the errors and slowing sql (database) searching.

Install post thanks xml from the admincp. Overwriting.
Don't uninstall, you'll lose at data

[jimnyc]

Originally Posted by Hippy

Changing host is definitely the cause.

Did you try optimizing the database from phpmyadmin?

Did you try the recounter in the admincp for post thanks?

Something is screwy with the count causing the errors and slowing sql (database) searching.

Install post thanks xml from the admincp. Overwriting.
Don't uninstall, you'll lose at data

I did the optimize earlier, and I did the overwrites. Where in the admincp will I find the option to recounter the post thanks? I looked under maintenance so far and can't locate it.

Thanks!!

[jimnyc]

I found it, doing the recounter now...