<?php
/**
 * float to top for phorum 3.2.11 <07/11/2001>
 * by badguy <2badguy@gmx.net>
 *
 * DISCLAIMER
 *
 * I don't accept responsibility if this piece of code screws up your
 * database or causes your site to crash, so PLEASE BACKUP YOUR FILES 
 * AND DATABASE BEFORE YOU APPLY THIS HACK! 
 *
 */

  require "./common.php";

  $SQL="Select id, name, table_name from $pho_main WHERE folder = '0'";
  $query = new query($DB, $SQL);

  $rec=$query->getrow();

  while(is_array($rec)){
    echo "Altering tables for $rec[name]<br />\n";
    flush();
    $SQL="ALTER TABLE $rec[table_name] ADD modifystamp int(10) unsigned DEFAULT '0' NOT NULL";
    $q->query($DB, $SQL);
    $SQL="ALTER TABLE $rec[table_name] ADD KEY modifystamp (modifystamp)";
    $q->query($DB, $SQL);
    echo "Updating modifystamp for $rec[name]<br />\n";
    flush();
    $SQL="select thread, max(datestamp) as datestamp from $rec[table_name] group by thread";
    $q->query($DB, $SQL);

    $q2 = new query($DB);

    while($rec2=$q->getrow()){
        list($date,$time) = explode(" ", $rec2["datestamp"]);
        list($year,$month,$day) = explode("-", $date);
        list($hour,$minute,$second) = explode(":", $time);
        $tstamp = mktime($hour,$minute,$second,$month,$day,$year);
        $SQL="update $rec[table_name] set modifystamp=$tstamp where thread=$rec2[thread]";
        $q2->query($DB, $SQL);
        echo ".";
        flush();
    }
    $rec=$query->getrow();
  }
  echo "<br />DONE!!!\n";

?>