Installed and working great.

this is pure freeekin genius!

I would like to add stylevar for the error message to style it. How can I do it please?

The error message uses the default vBulletin error template which you can modify as you see fit through your template manager but it will impact all errors.

Alternatively you can add HTML to the error message phrase.

Thank Ted S, How about the reminder message? Where I can Style it please?

It uses the notice template and a phrase.

The best way to find mod elements is always to search the phrases, find the right one and then find the template it's in.

Nice.... I like it! Installed

Thank you very much..

Not working on 4.1.11 unfortunately. :(

It's really really really hard to do anything only knowing that it's "not working".

What exactly is happening or not happening?

Sorry mate, forgot to do the template edit on my updated style :(:down:
Sorry.

Also i got my edits to work so that it would show if members of a certain usergroup didnt upgrade to a subscription, instead of guests registering. :D

Its not working for me on 4.1.10....any support please.

I hate to sound like a broken record but no one can offer you support when the details of your issue are simply "it's not working".

works fine with 4.1.11 and worked with 4.1.10 to

Works fine with 4.2.x

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.lgv' doesn't exist in [path]/includes/class_core.php on line 1391
Updated ID Field


Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.lgv' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'TYPE=MyISAM' at line 9 in [path]/includes/class_core.php on line 1391

When I use that additional one you added I get the same error:

Database error in vBulletin 4.2.0:

Invalid SQL:
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;

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 'TYPE=MyISAM' at line 9
Error Number : 1064
Request Date : Thursday, June 7th 2012 @ 10:03:27 PM
Error Date : Thursday, June 7th 2012 @ 10:03:27 PM
Script : http://********/admincp/plugin.php?do=productimport
Referrer : http://********/admincp/plugin.php?do=productadd
IP Address : ******************
Username : ***
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55

Does your mySQL server not use MyISAM?

Don't know my mate uses HostGator.

Edit:

(4:50:00pm)Ezekiel K.:Our MySQL servers use innodb instead of MyISAM.

vBulletin has generally assumed MyISAM but this is not a big deal. Simply remove the Type=MyISAM bit leaving ); in the query / xml file.

Thank you :D yey

Hey Tom great Mod... been using this mod for over 3 years and love it. Great job my friend! Question what do I need to replace to get this to work with registered members. Looking at your code I cannot for the life of me figure this out! I know that non reg is 1 and my registered is 2, could you please let me know where to make these changes in the code and does it also need to be done in MySQL...if so where? Any help would be appreciated. Thanks again.

Ross

Tom? We've got an Andrew, a Drew, but no Tom's around here to pass your remarks on to... :confused:

As far as your question, if you want to limit how registered members see threads you'd essentially be taking the base code and rewriting the check functionality to switch from guest to a usergroup check. You can find the aproppriate functions in the vBulletin documentation.

Thanks for all your smart ass help TED! TEDDY! EDWARD! EDWARDO! UN-Installed. I'll rewrite the whole thing and post it. One word of advice...be very careful who you insult, especially when you have NO IDEA who you are insulting.

I think you have seriously misinterpreted his response if you think that was an insult. The smiley alone shows he's just palling around. Lighten up.

What insult? Now I'm even more confused.

Anyways to each their own. But if you do decide to create a better version of this idea I certainly do hope you share it with the community. That's the point of this all, right?

I get database error when I try to install on 4.1.12.
I even used the updated one from page one as well. no dice.

thanks :D i had the same error and that worked. I could easily enable MyISAM but i was being lazy so just removed type=MyISAM :D

InnoDB is a better option anyways :D

Change: TYPE=MyISAM to Engine=MyISAM
Works for Mysql 5 plus
HTH

Thanks Installed :)

Hey LGV users!

It's been a while since we've had an update for the mod and today's release of 2.1.0 is one part functionality, one part compatibility...

- Adds basic usergroups limiting just like guests get
- Adds option to enable/ disable guest blocking
- Removes requirement for template edits
- Removes references to MyISAM to support mySQL 5.5 and above
- Updates search bot list and checking process

Of course if there's other features you'd like to see please chime in.

Fixed in version 2.1.0 - MyISAM is not required so we'll default to whatever your mySQL install uses.

This is a great mod! I'm really hoping this will up our registration. Question, if you go to our site http://www.mathhelpboards.com/thread...Welcome-to-MHB as a guest the guest message appears but it's not in the yellow background that other notices are? What CSS option can I change for this?

You would need to change the output template to wrap it into whatever css attribute you want. The template is limited_guest_viewing

Thank you! Why isn't it showing in the same color as your example pictures (grey)? I would actually prefer that color so it doesn't look too monotonous but it's showing up without wrapping at all.

I tried using the following css in additional.css but nothing changed unfortunately.

Because on that test forum the template uses a css element defined elsewhere... You'll need to find the right attribute to assign to this one... using firebug in the firefox browser can give you a head start.

It is imcompatible with 4.2 ? any other similiar mod which is compatible .

Thanks :)

Working Fine on 4.2 for me mate

That a mod is not working on your install does not mean it is incompatible with a version. LGV is live and working fine on many, many 4.2 installs.

installed and exactly what is needed on my board

Kudos, it allows a great teaser to potential new members

Thanks again

Chief (a non-stat measuring forum admin)

I've tried and can't find it. I'm not just being lazy and I don't want to waste your time.

Anyone willing to look into this? I'm willing to send you something small for your time if need be.