0)
{
$resultoptiuni = mysql_query( 'SELECT * FROM citatepedia_optiuni WHERE userid='.$ID_MEMBER, $link );
$optiuni = mysql_fetch_array( $resultoptiuni );
}
include "../header_content.php";
$mycontext_category='Carti de dragoste,Literatura erotica,Romanticoase,Dragoste';
$mycontext_order='data_extern DESC';
$mycontext_limit=(($p-1)*3).',3';
$cond=$optiuni['ignoratisql'];
if ($_SERVER['REQUEST_URI']=='/')
{
$subiect='iubire';
include '../despre.php';
$subiect='romantism';
include '../despre.php';
$subiect='declarații de dragoste';
include '../despre.php';
$subiect='sărut';
include '../despre.php';
$subiect='logodnă';
include '../despre.php';
$subiect='căsătorie';
include '../despre.php';
if (strpos($_SERVER['HTTP_REFERER'],'sfinti')===false)
{
$subiect='sex';
include '../despre.php';
}
if (strpos($all_match,' -')===false and strpos($all_match,'"')===false) $cond=$match_subiect_against.' ("'.$all_match.'") '.$cond;
else $cond=$match_subiect_against.' (\''.$all_match.'\' IN BOOLEAN MODE) '.$cond;
$result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." AND voti>0 AND vote>0 ORDER BY dataora DESC LIMIT 3", $link ) or die ( "Couldn't select: ".mysql_error() );
echo 'Recent adăugate
';
include "../show_list.php";
echo 'Mai multe adăugate recent...
';
include '../module_ad3.php';
}
else
{
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="iubire" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="romantism" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="declarații de dragoste" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="sărut" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="logodnă" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="căsătorie" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
$result = mysql_query( 'SELECT conditie1 FROM citatepedia_subiect WHERE subiect="sex" LIMIT 1' );
$subrow = mysql_fetch_array( $result );
$all_match.=' '.$subrow['conditie1'];
if (strpos($all_match,' -')===false and strpos($all_match,'"')===false) $cond=$match_subiect_against.' ("'.$all_match.'") '.$cond;
else $cond=$match_subiect_against.' (\''.$all_match.'\' IN BOOLEAN MODE) '.$cond;
$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() );
echo 'Recent adăugate
';
include "../show_list.php";
include '../module_ad3.php';
$firstpage=1;
include "../navig.php";
}
include "../sidebar.php";
mysql_close( $link );
}
include "../footer_general.php";
?>