0) { $resultoptiuni = mysql_query( 'SELECT * FROM citatepedia_optiuni WHERE userid='.$ID_MEMBER, $link ); $optiuni = mysql_fetch_array( $resultoptiuni ); } include "../header_content.php"; $mycontext_theme='F'; $mycontext_order='data_extern DESC'; $mycontext_limit=1; if ($c<>"") { echo '

'.urldecode($c).'

'; if ($c=='*') $cond="tip='#' AND LEFT(sursa,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') ".$optiuni['ignoratisql']; else $cond="tip='#' AND LEFT(sursa,1)='".substr($c,0,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']; // $result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." ORDER BY termen0 LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); $result = mysql_query( "SELECT id,termen,sursa FROM citatepedia WHERE ".$cond." ORDER BY sursa,termen", $link ) or die ( "Couldn't select: ".mysql_error() ); if (mysql_affected_rows($link)==0) { echo '

Nu sunt titluri de trailere care încep cu litera '.$c.'.

'; } else { while ( $row = mysql_fetch_array( $result ) ) { echo '
  • '.$row['sursa']; if ($row['termen']<>$row['sursa']) echo ' / '.$row['termen']; echo '
  • '; $mycontext_limit+=1; } $mycontext_limit=1+round($mycontext_limit/20); echo '

    '; } include '../module_ad3.php'; } else { $mycontext_limit=(($p-1)*3).',10'; echo '

    Trailere

    '; $cond="tip='#' ".$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"; ?>