функция cot_generatePaginationTags($pagenav); создаст нужное количество страниц в соответствии с настройками сайта

list($pg, $d, $durl) = cot_import_pagenav('d', $cfg['users']['maxusersperpage']);

$sql = $db->query("SELECT * FROM $db_fz_houses")->fetchAll();
$totalusers = sizeof($sql);

$sql = $db->query("SELECT * FROM $db_fz_houses ORDER BY HouseNumber ASC LIMIT $d,{$cfg['users']['maxusersperpage']}")->fetchAll();


$totalpage = ceil($totalusers / $cfg['users']['maxusersperpage']);
$currentpage = ceil($d / $cfg['users']['maxusersperpage']) + 1;
$pagenav = cot_pagenav('fazenda', "e=fazenda", $d, $totalusers, $cfg['users']['maxusersperpage']);


foreach ( $sql as $row ) 
{

$t->assign(array(
 'FZ_ROW_USERNAME' =>  $row['KeeperName'],
 'FZ_ROW_HOUSE_NUMDER' => $row['HouseNumber'], 
 'FZ_ROW_PHONE_NUM' => $row['Phone'],
 'FZ_ROW_ADDRESS' => $row['Address']
  ));	    
$t->parse('MAIN.FZ_ROW');
}

$t->assign(cot_generatePaginationTags($pagenav));

$t->parse('ALTERNATIVE');

в TPL

    <!-- IF {PAGINATION} -->
        <div class="paging">{PREVIOUS_PAGE}{PAGINATION}{NEXT_PAGE}</div>
    <!-- ENDIF -->