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