コード例 #1
0
// Hmmm, gets rid of all status effects, we may want to make that not have that limit, some day.
$affected_rows['Statuses Removed'] = $sql->a_rows;
$deleted = shorten_chat($sql);
// run the shortening of the chat.
$affected_rows['deleted chats'] = $deleted;
$stats = membership_and_combat_stats($sql, $update_past_stats = true);
$affected_rows['Vicious killer: '] = $stats['vicious_killer'];
//$sql->Update("DELETE FROM mail WHERE send_to='SysMsg'");  //Deletes any mail directed to the sysmsg message bot.
//Nightly Unconfirm old players script settings.
$unconfirmed = unconfirm_older_players_over_minimums($keep_players_until_over_the_number, $days_players_have_to_be_older_than_to_be_unconfirmed, $maximum_players_to_unconfirm, $just_testing = false);
assert($unconfirmed < 21);
$affected_rows['Players Unconfirmed'] = $unconfirmed === false ? 'Under the Minimum number of players' : $unconfirmed;
// Delete from inventory where owner is unconfirmed or non-existent.
$sql->QueryRow("Delete from inventory where owner in (SELECT owner FROM inventory LEFT JOIN players ON owner = uname WHERE confirmed = 0 OR uname is null GROUP BY owner)");
$affected_rows['deleted items'] = $sql->a_rows;
$deleted_mail = delete_old_messages($sql);
// As per the mail function in lib_deity.
$affected_rows['Old Messages Deletion'] = $deleted_mail;
$sql->Delete("delete from levelling_log where killsdate < now()- interval '3 months'");
$affected_rows['levelling log deletion'] = $sql->a_rows;
// Keep only the last 3 months of logs.
$sql->Delete("delete from dueling_log where date != cast(now() AS date) AND date != cast(now() AS date)-1");
// Keep only the last two days of duels.
$affected_rows['dueling log deletion'] = $sql->a_rows;
$sql->Delete("delete from players where confirmed = 0 and level = 1");
// Delete old level 1's.
$affected_rows['old level 1 players deletion'] = $sql->a_rows;
$logMessage .= "DEITY_NIGHTLY: Deity reset occurred at server date/time: " . date('l jS \\of F Y h:i:s A') . ".\n";
$logMessage .= 'DEITY_NIGHTLY: Mail deleted: (' . $affected_rows['Old Messages Deletion'] . ")\n";
$logMessage .= "DEITY_NIGHTLY: Items: " . $affected_rows['deleted items'] . "\n";
$logMessage .= 'DEITY_NIGHTLY: Players unconfirmed: (' . $unconfirmed . ").  30 is the current default maximum.\n";
コード例 #2
0
ファイル: deity_nightly.php プロジェクト: NinjaWars/ninjawars
$affected_rows['Statuses Removed'] = $status_removal->rowCount();
$deleted = shorten_chat();
// run the shortening of the chat.
$affected_rows['deleted chats'] = $deleted;
update_most_vicious_killer_stat();
// Update the vicious killer stat.
//Nightly Unconfirm old players script settings.
$unconfirmed = unconfirm_older_players_over_minimums($keep_players_until_over_the_number, $days_players_have_to_be_older_than_to_be_unconfirmed, $maximum_players_to_unconfirm, $just_testing = false);
assert($unconfirmed < $maximum_players_to_unconfirm + 1);
$affected_rows['Players Unconfirmed'] = $unconfirmed === false ? 'Under the Minimum number of players' : $unconfirmed;
// Delete from inventory where owner is unconfirmed or non-existent.
$deleted_items = DatabaseConnection::$pdo->query("DELETE FROM inventory WHERE owner IN (SELECT owner FROM inventory LEFT JOIN players ON owner = player_id WHERE uname IS NULL GROUP BY owner)");
$affected_rows['deleted items'] = $deleted_items->rowCount();
$deleted_items = DatabaseConnection::$pdo->query("delete from levelling_log where killsdate < (now() - interval '2 months')");
$affected_rows['deleted levelling_logs'] = $deleted_items->rowCount();
$deleted_mail = delete_old_messages();
// As per the mail function in lib_deity.
$deleted_events = delete_old_events();
$affected_rows['Old Messages Deletion'] = $deleted_mail;
$level_log_delete = DatabaseConnection::$pdo->query("delete from levelling_log where killsdate < now()- interval '3 months'");
$affected_rows['levelling log deletion'] = $level_log_delete->rowCount();
// Keep only the last 3 months of logs.
$duel_log_delete = DatabaseConnection::$pdo->query("delete from dueling_log where date != cast(now() AS date) AND date != cast(now() AS date)-1");
// Keep only the last two days of duels.
$affected_rows['dueling log deletion'] = $duel_log_delete->rowCount();
$level_1_delete = DatabaseConnection::$pdo->query("delete from players where active = 0 and level = 1 and created_date < (now() - interval '5 days')");
// Delete old level 1's.
DatabaseConnection::$pdo->query('COMMIT');
$affected_rows['old level 1 players deletion'] = $level_1_delete->rowCount();
$logMessage .= "DEITY_NIGHTLY: Deity reset occurred at server date/time: " . date('l jS \\of F Y h:i:s A') . ".\n";
$logMessage .= 'DEITY_NIGHTLY: Mail deleted: (' . $affected_rows['Old Messages Deletion'] . ")\n";