[admin_listhosts]
| Link | admin_listhosts |
| Author | Jason Huck |
| Category | Administration |
| Version | 8.x |
| License | http://opensource.org/licenses/artistic-license.php |
| Posted | 21 Nov 2006 |
| Updated | 21 Nov 2006 |
| More by this author... | |
Description
Returns an array of all enabled hosts for the given Lasso Site. Requires authentication as a user with permissions on Lasso's internal databases, i.e., with [auth_admin].
Sample Usage
admin_listhosts; -> array: (localhost), (DBServer)
Source Code
Click the "Download" button below to retrieve a copy of this tag, including the complete documentation and sample usage shown on this page. Place the downloaded ".inc" file in your LassoStartup folder, restart Lasso, and you can begin using this tag immediately.
define_tag(
'listhosts',
-namespace='admin_',
-priority='replace',
-description='Returns an array of all enabled hosts.'
);
local('out' = array);
local('sql' = '
SELECT id, name
FROM security_datasource_hosts
WHERE enabled = \'Y\'
ORDER BY id
');
inline(
-database='lasso_internal',
-sql=#sql
);
rows;
local('name') = field('name');
local('sql' = '
SELECT data
FROM global_prefs
WHERE store_key LIKE \'_admin_host_alias:' + field('id') + '%\'
');
inline( -sql=#sql);
found_count ? #out->insert(field('data')) | #out->insert(#name);
/inline;
/rows;
/inline;
return(#out);
/define_tag;
Related Tags
Comments
No comments
