$qry_result = $adb->pquery($qry, array($userid)); $no_of_rows = $adb->num_rows($qry_result); //Retreiving the start value from request if (isset($_REQUEST['start']) && $_REQUEST['start'] != '') { $start = vtlib_purify($_REQUEST['start']); } else { $start = 1; } //Retreive the Navigation array $navigation_array = getNavigationValues($start, $no_of_rows, '100'); $start_rec = $navigation_array['start']; $end_rec = $navigation_array['end_val']; $record_string = $app_strings['LBL_SHOWING'] . " " . $start_rec . " - " . $end_rec . " " . $app_strings['LBL_LIST_OF'] . " " . $no_of_rows; $navigationOutput = getTableHeaderNavigation($navigation_array, $url_string, "Settings", "ShowAuditTrail", ''); $smarty->assign("MOD", $current_module_strings); $smarty->assign("CMOD", $mod_strings); $smarty->assign("APP", $app_strings); $smarty->assign("THEME", $theme); $smarty->assign("IMAGE_PATH", $image_path); $smarty->assign("THEME_PATH", $theme_path); $smarty->assign("LIST_HEADER", $focus->getAuditTrailHeader()); $smarty->assign("LIST_ENTRIES", $focus->getAuditTrailEntries($userid, $navigation_array, $sorder, $sortby)); $smarty->assign("RECORD_COUNTS", $record_string); $smarty->assign("NAVIGATION", $navigationOutput); $smarty->assign("USERID", $userid); $smarty->assign("CATEGORY", $category); if ($_REQUEST['ajax'] != '') { $smarty->display("ShowAuditTrailContents.tpl"); } else { $smarty->display("ShowAuditTrail.tpl"); }