0)
{
$resultoptiuni = mysql_query( 'SELECT * FROM citatepedia_optiuni WHERE userid='.$ID_MEMBER, $link );
$optiuni = mysql_fetch_array( $resultoptiuni );
}
include "../header_content.php";
$result = mysql_query( "SELECT * FROM citatepedia_subiect WHERE subiect='epigrame' LIMIT 1", $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
$mycontext_text=$row['conditie'];
$mycontext_order='data_extern DESC';
$mycontext_limit=1;
if ($c<>"")
{
echo ''.urldecode($c).'
';
$cond="tip='e' AND titlu0 LIKE '".substr($c,0,1)."%' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT id,titlu,autor FROM citatepedia WHERE ".$cond." ORDER BY titlu0,autor", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_affected_rows($link)==0)
{
echo 'Nu sunt titluri de epigrame care încep cu litera '.$c.'.
';
}
else
{
while ( $row = mysql_fetch_array( $result ) )
{
echo ''.$row['titlu'].' de '.$row['autor'].'';
$mycontext_limit+=1;
}
$mycontext_limit=1+round($mycontext_limit/20);
echo '
';
}
include '../module_ad3.php';
}
else
{
$mycontext_limit=(($p-1)*3).',3';
$cond="tip IN ('e','6','7','a') ".$optiuni['ignoratisql'];
$sarbatori_cond=" citatepedia.tip IN ('e','6','7','a') ";
$sarbatori_subdomain='epigrame';
if ($_SERVER['REQUEST_URI']=='/')
{
$date=getdate();
$events_result_born = mysql_query( "SELECT * FROM citatepedia_date WHERE luna='".(strlen($date['mon'])==1?'0':'').$date['mon']."' AND ziua='".(strlen($date['mday'])==1?'0':'').$date['mday']."' AND tip='0' AND autor IN (SELECT DISTINCT autor FROM citatepedia WHERE tip='e') ORDER BY anul", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_num_rows($events_result_born)>0)
{
if (mysql_num_rows($events_result_born)>=2) echo 'Epigramiști aniversați
';
else echo 'Epigramist aniversat
';
while ( $events_row = mysql_fetch_array( $events_result_born ) )
{
$a=$events_row['autor'];
echo ''.$a.' - '.age_in_years($events_row['anul'],$events_row['luna'],$events_row['ziua']).' de ani
';
$result = mysql_query( 'SELECT * FROM citatepedia WHERE tip="e" AND autor="'.mysql_real_escape_string($a).'" ORDER BY calitate DESC,voturi DESC LIMIT 1', $link ) or die ( "Couldn't select: ".mysql_error() );
include '../show_list.php';
$mycontext_text.=' "'.$q_autor.'"';
echo 'Mai multe epigrame de '.$a.'...
';
}
$a='';
}
$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='epigrame';
include '../despre.php';
$cacheFile = $citatepedia_path.'/cache_sql/'.$home_domain.'_momentului';
$row=row_from_cache($cacheFile,3600);
if (is_null($row))
{
$row=row_rand($cond." AND frontal=9 AND vott>=1 ".$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...
';
}
echo 'Specialități cu caracter epigramistic
' ;
echo '';
echo '';
echo '';
include '../content_separator.php';
$search_cond=$cond;
$search_type='c';
$search_what='epigrame';
include '../recent_search.php';
include '../content_separator.php';
$result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." AND voti>0 AND vote>0 ORDER BY dataora DESC LIMIT 3", $link ) or die ( "Couldn't select: ".mysql_error() );
echo 'Epigrame recent adăugate
';
include "../show_list.php";
echo 'Mai multe epigrame 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 'Epigrame recent adăugate
';
include "../info_noutati.php";
include "../show_list.php";
include '../module_ad3.php';
$firstpage=1;
include "../navig.php";
}
}
include "../sidebar.php";
mysql_close( $link );
}
if (!(isset($w) AND $w<>"")) include "../footer_general.php";
?>