$logged_in = login_user(in('user'), in('pass', null, 'toPassword')); $is_logged_in = $logged_in['success']; if (!$is_logged_in) { // Login was attempted, but failed, so display an error. $login_error = true; } else { header("Location: index.php"); exit; // Login redirect to prevent the refresh postback problem. } } $is_not_logged_in = !$is_logged_in; $username = get_username(); $user_id = get_user_id(); // Player counts. $stats = membership_and_combat_stats($sql); $player_count = $stats['player_count']; $players_online = $stats['players_online']; $header = render_html_for_header('Live By the Sword', 'main-body', $is_index = true); // render_html_for_header Writes out the html,head,meta,title,css,js. $version = 'NW Version 1.7.1 2009.11.22'; // Display main iframe page unless logged in. $main_src = 'main.php'; if ($is_logged_in) { $level = getLevel($username); $main_src = 'list_all_players.php'; if ($level == 1) { $main_src = 'tutorial.php'; } elseif ($level < 6) { $main_src = 'attack_player.php'; }
// TODO: When the message table is created, delete from mail more stringently. // TODO: Set up a backup of the players table. $keep_players_until_over_the_number = 2000; $days_players_have_to_be_older_than_to_be_unconfirmed = 60; $maximum_players_to_unconfirm = 200; // *************** DEITY NIGHTLY, manual-run-output occurs at the bottom.********************* $sql = new DBAccess(); $affected_rows['Increase Days Of Players'] = update_days($sql); //$sql->Update("UPDATE players SET status = status-".POISON." WHERE status&".POISON); // Black Poison Fix $sql->Update("UPDATE players SET status = 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.
<?php require_once LIB_ROOT . "control/lib_player.php"; $private = false; $alive = false; if ($error = init($private, $alive)) { redirect('list.php'); } else { $stats = membership_and_combat_stats(); $vicious_killer = $stats['vicious_killer']; $duels = query_array("SELECT dueling_log.*, attackers.player_id AS attacker_id, defenders.player_id AS defender_id FROM dueling_log JOIN players AS attackers ON attackers.uname = attacker JOIN players AS defenders ON defender = defenders.uname ORDER BY id DESC LIMIT 500"); display_page('duel.tpl', 'Bath House', get_certain_vars(get_defined_vars(), array('duels')), array('quickstat' => false)); }