Profile Enhancements - Activity Streams

Activity Streams 2.0
Tested with vBulletin 4.0.8, 4.1.0


This modification collects activity from the user and displays it in his profile. You can select how many streams, how many days it should look back and the length of the preview text. Activity Streams is based on my Central What's New Widget (Thread: https://vborg.vbsupport.ru/showthread.php?t=248165), but does not need the vBulletin Suite.


With v2.0.0 there is support for collecting streams from this:
- Blog (Suite)
- Blog comments (Suite)
- CMS Articles (Suite)
- CMS comments (Suite)
- vBExperience achievements
- vBExperience awards
- Group discussions
- Group messages
- Album Pictures
- Album Pictures comments
- Threads
- Posts
- Visitor Message
- Project Tools Issues
- iTrader Feedbacks


It can be easily expanded to display also data from Post Thanks, vBookie, Downloads, etc...


/***** Demo: *****\
http://www.vbaddict.net/member.php?1-Phalynx



/***** How to install this? *****\
- Upload the content of the folder "upload_via_ftp" to your server.
- Install the product xml as a plugin



Comments, suggestions, translations, bugs, etc... are very welcome! Support is only given to people who have clicked "Mark as Installed".

Main Support Site:
http://www.vbaddict.net


/***** History: *****\
2.0.0a, 29th December 2010:
- Fixed not showing tab

2.0.0, 28th December 2010:
- First public release

1.x:
- Releases used for own websites

[wEbAddEr]

Ok thanks wil wait for it

[Dr.osamA]

Excellent = 5 stars

installed +translated to Arabic

plzz be nice and add translation to 1st original post
thank you

[Britmovie]

Prob been said but profiles dont work and I get
---------------
Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1293729944 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN vb_cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
WHERE (node.contenttypeid = )
GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden HAVING COUNT(child.nodeid) > 0
ORDER by node.nodeleft;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN v' at line 3
Error Number : 1064
Request Date : Thursday, December 30th 2010 @ 11:25:44 AM
Error Date : Thursday, December 30th 2010 @ 11:25:44 AM
Script : http://www.britmovie.net/britforum/m...on=getinfo&u=1
Referrer : http://www.britmovie.net/britforum/xperience.php
IP Address : 86.29.56.215
Username : Britmovie
Classname : vB_Database
MySQL Version : 5.1.52
==============================

[NNJJ]

thanks for hack and for arabic translation

[NNJJ]

and i have error as well
Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1293732849 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM cms_node AS node
LEFT JOIN cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
WHERE (node.contenttypeid = )
GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden HAVING COUNT(child.nodeid) > 0
ORDER by node.nodeleft;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END) AS publish_count
FROM cms_node AS node
LEFT JOIN cm' at line 3
Error Number : 1064
Request Date : Thursday, December 30th 2010 @ 12:14:09 PM
Error Date : Thursday, December 30th 2010 @ 12:14:09 PM
Script : http://www.colorssky.com/vb/member.php?3-Jenan
Referrer : http://www.colorssky.com/vb/forum.php
IP Address :
Username :

Classname : vB_Database
MySQL Version : 5.0.91-community-log

[Phalynx]

Originally Posted by Dr.osamA

Excellent = 5 stars

installed +translated to Arabic

plzz be nice and add translation to 1st original post
thank you

Thanks for sharing.

Originally Posted by Britmovie

Prob been said but profiles dont work and I get
---------------
Database error in vBulletin 4.1.0:

Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1293729944 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN vb_cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
WHERE (node.contenttypeid = )
GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden HAVING COUNT(child.nodeid) > 0
ORDER by node.nodeleft;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN v' at line 3
Error Number : 1064
Request Date : Thursday, December 30th 2010 @ 11:25:44 AM
Error Date : Thursday, December 30th 2010 @ 11:25:44 AM
Script : http://www.britmovie.net/britforum/m...on=getinfo&u=1
Referrer : http://www.britmovie.net/britforum/xperience.php
IP Address : 86.29.56.215
Username : Britmovie
Classname : vB_Database
MySQL Version : 5.1.52
==============================

This is a known issue by disabled CMS, just delete the files:
\sas\streams\cms.php
\sas\streams\cms_comment.php

[InTeNsE-HuMoR]

Does this mod respect user permissions (like private forums)?

It is showing that I posted in the staff forum, will non-staff members see that?

[Phalynx]

Yes. It's obeying forum permissions.

[CRDeveloper]

I'm getting this:

Database error in vBulletin 4.1.0:

Invalid SQL:

            SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername,
                thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
                forum.forumid, forum.title_clean as forumtitle,
                post.pagetext AS message, post.allowsmilie, post.postid,
                user.userid, user.username, thread.lastposter AS lastpostername
            FROM vbulletin_thread AS thread
            INNER JOIN vbulletin_forum AS forum ON(forum.forumid = thread.forumid)
            LEFT JOIN vbulletin_post AS post ON (post.postid = thread.firstpostid)
            LEFT JOIN vbulletin_user AS user ON (thread.postuserid = user.userid)
            WHERE 1=1
                 AND (thread.forumid IN(3,71,157,158,162,163,164,165,45,135,44,46,47,48,78,93,105,145,147,138,139,148,140,141,142,143,144,146,23,9,10,16,17,50,51,52,107,29,30,31,32,33,34,35,36,37,38,94,39,40,41,42,43,26,136,19,20,21,22,149,55,92,102,103,96,112,76,49,81,83,86,119,120,121,127,128,129,130,87,88,89,90,91,95,97,98,116,117,122,125,126,24,14,137,15,150,151,152,153,154,155,156,65,66,67,54,118,131,160,25,13,77,57,59,58,60,61,62,63,82,84,70,64,68,80,99,100,104,108,109,111,114,124,132,161,27,11,28,75,159,73,85,74,53,56,69,101,106,110,113,123)
                AND thread.visible = 1
                AND post.visible = 1
                AND open <> 10
                AND thread.dateline > 1292009442
                
                
                
                AND thread.postuserid IN (27350)
            ORDER BY thread.dateline DESC
            LIMIT 0,1;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY thread.dateline DESC
            LIMIT 0,1' at line 20
Error Number  : 1064
Request Date  : Friday, December 31st 2010 @ 01:30:42 PM
Error Date    : Friday, December 31st 2010 @ 01:30:42 PM
Script        : http://www.*********.com/forum/member.php/27350
Referrer      : http://www.*********.com/forum/showthread.php/*********
IP Address    : xxx.xxx.xxx.xxx
Username      : *********
Classname     : vB_Database
MySQL Version : 5.0.91-community

[NNJJ]

Originally Posted by Phalynx

Thanks for sharing.


This is a known issue by disabled CMS, just delete the files:
\sas\streams\cms.php
\sas\streams\cms_comment.php

if i do this i got this error

Fatal error: Call to undefined function cms_old() in /home/colors/public_html/vb/sas/includes/member_complete.php on line 46