require_once('jadro/base.php');
definevars("where id='LINK_NEW_WINDOW' or id='META_CATEGORY_DESCRIPTION' or id='RSS_ENABLE' or id='CATEGORY_DESCRIPTION' or id='META_DESC' or id='REWRITE_ENABLED' or id='SITE_DESC' or id='LINKS_PER_PAGE_TOP' or id='CATEGS_PER_COLUMN' or id='FRONT_SUBCATEGS_PER_COLUMN' or id='SUBCATEGS_PER_COLUMN' or id='LINKS_PER_PAGE' or id='FEAT_PER_CAT' or id='SHOW_LATEST_LINKS' or id='SHOW_PREMIUM_LINKS' or id='ENABLE_NUMLINKS' or id='ITEM_DEFAULT_ORDER'");
require_once('jadro/redircat.php');
{
require_once('jadro/smartyfunc.php');
$categoryid='';
$uri=rawurlencode($_GET['uri']);
$uri=str_replace('%2F','/',$uri);
$sq='';
$sq="SELECT id,info,catpath,catname,chid,meta_desc from categories where id='" . intval($_GET['c']) . "'";
$sq="SELECT id,info,catpath,catname,chid,meta_desc from categories where catpath='" . $uri . "'";
{
$rez=$db->Execute($sq);
{
$row=$rez->FetchRow();
$categoryid=$row['id'];
$smarty->assign('chid',$row['chid']);
$smarty->assign('info',$row['info']);
$smarty->assign('categoryid',$row['id']);
if(META_CATEGORY_DESCRIPTION
==1 && $_GET
['p']=='') $smarty->assign('meta_description',$row['meta_desc']);
if(CATEGORY_DESCRIPTION
==1 && $_GET
['p']=='') $smarty->assign('category_description',$row['info']);
$smarty->assign('uri',$row['catpath']);
$smarty->assign('catname',$row['catname']);
unset($row);
}
$rez->Close();
unset($rez);
}
if($uri
!='' && $categoryid
=='') {
@header('HTTP/1.1 301 Moved Permanently');
@header('Location: ' . SITE_URL);
die();
}
if($categoryid
=='' && $_GET
['l']=='' && $_GET
['pm']=='') {
$smarty->assign('categs_per_col',CATEGS_PER_COLUMN);
$sq="SELECT catname,id,catpath,numlinks from categories where parrentcatid='0' order by catname";
$rez=$db->Execute($sq);
$cats=array();
while(!$rez->EOF)
{
$red=$rez->FetchRow();
$subcats=array();
$sq="SELECT catname,id,catpath from categories where parrentcatid='" . $red['id'] ."' order by catname limit 0," . FRONT_SUBCATEGS_PER_COLUMN;
$rez1=$db->Execute($sq);
while(!$rez1->EOF)
{
$red2=$rez1->FetchRow();
$subcats[]=array('catname'=>$red2['catname'],'id'=>$red2['id'],'catpath'=>$red2['catpath']);
}
$rez1->Close();
$cats[]=array('id'=>$red['id'],'catname'=>$red['catname'],'subcats'=>$subcats,'catpath'=>$red['catpath'],'numlinks'=>$red['numlinks']);
unset($subcats);
}
$rez->Close();
$smarty->assign('meta_description',META_DESC);
$smarty->assign('site_desc',SITE_DESC);
$smarty->assign('categories',$cats);
unset($cats,$red,$red2,$rez,$rez1);
}
{
$list=htmlspecialchars_m($_GET['l']);
$links_per_page=$br=LINKS_PER_PAGE;
$feat_per_cat=FEAT_PER_CAT;
$feat_per_cat=$links_per_page=$br='10';
$smarty->assign('sort',$list);
switch($list)
{
{
$order='caption';
break;
}
{
$order='hits';
break;
}
{
$order='pr';
break;
}
{
$order='id desc';
$smarty->assign('catname','Ultimos enlaces');
break;
}
{
$order=ITEM_DEFAULT_ORDER;
break;
}
}
{
$_GET
['p']=(int) $_GET
['p']; if($_GET
['p']=='' || $_GET
['p']==0) $_GET['p']=1;
{
$smarty->assign('categs_per_col',SUBCATEGS_PER_COLUMN);
$sq="SELECT catpath,id,info,catname,numlinks from categories where parrentcatid='" . $categoryid . "' order by catname";
$rez=$db->Execute($sq);
$subcats=array();
while(!$rez->EOF)
{
$red=$rez->FetchRow();
$subcats[]=array('id'=>$red['id'],'catname'=>$red['catname'],'catpath'=>$red['catpath'],'numlinks'=>$red['numlinks']);
}
$smarty->assign('categories',$subcats);
$rez->Close();
unset($subcats,$rez);
}
$sq="SELECT count(*) from link where featured='0' and approved='yes' and categoryid='" . $categoryid . "'";
$o_links=$db->GetOne($sq);
$sq="SELECT count(*) from link where featured='1' and approved='yes' and categoryid='" . $categoryid . "'";
$num_splinks=$db->GetOne($sq);
$br=($_GET['p']-1)*$br;
$sq="SELECT id,sitedesc,url,caption,sitedesc,categoryid from link where featured='1' and approved='yes' and categoryid='$categoryid' order by $order limit 0,$feat_per_cat";
$linkovi=$db->GetAll($sq);
$smarty->assign('featlinks',$linkovi);
$sq="SELECT id,sitedesc,url,caption,sitedesc,hits,sitedesc,categoryid from link where featured='0' and approved='yes' and categoryid='$categoryid' order by $order limit $br,$links_per_page";
$linkovi=$db->GetAll($sq);
$smarty->assign('links',$linkovi);
$smarty->assign('linksperpage',$links_per_page);
$smarty->assign('numfeatlinks',$num_splinks);
$smarty->assign('numlinks',$o_links);
$smarty->assign('page',$_GET['p']);
unset($linkovi,$o_links,$links_per_page,$num_splinks);
}
{
if($_GET
['pm']=='') /* LATEST */ {
$sq="SELECT id,sitedesc,url,caption,sitedesc,hits,sitedesc,categoryid from link where approved='yes' order by $order limit 0," . LINKS_PER_PAGE_TOP;
$linkovi=$db->GetAll($sq);
$smarty->assign('links',$linkovi);
$smarty
->assign
('numlinks',count($linkovi
));
}
elseif($_GET['pm']!='') /* PREMIUM */
{
$sq="SELECT id,sitedesc,url,categoryid,caption from link where featured='1' and approved='yes' order by id desc limit 0," . LINKS_PER_PAGE_TOP;
$linkovi=$db->GetAll($sq);
$smarty->assign('catname','Enlaces premium');
$smarty->assign('featlinks',$linkovi);
$smarty
->assign
('numlinks',count($linkovi
)); }
unset($linkovi);
}
}
}
/* Ultimos Enlaces index */
$newlinks=$db->GetAll("SELECT id,sitedesc,url,caption,sitedesc,hits,sitedesc,categoryid from link where approved='yes' ORDER BY id desc limit 0,100"); //0,5 para mostrar 5 enlaces
$smarty->assign('newlinks',$newlinks);
/* Fin ultimos enlaces index */
/* Top enlaces */
$toplink=$db->GetAll("SELECT id, LEFT(sitedesc,15), url, caption FROM link WHERE approved='yes' ORDER BY id desc LIMIT 0,5"); //0,5 para mostrar 5 enlaces
$smarty->assign('toplink',$toplink);
/* Fin top enlaces */
/* Estadisticas */
$stats
=$db
->GetAll
("(SELECT count(id) as info from categories) UNION (SELECT count(id) from link where approved='yes') UNION ( SELECT count(id) from link where approved='no' and stime='" .
date('Y') .
'-' .
date('m') .
'-' .
date('d') .
"')");$info=array();
$info['numcategs']=$stats[0]['info'];
$info['numlinks']=$stats[1]['info'];
$info['numlinkstoday']=$stats[2]['info'];
unset($stats);
$smarty->assign('infostats',$info);
/* Fin estadisticas */
$smarty->display('main.tpl');