vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - Limited Guest Viewing -- Motivate Guests to Register (https://vborg.vbsupport.ru/showthread.php?t=178720)

Ted S 12-09-2008 08:59 PM

The table didn't get added for a reason... You can try reimporting but it's likely your vbulletin mysql account doesn't have enough access to create the table in the first place... But no reason you can't try.

EricPSF 12-09-2008 11:51 PM

Hi,

I hv installed and tested out without logging into my forum.

I tested it out by clicking on the "back" button of the browser everytime for more than 5 times, but I'm still unable to see the limited guest message?

Any advise? I hv already enabled the mod in admincp.

adamskiii 12-10-2008 12:44 AM

nice one man. thanks

Ted S 12-10-2008 03:38 AM

Quote:

Originally Posted by EricPSF (Post 1682007)
Hi,

I hv installed and tested out without logging into my forum.

I tested it out by clicking on the "back" button of the browser everytime for more than 5 times, but I'm still unable to see the limited guest message?

Any advise? I hv already enabled the mod in admincp.

I'm not following your issue... did you view 5 threads or use a back button multiple times to see 5 cached pages?

Rene Kriest 12-10-2008 04:05 AM

Kudos, Ted_S!

This addon really boosts registrations. If you have a decent forum with information of great value for your visitors then this is without any doubt the way to go.

I really cannot see why this addon doesn't show up as MotM and still suffers its fith star. Well...

EricPSF 12-10-2008 08:46 AM

Quote:

Originally Posted by Ted S (Post 1682083)
I'm not following your issue... did you view 5 threads or use a back button multiple times to see 5 cached pages?

Hi Ted,

Yes, I viewed 5 threads. I used the back button to go back to the main forum page everytime to select 5 threads.

Thank you.

IcheeWaWa 12-10-2008 02:05 PM

I updated my version of this plugin yesterday and starting seeing db errors in my email this morning when the cron ran:

Invalid SQL:

DELTE FROM lgv
WHERE (lastactivity + ( * 86400)) < 1228892404;

I looked at the lgvdb.php in /includes/cron and the sql is incorrect:

// actually do the kill
$vbulletin->db->query_write("
DELTE FROM " . TABLE_PREFIX . "lgv
WHERE (lastactivity + (". $lgvcleardays ." * 86400)) < ". TIMENOW ."

Note the DELTE. I know it's just a typo and I have corrected it on my system.

Thanks for the mod!

Ted S 12-10-2008 05:39 PM

Quote:

Originally Posted by EricPSF (Post 1682239)
Hi Ted,

Yes, I viewed 5 threads. I used the back button to go back to the main forum page everytime to select 5 threads.

Thank you.

I'm still not following... did you load 5 threads by clicking on them or did you simply surf back using a back button to see 5 threads you had already viewed? There's a dramatic differance between the two actions... if you click a link the page loads up and calls the system, if you merely go back and foward to pages you've already seen it's all from your cache and the system doesn't refresh.

Ted S 12-10-2008 05:40 PM

Quote:

Originally Posted by IcheeWaWa (Post 1682404)
I updated my version of this plugin yesterday and starting seeing db errors in my email this morning when the cron ran:

Invalid SQL:

DELTE FROM lgv
WHERE (lastactivity + ( * 86400)) < 1228892404;

I looked at the lgvdb.php in /includes/cron and the sql is incorrect:

// actually do the kill
$vbulletin->db->query_write("
DELTE FROM " . TABLE_PREFIX . "lgv
WHERE (lastactivity + (". $lgvcleardays ." * 86400)) < ". TIMENOW ."

Note the DELTE. I know it's just a typo and I have corrected it on my system.

Thanks for the mod!

Yikes. Good catch... issuing an update right now!

Ted S 12-10-2008 05:44 PM

An important bug update has been released for the 2.0 version of this addon! This update fixes a typo in the cron file causing it to improperly reset guest counts. Anyone using the 2.0 version of this addon who has database logging AND the clearing tool enabled should upgrade immediately.

To update simply download the attached version2 zip file and replace the cron files via FTP. No changes to the plugin file were made other than updating the version number.

Users not using database logging or on version1 do not need to upgrade.

Thank you to IcheeWaWa for discovering this bug and reporting it.

Issue: #2-01


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