fetchAll($sql); $total = count($tmp); $page = !empty($_GET['page']) ? (int)($_GET['page']) : 1; $limit = 10; $pages = ceil($total/$limit); $start = ($page -1)* $limit; $stop= ($page - 1)* $limit + $limit; $sites = array(); foreach($tmp as $k=>$v) { if(!($k >= $start and $k< $stop)) continue; $item = array(); $item['site'] = $v; $item['url'] = Telekom_Cms_Url_Default::getUrl(array( 'siteId' => $v['cms_site_id'], 'subsiteId' => 0, 'lang' => 'pl', 'name' => Telekom_Cms::disablePhpCode($v['name']), 'get' => null )); $sql = "SELECT * FROM cms_files WHERE site_id=".$v['cms_site_id']." and deleted=0 and published=1 order by cms_file_id desc limit 5;"; $files = $db->fetchAll($sql); $item['files'] = $files; $sites[] = $item; } //_dp($sites,1); ?>