require("config.php");


require("db/db.php");


$justreport = true;


$fixit = true; // set to true to set comments in stories table to number found in comments


$result = $db->sql_query('SELECT title, sid, comments FROM '.$prefix.'_stories');


while ($row = $db->sql_fetchrow($result)) {


        $counter = 0;


         $sid = intval($row['sid']);


         $comments = intval($row['comments']);


$counter = intval($db->sql_numrows($db->sql_query('SELECT sid FROM '.$prefix.'_comments WHERE sid =\''.$sid.'\'')));


if ($justreport) {


echo $sid . ' ' . $row['title'] . ' --comments table=  ' .  $counter . ' --stories table = ' . $comments . '<br>';   }


if ($fixit) {


    if ($comments != $counter) {


    $result2 = $db->sql_query('UPDATE '.$prefix.'_stories SET comments=\''.$counter.'\' WHERE sid=\''.$sid.'\'');


    if (!$result2) {


        echo mysql_errno($result2) . mysql_error($result2) ; }


    echo 'fixing comments field in ' . $row['title'] . '<br>';


    }


}


}


 

<?php


include 'mainfile.php';


include 'header.php';


OpenTable();





$sql = "SELECT sid, comments FROM {$prefix}_stories ORDER BY sid";


$result = $db->sql_query($sql);


while ($row = $db->sql_fetchrow($result))


{


   $sid = $row['sid'];


   $comments = $row['comments'];





   $sql = "SELECT COUNT(*) FROM {$prefix}_comments WHERE sid = '$sid'";


   $result2 = $db->sql_query($sql);


   $row2 = $db->sql_fetchrow($result2);


   $actComments = $row2[0];





   if ($comments != $actComments)


   {


      echo "Updating story $sid because it thinks it has $comments comments, but it really has $actComments<br />";


      $sql = "UPDATE {$prefix}_stories SET comments = '$actComments' WHERE sid = '$sid'";


      if (false === $db->sql_query($sql))


      {


         echo "Oops it didn't work for story $sid<br />";


      }


   }


}





CloseTable();


include 'footer.php';


?>