<?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();