<?php
require_once("../includes/config.php");
require_once("../includes/functions/func.global.php");
require_once("../includes/functions/loggincheck.php");
require_once('../includes/lang/admin/lang_'.$config['lang'].'.php');
require_once("class.menu.php");
// Connect to database
db_connect($config);
$obj = new Menu();
$nav = $obj->get_js_menu(0,$config,$lang);
if(!isset($_GET['count']))
{
$num_stories = mysql_num_rows(mysql_query("SELECT 1 FROM ".$config['db']['pre']."stories"));
$_GET['count'] = 0;
$_GET['fixed'] = 0;
$_GET['done'] = 0;
$_GET['stories'] = $num_stories;
}
$comments = 0;
$query = "SELECT story_id,story_comments FROM ".$config['db']['pre']."stories LIMIT ".addslashes($_GET['count']).",20";
$query_result = mysql_query($query);
while ($info = @mysql_fetch_array($query_result))
{
$num_comments = mysql_num_rows(mysql_query("SELECT 1 FROM ".$config['db']['pre']."comm WHERE story_id='".$info['story_id']."'"));
if($info['story_comments'] != $num_comments)
{
mysql_query("UPDATE `".$config['db']['pre']."stories` SET `story_comments` = '".$num_comments."' WHERE `story_id` =".$info['story_id']." LIMIT 1 ;");
$_GET['fixed']++;
}
$_GET['done']++;
$comments++;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>PHPDug Admin - Script Health</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="images/style.css">
<?php
if($comments > 0)
{
?>
<meta http-equiv="refresh" content="3;URL=health_story.php?count=<?=($_GET['count']+20);?>&fixed=<?=$_GET['fixed'];?>&done=<?=$_GET['done'];?>&stories=<?=$_GET['stories'];?>">
<?php
}
?>
<SCRIPT LANGUAGE="JavaScript" SRC="menu/JSCookMenu.js"></SCRIPT>
<LINK REL="stylesheet" HREF="menu/themes/Office/theme.css" TYPE="text/css">
<SCRIPT LANGUAGE="JavaScript" SRC="menu/themes/Office/theme.js"></SCRIPT>
<LINK REL="stylesheet" HREF="menu/themes/Office/theme.css" TYPE="text/css">
<SCRIPT LANGUAGE="JavaScript" SRC="menu/themes/Office/theme.js"></SCRIPT>
<script language="JavaScript">
<!--
function checkBox(theBox){
var aBox = theBox.form["list[]"];
var selAll = false;
var i;
for(i=0;i<aBox.length;i++){
if(aBox[i].checked==false) selAll=true;
}
if(theBox.name=="selall"){
for(i=0;i<aBox.length;i++){
aBox[i].checked = selAll;
}
selAll = !selAll;
}
//theBox.form.selall.checked = selAll;
}
function init(){
var theForm = document.f1;
var aBox = theForm["list[]"];
var selAll = false;
var i;
for(i=0;i<aBox.length;i++){
if(aBox[i].checked==false) selAll=true;
aBox[i].onclick = function(){checkBox(this)};
}
//theForm.selall.checked = selAll;
}
//-->
</script>
<style type="text/css">
<!--
.style6 {font-size: 14px}
-->
</style>
</head>
<body>
<!--Start top-->
<table width="850" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="42" align="left" background="images/bg_top.gif"><a href="index.php"><img src="images/logo.gif" width="127" height="37" hspace="10" border="0"></a></td>
</tr>
<tr>
<td><img src="images/dot.gif" width="1" height="1" alt=""></td>
</tr>
</table>
<!--End top-->
<!--Start topmenu-->
<table width="850" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F0F0F0" height="25" style="padding-left:20px;" id="menu"><SCRIPT language="JavaScript" type="text/javascript">
var myMenu =
// Start the menu
[
<?php echo $nav; ?>
];
// Output the menu
cmDraw ('menu', myMenu, 'hbr', cmThemeOffice, 'ThemeOffice');
</SCRIPT></td>
</tr>
<tr>
<td bgcolor="#333333"><img src="images/dot.gif" width="1" height="1" alt=""></td>
</tr>
</table>
<br>
<!--End topmenu-->
<!--Start heading page-->
<table width="850" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td class="heading"><img src="images/icons/icon_manage.gif" width="26" height="25" alt="" align="absmiddle" hspace="5">Script Health - Story Recalculate </td>
</tr>
<tr>
<td bgcolor="#333333"><img src="images/dot.gif" width="1" height="1" alt=""></td>
</tr>
</table>
<!--End heading page-->
<!--Start form-->
<br>
<table width="850" border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid #CCCCCC;">
<tr>
<td align="left" valign="top" bgcolor="#F6F6F6" style="padding:15px;">
<?php
if($comments == 0)
{
?>
<span class="style6">The script has finished running!<br><br>
Ran through <?=$_GET['done'];?> stories and fixed <?=$_GET['fixed'];?> of them.<br>
</span>
<?php
}
else
{
?>
<span class="style6">Currently running, please leave this window open<br>
<br>
<br>
Checked <?=$_GET['done'];?> out of <?=$_GET['stories'];?> stories<br>
</span>
<?php
}
?>
</td>
</tr>
</table>
<!--End form-->
<br><br>
<!--Start bottom-->
<table width="850" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#333333"><img src="images/dot.gif" width="1" height="1" alt=""></td>
</tr>
<tr>
<td style="padding:15px;" align="center">
<span class="copyright">Copyright © 2008 <a href="http://www.kubelabs.com/phpdug/" class="copyright" target="_blank">Kubelabs.com</a> All Rights Reserved.</span></td>
</tr>
</table>
<!--End bottom-->
</body>
</html>