Force members to enter birthday

[aacircle]

Hello,

I have just enabled the birthday field to be mandatory. I know that members will HAVE to now enter their birthday when updating their profiles. However, is it possible to FORCE members to enter their b'day even before they make their next post?

Thank you.

[Jose Amaral Rego]

Before running any queries on your live forum, do create and test your database backup
You can find them all then send a private message and do not see another method to force your member(s) to do anything, unless you resend passwords for them to login and then they would have to enter birthdate.

 
SELECT username, birthday FROM user WHERE birthday = 0000-00-00

AdminCP > vBulletin Options > User Profile Options > Require Date of Birth > Yes


FAQ: What you need to know about running queries

Create at least two working database backups before attemping to Executing Queries.

• How to make a backup of vbulletin board database
• Upload and place your vBulletin version behind .htaccess and play with it, test hacks and add your template modification.
• Test all your Catagories, Forums, Threads, Posts, User Cp, Adminastrative / Moderator board functions.
• List all your hacks on a piece of paper, then visit www.vbulletin.org and find those edit and make sure they are working.

Backup tools if you do not have SHH access from your host.

• http://www.ozerov.de/bigdump.php
• http://www.mysqldumper.de/en/index.php

What is .htacces

• .htaccess .htaccess .htaccess

Use the Update Counters if ask to after Execute SQL Query is completed.


So please ask lots and lot of question before executing these queries on your forum's database.

Queries posted here are from members, vBulletin.com and vBulletin.org Staff that posted in these forums and are not to be taken likely, as these can have irreversible affects to your forums database.


vBulletn version 3.5Updating Options En Masse with Queries
vBulletn version 3.6Updating Options En Masse with Queries