Lasso Soft Inc. > Home

[host_id]

Linkhost_id
AuthorJason Huck
CategoryAdministration
Version8.x
Licensehttp://opensource.org/licenses/artistic-license.php
Posted21 Nov 2006
Updated21 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

Please log in to comment

Subscribe to the LassoTalk mail list

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft