Nova arhiva
{source 0}
getQuery(true);
$pageLimit = 70;
error_reporting(E_ALL);
try{
$pp = isset($_GET["pp"]) ? ((int)$_GET["pp"] * $pageLimit) : 0;
}catch(Exception $e){
echo $e->getMessage();
}
$query -> select(" #__k2_items.publish_up as publish_up, #__k2_items.published as published, #__k2_items.title as title,#__k2_attachments.filename as filename");
$query -> from ("#__k2_items");
$query -> innerJoin("#__k2_attachments ON #__k2_attachments.itemID = #__k2_items.id");
$query -> where(" `catid` = 2 AND `published` = 1 AND (SELECT COUNT(*) FROM #__natjecaji_odluke_linkovi WHERE natjecaj_id = #__k2_items.id) = 0");
$query -> order("publish_up DESC");
$query -> setLimit($pageLimit,$pp);
$db -> setQuery( (string) $query );
$rows = $db -> loadAssocList();
$query = $db->getQuery(true);
$query -> select("COUNT(*)");
$query -> from ("#__k2_items");
$query -> where(" `catid` = 2 AND `published` = 1 AND (SELECT COUNT(*) FROM #__natjecaji_odluke_linkovi WHERE natjecaj_id = #__k2_items.id) = 0");
$db -> setQuery( (string) $query );
$count = $db -> loadAssocList()[0]["COUNT(*)"];
$pgs = ceil($count / $pageLimit);
$cpg = floor($pp / $pageLimit);
$actual_link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]";
function unparse_url($parsed_url) {
$scheme = isset($parsed_url['scheme']) ? $parsed_url['scheme'] . '://' : '';
$host = isset($parsed_url['host']) ? $parsed_url['host'] : '';
$port = isset($parsed_url['port']) ? ':' . $parsed_url['port'] : '';
$user = isset($parsed_url['user']) ? $parsed_url['user'] : '';
$pass = isset($parsed_url['pass']) ? ':' . $parsed_url['pass'] : '';
$pass = ($user || $pass) ? "$pass@" : '';
$path = isset($parsed_url['path']) ? $parsed_url['path'] : '';
$query = isset($parsed_url['query']) ? '?' . $parsed_url['query'] : '';
$fragment = isset($parsed_url['fragment']) ? '#' . $parsed_url['fragment'] : '';
return "$scheme$user$pass$host$port$path$query$fragment";
}
function removeQueryParam($url, $param_to_remove) {
$parsed = parse_url($url);
if ($parsed && isset($parsed['query'])) {
$parsed['query'] = implode('&', array_filter(explode('&', $parsed['query']), function($param) use ($param_to_remove) {
return explode('=', $param)[0] !== $param_to_remove;
}));
if ($parsed['query'] === '') unset($parsed['query']);
return unparse_url($parsed);
} else {
return $url;
}
}
?>
Zatvoreni natječaji
{/source}
Naziv
Datum objave
5 ? (5 + $cpg) : $pgs;
for($i = max(0,$cpg - 5) ; $i < $morePgs;$i++){
if(isset($_GET["pp"])){
$act_link = removeQueryParam($act_link,"pp");
unset($_GET["pp"]);
}
$query = parse_url($act_link, PHP_URL_QUERY);
if ($query) {
$url = $act_link . '&pp=' . $i;
} else {
$url = $act_link . '?pp=' . $i;
}
?>
">
