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=1;
if ($c<>"")
{
echo ''.urldecode($c).'
';
$cond="tip='1' AND titlu0 LIKE '".substr($c,0,1)."%' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT id,titlu,autor FROM citatepedia WHERE ".$cond." ORDER BY titlu0,autor", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_affected_rows($link)==0)
{
echo 'Nu sunt titluri de monostihuri care încep cu litera '.$c.'.
';
}
else
{
while ( $row = mysql_fetch_array( $result ) )
{
echo ''.$row['titlu'].' de '.$row['autor'].'';
$mycontext_limit+=1;
}
$mycontext_limit=1+round($mycontext_limit/20);
echo '
';
}
include '../module_ad3.php';
}
else
{
$mycontext_limit=(($p-1)*3).',3';
echo 'Pentru o mai clară clasificare, această secţiune include şi monostihurile cu caracter epigramistic.
';
echo 'Monostihuri recent adăugate
';
$cond="tip='1' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT COUNT(*) AS _items FROM citatepedia WHERE ".$cond, $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
$items = $row['_items'];
// $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() );
include "../show_list.php";
include '../module_ad3.php';
include "../navig.php";
}
include "../sidebar.php";
mysql_close( $link );
}
if (!(isset($w) AND $w<>"")) include "../footer_general.php";
?>