Activity Streams

[Phalynx]

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

[ProFifaLeagues]

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

How do you go about this please?

[Phalynx]

Activity Streams is reading PHP files from a defined directory. If someone will do a stream for f.e. Post Thanks, you just need to copy that "stream file" to the defined directory (/sas/streams/)
No need to change any sourcecode of Activity Streams.

[Alfa1]

Very nice! I'll install this when I move to vb4. tagged.

Please consider to add 'received reputation comments'.

[Phalynx]

Very nice! I'll install this when I move to vb4. tagged.

Please consider to add 'received reputation comments'.

Great idea. Added:
http://www.vbaddict.net/project.php?issueid=100

BTW, A version for vBulletin 3.8 is already in work.

[Alfa1]

Thanks Marius!

[ProFifaLeagues]

Cheers Alfa1

[Hornstar]

This is fantastic. Very nice work!

[sticky]

Will this work on versions prior to 4.1 or 4.0.8?

[Juggernaut]

Is this mod resourse intensive? does it use a lot of server resources? my forum is kind of small, but I am on a shared hosting account.

[Daryn]

I tried to install this on 4.1.0 and it didn't show up on the user profiles. Not sure what's going on, but removed it for the time being.

[mitch84]

thank you

[Phalynx]

Will this work on versions prior to 4.1 or 4.0.8?
I doubt, as templates changed with 4.0.8

Is this mod resourse intensive? does it use a lot of server resources? my forum is kind of small, but I am on a shared hosting account.
Try it, if it's too much you can disable/uninstall it.

I tried to install this on 4.1.0 and it didn't show up on the user profiles. Not sure what's going on, but removed it for the time being.
You installed the product xml? Does it show up in the installed products?

[Diana Notacat]

I tried to install this on 4.1.0 and it didn't show up on the user profiles. Not sure what's going on, but removed it for the time being.

You installed the product xml? Does it show up in the installed products?

I'm having the same problem! Did install the xml, and it's showing up as installed in the Products. The settings are also showing up in the AdminCP, it's just not displaying in the profiles.

[wEbAddEr]

same here, installed but nothing at the profiles

[g0dfather1984]

I am just getting this error when I try to go to the profiles:

Warning: require_once([path]/sas/includes/member_complete.php) [function.require-once]: failed to open stream: No such file or directory in [path]/member.php(609) : eval()'d code on line 41

Fatal error: require_once() [function.require]: Failed opening required '/home/******/*******/sas/includes/member_complete.php' (include_path='.:/usr/lib/php') in /home/*******/*****/member.php(609) : eval()'d code on line 41

[Phalynx]

I'm having the same problem! Did install the xml, and it's showing up as installed in the Products. The settings are also showing up in the AdminCP, it's just not displaying in the profiles.

same here, installed but nothing at the profiles
Just released a version where the not showing tab is fixed. Please upload the file \sas\includes\member_complete.php from the updated ZIP to your server.


I am just getting this error when I try to go to the profiles:

Warning: require_once([path]/sas/includes/member_complete.php) [function.require-once]: failed to open stream: No such file or directory in [path]/member.php(609) : eval()'d code on line 41

Fatal error: require_once() [function.require]: Failed opening required '/home/******/*******/sas/includes/member_complete.php' (include_path='.:/usr/lib/php') in /home/*******/*****/member.php(609) : eval()'d code on line 41

You need to copy the files in the ZIP to your server. The folder /sas/ should be in the root where also forum.php is located.

[Phalynx]

Just released a version where the not showing tab is fixed. Please upload the file \sas\includes\member_complete.php from the updated ZIP to your server.

[wEbAddEr]

the new file gives me a database error:

Database error in vBulletin 4.1.0:

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(3,4,11,5,56,6,7,8,9,10,12,13,14,15,16,17,18,19, 28,20,40,22,23,24,25,26,27,53, 54,55,29,31,32,52,30,35,41,42,43,44,45,46,47,48,49 ,50,51,36,37,38,39)

AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1291844552
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 : Wednesday, December 29th 2010 @ 01:42:32 PM
Error Date : Wednesday, December 29th 2010 @ 01:42:32 PM
Script :
Referrer :
IP Address :
Username :
Classname :
MySQL Version : 5.0.51a-community

[Phalynx]

Fixed in next version.

[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/member.php?action=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]

Excellent = 5 stars

installed +translated to Arabic

plzz be nice and add translation to 1st original post
thank you
Thanks for sharing.

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/member.php?action=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,1 49,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,1 22,125,126,24,14,137,15,150,151,152,153,154,155,15 6,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]

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

[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]

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.php?p=2141467&postcount=26

I'm still on it.

[yahooooh]

perfect perfect perfect

[hakan68]

it's not working vBulletin 3.8.x version...

[Phalynx]

Of course it's not working with 3.x, as this is a version for 4.x

A version for 3.8 will be released in February.

[tattooz]

Any chance of adding the Photopost gallery?

[tattooz]

Installed on 4.1.0 and works great! Thanks

[Alfa1]

Of course it's not working with 3.x, as this is a version for 4.x

A version for 3.8 will be released in February.
Thanks!

Any chance of adding the Photopost gallery?
Would be great!

[punchbowl]

Another great mod!

Bug: Experience awards link to /sas.php

also

I changed line 80 to $selected_tab = "aboutme" will this have any side effects? I haven't noticed any so far.

[SuperTaz]

Edit: Nevermind. I saw your quick fix post.

[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.

[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

3. vba modules for activity streams for user friends
this will contain all activities of his friends only and for last xx time and will support ajax
and also will respect friends permissions if they remove one type of streas or one of them want to stop all his streams

4. the same as vba module but as php file , for example: streams.php with ability to make it as streams for all the site and with option for user to just for friends and also it will respect permissions of the users if they want to not show thier activities except for thier friends or for no one

this will make big step to be close to social site than just forum

[ThorstenA]

With the CMS disabled, I get a database error on the profiles.

[gibigbig]

database error. not going to bother with this.
too bad though

[BlackThorn]

With the CMS disabled, I get a database error on the profiles.

https://vborg.vbsupport.ru/showpost.php?p=2141467&postcount=26

[Brew]

Really nice mod Phalynx

But in some styles the text within the tab doesn't show, as in the attached image

As seen when visiting profile:

https://vborg.vbsupport.ru/external/2011/01/15.png


This is when the tab is hilighted:

https://vborg.vbsupport.ru/external/2011/01/16.png

[Antidepresiv]

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

[CRDeveloper]

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

No updates jet??

[Fatih ?zcan]

Still waiting for vB3.8.x version, when it will release?

[Alfa1]

Could you please post an update on the status of the 3.8 version?

Many thanks for all your work!

[shanevas2]

I am getting a database error on 4.1.2

[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 :)

[i3lack]

Yeah my tabs are not showing on profiles for this mod. any idea on how to fix?

[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]

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.php?p=2141467&postcount=26

[K4GAP]

Just added to 4.1.3. running great!!

Thanks

[EquinoxWorld]

Confirmed 4.1.4 working great!

[8thos]

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,5 50,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,33 5,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,5 7,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,6 82,683,684,670,713,752,660,662,827,664,663,826,666 ,665,661,823,259,667,672,688,674,673,676,675,677,6 78,824,825,13,552,14,431,446,453,430,391,15,432,44 3,447,454,16,433,442,448,455,17,434,441,449,456,39 0,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,48 4,763,762,764,765,766,28,217,704,218,702,703,219,2 23,509,706,707,708,27,306,699,700,88,697,698,709,5 76,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,48 6,792,622,796,797,480,494,493,497,575,307,310,822, 182,183,184,185,214,211,213,186,593,594,595,596,59 7,598,212,374,375,377,376,380,378,379,381,599,579, 620,652,654,619,651,621,573,582,583,584,578,585,58 1,656,580,600,603,773,775,774,616,632,633,630,631, 628,629,635,624,617,626,636,602,590,758,760,757,75 9,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,82 8,192,338,191,563,168,89,224,39,564,561,560,559,58 8,562,73,80,342,350,355,356,339,343,341,344,348,34 7,340,353,345,351,349,352,346,642,81,357,358,658,9 0,92,91,170,93,94,169,110,114,113,111,95,383,261,2 69,571,572,517,518,568,277,519,520,521,569,283,522 ,524,525,288,535,536,534,527,566,302,532,533,528,2 89,529,530,384,473,515,516,710,715,720,721,722,716 ,723,724,725,726,717,729,733,727,735,730,731,734,7 28,732,736,718,738,739,737,719,745,742,747,748,746 ,743,744,740,741,755,791,31,121,120,257,181,260,54 3,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]

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 :)

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

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]

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.

[kylek]

Thanks Gemma,

Have tried that before and in our case it still keeps activity showing as number 1 when going to a members profile page.

I can move the tab with no problem, just cant get the activity moved out of the number 1 spot.