vb.org Archive - New Posting Features - [hide] hack incl post thank you "addon"

Yes it is.. a huge difference :D
if you thanked this hack won't do a db query if you (as you have it) can thank each post and not only the first one.
but in your case that won't do somehow.
so replace your fetch hide tag plugin by this code:

PHP Code:


		
			
if ($this->registry->options['sid_hide_active'] == '1' AND stristr($post['message'],'[hide]')){
            global $vbulletin, $vboptions, $bbuserinfo, $db, $threadid, $hide_call, $postid;
            $bbuserinfo = $this->registry->userinfo;
            $post = $this->post;
            $hide_read = false;
            $hide_img_set = 0;
            $hide_replied = '';
            $hide_thanked = '';
            $hide_stop = 0;
            if (!empty($this->registry->options['sid_hide_notforum'])){
                $sid_hide_forum_stop = explode(",",$this->registry->options['sid_hide_notforum']);
                if(in_array($thread['forumid'],$sid_hide_forum_stop)){
                    $post['message'] = preg_replace('/\\[hide\\](.*)\\[\/hide\\]/siU', '\\1', $post['message']);
                    $hide_stop = 1;
                }
            }
            if($post['userid'] == $bbuserinfo['userid'] AND $hide_stop == 0){
                $post['message'] = preg_replace('/\\[hide\\](.*)\\[\/hide\\]/siU', '<fieldset><legend><span class="highlight">'.$vbphrase[sid_hide_post_own].'</span></legend>\\1</fieldset>', $post['message']);
                $hide_stop = 1;
            }
            if ($hide_stop != 1){
                if ($this->registry->options['sid_hide_showadmin'] AND $bbuserinfo[usergroupid]==6){
                    $hide_read = true;
                }elseif ($this->registry->options['sid_hide_showmod'] AND can_moderate($thread['forumid'])){
                    $hide_read = true;
                }elseif (!empty($this->registry->options['sid_hide_showusergroup'])){
                    $hide_groups_see = explode(",",$this->registry->options['sid_hide_showusergroup']);
                    if (in_array($bbuserinfo['usergroupid'], $hide_groups_see)){
                        $hide_read = true;
                    }
                }
                if ($vbulletin->options['sid_hide_showthanked'] AND $hide_read==false){
                    $hide_img_set = $hide_img_set + 1;
                    if($vbulletin->options['post_thanks_forum_first_all'] == 1){
                        $hide_thanked = $db->query_first("SELECT userid FROM ". TABLE_PREFIX ."post_thanks WHERE postid='$threadinfo[firstpostid]' AND userid='$bbuserinfo[userid]'");
                        if($hide_thanked !=''){
                            $hide_read = true;
                        }
                    } elseif (!empty($vbulletin->options['post_thanks_forum_first'])){
                        $post_thanks_only_first = explode("|",$vbulletin->options['post_thanks_forum_first']);
                        if (in_array($threadinfo['forumid'], $post_thanks_only_first)){
                            $hide_thanked = $db->query_first("SELECT userid FROM ". TABLE_PREFIX ."post_thanks WHERE postid='$threadinfo[firstpostid]' AND userid='$bbuserinfo[userid]'");
                            if($hide_thanked !=''){
                                $hide_read = true;
                            }
                        }else{
                            $hide_thanked = $db->query_first("SELECT userid FROM ". TABLE_PREFIX ."post_thanks WHERE postid='$post[postid]' AND userid='$bbuserinfo[userid]'");
                            if($hide_thanked !=''){
                                $hide_read = true;
                            }
                        }
                    } else{
                        $hide_thanked = $db->query_first("SELECT userid FROM ". TABLE_PREFIX ."post_thanks WHERE postid='$post[postid]' AND userid='$bbuserinfo[userid]'");
                        if($hide_thanked !=''){
                            $hide_read = true;
                        }
                    }
                }
                if ($this->registry->options['sid_hide_showposted'] AND $hide_read==false){
                    $hide_img_set = $hide_img_set + 2 ;
                    $hide_replied = $db->query("SELECT COUNT(postid) AS count FROM ". TABLE_PREFIX . "post WHERE userid='$bbuserinfo[userid]' AND visible = 1 AND threadid='$post[threadid]'");
                    $myreplies = 0;
                    if($db->num_rows($hide_replied)){
                        while ($h_post = $db->fetch_array($hide_replied)){
                            $myreplies += $h_post['count'];
                        }
                        $myreplies = vb_number_format($myreplies);
                    }
                    if($myreplies > 0){
                        $hide_read['userid'] = true;
                    }
                }
                if (!$hide_call){
                    $hide_call =$post['postid'];
                } else {
                    $hide_call .=",".$post['postid'];
                }
                if($hide_img_set == 3){
                    $hide_img = $vbphrase[sid_hide_img_pot];
                } elseif ($hide_img_set == 2){
                    $hide_img = $vbphrase[sid_hide_img_post];
                } elseif ($hide_img_set == 1){
                    $hide_img = $vbphrase[sid_hide_img_thank];
                } else {
                    $hide_img = $vbphrase[sid_hide_img_sorry];
                }
                if(!$bbuserinfo[userid]){
                    $hide_read = false;
                }
                if ($hide_read == true){
                    $post['message'] = preg_replace('/\\[hide\\](.*)\\[\/hide\\]/siU', '<fieldset><legend><span class="highlight">'.$vbphrase[sid_hide_post_show].'</span></legend>\\1</fieldset>', $post['message']);
                } else {
                    eval('$hide_fetch = "' . fetch_template('sid_hide_noaccess') . '";');
                    $post['message'] = preg_replace('/\\[hide\\](.*)\\[\/hide\\]/siU', $hide_fetch, $post['message']);
                }
            }
        }

that'll add an own db query for thanked posts and is not using the original array.

This one will surely work.

(I hat to have unnecessary querys, but I see no other chance right now to get this to work in your forums.)

'sid

ps don't forget to delete the debug plugin! that's causing a lot of querys too :D

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_code_printable (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.02508 seconds
Memory Usage 1,847KB
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_code_printable
(1)bbcode_php_printable
(2)bbcode_quote_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)pagenav
(1)pagenav_curpage
(4)pagenav_pagelink
(3)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:

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