mirror of
https://github.com/torrentpier/torrentpier-lts.git
synced 2025-02-28 15:10:54 +03:00
36 lines
1.4 KiB
PHP
36 lines
1.4 KiB
PHP
<?php
|
|
|
|
define('IN_FORUM', true);
|
|
define('BB_ROOT', './');
|
|
require(BB_ROOT . 'common.php');
|
|
|
|
$user->session_start();
|
|
|
|
set_die_append_msg();
|
|
if (!IS_SUPER_ADMIN) bb_die($lang['ONLY_FOR_SUPER_ADMIN']);
|
|
|
|
$confirm = request_var('confirm', '');
|
|
|
|
if ($confirm) {
|
|
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 = bb_date($row['user_birthday_old'] * 86400 + 1, 'Y-m-d', 0);
|
|
DB()->query("UPDATE ". BB_USERS ." SET user_birthday = '". $birthday ."' WHERE user_id = ". $row['user_id'] ."");
|
|
}
|
|
|
|
DB()->query("ALTER TABLE ". BB_USERS ." DROP user_birthday_old");
|
|
|
|
bb_die('<h1 style="color: green">База данных обновлена</h1>');
|
|
} else {
|
|
$msg = '<form method="POST">';
|
|
$msg .= '<h1 style="color: red">!!! Перед тем как нажать на кнопку, сделайте бекап базы данных !!!</h1><br />';
|
|
$msg .= '<input type="submit" name="confirm" value="Начать обновление Базы Данных (R496)" style="height: 30px; font:bold 14px Arial, Helvetica, sans-serif;" />';
|
|
$msg .= '</form>';
|
|
|
|
bb_die($msg);
|
|
} |