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