include "../header_top.php";
include "header_general.php";
include "../header_content.php";
$mycontext_theme='U';
$mycontext_order='data_extern DESC';
$mycontext_limit=1;
echo 'Autori de tristihuri
';
?>
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() );
$result = mysql_query( "SELECT autor,COUNT(*) AS _count FROM citatepedia WHERE tip='3' AND autor<>'' GROUP BY autor ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
echo '- '.$row['autor'].'';
$result2 = mysql_query( 'SELECT * FROM citatepedia_autor WHERE autor="'.$row['autor'].'" LIMIT 1', $link ) or die ( "Couldn't select: ".mysql_error() );
$row2 = mysql_fetch_array( $result2 );
if ($row2['complet']<>'') echo ' ('.$row2['complet'].')';
if ($row2['observatii']<>'') echo ' - [informaþii]';
if (is_file($citatepedia_path.'/autori/foto/'.strtolower(strtr($row['autor']," .-'ÃãÂâÎÞþ","____AaAaIiSsTt")).'.jpg')) echo ' - [imagine]';
echo ' ('.$row['_count'].($row['_count']>1?' tristihuri':' tristih').')
';
$mycontext_limit+=1;
}
$mycontext_limit=1+round($mycontext_limit/20);
}
echo '
';
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>