vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - Display Unread Posts and New Reputation Comments (https://vborg.vbsupport.ru/showthread.php?t=168303)

Caddyman 03-24-2008 01:10 PM

i have this installed on my board talkdelaware.com and it works GREAT!

my users love it, now i just added news feeds. they want these dis-included from the new post search and the count it shows "X unread posts" in the welcome box.

i have successfully filtered out the right forums on a search by using the "&exclude=48,4,54,55,56,57,58,59,60,61,62,63,64,65 ,66\" on the end of get new.

is there a way to get the "X unread post" to be filtered as well?

now it will show like "20 unread posts" and when you click the search it will return nothing as the actual search is filtered.

does that make sense?
-Caddy

mamashid 03-24-2008 02:25 PM

HI there paul, i have used your hack for this in the past, I just upgraded it from the 3.6 to this I have 3.7.0 RC running on board, when I added it, it is now not showing in my welcome box, help?

Caddyman 03-24-2008 05:42 PM

ok i found this in the 3.6 thread for this mod. i want to exclude a userid from the new post counts. how do i do it with this mod?

Quote:

Originally Posted by aranthorn (Post 1316268)
Everyone keeps asking if they can exclude forums, well, that's a different table in vBulletin. What I did is remove a user. I my case this is an RSS bot. So here's what I did.
Original New Posts and Reputation (1) Plugin:
Code:

$repcount = array();
$postcount = array();
$show['pcount'] = $vbulletin->options['npr1'];
$show['rcount'] = $vbulletin->options['npr2'];

if ($vbulletin->userinfo['userid'])
{
        if ($show['pcount'])
        {
                $postcount = $vbulletin->db->query_first_slave("
                        SELECT COUNT(dateline) AS pcount
                        FROM ".TABLE_PREFIX."post
                        WHERE dateline > {$vbulletin->userinfo[lastvisit]}
                ");
        }
        if ($show['rcount'])
        {
                if ($vbulletin->userinfo['showreputation'])
                {
                        $repcount = $vbulletin->db->query_first_slave("
                                SELECT COUNT(dateline) AS rcount
                                FROM ".TABLE_PREFIX."reputation
                                WHERE userid = {$vbulletin->userinfo[userid]}
                                AND dateline > {$vbulletin->userinfo[lastrepcheck]}
                        ");
                }
        }

        if ($postcount['pcount'] == 0)
        {
                $vbulletin->userinfo['pcount'] = $vbphrase['npr_no_posts'];
        }
        else
        {
                if ($postcount['pcount'] == 1)
                {
                        $vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_single_post']);
                }
                else
                {
                        $vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_plural_post']); 
                }               
        }               

        if ($repcount['rcount'] == 0)
        {
                $vbulletin->userinfo['rcount'] = $vbphrase['npr_no_reputation'];
        }
        else
        {
                if ($repcount['rcount'] == 1)
                {
                        $vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_single_comment']);
                }
                else
                {
                        $vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_plural_comment']); 
                }               
        }               
}

Have a look at this bit:
Code:

        if ($show['pcount'])
        {
                $postcount = $vbulletin->db->query_first_slave("
                        SELECT COUNT(dateline) AS pcount
                        FROM ".TABLE_PREFIX."post
                        WHERE dateline > {$vbulletin->userinfo[lastvisit]}
                ");
        }

This is where you can manually tweak the query.
Code:

        if ($show['pcount'])
        {
                $postcount = $vbulletin->db->query_first_slave("
                        SELECT COUNT(dateline) AS pcount
                        FROM ".TABLE_PREFIX."post
                        WHERE dateline > {$vbulletin->userinfo[lastvisit]}
                        AND userid != 13476
                ");
        }

I added the bold text. The userid is my RSS poster bot userid. You can exclude any of the following by changing my "userid" to one on the list below and my "13476" to whatever floats your boat.

I don't recommend anyone do this unless you know what your doing!

I'm only showing you the query used and possibilities to tweak it and the only reason I'm doing that is because Paul M has stated he's not adding any features to this kick ass mod.

Here are the fields than can be played with:
postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid


Paul M ~ if you don't like what I've posted here, I totally understand and will delete the post. Just let me know.



please and thank you :)

DJ Matt4684 03-25-2008 01:47 AM

Edit: Nevermind, got it working again.

user02934123123 03-26-2008 08:07 AM

Is there any way to display the New Posts reading separately from the Welcome block? I very much like it there; but I'd also like to add it to various locations on custom forum pages -- e.g. we have a 'welcome page' that displays a quotation, and where I used the old Show New Posts hack to paste in the HTML code so that the reading would show.

How can I display this hack's readout elsewhere via HTML in templates?

DJ Matt4684 03-26-2008 09:31 AM

This works for me flawlessly, but on the vbadvanced page (homepage) it does not work. Is there anyway to fix this issue with vbadvanced?

Paul M 03-26-2008 10:01 PM

I think this has the path option, I cant check while on holiday.

mamashid 03-26-2008 11:34 PM

what about me paul??? ;)

mamashid 03-27-2008 01:54 AM

took me forever but i figured it out on my own, thanks though!

Forum Lover 03-27-2008 04:47 AM

Marked as Installed. :up:


All times are GMT. The time now is 04:48 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

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