Miscellaneous Hacks - Digital Point Spy

About
This is a Digg-style spy for seeing what's going on in your forum in realtime.

This is something I originally made about 4 years ago. Now that I rewrote it for vBulletin 4 (it also now uses the bundled YUI for animation), I decided to also wrap it up as a product package and release it for the world to use.

Installation

• Put the spy.php file in your forum folder.
• Put the digitalpoint_spy.js file in your clientscript folder.
• Install the product-digitalpoint_spy.xml product under AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product

You can see a live version in action here:
http://forums.digitalpoint.com/spy.php


1.1.0 Update

• Moved JavaScript to external file (works around template parsing bug with early versions of vBulletin 4.0.x).
• XML generation is done with vBulletin's XML Builder class (let it deal with weird characters).
• Switched JavaScript library to from YUI to jQuery (for an end user, it means better animations).
• Changed do=xml to do=feed (works around servers that are overly protective and think they are trying to be hacked and blocking the request).

[digitalpoint]

Originally Posted by dutchbb

Ok but I just need the old vb3 files , perhaps my developer can tweak them to work with the latest vb3?

They don't exist anymore, sorry. I don't have a vB3 site, so there was no point in keeping them.

[dutchbb]

Originally Posted by digitalpoint

They don't exist anymore, sorry. I don't have a vB3 site, so there was no point in keeping them.

Ok I understand.

Edit: found old backup of it and attached it for anyone interested. If you don't want them uploaded please contact so I can remove them.

[Mark.B]

In IE8, this seems to have all but the first row indented (compared to the first row).

Seems to be the same on DP's site so I don't think it's anything in my style.

[digitalpoint]

Can you post a screenshot by chance? Haven't had a Windows machine since about 1995.

[Mark.B]

Originally Posted by digitalpoint

Can you post a screenshot by chance? Haven't had a Windows machine since about 1995.

Sure.

Attachment 136762

[Seductor]

Hello, I was trying to not show what the admin is doing and to show only the new post and new threads actions.

Am I doing this right?

	if ($vbulletin->GPC['last'] > 0) $extra = 'AND spyid > ' . $vbulletin->GPC['last'] . ' AND forumid > 0';



// don't force to forums.*

	$events = $db->query_read_slave("
		SELECT spy.*, user.username, thread.title, thread.forumid, post.pagetext AS preview
		FROM " . TABLE_PREFIX . "digitalpoint_spy AS spy
			LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = spy.userid)
			LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = spy.threadid)
			LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = spy.postid)
		WHERE (thread.forumid IS NULL OR (thread.forumid IN ($forumids)$sql_subscribed) AND (action IN (1,2,3)))
			$extra
		ORDER BY dateline DESC
		LIMIT 25
	");

[clutchthese]

4.1.11 working. Thanks.

[sportsfroma2]

if my site used this of vbulletin's built-in "new posts" search feature, would it result lower resource usage?

[digitalpoint]

Originally Posted by sportsfroma2

if my site used this of vbulletin's built-in "new posts" search feature, would it result lower resource usage?

They are two unrelated functions.

[Taurus1]

Great mod thank you.

Is there any way to exclude certain forums? I have some RSS feeds that gets posted on my forum, and when these post I don't all of these posts to display on the spy page.

Oh, and is it perhaps possible to edit the green border line to a different color?

Thanks