include "../header_top.php";
include "header_general.php";
if ($c)
{
echo 'Subiecte care încep cu '.$c.'
';
include '../meniu_subiect_lista.php';
}
else
{
echo 'Subiecte
';
include '../meniu_subiect_start.php';
}
include "../header_content.php";
include '../config.php';
include '../show_access.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() );
$despre_expl='aforisme';
$result = mysql_query( "SELECT * FROM citatepedia_subiect WHERE subiect='aforisme' LIMIT 1", $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
$mycontext_text=$row['conditie'];
$mycontext_order='data_extern DESC';
if ($c<>"")
{
echo 'Aforisme despre...
';
$result = mysql_query( "SELECT * FROM citatepedia_subiect WHERE doar_aforisme='T' AND LEFT(subiect0,1)='".substr($c,0,1)."' ORDER BY subiect0", $link ) or die ( "Couldn't select: ".mysql_error() );
$mycontext_limit=1+round(mysql_num_rows($result)/20);
echo '';
}
else
{
$mycontext_limit='10';
$date=getdate();
$cond=" citatepedia.tip='0' ";
$sarbatori_cond=$cond;
$sarbatori_subdomain='aforisme';
include '../sarbatori.php';
$despre_cond=$cond;
$result5 = mysql_query( "SELECT * FROM citatepedia_subiect WHERE doar_aforisme='T' ORDER BY accesat_aforisme DESC LIMIT 3", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row5 = mysql_fetch_array( $result5 ) )
{
$subiect=$row5['subiect'];
include '../despre.php';
}
echo 'Alte subiecte accesate recent
';
$result = mysql_query( "SELECT * FROM citatepedia_subiect WHERE doar_aforisme='T' ORDER BY accesat_aforisme DESC LIMIT 4,50", $link ) or die ( "Couldn't select: ".mysql_error() );
echo '';
}
}
echo '
';
include '../module_ad3.php';
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>