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

[Hostboard]

I used your upgrade file to 3.5b and it worked.
I tried to set a forum to age lock and it threw a DB error. I tried to uninstall and start fresh and it threw a DB error. Sorta stuck...

Here is the uninstall error:

Database error in vBulletin 4.1.3:

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

MySQL Error   : Can't DROP 'agelock'; check that column/key exists
Error Number  : 1091
Request Date  : Monday, August 8th 2011 @ 10:20:22 PM
Error Date    : Monday, August 8th 2011 @ 10:20:22 PM
Script        : http://www.MyDomain.com/forums/admincp/plugin.php?do=productkill
Referrer      : http://www.MyDomain.com/forums/admincp/plugin.php?do=productdelete&productid=aglk35&s=
IP Address    : xxx.xxx.xxx.xxx
Username      : UserID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

Here is the error when I try to set a forum to age lock:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE forum SET
    title_clean = 'Adults',
    title = 'Adults',
    description_clean = '',
    description = '',
    link = '',
    displayorder = 1,
    parentid = 8,
    daysprune = -1,
    defaultsortfield = 'lastpost',
    defaultsortorder = 'desc',
    showprivate = 0,
    newpostemail = '',
    newthreademail = '',
    ### Bitfield: forum.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 16, options - 16, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 32768, options - 32768, options),
        options = IF(options & 8192, options, options + 8192),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 16384, options, options + 16384),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options, options + 128),
        options = IF(options & 512, options, options + 512),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options, options + 4096),
        options = IF(options & 65536, options, options + 65536),
        options = IF(options & 131072, options - 131072, options),
    styleid = 0,
    imageprefix = '',
    password = '',
    vbseo_enable_likes = 1,
    vbseo_moderatepingbacks = 1,
    vbseo_moderatetrackbacks = 1,
    vbseo_moderaterefbacks = 1,
    xx_owner = 0,
    xx_ownername = '',
    xx_deletion = 0,
    xx_validparent = 1,
    xx_views = 0,
    agelock = '1',
    agelock_age = '18',
    agelock_method = '0'
WHERE forumid = 55;

MySQL Error   : Unknown column 'agelock' in 'field list'
Error Number  : 1054
Request Date  : Monday, August 8th 2011 @ 10:24:29 PM
Error Date    : Monday, August 8th 2011 @ 10:24:29 PM
Script        : http://www.MyDomain.com/forums/admincp/forum.php?do=update
Referrer      : http://www.MyDomain.com/forums/admincp/forum.php?do=edit&f=55
IP Address    : xxx.xxx.xxx.xxx
Username      : UserID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

[HMBeaty]

Looks to me like it didn't even create the column agelock

[Hostboard]

I also did run the php file in the install directory and it said upgrade successful.

[Hostboard]

Stuie, thank you for taking the time to trouble shoot my problem with AgeLock. Support like this is unprecedented and rarely matched.

Thank you...

[EdQ]

Still get this when I post an article

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

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

[stuie_b]

Originally Posted by 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 


Both errors are because agelock isn't installed correctly, the fields necessary for agelock to function dont exist.

If you have access to phpmyadmin manually confirm this before trying the following. (Making sure that all agelock fields dont exist! - forum,blog,cms_node)
If they dont exist you have 2 options


* Edit the agelock product in vb and remove the uninstall code, then uninstall agelock before installing agelock with "product-aglk35b (CMS Edition).xml"

-or-

* Re-create the fields via phpmyadmin using the sql code below. (replacing " . TABLE_PREFIX . " with your tables prefix)

ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_parent INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "forum ADD agelock_age varchar(10);

ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "blog ADD agelock_age varchar(10);

ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock_method INT(1) DEFAULT '0';
ALTER TABLE " . TABLE_PREFIX . "cms_node ADD agelock_age varchar(10);

If they do exist
* Check all the agelock fields exist (forum,blog,cms_node)

If it is missing the fields on certain tables you can either

* Remove the fields from the tables that do have the fields and then perfom option 1 from above

* Re-create the missing fields using the SQL code above.

None of the fields exist on any tables

* Edit the agelock product in vb and remove the uninstall code, then uninstall agelock before installing agelock with "product-aglk35b (CMS Edition).xml"

If you opt to re-create the fields then agelock will function as it should, However to prevent any issues elsewhere i would recommend re-installing age lock using "product-aglk35b (CMS Edition).xml"

Stuie

[EdQ]

I did this

* Re-create the missing fields using the SQL code above.

I don't get that error anymore.

Could not re-install because it told me the field was there.
So un-installed and re-installed.
So far so good.

[8thos]

Interesting.

[tbl33]

I just installed a fresh copy of vBulletin 4.1.6. Will this Mod work with the latest version of VB?

[Scyther]

good mod.

marked installed.