PHP rexsearchStats Examples

Example #1

File: functions.inc.php Project: olien/rexsearch

function a587_stats_addtruncate($params)
{
    global $I18N;
    if (rex_request('func') == 'truncate') {
        $stats = new rexsearchStats();
        $stats->truncate();
        a587_stats_saveSettings(array('maxtopSearchitems' => '10', 'searchtermselect' => '', 'searchtermselectmonthcount' => '12'));
        $params['subject'] = rex_info($I18N->Msg('a587_stats_truncate_done')) . $params['subject'];
    }
    $params['subject'] .= '<p class="rex-tx1">' . $I18N->Msg('a587_stats_truncate') . '</p>
<p class="rex-button"><a onclick="return confirm(\'' . $I18N->Msg('a587_stats_truncate_confirm') . '\');" href="index.php?page=rexsearch&amp;subpage=generate&amp;func=truncate" class="rex-button"><span>' . $I18N->Msg('a587_stats_truncate_button') . '</span></a></p>';
    return $params['subject'];
}

Example #2

File: index.inc.php Project: olien/rexsearch

            break;
    }
}
include $REX['INCLUDE_PATH'] . '/layout/top.php';
rex_title("rexsearch", $REX['ADDON'][$page]['SUBPAGES']);
?>
<div class="rex-addon-output" id="a587-form">
<h2 class="rex-hl2" style="position: relative;"><?php 
echo $I18N->Msg('a587_stats_title');
?>
</h2>

<div class="rex-form">
<form method="post" action="index.php?page=rexsearch&amp;subpage=stats" id="a587_stats_form">
<?php 
$stats = new rexsearchStats();
#$stats->createTestData();
#error_reporting(E_ALL);
// general stats
$sql = new rex_sql();
$generalstats = $sql->getArray('SELECT
  ((SELECT COUNT(DISTINCT ftable,fid) as count FROM `' . $REX['TABLE_PREFIX'] . '587_searchindex` WHERE ftable IS NOT NULL) + (SELECT COUNT(DISTINCT fid) as count FROM `' . $REX['TABLE_PREFIX'] . '587_searchindex` WHERE ftable IS NULL)) AS 010_uniquedatasetcount,
  (SELECT AVG(resultcount) FROM `' . $REX['TABLE_PREFIX'] . '587_stats_searchterms`) AS 020_averageresultcount,
  (SELECT COUNT(*) FROM `' . $REX['TABLE_PREFIX'] . '587_stats_searchterms` WHERE resultcount > 0) AS 040_successfullsearchescount,
  (SELECT COUNT(*) FROM `' . $REX['TABLE_PREFIX'] . '587_stats_searchterms` WHERE resultcount = 0) AS 050_failedsearchescount,
  (SELECT COUNT(DISTINCT term) FROM `' . $REX['TABLE_PREFIX'] . '587_stats_searchterms`) AS 060_uniquesearchterms');
$generalstats = $generalstats[0];
$generalstats['030_searchescount'] = $generalstats['040_successfullsearchescount'] + $generalstats['050_failedsearchescount'];
$generalstats['100_datalength'] = 0;
$generalstats['110_indexlength'] = 0;
foreach ($sql->getArray("SHOW TABLE STATUS LIKE '" . $REX['TABLE_PREFIX'] . "587_%'") as $table) {