vb.org Archive - Add-On Releases - vBISpy - AJAX real-time feed of new posts/threads

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

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

- - Add-On Releases - vBISpy - AJAX real-time feed of new posts/threads (https://vborg.vbsupport.ru/showthread.php?t=125947)

I would love this for vb4 as well :)

Quote:

Originally Posted by MPDev (Post 1959452)

They are using vBISpy in an iframe.

http://www.city-data.com/forum/vaispy.php

I did something similiar on one of my sites; but without the iframe - all you need to do is modify the html to suit your page and then incorporate the javascript.

MPDev,
Can you post some guide on how to do that?

They have a feature that will auto freeze after some timeout and you will have to click to refresh. I guess that's done to reduce server load for idle users.

Would love to implement this in the iframe method as shown on that site.

I don't really have a guide since there are so many ways people have asked to do this. All you have to do is edit the html to suit your needs (depending on where you want it - for example, in an iframe would require just changing the list to a shorter list and getting rid of the header and footer (but not the headerinclude).

thanksss works perfect on 3.8.4

MPDev has given me permission (via PM) to port this to vB4 - I will try to get it released by next week.

please integrate 'ignored users' into ispy4!
:up:

Quote:

Originally Posted by SecondV (Post 1961902)

MPDev has given me permission (via PM) to port this to vB4 - I will try to get it released by next week.

Questions.

1. How to shorten the preview length?

2. Would all of vaispy.php be dumped into an Ultimate Side Column to make a collapsible sidebar?

Thanks!!!

Just did a fresh install on 3.8.5, and this plugin, and it simply doesn't load. The page loads, but it is not being ajaxy .. so to speak. It's just sitting htere, not updating, a manual refresh shows older threads too, kinda weird. :/

This is great and was so easy to install thanks for the great hack!

I used this on vB 3.7.3 but decided to simplify it and embed it as an iframe on SHOWTHREAD. I used a meta refresh in the head instead of ajax so all you need is one php file.

Features:

Lists 20 latest posts. Scrolls side to side.
112 pixels tall.
Visited titles turn purple.
Hover for forum name, views and replies.

Code:

<?php

//################################################################################//

//         MOD NAME: VBISpy                                                      #//

//################################################################################//

//      DESCRIPTION: This modification for vBulletin adds a "live" scrolling     #//

//                   update of new posts to the forum                            #//

//################################################################################//

//               BY: MPDev                                                       #//

//             DATE: 9.26.06                                                     #//

//          VERSION: 1.0.12                                                      #//

//################################################################################//



// ####################### SET PHP ENVIRONMENT ###########################

error_reporting(E_ALL & ~E_NOTICE);



// #################### DEFINE IMPORTANT CONSTANTS #######################

define('THIS_SCRIPT', 'vaispy');



// ################### PRE-CACHE TEMPLATES AND DATA ######################

// get special phrase groups

$phrasegroups = array();



// get special data templates from the datastore

$specialtemplates = array();



// pre-cache templates used by all actions

$globaltemplates = array();



// pre-cache templates used by specific actions

$actiontemplates = array();



// ######################### REQUIRE BACK-END ############################

require_once('./global.php');



// #########################   CONFIG VARS    ############################

// The number of days to scan the table for .. (86400 represents the number of seconds in 24 hours)

$daysprune = 1;



// Do not list these forums even if they have permissions (test categories, etc)

$blockforums = "";



// #########################   CONFIG VARS    ############################



$forumperms = array();

$lastpostid = (int)$_REQUEST['last'];

$subscribe = (int)$_REQUEST['subscribe'];



foreach($vbulletin->forumcache AS $forum) {

    $forumid = $forum['forumid'];

    $forumperms =& $vbulletin->userinfo['forumpermissions']["$forumid"];



    if (!isset($vbulletin->forumcache["$forumid"]) OR !($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']) OR !($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewothers']) OR !verify_forum_password($forumid, $vbulletin->forumcache["$forumid"]['password'], false))

    {

        $blockforums .= ','.$forum['forumid'];

    }

}

unset($forum);



$datecut = "AND thread.lastpost >= " . (TIMENOW - ($daysprune * 86400));

$prefetched = null;



############################################################################

// Get Threads I've Posted In

require_once(DIR . '/includes/functions_forumdisplay.php');

$result = $db->query_read("

    SELECT threadid

    FROM " . TABLE_PREFIX . "thread as thread

    WHERE thread.forumid NOT IN (0$blockforums) and

        thread.visible = 1 and

        thread.open <> 10 and

        thread.lastpostid > $lastpostid

        $datecut

");



$idsArray = array();

while ($id = $db->fetch_array($result))

{

    $idsArray[] = $id['threadid'];

}



$dotthreads = fetch_dot_threads_array(implode(',', $idsArray));

############################################################################

// Get Threads



// Do not set to more than 20 unless you know how to modify the html at the bottom of the page (and at line 291)

$limitq = ( isset($_REQUEST['do']) ? "20" : "0,20" );



$getthreads = $db->query_read("

      SELECT thread.forumid,

             thread.firstpostid,

             thread.lastpost,

             thread.lastposter,

             thread.lastpostid,

             thread.replycount,

             thread.threadid,

             thread.title,

             thread.open,

             thread.views,

             post.pagetext AS preview,

             post.userid AS lastpuserid

        FROM " . TABLE_PREFIX . "thread AS thread

             LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

             LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.lastpostid)

       WHERE open <> 10

         $datecut

         AND thread.forumid NOT IN (0$blockforums)

         AND thread.visible = '1'

         AND thread.lastpostid > $lastpostid

         AND post.visible = 1

         AND deletionlog.primaryid IS NULL

       ORDER BY thread.lastpost DESC LIMIT $limitq

");





$row = $highestid = 1;

$rowcolor = "alt2";



while($thread = $db->fetch_array($getthreads)) {

    



    $thread['title'] = htmlspecialchars_uni(fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 85)));

    $thread['date'] = vbdate($vbulletin->options['dateformat'], $thread['lastpost'], 1);

    $thread['time'] = vbdate($vbulletin->options['timeformat'], $thread['lastpost']);



   /* Get rid of html and bbcode first

    $thread['preview'] = strip_tags(strip_bbcode($thread['preview'], true, true));

    $thread['preview'] = htmlspecialchars_uni(fetch_trimmed_title($thread['preview'], 200));

    $thread['preview'] = fetch_censored_text(fetch_word_wrapped_string($thread['preview'], 20));*/



    $thread['replycount'] = vb_number_format($thread['replycount']);

    $thread['views'] = vb_number_format($thread['views']);



    $tforumid = $thread['forumid'];

    $thread['forum'] = htmlspecialchars_uni($vbulletin->forumcache["$tforumid"]['title']);





    // Statusicon

    // show dot folder?

    if ($vbulletin->userinfo['userid'] AND $vbulletin->options['showdots'] AND $dotthreads["$thread[threadid]"])

    {

        $thread['statusicon'] .= '_dot';

        $thread['dot_count'] = $dotthreads["$thread[threadid]"]['count'];

        $thread['dot_lastpost'] = $dotthreads["$thread[threadid]"]['lastpost'];

    }



    // show hot folder?

    if ($vbulletin->options['usehotthreads'] AND (($thread['replycount'] >= $vbulletin->options['hotnumberposts'] AND $vbulletin->options['hotnumberposts'] > 0) OR ($thread['views'] >= $vbulletin->options['hotnumberviews'] AND $vbulletin->options['hotnumberviews'] > 0)))

    {

        $thread['statusicon'] .= '_hot';

    }



    // show locked folder?

    if (!$thread['open'])

    {

        $thread['statusicon'] .= '_lock';

    }



    $thread['statusicon'] = $stylevar['imgdir_statusicon'] . '/thread' . $thread['statusicon'] . '.gif';



 if ( $_REQUEST['do'] == "xml" )

    {

$output .= <<<VAPRINT

<event>

<id>{$thread['lastpostid']}</id>

<what>$etype</what>

<when>{$thread['date']} {$thread['time']}</when>

<title>{$thread['title']}</title>

<preview>{$thread['preview']}</preview>

<poster>{$thread['lastposter']}</poster>

<threadid>{$thread['threadid']}</threadid>

<postid>{$thread['lastpostid']}</postid>

<lastpost>{$thread['lastpost']}</lastpost>

<userid>{$thread['lastpuserid']}</userid>

<forumid>{$thread['forumid']}</forumid>

<forumname>{$thread['forum']}</forumname>

<views>{$thread['views']}</views>

<replies>{$thread['replycount']}</replies>

<statusicon>{$thread['statusicon']}</statusicon>

</event>

VAPRINT;

    }

    else

    {   

        /*$rowcolor = ( $rowcolor == "alt1" ? "alt2" : "alt1" );*/



        $where = $clip = $poster_clip = $poster = null;



        if ( stristr($etype, "thread") )

        {

            $post_url = "showthread.php?t={$thread['threadid']}";

        }

        else

        {

            $post_url = "showthread.php?p={$thread['lastpostid']}#post{$thread['lastpostid']}";

        }



        if( !$thread['title'] )

        {

            $clip = "<strong>Unknown</strong>";

        }

        else

        {

            $clip = "<strong><img src=\"{$thread['statusicon']}\" alt=\"\" /><a target=\"_parent\" href=\"{$post_url}\" >{$thread['title']}</a></strong>";

        }



        



        //$clip .= " ({$thread['views']} views, {$thread['replycount']} replies)";



        if ( $thread['lastpuserid'] )

        {

            $poster_clip = "By <strong>{$thread['lastposter']}</strong>";

        }



        $poster_clip .= " {$thread['date']} {$thread['time']}";



        if ( $thread['forum'] )

        {

            $where .= "In {$thread['forum']}";

            $where .= " ({$thread['views']} views, {$thread['replycount']} replies)";



        }

        else

        {

            $where = "";

        }



        

       

$prefetched .= <<<VAPRINT



<td><div class = "alt1"  style="vertical-align:top;"> <div class="smallfont" style="padding: 3px 6px; 

vertical-align:top;height:35px;" title = "$where">$clip</div></div><div class= "alt2"  style="width:298px;vertical-align:bottom;"><div class ="smallfont" style="padding: 3px 6px;vertical-align:bottom;height:100%;">$poster_clip</div></div></td>\n

VAPRINT;

        

     



        $row++;

        if ( $thread['lastpostid'] > $highestid )

        {

            $highestid = $thread['lastpostid'];

        }

    }



}





// memory saving

unset($thread);

$db->free_result($getthreads);



if ( $_REQUEST['do'] == "xml" )

{

    header( 'Content-Type: text/xml' . ($stylevar['charset'] != '' ? '; charset=' .  $stylevar['charset'] : '') );

    echo '<?xml version="1.0" encoding="' . $stylevar['charset'] . '"?>' . "\r\n";



    if ( $output )

    {

        echo "<events>$output</events>";

    }

    else

    {

        echo "<events />";

    }



    exit;

}



/*$navbits = array();

$navbits[$parent] = 'iSpy';

$navbits = construct_navbits($navbits);



eval('$navbar = "' . fetch_template('navbar') . '";');

$navbar = process_replacement_vars($navbar);*/



eval('$headinclude = "' . fetch_template('headinclude') . '";');

$headinclude = process_replacement_vars($headinclude);



/*eval('$footer = "' . fetch_template('footer') . '";');

$footer = process_replacement_vars($footer);*/



echo<<<VAPRINT

$stylevar[htmldoctype]

<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">

<head>

<META HTTP-EQUIV="refresh" CONTENT="120;url=/forum/vaispy.php"></META>

$headinclude



<style type="text/css">

a:link {color:#22229C;}    /* unvisited link */

a:visited {color:#8B008B;} /* visited link */

</style>



<title>iSpy</title>

</head>

<body style="margin:0px;" >

$output



<table class = "tborder" cellpadding="6" cellspacing="1" style="border-bottom-width:0px;" width="100%" align="center">

<thead>

        <tr>

                <td class="tcat">

                        

                        Latest Twenty Posts

                </td>

        </tr>



</thead>

</table>



<div class = "tborder"   style="overflow:auto; border-top-width:0px;" width="100%">

<table  class = "tborder" style="border-top-width:0px; border-left-width:0px; border-right-width:0px; border-bottom-width:1px;" cellspacing="1"  cellpadding ="0"  align="left" >

        <tr>

                      $prefetched

        </tr>

</table>

</div>

VAPRINT;



echo $output;

?>

Just paste it in as vaispy.php under forum.

To change refresh rate change this to the number of seconds you want:

<META HTTP-EQUIV="refresh" CONTENT="120;url=/forum/vaispy.php"></META>

To change the number of posts shown change these lines:

$limitq = ( isset($_REQUEST['do']) ? "20" : "0,20" );

and

<td class="tcat">

Latest Twenty Posts
</td>

To embed it as an iframe, paste this under $navbar in SHOWTHREAD template:

HTML Code:

<if condition="$show['member']">

<iframe src ="/forum/vaispy.php" width="100%" height ="112px" frameborder="0"  >

  <p>Your browser does not support iframes.</p>

</iframe>

</if><br /><br />

I've left in some odds and ends that could probably be left out, specifically

/*$navbits =.....*/

/*eval('$footer =......*/

One last thing: One of our members was very suspicious when his browser was loading a file called vaispy!

I get an error on line 254

That's exactly as I have it on my forum and it works. What does the error text say and do you know which is line 254?

EDIT: Is the error in vaispy or showthread? If in showthread do you already have the original version of vaispy working? If so rename the original one "vaispy_original.php"

EDIT 2: I put this in notepad and found line 254:

header( 'Content-Type: text/xml' . ($stylevar['charset'] != '' ? '; charset=' . $stylevar['charset'] : '') );

Maybe a real coder can help.

Quote:

Originally Posted by nerbert (Post 2042870)

There are no errors in the file.

I edited my version of vaispy to fix some things that one of my forum members pointed out. If you have already copied the file make the following edits:

find:

<div class = "tborder" style="overflow:auto; border-top-width:0px;" width="100%;">

and remove the ";"

find:

<body style="margin:0px;" onload="spyinit();">

and remove "onload="spyinit();""

The latter may cause problems in older versions of IE

I use this with 3.8.5 and it works great. However, I have an issue with a wiki mod I have in place.

In a nutshell, I need to add "&do=comments" to the showthread link that is generated. I edited the script, changing the $post_url definition appropriately. This works for the initial "static" entries that show up when the script is first loaded, but the subsequent entries that load from the top don't seem to be generated from the $post_url variable.

I'm at a loss as to where to fix this.

EDIT: Just found where to edit it in va_spy.js :)

<div class = "tborder" style="overflow:auto; border-top-width:0px;" width="100%;">
and remove the ";"

The ; is optional, and doens't fix an issue, it's non exist.

It works with and without the last ;

style="this:that"
or
style="this:that;"

the ; is there by default, and without it, is just more short hand.

the ; must actually be there, if you add more ..

style="this:that; another:one;"
is the same as
style="this:that; another:one"

:) Just saying :)

It doesn't cause bugs, nor fix them.

Just installed this mod in 3.8.4 and it worked first time. Simplest install ever. Thanks OP very nice mod.

Working on 3.8.6

http://www.dieselbombers.com/vaispy.php

I added my chatroom and some google ads

Anyone know how to make it parse smilies and show avatars?

Same here, works great on 3.8.6
Have been using it for a very long time. Can't go without it....lol

I have one question though, it does not seem to work with LiteSpeed. Does anyone have a fix for that. Thanks!

Is there any kindhearted person out there that can help me to get this to work with LiteSpeed?? Please!!

Does anyone know what the issue is with Litespeed servers?

Also I notice that forums with ampersand (&) in the title show up with the HTML & code instead.

Diesel, are you on VPS or Dedicated, did you notice any increase in server load with the live feed? Thanks.

Quote:

Originally Posted by DieselMinded (Post 2069754)

Working on 3.8.6

http://www.dieselbombers.com/vaispy.php

I added my chatroom and some google ads

Anyone know how to make it parse smilies and show avatars?

Does anybody know how to get this to stop refreshing after a certain period for idle users, to try and reduce server load?

You could probably put a META REFRESH tag in the header to forward the user to the main forum index after 5 minutes or so.

Code:

<meta http-equiv="refresh" content="300;url=http://www.yoursite.com/forums/" />

300 is 5 minutes in seconds.

Not work :(

Quote:

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: navbar in [path]/includes/functions.php on line 4007

Parse error: syntax error, unexpected T_STRING in /var/www/forumkiev/data/www/forum.kiev.ua/vaispy.php(334) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: headinclude in [path]/includes/functions.php on line 4007

Parse error: syntax error, unexpected T_STRING in /var/www/sitecom/data/www/site.com/vaispy.php(337) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: footer in [path]/includes/functions.php on line 4007

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/sitecom/data/www/site.com/vaispy.php(340) : eval()'d code on line 1

Quote:

Originally Posted by SammoLove (Post 2124478)

Not work :(

You have vBulletin 4.x, this mod is only for 3.x... There is a similar mod for VB4 by a different author... Search for "spy" in VB4 mods...

here: https://vborg.vbsupport.ru/showthread.php?t=243429

Quote:

Originally Posted by BirdOPrey5 (Post 2123858)

You could probably put a META REFRESH tag in the header to forward the user to the main forum index after 5 minutes or so.

Code:

<meta http-equiv="refresh" content="300;url=http://www.yoursite.com/forums/" />

300 is 5 minutes in seconds.

Thanks, I'll give it a try. :up:

Anyone want to tell me how to shove this into a Ultimate Side Column? :D

Quote:

Originally Posted by BirdOPrey5 (Post 2122254)

Does anyone know what the issue is with Litespeed servers?

I've just changed to a hosting company that is using litespeed and this hack is working fine on 3.8.5

Really? I installed it fine and the page displays but I don't get any new/live updates of new threads. :( You mind if I ask what host?

Quote:

Originally Posted by BirdOPrey5 (Post 2128863)

Really? I installed it fine and the page displays but I don't get any new/live updates of new threads. :( You mind if I ask what host?

Yip, working 100%. I'm with urljet.com

Quote:

Originally Posted by viper357 (Post 2128914)

Yip, working 100%. I'm with urljet.com

That's my host too. I guess I should try it again. Thanks.

Quote:

Originally Posted by BirdOPrey5 (Post 2128936)

That's my host too. I guess I should try it again. Thanks.

I've been watching it on your site and it's working fine for me.

Really? I have to try another computer then- for me it doesn't update at all and it doesn't even show my newest posts when I refresh, it's like 20 minutes behind... But thank you I'll keep playing with this.

Ok, something weird going on with yours, when viewing your board as a guest it seems to work fine, it updates and the faded posts are there at the bottom but it does seem to be a bit behind by about 2 hours I think it was, but then I registered and viewed it again and it didn't work at all, just keeps showing the same posts. Maybe a conflict with another add-on?

Thanks, I'll check as a guest...I registered on your site to see it and it was indeed working fine for me so it's not my browser.

One thing different through... when I look up what type of server you are running at:
http://whois.domaintools.com/ for your domain, under server stats it lists:
Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

For my domain (http://whois.domaintools.com/juot.net) it lists simply:
litespeed

So maybe our servers are configured differently.

I found the conflict, it was: Cyb Tic-Tac-Toe.

I have no clue why this would cause a problem honestly but when disabled vbISpy works as expected.

My solution was to modify the main Tic Tac Toe "GS" plugin and edit the code, replace the first line (the if statement) with this:

PHP Code:


		
			
if ($vbulletin->options['cybttt_enable'] AND THIS_SCRIPT != 'vaispy')

Now it's working for registered users. :up: Thank you viper!

-Edited Jan 15, 2011- I had the wrong code posted before.

Thanks for the update Joe. Working well with 3.8.6

Quote:

Originally Posted by BirdOPrey5 (Post 2129207)

One thing different through... when I look up what type of server you are running at:
http://whois.domaintools.com/ for your domain, under server stats it lists:
Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

For my domain (http://whois.domaintools.com/juot.net) it lists simply:
litespeed

So maybe our servers are configured differently.

That's odd, although in my admincp it says Litespeed instead of Apache, they must be conning me :p oh well, at least my site is working and it's fast I'm not going to complain, lol. ;)

Anyway, glad you figured it out. :up:

Now it's your turn to help me again please :p

Quote:

Originally Posted by BirdOPrey5 (Post 2123858)

You could probably put a META REFRESH tag in the header to forward the user to the main forum index after 5 minutes or so.

Code:

<meta http-equiv="refresh" content="300;url=http://www.yoursite.com/forums/" />

300 is 5 minutes in seconds.

When you say "header" do you mean the actual main forum header? If so then does that mean that any page a member is on will forward the user to index or whatever, after the set time period?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03540 seconds Memory Usage 1,901KB 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 (4)bbcode_code_printable (1)bbcode_html_printable (1)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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: