Miscellaneous Hacks - AgeLock v3.5

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


Change log
+ Added support for CMS (Blog locking is there but not usable (99.9% sure blog locking is prob. pointless, since all users would be able to age restrict posts))
+ Enable/Disable Guest Viewing of age locked forums
+ Moved Age Lock core from outdated hook (global_start) to new (global_bootstrap_init_start)
+ Removed defunct Error message
+ Added abillity to re-enable Date of Birth Editing for all users
+ Fixed Bug where Date of birth editing is still disabled for users who are exempt from Age Lock
+ Reworded Default Age Lock Messages
+ Added support for multi-level forum locking using parent lock state (instead of parent-->forum, now parent-->forum-->subforum-->..)
+ Removed over zelus agelock checking (No more queries to get lock state)
+ Removed vb 3.x support

3.5a Fixes
+ Fixed CMS bugs (missing table prefix)
+ Updated template edit to work with Vb 4.1.5

3.5b Fixes
+ Really fixes the CMS bugs (Sorry )

Please be aware although support is provided it is limited. This version is in beta so expect bugs!

enjoy

Stuie

[m1thr0s]

absolutely love this mod - thanks for putting the work into it!

[EdQ]

Has anyone been able to promote an Article while its enabled?

I get an error on this update. It doesn't seem to know the prefix of the table name

PHP Code:

UPDATE cms_article SET agelock='', agelock_method='',agelock_age='' WHERE contentid='134'; 


[stuie_b]

Originally Posted by EdQ

I get an error on this update. It doesn't seem to know the prefix of the table name

EDIT: The fix didnt really fix the CMS bug, There was a change to the way the articles are handled and agelock went the wrong way i've found the bug and fixed it this time (i promise)

Because there is a database change to make it work with 4.1.5 you will need to reinstall agelock (3.5b)

Appologies for the cock up

Stuie

[Hostboard]

The version number in the plugin & product system still shows 3.5a

BTW this modification was a godsend for me. Thank you!

[EdQ]

Installing over it didn't work.
This is when I tried to promote an Article

PHP Code:

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE xxx_cms_node SET agelock='', agelock_method='',agelock_age='' WHERE nodeid='135';

MySQL Error   : Unknown column 'agelock' in 'field list' 


So I tried to uninstall and got this

PHP Code:

Database error in vBulletin 4.1.5:

Invalid SQL:
ALTER TABLE xxx_forum DROP `agelock` ,
DROP `agelock_parent` ,
DROP `agelock_method` ,
DROP `agelock_age`;

MySQL Error   : Can't DROP 'agelock'; check that column/key exists 


[EdQ]

BTW, it did promote the Article.

[Hostboard]

Saw this was updated again today. Installed, set to over write... Got error... System still shows 3.5a

Database error in vBulletin 4.1.3:

Invalid SQL:
ALTER TABLE forum ADD agelock INT(1) DEFAULT '0';

MySQL Error   : Duplicate column name 'agelock'
Error Number  : 1060
Request Date  : Friday, August 5th 2011 @ 09:16:09 PM
Error Date    : Friday, August 5th 2011 @ 09:16:09 PM
Script        : http://www.MyDomain.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.MyDomain.com/forums/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : UserID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

[stuie_b]

Originally Posted by Hostboard

Saw this was updated again today. Installed, set to over write... Got error... System still shows 3.5a

The package was updated to reflect the correct version build! (3.5b) within an hour of your original post, However version info is irrelevant, The version number is for my internal use, it doesn't hold any weight within Agelock it's self.

Originally Posted by Hostboard

Database error in vBulletin 4.1.3:

Invalid SQL:
ALTER TABLE forum ADD agelock INT(1) DEFAULT '0';

MySQL Error   : Duplicate column name 'agelock'
Error Number  : 1060
Request Date  : Friday, August 5th 2011 @ 09:16:09 PM
Error Date    : Friday, August 5th 2011 @ 09:16:09 PM
Script        : http://www.MyDomain.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.MyDomain.com/forums/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : UserID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

Due to the fact AgeLock 3.5 is NOT considered upgrade safe at the moment there is NO upgrade instructions! you must perform a full reinstall (uninstall and re-install) on major changes like this.

However in an effort to help everyone upgrade to the latest build without the need to re-apply each and every lock state I've attached a version of agelock which will perform the db changes needed for 3.5b, Which will hopefully address this problem.

1. Goto  ADMINCP --> Plugins & Products -->Manage Products --> Add/Import Product
2. Select "product-aglk35b (CMS Edition) UPGRADE ONLY" from the agelock package
3. Set to overwrite
4. Import
5. Upload install/agelock_upgrade.php to your vbulletin root
6. goto install/agelock_upgrade.php
7. Remove install folder

Note: The upgrade package is simply Age Lock with the Database change for vb 4.1.5, Uninstalling the upgrade pack WILL remove all traces of age Lock not just the upgrade, If your installing a fresh use "product-aglk35b (CMS Edition)"

Note2: Age Lock version 3.5b is only needed for suite editions of vbulletin. Age Lock 3.5 is fully functional for current builds of vbulletin's Forum edition (upto 4.1.5pl1).

Stuie

[Hostboard]

Thank you for the explaination and more importantly thank you for your support and furthering this modificaiton.

[sbelle731]

I am having the issue where our members are not able to set the privacy for their birthdates. I know this mod prevents them from editing the date of birth, but does it also prevent them from displaying it as well? Any usergroup excluded from the agelock mod does not have this problem.

A few weeks ago, our forum crashed and we've had to reupload several mods because of it. I'm just not sure if the issue I'm having is a feature of the Age Lock mod, or if it is something else that is still screwed up LOL. I don't want to run around trying to fix something that isn't broke.