Batch job: "listall_topicsandboards.php"

[Chip (OP)]

<?php

// Load SMF bootstrap
require_once(dirname(__FILE__) . '/SSI.php');

global $smcFunc;

// Query: get all boards

$request = $smcFunc['db_query']('', '
    SELECT id_board, name
    FROM {db_prefix}boards
    ORDER BY id_board ASC'
);

$boards = array();
while ($row = $smcFunc['db_fetch_assoc']($request)) {
    $boards[$row['id_board']] = $row['name'];
}
$smcFunc['db_free_result']($request);

// Loop through boards and list topics with titles
foreach ($boards as $id_board => $board_name) {

    echo "=== BOARD $id_board: $board_name ===\n";

    $request = $smcFunc['db_query']('', '
        SELECT t.id_topic, m.subject
        FROM {db_prefix}topics AS t
        JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
        WHERE t.id_board = {int:board}
        ORDER BY t.id_topic ASC',
        array(
            'board' => $id_board,
        )
    );

    while ($topic = $smcFunc['db_fetch_assoc']($request)) {
        echo "Topic ID: {$topic['id_topic']} | {$topic['subject']}\n";
    }

    $smcFunc['db_free_result']($request);

    echo "\n";
}

echo "Done.\n";