include "_config.php";
$COMPONENT_SECTION = "4005";
//de aici vine f
include BASE."functii/fo_sesiune.php";
include BASE."functii/conectare.php";
include BASE."functii/rezolva_belele.php";
//conectara la baza de date
include (BASE."include/fa_conectare.php");
//VERIFIC DACA NU CUMVA SE JOACA CU SESIUNEA DIN BROWSER
tratare_sesiune($db);
$undeeste=getenv("REQUEST_URI");
$basefilename=basename($undeeste);
if(stristr($basefilename,"?")){
$explode=explode("?",$basefilename);
$basefilename=$explode[0];
}
if ($tip == 0) $titlu_special_perle = "Elevi";
elseif ($tip == 1) $titlu_special_perle = "Profesori";
else $titlu_special_perle = "toate perlele";
$titlu_special = 'Perle '.$titlu_special_perle.($_GET['pagina'] ? ' - pag '.$_GET['pagina'] : '');
$titlu_special .= ' - Perle de la examene. Perle Elevi. Perle Profesori. ';
mvc::add_breadcrumb('Distractie', HTTP . 'fun/chestii_distractive.html');
mvc::add_breadcrumb('Umor', HTTP . 'fun/umor.php'.$varsid1);
mvc::add_breadcrumb('Perle', HTTP . 'fun/perle.php'.$varsid1);
mvc::add_analytics_params('SECTION', 'Distractie');
mvc::add_analytics_params('SECTION_VALUE', 'Umor');
include (BASE."_header.php");
?>
print "
Perle
";
if(isset($apostat) && ($apostat==1))
{
print "Multumesc pentru perla.
O voi adauga in cel mai scurt timp.
";
}
//verificare tip
$tip=trim($tip);
if(($tip=="")||(($tip!==2)&&($tip==0)&&($tip==1)))
{
$tip=2;
}
$tip=(int)$tip;
//verificare id_perla
$id_perla=trim($id_perla);
if($id_perla==""){$sql_id="";}
else{
$id_perla_g=(int)$id_perla;
$sql_id=" and id_perla='$id_perla_g'";
}
//verificare keyword
$keyword=trim($keyword);
if($keyword==""){$sql_plus_k="";}
else{
$keyword_=rezolva_belele($keyword,3);
$sql_plus_k=" and continut ilike '%$keyword_%'";
}
?>
/*print "
Adauga si tu o \"perla\"
";
*/
?>
//acum formez sql_plus
if($tip==2){$sql_plus="";}
if($tip==0){$sql_plus=" and tip='0'";}
if($tip==1){$sql_plus=" and tip='1'";}
//AICI FAC SELECTUL PENTRU A VEDEA PERLELE
$sql="select count(*) from perla where stare='1' $sql_id $sql_plus $sql_plus_k";
$res_sql=db_query($db,$sql);
$num=pg_result($res_sql,0,0);
if($num!=0){
//-------------------------------
$nr_opinii=$num;
$pe_pag=6;
$tmp=$nr_opinii/$pe_pag;
$nr_pagini=(int)$tmp;
if ($nr_pagini!=$tmp) {$nr_pagini++;}
/* se testeaza pagina, se seteaza pagina pe care se va naviga */
$pagina=(int) $pagina;
if ($pagina<1 || $pagina>$nr_pagini) {$pagina=1;}
$main_file="perle.php";
/* se iau din baza opiniile utile */
$salt=($pagina-1)*$pe_pag;
$sql="select * from perla where stare='1' $sql_id $sql_plus $sql_plus_k order by id_perla desc";
$sql.=" limit $pe_pag OFFSET $salt";
$res_sql=db_query($db,$sql);
$num=pg_numrows($res_sql);
//-------------------------------
?>