Bump Topic

[Chip (OP)]

Compatable With Simple Portal's "Recent Topics"

Usage:

php bump_topic.php nnnnn

Code: [Select]

<?php

// Usage:
// php bump_topic.php <topic_id>

if (php_sapi_name() != &#39;cli&#39;)
    die("CLI only\n");

require_once(dirname(__FILE__) . &#39;/SSI.php&#39;);

if ($argc != 2)
    die("Usage: php bump_topic.php <topic_id>\n");

$topic_id = (int)$argv[1];

$now = time();
$member = 1; // change to your admin member ID

// Get topic info
$request = $smcFunc[&#39;db_query&#39;](&#39;&#39;, &#39;
    SELECT id_board, id_first_msg
    FROM {db_prefix}topics
    WHERE id_topic = {int:id_topic}&#39;,
    array(&#39;id_topic&#39; => $topic_id)
);

if (!$row = $smcFunc[&#39;db_fetch_assoc&#39;]($request))
    die("Topic not found\n");

$id_board = $row[&#39;id_board&#39;];

// Insert a reply
$smcFunc[&#39;db_insert&#39;](&#39;&#39;,
    &#39;{db_prefix}messages&#39;,
    array(
        &#39;id_board&#39; => &#39;int&#39;,
        &#39;id_topic&#39; => &#39;int&#39;,
        &#39;id_member&#39; => &#39;int&#39;,
        &#39;poster_time&#39; => &#39;int&#39;,
        &#39;poster_name&#39; => &#39;string&#39;,
        &#39;body&#39; => &#39;string&#39;,
        &#39;poster_ip&#39; => &#39;string&#39;,
    ),
    array(
        $id_board,
        $topic_id,
        $member,
        $now,
        &#39;Admin&#39;,
        &#39;Topic bumped&#39;,
        &#39;127.0.0.1&#39;,
    ),
    array(&#39;id_msg&#39;)
);

$new_msg = $smcFunc[&#39;db_insert_id&#39;](&#39;{db_prefix}messages&#39;, &#39;id_msg&#39;);

// Update topic
$smcFunc[&#39;db_query&#39;](&#39;&#39;, &#39;
    UPDATE {db_prefix}topics
    SET id_last_msg = {int:id_msg}
    WHERE id_topic = {int:id_topic}&#39;,
    array(
        &#39;id_msg&#39; => $new_msg,
        &#39;id_topic&#39; => $topic_id
    )
);

// Update board
$smcFunc[&#39;db_query&#39;](&#39;&#39;, &#39;
    UPDATE {db_prefix}boards
    SET id_last_msg = {int:id_msg}
    WHERE id_board = {int:id_board}&#39;,
    array(
        &#39;id_msg&#39; => $new_msg,
        &#39;id_board&#39; => $id_board
    )
);

echo "Topic bumped with new message ID {$new_msg}\n";