include "../header_top.php";
include "header_general.php";
include '../config.php';
$link = mysql_connect( $citatepedia_serv, $citatepedia_user, $citatepedia_pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
else
{
mysql_select_db( $citatepedia_data,$link ) or die ( "Couldn't open database: ".mysql_error() );
if ($ID_MEMBER>0)
{
$resultoptiuni = mysql_query( 'SELECT * FROM citatepedia_optiuni WHERE userid='.$ID_MEMBER, $link );
$optiuni = mysql_fetch_array( $resultoptiuni );
}
include "../header_content.php";
$mycontext_theme='U';
$mycontext_order='data_extern DESC';
$mycontext_limit=(($p-1)*3).',3';
// fără $optiuni['ignoratisql'] în $sarbatori_cond, ca să meargă join cu join cu common.produse
$cond=" (citatepedia.tip IN ('e','6','7','z','x','m','k','q','s') OR citatepedia.specie IN ('&','z') OR citatepedia.vott>=1) ";
$sarbatori_cond=' citatepedia.vott>1 and citatepedia.voturi>1 ';
$sarbatori_subdomain='umor';
$cond.=$optiuni['ignoratisql'];
if ($_SERVER['REQUEST_URI']=='/')
{
$date=getdate();
echo 'Secțiuni tipice cu umor
';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
include '../content_separator.php';
$cacheFile = $citatepedia_path.'/cache_sql/'.$home_domain.'_aniversarea_zilei';
$row=row_from_cache_by_hour($cacheFile);
if (is_null($row))
{
$result2 = mysql_query( "SELECT SQL_SMALL_RESULT citatepedia.autor,AVG(citatepedia.vott) AS _vott FROM citatepedia INNER JOIN citatepedia_date ON citatepedia.autor=citatepedia_date.autor WHERE citatepedia.voturi>0 AND citatepedia.voti>0 AND citatepedia.tip NOT IN ('#','!','%') AND citatepedia_date.luna='".(strlen($date['mon'])==1?'0':'').$date['mon']."' AND citatepedia_date.ziua='".(strlen($date['mday'])==1?'0':'').$date['mday']."' AND citatepedia_date.tip IN ('0','9') GROUP BY citatepedia.autor HAVING _vott>0.5 ORDER BY _vott DESC LIMIT 1", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_num_rows($result2)>0)
{
$row2 = mysql_fetch_array( $result2 );
$result = mysql_query( 'SELECT * FROM citatepedia WHERE autor="'.$row2['autor'].'" AND lungime<=250 ORDER BY vott DESC,voturi DESC LIMIT 1', $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
if ($home_domain<>'') file_put_contents($cacheFile, $row["id"]);
}
}
if ($row['id']>0)
{
echo '';
author_info($row['autor']);
include '../show_list_item.php';
$cond_plus=' AND autor<>"'.$q_autor.'"';
$mycontext_text.=' "'.$q_autor.'"';
echo 'Mai multe de '.$q_autor.'...
';
author_articles($q_autor);
include '../content_separator.php';
}
$result = mysql_query( 'SELECT * FROM citatepedia WHERE tip="e" AND x_zilei="'.date('Y-m-d').'" AND specie<>"=" LIMIT 1', $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
if ($row['id']>0)
{
echo 'Epigrama zilei
';
include '../show_list_item.php';
$cond_plus=' AND autor<>"'.$q_autor.'"';
include '../content_separator.php';
}
include '../sarbatori.php';
$subiect='umor';
include '../despre.php';
$cacheFile = $citatepedia_path.'/cache_sql/'.$home_domain.'_momentului';
$row=row_from_cache($cacheFile,3600);
if (is_null($row))
{
$row=row_rand("tip IN (' ','0') AND frontal=9 AND vott>=1.5 ".$cond_plus);
if ($home_domain<>'') file_put_contents($cacheFile, $row["id"]);
}
if ($row['id']>0)
{
echo 'Citatul cu haz al momentului
' ;
include '../show_list_item.php';
$cond_plus.=' AND autor<>"'.$q_autor.'"';
echo 'Mai multe citate cu haz...
';
}
$cacheFile = $citatepedia_path.'/cache_sql/'.$home_domain.'_epigrama_momentului';
$row=row_from_cache($cacheFile,3600);
if (is_null($row))
{
$row=row_rand("tip='e' AND frontal=9 AND vott>=1.5 ".$cond_plus);
if ($home_domain<>'') file_put_contents($cacheFile, $row["id"]);
}
if ($row['id']>0)
{
echo 'Epigrama momentului
' ;
include '../show_list_item.php';
$cond_plus.=' AND autor<>"'.$q_autor.'"';
echo 'Mai multe epigrame...
';
}
include '../content_separator.php';
$search_cond=$cond;
$search_type='.';
$search_what='umor';
include '../recent_search.php';
include '../content_separator.php';
$result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." AND voti>0 AND vote>0 AND vott>0 ORDER BY dataora DESC LIMIT 3", $link ) or die ( "Couldn't select: ".mysql_error() );
echo 'Umor recent adăugat
';
include "../show_list.php";
echo 'Mai multe adăugate recent...
';
}
else
{
$items=10*$perpage;
$result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." ORDER BY dataora DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() );
echo 'Umor recent adăugat
';
include "../show_list.php";
include '../module_ad3.php';
$firstpage=1;
include "../navig.php";
}
include "../sidebar.php";
}
if ($_SERVER['REQUEST_URI']=="/index.php" OR $_SERVER['REQUEST_URI']=="/")
{
echo 'Umoriști celebri
';
recommended_authors("Woody Allen","Stanislaw Jerzy Lec","Mae West","H.L. Mencken","Groucho Marx");
}
include "../footer_general.php";
?>