Marius Cramer
2013-10-14 d9bcf68e395d6156645a7974b1a992aa6e6c00aa
interface/web/sites/list/web_folder_user.list.php
@@ -42,6 +42,8 @@
// Enable auth
$liste["auth"]            = "yes";
$auth_sql = $app->tform->getAuthSQL('r', 'web_domain');
/*****************************************************
* Suchfelder
@@ -60,12 +62,15 @@
$liste["item"][] = array(   'field'      => "web_folder_id",
                     'datatype'   => "VARCHAR",
                            'filters'   => array( 0 => array( 'event' => 'SHOW',
                                                              'type' => 'IDNTOUTF8')
                                                ),
                     'formtype'   => "SELECT",
                     'op'      => "=",
                     'prefix'   => "",
                     'suffix'   => "",
                     'datasource'   => array (    'type'   => 'SQL',
                              'querystring' => "Select concat(web_domain.domain,' ',web_folder.path) as name, web_folder.web_folder_id from web_domain, web_folder WHERE web_domain.domain_id = web_folder.parent_domain_id AND {AUTHSQL} ORDER BY web_domain.domain",
                              'querystring' => "Select concat(web_domain.domain,' ',web_folder.path) as name, web_folder.web_folder_id from web_domain, web_folder WHERE web_domain.domain_id = web_folder.parent_domain_id AND ".$auth_sql." ORDER BY web_domain.domain",
                              'keyfield'=> 'web_folder_id',
                              'valuefield'=> 'name'
                            ),