<?php

define('BB_ROOT', './');
require(BB_ROOT .'common.php');

$user->session_start();

if (!IS_ADMIN)
{
	message_die(GENERAL_MESSAGE, $lang['NOT_ADMIN']);
}

set_time_limit(600);

DB()->query("ALTER TABLE ". BB_USERS ." CHANGE COLUMN user_birthday user_birthday_old int(11) NOT NULL DEFAULT 0 AFTER user_gender");
DB()->query("ALTER TABLE ". BB_USERS ." ADD user_birthday date NOT NULL DEFAULT '0000-00-00' AFTER user_gender");

$sql = "
	SELECT user_id, user_birthday_old
	FROM ". BB_USERS ."
	WHERE user_birthday_old != 0
	AND user_id NOT IN ('". EXCLUDED_USERS_CSV ."')
";

foreach (DB()->fetch_rowset($sql) as $row)
{
	$birthday = realdate($row['user_birthday_old'], 'Y-m-d');
	DB()->query("
		UPDATE ". BB_USERS ."
		SET user_birthday = '". $birthday ."'
		WHERE user_id = ". $row['user_id'] ."
	");
}
echo 'Done!';
?>