<?php
   // pretend db connectivity stuff is here

   $threadQuery = "SELECT * " .
                  "FROM   newthreadtable " .
                  "WHERE  lastpost BETWEEN whatever AND whatever";
   // I'd never <i>really</i> use 'select *', but I don't know the structure of the new table
   // also, the 'between' would obviously be whenever the server made the switch to when
   // the old version was restored

   $threadResult = mysql_query($threadQuery);

   while ($thread = mysql_fetch_array($threadResult))
   {
       $query = "SELECT COUNT(*) AS Counted " .
                "FROM   newthreadtable " .
                "WHERE  id=$thread[id] " .
                "AND    dateline BETWEEN whatever AND whatever";
       $isNewResult = mysql_query($query);
       $isNew = mysql_fetch_array($isNewResult);
       if ($isNew[Counted])
       {
           $query = "INSERT INTO thread VALUES (" .
                    "  NULL, " .
                    "  $thread[title], " .
                    "  $thread[lastpost], " .
                    "  $thread[forumid], " .
                    "  $thread[open], " . 
                    "  $thread[replycount], " .
                    "  $thread[postusername], " . 
                    "  $thread[lastposter], " .
                    "  $thread[dateline], " . 
                    "  $thread[views], " .
                    "  $thread[iconid], " . 
                    "  $thread[notes], " . 
                    "  $thread[visible], " .
                    "  $thread[subjectindex], " . 
                    "  $thread[threadindex], " .
                    "  $thread[userindex] " .
                    ")";
           mysql_query($query);
           $id = mysql_insert_id();
       }
       else
       {
           $id = $thread[id];
       }

       $postQuery = "SELECT * " . 
                    "FROM   newposttable " .
                    "WHERE  threadid=$thread[id] " .
                    "AND    dateline BETWEEN whatever AND whatever";
       $postResult = mysql_query($postQuery);
       while ($post = mysql_fetch_array($postQuery))
       {
           $query = "INSERT INTO post VALUES (" .
                    "  NULL, " .
                    "  $id, " .
                    "  $post[username], " .
                    "  $post[userid], " . 
                    "  $post[title], " . 
                    "  $post[dateline], " . 
                    "  $post[pagetext], " .
                    "  $post[allowssmilie], " .
                    "  $post[email], " .
                    "  $post[signature], " .
                    "  $post[ipaddress], " .
                    "  $post[iconid], " . 
                    "  $post[visible] " .
                    ")";
           mysql_query($query);
       }
   }
?&gt;