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

[aaphandana]

I got this error. Can you help?

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 < 1293840724 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' at line 3
Error Number  : 1064
Request Date  : Saturday, January 1st 2011 @ 07:12:04 AM
Error Date    : Saturday, January 1st 2011 @ 07:12:04 AM
Script        : http://www.xxx.com/forum/member.php?action=getinfo&u=844
Referrer      : http://www.xxx.com/forum/xxx/2601-title-member.html
IP Address    : xxx
Username      : xxxx
Classname     : vB_Database
MySQL Version : 5.0.91-community

[pete_brady]

Originally Posted by NNJJ

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

delete the files, not rename them

[CRDeveloper]

Any update soon?

[NNJJ]

cool

thanks

[BlackThorn]

Phalynx thanks really great hack but looking for 3.8.x however I hadn't see yet.

[Phalynx]

That version is still in work.

[BlackThorn]

Thank you

Edit: That doesn't work on vB3.8.x version. But working great on 4.1.x.

[Bouncer222]

Getting error, using latest vb suite.

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 < 1294433638 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  : Friday, January 7th 2011 @ 02:53:58 PM
Error Date    : Friday, January 7th 2011 @ 02:53:58 PM
Script        : http://www.fragtoss.com/member.php?action=getinfo&u=77
Referrer      : http://www.fragtoss.com/forum.php
IP Address    : 96.250.230.245
Username      : Bouncer
Classname     : vB_Database
MySQL Version : 5.1.52

[Phalynx]

Please follow this instructions to remove the CMS streams.
https://vborg.vbsupport.ru/showpost....7&postcount=26

I'm still on it.

[yahooooh]

perfect perfect perfect