diff options
Diffstat (limited to 'h-source/Application/Controllers')
| -rw-r--r-- | h-source/Application/Controllers/SpecialController.php | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/h-source/Application/Controllers/SpecialController.php b/h-source/Application/Controllers/SpecialController.php index 9298ad3..a118211 100644 --- a/h-source/Application/Controllers/SpecialController.php +++ b/h-source/Application/Controllers/SpecialController.php @@ -33,7 +33,9 @@ class SpecialController extends BaseController $data['title'] = gtext('last modifications').' - '.Website::$generalName; $this->append($data); - $this->setArgKeys(array('page:forceNat'=>1)); + Params::$nullQueryValue = 'undef'; + + $this->setArgKeys(array('page:forceNat'=>1,'username:sanitizeAll'=>'undef')); } protected function last($lang = 'en',$action = 'modifications') @@ -78,11 +80,12 @@ class SpecialController extends BaseController break; } - + $whereClauseArray['username'] = $this->viewArgs['username']; + $this->helper('Pages','special/'.$this->action.'/'.$this->lang,'page'); - - $this->m['HistoryModel']->clear()->select()->where($whereClauseArray)->orderBy('id_history desc'); - + + $this->m['HistoryModel']->clear()->left('regusers')->on('history.created_by=regusers.id_user')->select("history.*,regusers.username")->where($whereClauseArray)->orderBy('id_history desc'); + $recordNumber = $this->m['HistoryModel']->rowNumber(); $page = $this->viewArgs['page']; @@ -90,6 +93,8 @@ class SpecialController extends BaseController $data['table'] = $this->m['HistoryModel']->send(); +// echo $this->m['HistoryModel']->getQuery(); + $data['pageList'] = $this->h['Pages']->render($page-5,11); $this->append($data); @@ -120,7 +125,7 @@ class SpecialController extends BaseController $this->m['HistoryModel']->limit = $this->h['Pages']->getLimit($page,$recordNumber,30); $data['table'] = $this->m['HistoryModel']->send(); - + $data['pageList'] = $this->h['Pages']->render($page-5,11); $this->append($data); |