Miscellaneous Hacks - [DBTech] Forum Live Feed & User Wall v1 (vB4) [AJAX]

Forum Live Feed & User Wall lets you see a continuously updated feed of activities on the forum, with a powerful set of customisation options for sources of information.

Uses
If you've wished for a Facebook-like feed for your forum, this mod is for you.

This mod adds 2 distinct features to your site. First a live feed showing actions performed by everyone on the forum, from new threads and posts to things like new avatars or signatures, your members can customise their feed and keep up to date with everything that's going on, right as it happens.
Secondly every user also has their own wall that displays what they have been up to. This lets users see what their friends have been doing and join in!
With advanced privacy configuration options and configurable preview options for each content type, this mod compliments other modifications like InfoPanels and produces a more detailed and verbose feed of the happenings on the forum.


-------------------------------------------------------------------------------------------

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com

-------------------------------------------------------------------------------------------

Translations available @ our forum
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------

Complete Feature List

Lite

• Forum Sidebar block type
• Preview in Forum Sidebar
• Ability to turn off IMG tag parsing on both main pages and Sidebar
• Status updates (from Forum Sidebar or the Live Wall page)
• Content types for nearly all forum actions:
  • Posts
  • Threads
  • Avatar changes (Only if Avatars are stored in the file system!)
  • Signature picture changes (Only if Signature Pictures are stored in the file system!)
  • Username changes
  • Social Group discussion
  • Social Group discussion replies
  • Status Updates (From this mod)
  • vBLive Status Updates
  • vBArcade Scores
  • [DBTech] Advanced Post Thanks / Like: Button clicks for Posts
• Nobody / Registered Users / Contacts Only / Friends Only display options for each content type to control who you see feeds from
• Nobody / Registered Users / Contacts Only / Friends Only privacy options for each content type to control who can see your feeds
• Automatically refreshing via AJAX at controllable intervals

Pro

• Recent Entries page with more entries displayed, no auto refresh
• Ability to "favourite" stories and view them from their own page
• Comments system
  • Comment count in the main feed with link to comment thread
  • Ability to post comments in the comment thread
  • AJAX refreshed comment threads
  • Ability to delete your own/others comments with usergroup permissions
• Content types for nearly all forum actions:
  • Blog Posts
  • Blog Comments
  • User Notes
  • Visitor Messages
  • Profile Pictures

-------------------------------------------------------------------------------------------

This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[inigo]

Originally Posted by rbharathi

uploaded the files and installed the XML,
, and completed the setup permissions.

after that i cant see the Live feed !!
i have added a forum block.
but no new sidebars.

only i am able to click through , quick links "Live Feed"

But when i enter some text, it is not getting added to feed,
what im missing ??

Note: When i disable Everywhere sidebar,
feeds are working in,

/forum/livewall.php
so it is conflicting with EveryWhere Sidebar (ESB) ??

Any solutions??

Same problem, ESB installed. I cannot see the live wall after installing, and giving permissions, without errors,

Any help?

[DragonByte Tech]

The required files for the Live Wall to load are only added to the Forum Home page, for performance reasons. Currently, these two products are not compatible.

Fillip

[inigo]

Thanks, I will uninstall this product for the moment,...

If there is a solution in the future I will try again,

Thanks,

[JohnScag]

Is there a way to get this to come up on the top of the page and scroll horizontally? The live feed totally scrunches the pages too much when on the right or left.

[DJ-Dez]

Would be good if this plugin was more compatible with your Follower plugin, so forum users could use the activity page to track who they're following and not everyone

[DragonByte Tech]

Originally Posted by DJ-Dez

Would be good if this plugin was more compatible with your Follower plugin, so forum users could use the activity page to track who they're following and not everyone

If you re-post this @ our site, we can take it into consideration for future versions


Fillip

[Jorandh]

I'm currently optimising my database. Basically my whole Slow_query_log is filled with the queries from your plugin. Any chance you can improve the queries and use of left joins without indexes?

Example:

SET timestamp=1427964576;
SELECT
				thread.*,
				post.*,
				user.*,
				thread.title AS threadtitle,
				thread.dateline,
				thread.threadid AS contentid,
				'threads' AS contenttypeid,
				favourite.userid IS NOT NULL AS isfavourite				
				, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb
			FROM (SELECT threadid FROM vb_thread WHERE threadid > 215606 ORDER BY threadid DESC LIMIT 500) AS tmp
			LEFT JOIN vb_thread AS thread ON(thread.threadid = tmp.threadid)
			LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
			LEFT JOIN vb_user AS user ON(user.userid = thread.postuserid)
			LEFT JOIN vb_dbtech_livewall_settings AS currentuser_settings ON(currentuser_settings.userid = 71492)
			LEFT JOIN vb_dbtech_livewall_settings AS actionuser_settings ON(actionuser_settings.userid = user.userid)
			LEFT JOIN vb_dbtech_livewall_favourite AS favourite ON(favourite.userid = 71492 AND favourite.contenttypeid = 'threads' AND favourite.contentid = thread.threadid)
			LEFT JOIN vb_userlist AS actionuser_friend ON(actionuser_friend.userid = user.userid AND actionuser_friend.relationid = 71492)
			LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid)
			WHERE NOT ISNULL(thread.threadid)
				AND post.visible = 1
				AND thread.visible = 1
				AND thread.open != 10
				AND thread.forumid NOT IN(0,12,181,186,384,32,387,229,218,219,263,249,230,134,319,353,388,318,65,271,373,272,306,220,270,360,402,70,56,59,311,63,356,321,298,11,286,278,159,40,41,385)
				AND NOT FIND_IN_SET(0, membergroupids)
				AND usergroupid NOT IN('0')
				
				AND
				(
					user.userid = 71492 OR
					(
						(
							ISNULL(currentuser_settings.threads_display) OR 
							(
								currentuser_settings.threads_display = 0 OR
								(
									currentuser_settings.threads_display = 1 AND
									71492 > 0
								) OR
								(
									currentuser_settings.threads_display = 2 AND
									actionuser_friend.type = 'buddy'
								) OR
								(
									currentuser_settings.threads_display = 3 AND
									actionuser_friend.type = 'buddy' AND
									actionuser_friend.friend = 'yes'
								)
							)
						) AND
						(
							ISNULL(actionuser_settings.threads_privacy) OR 
							(
								actionuser_settings.threads_privacy = 0 OR
								(
									actionuser_settings.threads_privacy = 1 AND
									71492 > 0
								) OR
								(
									actionuser_settings.threads_privacy = 2 AND
									actionuser_friend.type = 'buddy'
								) OR
								(
									actionuser_settings.threads_privacy = 3 AND
									actionuser_friend.type = 'buddy' AND
									actionuser_friend.friend = 'yes'
								)
							)
						)						
					)
				)
				
			ORDER BY tmp.threadid DESC;

Which comes from /dbtech/livewall/threads.php


And it's just one example, there are multiple queries in different contenttype queries.

[Jorandh]

Originally Posted by DragonByte Tech

BB Code

• VIDEO and IMG BB Code will no longer parse in the Live Feed

I still get them when someone quotes a post with an image... Can this be removed too?

[DragonByte Tech]

Forum Live Feed & User Wall v1.2.8

New Features:

Content Types

• The "Posts" Content Type now supports thread prefixes
• The "Threads" Content Type now supports thread prefixes

Fillip

[DragonByte Tech]

Changed Features:

• A fresh copy of the jQuery library is now only downloaded if one has not been downloaded previously. Requires updating of all other affected DBTech mods to take full effect.

Fillip