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)
-   -   vBulletin Forum Sideblocks - Forum Sideblock - Recent Posts (with BBCodes parsed) (https://vborg.vbsupport.ru/showthread.php?t=321920)

MarkFL 02-25-2016 03:10 AM

Quote:

Originally Posted by Max Taxable (Post 2565562)
I don't see this Mod working on the site in your signature. Is that the site?

I have it working on our dev site, on the same server. I have brought this mod to the attention of my fellow staff there, and am waiting for a general consensus before going live with it.

Max Taxable 02-25-2016 03:13 AM

Quote:

Originally Posted by MarkFL (Post 2565563)
There's only 1 query:

PHP Code:

$recent_posts $vbulletin->db->query_read("
    SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid
    FROM " 
TABLE_PREFIX "post AS post
    INNER JOIN " 
TABLE_PREFIX "thread AS thread
    ON thread.threadid = post.threadid
    ORDER BY post.dateline DESC
"
); 

Information about the posts as well as the threads they inhabit are needed. If anyone sees how to make that query more efficient, I'm all ears. :)

NOT the queries of the mod itself, the amount of queries the server has to do in order to create the executable file for the page source. For whatever reason, this mod greatly increases it.
Quote:

I have it working on our dev site, on the same server.
Would you mind sending me that link via PM?

Meanwhile, i can turn this back on at my live site, and you can go there and see what kind of "lag" you get, significant or not.:D

MarkFL 02-25-2016 03:25 AM

Quote:

Originally Posted by Max Taxable (Post 2565565)
NOT the queries of the mod itself, the amount of queries the server has to do in order to create the executable file for the page source. For whatever reason, this mod greatly increases it.

Hmmm...okay, perhaps I should look into rendering the HTML via a custom template rather than storing it all in the returned value of the eval'd code. I thought about that, but decided against it since it seemed to work. I appreciate all of your feedback, and I will render the output via a custom block template instead.

Quote:

Originally Posted by Max Taxable (Post 2565565)
Would you mind sending me that link via PM?

Sorry, we only allow senior staff on our site access to our dev site. If it were my decision alone, I would have no hesitation, but it's not solely up to me.

Quote:

Originally Posted by Max Taxable (Post 2565565)
Meanwhile, i can turn this back on at my live site, and you can go there and see what kind of "lag" you get, significant or not.:D

I will be glad to check, but I am hoping using a custom template will fix the FBT issue...I should be able to complete this within 24 hours. :)

And again, thank you for your testing and feedback, it is greatly appreciated and valuable! :up:

Max Taxable 02-25-2016 03:27 AM

Quote:

Originally Posted by MarkFL (Post 2565568)
I will be glad to check, but I am hoping using a custom template will fix the FBT issue...I should be able to complete this within 24 hours. :)

And again, thank you for your testing and feedback, it is greatly appreciated and valuable! :up:

Okay check it right quick - your mod is the only forum block i have running.

http://dallascowboysuniverse.com

MarkFL 02-25-2016 03:34 AM

Quote:

Originally Posted by Max Taxable (Post 2565570)
Okay check it right quick - your mod is the only forum block i have running.

http://dallascowboysuniverse.com

Yes, I counted a 16 second load time after the initial load and I refreshed the page.:eek:

It will be interesting to see if the custom template makes a positive difference. :)

Max Taxable 02-25-2016 03:35 AM

Okay I have set the default block active, yours back off.

Glad to be of help.

MarkFL 02-25-2016 07:08 AM

Update - Version 1.1:
  • Combined queries.
  • Custom templates used to render output.
  • All CSS stored in template.
  • Fixed error causing block not to be removed upon uninstall.

In Omnibus 02-25-2016 11:08 AM

The block is displaying twice with version 1.1.

Easily remedied by removing one of the blocks in the Forum Blocks Manager.

Page still loads excessively slowly.

MarkFL 02-25-2016 02:17 PM

Quote:

Originally Posted by ProSportsForums (Post 2565578)
The block is displaying twice with version 1.1.

Easily remedied by removing one of the blocks in the Forum Blocks Manager.

Page still loads excessively slowly.

I had an error in previous versions where the block wasn't removed from the db when you uninstall, so installing version 1.1 after uninstalling a previous version requires you to remove any remaining blocks that were installed. That's fixed now.

Please make sure you removed the old block instead of the new one. :)

Max Taxable 02-25-2016 03:13 PM

Okay to just upload the XML to overwrite?


All times are GMT. The time now is 11:50 AM.

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.01194 seconds
  • Memory Usage 1,749KB
  • 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_php_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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