<?php

include_once(dirname(__FILE__).'/inc/prepend.php');

// Memcache connection
$memcache = DirXiphOrgMCC::getInstance();

// Get the args
$page_n = array_key_exists('page', $_GET) ? intval($_GET['page']) : 0;
if ($page_n > (MAX_SEARCH_RESULTS / MAX_RESULTS_PER_PAGE))
{   
    $page_n = 0;
}
if (array_key_exists('PATH_INFO', $_SERVER))
{
	$search_string = preg_replace('|^/([^\s/]+).*$|', '$1', $_SERVER['PATH_INFO']);
	$search_string = substr($search_string, 0, 15);
	$tpl->assign('search_keyword', str_replace('_', ' ', $search_string));
	$search_string = preg_replace('/[^A-Za-z0-9+_\-]/', '_', $search_string);
	$search_string_hash = jenkins_hash_hex($search_string);
	
	// Logging
	try
	{
	    statsLog::keywordsSearched(statsLog::SEARCH_TYPE_FORMAT, $search_string);
	}
	catch (SQLException $e)
	{
	    // Do nothing, it's just logging after all...
	}
		
    // Get the data from the Memcache server
    if (($results = $memcache->get(ENVIRONMENT.'_search_format_'.$search_string_hash)) === false)
    {
        // Database connection
        $db = DirXiphOrgDBC::getInstance();

        // Cache miss. Now query the database.
        try
        {
//			$query = 'SELECT m.* FROM `mountpoint` AS m INNER JOIN `media_type` AS mty ON m.`media_type_id` = mty.`id` WHERE mty.`media_type_url` = "%s" ORDER BY m.`listeners` DESC LIMIT %d;';
            $query = 'SELECT * FROM `mountpoint` WHERE `media_type_id` = (SELECT `id` FROM `media_type` WHERE `media_type_url` = "%s") ORDER BY `listeners` DESC LIMIT %d;';
            $query = sprintf($query, mysql_real_escape_string($search_string), MAX_SEARCH_RESULTS);
            $results = $db->selectQuery($query);
            $res = array();
            while (!$results->endOf())
            {
                $mp = Mountpoint::retrieveByPk($results->current('id'));
                if ($mp instanceOf Mountpoint)
                {
                    $res[] = $mp;
                }
                $results->next();
            }
            $results = $res;
        }
        catch (SQLNoResultException $e)
        {
            $results = array();
        }

        // Cache the resultset
        $memcache->set(ENVIRONMENT.'_search_format_'.$search_string_hash, $results, false, 60);
    }

	if ($results !== false && $results !== array())
	{
        $n_results = count($results);
        $results_pages = ceil($n_results / MAX_RESULTS_PER_PAGE);
        if ($page_n > $results_pages)
        {
            $page_n = 0;
        }
        $pages = array();
        if ($results_pages < PAGES_IN_PAGER)
        {
            $pages = range(1, $results_pages);
        }
        elseif ($page_n > PAGES_IN_PAGER)
        {
            $pages = range($page_n + 1 - PAGES_IN_PAGER, $pages_n + 1 + PAGES_IN_PAGER);
        }
        elseif ($page_n + PAGES_IN_PAGER > $results_pages)
        {
            $pages = range($results_pages - PAGES_IN_PAGER + 1, $results_pages);
        }
        else
        {
            $pages = range(1, PAGES_IN_PAGER);
        }
        $offset = $page_n * MAX_RESULTS_PER_PAGE;
        $results = array_slice($results, $offset,
                               MAX_RESULTS_PER_PAGE);
        $tpl->assign_by_ref('results', $results);
        $tpl->assign_by_ref('results_pages', $pages);
        $tpl->assign_by_ref('results_pages_total', $results_pages);
        $tpl->assign('results_page_no', $page_n + 1);
	}
}
else
{
	// Tag cloud
//	$tpl->assign('tag_cloud', $memcache->get('prod_tagcloud'));
}

// Header
$tpl->display("head.tpl");

// Display the results
$tpl->assign('servers_total', $memcache->get(ENVIRONMENT.'_servers_total'));
$tpl->assign('servers_mp3', $memcache->get(ENVIRONMENT.'_servers_'.CONTENT_TYPE_MP3));
$tpl->assign('servers_vorbis', $memcache->get(ENVIRONMENT.'_servers_'.CONTENT_TYPE_OGG_VORBIS));
$tpl->assign('tag_cloud', genfile::get(genfile::makeGenfileName('tagcloud')));
$tpl->display('search.tpl');

// Footer
if (ENVIRONMENT != 'prod')
{
	$tpl->assign('generation_time', (microtime(true) - $begin_time) * 1000);
	$tpl->assign('sql_queries', isset($db) ? $db->queries : 0);
	if (isset($db))
	{
		$tpl->assign('sql_debug', $db->log);	
	}
	$tpl->assign('mc_gets', isset($memcache) ? $memcache->gets : 0);
	$tpl->assign('mc_sets', isset($memcache) ? $memcache->sets : 0);
	if (isset($memcache))
	{
		$tpl->assign('mc_debug', $memcache->log);
	}
}
$tpl->assign("/search/by_format");
$tpl->display('foot.tpl');

?>