return $this->_getDb()->fetchAssoc('
SELECT spy.*, user.username, thread.title, thread.node_id, node.title as forum_title, post.message
FROM dp_spy AS spy
LEFT JOIN xf_user AS user ON (user.user_id = spy.user_id)
LEFT JOIN xf_thread AS thread ON (thread.thread_id = spy.thread_id)
LEFT JOIN xf_post AS post ON (post.post_id = spy.post_id)
LEFT JOIN xf_node AS node ON (node.node_id = thread.node_id)
WHERE (thread.node_id IS NULL OR thread.node_id IN (' . implode(',', $viewableNodes) . '))
AND spy.action IN ("' . implode('","', $actions) . '")
' . ($last > 0 ? 'AND spy_id > ' . $last : '') . '
ORDER BY date DESC
LIMIT 25
');
return $this->_getDb()->fetchAssoc('
SELECT spy.*, user.username, thread.title, thread.node_id, node.title as forum_title, post.message
FROM dp_spy AS spy
LEFT JOIN xf_user AS user ON (user.user_id = spy.user_id)
LEFT JOIN xf_thread AS thread ON (thread.thread_id = spy.thread_id)
LEFT JOIN xf_post AS post ON (post.post_id = spy.post_id)
LEFT JOIN xf_node AS node ON (node.node_id = thread.node_id)
WHERE spy.action IN ("' . implode('","', $actions) . '")
' . ($last > 0 ? 'AND spy_id > ' . $last : '') . '
ORDER BY date DESC
LIMIT 25
');
yes, all feed posts are posted by a registered account.Do the incoming RSS "threads" have an author? I mean it kind of makes sense to not have an author since there really isn't one...
I notice on your site it's loading this URL: http://windows2008forum.com/spy//feed?last=0&r=0.7457339414395392I've tried this on 2 sites both running 1.1 and it doesn't work. Table is there, but, there is no data in it. JS on the page works and no errors in server log on the server or in xenforo admin.
See it at http://windows2008forum.com/spy/
If nothing is getting in the table, then it's not picking up the events (obviously)... Any possibility you have listeners disabled in your config.php file?I've tried this on 2 sites both running 1.1 and it doesn't work. Table is there, but, there is no data in it. JS on the page works and no errors in server log on the server or in xenforo admin.
See it at http://windows2008forum.com/spy/
Not disabled. I tried an uninstall and reinstall and still no data in the db.If nothing is getting in the table, then it's not picking up the events (obviously)... Any possibility you have listeners disabled in your config.php file?
// $contents .= '<li><a href="' . XenForo_Link::buildPublicLink('spy') . '">' . new XenForo_Phrase('spy') . '</a></li>';
Thanks but instead of removing it, I just changed the name of spy to 'Who's Posting?' through phrases, then put a conditional in the spy template to prevent guests and regular members from viewing, then put a notice that only logged-in VIP members and above can view. This is a great feature to add for special vip or paid members-only. Thanks alot man!The easiest way would be to open the DigitalPointSpy/Listener/TemplateHook.php file and comment out this line like so:
PHP:// $contents .= '<li><a href="' . XenForo_Link::buildPublicLink('spy') . '">' . new XenForo_Phrase('spy') . '</a></li>';
We use essential cookies to make this site work, and optional cookies to enhance your experience.