tools/recount-bumps.php

   1 <?php
   2 // A script to recount bumps to recover from a last-page-bump attack
   3 // or to be run after the KusabaX Migration.
   4
   5 require dirname(__FILE__) . '/inc/cli.php';
   6
   7 if (!isset ($argv[1])) {
   8         die("Usage: tools/recount-bumps.php board_uri\n");
   9 }
  10 $board = $argv[1];
  11
  12 $q = query(sprintf("SELECT `id`, `bump`, `time` FROM ``posts_%s``
  13                     WHERE `thread` IS NULL", $board));
  14 while ($val = $q->fetch()) {
  15         $lc = prepare(sprintf('SELECT MAX(`time`) AS `aq` FROM ``posts_%s``
  16                                WHERE ((`thread` = :thread and
  17                                `email` != "sage" ) OR `id` = :thread', $board));
  18
  19         $lc->bindValue(":thread", $val['id']);
  20         $lc->execute();
  21
  22         $f = $lc->fetch();
  23         if ($val['bump'] != $f['aq']) {
  24                 $query = prepare(sprintf("UPDATE ``posts_%s`` SET `bump`=:bump
  25                                           WHERE `id`=:id", $board));
  26                 $query->bindValue(":bump", $f['aq']);
  27                 $query->bindValue(":id", $val['id']);
  28                 echo("Thread $val[id] - to be $val[bump] -> $f[aq]\n");
  29         }
  30         else {
  31                 echo("Thread $val[id] ok\n");
  32         }
  33 }
  34
  35 echo("done\n");