vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - [DBTech] Forum Live Feed & User Wall v1 (vB4) [AJAX] (https://vborg.vbsupport.ru/showthread.php?t=278742)

inigo 09-24-2014 02:56 PM

Quote:

Originally Posted by rbharathi (Post 2513513)
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 09-24-2014 03:01 PM

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 09-24-2014 04:08 PM

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

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

Thanks,

JohnScag 10-14-2014 02:00 PM

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 12-06-2014 07:43 AM

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 12-07-2014 07:04 PM

Quote:

Originally Posted by DJ-Dez (Post 2525977)
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 04-02-2015 07:39 AM

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

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 04-02-2015 07:55 AM

Quote:

Originally Posted by DragonByte Tech (Post 2511740)
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 07-17-2015 07:46 PM

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 04-25-2016 08:43 PM

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


All times are GMT. The time now is 10:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01495 seconds
  • Memory Usage 1,771KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete