gistfile1.txt

function PagedChildren($klazz, $childrenPerPage = 10) {
    
    $pageLength = $childrenPerPage;
    $parentID = $this->ID;

    if ($this->ClassName == 'NewsItemsFolder') {
      if ($this->ItemsPerPage) {
        $pageLength = $this->ItemsPerPage;
        //error_log("Items per page:".$childrenPerPage);
      }
    }

    $start = isset($_GET['start']) ? (int)$_GET['start'] : 0;

    $sort = '';
   


    $total = DB::query("SELECT COUNT(*) FROM SiteTree where ParentID=".$parentID)->value();
    $NumberPages = 1 + ($total / $pageLength);

    error_log("KLAZZ:".$klazz);
    error_log("SORT:".$sort);

     $results= DataObject::get($klazz, 
      "ParentID=".$parentID,//filter
      $sort,//sort
      //'',
      '',
      $start.','.$pageLength//limit
      );

      $this->lastPagedResults = $results;



      return $results;
  }