include "../header_top.php";
include "header_general.php";
include "../header_content.php";
$mycontext_order='data_extern DESC';
$mycontext_limit=1;
?>
Albume cu personalități
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() );
mysql_query( "SET NAMES utf8" ) or die ( "Couldn't select: ".mysql_error() );
$result = mysql_query( 'SELECT title FROM imagozone2.g3items WHERE parent_id=3 ORDER BY title', $link ) or die ( "Couldn't select: ".mysql_error() );
mysql_query( "SET NAMES latin1" ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
$autor=iconv('utf-8','windows-1250',$row['title']);
$autor_simplu=str_replace("'",'',str_replace('.','',strtr($autor,'ĂăÂâÎîȘșȚț','AaAaIiSsTt')));
echo '- '.$autor.'';
$result2 = mysql_query( 'SELECT * FROM citatepedia_autor WHERE autor="'.mysql_real_escape_string($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('foto/'.strtolower(strtr($autor," .-'ĂăÂâÎîȘșȚț","____AaAaIiSsTt")).'.jpg')) echo ' - [portret]';
$result3 = mysql_query( 'SELECT COUNT(*) AS _count FROM citatepedia WHERE autor="'.mysql_real_escape_string($autor).'"', $link ) or die ( "Couldn't select: ".mysql_error() );
$row3 = mysql_fetch_array( $result3 );
if ($row3['_count']>0) echo ' | '.$row3['_count'].($row3['_count']>1?' citate':' citat').' în română';
$result4 = mysql_query( 'SELECT COUNT(*) AS _count FROM citatep_en.citatepedia WHERE autor="'.mysql_real_escape_string($autor).'"', $link ) or die ( "Couldn't select: ".mysql_error() );
$row4 = mysql_fetch_array( $result4 );
if ($row4['_count']>0) echo ' | '.$row4['_count'].($row4['_count']>1?' citate':' citat').' în engleză';
echo '
';
$mycontext_limit+=1;
}
$mycontext_limit=1+round($mycontext_limit/20);
}
echo '
';
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>