[host_id]
| Link | host_id |
| 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 the id for the given host name or alias from Lasso's internal database. Requires authentication as a user with permissions on that database, i.e., with [auth_admin].
Sample Usage
host_id('Local MySQL');
-> 5
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(
'id',
-namespace='host_',
-req='name',
-priority='replace',
-description='Returns the id for the given host name or alias.'
);
inline( -database='lasso_internal', -sql='SELECT 1');
local('sql' = '
SELECT store_key
FROM global_prefs
WHERE data = \'' + #name + '\'
');
inline( -sql=#sql);
if(found_count);
local('id') = field('store_key');
#id->removeleading('_admin_host_alias:');
else;
local('sql' = '
SELECT id
FROM security_datasource_hosts
WHERE name = \'' + #name + '\'
');
inline( -sql=#sql);
found_count ? local('id') = field('id') | return(false);
/inline;
/if;
/inline;
/inline;
return(integer(#id));
/define_tag;
Related Tags
Comments
No comments
