<?php

if (!isset($gCms)) exit;  

//session_destroy();
//session_start();

$post_params=$params;


if(isset($_SESSION[$params['name'].'_PARAMS']))  $params=$_SESSION[$params['name'].'_PARAMS']; 

$_SESSION[$params['name'].'_PARAMS']=$params;


echo '<ul id=nav ><li>';
echo $this->CreateFormStart($id,'default',$returnid,'post');
echo $this->CreateInputSubmit($id, 'submit', '<< Prev ');
echo $this->CreateInputHidden($id, 'name', $params['name']);
echo $this->CreateFormEnd();
echo '</li>';
echo '<li>';
echo $this->CreateFormStart($id,'default',$returnid,'post');
echo $this->CreateInputSubmit($id, 'submit', ' Next >>');
echo $this->CreateInputHidden($id, 'name', $params['name']);
echo $this->CreateFormEnd();
echo '</li></ul>';


$name=$params['name'];
$type=$params['type'];
$cols=explode(',',$params['cols']);
$rows=$params['rows'];
$datasource=$params['datasource'];
$sourcetype=$params['sourcetype'];
$rowid=$params['rowid'];

if (!isset($_SESSION[$name.'_FIRST_VISIT'])){
    
    $db1 = NewADOConnection('mysql');
    
    $db1->Connect('localhost','root','','fodb');
    
    //$sql = "select id,name,comment,realname from fo_files";
    $sql=$datasource;
    //$db1->SetFetchMode(ADODB_FETCH_NUM);      
    //$ADODB_FETCH_MODE = ADODB_FETCH_NUM; 
    $dataset1=$db1->GetAll($sql);
    
    $_SESSION[$name.'_FIRST_VISIT'] ='NO';
    $_SESSION[$name.'_OFFSET']=0;
    $_SESSION[$name.'_DATASET']=$dataset1;
}


$dataset = array();
$dataset =  $_SESSION[$name.'_DATASET'] ;
$offset = $_SESSION[$name.'_OFFSET'];
$count = count($dataset);


$temp_arr_n=array();

require_once ('functions.lview.php');

if(!empty($_POST)){
  echo 'POSTING<br>';
  MoveNext($params,$dataset,$count,$offset,$this);
  header('Location: '.$_SERVER['REQUEST_URI']);
}else{

  if(($offset-$rows)<0){
    $page_start=0;
    MoveNext($params,$dataset,$count,$offset,$this);
  }else{
    $page_start=abs($offset-$rows);
  }  

  DisplayData($params,$page_start,$this);
    
}

$pageno=$_SESSION[$name.'_PAGENO'] ;
$offset = $_SESSION[$name.'_OFFSET'];
//echo 'OFFSET='.$offset.', ROWS='.$rows.', OFFSET-ROWS='.($offset-$rows).', PAGE_NO='.$pageno.'<br>';

?>
