$_COOKIE['template'] = $skin;
}
require_once "lib/villagenav.php";
require_once "common.php";
tlschema("prefs");
require_once "lib/is_email.php";
require_once "lib/showform.php";
require_once "lib/sanitize.php";
page_header("Preferences");
$op = httpget('op');
if ($op == "suicide" && getsetting("selfdelete", 0) != 0) {
    $userid = httpget('userid');
    require_once "lib/charcleanup.php";
    $acctids = array();
    $acctids[] = $userid;
    char_cleanup($acctids, CHAR_DELETE_SUICIDE);
    $sql = "DELETE FROM " . db_prefix("accounts") . " WHERE acctid='{$userid}'";
    db_query($sql);
    output("Your character has been deleted!");
    addnews("`#%s quietly passed from this world.", $session['user']['name']);
    addnav("Login Page", "index.php");
    $session = array();
    $session['user'] = array();
    $session['loggedin'] = false;
    $session['user']['loggedin'] = false;
    invalidatedatacache("charlisthomepage");
    invalidatedatacache("list.php-warsonline");
} else {
    checkday();
    if ($session['user']['alive']) {
        villagenav();
<?php

$sql = "SELECT name from " . db_prefix("accounts") . " WHERE acctid='{$userid}'";
$res = db_query($sql);
require_once "lib/charcleanup.php";
char_cleanup($userid, CHAR_DELETE_MANUAL);
while ($row = db_fetch_assoc($res)) {
    addnews(sprintf_translate("`#%s was unmade by the gods.", $row['name']));
    debuglog("deleted user" . $row['name'] . "'0");
}
$sql = "DELETE FROM " . db_prefix("accounts") . " WHERE acctid='{$userid}'";
db_query($sql);
output(db_affected_rows() . " user deleted.");
 $old = getsetting("expireoldacct", 45);
 $new = getsetting("expirenewacct", 10);
 $trash = getsetting("expiretrashacct", 1);
 # First, get the account ids to delete the user prefs.
 $sql1 = "SELECT login,acctid,dragonkills,level FROM " . db_prefix("accounts") . " WHERE (superuser&" . NO_ACCOUNT_EXPIRATION . ")=0 AND (1=0\n" . ($old > 0 ? "OR (laston < \"" . date("Y-m-d H:i:s", strtotime("-{$old} days")) . "\")\n" : "") . ($new > 0 ? "OR (laston < \"" . date("Y-m-d H:i:s", strtotime("-{$new} days")) . "\" AND level=1 AND dragonkills=0)\n" : "") . ($trash > 0 ? "OR (laston < \"" . date("Y-m-d H:i:s", strtotime("-" . ($trash + 1) . " days")) . "\" AND level=1 AND experience < 10 AND dragonkills=0)\n" : "") . ")";
 $result1 = db_query($sql1);
 $acctids = array();
 $pinfo = array();
 $dk0lvl = 0;
 $dk0ct = 0;
 $dk1lvl = 0;
 $dk1ct = 0;
 $dks = 0;
 while ($row1 = db_fetch_assoc($result1)) {
     require_once "lib/charcleanup.php";
     if (!char_cleanup($row1['acctid'], CHAR_DELETE_AUTO)) {
         continue;
     }
     array_push($acctids, $row1['acctid']);
     array_push($pinfo, "{$row1['login']}:dk{$row1['dragonkills']}-lv{$row1['level']}");
     if ($row1['dragonkills'] == 0) {
         $dk0lvl += $row1['level'];
         $dk0ct++;
     } else {
         if ($row1['dragonkills'] == 1) {
             $dk1lvl += $row1['level'];
             $dk1ct++;
         }
     }
     $dks += $row1['dragonkills'];
 }
if ($skin > "") {
    setcookie("template", $skin, strtotime("+45 days"));
    $_COOKIE['template'] = $skin;
}
require_once "lib/villagenav.php";
require_once "common.php";
tlschema("prefs");
require_once "lib/is_email.php";
require_once "lib/showform.php";
require_once "lib/sanitize.php";
page_header("Preferences");
$op = httpget('op');
if ($op == "suicide" && getsetting("selfdelete", 0) != 0) {
    $userid = httpget('userid');
    require_once "lib/charcleanup.php";
    char_cleanup($userid, CHAR_DELETE_SUICIDE);
    $sql = "DELETE FROM " . db_prefix("accounts") . " WHERE acctid='{$userid}'";
    db_query($sql);
    output("Your character has been deleted!");
    addnews(sprintf_translate("`#%s quietly passed from this world.", $session['user']['name']));
    addnav("Login Page", "index.php");
    $session = array();
    $session['user'] = array();
    $session['loggedin'] = false;
    $session['user']['loggedin'] = false;
    invalidatedatacache("charlisthomepage");
    invalidatedatacache("list.php-warsonline");
} else {
    checkday();
    if ($session['user']['alive']) {
        villagenav();