vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Track Guest Visits (https://vborg.vbsupport.ru/showthread.php?t=131314)

jw00dy 01-10-2007 06:03 AM

Thanks Paul, Nicely done.

Ricsca 01-10-2007 09:34 AM

Thanks! :)

red-dna 01-10-2007 10:26 AM

I check that set Enable Spider Display is allreadt set to 'Yes' in vBulletin Options
and i also visit the online.php page (and the spiders are displayed ok)
but i get:
Total guests that have visited the forum in the last 24 hours: 609
Visitors (609)


The previous version is worked ok, but with the update i got stuck with this problem.

Any help ?:(

MeMySelfNi 01-10-2007 01:48 PM

updated..........

Paul M 01-10-2007 05:34 PM

Quote:

Originally Posted by red-dna (Post 1155361)
Any help ?:(

As I have previously mentioned a few times, if you want me to look at a specific problem then unless you provide me with access to your forum (admin access, with the ability to run sql queries) then there is nothing I can do. I cannot investigate problems that are not reproducable on my system.

storpappa 01-11-2007 01:52 PM

Stats are showing visits from the 3 major search engines, but these do not show up in the visitors for the mod. Any suggestions on what to check?

Or a way to send a spoofed bot visit to the site and see what shows up?

As above, I am fine with that. Just PM me if you are interested in looking at the site - thanks

****turned this off, back on, changed a babies popy diaper and now it is working. Your mileage with or without the diaper may vary. Thanks for another great mod Paul

aciurczak 01-11-2007 03:46 PM

As much as I like the functionality of this mod, it had such a performance hit on my board I had to disable it. My board felt sluggish recently, so I paid closer attention to the Microstats at the bottom saying how many seconds & queries it took to create the page. With this plug-in enabled, it would sometimes take 4 or 5 seconds to display my forum home page, (with only 14 queries). It was never less than 3 seconds.

After disabling this hack, it is back down to between 0.4 and 1.0 seconds to create the home page, with 13 queries. This hack reported that I was getting about 2000 guests visiting per day (vast majority were spiders), and my server load never reports over 0.8, so it likely wasn't a server load problem.

Any suggestions on indexing certain tables to improve performance?

Paul M 01-11-2007 06:29 PM

Hmm, looking at this on my homepage, mysql is not using the index for some reason, even though it exists. By forcing it the query is quicker.

Change the SQL call (in Plugin 3) to this and let me know what happens ;

PHP Code:

    $todaysguests $vbulletin->db->query_read_slave("
        SELECT * FROM "
.TABLE_PREFIX."guest FORCE INDEX (lastactive) WHERE lastactive > $cutoff
    "
); 


aciurczak 01-11-2007 06:41 PM

That did it. Page load time is back under a second, with the mod enabled. Thx for the quick fix.

Paul M 01-11-2007 11:39 PM

Quote:

Originally Posted by aciurczak (Post 1156441)
That did it. Page load time is back under a second, with the mod enabled. Thx for the quick fix.

Good, I'll release that as an update tomorrow.

Investigating that has highlighted some index issues in a few other mods as well, so I've a few updates to issue ......


All times are GMT. The time now is 01:15 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.01955 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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