top100.php

<?php

require_once 'init.php';

/*
 * Top100 uses separate cache named top100;
 */

$section = 'apps';

$API->TPL->assign('headeradd', '<link rel="stylesheet" type="text/css" href="./css/appslist.css"> ');

$compatibility = $API->getval('compatibility', 'int');

$API->TPL->assign('compatibility', $compatibility);

$type = htmlspecialchars($API->getval('type'));

if (!in_array($type, array('app', 'book', '')))
    $type = '';

$API->TPL->assign('type', $type);


// fucking selector, first check by compatibility, second by type of content. every turn of compatiblity we must check type
if (!$compatibility || $compatibility > 4 || $compatibility < 0) {
    $compatibility_sql = false;
    if ($type == 'book') {
        $compatibility_sql = "$section.type='book'";
        $genres_for_search_addition = "genres.type='books'";
    } elseif ($type == 'app') {
        $genres_for_search_addition = "genres.type !='books'";
        $compatibility_sql = "$section.type='app'";
    }
} elseif ($compatibility == 1) {

    if (!$type) {
        $compatibility_sql = "compatibility<>4";
        $genres_for_search_addition = "genres.type!='mas'";
    } elseif ($type == 'book') {
        $compatibility_sql = "($section.type='book' AND compatibility<>4)";
        $genres_for_search_addition = "genres.type='books'";
    } elseif ($type == 'app') {
        $genres_for_search_addition = "genres.type NOT IN('mas','books')";
        $compatibility_sql = "($section.type='app' AND compatibility<>4)";
    }
} elseif ($compatibility == 2) {

    if (!$type) {
        $genres_for_search_addition = "genres.type!='mas'";
        $compatibility_sql = "compatibility NOT IN(3,4)";
    } elseif ($type == 'book') {
        $compatibility_sql = "($section.type='book' AND compatibility NOT IN(3,4))";
        $genres_for_search_addition = "genres.type='books'";
    } elseif ($type == 'app') {
        $genres_for_search_addition = "genres.type NOT IN('mas','books')";
        $compatibility_sql = "($section.type='app' AND compatibility NOT IN(3,4))";
    }
} elseif ($compatibility == 3) {

    if (!$type) {
        $genres_for_search_addition = "genres.type!='mas'";
        $compatibility_sql = "compatibility NOT IN(2,4)";
    } elseif ($type == 'book') {
        $compatibility_sql = "($section.type='book' AND compatibility NOT IN(2,4))";
        $genres_for_search_addition = "genres.type='books'";
    } elseif ($type == 'app') {
        $genres_for_search_addition = "genres.type NOT IN('mas','books')";
        $compatibility_sql = "($section.type='app' AND compatibility NOT IN(2,4))";
    }
} elseif ($compatibility == 4) {
    $genres_for_search_addition = "genres.type IN('mas','books')";
    if ($type == 'book')
        $compatibility_sql = "$section.type='book'";
    elseif ($type == 'app') {
        $compatibility_sql = "(compatibility=4 AND $section.type='app')";
    } else
        $compatibility_sql = "($section.type='book' OR compatibility=4)";
}
// selector end

if ($compatibility_sql)
    $query[] = $compatibility_sql;

$genre = $API->getval('genre', 'int');
$API->TPL->assign('genre', $genre);

if ($genre) {
    $query[] = "genre_id = $genre";
}

$price = $API->getval('price', 'int');
$API->TPL->assign('price', $price);

if ($price == 1) {
    $query['price'] = "price<>'Free'";
} elseif ($price == 2) {
    $query['price'] = "price='Free'";
}

// download_stats_archive table query

$period = $API->getval('period');

if (!in_array($period, explode(',', 'day,week,month,year,all'))) {
    $period = 'day';
}

$API->TPL->assign('period', $period);

if ($period == 'day') {
    $clicks_sql = "clicks_day AS clicks";
} elseif ($period == 'week') {
    $clicks_sql = "clicks_week AS clicks";
} elseif ($period == 'month') {
    $clicks_sql = "clicks_month AS clicks";
} elseif ($period == 'year') {
    $clicks_sql = "clicks_year AS clicks";
} else {
    $clicks_sql = "clicks_all AS clicks";
}

if ($query)
    $where = "WHERE " . implode(' AND ', $query);
else
    $where = '';


// genres selector generation
$genres_cache_query = "SELECT id,name, type, (SELECT COUNT(*) FROM $section WHERE genre_id=genres.id" . ($compatibility_sql ? " AND $compatibility_sql" : '') . ") AS numapps FROM genres" . ($genres_for_search_addition ? " WHERE $genres_for_search_addition" : '') . " ORDER BY numapps DESC";
$genres_cache_name = "genres-" . md5($genres_cache_query);

$genres_cache = $API->CACHE->get('lists_caches', $genres_cache_name);

if ($genres_cache === false) {

    $genres = $API->DB->query_return($genres_cache_query);
    $API->CACHE->set('lists_caches', $genres_cache_name, $genres);
} else
    $genres = $genres_cache;
// translating genres

$to_genres = array('mas' => 'Mac', 'ios' => 'iOS', 'books' => $API->LANG->_('Books'));
if ($genres) {
    foreach ($genres as $k => $g) {
        $genres[$k]['name'] = "{$API->LANG->_($g['name'])} ({$to_genres[$g['type']]})";
    }
}
$API->TPL->assign('genres', $genres);
// end genres, begin apps
/* $appscount_cache_name = 'count-top100-' . md5($where);

  $appscount_cache = $API->CACHE->get('top100', $appscount_cache_name);

  if ($appscount_cache === false) {
  $appscount = $API->DB->get_row_count($section, $where);
  $API->CACHE->set('top100', $appscount_cache_name, $appscount);
  } else
  $appscount = $appscount_cache; */


list($limit, $pagercode) = $API->generate_pagination($appscount, array('top100', 'compatibility', $compatibility, 'price', $price, 'type', $type, 'genre', $genre, 'period', $period));

$API->TPL->assign('pagercode', $pagercode);

$cache_query = "SELECT trackid, compatibility, $clicks_sql, artist_id,image, $section.name, genres.name AS gname, genres.type AS gtype, artists.name AS pname FROM $section LEFT JOIN genres ON $section.genre_id=genres.id LEFT JOIN artists ON $section.artist_id=artists.id $where ORDER BY clicks DESC $limit";

$cache_name = 'data-top100-' . md5($cache_query);

$cache = $API->CACHE->get('top100', $cache_name, 300);
/*
 * no cache for top100 data
 */
//$cache=false;
if ($cache === false) {

    $apps = $API->DB->query_return($cache_query);
    $API->CACHE->set('top100', $cache_name, $apps);
} else
    $apps = $cache;

$API->TPL->assign('apps', $apps);

$API->TPL->assign('navclass', 'ipod');
$API->TPL->assign('pagetitle', $API->LANG->_('Top 100 Apps'));
$API->TPL->assign('footername', $API->LANG->_('Top 100 Apps'));
$API->TPL->display('top100.tpl');
?>