Aforiști';
echo 'În partea dreaptă sunt marcate informațiile disponibile despre fiecare aforist (cele scrise cu roșu lipsesc). Oricine poate participa la completarea acestora.
';
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() );
$cacheFile=$citatepedia_path.'/cache_html/'.$home_domain.'_'.md5($_SERVER['REQUEST_URI']);
if(cache_start($cacheFile))
{
echo '';
if ($_GET['filtru']=='a')
{
$result = mysql_query( "SELECT autor,COUNT(*) AS _count FROM citatepedia WHERE tip='0' AND autor<>'' AND autor NOT IN (SELECT autor FROM citatepedia_date WHERE tip='9') AND autor NOT IN (SELECT autor FROM citatepedia_autor WHERE limba NOT IN ('','ro') OR (observatii<>'' AND observatii NOT LIKE '%român%' AND observatii NOT LIKE '%moldov%' AND observatii NOT LIKE '%basarab%') OR contact LIKE '%nu poate fi contactat%') GROUP BY autor HAVING _count>=5 ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
li_author($row['autor'],0,$row['_count'],'aforism','aforisme',0,'','','',true);
}
}
elseif ($_GET['filtru']=='a2')
{
$result = mysql_query( "SELECT autor,COUNT(*) AS _count FROM citatepedia WHERE tip='0' AND autor IN (SELECT autor FROM citatepedia_autor WHERE colaborare LIKE '%Antologia aforismului românesc contemporan, ediția a II-a%') GROUP BY autor ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
li_author($row['autor'],0,$row['_count'],'aforism','aforisme',0,'','','',false);
}
}
else
{
$result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(calitate) AS _vot FROM citatepedia WHERE tip='0' AND autor<>'' GROUP BY autor ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
li_author($row['autor'],($row['_count']>10?$row['_vot']:0),$row['_count'],'aforism','aforisme');
}
}
echo '
';
file_put_contents($cacheFile, ob_get_contents());
ob_end_flush();
}
}
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>