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 '

Epigrame • Hexagrame • Poligrame

'; echo '

Parodii • Satire • Fabule

'; echo '

Senryu • Limerickuri

'; echo '

Perle

'; echo '

Murphologie • Calambururi • Culmi

'; echo '

Întrebări și răspunsuri

'; 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 '

Umoristul zilei: '.$row['autor'].'

'; 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"; ?>