vb.org Archive
Page 36 of 61 « First 263435 36 373846 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Show Thread Enhancements - Limited Guest Viewing -- Motivate Guests to Register (https://vborg.vbsupport.ru/showthread.php?t=231352)

tutorials.de 07-15-2011 08:44 AM
Hi there :)

Is there anyone, who has modified the code, so that the add-on works with CMS articles? Would be great to get a little code snippet :cool:

Thank you very much!

BadgerDog 07-17-2011 10:34 AM
Quote:
Originally Posted by Ted S (Post 2217806)
Turn it to one of the other options so it runs but you are correct, we manually overwrote the date so 30 won't show up.
Thanks Ted .... :)

Have turned it ON with the 30 day patch. Seems to be running fine and I haven't noticed any server performance issues so far ...

Quote:
This option allows you to turn database logging on or off. When turned on guest views will be stored in a mysql table. This is more effective than using cookies alone for tracking but adds queries to every thread view causing additional server load and may have spider implications. See the support thread for more detail.
Using this option, has anyone ever reported problems with spiders being blocked and affecting search engines from being able to index a site?

Regards,
Doug

wildheart 07-18-2011 11:09 AM
Works perfectly on 4.1.4 patch level 1. Thank you very much and I clicked install.

BadgerDog 07-20-2011 09:11 PM
Quote:
Originally Posted by Ted S (Post 2217474)
Open the file lgvdb.php and replace

Code:
$vbulletin->db->query_write("
  DELETE FROM " . TABLE_PREFIX . "lgv
  WHERE (lastactivity + (". $vbulletin->options['lgvcleardays'] ." * 86400)) < ". TIMENOW ."
 ");
With code

Code:
$vbulletin->db->query_write("
  DELETE FROM " . TABLE_PREFIX . "lgv
  WHERE (lastactivity + (30 * 86400)) < ". TIMENOW ."
 ");

Hi Ted ... :)

Just checked the vBulletin error logs and it's showing me lots of SQL errors (same ones) when LGV executes the 30 day patch, at least I think that's what it's trying to tell me?

Quote:
Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM lgv
WHERE (lastactivity + (*30* * 86400)) < 1311049245;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*30* * 86400)) < 1311049245' at line 2
Error Number : 1064
Request Date : Tuesday, July 19th 2011 @ 12:20:45 AM
Error Date : Tuesday, July 19th 2011 @ 12:20:45 AM
Script : http://www.xxxxxx.com/cron.php?rand=1311049242
Referrer : http://www.xxxxxx.com/showthread.php?t=12345
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :
Did I enter the code change incorrectly? :confused:

Regards,
Doug

Ted S 07-21-2011 06:05 PM
Those stars around 30 (*30*) shouldn't be there. Are there any other characters that may have been added to the code you pasted? Maybe a single quote or something?

BadgerDog 07-21-2011 07:21 PM
Quote:
Originally Posted by Ted S (Post 2223305)
Those stars around 30 (*30*) shouldn't be there. Are there any other characters that may have been added to the code you pasted? Maybe a single quote or something?
Thanks Ted... I didn't see that .... :rolleyes:

What a dummy I am ... :D

I have no idea how that got in there, but I re-did the edit on a fresh PHP file and I re-installed it in /cron

Appreciate the support ... :up:

Regards,
Doug

Ted S 07-21-2011 07:58 PM
Perfect!

Hannigan 07-23-2011 09:18 PM
Fantastic add-on. Thanks.

gox 08-09-2011 02:48 PM
Hi Ted,

Is this MOD compatible with VB 4.1.5?

Thanks.

Ted S 08-10-2011 01:15 PM
Quote:
Originally Posted by gox (Post 2231390)
Hi Ted,

Is this MOD compatible with VB 4.1.5?

Thanks.
It's marked for 4.1.x unless someone knows otherwise


All times are GMT. The time now is 06:15 PM.
Page 36 of 61 « First 263435 36 373846 Last »
Show 40 post(s) from this thread on one page

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.01670 seconds
  • Memory Usage 1,744KB
  • 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
  • (2)bbcode_code_printable
  • (6)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