<?php
require "../base.php";
require_once PATH_APP . "/extra/func.save_user_backup";
global $_base;
access::need("admin");
$_base->page->add_title("User backup");
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$file = save_user_backup();
$_base->page->add_message("User backup saved to <b>{$file}</b>");
redirect::handle();
}
echo '
<h1>User backup</h1>
<form action="" method="post">
<p>
<input type="submit" value="Lagre backup" />
</p>
</form>';
$_base->page->load();
$last0 = 0;
$last1 = 0;
foreach ($rentetabell as $row) {
if ($last1 != 0) {
// gi renter for denne prisgruppen
\Kofradia\DB::get()->exec("\n\t\t\tUPDATE users_players\n\t\t\tSET up_interest_last = up_interest_last + LEAST(CAST(up_bank AS SIGNED) - {$row[0]}, {$last0} - {$row[0]}) * {$last1},\n\t\t\t\tup_bank = up_bank + LEAST(CAST(up_bank AS SIGNED) - {$row[0]}, {$last0} - {$row[0]}) * {$last1}\n\t\t\tWHERE up_access_level != 0 AND up_bank > {$row[0]} AND up_last_online >= {$last_online}");
}
$last0 = $row[0];
$last1 = $row[1];
}
// lagre backup
save_user_backup();
\Kofradia\DB::get()->exec("\n\tUPDATE users_players\n\tSET up_interest_total = up_interest_total + up_interest_last, up_interest_num = up_interest_num + 1, up_log_new = up_log_new + 1\n\tWHERE up_interest_last > 0");
// lås opp brukertabellen
\Kofradia\DB::get()->exec("UNLOCK TABLES");
// lagre logg melding
\Kofradia\DB::get()->exec("\n\tINSERT INTO users_log (time, ul_up_id, type, note, num)\n\tSELECT {$time}, up_id, " . gamelog::$items['renter'] . ", NULL, up_interest_last\n\tFROM users_players\n\tWHERE up_interest_last > 0");
// finn ut hvor mye renter som ble gitt
$result = \Kofradia\DB::get()->query("\n\tSELECT COUNT(up_id), SUM(up_interest_last)\n\tFROM users_players\n\tWHERE up_interest_last > 0 AND up_access_level < " . ess::$g['access_noplay']);
$row = $result->fetch(\PDO::FETCH_NUM);
$ant = game::format_number($row[0]);
$sum = game::format_cash($row[1]);
putlog("INFO", "%bRENTER:%b %u{$ant}%u spillere mottok renter! Totalt %u{$sum}%u ble gitt ut i form av renter!");
// renter gitt til nostat
$result = \Kofradia\DB::get()->query("\n\tSELECT COUNT(up_id), SUM(up_interest_last)\n\tFROM users_players\n\tWHERE up_interest_last > 0 AND up_access_level >= " . ess::$g['access_noplay']);
$row = $result->fetch(\PDO::FETCH_NUM);
$ant = game::format_number($row[0]);
$sum = game::format_cash($row[1]);
putlog("CREWCHAN", "%bRENTER-NOSTAT:%b %u{$ant}%u spillere mottok renter! Totalt %u{$sum}%u ble gitt ut i form av renter!");
save_user_backup();
