Location: PHPKode > projects > PhpSERA > html/errorlog.php
include_once "../global.inc.php";


  Search Engine Ranking Analysis
  File    : errorlog.php
  Desc.   : Show all failed analysis

  Version : 0.3
  Author  : Matthijs Koot

  History : 21-08-03 - file created
            22-09-03 - replace sql tablenames with vars from global.inc.php hide@address.com
            17-10-03 - added GROUP BY in SQL statement to provide more useful information
            03-05-04 - changed phpSERA to use UTF-8 (!) as it should have used to start with 


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<title><?php echo $TITLE?></title>
<link rel="stylesheet" href="css/content.css">
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
  .help { 
    position   : absolute; 
    visibility : hidden; 
    color      : #004499; 
<h3>Last 50 Analysis Failures</h3>
<p>This page is provided as a means for you (and us) to maintain high quality analysis data. When regex errors occur, you (and we) need to update the settings for that search engine. A search engine will only be displayed once per ranking date.</p>
<?php if (isset($msg)) echo $msg; ?>
        $sql_err = "SELECT
  $DB_Keyphrases.zt_id = $DB_Reportrules.zt_id 
  AND $DB_Searchengines.zm_id = $DB_Reportrules.zm_id 
  AND $DB_Reportrules.ranking < 0 
  AND $DB_Reportrules.mt_id = $DB_Reports.mt_id
  $DB_Reports.rankdate DESC,
  $DB_Searchengines.title ASC
LIMIT 0,50";

        $result_err = $db->Execute($sql_err);
        if (!$result_err->EOF) {
          <tr style="height:1px;">
            <td><img src="images/spacer.gif" alt="" width="90" height="1"></td>
            <td><img src="images/spacer.gif" alt="" width="120" height="1"></td>
            <td><img src="images/spacer.gif" alt="" width="50" height="1"></td>
            <td><img src="images/spacer.gif" alt="" width="50" height="1"></td>
          <th><?php echo $lang["newser"]["date"]?>:</th>
          <th><?php echo $lang["showreport"]["se"]?>:</th>
          <th><?php echo $lang["showreport"]["keyphrase"]?>:</th>
        while ($o = $result_err->FetchNextObject()) {
          switch ($o->RANKING) {
            case -3: $errormsg = "regex error (but URL found)"; break;
            case -2: $errormsg = "connect error"; break; 
            case -1: $errormsg = "regex error"; break;
            default: $errormsg = "-";

          echo "<tr>\n";
          echo "  <td>$o->RANKDATE</td>\n";
          echo "  <td>$o->TITLE</td>\n";
          echo "  <td>$o->KEYPHRASE</td>\n";
          echo "  <td>$errormsg &nbsp;";
          echo "    <a href=\"se_frameset.php?se=".$o->ZM_ID."&phrase=".urlencode($o->KEYPHRASE)."\">debug</a>";
          echo "</td>\n";
          echo "</tr>\n";
    } else {
      echo "<table cellpadding=10><tr><td><b>No failures recorded... yet :)</b></td></tr></table>\n";

Return current item: PhpSERA