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

[shanevas2]

Database error in vBulletin 4.1.3:

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 thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(11,12,13,14,15,19,20,21,22,23,24,25,26,1,3,16,1 7,4,5,6,30,2,18,7,8,9,10,27,28,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1300467552



AND thread.postuserid IN (1)
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, April 8th 2011 @ 09:59:12 AM
Error Date : Friday, April 8th 2011 @ 09:59:12 AM
Script : http://texasperformanceforums.com/member.php?1-Shane
Referrer : http://texasperformanceforums.com/forum.php
IP Address : 75.1.52.44
Username : Shane
Classname : vB_Database
MySQL Version : 5.0.91-log

[madshark]

Originally Posted by shanevas2

Database error in vBulletin 4.1.3:

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 thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(11,12,13,14,15,19,20,21,22,23,24,25,26,1,3,16,1 7,4,5,6,30,2,18,7,8,9,10,27,28,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1300467552



AND thread.postuserid IN (1)
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, April 8th 2011 @ 09:59:12 AM
Error Date : Friday, April 8th 2011 @ 09:59:12 AM
Script : http://texasperformanceforums.com/member.php?1-Shane
Referrer : http://texasperformanceforums.com/forum.php
IP Address : 75.1.52.44
Username : Shane
Classname : vB_Database
MySQL Version : 5.0.91-log

If you went a few pages back : https://vborg.vbsupport.ru/showpost....7&postcount=26

[K4GAP]

Just added to 4.1.3. running great!!

Thanks

[EquinoxWorld]

Confirmed 4.1.4 working great!

[8thos]

Originally Posted by yahooooh

plz this suggestions i hope they will be exist :

1.ability for user to hide his activity streams or make it only for his friends but not for others

2.abiliy for user to remove single stream , or to remove one type of streams , like :
user1 do not want to show his repies activities but he like to show other activities streams

Milad has a stream like this that does the things you asked called Social Feeds.

You can see it in action after you add someone to your friends list on my site.

[exxxir]

hi
i deleted
\sas\streams\cms.php
\sas\streams\cms_comment.php

but:

Database error in vBulletin 4.1.3:

Invalid SQL:

		SELECT thread.postusername as firstpostusername, thread.postuserid as firstpostuserid, post.dateline, post.pagetext, post.allowsmilie, post.postid,
			thread.threadid, thread.title, thread.prefixid, post.attach, thread.replycount,
			forum.forumid, post.title AS posttitle, post.dateline AS postdateline,
			user.userid as postuserid, user.username as postusername
	 	FROM post AS post
		JOIN thread AS thread ON (thread.threadid = post.threadid)
		JOIN forum AS forum ON(forum.forumid = thread.forumid)
		LEFT JOIN user AS user ON (post.userid = user.userid)
		WHERE 1=1
			 AND ( thread.forumid IN(1,690,689,3,469,696,653,470,209,753,754,4,638,550,5,639,641,577,87,695,67,531,97,116,389,795,171,327,388,482,514,523,526,565,567,586,589,537,691,7,692,8,122,123,712,705,9,798,10,465,50,51,48,466,335,336,49,362,11,41,40,42,43,44,812,476,820,12,801,52,53,56,55,84,161,164,165,166,162,163,54,78,467,57,59,751,60,64,66,124,69,216,68,541,361,258,540,72,800,659,669,679,681,680,711,671,685,714,686,668,682,683,684,670,713,752,660,662,827,664,663,826,666,665,661,823,259,667,672,688,674,673,676,675,677,678,824,825,13,552,14,431,446,453,430,391,15,432,443,447,454,16,433,442,448,455,17,434,441,449,456,390,125,435,440,450,457,104,436,439,451,458,105,437,438,452,459,693,172,142,19,126,140,385,141,386,132,387,143,144,145,146,18,195,468,483,20,138,657,174,173,179,178,316,176,784,180,177,175,818,25,331,484,763,762,764,765,766,28,217,704,218,702,703,219,223,509,706,707,708,27,306,699,700,88,697,698,709,576,701,802,803,806,807,808,809,813,819,814,815,816,830,804,817,805,831,694,21,23,318,319,324,22,330,139,24,109,321,332,333,222,460,193,799,462,490,491,492,475,498,464,30,496,771,424,770,29,554,82,557,312,313,314,841,427,553,461,485,756,489,487,488,486,792,622,796,797,480,494,493,497,575,307,310,822,182,183,184,185,214,211,213,186,593,594,595,596,597,598,212,374,375,377,376,380,378,379,381,599,579,620,652,654,619,651,621,573,582,583,584,578,585,581,656,580,600,603,773,775,774,616,632,633,630,631,628,629,635,624,617,626,636,602,590,758,760,757,759,761,768,618,627,769,601,604,648,649,650,794,772,605,655,606,607,608,776,777,778,779,780,33,34,548,546,547,781,549,35,556,786,787,785,551,788,789,790,833,834,835,836,837,838,839,840,555,38,558,106,828,192,338,191,563,168,89,224,39,564,561,560,559,588,562,73,80,342,350,355,356,339,343,341,344,348,347,340,353,345,351,349,352,346,642,81,357,358,658,90,92,91,170,93,94,169,110,114,113,111,95,383,261,269,571,572,517,518,568,277,519,520,521,569,283,522,524,525,288,535,536,534,527,566,302,532,533,528,289,529,530,384,473,515,516,710,715,720,721,722,716,723,724,725,726,717,729,733,727,735,730,731,734,728,732,736,718,738,739,737,719,745,742,747,748,746,743,744,740,741,755,791,31,121,120,257,181,260,543,545,793,643,644,645,832,646,647,479,539,71,6,821,782)
			
			AND thread.visible = 1
			AND post.visible = 1
			AND thread.open <> 10
			AND post.dateline > 1308584605
			AND post.parentid > 0
			
			
			AND post.userid IN (1)
		ORDER BY post.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 post.dateline DESC
		LIMIT 0,1' at line 20
Error Number  : 1064
Request Date  : Monday, July 11th 2011 @ 07:43:25 PM
Error Date    : Monday, July 11th 2011 @ 07:43:26 PM
Script        : http://www.parsiniak.com/forum2/member.php?1-Admin
Referrer      : 
IP Address    : 46.19.141.250
Username      : Admin
Classname     : vB_Database
MySQL Version : 5.0.92-community

[LisaArnold]

Thanks, but had to uninstall due to it throwing up errors when trying to enter into a profile.

I might try this one again at a later date.

World have been a good mod, so Thanks anyway.

[Krusty1231]

Agreed - same error as above. Uninstalled!

[kylek]

Originally Posted by Furcal15

How can I keep the activity streams tab but make my visitor messages tab default tab when viewing a users profile?

Thanks and marked as installed

Originally Posted by Antidepresiv

Thanks for this mod.. How could i put the Activity Streams after the Friends tab ? Thanks again..

Originally Posted by tattooz

How can I change the hook order in the profile. When a profile is viewed, I do not want the activity stream to be the first this someone views. I would like the default, visitor message to be seen first.

I would like to ask the same thing, need to move activity stream out of the first tab position.

[Gemma]

Originally Posted by kylek

I would like to ask the same thing, need to move activity stream out of the first tab position.

Try this

AdminCP > Plugins & Products > Add New Plugin

Product: vBulletin
Hook Location: member_build_blocks_start
Title: Load Visitor Messages Tab By Default
Execution Order: 1
Plugin PHP code:

if (!$vbulletin->GPC_exists['tab'])
{
    $vbulletin->GPC['tab'] = 'visitor_messaging';
}

Plugin is Active: Yes

There is probably a way to do it by modifying one of the Activity Stream plugins but I don't use this so can't check.

I use a similar method on my site to load the About Me tab first.