$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 ); }