include "../header_top.php";
include "header_general.php";
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() );
if ($ID_MEMBER>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 pentru secvențe 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 'Secvențe
';
$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";
?>