<?php
/* ============================================================
 * 网站地图 TXT（动态生成）
 * ============================================================ */
header('Content-Type: text/plain; charset=utf-8');

$root = __DIR__;
$db   = new SQLite3($root . '/data/d777ce190a82629e6fc10b69cfacc6be.db');
$db->busyTimeout(5000);

$site   = $db->querySingle("SELECT * FROM ay_site WHERE acode='cn'", true);
$domain = ($site && $site['domain']) ? $site['domain'] : (isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : '127.0.0.6');
$base   = 'http://' . $domain;

// 首页
echo $base . "/\n";

// 栏目
$sorts = array();
$r = $db->query("SELECT * FROM ay_content_sort WHERE status='1' ORDER BY sorting, id");
while ($row = $r->fetchArray(SQLITE3_ASSOC)) {
    $sorts[$row['id']] = $row;
    echo $base . '/' . $row['filename'] . "/\n";
}

// 文章
$r = $db->query("SELECT id, scode FROM ay_content WHERE status='1' ORDER BY date DESC");
while ($row = $r->fetchArray(SQLITE3_ASSOC)) {
    $sort = isset($sorts[$row['scode']]) ? $sorts[$row['scode']] : null;
    if (!$sort) continue;
    echo $base . '/' . $sort['filename'] . '/' . $row['id'] . ".html\n";
}