From 15e77077aa7acdcfc74dad3e3586c96870a4107b Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Tue, 31 Jul 2007 11:55:29 -0400 Subject: [PATCH] Updates in DNS manager --- interface/lib/classes/plugin_listview.inc.php | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/interface/lib/classes/plugin_listview.inc.php b/interface/lib/classes/plugin_listview.inc.php index 762e5a7..59d1b56 100644 --- a/interface/lib/classes/plugin_listview.inc.php +++ b/interface/lib/classes/plugin_listview.inc.php @@ -49,10 +49,14 @@ $limit_sql = $app->listform->getPagingSQL($sql_where); $listTpl->setVar("paging",$app->listform->pagingHTML); + $sql_order_by = ''; + if(isset($this->options["sql_order_by"])) { + $sql_order_by = $this->options["sql_order_by"]; + } // Get the data - $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $limit_sql"); + $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $sql_order_by $limit_sql"); $bgcolor = "#FFFFFF"; if(is_array($records)) { @@ -71,6 +75,8 @@ if($field['formtype'] == "SELECT") { $rec[$key] = $field['value'][$rec[$key]]; } + // Create a lowercase version of every item + $rec[$key.'_lowercase'] = strtolower($rec[$key]); } // The variable "id" contains always the index field -- Gitblit v1.9.1