S2OJ/web/app/upgrade/40_contest_resources/upgrade.php

38 lines
732 B
PHP
Raw Permalink Normal View History

2023-02-12 13:55:03 +00:00
<?php
return function ($type) {
if ($type == 'up_after_sql') {
DB::init();
$contests = DB::selectAll("select * from contests");
foreach ($contests as $contest) {
$extra_config = json_decode($contest['extra_config'], true);
if (isset($extra_config['links'])) {
$new_links = [];
foreach ($extra_config['links'] as $link) {
if (isset($link['name'])) continue;
$new_links[] = [
'name' => $link[0],
'url' => '/blogs/' . $link[1],
];
}
$extra_config['links'] = $new_links;
}
DB::update([
"update contests",
"set", [
"extra_config" => json_encode($extra_config, JSON_FORCE_OBJECT),
],
"where", [
"id" => $contest['id'],
],
]);
}
}
};