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_vhost_subdomain_list.php | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/interface/web/sites/web_vhost_subdomain_list.php b/interface/web/sites/web_vhost_subdomain_list.php index 8c48339..0677a93 100644 --- a/interface/web/sites/web_vhost_subdomain_list.php +++ b/interface/web/sites/web_vhost_subdomain_list.php @@ -47,8 +47,8 @@ $app->uses('listform_actions'); // Limit the results to alias domains -$app->listform_actions->SQLExtWhere = "type = 'vhostsubdomain'"; -$app->listform_actions->SQLOrderBy = 'ORDER BY domain'; +$app->listform_actions->SQLExtWhere = "web_domain.type = 'vhostsubdomain'"; +$app->listform_actions->SQLOrderBy = 'ORDER BY web_domain.domain'; $app->listform_actions->onLoad(); -- Gitblit v1.9.1