Age Lock Hack

UPDATE: Updated the code to work with latest versions (both stable and beta)

----------------------
Whats it all about?
----------------------
Age Lock is an all-in-one Forum locking facillity that works off the users age instead of there permissions
It gives you the abillity to keep those Under 18's out of your adult section

IMPORTANT NOTICE: Please Make sure you uninstall any currently installed versions prior to
installing this version!! THIS IS A MUST DUE TO MAJOR CODE CHANGES!

---------------
Installaiton?
---------------

- Log into you Admin Control Panel -
#############################################
-----------------------------------------------
1.) Upload the contents of the Upload folder to your forum root
2.) Find Plugin System
3.) Click Manage Products
4.) Click [Add/Import Product]
5.) Under Import Product
6.) Select the Product-AgeLock.xml file
7.) Make sure Allow Overwrite is turned OFF!
8.) Press Import
-----------------------------------------------

Total Template edits: 1
Total File Modifications: 0
Total Plugins: 1
Total Hooks Used: 6
Total extra sql querys: 0

Make sure to read the txt files before installing!!!
limited support will be provided!

enjoy and dont forget to click install

Stuie B

[Mastar]

I'm sorry to say that it still doesn't work. Still getting the DB error. I edited the template again and uploaded the product.

[stuie_b]

can you tell me if there is only one uninstall/install code when you edit the plugin

cheers

[Mastar]

Originally Posted by stuie_b

can you tell me if there is only one uninstall/install code when you edit the plugin

cheers

Install Code:

require_once('./global.php');
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum ADD age_locked ENUM('0','1') DEFAULT '0'");
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum ADD age_type ENUM('0','1') DEFAULT '0'");
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum ADD age_value varchar(10) DEFAULT ''");
$db->query("INSERT INTO " . TABLE_PREFIX . "phrase (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES ('', '-1', 'ageincorrect', 'Sorry but this forum has been age locked, <br>You seem to be too young to view this forum!!', '1000')");

Uninstall Code:

require_once('./global.php');
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN age_locked");
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN age_value");
$db->query("ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN age_type");
$db->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname='ageincorrect'");

[Mastar]

New error I found after I install Gallery and try to create a Category:

Fatal error: Field age_locked is not defined in $validfields in class vb_datamanager_forum in /includes/class_dm.php on line 485

And this hack will not delete. Getting a DB error:

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE forum DROP COLUMN age_locked;

MySQL Error  : Can't DROP 'age_locked'. Check that column/key exists
Error Number : 1091
Date         : Monday, November 21st 2005 @ 04:42:01 AM
Script       : http://www.******.com/admincp/plugin.php
Referrer     : http://www.********.com/admincp/plugin.php?do=productdelete&productid=AgeLimit&s=
IP Address   : *******
Username     : *****
Classname    : vb_database

Any thoughts?

[stuie_b]

It's because the plugin hasn't been installed correctly for some reason it is'nt installing it for you???

To uninstall the plugin, edit the plugin and remove the uninstall code, save it and then retry the uninstall

cheers

stuie

[Mastar]

Originally Posted by stuie_b

It's because the plugin hasn't been installed correctly for some reason it is'nt installing it for you???

To uninstall the plugin, edit the plugin and remove the uninstall code, save it and then retry the uninstall


cheers


stuie

Kool it is uninstalled.

[KBV]

Works on my site, but only for people who are older. If I want a forum that is for people 15 and under, it allowes people 15 and over to post, but not below. Yes, I have tried changing the 0 and 1 thing.

[stuie_b]

Originally Posted by KBV

Works on my site, but only for people who are older. If I want a forum that is for people 15 and under, it allowes people 15 and over to post, but not below. Yes, I have tried changing the 0 and 1 thing.

thanks for the notification i've re-written the code and have also removed the install/uninstall code from the plugin and added an external installer to see if that will fix the problems with the fields not being created correctly in the database


cheers


Stuie B

[KBV]

Thank you, it works perfect now. Great work Stuie!

[KBV]

The mod is letting people not of the given age into the forums that have a lock. I've observered several 15-17 year olds in my 18+ forum. Not posting, but luriking, because posting would get them banned.

Anyone else see this behaviour?