Gazelle-Porn/sections/log/sphinx.php

<?php
if (!empty($_GET['page']) && is_number($_GET['page'])) {
    $Page = min(CONFIG['SPHINX_MAX_MATCHES'] / CONFIG['LOG_ENTRIES_PER_PAGE'], $_GET['page']);
    $Offset = ($Page - 1) * CONFIG['LOG_ENTRIES_PER_PAGE'];
} else {
    $Page = 1;
    $Offset = 0;
}
if (empty($_GET['search']) || trim($_GET['search']) == '') {
    $Log = $DB->query("
		SELECT ID, Message, Time
		FROM log
		ORDER BY ID DESC
		LIMIT $Offset, " . CONFIG['LOG_ENTRIES_PER_PAGE']);
    $NumResults = G::$DB->record_count();
    if (!$NumResults) {
        $TotalMatches = 0;
    } elseif ($NumResults == CONFIG['LOG_ENTRIES_PER_PAGE']) {
        // This is a lot faster than SQL_CALC_FOUND_ROWS
        $SphQL = new SphinxqlQuery();
        $Result = $SphQL->set('cutoff', 0)->select('id')->from('log, log_delta')->limit(0, 1, 1)->query();
        $Debug->log_var($Result, '$Result');
        $TotalMatches = min(CONFIG['SPHINX_MAX_MATCHES'], $Result->get_meta('total_found'));
    } else {
        $TotalMatches = $NumResults + $Offset;
    }
    $QueryStatus = 0;
} else {
    $Page = min(CONFIG['SPHINX_MAX_MATCHES'] / CONFIG['TORRENTS_PER_PAGE'], $Page);
    $SphQL = new SphinxqlQuery();
    $SphQL->select('id')
        ->from('log, log_delta')
        ->where_match($_GET['search'], 'message')
        ->order_by('id', 'DESC')
        ->limit($Offset, CONFIG['LOG_ENTRIES_PER_PAGE'], $Offset + CONFIG['LOG_ENTRIES_PER_PAGE']);

    $Result = $SphQL->query();
    $Debug->log_var($Result, '$Result');
    $Debug->set_flag('Finished SphQL query');
    if ($QueryStatus = $Result->Errno) {
        $QueryError = $Result->Error;
    }
    $NumResults = $Result->get_result_info('num_rows');
    $TotalMatches = min(CONFIG['SPHINX_MAX_MATCHES'], $Result->get_meta('total_found'));
    if ($NumResults > 0) {
        $LogIDs = $Result->collect('id');
        $Log = $DB->query('
			SELECT ID, Message, Time
			FROM log
			WHERE ID IN (' . implode(',', $LogIDs) . ')
			ORDER BY ID DESC');
    } else {
        $Log = $DB->query('
			SET @nothing = 0');
    }
}