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

This seems to not work in 4.1.8.

The following dependencies were not met:
This product is not compatible with version 4.1.8 of vBulletin. (Compatible starting with 4.0.0 beta 4 / Incompatible with 4.1.0 alpha 1 and greater)

Go to the upper right and select "Search this mod" - for a distinct word like "dependencies".

Since this question has now been asked and answered over 10 million times, we can no longer keep lengthening the thread by simply repeating the answer. It's more productive to teach people how to find the answer on their own.

terminator2k2

11-28-2011 05:13 AM

Quote:

Originally Posted by HondaStreetCult (Post 2272502)

Need help... I am trying to change the "The Following 10 Users Say Thank You to Mervin For This Useful Post: " to something else. Can anyone help me and tell me where i can do this?

go to the ACP -> Languages & Phrases -> Phrase Manager -> Phrase Type: Global -> Phrase: post_thanks_users_say

uninvited13th

11-28-2011 08:00 AM

Quote:

Originally Posted by Breakthecycle2 (Post 2272590)

edit xml..

Code:

<dependency dependencytype="vbulletin" minversion="4.0.0 beta 4" maxversion="4.1.99" />

ballbrk

11-30-2011 09:11 PM

Hi I made a small change in the file post_thanks.php , . I change ORDER BY post.dateline to ORDER BY post.postid.

This will increase the performance of the plugin .. as you can read in http://articles.digitalpoint.com/con...ze-vBulletin-4

ballbrk

12-01-2011 01:17 PM

If you want to get an extra performance in post thanks .. you need to edit the file functions_post_thanks.php that is in the Include directory. Search for "SELECT * and change to
"SELECT postid,userid,post_thanks.username,date.

with this change you will reduce the quantity of data that will flow from DB to Webserver and reduce the time :)

Hippy

12-01-2011 07:49 PM

Quote:

Originally Posted by ballbrk (Post 2273659)

can you be a little more specific on the code to change ..
there are a few SELECT * there

thanks for the info.

MaXimus

12-03-2011 06:34 AM

this mod hasn't been updated in ages :(

Gursimran

12-03-2011 07:52 AM

Hello, I am getting vBulletin Database Error in my vBulletin 4.1.8
I guess it is because of this mod, so please help

Code:

Database error in vBulletin 4.1.8:



Invalid SQL:



                       REPLACE INTO vb_search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)

                       VALUES (0, '66.249.67.241', 1, 'bolt', '', 'post.dateline', 'DESC', 0.01879, 1, '34343,34170,34099,34098,34001,32857,31791,30741,30690,30373,30364,30363,30295,29159,28855,27126,25771,24767,23328,22923,22699,16141,16140,7728,3268,3203,3005,2914', 1322860031, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:4255;s:4:\"bolt\";}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\";}}', 'f573a426109978edf2b2fd3a4f226f4d');

MySQL Error : Table '****_vb.vb_search' doesn't exist
Error Number : 1146
Request Date : Friday, December 2nd 2011 @ 02:07:11 PM
Error Date : Friday, December 2nd 2011 @ 02:07:11 PM
Script : http://www.*****.info/forum/post_tha...er_gave&u=4255
Referrer :
IP Address : ********
Username : Unregistered
Classname : vB_Database
MySQL Version :

ballbrk

12-03-2011 08:12 AM

Quote:

Originally Posted by Hippy (Post 2273787)

can you be a little more specific on the code to change ..
there are a few SELECT * there

thanks for the info.

Yes sorry :) ... the modification is in includes/function_post_thanks.php ... you can see two SELECT * in the function fetch_thanks . I made some test and reduce the time of those SQL from 0.17s to 0.07s :) .

ballbrk

12-03-2011 08:14 AM

Quote:

Originally Posted by Gursimran (Post 2274261)

Hello, I am getting vBulletin Database Error in my vBulletin 4.1.8
I guess it is because of this mod, so please help

Code:

Database error in vBulletin 4.1.8:



Invalid SQL:



                       REPLACE INTO vb_search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)

                       VALUES (0, '66.249.67.241', 1, 'bolt', '', 'post.dateline', 'DESC', 0.01879, 1, '34343,34170,34099,34098,34001,32857,31791,30741,30690,30373,30364,30363,30295,29159,28855,27126,25771,24767,23328,22923,22699,16141,16140,7728,3268,3203,3005,2914', 1322860031, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:4255;s:4:\"bolt\";}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\";}}', 'f573a426109978edf2b2fd3a4f226f4d');

The problem that the table vb_search don't exist... maybe you deleted or changed the name.

All times are GMT. The time now is 12:43 AM.

Page 202 of 382

202

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08139 seconds Memory Usage 1,758KB 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 (3)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: