$this->database->setQuery( "SELECT product_name FROM #__license_products WHERE product_id='".( mosGetParam( $_REQUEST , "product_id" ) )."'" );
$table_name = md5( $this->database->loadResult() );
$this->database->setQuery( "SELECT license_name FROM #__lic_".( $table_name )." WHERE license_id='".( mosGetParam( mosGetParam( $_REQUEST , "cid" ) , 0 ) )."' " );
$license_name = $this->database->loadResult();
$this->database->setQuery( "SELECT param_name , param_type FROM #__license_params WHERE param_status='Active' AND param_product='".( mosGetParam( $_REQUEST , "product_id" ) )."' ORDER BY param_name" );
foreach( $this->database->loadObjectList() AS $param ) {
$this->database->setQuery( "SELECT ".( md5( $param->param_name ) )." FROM #__lic_".( $table_name )." WHERE license_id='".( mosGetParam( mosGetParam( $_REQUEST , "cid" ) , 0 ) )."'" );
switch( $param->param_type ) {
case "DATE":
$param->param_type = "param_name ) )."\" maxlength=\"19\" name=\"".( md5( $param->param_name ) )."\" size=\"25\" type=\"text\" value=\"".( $this->database->loadResult() )."\" /> ";
$param->param_type .= "param_name ) )."' , 'y-mm-dd' )\" type=\"button\" value=\"...\" />";
break;
case "INT":
$param->param_type = "param_name ) )."\" size=\"15\" type=\"text\" value=\"".( $this->database->loadResult() )."\" />";
break;
case "VARCHAR":
break;
}
$params[] = array( "param_name" => $param->param_name ,
"param_type" => $param->param_type );
}