PHP ftsearch_refresh_cache_logs Examples

Example #1

File: ftsearch.inc.php Project: PaulinaKowalczuk/oc-server3

function ftsearch_refresh_all_cache_logs()
{
    $rs = sql('SELECT `cache_logs`.`id` FROM `cache_logs` LEFT JOIN `search_index_times` ON `cache_logs`.`id`=`search_index_times`.`object_id` AND 1=`search_index_times`.`object_type` WHERE ISNULL(`search_index_times`.`object_id`) UNION DISTINCT SELECT `cache_logs`.`id` FROM `cache_logs` INNER JOIN `search_index_times` ON `search_index_times`.`object_type`=1 AND `cache_logs`.`id`=`search_index_times`.`object_id` WHERE `cache_logs`.`last_modified`>`search_index_times`.`last_refresh`');
    while ($r = sql_fetch_assoc($rs)) {
        ftsearch_refresh_cache_logs($r['id']);
    }
    sql_free_result($rs);
}

Example #2

File: ftsearch.inc.php Project: kojoty/opencaching-pl

function ftsearch_refresh_all_cache_logs()
{
    $rs = XDb::xSql('SELECT `cache_logs`.`id`
        FROM `cache_logs`
            LEFT JOIN `search_index_times` ON `cache_logs`.`id`=`search_index_times`.`object_id`
                AND 1=`search_index_times`.`object_type`
        WHERE ISNULL(`search_index_times`.`object_id`)
        UNION DISTINCT
        SELECT `cache_logs`.`id`
        FROM `cache_logs`
            INNER JOIN `search_index_times` ON `search_index_times`.`object_type`=1
            AND `cache_logs`.`id`=`search_index_times`.`object_id`
        WHERE `cache_logs`.`last_modified`>`search_index_times`.`last_refresh`
            AND `cache_logs`.`deleted`=0');
    while ($r = XDb::xFetchArray($rs)) {
        ftsearch_refresh_cache_logs($r['id']);
    }
    XDb::xFreeResults($rs);
}