From 7d5306ea268033b92cac8496c2d5efdb16b9f6c6 Mon Sep 17 00:00:00 2001 From: ftimme <ft@falkotimme.com> Date: Fri, 28 Jun 2013 14:37:02 -0400 Subject: [PATCH] - Lists can now be created from more than one database table (including sorting and searching) // needs more testing! --- interface/web/sites/web_domain_list.php | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/interface/web/sites/web_domain_list.php b/interface/web/sites/web_domain_list.php index feae9c8..d9c5066 100644 --- a/interface/web/sites/web_domain_list.php +++ b/interface/web/sites/web_domain_list.php @@ -52,8 +52,8 @@ } $list = new list_action; -$list->SQLExtWhere = "type = 'vhost' AND parent_domain_id = '0'"; -$list->SQLOrderBy = 'ORDER BY domain'; +$list->SQLExtWhere = "web_domain.type = 'vhost' AND web_domain.parent_domain_id = '0'"; +$list->SQLOrderBy = 'ORDER BY web_domain.domain'; $list->onLoad(); ?> \ No newline at end of file -- Gitblit v1.9.1