<?

// --------------------------------------------------------------------------
//
// Esvon Classifieds v.2.7
// Copyright(C), Esvon LLC, 2001-2003, All Rights Reserved.
// E-mail: products@esvon.com
//
// All forms of reproduction, including, but not limited to, internet posting, 
// printing, e-mailing, faxing and recording are strictly prohibited.
// One license required per site running Esvon Classifieds. 
// To obtain a license for using Esvon Classifieds, please register at
// http://www.esvon.com/index.php?pg=products&subpg=p_classifieds
//
// 09-Jul-2003
//
// --------------------------------------------------------------------------

require './inc/application.php';

$title=$A_LNG['t_pick'];

ShowHeader();

//nav stuff starts
define(DISP_ROWS,50);

if(!$off || $off<0) $off=0;
$number=$off*DISP_ROWS;


$ql='SELECT *,'.$TITLE_FIELD.' AS l_title FROM '.TBL_AD.' WHERE pick="1" AND approved="1"';

if(EN_EXP_DATE) $ql.=' AND exp_date>=NOW()';
$ql.=' ORDER BY catid,'.$TITLE_FIELD;
$res = $db->query($ql);
$numrecs = $db->num_rows($res);

$tpl = new HawkTpl;
$tpl->InitArray('row');

  $catid = -1;
  $z_c = array();
  
  while($v = $db->fetch_assoc($res)){

    if($catid!=$v['catid']){
      $catid = $v['catid'];
      $z_c['cname'] = GetCatPathCached($catid);
      $tpl->AddCell('row',$z_c,'cat');
    }

    if($v['images']) list($v['images']) = explode("\n",$v['images']);
    else $v['images'] = '../../img/no_image.gif';

    $z = $O_LFS->FillCustomFieldsArray($v);
    $z['link_id'] = $v['link_id'];
    $z['images'] = $v['images'];
 
    $tpl->AddCell('row',$z,'link');
                 
  }


$nav=GetNavigation($PHP_SELF,DISP_ROWS,10,$numrecs,$off,'');
//nav stuff ends

$tpl->Parse(TPL_PATH.'featured.htm','$numrecs,$nav',1);

ShowFooter();

?>