[3.3.1] Registration Age

[devspace]

Registration Age:

Adds an option to enter a birthdate upon registration and to check that the date is equal to, or greater, than a minimum age.

Compatibility:





Notes:

If you are using any other version of this extension then it must be Disabled /Delete data and the original files deleted before installing this version - you will loose all settings.

Features:

• Minimum age selectable.
• Log failed attempts.
• Ban the IP address for failed attempts (time limit selectable).
• Store the registration birthdate in the database.
• Auto copy the registration birthdate to the user's profile birthdate.
• ACP report comparing actual and registered birthdates.
• Option to display age in mini profile.

Language(s):

• en

Version:

• 3.3.1

Installation:

• Download the latest release and unzip it.
• Upload the unzipped files to [board root]/ext/devspace/registrationage and enable it in the ACP

Configuration:

• ACP
• Extensions
• Registration Age
• Manage registration age

Useage:

• ACP
• Users and groups
• User utilities
• Registration age

Extension Download:

[devspace]

Announcements:
[16/11/2022] Updated to 3.3.1 - error in migration file fixed.

[Niek]

Hello,

I made the Dutch translation for this extension.

[devspace]

I made the Dutch translation for this extension.

Thanks

[wads24]

I just upgraded to this news version deleted the old version that you no longer support and still got the error message when I clicked on registration age under user utilities

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'username_clean' in 'field list' [1054]

SQL

SELECT user_id, username, username_clean, user_birthday, user_colour, user_registration_birthdate FROM phpbb_ailabs_users WHERE user_type <> 2 ORDER BY username_clean ASC LIMIT 25

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/devspace/registrationage/controller/data_controller.php
LINE: 147
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/devspace/registrationage/acp/registrationage_data_module.php
LINE: 29
CALL: devspace\registrationage\controller\data_controller->display_output()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: devspace\registrationage\acp\registrationage_data_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

[devspace]

That error does not make any sense - can you check that you have that column in the users table as that is a phpBB default column.

[wads24]

I didn't understand the error either, but I did figure out that it was the AI labs extension that was causing it. So, I disabled that, and it resolved the error.

[devspace]

it was the AI labs extension that was causing it.

I don't know that extension but it seems a bit strange that it would affect a db column - I wonder what else it does?

[wads24]

@devspace

Would it be possible to change this from a text field to a dropdown for the date of birth?

I have noticed that users are able to enter numbers that are in an invalid format for the date of birth, and so if I copy the registration date of birth to a user's date of birth, the value isn't the same.

---

[kushcat420]

when i click the settings link under extensions it doesn't load the page to change any of the settings im on 3.3.15

[devspace]

when i click the settings link under extensions it doesn't load the page to change any of the settings im on 3.3.15

I am not seeing that problem.

Sounds as if it may not have installed correctly - try disabling, delete data, uninstall and then reinstall.

[kushcat420]

thanks i deleted reinstalled and it works

[kushcat420]

what does the verbose message setting do

[devspace]

what does the verbose message setting do

It will display a detailed message if there is an error or not display any message. For example it will give an error message saying that the minimum age is, say, 18 which would then inform whoever is trying to register what to change their date of birth to or it displays nothing leaving them to keep guessing

[kushcat420]

What is the point of store in database setting? I just enabled copy to birthday setting doesn't that still copy to database?

[devspace]

What is the point of store in database setting?

It will store in the database the dob that the user entered here upon registration.

I just enabled copy to birthday setting doesn't that still copy to database?

Yes but that will copy the dob to the "user_birthday" field in the "users" table which the user can, vis the UCP, change any time they wish.

The reason is twofold - firstly depending on your country's privacy laws storing the dob without permission may not be allowed and secondly the ACP comparison report will show both dobs, if present, to enable checking that the user does not try to circumvent age restrictions.

The recommended settings would be to store in the database but not to copy to the birthday setting.

[kushcat420]

what about date format

[devspace]

what about date format

What about it?

[kushcat420]

whats the difference betwen user and db

[devspace]

whats the difference betwen user and db

User is the member. db is the database

[kushcat420]

i changed to user, and went to register an account and it still asked the birthdate in the same format as the other setting did