vb.org Archive - Add-On Releases - Limited Guest Viewing -- Motivate Guests to Register

Page 10 of 11

Show 40 post(s) from this thread on one page

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)

mariocaz

10-01-2009 01:48 AM

Thank you Ted,

Let me try it.

mariocaz

10-01-2009 01:55 AM

Help Ted !!!!!!!

Now I am receiving tons of this errors in my email:

Database error in vBulletin 3.7.6:

Quote:

Invalid SQL:

SELECT id,views
FROM vblgv AS lgv
WHERE lgv.ipaddress = '186.15.15.217';

MySQL Error : Table 'allreef_inicio.vblgv' doesn't exist
Error Number : 1146
Request Date : Wednesday, September 30th 2009 @ 10:53:50 PM
Error Date : Wednesday, September 30th 2009 @ 10:53:50 PM
Script : http://www.all-reefs.com/inicio/showthread.php?t=7433
Referrer : http://www.all-reefs.com/inicio/forumdisplay.php?f=20
IP Address : 186.15.15.217
Username : No Registrado
Classname : vB_Database
MySQL Version :

Help.

mariocaz

10-01-2009 02:02 AM

Mmmm I don´t know why the vblgv table doesn´t exist.

I ran the the xml files in the ACP.

I don´t know how to create a table, if you want give me tha SQL instructions to do it in the phpmyadmin or another xml file.

I think when I uninstalled the mod I deleted the table but when I reinstalled it the table had to be installed again.

Ted S

10-01-2009 02:34 AM

The table can be created with the SQL:

Code:

CREATE TABLE PREFIXlgv (

        id int(7) unsigned NOT NULL auto_increment,

        ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',

       firstaccess INT UNSIGNED NOT NULL DEFAULT '0',

       views INT(4) NOT NULL DEFAULT '0',

       lastactivity INT UNSIGNED NOT NULL DEFAULT '0',

        PRIMARY KEY (id),

        KEY indexs (ipaddress,views,lastactivity)

      ) TYPE=MyISAM

Be sure to change or remove PREFIX.

mariocaz

10-01-2009 02:42 AM

if the table complete is vblgv, Is this one the correct instruction ?

Quote:

CREATE TABLE vblgv (
id int(7) unsigned NOT NULL auto_increment,
ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
views INT(4) NOT NULL DEFAULT '0',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY indexs (ipaddress,views,lastactivity)
) TYPE=MyISAM

or like this:

Quote:

CREATE TABLE lgv (
id int(7) unsigned NOT NULL auto_increment,
ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
views INT(4) NOT NULL DEFAULT '0',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY indexs (ipaddress,views,lastactivity)
) TYPE=MyISAM

Sorry if I am stupid, but I want to be sure before to run it.

mariocaz

10-01-2009 03:02 AM

Ted,

In this moment (I didn?t ran the SQL instruction yet, I am waiting your confirmation) I am receiving this errors:

Quote:

Database error in vBulletin 3.7.6:

Invalid SQL:

DELETE FROM vblgv
WHERE (lastactivity + ( * 86400)) < 1254369635;

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 '* 86400)) < 1254369635' at line 2
Error Number : 1064
Request Date : Thursday, October 1st 2009 @ 12:00:35 AM
Error Date : Thursday, October 1st 2009 @ 12:00:35 AM
Script : http://www.all-reefs.com/inicio/cron...and=1254369633
Referrer : http://www.all-reefs.com/inicio/onli...e&pp=20&page=1
IP Address : 189.142.218.197
Username : No Registrado
Classname : vB_Database
MySQL Version :

mariocaz

10-01-2009 03:26 AM

Ok I already ran the SQL instruction and I have now the table vblgv, but still receiving a lot of these errors by email:

Quote:

Database error in vBulletin 3.7.6:

Invalid SQL:

DELETE FROM vblgv
WHERE (lastactivity + ( * 86400)) < 1254370945;

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 '* 86400)) < 1254370945' at line 2
Error Number : 1064
Request Date : Thursday, October 1st 2009 @ 12:22:25 AM
Error Date : Thursday, October 1st 2009 @ 12:22:25 AM
Script : http://www.all-reefs.com/inicio/cron...and=1254370943
Referrer : http://www.all-reefs.com/inicio/show...?t=5752&page=6
IP Address : 189.217.98.64
Username : No Registrado
Classname : vB_Database
MySQL Version :

Ted S

10-01-2009 04:15 AM

That error is on the backend only but still needs to be fixed.

How often do have the scheduled task running? What is the value for the setting "Clear IP Activity Log"?

yahsuah

12-18-2009 10:15 PM

http://www.pdfonline.com/web2pdf/index.asp

Is it possible that I can use this script together with LGV plug-in?

I tried but it hasn't worked together.

How can I exclude this website: http://web2.pdfonline.com/pdfonline/pdfonline.js

HTML Code:

<!-- START: PDF Online Script -->

<script type="text/javascript">

        var authorId = "CED9DC99-40A8-4A21-9709-D89FD891A8F3";

        var pageOrientation = "0";

        var topMargin = "0.5";

        var bottomMargin = "0.5";

        var leftMargin = "0.5";

        var rightMargin = "0.5";

</script>

<script type="text/javascript" src="http://web2.pdfonline.com/pdfonline/pdfonline.js">

</script>

<!-- END: PDF Online Script -->

Ted S

12-19-2009 06:36 AM

This code would not impact javascript files.

BadgerDog

12-28-2009 06:04 PM

I've been using this mod (note: v3.6 version) for a long time and it's been great !!! :up:

Thanks for the work Ted... much appreciated ... :)

I had a question and I just wanted to make sure I've always understood what's happening with this mod ...

A "guest" reads posts on the site up to the limit of what I've set. He gets the warning message and finally the "blocking" message telling him should register.

I get a lot of people who the register, which changes their status to the group "Awaiting Email Validation". I notice that people sit for a long time at that group level, but never validate their emails and in fact, a lot of the time the emails they've provided are invalid. I usually purge this group for anyone over 10 days who hasn't validated their emails.

Am I correct in assuming that they do this so they can continue to read the forums using Ted's mod designed for guests and by registering and staying in the p "Awaiting Email Validation" status they circumvent the restrictions of it?

If so, is there anyplace I can add this group ID so they get treated like guests until they actually complete the registration process and validate their emails?

Thanks for and feedback and best wished to everyone for a happy, safe and prosperous new year ... :up:

Regards,
Badger

Ted S

12-28-2009 09:10 PM

Quote:

Am I correct in assuming that they do this so they can continue to read the forums using Ted's mod designed for guests and by registering and staying in the p "Awaiting Email Validation" status they circumvent the restrictions of it?

If so, is there anyplace I can add this group ID so they get treated like guests until they actually complete the registration process and validate their emails?

I'd actually theorize (with some data to back it) that many remain unconfirmed because they don't realize they are unconfirmed. The email doesn't get to them and your forum doesn't tell them anything is wrong so unless they go looking, they just get stuck. That's why the welcome headers mod I created has a treatment to bug them to confirm.

In any event, you are correct, once registered they are considered a full member even if they don't confirm. You can address this however by modifying the plugin:

Code:

if ($show['guest'] AND !$lvgbot AND $vbulletin->options['lgvon'])

Becomes:

Code:

if ( ($show['guest'] OR $vbulletin->userinfo['usergroupid'] == 'XXX') AND !$lvgbot AND $vbulletin->options['lgvon'])

Where XXX is the id of your awaiting group

BadgerDog

12-30-2009 10:44 AM

Quote:

Originally Posted by Ted S (Post 1940876)

In any event, you are correct, once registered they are considered a full member even if they don't confirm. You can address this however by modifying the plugin:

Hello Ted… :)

Thank you for the patch. That was gracious of you to provide that …. :up:

I also do use your excellent "Welcome Headers" mod and have so for years as well. First class add-on....

Before I went ahead and put in the patch, I thought I'd check to see what was happening with "Limited Guest Viewing" right now, as it's been a few years since I did that. I discovered something odd. The mod seems to have stopped working at some point in time.

If I turn it OFF, then guests can't access posts and they receive the standard "not permitted" message. If I turn it ON, they are able to view threads, but indefinitely and none of the warning or blocked messages ever appear. I have no idea why it's stopped working and I've done a bunch of testing, but can't find anything unusual. I've recheck the addition of the $lgvmessage at the bottom of "NAVBAR" template and it's there, located right under the $welcomeheaders one, both located right at bottom of the template.

I know it was working and the "Welcome Headers" mod is still functioning fine. I even turned it off and tested without it running, but I never see any "Limited Guest Viewing" messages, nor does it stop anyone from indefinite views of posts in forums.

Any ideas where I can look further to test and debug?

Thanks again for your excellent mods. I have been meaning to send you a donation for years, but it always slips my mind. Now that I'm here once again and dealing with the forum, I have just done that to say thank you for your mods and other help you given everyone of the years.

Regards,
BadgerDog (Doug)

Ted S

12-31-2009 06:00 AM

Quote:

Originally Posted by BadgerDog (Post 1942379)

If I turn it OFF, then guests can't access posts and they receive the standard "not permitted" message.

This mod doesnt have that much power. It's possible something is conflicting but I suspect your permissions are out of wack on the forum.

Quote:

Originally Posted by BadgerDog (Post 1942379)

I know it was working and the "Welcome Headers" mod is still functioning fine. I even turned it off and tested without it running, but I never see any "Limited Guest Viewing" messages, nor does it stop anyone from indefinite views of posts in forums.

Pop open firefox as a guest and watch for the lgv cookie to be sure it's increasing. Then check that your settings for the message are right

Or turn on debugging by editing the xml file to set $debug = 1; and you will get lots of output about what it is doing.

vitrag24

12-31-2009 06:51 PM

i hope this will be updated for vb 4.0 soon.
Thanks.

BadgerDog

12-31-2009 07:00 PM

Quote:

Originally Posted by Ted S (Post 1943168)

This mod doesnt have that much power. It's possible something is conflicting but I suspect your permissions are out of wack on the forum.

Got it running ... :up:

I think there was something amiss with the forum permissions contradicting the mod ...

I reset the forum permissions and it started working fine ...

I had to patch the original XML file with your patch above and re-upload it, instead of patching the plug-in directly. For whatever reason, when I patched the plugin, it would change the hook and the code wouldn't work. I have screen pics of the AdminCP weirdness I can send it you're interested.

If I patched the XML and then uploaded it, everything works fine and now the "Awaiting Email" group gets caught in the same "guest" cookie trap. Works great and has already forced down the guys who were just circumventing the guest access block. Thank you .. :up:

By the way, also installed your "Subscription Notification System" and it's working great as well ... :)

Regards,
Badger

mintman72

01-16-2010 04:41 PM

Any possibility for an update to 4.0?

Ted S

01-16-2010 05:17 PM

There is already a 4.0 version.

SomeSailor

01-17-2010 01:37 PM

I'm getting an error in the Register Take-Over:

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: limited_guest_viewing in [path]/includes/functions.php on line 3893

This appears across the top of the forum when they hit the count set in 'Register Take-Over Message Count'.

Any ideas?

Kunani

01-17-2010 10:49 PM

I installed this on 4.0.1 and use the cookie only default settings and everything works fine. Thanks for the great mod. Exactly what I was wanting.

Ted S

01-18-2010 03:19 AM

Quote:

Originally Posted by SomeSailor (Post 1958161)

Are you sure you are running the vB4 version?

vitrag24

03-15-2010 09:04 PM

update for 4.0?
thx.

Sea Shepherd

05-12-2010 03:49 PM

I must be blind...i cant see the 4.0 version anyway in the 4.0 lists.

CarlitoBrigante

06-28-2010 05:18 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=231352" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=231352</a>

Usually, you can check the user's profile to see new versions of products.

mindhunter77

08-03-2010 10:35 PM

For some reason, with database loging on, when a guest reaches their limit it throws them a MYSQL error instead of showing them the message page. Any idea what would cause this?

Ted S

08-05-2010 11:52 PM

Quote:

Originally Posted by mindhunter77 (Post 2078797)

For some reason, with database loging on, when a guest reaches their limit it throws them a MYSQL error instead of showing them the message page. Any idea what would cause this?

What's the error?

mindhunter77

08-08-2010 02:32 AM

Quote:

Originally Posted by Ted S (Post 2079847)

What's the error?

Code:

MySQL Error : Table 'bbq.vblgv' doesn't exist

Ted S

08-08-2010 09:07 PM

Quote:

Originally Posted by mindhunter77 (Post 2080706)

Code:

MySQL Error : Table 'bbq.vblgv' doesn't exist

The table was not setup for some reason, you will need to either reinstall or manually create it:

Code:

CREATE TABLE bbq.lgv (

        id int(7) unsigned NOT NULL auto_increment,

        ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',

       firstaccess INT UNSIGNED NOT NULL DEFAULT '0',

       views INT(4) NOT NULL DEFAULT '0',

       lastactivity INT UNSIGNED NOT NULL DEFAULT '0',

        PRIMARY KEY (id),

        KEY indexs (ipaddress,views,lastactivity)

      ) TYPE=MyISAM

mindhunter77

08-08-2010 09:14 PM

Thanks man =)

MarceloS

08-24-2010 05:11 PM

Thanks for the mod!

It would be good to have the option to "include forum Ids". I may want to use the mod only on one popular forum, for example.

yahwehpassim

08-28-2010 12:00 PM

Is this hack good for the 4.0 series of vbulletin? If not when will it be? Is someone working on it? This is a great hack. I lost a lot of hacks during my upgrade to the publishing suite and this was one of the most important ones. Thanks for all your work.

Ted S

08-29-2010 09:20 PM

Quote:

Originally Posted by yahwehpassim (Post 2090680)

The 4.0 version is good for 4.0.

TitanJeff

08-30-2010 11:33 PM

Quote:

Originally Posted by okhissabigfish (Post 1569564)

Idea:

When the message appears the backgound fades and the notice is on top. Then the visitor has to clear the message to bring the site back up or can bring it back up by hitting the Register Now link in the body of the message.

:)

Anyone ever figure out a way to make this happen? I'd just be happy to have it open the message in a window over the forum that the viewer either has to close or register. Thanks.

SpyCam

12-02-2010 08:01 AM

With database loging on, non registerred users can't open threads, they can see the listing, but can't open threads as they are getting a database error:

Code:

Database error:

The database has encountered a problem.

I also get such DB error emails:

Code:

Database error in vBulletin 3.8.6:



Invalid SQL:



                                                        INSERT INTO lgv SET 

                                                        ipaddress =  '79.142.126.22',

                                                        firstaccess  = 1291283798,

                                                        views = views + 1,

                                                        lastactivity = 1291283798;



MySQL Error   : Duplicate entry '65535' for key 1

Error Number  : 1062

Request Date  : Thursday, December 2nd 2010 @ 10:56:38 AM

Error Date    : Thursday, December 2nd 2010 @ 10:56:38 AM

Script        : http://www...com/.../...html

Referrer      : http://www...com/.../

IP Address    : 79.142.126.22

Username      : Unregisterred

Classname     : vB_Database

MySQL Version :

Please tell me how to fix that.
Thanks

nlwin

03-04-2011 05:52 PM

How do I change header bar "Notices" to some thing else?

blackberry

05-13-2011 03:08 PM

i want to set it for Users Awaiting Email Confirmation

where i should make changes?

J517E7B2F4A5

08-09-2011 01:31 PM

Hey sorry if i disturb i see there's 2 zip file for the 3.7 wich one is the right one ?

Than you sorry for disturb:erm:

SCRIPT3R

10-11-2011 07:27 AM

Possible to apply this to another usergroup?

Ted S

10-11-2011 08:52 PM

Quote:

Originally Posted by SCRIPT3R (Post 2255827)

Possible to apply this to another usergroup?

With minor code hacking, yes

Ted S

10-11-2011 08:53 PM

Quote:

Originally Posted by blackberry (Post 2195128)

i want to set it for Users Awaiting Email Confirmation

where i should make changes?

To the php code in the XML file. If you are not familiar with basic code hacking you should only try this on a development server.

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

Page 10 of 11

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01740 seconds Memory Usage 1,857KB 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 (8)bbcode_code_printable (1)bbcode_html_printable (18)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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
Messages: