<?php

/*------------------------------------------------------------------------*/
// Product: ActualAnalyzer
// Script: ref.php
// Source: http://www.actualscripts.com/
// Copyright: (c) 2002-2006 ActualScripts, Company. All rights reserved.
//
// YOU DON'T NEED TO EDIT ANYTHING IN THIS SCRIPT.
// SEE LICENSE AGREEMENT FOR MORE DETAILS
/*------------------------------------------------------------------------*/

  if($page_id==221) $page_id=201;
  $dy=getdate($conf->dtime-40000);
  $ydtime=mktime(0,0,0,$dy['mon'],$dy['mday'],$dy['year']);
  $lyear=(int)(date('y',$conf->ctime))-(int)(date('y',$conf->btime))+1;
  $dyear=$year;
  $year=$year-(int)(date('Y',$conf->btime))+1;
  if(!strcmp($tint,'today')) {
      if($flag==0) $svalues='SUM(vt) AS v,SUM(hst) AS hs,SUM(htt-vt) AS r,SUM(htt) AS ht';
      $values='vt AS v,hst AS hs,(htt-vt) AS r,htt AS ht';
      $minvalues='MIN(vt) AS minv,MIN(hst) AS minhs,MIN(htt-vt) AS minr,MIN(htt) AS minht';
      $maxvalues='MAX(vt) AS maxv,MAX(hst) AS maxhs,MAX(htt-vt) AS maxr,MAX(htt) AS maxht';
      $sumvalues='SUM(vt) AS sumv,SUM(hst) AS sumhs,SUM(htt-vt) AS sumr,SUM(htt) AS sumht';
      $where=' AND (modify>='.$conf->dtime.' AND (vt!=0 OR hst!=0 OR htt!=0))';
      $dateint=' ('.ldate(2,$conf->dformat,$conf->dtime).') ';
  }
  elseif(!strcmp($tint,'yesterday')) {
      if($flag==0) $svalues='SUM(IF(modify>='.$conf->dtime.',vy,vt)) AS v,SUM(IF(modify>='.$conf->dtime.',hsy,hst)) AS hs,SUM(IF(modify>='.$conf->dtime.',hty-vy,htt-vt)) AS r,SUM(IF(modify>='.$conf->dtime.',hty,htt)) AS ht';
      $values='IF(modify>='.$conf->dtime.',vy,vt) AS v,IF(modify>='.$conf->dtime.',hsy,hst) AS hs,IF(modify>='.$conf->dtime.',hty-vy,htt-vt) AS r,IF(modify>='.$conf->dtime.',hty,htt) AS ht';
      $values='IF(modify>='.$conf->dtime.',vy,vt) AS v,IF(modify>='.$conf->dtime.',hsy,hst) AS hs,IF(modify>='.$conf->dtime.',hty-vy,htt-vt) AS r,IF(modify>='.$conf->dtime.',hty,htt) AS ht';
      $minvalues='MIN(IF(modify>='.$conf->dtime.',vy,vt)) AS minv,MIN(IF(modify>='.$conf->dtime.',hsy,hst)) AS minhs,MIN(IF(modify>='.$conf->dtime.',hty-vy,htt-vt)) AS minr,MIN(IF(modify>='.$conf->dtime.',hty,htt)) AS minht';
      $maxvalues='MAX(IF(modify>='.$conf->dtime.',vy,vt)) AS maxv,MAX(IF(modify>='.$conf->dtime.',hsy,hst)) AS maxhs,MAX(IF(modify>='.$conf->dtime.',hty-vy,htt-vt)) AS maxr,MAX(IF(modify>='.$conf->dtime.',hty,htt)) AS maxht';
      $sumvalues='SUM(IF(modify>='.$conf->dtime.',vy,vt)) AS sumv,SUM(IF(modify>='.$conf->dtime.',hsy,hst)) AS sumhs,SUM(IF(modify>='.$conf->dtime.',hty-vy,htt-vt)) AS sumr,SUM(IF(modify>='.$conf->dtime.',hty,htt)) AS sumht';
      $where=' AND ((modify>='.$conf->dtime.' AND (vy!=0 OR hsy!=0 OR hty!=0)) OR ((modify>='.$ydtime.' AND modify<'.$conf->dtime.') AND (vt!=0 OR hst!=0 OR htt!=0)))';
      $dateint=' ('.ldate(2,$conf->dformat,$ydtime).') ';
  }
  elseif(!strcmp($tint,'week')) {
      if($flag==0) $svalues='SUM(vw) AS v,SUM(hsw) AS hs,SUM(htw-vw) AS r,SUM(htw) AS ht';
      $values='vw AS v,hsw AS hs,htw-vw AS r,htw AS ht';
      $minvalues='MIN(vw) AS minv,MIN(hsw) AS minhs,MIN(htw-vw) AS minr,MIN(htw) AS minht';
      $maxvalues='MAX(vw) AS maxv,MAX(hsw) AS maxhs,MAX(htw-vw) AS maxr,MAX(htw) AS maxht';
      $sumvalues='SUM(vw) AS sumv,SUM(hsw) AS sumhs,SUM(htw-vw) AS sumr,SUM(htw) AS sumht';
      $where=' AND (modify>='.$conf->wtime.' AND (vw!=0 OR hsw!=0 OR htw!=0))';
      if($conf->btime>$conf->wtime) $dateint=' ('.ldate(2,$conf->dformat,$conf->btime).' - '.ldate(2,$conf->dformat,$conf->ctime).')';
      else $dateint=' ('.ldate(2,$conf->dformat,$conf->wtime).' - '.ldate(2,$conf->dformat,$conf->ctime).')';
  }
  elseif(!strcmp($tint,'lastweek')) {
      if($flag==0) $svalues='SUM(IF(modify>='.$conf->wtime.',vlw,vw)) AS v,SUM(IF(modify>='.$conf->wtime.',hslw,hsw)) AS hs,SUM(IF(modify>='.$conf->wtime.',htlw-vlw,htw-vw)) AS r,SUM(IF(modify>='.$conf->wtime.',htlw,htw)) AS ht';
      $values='IF(modify>='.$conf->wtime.',vlw,vw) AS v,IF(modify>='.$conf->wtime.',hslw,hsw) AS hs,IF(modify>='.$conf->wtime.',htlw-vlw,htw-vw) AS r,IF(modify>='.$conf->wtime.',htlw,htw) AS ht';
      $minvalues='MIN(IF(modify>='.$conf->wtime.',vlw,vw)) AS minv,MIN(IF(modify>='.$conf->wtime.',hslw,hsw)) AS minhs,MIN(IF(modify>='.$conf->wtime.',htlw-vlw,htw-vw)) AS minr,MIN(IF(modify>='.$conf->wtime.',htlw,htw)) AS minht';
      $maxvalues='MAX(IF(modify>='.$conf->wtime.',vlw,vw)) AS maxv,MAX(IF(modify>='.$conf->wtime.',hslw,hsw)) AS maxhs,MAX(IF(modify>='.$conf->wtime.',htlw-vlw,htw-vw)) AS maxr,MAX(IF(modify>='.$conf->wtime.',htlw,htw)) AS maxht';
      $sumvalues='SUM(IF(modify>='.$conf->wtime.',vlw,vw)) AS sumv,SUM(IF(modify>='.$conf->wtime.',hslw,hsw)) AS sumhs,SUM(IF(modify>='.$conf->wtime.',htlw-vlw,htw-vw)) AS sumr,SUM(IF(modify>='.$conf->wtime.',htlw,htw)) AS sumht';
      $where=' AND ((modify>='.$conf->wtime.' AND (vlw!=0 OR hslw!=0 OR htlw!=0)) OR ((modify>='.$conf->lwtime.' AND modify<'.$conf->wtime.') AND (vw!=0 OR hsw!=0 OR htw!=0)))';
      if($conf->btime>=$conf->lwtime&&$conf->btime<$conf->wtime) $dateint=' ('.ldate(2,$conf->dformat,$conf->btime).' - '.ldate(2,$conf->dformat,$conf->wtime-7200).')';
      else $dateint=' ('.ldate(2,$conf->dformat,$conf->lwtime).' - '.ldate(2,$conf->dformat,$conf->wtime-7200).')';
  }
  elseif(!strcmp($tint,'month')) {
      if($flag==0) $svalues='SUM(vm) AS v,SUM(hsm) AS hs,SUM(htm-vm) AS r,SUM(htm) AS ht';
      $values='vm AS v,hsm AS hs,htm-vm AS r,htm AS ht';
      $minvalues='MIN(vm) AS minv,MIN(hsm) AS minhs,MIN(htm-vm) AS minr,MIN(htm) AS minht';
      $maxvalues='MAX(vm) AS maxv,MAX(hsm) AS maxhs,MAX(htm-vm) AS maxr,MAX(htm) AS maxht';
      $sumvalues='SUM(vm) AS sumv,SUM(hsm) AS sumhs,SUM(htm-vm) AS sumr,SUM(htm) AS sumht';
      $where=' AND (modify>='.$conf->mtime.' AND (vm!=0 OR hsm!=0 OR htm!=0))';
      if($conf->btime>$conf->mtime) $dateint=' ('.ldate(2,$conf->dformat,$conf->btime).' - '.ldate(2,$conf->dformat,$conf->ctime).')';
      else $dateint=' ('.ldate(2,$conf->dformat,$conf->mtime).' - '.ldate(2,$conf->dformat,$conf->ctime).')';
  }
  elseif(!strcmp($tint,'lastmonth')) {
      if($flag==0) $svalues='SUM(IF(modify>='.$conf->mtime.',vlm,vm)) AS v,SUM(IF(modify>='.$conf->mtime.',hslm,hsm)) AS hs,SUM(IF(modify>='.$conf->mtime.',htlm-vlm,htm-vm)) AS r,SUM(IF(modify>='.$conf->mtime.',htlm,htm)) AS ht';
      $values='IF(modify>='.$conf->mtime.',vlm,vm) AS v,IF(modify>='.$conf->mtime.',hslm,hsm) AS hs,IF(modify>='.$conf->mtime.',htlm-vlm,htm-vm) AS r,IF(modify>='.$conf->mtime.',htlm,htm) AS ht';
      $minvalues='MIN(IF(modify>='.$conf->mtime.',vlm,vm)) AS minv,MIN(IF(modify>='.$conf->mtime.',hslm,hsm)) AS minhs,MIN(IF(modify>='.$conf->mtime.',htlm-vlm,htm-vm)) AS minr,MIN(IF(modify>='.$conf->mtime.',htlm,htm)) AS minht';
      $maxvalues='MAX(IF(modify>='.$conf->mtime.',vlm,vm)) AS maxv,MAX(IF(modify>='.$conf->mtime.',hslm,hsm)) AS maxhs,MAX(IF(modify>='.$conf->mtime.',htlm-vlm,htm-vm)) AS maxr,MAX(IF(modify>='.$conf->mtime.',htlm,htm)) AS maxht';
      $sumvalues='SUM(IF(modify>='.$conf->mtime.',vlm,vm)) AS sumv,SUM(IF(modify>='.$conf->mtime.',hslm,hsm)) AS sumhs,SUM(IF(modify>='.$conf->mtime.',htlm-vlm,htm-vm)) AS sumr,SUM(IF(modify>='.$conf->mtime.',htlm,htm)) AS sumht';
      $where=' AND ((modify>='.$conf->mtime.' AND (vlm!=0 OR hslm!=0 OR htlm!=0)) OR ((modify>='.$conf->lmtime.' AND modify<'.$conf->mtime.') AND (vm!=0 OR hsm!=0 OR htm!=0)))';
      if($conf->btime>=$conf->lmtime&&$conf->btime<$conf->mtime) $dateint=' ('.ldate(2,$conf->dformat,$conf->btime).' - '.ldate(2,$conf->dformat,$conf->mtime-7200).')';
      else $dateint=' ('.ldate(2,$conf->dformat,$conf->lmtime).' - '.ldate(2,$conf->dformat,$conf->mtime-7200).')';
  }
  elseif(!strcmp($tint,'totalm')) {
      if($flag==0) $svalues='SUM(v'.$year.') AS v,SUM(hs'.$year.') AS hs,SUM(ht'.$year.'-v'.$year.') AS r,SUM(ht'.$year.') AS ht';
      $values='v'.$year.' AS v,hs'.$year.' AS hs,ht'.$year.'-v'.$year.' AS r,ht'.$year.' AS ht';
      $minvalues='MIN(v'.$year.') AS minv,MIN(hs'.$year.') AS minhs,MIN(ht'.$year.'-v'.$year.') AS minr,MIN(ht'.$year.') AS minht';
      $maxvalues='MAX(v'.$year.') AS maxv,MAX(hs'.$year.') AS maxhs,MAX(ht'.$year.'-v'.$year.') AS maxr,MAX(ht'.$year.') AS maxht';
      $sumvalues='SUM(v'.$year.') AS sumv,SUM(hs'.$year.') AS sumhs,SUM(ht'.$year.'-v'.$year.') AS sumr,SUM(ht'.$year.') AS sumht';
      $where=' AND (v'.$year.'!=0 OR hs'.$year.'!=0 OR ht'.$year.'!=0)';
      $dateint=' ('.$dyear.') ';
  }
  elseif(!strcmp($tint,'all')||!strcmp($tint,'total')) {
      $vvalues='v1';
      $hsvalues='hs1';
      $htvalues='ht1';
      for($i=2;$i<=$lyear;$i++) {
          $vvalues.='+v'.$i;
          $hsvalues.='+hs'.$i;
          $htvalues.='+ht'.$i;
      }
      if($flag==0) $svalues='SUM('.$vvalues.') AS v,SUM('.$hsvalues.') AS hs,SUM(('.$htvalues.')-('.$vvalues.')) AS r,SUM('.$htvalues.') AS ht';
      $values='('.$vvalues.') AS v,('.$hsvalues.') AS hs,(('.$htvalues.')-('.$vvalues.')) AS r,('.$htvalues.') AS ht';
      $minvalues='MIN('.$vvalues.') AS minv,MIN('.$hsvalues.') AS minhs,MIN(('.$htvalues.')-('.$vvalues.')) AS minr,MIN('.$htvalues.') AS minht';
      $maxvalues='MAX('.$vvalues.') AS maxv,MAX('.$hsvalues.') AS maxhs,MAX(('.$htvalues.')-('.$vvalues.')) AS maxr,MAX('.$htvalues.') AS maxht';
      $sumvalues='SUM('.$vvalues.') AS sumv,SUM('.$hsvalues.') AS sumhs,SUM(('.$htvalues.')-('.$vvalues.')) AS sumr,SUM('.$htvalues.') AS sumht';
      $where=' AND (('.$vvalues.')!=0 OR ('.$hsvalues.')!=0 OR ('.$htvalues.')!=0)';
      $dateint=' ('.ldate(2,$conf->dformat,$conf->btime).' - '.ldate(2,$conf->dformat,$conf->ctime).') ';
  }
  if($flag==0) {
      if($sort['column']==1) $ordert='domain ASC';
      elseif(($sort['table']==1&&$sort['column']==2)||($sort['table']==2&&$sort['column']==2)) $ordert='v DESC,domain ASC';
      elseif(($sort['table']==1&&$sort['column']==3)||($sort['table']==3&&$sort['column']==2)) $ordert='hs DESC,domain ASC';
      elseif(($sort['table']==1&&$sort['column']==4)||($sort['table']==4&&$sort['column']==2)) $ordert='r DESC,domain ASC';
      elseif(($sort['table']==1&&$sort['column']==5)||($sort['table']==5&&$sort['column']==2)) $ordert='ht DESC,domain ASC';
      else $ordert='domain ASC';
  }
  else {
      if($sort['column']==1) $ordert='url ASC';
      elseif(($sort['table']==1&&$sort['column']==2)||($sort['table']==2&&$sort['column']==2)) $ordert='v DESC,url ASC';
      elseif(($sort['table']==1&&$sort['column']==3)||($sort['table']==3&&$sort['column']==2)) $ordert='hs DESC,url ASC';
      elseif(($sort['table']==1&&$sort['column']==4)||($sort['table']==4&&$sort['column']==2)) $ordert='r DESC,url ASC';
      elseif(($sort['table']==1&&$sort['column']==5)||($sort['table']==5&&$sort['column']==2)) $ordert='ht DESC,url ASC';
      else $ordert='url ASC';
  }
  //total results
  $vsumt=0;
  $hssumt=0;
  $htsumt=0;
  $rsumt=0;
  $vavgt=0;
  $hsavgt=0;
  $htavgt=0;
  $ravgt=0;
  $nrect=0;
  $vmint=1000000;
  $hsmint=1000000;
  $htmint=1000000;
  $rmint=1000000;
  $vmaxt=0;
  $hsmaxt=0;
  $htmaxt=0;
  $rmaxt=0;

  if($flag==0) {
      $request='SELECT GET_LOCK("aa_lockv",10)';
      $result=db_query($request,$conf->link);
      if(!$result) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
      if(!db_num_rows($result)) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
      $row=db_fetch_row($result);
      if(!$row[0]) {$err->reason('vdb.php|ref|\'vdb\' is busy -- '.db_error($conf->link));return;}
      db_free_result($result);
      $request='DELETE FROM aa_tmp';
      $result=db_query($request,$conf->link);
      if(!$result) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
      $request='INSERT INTO aa_tmp (refid,visitors,hosts,reloads,hits) SELECT domid,'.$svalues.' FROM aa_ref_total WHERE id='.$page_id.$where.' GROUP BY domid';
      $result=db_query($request,$conf->link);
      if(!$result) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  }

  if($conf->locktab) {
    if($flag==0) $request='LOCK TABLES aa_domains READ,aa_tmp READ';
    else $request='LOCK TABLES aa_ref_base READ,aa_ref_total READ';
    $result=db_query($request,$conf->link);
    if(!$result) {$err->reason('vdb.php|ref|blocking of tables has failed -- '.db_error($conf->link));return;}
  }

  if($flag==0) $request='SELECT domain AS name,visitors AS v,hosts AS hs,hits AS ht,reloads AS r FROM aa_tmp LEFT OUTER JOIN aa_domains ON aa_tmp.refid=aa_domains.domid ORDER BY '.$ordert.' LIMIT '.$begstr.','.$numstr;
  elseif($flag==1) $request='SELECT url AS name,'.$values.' FROM aa_ref_total LEFT OUTER JOIN aa_ref_base ON aa_ref_total.refid=aa_ref_base.refid WHERE id='.$page_id.$where.' ORDER BY '.$ordert.' LIMIT '.$begstr.','.$numstr;
  elseif($flag==2) $request='SELECT url AS name,'.$values.' FROM aa_ref_total LEFT OUTER JOIN aa_ref_base ON aa_ref_total.refid=aa_ref_base.refid WHERE id='.$page_id.' AND aa_ref_base.flag=1'.$where.' ORDER BY '.$ordert.' LIMIT '.$begstr.','.$numstr;
  elseif($flag==3) $request='SELECT url AS name,'.$values.' FROM aa_ref_total LEFT OUTER JOIN aa_ref_base ON aa_ref_total.refid=aa_ref_base.refid WHERE id='.$page_id.' AND aa_ref_base.flag=2'.$where.' ORDER BY '.$ordert.' LIMIT '.$begstr.','.$numstr;
  $result=db_query($request,$conf->link);
  if(!$result) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}

  if($flag==0) $request='SELECT MIN(visitors) AS minv,MIN(hosts) AS minhs,MIN(hits-visitors) AS minr,MIN(hits) AS minht,MAX(visitors) AS maxv,MAX(hosts) AS maxhs,MAX(hits-visitors) AS maxr,MAX(hits) AS maxht,SUM(visitors) AS sumv,SUM(hosts) AS sumhs,SUM(hits-visitors) AS sumr,SUM(hits) AS sumht,COUNT(*) AS nrect FROM aa_tmp';
  elseif($flag==1) $request='SELECT '.$minvalues.','.$maxvalues.','.$sumvalues.',COUNT(*) AS nrect FROM aa_ref_total WHERE id='.$page_id.$where;
  elseif($flag==2) $request='SELECT '.$minvalues.','.$maxvalues.','.$sumvalues.',COUNT(*) AS nrect FROM aa_ref_total LEFT OUTER JOIN aa_ref_base ON aa_ref_total.refid=aa_ref_base.refid WHERE id='.$page_id.' AND aa_ref_base.flag=1'.$where;
  elseif($flag==3) $request='SELECT '.$minvalues.','.$maxvalues.','.$sumvalues.',COUNT(*) AS nrect FROM aa_ref_total LEFT OUTER JOIN aa_ref_base ON aa_ref_total.refid=aa_ref_base.refid WHERE id='.$page_id.' AND aa_ref_base.flag=2'.$where;
  $resultt=db_query($request,$conf->link);
  if(!$resultt) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}

  if($conf->locktab) {
    $request='UNLOCK TABLES';
    $resultu=db_query($request,$conf->link);
    if(!$resultu) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  }

  if($flag==0) {
      $request='DELETE FROM aa_tmp';
      $resultd=db_query($request,$conf->link);
      if(!$resultd) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
      $request='SELECT RELEASE_LOCK("aa_lockv")';
      $reslock=db_query($request,$conf->link);
      if(!$reslock) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
      db_free_result($reslock);
  }

  while($row=db_fetch_object($resultt)) {
      $nrect=$row->nrect;
      if($nrect) {
          $vsumt=$row->sumv;
          $hssumt=$row->sumhs;
          $htsumt=$row->sumht;
          $rsumt=$row->sumr;
          $vmint=$row->minv;
          $hsmint=$row->minhs;
          $htmint=$row->minht;
          $rmint=$row->minr;
          $vmaxt=$row->maxv;
          $hsmaxt=$row->maxhs;
          $htmaxt=$row->maxht;
          $rmaxt=$row->maxr;
          $vavgt=sprintf("%.0f",$vsumt/$nrect);
          $hsavgt=sprintf("%.0f",$hssumt/$nrect);
          $htavgt=sprintf("%.0f",$htsumt/$nrect);
          $ravgt=sprintf("%.0f",$rsumt/$nrect);
      }
      else {
          $vmint=0;
          $hsmint=0;
          $htmint=0;
          $rmint=0;
      }
  }
  db_free_result($resultt);

  // length of column for graphic view
  $maxlen=175;
  // max values
  $vmax=0;
  $hsmax=0;
  $htmax=0;
  $rmax=0;
  $vmin=100000;                               //min values
  $hsmin=100000;
  $htmin=100000;
  $rmin=100000;
  $vs=0;                //page sum
  $hss=0;
  $hts=0;
  $rs=0;
  if($numstr>$nrect) $numstr=$nrect;               //nrect - the number of total pages in group/groups
  $nrec=$nrect-$begstr;                            //nrec - the number of frames pages in group/groups
  if($nrec>$numstr) $nrec=$numstr;

  require './style/'.$conf->style.'/template/vpr_a.php';
  $vars['LISTLEN']=$nrect;
  $vars['STAB']=1;
  $vars['REF']='summary';
  $vars['HEADER']=_SUMMARY.' / ';
  if($flag==0) { $vars['ITEM']=_REFSERV; $vars['RHEADER']=_REFSERVS; }
  elseif($flag==1) { $vars['ITEM']=_REFPG; $vars['RHEADER']=_ALLREFPGS; }
  elseif($flag==2) { $vars['ITEM']=_REFPG; $vars['RHEADER']=_INTREFPGS; }
  elseif($flag==3) { $vars['ITEM']=_REFPG; $vars['RHEADER']=_EXTREFPGS; }
  if($nrect) $vars['RANGE']=($begstr+1).' - '.($begstr+$nrec).' '._OUTOF.' '.$nrect;
  else $vars['RANGE']='0 - 0 '._OUTOF.' '.$nrect;
  $vars['SHOWING']=_SHOWING.' '.$nrec.' '._ITEM_S;
  $fname=$name;
  if(strlen($fname)>_VS_PGSTITLITEM) $sname=substr($fname,0,_VS_PGSTITLITEM-3).'...';
  else $sname=$fname;
  if($page_id>200) {
    $vars['GRPG']=_GROUP;
    $vars['FPG']=_FORGR." '<b><i>".$name."</i></b>'";
    //new design
    if(isset($stnew)) {
      $vars['FPG']=_FORGR.': '.$name;
    }
  }
  else {
    $vars['GRPG']=_PAGE;
    $vars['FPG']=_FORPG.' \'<a href="'.$url.'" title="'.$fname.'" target=_blank><code class=ctx><b><i>'.$sname."</i></b></code></a>'";
    //new design
    if(isset($stnew)) {
      $sname=chunk_split($name,10,$ybsp);
      $vars['PGURL']=$url;
      $vars['GRPGSHORT']=$sname;
      $vars['FPG']=_FORPG.': '.ltparse($tlink,$vars);
    }
  }
  if(!strcmp($tint,'month')) $vars['THEADER']=_MONTH.$dateint;
  elseif(!strcmp($tint,'week')) $vars['THEADER']=_WEEK.$dateint;
  elseif(!strcmp($tint,'yesterday')) $vars['THEADER']=_YESTERDAY.$dateint;
  elseif(!strcmp($tint,'today')) $vars['THEADER']=_TODAY.$dateint;
  elseif(!strcmp($tint,'totalm')) $vars['THEADER']=_YEAR.$dateint;
  elseif(!strcmp($tint,'lastweek')) $vars['THEADER']=_LASTWEEK.$dateint;
  elseif(!strcmp($tint,'lastmonth')) $vars['THEADER']=_LASTMONTH.$dateint;
  elseif(!strcmp($tint,'all')||!strcmp($tint,'total')) $vars['THEADER']=_ALLTIME.$dateint;
  $vars['DETAIL']=_DETAILED;
  $vars['VISITORS']=_VISITORS;
  $vars['HOSTS']=_HOSTS;
  $vars['RELOADS']=_RELOADS;
  $vars['HITS']=_HITS;
  $vars['SORTBYN']=_SORTBYN;
  $vars['SORTBYV']=_SORTBYV;
  $vars['SORTBYHT']=_SORTBYHT;
  $vars['SORTBYHS']=_SORTBYHS;
  $vars['SORTBYR']=_SORTBYR;
  $vars['SORTBYP']=_SORTBYP;
  $vars['LBEG']=_STARTOFLIST;
  $vars['LLSCR']=_PREVPG;
  $vars['LRSCR']=_NEXTPG;
  $vars['LEND']=_ENDOFLIST;
  $vars['LLLSCR']=_10PGSBACK;
  $vars['LRLSCR']=_10PGSFORWARD;
  tparse($top,$vars);
  $num=$begstr+1;
  $minf=0;

  $rdid=$conf->ctime;
  $rdid=substr($rdid,2);
  srand((double)microtime() * 1000000);
  $rv=rand(1,41);
  $rdid=$rv.$rdid;
  $vars['PICTID']=$rdid;
  $rdnum=1;
  $request='DELETE FROM aa_rdata WHERE added<'.($conf->ctime-$conf->mrrdata*3600);
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.',0,"'.($page_id.'|'.$vars['THEADER']).'","",'.$num.',0,0,0,0,0,0,0,0,0,0,0)';
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}

  $vars['MODULE']='graph';
  $vars['TITLE']=_BAR;
  $vars['ELEM']='bar';
  tparse($button,$vars);
  tparse($etop,$vars);

  if(db_num_rows($result)) {
      db_data_seek($result,0);
      while($row=db_fetch_object($result)) {
          $vars['NUM']=$num++;
          $vars['VISITORS']=$row->v;
          $vars['HOSTS']=$row->hs;
          $vars['HITS']=$row->ht;
          $vars['RELOADS']=$row->r;
          if($flag==0) {
              if(!strcmp($row->name,'undefined')) { $vars['REFSHORT']=_DIRECT; $rd=_DIRECT; }
              else { $vars['REFSHORT']=$row->name; $rd=$row->name; }
              tparse($cplain,$vars);
          }
          else {
              if(strcmp($row->name,'undefined')) {
                  $fname='http://'.$row->name;
                  $fname=str_replace("\\","/",$fname);
                  if(strlen($fname)>_VS_REFPGS) $sname=substr($fname,0,_VS_REFPGS-3).'...';
                  else $sname=$fname;
                  //new design
                  if(isset($stnew)) $sname=chunk_split($fname,10,$ybsp);
                  $vars['REFERRER']=$fname;
                  $vars['REFSHORT']=$sname;
                  $rd=$fname;
                  tparse($curl,$vars);
              }
              else { $vars['REFSHORT']=_DIRECT; $rd=_DIRECT; tparse($cplain,$vars); }
          }
          //frames parameters
          $vmax=max($vmax,$row->v);
          $hsmax=max($hsmax,$row->hs);
          $htmax=max($htmax,$row->ht);
          $rmax=max($rmax,$row->r);
          $vmin=min($vmin,$row->v);
          $hsmin=min($hsmin,$row->hs);
          $htmin=min($htmin,$row->ht);
          $rmin=min($rmin,$row->r);
          $minf=1;
          $vs+=$row->v;
          $hss+=$row->hs;
          $hts+=$row->ht;
          $rs+=$row->r;

          $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.','.$rdnum.',"'.preg_replace("/\"/",'\\\"',$rd).'","",0,'.($vsumt?sprintf("%.2f",$row->v/$vsumt*100):'0.00').','.$row->v.',0,'.($hssumt?sprintf("%.2f",$row->hs/$hssumt*100):'0.00').','.$row->hs.',0,'.($rsumt?sprintf("%.2f",$row->r/$rsumt*100):'0.00').','.$row->r.',0,'.($htsumt?sprintf("%.2f",$row->ht/$htsumt*100):'0.00').','.$row->ht.')';
          $result1=db_query($request,$conf->link);
          if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
          $rdnum++;
      }
  }
  else { $vars['TEXT']=_NORECORDS; tparse($empty,$vars); }

  if(!$minf) { $vmin=0; $hsmin=0; $htmin=0; $rmin=0; }
  if($nrec) {
      $av=sprintf("%.0f",$vs/$nrec);
      $ahs=sprintf("%.0f",$hss/$nrec);
      $aht=sprintf("%.0f",$hts/$nrec);
      $ar=sprintf("%.0f",$rs/$nrec);
  }
  else { $av=0; $ahs=0; $aht=0; $ar=0; }
  if($numstr<$nrect) {
        $vars['VISITORS']=$vs;
        $vars['HOSTS']=$hss;
        $vars['HITS']=$hts;
        $vars['RELOADS']=$rs;
        tparse($delimiter,$vars);
        $vars['NAME']=_MINIMUM;
        $vars['VISITORS']=$vmin;
        $vars['HOSTS']=$hsmin;
        $vars['HITS']=$htmin;
        $vars['RELOADS']=$rmin;
        tparse($foot,$vars);
        $vars['NAME']=_AVERAGE;
        $vars['VISITORS']=$av;
        $vars['HOSTS']=$ahs;
        $vars['HITS']=$aht;
        $vars['RELOADS']=$ar;
        tparse($foot,$vars);
        $vars['NAME']=_MAXIMUM;
        $vars['VISITORS']=$vmax;
        $vars['HOSTS']=$hsmax;
        $vars['HITS']=$htmax;
        $vars['RELOADS']=$rmax;
        tparse($foot,$vars);
  }
  if($nrect) $vars['NAME']=_TOTAL.' (1 - '.$nrect.')';
  else $vars['NAME']=_TOTAL.' (0 - 0)';
  $vars['VISITORS']=$vsumt;
  $vars['HOSTS']=$hssumt;
  $vars['HITS']=$htsumt;
  $vars['RELOADS']=$rsumt;
  tparse($delimiter2,$vars);
  $vars['NAME']=_MINIMUM;
  $vars['VISITORS']=$vmint;
  $vars['HOSTS']=$hsmint;
  $vars['HITS']=$htmint;
  $vars['RELOADS']=$rmint;
  tparse($foot,$vars);
  $vars['NAME']=_AVERAGE;
  $vars['VISITORS']=$vavgt;
  $vars['HOSTS']=$hsavgt;
  $vars['HITS']=$htavgt;
  $vars['RELOADS']=$ravgt;
  tparse($foot,$vars);
  $vars['NAME']=_MAXIMUM;
  $vars['VISITORS']=$vmaxt;
  $vars['HOSTS']=$hsmaxt;
  $vars['HITS']=$htmaxt;
  $vars['RELOADS']=$rmaxt;
  tparse($foot,$vars);
  $vars['BACKTT']=_BACKTOTOP;
  tparse($bottom,$vars);

  require './style/'.$conf->style.'/template/vpr_d.php';

  //VISITORS
  $fshow=true;
  if(isset($stnew)) {
    if(!($this->shreps & 0x2)) $fshow=false;
  }

if($fshow) {
  $vars['STAB']=2;
  $vars['HEADER']=_VISITORS.' / ';
  $vars['REF']='visitors';
  $vars['TOTAL']=_VISITORS;
  $vars['GRAPHIC']=_GRAPHIC;
  $vars['SORT']=_SORTBYV;
  tparse($top,$vars);
  $vars['MODULE']='graph';
  $vars['TITLE']=_PIE;
  $vars['ELEM']='pie';
  tparse($button,$vars);
  $vars['TITLE']=_BAR;
  $vars['ELEM']='bar';
  tparse($button,$vars);
  tparse($etop,$vars);

  $num=$begstr+1;
  $minf=0;
  if(db_num_rows($result)) {
      db_data_seek($result,0);
      while($row=db_fetch_object($result)) {
          $vars['NUM']=$num++;
          $vars['TOTAL']=$row->v;
          $vars['PER']=$vsumt?sprintf("%.2f",$row->v/$vsumt*100):'0.00';
          $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$row->v/$vmaxt):0;
          //new design
          if(isset($stnew)) {
            if($vmaxt) $vars['GRAPHIC']=(int)(90*$row->v/$vmaxt);
            else $vars['GRAPHIC']=1;
            if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
            $vars['GRAPHIC'].='%';
          }
          if($flag==0) {
              if(!strcmp($row->name,'undefined')) $vars['REFSHORT']=_DIRECT;
              else $vars['REFSHORT']=$row->name;
              tparse($cplain,$vars);
          }
          else {
              if(strcmp($row->name,'undefined')) {
                  $fname='http://'.$row->name;
                  $fname=str_replace("\\","/",$fname);
                  if(strlen($fname)>_VS_REFPGS) $sname=substr($fname,0,_VS_REFPGS-3).'...';
                  else $sname=$fname;
                  //new design
                  if(isset($stnew)) $sname=chunk_split($fname,10,$ybsp);
                  $vars['REFERRER']=$fname;
                  $vars['REFSHORT']=$sname;
                  tparse($curl,$vars);
              }
              else { $vars['REFSHORT']=_DIRECT; tparse($cplain,$vars); }
          }
      }
  }
  else { $vars['TEXT']=_NORECORDS; tparse($empty,$vars); }
  if($numstr<$nrect) {
        $vars['TOTAL']=$vs;
        $vars['PER']=$vsumt?sprintf("%.2f",$vs/$vsumt*100):'0.00';
        tparse($delimiter,$vars);
        $vars['NAME']=_MINIMUM;
        $vars['TOTAL']=$vmin;
        $vars['PER']=$vsumt?sprintf("%.2f",$vmin/$vsumt*100):'0.00';
        $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$vmin/$vmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($vmaxt) $vars['GRAPHIC']=(int)(90*$vmin/$vmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_AVERAGE;
        $vars['TOTAL']=$av;
        $vars['PER']=$vsumt?sprintf("%.2f",$av/$vsumt*100):'0.00';
        $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$av/$vmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($vmaxt) $vars['GRAPHIC']=(int)(90*$av/$vmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_MAXIMUM;
        $vars['TOTAL']=$vmax;
        $vars['PER']=$vsumt?sprintf("%.2f",$vmax/$vsumt*100):'0.00';
        $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$vmax/$vmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($vmaxt) $vars['GRAPHIC']=(int)(90*$vmax/$vmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
  }
  if($nrect) $vars['NAME']=_TOTAL.' (1 - '.$nrect.')';
  else $vars['NAME']=_TOTAL.' (0 - 0)';
  $vars['TOTAL']=$vsumt;
  $vars['PER']='100.00';
  tparse($delimiter2,$vars);
  $vars['NAME']=_MINIMUM;
  $vars['TOTAL']=$vmint;
  $vars['PER']=$vsumt?sprintf("%.2f",$vmint/$vsumt*100):'0.00';
  $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$vmint/$vmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($vmaxt) $vars['GRAPHIC']=(int)(90*$vmint/$vmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_AVERAGE;
  $vars['TOTAL']=$vavgt;
  $vars['PER']=$vsumt?sprintf("%.2f",$vavgt/$vsumt*100):'0.00';
  $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$vavgt/$vmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($vmaxt) $vars['GRAPHIC']=(int)(90*$vavgt/$vmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_MAXIMUM;
  $vars['TOTAL']=$vmaxt;
  $vars['PER']=$vsumt?sprintf("%.2f",$vmaxt/$vsumt*100):'0.00';
  $vars['GRAPHIC']=$vmaxt?(int)($maxlen*$vmaxt/$vmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($vmaxt) $vars['GRAPHIC']=(int)(90*$vmaxt/$vmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  tparse($bottom,$vars);
}

  //HOSTS
  $fshow=true;
  if(isset($stnew)) {
    if(!($this->shreps & 0x4)) $fshow=false;
  }

if($fshow) {
  $vars['STAB']=3;
  $vars['HEADER']=_HOSTS.' / ';
  $vars['REF']='hosts';
  $vars['TOTAL']=_HOSTS;
  $vars['GRAPHIC']=_GRAPHIC;
  $vars['SORT']=_SORTBYHS;
  tparse($top,$vars);
  $vars['MODULE']='graph';
  $vars['TITLE']=_PIE;
  $vars['ELEM']='pie';
  tparse($button,$vars);
  $vars['TITLE']=_BAR;
  $vars['ELEM']='bar';
  tparse($button,$vars);
  tparse($etop,$vars);
  $num=$begstr+1;
  $minf=0;
  if(db_num_rows($result)) {
      db_data_seek($result,0);
      while($row=db_fetch_object($result)) {
          $vars['NUM']=$num++;
          $vars['TOTAL']=$row->hs;
          $vars['PER']=$hssumt?sprintf("%.2f",$row->hs/$hssumt*100):'0.00';
          $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$row->hs/$hsmaxt):'0';
          //new design
          if(isset($stnew)) {
            if($hsmaxt) $vars['GRAPHIC']=(int)(90*$row->hs/$hsmaxt);
            else $vars['GRAPHIC']=1;
            if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
            $vars['GRAPHIC'].='%';
          }
          if($flag==0) {
              if(!strcmp($row->name,'undefined')) $vars['REFSHORT']=_DIRECT;
              else $vars['REFSHORT']=$row->name;
              tparse($cplain,$vars);
          }
          else {
              if(strcmp($row->name,'undefined')) {
                  $fname='http://'.$row->name;
                  $fname=str_replace("\\","/",$fname);
                  if(strlen($fname)>_VS_REFPGS) $sname=substr($fname,0,_VS_REFPGS-3).'...';
                  else $sname=$fname;
                  //new design
                  if(isset($stnew)) $sname=chunk_split($fname,10,$ybsp);
                  $vars['REFERRER']=$fname;
                  $vars['REFSHORT']=$sname;
                  tparse($curl,$vars);
              }
              else { $vars['REFSHORT']=_DIRECT; tparse($cplain,$vars); }
          }
      }
  }
  else { $vars['TEXT']=_NORECORDS; tparse($empty,$vars); }
  if($numstr<$nrect) {
        $vars['TOTAL']=$hss;
        $vars['PER']=$hssumt?sprintf("%.2f",$hss/$hssumt*100):'0.00';
        tparse($delimiter,$vars);
        $vars['NAME']=_MINIMUM;
        $vars['TOTAL']=$hsmin;
        $vars['PER']=$hssumt?sprintf("%.2f",$hsmin/$hssumt*100):'0.00';
        $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$hsmin/$hsmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($hsmaxt) $vars['GRAPHIC']=(int)(90*$hsmin/$hsmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_AVERAGE;
        $vars['TOTAL']=$ahs;
        $vars['PER']=$hssumt?sprintf("%.2f",$ahs/$hssumt*100):'0.00';
        $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$ahs/$hsmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($hsmaxt) $vars['GRAPHIC']=(int)(90*$ahs/$hsmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_MAXIMUM;
        $vars['TOTAL']=$hsmax;
        $vars['PER']=$hssumt?sprintf("%.2f",$hsmax/$hssumt*100):'0.00';
        $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$hsmax/$hsmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($hsmaxt) $vars['GRAPHIC']=(int)(90*$hsmax/$hsmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
  }
  if($nrect) $vars['NAME']=_TOTAL.' (1 - '.$nrect.')';
  else $vars['NAME']=_TOTAL.' (0 - 0)';
  $vars['TOTAL']=$hssumt;
  $vars['PER']='100.00';
  tparse($delimiter2,$vars);
  $vars['NAME']=_MINIMUM;
  $vars['TOTAL']=$hsmint;
  $vars['PER']=$hssumt?sprintf("%.2f",$hsmint/$hssumt*100):'0.00';
  $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$hsmint/$hsmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($hsmaxt) $vars['GRAPHIC']=(int)(90*$hsmint/$hsmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_AVERAGE;
  $vars['TOTAL']=$hsavgt;
  $vars['PER']=$hssumt?sprintf("%.2f",$hsavgt/$hssumt*100):'0.00';
  $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$hsavgt/$hsmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($hsmaxt) $vars['GRAPHIC']=(int)(90*$hsavgt/$hsmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_MAXIMUM;
  $vars['TOTAL']=$hsmaxt;
  $vars['PER']=$hssumt?sprintf("%.2f",$hsmaxt/$hssumt*100):'0.00';
  $vars['GRAPHIC']=$hsmaxt?(int)($maxlen*$hsmaxt/$hsmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($hsmaxt) $vars['GRAPHIC']=(int)(90*$hsmaxt/$hsmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  tparse($bottom,$vars);
}

  //RELOADS
  $fshow=true;
  if(isset($stnew)) {
    if(!($this->shreps & 0x8)) $fshow=false;
  }

if($fshow) {
  $vars['STAB']=4;
  $vars['HEADER']=_RELOADS.' / ';
  $vars['REF']='reloads';
  $vars['TOTAL']=_RELOADS;
  $vars['GRAPHIC']=_GRAPHIC;
  $vars['SORT']=_SORTBYR;
  tparse($top,$vars);
  $vars['MODULE']='graph';
  $vars['TITLE']=_PIE;
  $vars['ELEM']='pie';
  tparse($button,$vars);
  $vars['TITLE']=_BAR;
  $vars['ELEM']='bar';
  tparse($button,$vars);
  tparse($etop,$vars);
  $num=$begstr+1;
  $minf=0;
  if(db_num_rows($result)) {
      db_data_seek($result,0);
      while($row=db_fetch_object($result)) {
          $vars['NUM']=$num++;
          $vars['TOTAL']=$row->r;
          $vars['PER']=$rsumt?sprintf("%.2f",$row->r/$rsumt*100):'0.00';
          $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$row->r/$rmaxt):'0';
              //new design
              if(isset($stnew)) {
                if($rmaxt) $vars['GRAPHIC']=(int)(90*$row->r/$rmaxt);
                else $vars['GRAPHIC']=1;
                if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
                $vars['GRAPHIC'].='%';
              }
          if($flag==0) {
              if(!strcmp($row->name,'undefined')) $vars['REFSHORT']=_DIRECT;
              else $vars['REFSHORT']=$row->name;
              tparse($cplain,$vars);
          }
          else {
              if(strcmp($row->name,'undefined')) {
                  $fname='http://'.$row->name;
                  $fname=str_replace("\\","/",$fname);
                  if(strlen($fname)>_VS_REFPGS) $sname=substr($fname,0,_VS_REFPGS-3).'...';
                  else $sname=$fname;
                      //new design
                      if(isset($stnew)) $sname=chunk_split($fname,10,$ybsp);
                  $vars['REFERRER']=$fname;
                  $vars['REFSHORT']=$sname;
                  tparse($curl,$vars);
              }
              else { $vars['REFSHORT']=_DIRECT; tparse($cplain,$vars); }
          }
      }
  }
  else { $vars['TEXT']=_NORECORDS; tparse($empty,$vars); }
  if($numstr<$nrect) {
        $vars['TOTAL']=$rs;
        $vars['PER']=$rsumt?sprintf("%.2f",$rs/$rsumt*100):'0.00';
        tparse($delimiter,$vars);
        $vars['NAME']=_MINIMUM;
        $vars['TOTAL']=$rmin;
        $vars['PER']=$rsumt?sprintf("%.2f",$rmin/$rsumt*100):'0.00';
        $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$rmin/$rmaxt):'0';
            //new design
            if(isset($stnew)) {
              if($rmaxt) $vars['GRAPHIC']=(int)(90*$rmin/$rmaxt);
              else $vars['GRAPHIC']=1;
              if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
              $vars['GRAPHIC'].='%';
            }
        tparse($foot,$vars);
        $vars['NAME']=_AVERAGE;
        $vars['TOTAL']=$ar;
        $vars['PER']=$rsumt?sprintf("%.2f",$ar/$rsumt*100):'0.00';
        $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$ar/$rmaxt):'0';
            //new design
            if(isset($stnew)) {
              if($rmaxt) $vars['GRAPHIC']=(int)(90*$ar/$rmaxt);
              else $vars['GRAPHIC']=1;
              if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
              $vars['GRAPHIC'].='%';
            }
        tparse($foot,$vars);
        $vars['NAME']=_MAXIMUM;
        $vars['TOTAL']=$rmax;
        $vars['PER']=$rsumt?sprintf("%.2f",$rmax/$rsumt*100):'0.00';
        $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$rmax/$rmaxt):'0';
            //new design
            if(isset($stnew)) {
              if($rmaxt) $vars['GRAPHIC']=(int)(90*$rmax/$rmaxt);
              else $vars['GRAPHIC']=1;
              if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
              $vars['GRAPHIC'].='%';
            }
        tparse($foot,$vars);
  }
  if($nrect) $vars['NAME']=_TOTAL.' (1 - '.$nrect.')';
  else $vars['NAME']=_TOTAL.' (0 - 0)';
  $vars['TOTAL']=$rsumt;
  $vars['PER']='100.00';
  tparse($delimiter2,$vars);
  $vars['NAME']=_MINIMUM;
  $vars['TOTAL']=$rmint;
  $vars['PER']=$rsumt?sprintf("%.2f",$rmint/$rsumt*100):'0.00';
  $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$rmint/$rmaxt):'0';
      //new design
      if(isset($stnew)) {
        if($rmaxt) $vars['GRAPHIC']=(int)(90*$rmint/$rmaxt);
        else $vars['GRAPHIC']=1;
        if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
        $vars['GRAPHIC'].='%';
      }
  tparse($foot,$vars);
  $vars['NAME']=_AVERAGE;
  $vars['TOTAL']=$ravgt;
  $vars['PER']=$rsumt?sprintf("%.2f",$ravgt/$rsumt*100):'0.00';
  $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$ravgt/$rmaxt):'0';
      //new design
      if(isset($stnew)) {
        if($rmaxt) $vars['GRAPHIC']=(int)(90*$ravgt/$rmaxt);
        else $vars['GRAPHIC']=1;
        if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
        $vars['GRAPHIC'].='%';
      }
  tparse($foot,$vars);
  $vars['NAME']=_MAXIMUM;
  $vars['TOTAL']=$rmaxt;
  $vars['PER']=$rsumt?sprintf("%.2f",$rmaxt/$rsumt*100):'0.00';
  $vars['GRAPHIC']=$rmaxt?(int)($maxlen*$rmaxt/$rmaxt):'0';
      //new design
      if(isset($stnew)) {
        if($rmaxt) $vars['GRAPHIC']=(int)(90*$rmaxt/$rmaxt);
        else $vars['GRAPHIC']=1;
        if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
        $vars['GRAPHIC'].='%';
      }
  tparse($foot,$vars);
  tparse($bottom,$vars);
}

  //HITS
  $fshow=true;
  if(isset($stnew)) {
    if(!($this->shreps & 0x10)) $fshow=false;
  }

if($fshow) {
  $vars['STAB']=5;
  $vars['HEADER']=_HITS.' / ';
  $vars['REF']='hits';
  $vars['TOTAL']=_HITS;
  $vars['GRAPHIC']=_GRAPHIC;
  $vars['SORT']=_SORTBYHT;
  tparse($top,$vars);
  $vars['MODULE']='graph';
  $vars['TITLE']=_PIE;
  $vars['ELEM']='pie';
  tparse($button,$vars);
  $vars['TITLE']=_BAR;
  $vars['ELEM']='bar';
  tparse($button,$vars);
  tparse($etop,$vars);
  $num=$begstr+1;
  $minf=0;
  if(db_num_rows($result)) {
      db_data_seek($result,0);
      while($row=db_fetch_object($result)) {
          $vars['NUM']=$num++;
          $vars['TOTAL']=$row->ht;
          $vars['PER']=$htsumt?sprintf("%.2f",$row->ht/$htsumt*100):'0.00';
          $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$row->ht/$htmaxt):'0';
          //new design
          if(isset($stnew)) {
            if($htmaxt) $vars['GRAPHIC']=(int)(90*$row->ht/$htmaxt);
            else $vars['GRAPHIC']=1;
            if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
            $vars['GRAPHIC'].='%';
          }
          if($flag==0) {
              if(!strcmp($row->name,'undefined')) $vars['REFSHORT']=_DIRECT;
              else $vars['REFSHORT']=$row->name;
              tparse($cplain,$vars);
          }
          else {
              if(strcmp($row->name,'undefined')) {
                  $fname='http://'.$row->name;
                  $fname=str_replace("\\","/",$fname);
                  if(strlen($fname)>_VS_REFPGS) $sname=substr($fname,0,_VS_REFPGS-3).'...';
                  else $sname=$fname;
                  //new design
                  if(isset($stnew)) $sname=chunk_split($fname,10,$ybsp);
                  $vars['REFERRER']=$fname;
                  $vars['REFSHORT']=$sname;
                  tparse($curl,$vars);
              }
              else { $vars['REFSHORT']=_DIRECT; tparse($cplain,$vars); }
          }
      }
  }
  else { $vars['TEXT']=_NORECORDS; tparse($empty,$vars); }
  if($numstr<$nrect) {
        $vars['TOTAL']=$hts;
        $vars['PER']=$htsumt?sprintf("%.2f",$hts/$htsumt*100):'0.00';
        tparse($delimiter,$vars);
        $vars['NAME']=_MINIMUM;
        $vars['TOTAL']=$htmin;
        $vars['PER']=$htsumt?sprintf("%.2f",$htmin/$htsumt*100):'0.00';
        $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$htmin/$htmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($htmaxt) $vars['GRAPHIC']=(int)(90*$htmin/$htmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_AVERAGE;
        $vars['TOTAL']=$aht;
        $vars['PER']=$htsumt?sprintf("%.2f",$aht/$htsumt*100):'0.00';
        $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$aht/$htmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($htmaxt) $vars['GRAPHIC']=(int)(90*$aht/$htmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
        $vars['NAME']=_MAXIMUM;
        $vars['TOTAL']=$htmax;
        $vars['PER']=$htsumt?sprintf("%.2f",$htmax/$htsumt*100):'0.00';
        $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$htmax/$htmaxt):'0';
        //new design
        if(isset($stnew)) {
          if($htmaxt) $vars['GRAPHIC']=(int)(90*$htmax/$htmaxt);
          else $vars['GRAPHIC']=1;
          if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
          $vars['GRAPHIC'].='%';
        }
        tparse($foot,$vars);
  }
  if($nrect) $vars['NAME']=_TOTAL.' (1 - '.$nrect.')';
  else $vars['NAME']=_TOTAL.' (0 - 0)';
  $vars['TOTAL']=$htsumt;
  $vars['PER']='100.00';
  tparse($delimiter2,$vars);
  $vars['NAME']=_MINIMUM;
  $vars['TOTAL']=$htmint;
  $vars['PER']=$htsumt?sprintf("%.2f",$htmint/$htsumt*100):'0.00';
  $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$htmint/$htmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($htmaxt) $vars['GRAPHIC']=(int)(90*$htmint/$htmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_AVERAGE;
  $vars['TOTAL']=$htavgt;
  $vars['PER']=$htsumt?sprintf("%.2f",$htavgt/$htsumt*100):'0.00';
  $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$htavgt/$htmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($htmaxt) $vars['GRAPHIC']=(int)(90*$htavgt/$htmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  $vars['NAME']=_MAXIMUM;
  $vars['TOTAL']=$htmaxt;
  $vars['PER']=$htsumt?sprintf("%.2f",$htmaxt/$htsumt*100):'0.00';
  $vars['GRAPHIC']=$htmaxt?(int)($maxlen*$htmaxt/$htmaxt):'0';
  //new design
  if(isset($stnew)) {
    if($htmaxt) $vars['GRAPHIC']=(int)(90*$htmaxt/$htmaxt);
    else $vars['GRAPHIC']=1;
    if(!$vars['GRAPHIC']) $vars['GRAPHIC']=1;
    $vars['GRAPHIC'].='%';
  }
  tparse($foot,$vars);
  tparse($bottom,$vars);
}
  db_free_result($result);

  //total
  $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.',252,"tot","",0,'.$nrect.','.$vsumt.',0,100.00,'.$hssumt.',0,100.00,'.$rsumt.',0,100.00,'.$htsumt.')';
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  //minimum
  $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.',253,"min","",0,'.($vsumt?sprintf("%.2f",$vmint/$vsumt*100):'0.00').','.$vmint.',0,'.($hssumt?sprintf("%.2f",$hsmint/$hssumt*100):'0.00').','.$hsmint.',0,'.($rsumt?sprintf("%.2f",$rmint/$rsumt*100):'0.00').','.$rmint.',0,'.($htsumt?sprintf("%.2f",$htmint/$htsumt*100):'0.00').','.$htmint.')';
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  //maximum
  $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.',254,"avg","",0,'.($vsumt?sprintf("%.2f",$vavgt/$vsumt*100):'0.00').','.$vavgt.',0,'.($hssumt?sprintf("%.2f",$hsavgt/$hssumt*100):'0.00').','.$hsavgt.',0,'.($rsumt?sprintf("%.2f",$ravgt/$rsumt*100):'0.00').','.$ravgt.',0,'.($htsumt?sprintf("%.2f",$htavgt/$htsumt*100):'0.00').','.$htavgt.')';
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}
  //maximum
  $request='INSERT INTO aa_rdata (id,added,num,name,addpar,vi,vp,v,hsi,hsp,hs,ri,rp,r,hti,htp,ht) VALUES ('.$rdid.','.$conf->ctime.',255,"max","",0,'.($vsumt?sprintf("%.2f",$vmaxt/$vsumt*100):'0.00').','.$vmaxt.',0,'.($hssumt?sprintf("%.2f",$hsmaxt/$hssumt*100):'0.00').','.$hsmaxt.',0,'.($rsumt?sprintf("%.2f",$rmaxt/$rsumt*100):'0.00').','.$rmaxt.',0,'.($htsumt?sprintf("%.2f",$htmaxt/$htsumt*100):'0.00').','.$htmaxt.')';
  $result1=db_query($request,$conf->link);
  if(!$result1) {$err->reason('vdb.php|ref|the request \''.$request.'\' has failed -- '.db_error($conf->link));return;}

?>