コード例 #1
0
ファイル: 2_0_8.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     // Added new internal config for maximum image's size
     $database->setQuery('INSERT INTO #__mt_config (`varname`, `groupname`, `value`, `default`, `configcode`, `ordering`, `displayed`) VALUES ("image_maxsize", "image", "3145728", "3145728", "text", "10300", "1")');
     $database->query();
     $this->printStatus('Added new internal config for maximum image\'s size.');
     // Update coredesc class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'link_desc\';\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		if( ($inBackEnd AND $mtconf->get(\'use_wysiwyg_editor_in_admin\')) || (!$inBackEnd AND $mtconf->get(\'use_wysiwyg_editor\')) ) {\\r\\n			ob_start();\\r\\n			editorArea( \'editor1\',  $this->getValue() , $this->getInputFieldName(1), \'100%\', $this->getSize(), \'75\', \'25\' );\\r\\n			$html = ob_get_contents();\\r\\n			ob_end_clean();\\r\\n		} else {\\r\\n			$html = \'<textarea class=\\"inputbox\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" style=\\"width:95%;height:\' . $this->getSize() . \'px\\">\' . htmlspecialchars($this->getValue()) . \'</textarea>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'parseMambots\'] = $this->getParam(\'parseMambots\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		$params[\'showReadMore\'] = $this->getParam(\'showReadMore\',0);\\r\\n		$params[\'whenReadMore\'] = $this->getParam(\'whenReadMore\',0);\\r\\n		$params[\'txtReadMore\'] = $this->getParam(\'txtReadMore\',(( $GLOBALS[\'_VERSION\']->RELEASE == \'1.0\' )?_READ_MORE:JTEXT::_( \'Read More...\' )));\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\']) {\\r\\n				$regex = \'/http:\\\\/\\\\/(.*?)(\\\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n			if (!$mtconf->get(\'use_wysiwyg_editor\') && $params[\'stripDetailsTags\'] && !in_array(\'br\',explode(\',\',$params[\'allowedTags\'])) && !in_array(\'p\',explode(\',\',$params[\'allowedTags\'])) ) {\\r\\n				$html = nl2br(trim($html));\\r\\n			}\\r\\n			if($params[\'parseMambots\']) {\\r\\n				$this->parseMambots($html);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			global $Itemid;\\r\\n			$html = preg_replace(\'@{[\\\\/\\\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			if($params[\'summaryChars\'] > 0) {\\r\\n				$trimmed_desc = trim($this->html_substr($html,0,$params[\'summaryChars\']));\\r\\n			} else {\\r\\n				$trimmed_desc = \'\';\\r\\n			}\\r\\n			if ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc;\\r\\n				$html .= \' <b>...</b>\';\\r\\n			}\\r\\n			if( $params[\'showReadMore\'] && ($params[\'whenReadMore\'] == 1 || ($params[\'whenReadMore\'] == 0 && $this->strlen_utf8($html) > $params[\'summaryChars\'])) ) {\\r\\n				if(!empty($trimmed_desc)) {\\r\\n					$html .= \'<br />\';\\r\\n				}\\r\\n				$html .= \' <a href=\\"\' . JRoute::_(\'index.php?option=com_mtree&task=viewlink&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid) . \'\\" class=\\"readon\\">\' . $params[\'txtReadMore\'] . \'</a>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "coredesc" LIMIT 1');
     $database->query();
     // Update coredesc version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "21" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coredesc field type to version 2.');
     // Update mfile class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_mFile extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n		$fileExtensions = $this->getParam(\'fileExtensions\',\'\');\\r\\n		if(is_array($fileExtensions)) {\\r\\n			$fileExtensions = implode(\'|\',$fileExtensions);\\r\\n		} else {\\r\\n			$fileExtensions = trim($fileExtensions);\\r\\n		}\\r\\n		if(!empty($fileExtensions)) {\\r\\n			$js = \'\';\\r\\n			$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'\' . $fileExtensions . \'\\\\\')) {\'; \\r\\n			$js .= \'alert(\\"\' . $this->getCaption() . \': Please select files with these extension(s) - \' . str_replace(\'|\',\', \',$fileExtensions) . \'.\\");\';\\r\\n			return $js;\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "mfile" LIMIT 1');
     $database->query();
     // Update mfile version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "48" LIMIT 1');
     $database->query();
     $this->printStatus('Updated mfile field type to version 2.');
     // Update videoplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_videoplayer extends mFieldType_file {\\r\\n\\r\\n	function getOutput() {\\r\\n		$html =\'\';\\r\\n		$filename = $this->getValue();\\r\\n		$format = $this->getParam(\'format\');\\r\\n		$id = $format.$filename;\\r\\n		$width = $this->getParam(\'width\');\\r\\n		$height = $this->getParam(\'height\');\\r\\n		$autoplay = $this->getParam(\'autoplay\',false);\\r\\n		if($autoplay) {\\r\\n			$autoplay = \'true\';\\r\\n		} else {\\r\\n			$autoplay = \'false\';\\r\\n		}\\r\\n		switch($format) {\\r\\n			case \'mov\':\\r\\n				$html .= \'<object classid=\\"clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B\\" width=\\"\' . $width . \'\\" height=\\"\' . $height. \'\\" codebase=\\"http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0\\" align=\\"middle\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/quicktime\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" pluginspage=\\"http://www.apple.com/quicktime/download/\\" align=\\"middle\\" autoplay=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'divx\':\\r\\n				$html .= \'\';\\r\\n				$html .= \'<object classid=\\"clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" codebase=\\"http://go.divx.com/plugin/DivXBrowserPlugin.cab\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"autoPlay\\" value=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/divx\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" autoPlay=\\"\' . $autoplay . \'\\" pluginspage=\\"http://go.divx.com/plugin/download/\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'windowsmedia\':\\r\\n				$html .= \'<object classid=\\"CLSID:6BF52A52-394A-11D3-B153-00C04F79FAA6\\" id=\\"\' . $id . \'\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" type=\\"application/x-oleobject\\">\';\\r\\n				$html .= \'<param name=\\"URL\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"wmode\\" value=\\"opaque\\" />\';\\r\\n				$html .= \'<param name=\\"ShowControls\\" value=\\"1\\" />\';\\r\\n				$html .= \'<param name=\\"autoStart\\" value=\\"\' . (($autoplay==\'true\')?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"application/x-mplayer2\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" wmode=\\"opaque\\" border=\\"0\\" autoStart=\\"\' . (($autoplay == \'true\')?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "videoplayer" LIMIT 1');
     $database->query();
     // Update videoplayer version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "45" LIMIT 1');
     $database->query();
     $this->printStatus('Updated videoplayer field type to version 3.');
     updateVersion(2, 0, 8);
     $this->updated = true;
     return true;
 }
コード例 #2
0
ファイル: 2_0_9.php プロジェクト: rsemedo/Apply-Within
    function upgrade()
    {
        $database =& JFactory::getDBO();
        // Update audioplayer class code
        $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_audioplayer extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' . $this->getName() . \'.value,\\\\\'mp3\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . addslashes($this->getCaption()) . \': Please select a mp3 file.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$id = $this->getId();\\r\\n		$params[\'text\'] = $this->getParam(\'textColour\');\\r\\n		$params[\'displayfilename\'] = $this->getParam(\'displayfilename\',1);\\r\\n		$params[\'slider\'] = $this->getParam(\'sliderColour\');\\r\\n		$params[\'loader\'] = $this->getParam(\'loaderColour\');\\r\\n		$params[\'track\'] = $this->getParam(\'trackColour\');\\r\\n		$params[\'border\'] = $this->getParam(\'borderColour\');\\r\\n		$params[\'bg\'] = $this->getParam(\'backgroundColour\');\\r\\n		$params[\'leftbg\'] = $this->getParam(\'leftBackgrounColour\');\\r\\n		$params[\'rightbg\'] = $this->getParam(\'rightBackgrounColour\');\\r\\n		$params[\'rightbghover\'] = $this->getParam(\'rightBackgroundHoverColour\');\\r\\n		$params[\'lefticon\'] = $this->getParam(\'leftIconColour\');\\r\\n		$params[\'righticon\'] = $this->getParam(\'rightIconColour\');\\r\\n		$params[\'righticonhover\'] = $this->getParam(\'rightIconHoverColour\');\\r\\n		\\r\\n		$html = \'\';\\r\\n		$html .= \'<script language=\\"JavaScript\\" src=\\"\' . $this->getFieldTypeAttachmentURL(\'audio-player.js\'). \'\\"></script>\';\\r\\n		$html .= \\"\\\\n\\" . \'<object type=\\"application/x-shockwave-flash\\" data=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\'). \'\\" id=\\"audioplayer\' . $id . \'\\" height=\\"24\\" width=\\"290\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"movie\\" value=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\') . \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"FlashVars\\" value=\\"\';\\r\\n		$html .= \'playerID=\' . $id;\\r\\n		$html .= \'&amp;soundFile=\' . urlencode($this->getDataAttachmentURL());\\r\\n		foreach( $params AS $key => $value ) {\\r\\n			if(!empty($value)) {\\r\\n				$html .= \'&amp;\' . $key . \'=0x\' . $value;\\r\\n			}\\r\\n		}\\r\\n		$html .= \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"quality\\" value=\\"high\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"menu\\" value=\\"false\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"wmode\\" value=\\"transparent\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'</object>\';\\r\\n		if($params[\'displayfilename\']) {\\r\\n			$html .= \\"\\\\n<br />\\";\\r\\n			$html .= \\"\\\\n\\" . \'<a href=\\"\' . $this->getDataAttachmentURL() . \'\\" target=\\"_blank\\">\';\\r\\n			$html .= $this->getValue();\\r\\n			$html .= \'</a>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "audioplayer" LIMIT 1');
        $database->query();
        // Update audioplayer version number
        $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "24" LIMIT 1');
        $database->query();
        $this->printStatus('Updated audioplayer field type to version 3.');
        // Update image class code
        $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_image extends mFieldType_file {\\r\\n	function parseValue($value) {\\r\\n		global $mtconf;\\r\\n		$params[\'size\'] = intval(trim($this->getParam(\'size\')));\\r\\n		if($params[\'size\'] <= 0) {\\r\\n			$size = $mtconf->get(\'resize_listing_size\');\\r\\n		} else {\\r\\n			$size = intval($params[\'size\']);\\r\\n		}\\r\\n		$mtImage = new mtImage();\\r\\n		$mtImage->setMethod( $mtconf->get(\'resize_method\') );\\r\\n		$mtImage->setQuality( $mtconf->get(\'resize_quality\') );\\r\\n		$mtImage->setSize( $size );\\r\\n		$mtImage->setTmpFile( $value[\'tmp_name\'] );\\r\\n		$mtImage->setType( $value[\'type\'] );\\r\\n		$mtImage->setName( $value[\'name\'] );\\r\\n		$mtImage->setSquare(false);\\r\\n		$mtImage->resize();\\r\\n		$value[\'data\'] = $mtImage->getImageData();\\r\\n		$value[\'size\'] = strlen($value[\'data\']);\\r\\n		\\r\\n		return $value;\\r\\n	}\\r\\n	function getJSValidation() {\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'gif|png|jpg|jpeg\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . addslashes($this->getCaption()) . \': Please select an image with one of these extensions - gif,png,jpg,jpeg.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$html = \'\';\\r\\n		$html .= \'<img src=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$html = \'\';\\r\\n		if( $this->attachment > 0 ) {\\r\\n			$html .= $this->getKeepFileCheckboxHTML($this->attachment);\\r\\n			$html .= \'<label for=\\"\' . $this->getKeepFileName() . \'\\"><img src=\\"\' . $this->getDataAttachmentURL() . \'\\" hspace=\\"5\\" vspace=\\"0\\" /></label>\';\\r\\n			$html .= \'</br >\';\\r\\n		}\\r\\n		$html .= \'<input class=\\"inputbox\\" type=\\"file\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "image" LIMIT 1');
        $database->query();
        // Update image version number
        $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "25" LIMIT 1');
        $database->query();
        $this->printStatus('Updated image field type to version 3.');
        // Update mfile class code
        $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_mFile extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n		$fileExtensions = $this->getParam(\'fileExtensions\',\'\');\\r\\n		if(is_array($fileExtensions)) {\\r\\n			$fileExtensions = implode(\'|\',$fileExtensions);\\r\\n		} else {\\r\\n			$fileExtensions = trim($fileExtensions);\\r\\n		}\\r\\n		if(!empty($fileExtensions)) {\\r\\n			$js = \'\';\\r\\n			$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'\' . $fileExtensions . \'\\\\\')) {\'; \\r\\n			$js .= \'alert(\\"\' . addslashes($this->getCaption()) . \': Please select files with these extension(s) - \' . str_replace(\'|\',\', \',$fileExtensions) . \'.\\");\';\\r\\n			return $js;\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "mfile" LIMIT 1');
        $database->query();
        // Update mfile version number
        $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "48" LIMIT 1');
        $database->query();
        $this->printStatus('Updated mfile field type to version 3.');
        // Update jQuery path to point to new version 1.2.6
        $database->setQuery('UPDATE #__mt_config SET `value` = \'/components/com_mtree/js/jquery-1.2.6.min.js\',
		`default` = \'/components/com_mtree/js/jquery-1.2.6.min.js\' WHERE varname = \'relative_path_to_js_library\' LIMIT 1');
        $database->query();
        $this->printStatus('Update configuration to use new jQuery path.');
        updateVersion(2, 0, 9);
        $this->updated = true;
        return true;
    }
コード例 #3
0
ファイル: 2_0_7.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     // Update corecreated class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corecreated extends mFieldType_date {\\r\\n	var $name = \'link_created\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function parseValue($value) {\\r\\n		return strip_tags($value);\\r\\n	}\\r\\n}"  WHERE field_type = "corecreated" LIMIT 1');
     $database->query();
     // Update corecreated version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "22" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corecreated field type to version 2.');
     // Update coredesc class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'link_desc\';\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		if( ($inBackEnd AND $mtconf->get(\'use_wysiwyg_editor_in_admin\')) || (!$inBackEnd AND $mtconf->get(\'use_wysiwyg_editor\')) ) {\\r\\n			ob_start();\\r\\n			editorArea( \'editor1\',  $this->getValue() , $this->getInputFieldName(1), \'100%\', $this->getSize(), \'75\', \'25\' );\\r\\n			$html = ob_get_contents();\\r\\n			ob_end_clean();\\r\\n		} else {\\r\\n			$html = \'<textarea class=\\"inputbox\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" style=\\"width:95%;height:\' . $this->getSize() . \'px\\">\' . htmlspecialchars($this->getValue()) . \'</textarea>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'parseMambots\'] = $this->getParam(\'parseMambots\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		$params[\'showReadMore\'] = $this->getParam(\'showReadMore\',0);\\r\\n		$params[\'whenReadMore\'] = $this->getParam(\'whenReadMore\',0);\\r\\n		$params[\'txtReadMore\'] = $this->getParam(\'txtReadMore\',(( $GLOBALS[\'_VERSION\']->RELEASE == \'1.0\' )?_READ_MORE:JTEXT::_( \'Read More...\' )));\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\\\/\\\\/(.*?)(\\\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n			if (!$mtconf->get(\'use_wysiwyg_editor\') && $params[\'stripDetailsTags\'] && !in_array(\'br\',explode(\',\',$params[\'allowedTags\'])) && !in_array(\'p\',explode(\',\',$params[\'allowedTags\'])) ) {\\r\\n				$html = nl2br(trim($html));\\r\\n			}\\r\\n			if($params[\'parseMambots\']) {\\r\\n				$this->parseMambots($html);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			global $Itemid;\\r\\n			$html = preg_replace(\'@{[\\\\/\\\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			if($params[\'summaryChars\'] > 0) {\\r\\n				$trimmed_desc = trim($this->html_substr($html,0,$params[\'summaryChars\']));\\r\\n			} else {\\r\\n				$trimmed_desc = \'\';\\r\\n			}\\r\\n			if ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc;\\r\\n				$html .= \' <b>...</b>\';\\r\\n			}\\r\\n			if( $params[\'showReadMore\'] && ($params[\'whenReadMore\'] == 1 || ($params[\'whenReadMore\'] == 0 && $this->strlen_utf8($html) > $params[\'summaryChars\'])) ) {\\r\\n				if(!empty($trimmed_desc)) {\\r\\n					$html .= \'<br />\';\\r\\n				}\\r\\n				$html .= \' <a href=\\"\' . JRoute::_(\'index.php?option=com_mtree&task=viewlink&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid) . \'\\" class=\\"readon\\">\' . $params[\'txtReadMore\'] . \'</a>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "coredesc" LIMIT 1');
     $database->query();
     // Update coredesc version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "21" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coredesc field type to version 2.');
     // Update coremodified class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coremodified extends mFieldType_date {\\r\\n	var $name = \'link_modified\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput() {\\r\\n\\r\\n		$value = $this->getValue();\\r\\n		if($value == \'0000-00-00 00:00:00\') {\\r\\n			return $_MT_LANG->NEVER;\\r\\n		} else {\\r\\n			$dateFormat = $this->getParam(\'dateFormat\',\'%Y-%m-%d\');\\r\\n			return strftime($dateFormat,mktime(0,0,0,intval(substr($value,5,2)),intval(substr($value,8,2)),intval(substr($value,0,4))));\\r\\n		}\\r\\n	}\\r\\n\\r\\n}\\r\\n"  WHERE field_type = "coremodified" LIMIT 1');
     $database->query();
     // Update coremodified version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "15" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coremodified field type to version 2.');
     // Update corewebsite class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n\\r\\n	function getOutput() {\\r\\n		$maxUrlLength = $this->getParam(\'maxUrlLength\',60);\\r\\n		$text = $this->getParam(\'text\',\'\');\\r\\n		$openNewWindow = $this->getParam(\'openNewWindow\',1);\\r\\n		$useMTVisitRedirect = $this->getParam(\'useMTVisitRedirect\',1);\\r\\n	\\r\\n		$html = \'\';\\r\\n		$html .= \'<a href=\\"\';\\r\\n		if($useMTVisitRedirect) {\\r\\n			global $Itemid;\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=visit&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid);\\r\\n		} else {\\r\\n			$html .= $this->getValue();\\r\\n		}\\r\\n		$html .= \'\\"\';\\r\\n		if( $openNewWindow == 1 ) {\\r\\n			$html .= \' target=\\"_blank\\"\';\\r\\n		}\\r\\n		$html .= \'>\';\\r\\n		if(!empty($text)) {\\r\\n			$html .= $text;\\r\\n		} else {\\r\\n			$value = $this->getValue();\\r\\n			if(strpos($value,\'://\') !== false) {\\r\\n				$value = substr($value,(strpos($value,\'://\')+3));\\r\\n			}\\r\\n			if( empty($maxUrlLength) || $maxUrlLength == 0 ) {\\r\\n				$html .= $value;\\r\\n			} else {\\r\\n				$html .= substr($value,0,$maxUrlLength);\\r\\n				if( strlen($value) > $maxUrlLength ) {\\r\\n					$html .= $this->getParam(\'clippedSymbol\');\\r\\n				}\\r\\n			}\\r\\n		}\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n\\r\\n		$showGo = $this->getParam(\'showGo\',1);\\r\\n		$showSpider = $this->getParam(\'showSpider\',0);\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area inputbox\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . $this->getSize() . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		if($showGo && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript:window.open(\\"index3.php?option=com_mtree&task=openurl&url=\\"+escape(document.getElementById(\\"website\\").value))\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->GO . \'\\" />\';\\r\\n		}\\r\\n		\\r\\n		if($showSpider && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript: \';\\r\\n			$html .= \'jQuery(\\"#spiderwebsite\\").html(\\"\' . $_MT_LANG->SPIDER_PROGRESS . \'\\");\';\\r\\n			$html .= \'jQuery.ajax({\\r\\n			  type: \\"POST\\",\\r\\n			  url: mosConfig_live_site+\\"/administrator/index2.php\\",\\r\\n			  data: \\"option=com_mtree&task=ajax&task2=spiderurl&url=\\"+document.getElementById(\\"website\\").value+\\"&no_html=1\\",\\r\\n			  dataType: \\"script\\"\\r\\n			});\';\\r\\n			$html .= \'\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->SPIDER . \'\\" />\';\\r\\n			$html .= \'<span id=\\"spider\' . $this->getInputFieldName(1) . \'\\" style=\\"margin-left:5px;background-color:white\\"></span>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "corewebsite" LIMIT 1');
     $database->query();
     // Update corewebsite version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corewebsite field type to version 2.');
     // Update videoplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_videoplayer extends mFieldType_file {\\r\\n\\r\\n	function getOutput() {\\r\\n		$html =\'\';\\r\\n		$filename = $this->getValue();\\r\\n		$format = $this->getParam(\'format\');\\r\\n		$id = $format.$filename;\\r\\n		$width = $this->getParam(\'width\');\\r\\n		$height = $this->getParam(\'height\');\\r\\n		$autoplay = $this->getParam(\'autoplay\',false);\\r\\n		\\r\\n		switch($format) {\\r\\n			case \'mov\':\\r\\n				$html .= \'<object classid=\\"clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B\\" width=\\"\' . $width . \'\\" height=\\"\' . $height. \'\\" codebase=\\"http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0\\" align=\\"middle\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"autoplay\\" value=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/quicktime\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" pluginspage=\\"http://www.apple.com/quicktime/download/\\" align=\\"middle\\" autoplay=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'divx\':\\r\\n				$html .= \'\';\\r\\n				$html .= \'<object classid=\\"clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" codebase=\\"http://go.divx.com/plugin/DivXBrowserPlugin.cab\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"autoPlay\\" value=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/divx\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" autoPlay=\\"\' . $autoplay . \'\\" pluginspage=\\"http://go.divx.com/plugin/download/\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'windowsmedia\':\\r\\n				$html .= \'<object classid=\\"CLSID:6BF52A52-394A-11D3-B153-00C04F79FAA6\\" id=\\"\' . $id . \'\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" type=\\"application/x-oleobject\\">\';\\r\\n				$html .= \'<param name=\\"URL\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"wmode\\" value=\\"opaque\\" />\';\\r\\n				$html .= \'<param name=\\"ShowControls\\" value=\\"1\\" />\';\\r\\n				$html .= \'<param name=\\"autoStart\\" value=\\"\' . (($autoplay)?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"application/x-mplayer2\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" wmode=\\"opaque\\" border=\\"0\\" autoStart=\\"\' . (($autoplay)?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "videoplayer" LIMIT 1');
     $database->query();
     // Update videoplayer version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "45" LIMIT 1');
     $database->query();
     $this->printStatus('Updated videoplayer field type to version 2.');
     // Update videoplayer params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D22666F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D22566964656F20466F726D6174223E0A0909093C6F7074696F6E2076616C75653D226D6F76223E517569636B74696D65204D6F7669653C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2264697678223E446976583C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2277696E646F77736D65646961223E57696E646F7773204D6564696120566964656F3C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2277696474682220747970653D2274657874222064656661756C743D2222206C6162656C3D22576964746822202F3E0A09093C706172616D206E616D653D226865696768742220747970653D2274657874222064656661756C743D2222206C6162656C3D2268656967687422202F3E0A09093C706172616D206E616D653D226175746F706C61792220747970653D22726164696F222064656661756C743D2266616C736522206C6162656C3D224175746F20506C6179223E0A0909093C6F7074696F6E2076616C75653D2274727565223E5965733C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2266616C7365223E4E6F3C2F6F7074696F6E3E0A09093C2F706172616D3E0A09090A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 572 WHERE ft_id = 45 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update coredesc params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D2273756D6D61727943686172732220747970653D2274657874222064656661756C743D2232353522206C6162656C3D224E756D626572206F662053756D6D617279206368617261637465727322202F3E0A09093C706172616D206E616D653D22737472697053756D6D617279546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2053756D6D617279207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773207468617420636F756C6420706F74656E7469616C6C7920616666656374207768656E2076696577696E672061206C697374206F66206C697374696E67732E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22737472697044657461696C73546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2044657461696C73207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773206578636570742074686F73652074686174206172652073706563696669656420696E2027416C6C6F7765642074616773272E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22706172736555726C2220747970653D22726164696F222064656661756C743D223122206C6162656C3D2250617273652055524C206173206C696E6B20696E2044657461696C732076696577223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A0A09093C706172616D206E616D653D227374726970416C6C546167734265666F7265536176652220747970653D22726164696F222064656661756C743D223022206C6162656C3D22537472697020616C6C2048544D4C2074616773206265666F72652073746F72696E6720746F20646174616261736522206465736372697074696F6E3D224966205759535957494720656469746F7220697320656E61626C656420696E207468652066726F6E742D656E642C2074686973206665617475726520616C6C6F7720796F7520746F20737472697020616E7920706F74656E7469616C6C79206861726D66756C20636F6465732E20596F752063616E207374696C6C20616C6C6F7720736F6D6520746167732077697468696E206465736372697074696F6E206669656C642C2077686963682063616E206265207370656369666965642062656C6F772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22616C6C6F776564546167732220747970653D2274657874222064656661756C743D22752C622C692C612C756C2C6C692C7072652C626C6F636B71756F746522206C6162656C3D22416C6C6F776564207461677322206465736372697074696F6E3D22456E7465722074686520746167206E616D65732073657065726174656420627920636F6D6D612E205468697320706172616D6574657220616C6C6F7720796F7520746F2061636365707420736F6D652048544D4C2074616773206576656E20696620796F75206861766520656E61626C65207374726970696E67206F6620616C6C2048544D4C20746167732061626F76652E22202F3E0A09093C706172616D206E616D653D2270617273654D616D626F74732220747970653D22726164696F222064656661756C743D223022206C6162656C3D225061727365204D616D626F747322206465736372697074696F6E3D22456E61626C696E6720746869732077696C6C207061727365206D616D626F747320636F646573732077697468696E20746865206465736372697074696F6E206669656C64223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F77526561644D6F72652220747970653D22726164696F222064656661756C743D223022206C6162656C3D2253686F77202671756F743B52656164204D6F72652E2E2E2671756F743B22206465736372697074696F6E3D2253686F77202671756F743B52656164204D6F72652E2E2671756F743B2069662061206465736372697074696F6E207465787420636C697070656420696E2053756D6D61727920566965772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D227768656E526561644D6F72652220747970653D226C697374222064656661756C743D223022206C6162656C3D225768656E20746F2073686F77202671756F743B52656164204D6F72652E2E2671756F743B22206465736372697074696F6E3D225468697320616C6C6F7720796F7520746F20736574207768656E20746F2073686F7720746865202671756F743B52656164204D6F72652E2E2671756F743B206C696E6B2E223E0A0909093C6F7074696F6E2076616C75653D2230223E4F6E6C79207768656E206465736372697074696F6E20697320636C697070656420696E2053756D6D61727920566965773C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E416C6C207468652074696D653C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22747874526561644D6F72652220747970653D2274657874222064656661756C743D2252656164204D6F72652E2E2E22206C6162656C3D2252656164204D6F7265207465787422206465736372697074696F6E3D22456E74657220746865202671756F743B52656164204D6F72652E2E2671756F743B20746578742E22202F3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 2541 WHERE ft_id = 21 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update corecreated params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0D0A093C706172616D733E0D0A09093C706172616D206E616D653D227374617274596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D225374617274207965617222206465736372697074696F6E3D22456E74657220746865207374617274696E672079656172206F72206561726C69657374207965617220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C2069742077696C6C2064656661756C7420746F2037302079656172732061676F2066726F6D207468652063757272656E7420796561722E22202F3E0D0A09093C706172616D206E616D653D22656E64596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D22456E64207965617222206465736372697074696F6E3D22456E74657220746865206C61746573742079656172206F7220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C207468652063757272656E7420796561722077696C6C20626520757365642E22202F3E0D0A09093C706172616D206E616D653D2264617465466F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D224461746520466F726D617422203E0D0A0909093C6F7074696F6E2076616C75653D2225592D256D2D2564223E323030372D30362D30313C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D2225652E256D2E2559223E312E30362E323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D222565202542202559223E31204A756E6520323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D2225652F256D2F2559223E312F30362F323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D22256D2F25652F2559223E30362F312F323030373C2F6F7074696F6E3E0D0A09093C2F706172616D3E09090D0A093C2F706172616D733E0D0A3C2F6D6F73706172616D733E, filesize = 792 WHERE ft_id = 22 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update coremodified params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0D0A093C706172616D733E0D0A09093C706172616D206E616D653D227374617274596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D225374617274207965617222206465736372697074696F6E3D22456E74657220746865207374617274696E672079656172206F72206561726C69657374207965617220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C2069742077696C6C2064656661756C7420746F2037302079656172732061676F2066726F6D207468652063757272656E7420796561722E22202F3E0D0A09093C706172616D206E616D653D22656E64596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D22456E64207965617222206465736372697074696F6E3D22456E74657220746865206C61746573742079656172206F7220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C207468652063757272656E7420796561722077696C6C20626520757365642E22202F3E0D0A09093C706172616D206E616D653D2264617465466F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D224461746520466F726D617422203E0D0A0909093C6F7074696F6E2076616C75653D2225592D256D2D2564223E323030372D30362D30313C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D2225652E256D2E2559223E312E30362E323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D222565202542202559223E31204A756E6520323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D2225652F256D2F2559223E312F30362F323030373C2F6F7074696F6E3E0D0A0909093C6F7074696F6E2076616C75653D22256D2F25652F2559223E30362F312F323030373C2F6F7074696F6E3E0D0A09093C2F706172616D3E09090D0A093C2F706172616D733E0D0A3C2F6D6F73706172616D733E, filesize = 792 WHERE ft_id = 15 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     updateVersion(2, 0, 7);
     $this->updated = true;
     return true;
 }
コード例 #4
0
ファイル: 2_0_3.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     $this->db2dir();
     // Update multilineTextbox field's params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d22726f77732220747970653d2274657874222064656661756c743d223622206c6162656c3d22526f777322202f3e0a09093c706172616d206e616d653d22636f6c732220747970653d2274657874222064656661756c743d22363022206c6162656c3d22436f6c756d6e7322202f3e0a09093c706172616d206e616d653d227374796c652220747970653d2274657874222064656661756c743d2222206c6162656c3d225374796c6522206465736372697074696f6e3d225468652074657874626f782062792064656661756c74206973207374796c6564206279207468652027696e707574626f78272043535320636c6173732e20596f752063616e2073706563696679206164646974696f6e616c207374796c65206865726522202f3e0a0a09093c706172616d206e616d653d22407370616365722220747970653d22737061636572222064656661756c743d2222206c6162656c3d2222206465736372697074696f6e3d2222202f3e0a0a09093c706172616d206e616d653d2273756d6d61727943686172732220747970653d2274657874222064656661756c743d2232353522206c6162656c3d224e756d626572206f662053756d6d617279206368617261637465727322202f3e0a09093c706172616d206e616d653d22737472697053756d6d617279546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2053756d6d617279207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773207468617420636f756c6420706f74656e7469616c6c7920616666656374207768656e2076696577696e672061206c697374206f66206c697374696e67732e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22737472697044657461696c73546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2044657461696c73207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773206578636570742074686f73652074686174206172652073706563696669656420696e2027416c6c6f7765642074616773272e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22706172736555726c2220747970653d22726164696f222064656661756c743d223122206c6162656c3d2250617273652055524c206173206c696e6b20696e2044657461696c732076696577223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a0a09093c706172616d206e616d653d227374726970416c6c546167734265666f7265536176652220747970653d22726164696f222064656661756c743d223022206c6162656c3d22537472697020616c6c2048544d4c2074616773206265666f72652073746f72696e6720746f20646174616261736522206465736372697074696f6e3d224966205759535957494720656469746f7220697320656e61626c656420696e207468652066726f6e742d656e642c2074686973206665617475726520616c6c6f7720796f7520746f20737472697020616e7920706f74656e7469616c6c79206861726d66756c20636f6465732e20596f752063616e207374696c6c20616c6c6f7720736f6d6520746167732077697468696e206465736372697074696f6e206669656c642c2077686963682063616e206265207370656369666965642062656c6f772e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22616c6c6f776564546167732220747970653d2274657874222064656661756c743d22752c622c692c612c756c2c6c692c7072652c626c6f636b71756f746522206c6162656c3d22416c6c6f776564207461677322206465736372697074696f6e3d22456e7465722074686520746167206e616d65732073657065726174656420627920636f6d6d612e205468697320706172616d6574657220616c6c6f7720796f7520746f2061636365707420736f6d652048544d4c2074616773206576656e20696620796f75206861766520656e61626c65207374726970696e67206f6620616c6c2048544d4c20746167732061626f76652e22202f3e0a09090a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 1967 WHERE ft_id = 26 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update metadesc & metakeys class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coremetakey extends mFieldType {\\r\\n	var $name = \'metakey\';\\r\\n	var $numOfInputFields = 0;\\r\\n}" WHERE field_type = "coremetakey" LIMIT 1');
     $database->query();
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coremetadesc extends mFieldType {\\r\\n	var $name = \'metadesc\';\\r\\n	var $numOfInputFields = 0;\\r\\n}" WHERE field_type = "coremetadesc" LIMIT 1');
     $database->query();
     // Update year class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_year extends mFieldType {\\r\\n	var $numOfSearchFields = 2;\\r\\n	function getSearchHTML() {\\r\\n\\r\\n		$startYear = $this->getParam(\'startYear\',(date(\'Y\')-70));\\r\\n		$endYear = $this->getParam(\'endYear\',date(\'Y\'));\\r\\n		\\r\\n		$html = \'<select name=\\"\' . $this->getSearchFieldName(2) . \'\\" class=\\"inputbox\\" size=\\"1\\">\';\\r\\n		$html .= \'<option value=\\"1\\" selected=\\"selected\\">\' . $_MT_LANG->EXACTLY . \'</option>\';\\r\\n		$html .= \'<option value=\\"2\\">\' . $_MT_LANG->AFTER . \'</option>\';\\r\\n		$html .= \'<option value=\\"3\\">\' . $_MT_LANG->BEFORE . \'</option>\';\\r\\n		$html .= \'</select>\';\\r\\n		$html .= \'&nbsp;\';\\r\\n\\r\\n		$html .= \'<select name=\\"\' . $this->getInputFieldName(1) . \'\\" class=\\"inputbox\\">\';\\r\\n		$html .= \'<option value=\\"\\">&nbsp;</option>\';\\r\\n		for($year=$endYear;$year>=$startYear;$year--) {\\r\\n			$html .= \'<option value=\\"\' . $year . \'\\">\' . $year . \'</option>\';\\r\\n		}\\r\\n		$html .= \'</select>\';		\\r\\n\\r\\n		return $html;\\r\\n	}\\r\\n\\r\\n	function getInputHTML() {\\r\\n		$startYear = $this->getParam(\'startYear\',(date(\'Y\')-70));\\r\\n		$endYear = $this->getParam(\'endYear\',date(\'Y\'));\\r\\n		$value = $this->getValue();\\r\\n		\\r\\n		$html = \'\';\\r\\n		$html .= \'<select name=\\"\' . $this->getInputFieldName() . \'\\" class=\\"inputbox\\">\';\\r\\n		$html .= \'<option value=\\"\\">&nbsp;</option>\';\\r\\n		for($year=$endYear;$year>=$startYear;$year--) {\\r\\n			$html .= \'<option value=\\"\' . $year . \'\\"\';\\r\\n			if( $year == $value ) {\\r\\n				$html .= \' selected\';\\r\\n			}\\r\\n			$html .= \'>\' . $year . \'</option>\';\\r\\n		}\\r\\n		$html .= \'</select>\';		\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getWhereCondition() {\\r\\n		$args = func_get_args();\\r\\n		$fieldname = \'cfv#.value\';\\r\\n		if( ($args[1] >= 1 || $args[1] <= 3) && is_numeric($args[0]) ) {\\r\\n			switch($args[1]) {\\r\\n				case 1:\\r\\n					return $fieldname . \' = \\\\\'\' . $args[0] . \'\\\\\'\';\\r\\n					break;\\r\\n				case 2:\\r\\n					return $fieldname . \' > \\\\\'\' . $args[0] . \'\\\\\'\';\\r\\n					break;\\r\\n				case 3:\\r\\n					return $fieldname . \' < \\\\\'\' . $args[0] . \'\\\\\'\';\\r\\n					break;\\r\\n			}\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}	\\r\\n}" WHERE ft_id = "46" LIMIT 1');
     $database->query();
     // Update mfile class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_mFile extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n		$fileExtensions = trim($this->getParam(\'fileExtensions\',\'\'));\\r\\n		if(!empty($fileExtensions)) {\\r\\n			$js = \'\';\\r\\n			$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'\' . $fileExtensions . \'\\\\\')) {\'; \\r\\n			$js .= \'alert(\\"\' . $this->getCaption() . \': Please select files with these extension(s) - \' . str_replace(\'|\',\', \',$fileExtensions) . \'.\\");\';\\r\\n			return $js;\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}\\r\\n}" WHERE ft_id = "48" LIMIT 1');
     $database->query();
     // Update coredesc class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'link_desc\';\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		if( ($inBackEnd AND $mtconf->get(\'use_wysiwyg_editor_in_admin\')) || (!$inBackEnd AND $mtconf->get(\'use_wysiwyg_editor\')) ) {\\r\\n			ob_start();\\r\\n			editorArea( \'editor1\',  $this->getValue() , $this->getInputFieldName(1), \'100%\', $this->getSize(), \'75\', \'25\' );\\r\\n			$html = ob_get_contents();\\r\\n			ob_end_clean();\\r\\n		} else {\\r\\n			$html = \'<textarea class=\\"inputbox\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" style=\\"width:95%;height:\' . $this->getSize() . \'px\\">\' . htmlspecialchars($this->getValue()) . \'</textarea>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'parseMambots\'] = $this->getParam(\'parseMambots\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\/\\/(.*?)(\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n			if (!$mtconf->get(\'use_wysiwyg_editor\') && $params[\'stripDetailsTags\'] && !in_array(\'br\',explode(\',\',$params[\'allowedTags\'])) && !in_array(\'p\',explode($params[\'allowedTags\'])) ) {\\r\\n				$html = nl2br(trim($html));\\r\\n			}\\r\\n			if($params[\'parseMambots\']) {\\r\\n				$this->parseMambots($html);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'@{[\\/\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			// $trimmed_desc = $this->html_cutstr($html,$params[\'summaryChars\']);\\r\\n			$trimmed_desc = $this->html_substr($html,0,$params[\'summaryChars\']);\\r\\n			if ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc . \' <b>...</b>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}" WHERE ft_id = "21" LIMIT 1');
     $database->query();
     // Update corewebsite class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n\\r\\n	function getOutput() {\\r\\n		$maxUrlLength = $this->getParam(\'maxUrlLength\',60);\\r\\n		$text = $this->getParam(\'text\',\'\');\\r\\n		$openNewWindow = $this->getParam(\'openNewWindow\',1);\\r\\n		$useMTVisitRedirect = $this->getParam(\'useMTVisitRedirect\',1);\\r\\n	\\r\\n		$html = \'\';\\r\\n		$html .= \'<a href=\\"\';\\r\\n		if($useMTVisitRedirect) {\\r\\n			global $Itemid;\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=visit&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid);\\r\\n		} else {\\r\\n			$html .= $this->getValue();\\r\\n		}\\r\\n		$html .= \'\\"\';\\r\\n		if( $openNewWindow == 1 ) {\\r\\n			$html .= \' target=\\"_blank\\"\';\\r\\n		}\\r\\n		$html .= \'>\';\\r\\n		if(!empty($text)) {\\r\\n			$html .= $text;\\r\\n		} else {\\r\\n			if( empty($maxUrlLength) || $maxUrlLength == 0 ) {\\r\\n				$html .= $this->getValue();\\r\\n			} else {\\r\\n				$html .= substr($this->getValue(),0,$maxUrlLength);\\r\\n				if( strlen($this->getValue()) > $maxUrlLength ) {\\r\\n					$html .= $this->getParam(\'clippedSymbol\');\\r\\n				}\\r\\n			}\\r\\n		}\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n\\r\\n		$showGo = $this->getParam(\'showGo\',1);\\r\\n		$showSpider = $this->getParam(\'showSpider\',0);\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . $this->getSize() . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		if($showGo) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript:window.open(\\"index3.php?option=com_mtree&task=openurl&url=\\"+escape(document.getElementById(\\"website\\").value))\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->GO . \'\\" />\';\\r\\n		}\\r\\n		\\r\\n		if($showSpider && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript: \';\\r\\n			$html .= \'jQuery(\\"#spiderwebsite\\").html(\\"\' . $_MT_LANG->SPIDER_PROGRESS . \'\\");\';\\r\\n			$html .= \'jQuery.ajax({\\r\\n			  type: \\"POST\\",\\r\\n			  url: mosConfig_live_site+\\"/administrator/index2.php\\",\\r\\n			  data: \\"option=com_mtree&task=ajax&task2=spiderurl&url=\\"+document.getElementById(\\"website\\").value+\\"&no_html=1\\",\\r\\n			  dataType: \\"script\\"\\r\\n			});\';\\r\\n			$html .= \'\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->SPIDER . \'\\" />\';\\r\\n			$html .= \'<span id=\\"spider\' . $this->getInputFieldName(1) . \'\\" style=\\"margin-left:5px;background-color:white\\"></span>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     // Update multilineTextbox class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_multilineTextbox extends mFieldType {\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$params[\'cols\'] = $this->getParam(\'cols\',60);\\r\\n		$params[\'rows\'] = $this->getParam(\'rows\',6);\\r\\n		$params[\'style\'] = $this->getParam(\'style\',\'\');\\r\\n		$html = \'\';\\r\\n		$html .= \'<textarea name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" class=\\"inputbox\\"\';\\r\\n		$html .= \' cols=\\"\' . $params[\'cols\'] . \'\\" rows=\\"\' . $params[\'rows\'] . \'\\"\';\\r\\n		if(!empty($params[\'style\'])) {\\r\\n			$html .=  \' style=\\"\' . $params[\'style\'] . \'\\"\';\\r\\n		}\\r\\n		$html .=  \'>\' . $this->getValue() . \'</textarea>\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n	\\r\\n		$html = $this->getValue();\\r\\n	\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\/\\/(.*?)(\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'@{[\\/\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			} else {\\r\\n			}\\r\\n			$trimmed_desc = trim($this->html_substr($html,0,$params[\'summaryChars\']));\\r\\n			if ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc . \' <b>...</b>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}" WHERE ft_id = "26" LIMIT 1');
     $database->query();
     // Delete config: show_email
     $database->setQuery('DELETE FROM #__mt_config WHERE varname = "show_email" LIMIT 1');
     $database->query();
     // Insert new config - show_favourite
     $database->setQuery("INSERT INTO #__mt_config VALUES ('show_favourite', 'feature', '1', '1', 'yesno', 4000, 1)");
     $database->query();
     // Re-order needapproval_replyreview
     $database->setQuery("UPDATE #__mt_config SET ordering = '8500' WHERE varname = 'needapproval_replyreview' LIMIT 1");
     $database->query();
     // Add 5 configs for image storage for listings and categories - relative_path_to_cat* & relative_path_to_listings*
     $database->setQuery("INSERT INTO #__mt_config ( `varname` , `groupname` , `value` , `default` , `configcode` , `ordering` , `displayed` ) VALUES ('relative_path_to_cat_small_image', 'core', '', '/components/com_mtree/img/cats/s/', '', '', '0')");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_config ( `varname` , `groupname` , `value` , `default` , `configcode` , `ordering` , `displayed` ) VALUES ('relative_path_to_cat_original_image', 'core', '', '/components/com_mtree/img/cats/o/', '', '', '0')");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_config ( `varname` , `groupname` , `value` , `default` , `configcode` , `ordering` , `displayed` ) VALUES ('relative_path_to_listing_small_image', 'core', '', '/components/com_mtree/img/listings/s/', '', '', '0')");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_config ( `varname` , `groupname` , `value` , `default` , `configcode` , `ordering` , `displayed` ) VALUES ('relative_path_to_listing_medium_image', 'core', '', '/components/com_mtree/img/listings/m/', '', '', '0')");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_config ( `varname` , `groupname` , `value` , `default` , `configcode` , `ordering` , `displayed` ) VALUES ('relative_path_to_listing_original_image', 'core', '', '/components/com_mtree/img/listings/o/', '', '', '0')");
     $database->query();
     $this->addColumn('reports', 'rev_id', 'int(10) unsigned NOT NULL default \'0\'', 'link_id');
     updateVersion(2, 0, 3);
     $this->updated = true;
     return true;
 }
コード例 #5
0
ファイル: 2_0_1.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     $this->addColumn('reviews', 'vote_helpful', 'INT UNSIGNED NOT NULL DEFAULT \'0\'');
     $this->addColumn('reviews', 'vote_total', 'INT UNSIGNED NOT NULL DEFAULT \'0\'');
     $this->addColumn('reviews', 'ownersreply_text', 'TEXT NOT NULL');
     $this->addColumn('reviews', 'ownersreply_date', 'DATETIME NOT NULL');
     $this->addColumn('reviews', 'ownersreply_approved', 'TINYINT NOT NULL DEFAULT \'0\'');
     $this->addColumn('reviews', 'ownersreply_admin_note', 'MEDIUMTEXT NOT NULL');
     $this->addColumn('reviews', 'send_email', 'TINYINT NOT NULL DEFAULT \'0\'');
     $this->addColumn('reviews', 'email_message', 'MEDIUMTEXT NOT NULL');
     $this->addRows('fieldtypes_info', array(array('23', '1.00', 'http://www.mosets.com/', ''), array('26', '1.00', 'http://www.mosets.com/', '')));
     // Update corewebsite field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n}" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     // $database->setQuery('INSERT INTO #__mt_fieldtypes VALUES (11, "corewebsite", "Website", "class mFieldType_corewebsite extends mFieldType_weblink {\r\n	var $name = \'website\';\r\n}", 0, 0, 0, 1);');
     // $database->query();
     $database->setQuery("INSERT INTO #__mt_fieldtypes_att VALUES (115, 11, 'params.xml', 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226f70656e4e657757696e646f772220747970653d22726164696f222064656661756c743d223122206c6162656c3d224f70656e204e65772057696e646f7722206465736372697074696f6e3d224f70656e2061206e65772077696e646f77207768656e20746865206c696e6b20697320636c69636b65642e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22746578742220747970653d2274657874222064656661756c743d2222206c6162656c3d224c696e6b205465787422206465736372697074696f6e3d22557365207468697320706172616d6574657220746f207370656369667920746865206c696e6b20746578742e204966206c65667420656d7074792c207468652066756c6c2055524c2077696c6c20626520646973706c6179656420617320746865206c696e6b277320746578742e22202f3e0a09093c706172616d206e616d653d226d617855726c4c656e6774682220747970653d2274657874222064656661756c743d22363022206c6162656c3d224d61782e2055524c204c656e67746822206465736372697074696f6e3d22456e74657220746865206d6178696d756d2055524c2773206c656e677468206265666f726520697420697320636c697070656422202f3e0a09093c706172616d206e616d653d22636c697070656453796d626f6c2220747970653d2274657874222064656661756c743d222e2e2e22206c6162656c3d22436c69707065642073796d626f6c22202f3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, 694, 'text/xml', 1)");
     $database->query();
     // Update weblinknewwin field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_weblinkNewWin extends mFieldType_weblink {\\r\\n\\r\\n}" WHERE field_type = "weblinknewwin" LIMIT 1');
     $database->query();
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226f70656e4e657757696e646f772220747970653d22726164696f222064656661756c743d223122206c6162656c3d224f70656e204e65772057696e646f7722206465736372697074696f6e3d224f70656e2061206e65772077696e646f77207768656e20746865206c696e6b20697320636c69636b65642e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22746578742220747970653d2274657874222064656661756c743d2222206c6162656c3d224c696e6b205465787422206465736372697074696f6e3d22557365207468697320706172616d6574657220746f207370656369667920746865206c696e6b20746578742e204966206c65667420656d7074792c207468652066756c6c2055524c2077696c6c20626520646973706c6179656420617320746865206c696e6b277320746578742e22202f3e0a09093c706172616d206e616d653d226d617855726c4c656e6774682220747970653d2274657874222064656661756c743d22363022206c6162656c3d224d61782e2055524c204c656e67746822206465736372697074696f6e3d22456e74657220746865206d6178696d756d2055524c2773206c656e677468206265666f726520697420697320636c697070656422202f3e0a09093c706172616d206e616d653d22636c697070656453796d626f6c2220747970653d2274657874222064656661756c743d222e2e2e22206c6162656c3d22436c69707065642073796d626f6c22202f3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 694 WHERE ft_id = 23 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     $database->setQuery("DELETE FROM #__mt_fieldtypes_att WHERE ft_id = 23 AND filename = 'application_double.png' LIMIT 1");
     $database->query();
     // Update onlinevideo field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_onlinevideo extends mFieldType {\\r\\n\\r\\n	function getOutput() {\\r\\n		$html =\'\';\\r\\n		$id = $this->getVideoId();\\r\\n		$videoProvider = $this->getParam(\'videoProvider\',\'youtube\');\\r\\n		switch($videoProvider) {\\r\\n			case \'youtube\':\\r\\n				$html .= \'<object width=\\"425\\" height=\\"350\\">\';\\r\\n				$html .= \'<param name=\\"movie\\" value=\\"http://www.youtube.com/v/\' . $id . \'\\"></param>\';\\r\\n				$html .= \'<param name=\\"wmode\\" value=\\"transparent\\"></param>\';\\r\\n				$html .= \'<embed src=\\"http://www.youtube.com/v/\' . $id . \'\\" type=\\"application/x-shockwave-flash\\" wmode=\\"transparent\\" width=\\"425\\" height=\\"350\\"></embed>\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'googlevideo\':\\r\\n				$html .= \'<embed style=\\"width:400px; height:326px;\\" id=\\"VideoPlayback\\" type=\\"application/x-shockwave-flash\\" src=\\"http://video.google.com/googleplayer.swf?docId=\' . $id . \'\\">\';\\r\\n				$html .= \'</embed>\';\\r\\n				break;\\r\\n			/*\\r\\n			case \'metacafe\':\\r\\n				$html .= \'<embed src=\\"http://www.metacafe.com/fplayer/\' . $id . \'.swf\\" width=\\"400\\" height=\\"345\\" wmode=\\"transparent\\" pluginspage=\\"http://www.macromedia.com/go/getflashplayer\\" type=\\"application/x-shockwave-flash\\"></embed>\';\\r\\n				break;\\r\\n			case \'ifilm\':\\r\\n				$html .= \'<embed width=\\"448\\" height=\\"365\\" src=\\"http://www.ifilm.com/efp\\" quality=\\"high\\" bgcolor=\\"000000\\" name=\\"efp\\" align=\\"middle\\" type=\\"application/x-shockwave-flash\\" pluginspage=\\"http://www.macromedia.com/go/getflashplayer\\" flashvars=\\"flvbaseclip=\' . $id . \'&amp;\\"></embed>\';\\r\\n				break;\\r\\n			*/\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getVideoId() {\\r\\n		$videoProvider = $this->getParam(\'videoProvider\',\'youtube\');\\r\\n		$value = $this->getValue();\\r\\n		$id = null;\\r\\n		if(empty($value)) {\\r\\n			return null;\\r\\n		}\\r\\n		$url = parse_url($value);\\r\\n	    parse_str($url[\'query\'], $query);\\r\\n		switch($videoProvider) {\\r\\n			case \'youtube\':\\r\\n				if (isset($query[\'v\'])) {\\r\\n			        $id = $query[\'v\'];\\r\\n			    }\\r\\n				break;\\r\\n			case \'googlevideo\':\\r\\n			    if (isset($query[\'docid\'])) {\\r\\n			        $id = $query[\'docid\'];\\r\\n			    }\\r\\n				break;\\r\\n		}\\r\\n		return $id;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n		$videoProvider = $this->getParam(\'videoProvider\',\'youtube\');\\r\\n		$youtubeInputDescription = $this->getParam(\'youtubeInputDescription\',\'Enter the full URL of the Youtube video page.<br />ie: <b>http://youtube.com/watch?v=OHpANlSG7OI</b>\');\\r\\n		$googlevideoInputDescription = $this->getParam(\'googlevideoInputDescription\',\'Enter the full URL of the Google video page.<br />ie: <b>http://video.google.com/videoplay?docid=832064557062572361</b>\');\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . $this->getSize() . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		switch($videoProvider) {\\r\\n			case \'youtube\':\\r\\n				if(!empty($youtubeInputDescription)) {\\r\\n					$html .= \'<br />\' . $youtubeInputDescription;\\r\\n				}\\r\\n				break;\\r\\n			case \'googlevideo\':\\r\\n				if(!empty($googlevideoInputDescription)) {\\r\\n					$html .= \'<br />\' . $googlevideoInputDescription;\\r\\n				}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getSearchHTML() {\\r\\n		$checkboxLabel = $this->getParam(\'checkboxLabel\',\'Contains video\');\\r\\n		return \'<input class=\\"text_area\\" type=\\"checkbox\\" name=\\"\' . $this->getSearchFieldName(1) . \'\\" id=\\"\' . $this->getSearchFieldName(1) . \'\\" />&nbsp;<label for=\\"\' . $this->getName() . \'\\">\' . $checkboxLabel . \'</label>\';\\r\\n	}\\r\\n	\\r\\n	function getWhereCondition() {\\r\\n		if( func_num_args() == 0 ) {\\r\\n			return null;\\r\\n		} else {\\r\\n			return \'(cfv#.value <> \'\')\';\\r\\n		}\\r\\n	}\\r\\n}" WHERE ft_id = "29" LIMIT 1');
     $database->query();
     $database->setQuery("DELETE FROM #__mt_fieldtypes_att WHERE ft_id = 29");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_fieldtypes_att VALUES ('', 29, 'params.xml', 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0d0a093c706172616d733e0d0a09093c706172616d206e616d653d22766964656f50726f76696465722220747970653d226c697374222064656661756c743d2222206c6162656c3d22566964656f2050726f7669646572223e0d0a0909093c6f7074696f6e2076616c75653d22796f7574756265223e596f75747562653c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d22676f6f676c65766964656f223e476f6f676c6520566964656f3c2f6f7074696f6e3e0d0a0909093c212d2d203c6f7074696f6e2076616c75653d226d65746163616665223e4d657461636166653c2f6f7074696f6e3e202d2d3e0d0a0909093c212d2d203c6f7074696f6e2076616c75653d226966696c6d223e6946696c6d3c2f6f7074696f6e3e202d2d3e0d0a09093c2f706172616d3e0d0a09093c706172616d206e616d653d22636865636b626f784c6162656c2220747970653d2274657874222064656661756c743d22436f6e7461696e7320766964656f22206c6162656c3d22536561726368277320636865636b626f78206c6162656c22202f3e0d0a09093c706172616d206e616d653d22796f7574756265496e7075744465736372697074696f6e2220747970653d2274657874222064656661756c743d22456e746572207468652066756c6c2055524c206f662074686520596f757475626520766964656f20706167652e266c743b6272202f2667743b69653a20266c743b622667743b687474703a2f2f796f75747562652e636f6d2f77617463683f763d4f4870414e6c5347374f49266c743b2f622667743b22206c6162656c3d22496e707574206465736372697074696f6e22202f3e0d0a09093c706172616d206e616d653d22676f6f676c65766964656f496e7075744465736372697074696f6e2220747970653d2274657874222064656661756c743d22456e746572207468652066756c6c2055524c206f662074686520476f6f676c6520766964656f20706167652e266c743b6272202f2667743b69653a20266c743b622667743b687474703a2f2f766964656f2e676f6f676c652e636f6d2f766964656f706c61793f646f6369643d383332303634353537303632353732333631266c743b2f622667743b22206c6162656c3d22496e707574206465736372697074696f6e22202f3e0d0a093c2f706172616d733e0d0a3c2f6d6f73706172616d733e, 905, 'text/xml', 1);");
     $database->query();
     // Update corename field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corename extends mFieldType {\\r\\n	var $name = \'link_name\';\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'maxSummaryChars\'] = intval($this->getParam(\'maxSummaryChars\',55));\\r\\n		$params[\'maxDetailsChars\'] = intval($this->getParam(\'maxDetailsChars\',0));\\r\\n		$value = $this->getValue();\\r\\n		$output = \'\';\\r\\n		if($view == 1 AND $params[\'maxDetailsChars\'] > 0 AND $this->strlen_utf8($value) > $params[\'maxDetailsChars\']) {\\r\\n			$output .= $this->html_cutstr($value,$params[\'maxDetailsChars\']);\\r\\n			$output .= \'...\';\\r\\n		} elseif($view == 2 AND $params[\'maxSummaryChars\'] > 0 AND $this->strlen_utf8($value) > $params[\'maxSummaryChars\']) {\\r\\n			$output .= $this->html_cutstr($value,$params[\'maxSummaryChars\']);\\r\\n			$output .= \'...\';\\r\\n		} else {\\r\\n			$output = $value;\\r\\n		}\\r\\n		return $output;\\r\\n	}\\r\\n	\\r\\n	function strlen_utf8($str)	{ return strlen(utf8_decode($this->utf8_html_entity_decode($str)));	}\\r\\n	function utf8_replaceEntity($result){\\r\\n		$value = intval($result[1]);\\r\\n		$string = \'\';\\r\\n		$len = round(pow($value,1/8));\\r\\n		for($i=$len;$i>0;$i--){\\r\\n		    $part = ($value AND (255>>2)) | pow(2,7);\\r\\n		    if ( $i == 1 ) $part |= 255<<(8-$len);\\r\\n		    $string = chr($part) . $string;\\r\\n		    $value >>= 6;\\r\\n		}\\r\\n		return $string;\\r\\n	}\\r\\n	function utf8_html_entity_decode($string){ return preg_replace_callback(\'/&#([0-9]+);/u\',array($this,\'utf8_replaceEntity\'),$string);	}\\r\\n	function html_cutstr($str, $len) {\\r\\n		if (!preg_match(\'/\\&#[0-9]*;.*/i\', $str)) {\\r\\n			return substr($str, 0, $len);\\r\\n		}\\r\\n		$chars = 0;\\r\\n		$start = 0;\\r\\n		for($i=0; $i < strlen($str); $i++) {\\r\\n			if ($chars >= $len) {\\r\\n				break;\\r\\n			}\\r\\n		    $str_tmp = substr($str, $start, $i-$start);\\r\\n		    if (preg_match(\'/\\&#[0-9]*;.*/i\', $str_tmp)) {\\r\\n				$chars++;\\r\\n		        $start = $i;\\r\\n		    }\\r\\n		}\\r\\n		$rVal = substr($str, 0, $start);\\r\\n		if (strlen($str) > $start)\\r\\n		return $rVal;\\r\\n	}\\r\\n}" WHERE ft_id = "20" LIMIT 1');
     $database->query();
     // Update coredesc field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = \'class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'\'link_desc\'\';\\r\\n	function stripTags($value) {\\r\\n		$params[\'\'allowedTags\'\'] = $this->getParam(\'\'allowedTags\'\',\'\'u,b,i,a,ul,li,pre,br,blockquote\'\');\\r\\n		if(!empty($params[\'\'allowedTags\'\'])) {\\r\\n			$tmp = explode(\'\',\'\',$params[\'\'allowedTags\'\']);\\r\\n			array_walk($tmp,\'\'trim\'\');\\r\\n			$allowedTags = \'\'<\'\' . implode(\'\'><\'\',$tmp) . \'\'>\'\';\\r\\n		} else {\\r\\n			$allowedTags = \'\'\'\';\\r\\n		}\\r\\n		return strip_tags( $value, $allowedTags );\\r\\n	}\\r\\n	function parseValue($value) {\\r\\n		$params[\'\'stripAllTagsBeforeSave\'\'] = $this->getParam(\'\'stripAllTagsBeforeSave\'\',0);\\r\\n		if($params[\'\'stripAllTagsBeforeSave\'\']) {\\r\\n			$value = $this->stripTags($value);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'\'PHP_SELF\'\']),-13) == \'\'administrator\'\') ? true : false;\\r\\n		if( ($inBackEnd AND $mtconf->get(\'\'use_wysiwyg_editor_in_admin\'\')) || (!$inBackEnd AND $mtconf->get(\'\'use_wysiwyg_editor\'\')) ) {\\r\\n			ob_start();\\r\\n			editorArea( \'\'editor1\'\',  $this->getValue() , $this->getInputFieldName(1), \'\'100%\'\', $this->getSize(), \'\'75\'\', \'\'25\'\' );\\r\\n			$html = ob_get_contents();\\r\\n			ob_end_clean();\\r\\n		} else {\\r\\n			$html = \'\'<textarea class="inputbox" name="\'\' . $this->getInputFieldName(1) . \'\'" style="width:95%;height:\'\' . $this->getSize() . \'\'px">\'\' . htmlspecialchars($this->getValue()) . \'\'</textarea>\'\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'\'<input class="inputbox" type="text" name="\'\' . $this->getName() . \'\'" size="30" />\'\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'\'parseUrl\'\'] = $this->getParam(\'\'parseUrl\'\',1);\\r\\n		$params[\'\'summaryChars\'\'] = $this->getParam(\'\'summaryChars\'\',255);\\r\\n		$params[\'\'stripSummaryTags\'\'] = $this->getParam(\'\'stripSummaryTags\'\',1);\\r\\n		$params[\'\'stripDetailsTags\'\'] = $this->getParam(\'\'stripDetailsTags\'\',1);\\r\\n		$params[\'\'parseMambots\'\'] = $this->getParam(\'\'parseMambots\'\',0);\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			if($params[\'\'stripDetailsTags\'\']) {\\r\\n				$html = $this->stripTags($html);\\r\\n			}\\r\\n			if($params[\'\'parseUrl\'\'] AND $view == 0) {\\r\\n				$regex = \'\'/http:\\/\\/(.*?)(\\s|$)/i\'\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'\'linkcreator\'\'), $html );\\r\\n			}\\r\\n			if (!$mtconf->get(\'\'use_wysiwyg_editor\'\')) {\\r\\n				$html = nl2br(trim($html));\\r\\n			}\\r\\n			if($params[\'\'parseMambots\'\']) {\\r\\n				$this->parseMambots($html);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'\'@{[\\/\\!]*?[^<>]*?}@si\'\', \'\'\'\', $html);\\r\\n			if($params[\'\'stripSummaryTags\'\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			$trimmed_desc = $this->html_cutstr($html,$params[\'\'summaryChars\'\']);\\r\\n			if  ($this->strlen_utf8($html) > $params[\'\'summaryChars\'\']) {\\r\\n				$html = $trimmed_desc . \'\' <b>...</b>\'\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function parseMambots( &$html ) {\\r\\n		global $_MAMBOTS, $mtconf;\\r\\n\\r\\n		$_MAMBOTS->loadBotGroup( \'\'content\'\' );\\r\\n\\r\\n		// Load Parameters\\r\\n		$params =& new mosParameters( \'\'\'\' );\\r\\n		$link = new stdclass;\\r\\n		$link->text = $html;\\r\\n		\\r\\n		$link->id = 1;\\r\\n		$link->title = \'\'\'\';\\r\\n		$page = 0;\\r\\n		$results = $_MAMBOTS->trigger( \'\'onPrepareContent\'\', array( &$link, &$params, $page ), true );\\r\\n		$html = $link->text;\\r\\n\\r\\n		return true;\\r\\n	}\\r\\n	function linkcreator( $matches )\\r\\n	{	\\r\\n		$url = \'\'http://\'\';\\r\\n		$append = \'\'\'\';\\r\\n\\r\\n		if ( in_array(substr($matches[1],-1), array(\'\'.\'\',\'\')\'\')) ) {\\r\\n			$url .= substr($matches[1], 0, -1);\\r\\n			$append = substr($matches[1],-1);\\r\\n\\r\\n		# Prevent cutting off breaks <br />\\r\\n		} elseif( substr($matches[1],-3) == \'\'<br\'\' ) {\\r\\n			$url .= substr($matches[1], 0, -3);\\r\\n			$append = substr($matches[1],-3);\\r\\n\\r\\n		} elseif( substr($matches[1],-1) == \'\'>\'\' ) {\\r\\n			$regex = \'\'/<(.*?)>/i\'\';\\r\\n			preg_match( $regex, $matches[1], $tags );\\r\\n			if( !empty($tags[1]) ) {\\r\\n				$append = \'\'<\'\'.$tags[1].\'\'>\'\';\\r\\n				$url .= $matches[1];\\r\\n				$url = str_replace( $append, \'\'\'\', $url );\\r\\n			}\\r\\n		} else {\\r\\n			$url .= $matches[1];\\r\\n		}\\r\\n\\r\\n		return \'\'<a href="\'\'.$url.\'\'" target="_blank">\'\'.$url.\'\'</a>\'\'.$append.\'\' \'\';\\r\\n	}\\r\\n	function strlen_utf8($str)	{ return strlen(utf8_decode($this->utf8_html_entity_decode($str)));	}\\r\\n	function utf8_replaceEntity($result){\\r\\n		$value = intval($result[1]);\\r\\n		$string = \'\'\'\';\\r\\n		$len = round(pow($value,1/8));\\r\\n		for($i=$len;$i>0;$i--){\\r\\n		    $part = ($value AND (255>>2)) | pow(2,7);\\r\\n		    if ( $i == 1 ) $part |= 255<<(8-$len);\\r\\n		    $string = chr($part) . $string;\\r\\n		    $value >>= 6;\\r\\n		}\\r\\n		return $string;\\r\\n	}\\r\\n	function utf8_html_entity_decode($string){ return preg_replace_callback(\'\'/&#([0-9]+);/u\'\',array($this,\'\'utf8_replaceEntity\'\'),$string); }\\r\\n	function html_cutstr($str, $len) {\\r\\n		if (!preg_match(\'\'/\\&#[0-9]*;.*/i\'\', $str)) {\\r\\n			return substr($str,0,$len);\\r\\n		}\\r\\n\\r\\n		$chars = 0;\\r\\n		$start = 0;\\r\\n		for($i=0; $i < strlen($str); $i++) {\\r\\n			if ($chars >= $len) {\\r\\n				break;\\r\\n			}\\r\\n		    $str_tmp = substr($str, $start, $i-$start);\\r\\n		    if (preg_match(\'\'/\\&#[0-9]*;.*/i\'\', $str_tmp)) {\\r\\n				$chars++;\\r\\n		        $start = $i;\\r\\n		    }\\r\\n		}\\r\\n		$rVal = substr($str, 0, $start);\\r\\n		if (strlen($str) > $start)\\r\\n		return $rVal;\\r\\n	}\\r\\n}\' WHERE field_type = \'coredesc\' LIMIT 1');
     $database->query();
     $database->setQuery("DELETE FROM #__mt_fieldtypes_att WHERE ft_id = 21");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_fieldtypes_att VALUES ('', 21, 'params.xml', 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d2273756d6d61727943686172732220747970653d2274657874222064656661756c743d2232353522206c6162656c3d224e756d626572206f662053756d6d617279206368617261637465727322202f3e0a09093c706172616d206e616d653d22737472697053756d6d617279546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2053756d6d617279207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773207468617420636f756c6420706f74656e7469616c6c7920616666656374207768656e2076696577696e672061206c697374206f66206c697374696e67732e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22737472697044657461696c73546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2044657461696c73207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773206578636570742074686f73652074686174206172652073706563696669656420696e2027416c6c6f7765642074616773272e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22706172736555726c2220747970653d22726164696f222064656661756c743d223122206c6162656c3d2250617273652055524c206173206c696e6b20696e2044657461696c732076696577223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a0a09093c706172616d206e616d653d227374726970416c6c546167734265666f7265536176652220747970653d22726164696f222064656661756c743d223022206c6162656c3d22537472697020616c6c2048544d4c2074616773206265666f72652073746f72696e6720746f20646174616261736522206465736372697074696f6e3d224966205759535957494720656469746f7220697320656e61626c656420696e207468652066726f6e742d656e642c2074686973206665617475726520616c6c6f7720796f7520746f20737472697020616e7920706f74656e7469616c6c79206861726d66756c20636f6465732e20596f752063616e207374696c6c20616c6c6f7720736f6d6520746167732077697468696e206465736372697074696f6e206669656c642c2077686963682063616e206265207370656369666965642062656c6f772e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22616c6c6f776564546167732220747970653d2274657874222064656661756c743d22752c622c692c612c756c2c6c692c7072652c626c6f636b71756f746522206c6162656c3d22416c6c6f776564207461677322206465736372697074696f6e3d22456e7465722074686520746167206e616d65732073657065726174656420627920636f6d6d612e205468697320706172616d6574657220616c6c6f7720796f7520746f2061636365707420736f6d652048544d4c2074616773206576656e20696620796f75206861766520656e61626c65207374726970696e67206f6620616c6c2048544d4c20746167732061626f76652e22202f3e0a09093c706172616d206e616d653d2270617273654d616d626f74732220747970653d22726164696f222064656661756c743d223022206c6162656c3d225061727365204d616d626f747322206465736372697074696f6e3d22456e61626c696e6720746869732077696c6c207061727365206d616d626f747320636f646573732077697468696e20746865206465736372697074696f6e206669656c64223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, 1822, 'text/xml', 1)");
     $database->query();
     updateVersion(2, 0, 1);
     return true;
 }
コード例 #6
0
ファイル: 2_0_5.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     // Update coredesc class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'link_desc\';\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		if( ($inBackEnd AND $mtconf->get(\'use_wysiwyg_editor_in_admin\')) || (!$inBackEnd AND $mtconf->get(\'use_wysiwyg_editor\')) ) {\\r\\n			ob_start();\\r\\n			editorArea( \'editor1\',  $this->getValue() , $this->getInputFieldName(1), \'100%\', $this->getSize(), \'75\', \'25\' );\\r\\n			$html = ob_get_contents();\\r\\n			ob_end_clean();\\r\\n		} else {\\r\\n			$html = \'<textarea class=\\"inputbox\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" style=\\"width:95%;height:\' . $this->getSize() . \'px\\">\' . htmlspecialchars($this->getValue()) . \'</textarea>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'parseMambots\'] = $this->getParam(\'parseMambots\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		$params[\'showReadMore\'] = $this->getParam(\'showReadMore\',0);\\r\\n		$params[\'whenReadMore\'] = $this->getParam(\'whenReadMore\',0);\\r\\n		$params[\'txtReadMore\'] = $this->getParam(\'txtReadMore\',(( $GLOBALS[\'_VERSION\']->RELEASE == \'1.0\' )?_READ_MORE:JTEXT::_( \'Read More...\' )));\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\/\\/(.*?)(\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n			if (!$mtconf->get(\'use_wysiwyg_editor\') && $params[\'stripDetailsTags\'] && !in_array(\'br\',explode(\',\',$params[\'allowedTags\'])) && !in_array(\'p\',explode(\',\',$params[\'allowedTags\'])) ) {\\r\\n				$html = nl2br(trim($html));\\r\\n			}\\r\\n			if($params[\'parseMambots\']) {\\r\\n				$this->parseMambots($html);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			global $Itemid;\\r\\n			$html = preg_replace(\'@{[\\/\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			$trimmed_desc = trim($this->html_substr($html,0,$params[\'summaryChars\']));\\r\\n			if ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc;\\r\\n				$html .= \' <b>...</b>\';\\r\\n			}\\r\\n			if( $params[\'showReadMore\'] && ($params[\'whenReadMore\'] == 1 || ($params[\'whenReadMore\'] == 0 && $this->strlen_utf8($html) > $params[\'summaryChars\'])) ) {\\r\\n				if(!empty($trimmed_desc)) {\\r\\n					$html .= \'<br />\';\\r\\n				}\\r\\n				$html .= \' <a href=\\"\' . JRoute::_(\'index.php?option=com_mtree&task=viewlink&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid) . \'\\" class=\\"readon\\">\' . $params[\'txtReadMore\'] . \'</a>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "coredesc" LIMIT 1');
     $database->query();
     // Update coredesc version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "21" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coredesc field type to version 2.');
     // Update corerating class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corerating extends mFieldType {\\r\\n	var $name = \'link_rating\';\\r\\n	var $numOfSearchFields = 0;\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput($view=1) {\\r\\n		return round($this->getValue(),2);\\r\\n	}\\r\\n}"  WHERE field_type = "corerating" LIMIT 1');
     $database->query();
     // Update corerating version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "1" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corerating field type to version 2.');
     // Update image class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_image extends mFieldType_file {\\r\\n	function parseValue($value) {\\r\\n		global $mtconf;\\r\\n		$params[\'size\'] = intval(trim($this->getParam(\'size\')));\\r\\n		if($params[\'size\'] <= 0) {\\r\\n			$size = $mtconf->get(\'resize_listing_size\');\\r\\n		} else {\\r\\n			$size = intval($params[\'size\']);\\r\\n		}\\r\\n		$mtImage = new mtImage();\\r\\n		$mtImage->setMethod( $mtconf->get(\'resize_method\') );\\r\\n		$mtImage->setQuality( $mtconf->get(\'resize_quality\') );\\r\\n		$mtImage->setSize( $size );\\r\\n		$mtImage->setTmpFile( $value[\'tmp_name\'] );\\r\\n		$mtImage->setType( $value[\'type\'] );\\r\\n		$mtImage->setName( $value[\'name\'] );\\r\\n		$mtImage->setSquare(false);\\r\\n		$mtImage->resize();\\r\\n		$value[\'data\'] = $mtImage->getImageData();\\r\\n		$value[\'size\'] = strlen($value[\'data\']);\\r\\n		\\r\\n		return $value;\\r\\n	}\\r\\n	function getJSValidation() {\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'gif|png|jpg|jpeg\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . $this->getCaption() . \': Please select an image with one of these extensions - gif,png,jpg,jpeg.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$html = \'\';\\r\\n		$html .= \'<img src=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$html = \'\';\\r\\n		if( $this->attachment > 0 ) {\\r\\n			$html .= $this->getKeepFileCheckboxHTML($this->attachment);\\r\\n			$html .= \'<label for=\\"\' . $this->getKeepFileName() . \'\\"><img src=\\"\' . $this->getDataAttachmentURL() . \'\\" hspace=\\"5\\" vspace=\\"0\\" /></label>\';\\r\\n			$html .= \'</br >\';\\r\\n		}\\r\\n		$html .= \'<input class=\\"inputbox\\" type=\\"file\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "image" LIMIT 1');
     $database->query();
     // Update image version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "25" LIMIT 1');
     $database->query();
     $this->printStatus('Updated image field type to version 2.');
     // Update videoplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_videoplayer extends mFieldType_file {\\r\\n\\r\\n	function getOutput() {\\r\\n		$html =\'\';\\r\\n		$filename = $this->getValue();\\r\\n		$format = $this->getParam(\'format\');\\r\\n		$id = $format.$filename;\\r\\n		$width = $this->getParam(\'width\');\\r\\n		$height = $this->getParam(\'height\');\\r\\n		$autoplay = $this->getParam(\'autoplay\',false);\\r\\n		\\r\\n		switch($format) {\\r\\n			case \'mov\':\\r\\n				$html .= \'<object classid=\\"clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B\\" width=\\"\' . $width . \'\\" height=\\"\' . $height. \'\\" codebase=\\"http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0\\" align=\\"middle\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"autoplay\\" value=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/quicktime\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" pluginspage=\\"http://www.apple.com/quicktime/download/\\" align=\\"middle\\" autoplay=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'divx\':\\r\\n				$html .= \'\';\\r\\n				$html .= \'<object classid=\\"clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" codebase=\\"http://go.divx.com/plugin/DivXBrowserPlugin.cab\\">\';\\r\\n				$html .= \'<param name=\\"src\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"autoPlay\\" value=\\"\' . $autoplay . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"video/divx\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" autoPlay=\\"\' . $autoplay . \'\\" pluginspage=\\"http://go.divx.com/plugin/download/\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n			case \'windowsmedia\':\\r\\n				$html .= \'<object classid=\\"CLSID:6BF52A52-394A-11D3-B153-00C04F79FAA6\\" id=\\"\' . $id . \'\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" type=\\"application/x-oleobject\\">\';\\r\\n				$html .= \'<param name=\\"URL\\" value=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n				$html .= \'<param name=\\"wmode\\" value=\\"opaque\\" />\';\\r\\n				$html .= \'<param name=\\"ShowControls\\" value=\\"1\\" />\';\\r\\n				$html .= \'<param name=\\"autoStart\\" value=\\"\' . (($autoplay)?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'<embed src=\\"\' . $this->getDataAttachmentURL() . \'\\" type=\\"application/x-mplayer2\\" width=\\"\' . $width . \'\\" height=\\"\' . $height . \'\\" wmode=\\"opaque\\" border=\\"0\\" autoStart=\\"\' . (($autoplay)?\'1\':\'0\') . \'\\" />\';\\r\\n				$html .= \'</object>\';\\r\\n				break;\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "videoplayer" LIMIT 1');
     $database->query();
     // Update videoplayer version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "45" LIMIT 1');
     $database->query();
     $this->printStatus('Updated videoplayer field type to version 2.');
     // Update videoplayer params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D22666F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D22566964656F20466F726D6174223E0A0909093C6F7074696F6E2076616C75653D226D6F76223E517569636B74696D65204D6F7669653C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2264697678223E446976583C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2277696E646F77736D65646961223E57696E646F7773204D6564696120566964656F3C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2277696474682220747970653D2274657874222064656661756C743D2222206C6162656C3D22576964746822202F3E0A09093C706172616D206E616D653D226865696768742220747970653D2274657874222064656661756C743D2222206C6162656C3D2268656967687422202F3E0A09093C706172616D206E616D653D226175746F706C61792220747970653D22726164696F222064656661756C743D2266616C736522206C6162656C3D224175746F20506C6179223E0A0909093C6F7074696F6E2076616C75653D2274727565223E5965733C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2266616C7365223E4E6F3C2F6F7074696F6E3E0A09093C2F706172616D3E0A09090A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 572 WHERE ft_id = 45 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update coredesc params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D2273756D6D61727943686172732220747970653D2274657874222064656661756C743D2232353522206C6162656C3D224E756D626572206F662053756D6D617279206368617261637465727322202F3E0A09093C706172616D206E616D653D22737472697053756D6D617279546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2053756D6D617279207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773207468617420636F756C6420706F74656E7469616C6C7920616666656374207768656E2076696577696E672061206C697374206F66206C697374696E67732E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22737472697044657461696C73546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2044657461696C73207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773206578636570742074686F73652074686174206172652073706563696669656420696E2027416C6C6F7765642074616773272E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22706172736555726C2220747970653D22726164696F222064656661756C743D223122206C6162656C3D2250617273652055524C206173206C696E6B20696E2044657461696C732076696577223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A0A09093C706172616D206E616D653D227374726970416C6C546167734265666F7265536176652220747970653D22726164696F222064656661756C743D223022206C6162656C3D22537472697020616C6C2048544D4C2074616773206265666F72652073746F72696E6720746F20646174616261736522206465736372697074696F6E3D224966205759535957494720656469746F7220697320656E61626C656420696E207468652066726F6E742D656E642C2074686973206665617475726520616C6C6F7720796F7520746F20737472697020616E7920706F74656E7469616C6C79206861726D66756C20636F6465732E20596F752063616E207374696C6C20616C6C6F7720736F6D6520746167732077697468696E206465736372697074696F6E206669656C642C2077686963682063616E206265207370656369666965642062656C6F772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22616C6C6F776564546167732220747970653D2274657874222064656661756C743D22752C622C692C612C756C2C6C692C7072652C626C6F636B71756F746522206C6162656C3D22416C6C6F776564207461677322206465736372697074696F6E3D22456E7465722074686520746167206E616D65732073657065726174656420627920636F6D6D612E205468697320706172616D6574657220616C6C6F7720796F7520746F2061636365707420736F6D652048544D4C2074616773206576656E20696620796F75206861766520656E61626C65207374726970696E67206F6620616C6C2048544D4C20746167732061626F76652E22202F3E0A09093C706172616D206E616D653D2270617273654D616D626F74732220747970653D22726164696F222064656661756C743D223022206C6162656C3D225061727365204D616D626F747322206465736372697074696F6E3D22456E61626C696E6720746869732077696C6C207061727365206D616D626F747320636F646573732077697468696E20746865206465736372697074696F6E206669656C64223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F77526561644D6F72652220747970653D22726164696F222064656661756C743D223022206C6162656C3D2253686F77202671756F743B52656164204D6F72652E2E2E2671756F743B22206465736372697074696F6E3D2253686F77202671756F743B52656164204D6F72652E2E2671756F743B2069662061206465736372697074696F6E207465787420636C697070656420696E2053756D6D61727920566965772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D227768656E526561644D6F72652220747970653D226C697374222064656661756C743D223022206C6162656C3D225768656E20746F2073686F77202671756F743B52656164204D6F72652E2E2671756F743B22206465736372697074696F6E3D225468697320616C6C6F7720796F7520746F20736574207768656E20746F2073686F7720746865202671756F743B52656164204D6F72652E2E2671756F743B206C696E6B2E223E0A0909093C6F7074696F6E2076616C75653D2230223E4F6E6C79207768656E206465736372697074696F6E20697320636C697070656420696E2053756D6D61727920566965773C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E416C6C207468652074696D653C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22747874526561644D6F72652220747970653D2274657874222064656661756C743D2252656164204D6F72652E2E2E22206C6162656C3D2252656164204D6F7265207465787422206465736372697074696F6E3D22456E74657220746865202671756F743B52656164204D6F72652E2E2671756F743B20746578742E22202F3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 2541 WHERE ft_id = 21 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     updateVersion(2, 0, 5);
     $this->updated = true;
     return true;
 }
コード例 #7
0
ファイル: 2_0_2.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     // Delete config: show_email
     $database->setQuery('DELETE FROM #__mt_config WHERE varname = "show_email" LIMIT 1');
     $database->query();
     // Update jQuery library to 1.1.4
     $database->setQuery('UPDATE #__mt_config SET `value` = "/components/com_mtree/js/jquery-1.1.4.pack.js", `default` = "/components/com_mtree/js/jquery-1.1.4.pack.js" WHERE varname = "relative_path_to_js_library" LIMIT 1');
     $database->query();
     // Add 2 new fieldtypes - coremetakey & coremetadesc
     $database->setQuery("INSERT INTO #__mt_customfields VALUES ('', 'coremetakey', 'Meta Keys', '', 0, '', '', '', '', '', 0, 23, 0, 0, 0, 0, 1, 1, 0, 0, '', '', 1)");
     $database->query();
     $database->setQuery("INSERT INTO #__mt_customfields VALUES ('', 'coremetadesc', 'Meta Description', '', 0, '', '', '', '', '', 0, 24, 0, 0, 1, 0, 0, 0, 0, 0, '', '', 1)");
     $database->query();
     $database->setQuery('INSERT INTO #__mt_fieldtypes VALUES (30, "coremetakey", "Meta Keys", "class mFieldType_coremetakey extends mFieldType {\\r\\n	var $name = \'metakey\';\\r\\n	var $numOfInputFields = 0;\\r\\n}", 0, 0, 0, 1)');
     $database->query();
     $database->setQuery('INSERT INTO #__mt_fieldtypes VALUES (31, "coremetadesc", "Meta Description", "class mFieldType_coremetadesc extends mFieldType {\\r\\n	var $name = \'metadesc\';\\r\\n	var $numOfInputFields = 0;\\r\\n}\\r\\n", 0, 0, 0, 1)');
     $database->query();
     // Update corefeatured field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corefeatured extends mFieldType {\\r\\n	var $name = \'link_featured\';\\r\\n	var $numOfSearchFields = 0;\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput() {\\r\\n\\r\\n		$featured = $this->getValue();\\r\\n		$html = \'\';\\r\\n		if($featured) {\\r\\n			$html .= $_MT_LANG->YES;\\r\\n		} else {\\r\\n			$html .= $_MT_LANG->NO;\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}" WHERE ft_id = "14" LIMIT 1');
     $database->query();
     // Update multilineTextBox field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_multilineTextbox extends mFieldType {\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$params[\'cols\'] = $this->getParam(\'cols\',60);\\r\\n		$params[\'rows\'] = $this->getParam(\'rows\',6);\\r\\n		$params[\'style\'] = $this->getParam(\'style\',\'\');\\r\\n		$html = \'\';\\r\\n		$html .= \'<textarea name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" class=\\"inputbox\\"\';\\r\\n		$html .= \' cols=\\"\' . $params[\'cols\'] . \'\\" rows=\\"\' . $params[\'rows\'] . \'\\"\';\\r\\n		if(!empty($params[\'style\'])) {\\r\\n			$html .=  \' style=\\"\' . $params[\'style\'] . \'\\"\';\\r\\n		}\\r\\n		$html .=  \'>\' . $this->getValue() . \'</textarea>\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n	\\r\\n		$html = $this->getValue();\\r\\n	\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\/\\/(.*?)(\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'@{[\\/\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			} else {\\r\\n			}\\r\\n			$trimmed_desc = $this->html_cutstr($html,$params[\'summaryChars\']);\\r\\n			if  ($this->strlen_utf8($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc . \' <b>...</b>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}" WHERE ft_id = "26" LIMIT 1');
     $database->query();
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d2273756d6d61727943686172732220747970653d2274657874222064656661756c743d2232353522206c6162656c3d224e756d626572206f662053756d6d617279206368617261637465727322202f3e0a09093c706172616d206e616d653d22737472697053756d6d617279546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2053756d6d617279207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773207468617420636f756c6420706f74656e7469616c6c7920616666656374207768656e2076696577696e672061206c697374206f66206c697374696e67732e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22737472697044657461696c73546167732220747970653d22726164696f222064656661756c743d223122206c6162656c3d22537472697020616c6c2048544d4c207461677320696e2044657461696c73207669657722206465736372697074696f6e3d2253657474696e67207468697320746f207965732077696c6c2072656d6f766520616c6c2074616773206578636570742074686f73652074686174206172652073706563696669656420696e2027416c6c6f7765642074616773272e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22706172736555726c2220747970653d22726164696f222064656661756c743d223122206c6162656c3d2250617273652055524c206173206c696e6b20696e2044657461696c732076696577223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a0a09093c706172616d206e616d653d227374726970416c6c546167734265666f7265536176652220747970653d22726164696f222064656661756c743d223022206c6162656c3d22537472697020616c6c2048544d4c2074616773206265666f72652073746f72696e6720746f20646174616261736522206465736372697074696f6e3d224966205759535957494720656469746f7220697320656e61626c656420696e207468652066726f6e742d656e642c2074686973206665617475726520616c6c6f7720796f7520746f20737472697020616e7920706f74656e7469616c6c79206861726d66756c20636f6465732e20596f752063616e207374696c6c20616c6c6f7720736f6d6520746167732077697468696e206465736372697074696f6e206669656c642c2077686963682063616e206265207370656369666965642062656c6f772e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22616c6c6f776564546167732220747970653d2274657874222064656661756c743d22752c622c692c612c756c2c6c692c7072652c626c6f636b71756f746522206c6162656c3d22416c6c6f776564207461677322206465736372697074696f6e3d22456e7465722074686520746167206e616d65732073657065726174656420627920636f6d6d612e205468697320706172616d6574657220616c6c6f7720796f7520746f2061636365707420736f6d652048544d4c2074616773206576656e20696620796f75206861766520656e61626c65207374726970696e67206f6620616c6c2048544d4c20746167732061626f76652e22202f3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 1584 WHERE ft_id = 26 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update corewebsite field
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "' . 'class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n\\r\\n	function getOutput() {\\r\\n		$maxUrlLength = $this->getParam(\'maxUrlLength\',60);\\r\\n		$text = $this->getParam(\'text\',\'\');\\r\\n		$openNewWindow = $this->getParam(\'openNewWindow\',1);\\r\\n		$useMTVisitRedirect = $this->getParam(\'useMTVisitRedirect\',1);\\r\\n	\\r\\n		$html = \'\';\\r\\n		$html .= \'<a href=\\"\';\\r\\n		if($useMTVisitRedirect) {\\r\\n			global $Itemid;\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=visit&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid);\\r\\n		} else {\\r\\n			$html .= $this->getValue();\\r\\n		}\\r\\n		$html .= \'\\"\';\\r\\n		if( $openNewWindow == 1 ) {\\r\\n			$html .= \' target=\\"_blank\\"\';\\r\\n		}\\r\\n		$html .= \'>\';\\r\\n		if(!empty($text)) {\\r\\n			$html .= $text;\\r\\n		} else {\\r\\n			if( empty($maxUrlLength) || $maxUrlLength == 0 ) {\\r\\n				$html .= $this->getValue();\\r\\n			} else {\\r\\n				$html .= substr($this->getValue(),0,$maxUrlLength);\\r\\n				if( strlen($this->getValue()) > $maxUrlLength ) {\\r\\n					$html .= $this->getParam(\'clippedSymbol\');\\r\\n				}\\r\\n			}\\r\\n		}\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n\\r\\n		$showGo = $this->getParam(\'showGo\',1);\\r\\n		$showSpider = $this->getParam(\'showSpider\',0);\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . $this->getSize() . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		if($showGo) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript:window.open(\\"index3.php?option=com_mtree&task=openurl&url=\\"+escape(document.getElementById(\\"website\\").value))\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->GO . \'\\" />\';\\r\\n		}\\r\\n		if($showSpider) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript: \';\\r\\n			$html .= \'jQuery(\\"#spiderwebsite\\").html(\\"\' . $_MT_LANG->SPIDER_PROGRESS . \'\\");\';\\r\\n			$html .= \'jQuery.ajax({\\r\\n			  type: \\"POST\\",\\r\\n			  url: mosConfig_live_site+\\"/administrator/index2.php\\",\\r\\n			  data: \\"option=com_mtree&task=ajax&task2=spiderurl&url=\\"+document.getElementById(\\"website\\").value+\\"&no_html=1\\",\\r\\n			  dataType: \\"script\\"\\r\\n			});\';\\r\\n			$html .= \'\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->SPIDER . \'\\" />\';\\r\\n			$html .= \'<span id=\\"spider\' . $this->getInputFieldName(1) . \'\\" style=\\"margin-left:5px;background-color:white\\"></span>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}' . '" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226f70656e4e657757696e646f772220747970653d22726164696f222064656661756c743d223122206c6162656c3d224f70656e204e65772057696e646f7722206465736372697074696f6e3d224f70656e2061206e65772077696e646f77207768656e20746865206c696e6b20697320636c69636b65642e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d227573654d54566973697452656469726563742220747970653d22726164696f222064656661756c743d223122206c6162656c3d2255736520696e7465726e616c20726564697265637422206465736372697074696f6e3d225573696e6720696e7465726e65742072656469726563742077696c6c206272696e672076697369746f7273207468726f75676820616e20696e7465726e616c2055524c206265666f7265207265646972656374696e67207468656d20746f207468652061637475616c20776562736974652e205468697320616c6c6f7773204d6f73657473205472656520746f206b65657020747261636b206f6620746865206869747320616e64206869646573207468652061637475616c792055524c2066726f6d2076697369746f722e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22746578742220747970653d2274657874222064656661756c743d2222206c6162656c3d224c696e6b205465787422206465736372697074696f6e3d22557365207468697320706172616d6574657220746f207370656369667920746865206c696e6b20746578742e204966206c65667420656d7074792c207468652066756c6c2055524c2077696c6c20626520646973706c6179656420617320746865206c696e6b277320746578742e22202f3e0a09093c706172616d206e616d653d226d617855726c4c656e6774682220747970653d2274657874222064656661756c743d22363022206c6162656c3d224d61782e2055524c204c656e67746822206465736372697074696f6e3d22456e74657220746865206d6178696d756d2055524c2773206c656e677468206265666f726520697420697320636c697070656422202f3e0a09093c706172616d206e616d653d22636c697070656453796d626f6c2220747970653d2274657874222064656661756c743d222e2e2e22206c6162656c3d22436c69707065642073796d626f6c22202f3e0a0a09093c706172616d206e616d653d2273686f77476f2220747970653d22726164696f222064656661756c743d223122206c6162656c3d2253686f7720476f20627574746f6e22206465736372697074696f6e3d225468697320476f20627574746f6e2077696c6c20626520617661696c61626c6520696e20746865206261636b2d656e642045646974204c697374696e67207061676520746f20616c6c6f772061646d696e206120666173742077617920746f206f70656e20746865206c697374696e67277320776562736974652e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d2273686f775370696465722220747970653d22726164696f222064656661756c743d223022206c6162656c3d2253686f772053706964657220627574746f6e22206465736372697074696f6e3d225768656e20656e61626c65642c20612053706964657220627574746f6e2077696c6c20626520617661696c61626c65206e65787420746f20746865207765627369746520696e707574206669656c6420696e206261636b2d656e642e205768656e2074686520627574746f6e20697320636c69636b65642c2069742077696c6c20636865636b20746865207765627369746520696e20746865206261636b67726f756e20616e6420706f70756c61746520746865206c697374696e672773204d455441204b65797320616e64204d455441204465736372697074696f6e206669656c642e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 1772 WHERE ft_id = 11 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update weblinknewwin field's params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226f70656e4e657757696e646f772220747970653d22726164696f222064656661756c743d223122206c6162656c3d224f70656e204e65772057696e646f7722206465736372697074696f6e3d224f70656e2061206e65772077696e646f77207768656e20746865206c696e6b20697320636c69636b65642e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22746578742220747970653d2274657874222064656661756c743d2222206c6162656c3d224c696e6b205465787422206465736372697074696f6e3d22557365207468697320706172616d6574657220746f207370656369667920746865206c696e6b20746578742e204966206c65667420656d7074792c207468652066756c6c2055524c2077696c6c20626520646973706c6179656420617320746865206c696e6b277320746578742e22202f3e0a09093c706172616d206e616d653d226d617855726c4c656e6774682220747970653d2274657874222064656661756c743d22363022206c6162656c3d224d61782e2055524c204c656e67746822206465736372697074696f6e3d22456e74657220746865206d6178696d756d2055524c2773206c656e677468206265666f726520697420697320636c697070656422202f3e0a09093c706172616d206e616d653d22636c697070656453796d626f6c2220747970653d2274657874222064656661756c743d222e2e2e22206c6162656c3d22436c69707065642073796d626f6c22202f3e0a09093c706172616d206e616d653d2273686f77476f2220747970653d22726164696f222064656661756c743d223022206c6162656c3d2253686f7720476f20627574746f6e22206465736372697074696f6e3d225468697320476f20627574746f6e2077696c6c20626520617661696c61626c6520696e20746865206261636b2d656e642045646974204c697374696e67207061676520746f20616c6c6f772061646d696e206120666173742077617920746f206f70656e20746865206c697374696e67277320776562736974652e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 982 WHERE ft_id = 23 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     updateVersion(2, 0, 2);
     $this->updated = true;
     return true;
 }
コード例 #8
0
ファイル: 2_1_1.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $mtconf;
     $database =& JFactory::getDBO();
     // Insert a hidden config to configure days to expire
     $database->setQuery('INSERT INTO `#__mt_config` (`varname`,`groupname`,`value`,`default`,`configcode`,`ordering`,`displayed`) VALUES (\'days_to_expire\', \'listing\', \'0\', \'0\', \'text\', \'6800\', \'0\')');
     $database->query();
     // Insert hidden configs to configure the number of rss items
     $database->setQuery('INSERT INTO `#__mt_config` (`varname`,`groupname`,`value`,`default`,`configcode`,`ordering`,`displayed`) VALUES (\'rss_new_limit\', \'rss\', \'40\', \'40\', \'text\', \'220\', \'0\'), (\'rss_updated_limit\', \'rss\', \'40\', \'40\', \'text\', \'240\', \'0\')');
     $database->query();
     // Insert hidden configs to make max & min search characters configurable
     $database->setQuery('INSERT INTO `#__mt_config` (`varname`,`groupname`,`value`,`default`,`configcode`,`ordering`,`displayed`) VALUES (\'limit_max_chars\', \'search\', \'20\', \'20\', \'text\', \'2160\', \'0\'), (\'limit_min_chars\', \'search\', \'3\', \'3\', \'text\', \'2170\', \'0\')');
     $database->query();
     $this->printStatus('Added new configurations.');
     // Rename htaccess.txt to .htaccess in attachments directory
     jimport('joomla.filesystem.file');
     if (!JFile::move(JPATH_SITE . $mtconf->get('relative_path_to_attachments') . 'htaccess.txt', JPATH_SITE . $mtconf->get('relative_path_to_attachments') . '.htaccess')) {
         $this->printStatus('Failed to rename ' . $mtconf->get('relative_path_to_attachments') . 'htaccess.txt. To fix this, rename htacess.txt to <strong>.htaccess</strong> at this location ' . JPATH_SITE . $mtconf->get('relative_path_to_attachments') . 'htaccess.txt. This is an important steps to protect your attachment from being downloaded by unauthorized users.', -1);
     }
     updateVersion(2, 1, 1);
     $this->updated = true;
     return true;
 }
コード例 #9
0
ファイル: 2_0_4.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     $database->setQuery('DELETE FROM #__mt_customfields WHERE field_type IN (\'coremetakey\',\'coremetadesc\') AND cf_id NOT IN (26,27) LIMIT 2');
     $database->query();
     $this->printStatus('Cleaned up of CORE META Keys and CORE META Desc fields.');
     $database->setQuery('DELETE FROM #__mt_config WHERE varname = \'fullmenu_tree_level\' LIMIT 1');
     $database->query();
     $this->printStatus('Removed fullmenu_tree_level config.');
     changeColumnType('links', 'link_rating', 'DECIMAL( 7, 6 )', 'UNSIGNED NOT NULL DEFAULT \'0.00\'');
     // Update date params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0d0a093c706172616d733e0d0a09093c706172616d206e616d653d227374617274596561722220747970653d2274657874222064656661756c743d2222206c6162656c3d225374617274207965617222206465736372697074696f6e3d22456e74657220746865207374617274696e672079656172206f72206561726c69657374207965617220617661696c61626c6520666f722073656c656374696f6e2e204966206c65667420656d7074792c2069742077696c6c2064656661756c7420746f2037302079656172732061676f2066726f6d207468652063757272656e7420796561722e22202f3e0d0a09093c706172616d206e616d653d22656e64596561722220747970653d2274657874222064656661756c743d2222206c6162656c3d22456e64207965617222206465736372697074696f6e3d22456e74657220746865206c61746573742079656172206f7220617661696c61626c6520666f722073656c656374696f6e2e204966206c65667420656d7074792c207468652063757272656e7420796561722077696c6c20626520757365642e22202f3e0d0a09093c706172616d206e616d653d2264617465466f726d61742220747970653d226c697374222064656661756c743d2222206c6162656c3d224461746520466f726d617422203e0d0a0909093c6f7074696f6e2076616c75653d22592d6d2d64223e323030372d30362d30313c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d226a2e6e2e59223e312e362e323030373c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d226420462059223e3031204a756e6520323030373c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d226a53205c6f5c6620462059223e317374206f66204a756e6520323030373c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d226a2f6e2f59223e312f362f323030373c2f6f7074696f6e3e0d0a0909093c6f7074696f6e2076616c75653d226e2f6a2f59223e362f312f323030373c2f6f7074696f6e3e0d0a09093c2f706172616d3e09090d0a093c2f706172616d733e0d0a3c2f6d6f73706172616d733e, filesize = 833 WHERE ft_id = 47 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update audioplayer params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226175746f53746172742220747970653d22726164696f222064656661756c743d223022206c6162656c3d224175746f20537461727422206465736372697074696f6e3d224175746f6d61746963616c6c79206f70656e2074686520706c6179657220616e6420737461727420706c6179696e672074686520747261636b2e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d22646973706c617966696c656e616d652220747970653d22726164696f222064656661756c743d223122206c6162656c3d22446973706c61792046696c656e616d6522206465736372697074696f6e3d22446973706c61792074686520617564696f27732066696c656e616d652062656c6f772074686520706c617965722e223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d226c6f6f702220747970653d22726164696f222064656661756c743d223022206c6162656c3d224c6f6f7022206465736372697074696f6e3d2254686520747261636b2077696c6c206265206c6f6f70656420696e646566696e6974656c79223e0a0909093c6f7074696f6e2076616c75653d2230223e4e6f3c2f6f7074696f6e3e0a0909093c6f7074696f6e2076616c75653d2231223e5965733c2f6f7074696f6e3e0a09093c2f706172616d3e0a09093c706172616d206e616d653d2274657874436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d225465787420636f6c6f757222202f3e0a09093c706172616d206e616d653d22736c69646572436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d22536c6964657220636f6c6f757222202f3e0a09093c706172616d206e616d653d226c6f61646572436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d224c6f6164657220636f6c6f757222202f3e0a09093c706172616d206e616d653d22747261636b436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d22547261636b20636f6c6f757222202f3e0a09093c706172616d206e616d653d22626f72646572436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d22426f7264657220636f6c6f757222202f3e0a09093c706172616d206e616d653d226261636b67726f756e64436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d224261636b67726f756e6420636f6c6f757222202f3e0a09093c706172616d206e616d653d226c6566744261636b67726f756e64436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d224c656674206261636b67726f756e6420636f6c6f757222202f3e0a09093c706172616d206e616d653d2272696768744261636b67726f756e64436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d225269676874206261636b67726f756e6420636f6c6f757222202f3e0a09093c706172616d206e616d653d2272696768744261636b67726f756e64486f766572436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d225269676874206261636b67726f756e6420636f6c6f75722028686f7665722922202f3e0a09093c706172616d206e616d653d226c65667449636f6e436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d224c6566742069636f6e20636f6c6f757222202f3e0a09093c706172616d206e616d653d22726967687449636f6e436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d2252696768742069636f6e20636f6c6f757222202f3e0a09093c706172616d206e616d653d22726967687449636f6e486f766572436f6c6f75722220747970653d2274657874222064656661756c743d2222206c6162656c3d2252696768742069636f6e20636f6c6f75722028686f7665722922202f3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, filesize = 1719 WHERE ft_id = 24 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update audioplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_audioplayer extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' . $this->getName() . \'.value,\\\'mp3\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . $this->getCaption() . \': Please select a mp3 file.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$id = $this->getId();\\r\\n		$params[\'text\'] = $this->getParam(\'textColour\');\\r\\n		$params[\'displayfilename\'] = $this->getParam(\'displayfilename\',1);\\r\\n		$params[\'slider\'] = $this->getParam(\'sliderColour\');\\r\\n		$params[\'loader\'] = $this->getParam(\'loaderColour\');\\r\\n		$params[\'track\'] = $this->getParam(\'trackColour\');\\r\\n		$params[\'border\'] = $this->getParam(\'borderColour\');\\r\\n		$params[\'bg\'] = $this->getParam(\'backgroundColour\');\\r\\n		$params[\'leftbg\'] = $this->getParam(\'leftBackgrounColour\');\\r\\n		$params[\'rightbg\'] = $this->getParam(\'rightBackgrounColour\');\\r\\n		$params[\'rightbghover\'] = $this->getParam(\'rightBackgroundHoverColour\');\\r\\n		$params[\'lefticon\'] = $this->getParam(\'leftIconColour\');\\r\\n		$params[\'righticon\'] = $this->getParam(\'rightIconColour\');\\r\\n		$params[\'righticonhover\'] = $this->getParam(\'rightIconHoverColour\');\\r\\n		\\r\\n		$html = \'\';\\r\\n		$html .= \'<script language=\\"JavaScript\\" src=\\"\' . $this->getFieldTypeAttachmentURL(\'audio-player.js\'). \'\\"></script>\';\\r\\n		$html .= \\"\\n\\" . \'<object type=\\"application/x-shockwave-flash\\" data=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\'). \'\\" id=\\"audioplayer\' . $id . \'\\" height=\\"24\\" width=\\"290\\">\';\\r\\n		$html .= \\"\\n\\" . \'<param name=\\"movie\\" value=\\"\' . $this->getDataAttachmentURL(). \'\\">\';\\r\\n		$html .= \\"\\n\\" . \'<param name=\\"FlashVars\\" value=\\"\';\\r\\n		$html .= \'playerID=\' . $id;\\r\\n		$html .= \'&amp;soundFile=\' . urlencode($this->getDataAttachmentURL());\\r\\n		foreach( $params AS $key => $value ) {\\r\\n			if(!empty($value)) {\\r\\n				$html .= \'&amp;\' . $key . \'=0x\' . $value;\\r\\n			}\\r\\n		}\\r\\n		$html .= \'\\">\';\\r\\n		$html .= \\"\\n\\" . \'<param name=\\"quality\\" value=\\"high\\">\';\\r\\n		$html .= \\"\\n\\" . \'<param name=\\"menu\\" value=\\"false\\">\';\\r\\n		$html .= \\"\\n\\" . \'<param name=\\"wmode\\" value=\\"transparent\\">\';\\r\\n		$html .= \\"\\n\\" . \'</object>\';\\r\\n		if($params[\'displayfilename\']) {\\r\\n			$html .= \\"\\n<br />\\";\\r\\n			$html .= \\"\\n\\" . \'<a href=\\"\' . $this->getDataAttachmentURL() . \'\\" target=\\"_blank\\">\';\\r\\n			$html .= $this->getValue();\\r\\n			$html .= \'</a>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}" WHERE field_type = "audioplayer" LIMIT 1');
     $database->query();
     updateVersion(2, 0, 4);
     $this->updated = true;
     return true;
 }
コード例 #10
0
ファイル: 2_0_6.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $database;
     // Added new internal config for customizable RSS's title separator
     $database->setQuery('INSERT INTO #__mt_config (`varname`, `groupname`, `value`, `default`, `configcode`, `ordering`, `displayed`) VALUES ("rss_title_separator", "core", " - ", " - ", "text", "", "0")');
     $database->query();
     $this->printStatus('Added new internal config for customizable RSS\'s title separator');
     // Update jQuery to 1.2.3
     $database->setQuery('UPDATE #__mt_config SET value = "/components/com_mtree/js/jquery-1.2.3.min.js" WHERE varname = "relative_path_to_js_library" LIMIT 1');
     $database->query();
     $this->printStatus('Updated jQuery to 1.2.3');
     // Added new internal config(cat_parse_plugin) to toggle parsing of plugin in category view (listcats)
     $database->setQuery('INSERT INTO #__mt_config (`varname` ,`groupname` ,`value` ,`default` ,`configcode` ,`ordering` ,`displayed` ) VALUES ("cat_parse_plugin", "category", "1", "1", "yesno", "3400", "0")');
     $database->query();
     $this->printStatus('Added new internal config(cat_parse_plugin) to toggle parsing of plugin in category view (listcats)');
     // Update audioplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_audioplayer extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' . $this->getName() . \'.value,\\\\\'mp3\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . $this->getCaption() . \': Please select a mp3 file.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$id = $this->getId();\\r\\n		$params[\'text\'] = $this->getParam(\'textColour\');\\r\\n		$params[\'displayfilename\'] = $this->getParam(\'displayfilename\',1);\\r\\n		$params[\'slider\'] = $this->getParam(\'sliderColour\');\\r\\n		$params[\'loader\'] = $this->getParam(\'loaderColour\');\\r\\n		$params[\'track\'] = $this->getParam(\'trackColour\');\\r\\n		$params[\'border\'] = $this->getParam(\'borderColour\');\\r\\n		$params[\'bg\'] = $this->getParam(\'backgroundColour\');\\r\\n		$params[\'leftbg\'] = $this->getParam(\'leftBackgrounColour\');\\r\\n		$params[\'rightbg\'] = $this->getParam(\'rightBackgrounColour\');\\r\\n		$params[\'rightbghover\'] = $this->getParam(\'rightBackgroundHoverColour\');\\r\\n		$params[\'lefticon\'] = $this->getParam(\'leftIconColour\');\\r\\n		$params[\'righticon\'] = $this->getParam(\'rightIconColour\');\\r\\n		$params[\'righticonhover\'] = $this->getParam(\'rightIconHoverColour\');\\r\\n		\\r\\n		$html = \'\';\\r\\n		$html .= \'<script language=\\"JavaScript\\" src=\\"\' . $this->getFieldTypeAttachmentURL(\'audio-player.js\'). \'\\"></script>\';\\r\\n		$html .= \\"\\\\n\\" . \'<object type=\\"application/x-shockwave-flash\\" data=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\'). \'\\" id=\\"audioplayer\' . $id . \'\\" height=\\"24\\" width=\\"290\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"movie\\" value=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\') . \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"FlashVars\\" value=\\"\';\\r\\n		$html .= \'playerID=\' . $id;\\r\\n		$html .= \'&amp;soundFile=\' . urlencode($this->getDataAttachmentURL());\\r\\n		foreach( $params AS $key => $value ) {\\r\\n			if(!empty($value)) {\\r\\n				$html .= \'&amp;\' . $key . \'=0x\' . $value;\\r\\n			}\\r\\n		}\\r\\n		$html .= \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"quality\\" value=\\"high\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"menu\\" value=\\"false\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"wmode\\" value=\\"transparent\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'</object>\';\\r\\n		if($params[\'displayfilename\']) {\\r\\n			$html .= \\"\\\\n<br />\\";\\r\\n			$html .= \\"\\\\n\\" . \'<a href=\\"\' . $this->getDataAttachmentURL() . \'\\" target=\\"_blank\\">\';\\r\\n			$html .= $this->getValue();\\r\\n			$html .= \'</a>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "audioplayer" LIMIT 1');
     $database->query();
     // Update audioplayer version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "24" LIMIT 1');
     $database->query();
     $this->printStatus('Updated audioplayer field type to version 2.');
     // Update corecreated class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corecreated extends mFieldType_date {\\r\\n	var $name = \'link_created\';\\r\\n	var $numOfInputFields = 0;\\r\\n}"  WHERE field_type = "corecreated" LIMIT 1');
     $database->query();
     // Update corecreated version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "22" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corecreated field type to version 2.');
     // Update corefeatured class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corefeatured extends mFieldType {\\r\\n	var $name = \'link_featured\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput() {\\r\\n\\r\\n		$featured = $this->getValue();\\r\\n		$html = \'\';\\r\\n		if($featured) {\\r\\n			$html .= $_MT_LANG->YES;\\r\\n		} else {\\r\\n			$html .= $_MT_LANG->NO;\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n\\r\\n		$html = \'<select name=\\"\' . $this->getSearchFieldName(1) . \'\\" class=\\"inputbox text_area\\" size=\\"1\\">\';\\r\\n		$html .= \'<option value=\\"-1\\" selected=\\"selected\\">\' . $_MT_LANG->ANY . \'</option>\';\\r\\n		$html .= \'<option value=\\"1\\">\' . $_MT_LANG->FEATURED_ONLY . \'</option>\';\\r\\n		$html .= \'<option value=\\"0\\">\' . $_MT_LANG->NON_FEATURED_ONLY . \'</option>\';\\r\\n		$html .= \'</select>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getWhereCondition() {\\r\\n		$args = func_get_args();\\r\\n\\r\\n		$fieldname = $this->getName();\\r\\n		\\r\\n		if(  is_numeric($args[0]) ) {\\r\\n			switch($args[0]) {\\r\\n				case -1:\\r\\n					return null;\\r\\n					break;\\r\\n				case 1:\\r\\n					return $fieldname . \' = 1\';\\r\\n					break;\\r\\n				case 0:\\r\\n				return $fieldname . \' = 0\';\\r\\n					break;\\r\\n			}\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "corefeatured" LIMIT 1');
     $database->query();
     // Update corefeatured version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "14" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corefeatured field type to version 2.');
     // Update coremodified class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coremodified extends mFieldType_date {\\r\\n	var $name = \'link_modified\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput() {\\r\\n\\r\\n		$value = $this->getValue();\\r\\n		if($value == \'0000-00-00 00:00:00\') {\\r\\n			return $_MT_LANG->NEVER;\\r\\n		} else {\\r\\n			return $value;\\r\\n		}\\r\\n	}\\r\\n}\\r\\n"  WHERE field_type = "coremodified" LIMIT 1');
     $database->query();
     // Update coremodified version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "15" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coremodified field type to version 2.');
     // Update corename class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corename extends mFieldType {\\r\\n	var $name = \'link_name\';\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'maxSummaryChars\'] = intval($this->getParam(\'maxSummaryChars\',55));\\r\\n		$params[\'maxDetailsChars\'] = intval($this->getParam(\'maxDetailsChars\',0));\\r\\n		$value = $this->getValue();\\r\\n		$output = \'\';\\r\\n		if($view == 1 AND $params[\'maxDetailsChars\'] > 0 AND $this->strlen_utf8($value) > $params[\'maxDetailsChars\']) {\\r\\n			$output .= $this->html_cutstr($value,$params[\'maxDetailsChars\']);\\r\\n			$output .= \'...\';\\r\\n		} elseif($view == 2 AND $params[\'maxSummaryChars\'] > 0 AND $this->strlen_utf8($value) > $params[\'maxSummaryChars\']) {\\r\\n			$output .= $this->html_cutstr($value,$params[\'maxSummaryChars\']);\\r\\n			$output .= \'...\';\\r\\n		} else {\\r\\n			$output = $value;\\r\\n		}\\r\\n		return $output;\\r\\n	}\\r\\n}"  WHERE field_type = "corename" LIMIT 1');
     $database->query();
     // Update corename version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "20" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corename field type to version 2.');
     // Update coreprice class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coreprice extends mFieldType_number {\\r\\n	var $name = \'price\';\\r\\n	function getOutput() {\\r\\n		$price = $this->getValue();\\r\\n		$displayFree = $this->getParam(\'displayFree\',1);\\r\\n		if($price == 0 && $displayFree == 1) {\\r\\n\\r\\n			return $_MT_LANG->FREE;\\r\\n		} else {\\r\\n			return $price;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "coreprice" LIMIT 1');
     $database->query();
     // Update coreprice version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "2" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coreprice field type to version 2.');
     // Update corerating class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corerating extends mFieldType_number {\\r\\n	var $name = \'link_rating\';\\r\\n	var $numOfSearchFields = 2;\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput($view=1) {\\r\\n		return round($this->getValue(),2);\\r\\n	}\\r\\n	function getJSValidation() {\\r\\n		return null;\\r\\n	}\\r\\n}"  WHERE field_type = "corerating" LIMIT 1');
     $database->query();
     // Update corerating version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "1" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corerating field type to version 2.');
     // Update corevisited class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corevisited extends mFieldType_number {\\r\\n	var $name = \'link_visited\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function getJSValidation() {\\r\\n		return null;\\r\\n	}\\r\\n}\\r\\n"  WHERE field_type = "corevisited" LIMIT 1');
     $database->query();
     // Update corevisited version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "16" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corevisited field type to version 2.');
     // Update corewebsite class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n\\r\\n	function getOutput() {\\r\\n		$maxUrlLength = $this->getParam(\'maxUrlLength\',60);\\r\\n		$text = $this->getParam(\'text\',\'\');\\r\\n		$openNewWindow = $this->getParam(\'openNewWindow\',1);\\r\\n		$useMTVisitRedirect = $this->getParam(\'useMTVisitRedirect\',1);\\r\\n	\\r\\n		$html = \'\';\\r\\n		$html .= \'<a href=\\"\';\\r\\n		if($useMTVisitRedirect) {\\r\\n			global $Itemid;\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=visit&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid);\\r\\n		} else {\\r\\n			$html .= $this->getValue();\\r\\n		}\\r\\n		$html .= \'\\"\';\\r\\n		if( $openNewWindow == 1 ) {\\r\\n			$html .= \' target=\\"_blank\\"\';\\r\\n		}\\r\\n		$html .= \'>\';\\r\\n		if(!empty($text)) {\\r\\n			$html .= $text;\\r\\n		} else {\\r\\n			if( empty($maxUrlLength) || $maxUrlLength == 0 ) {\\r\\n				$html .= $this->getValue();\\r\\n			} else {\\r\\n				$html .= substr($this->getValue(),0,$maxUrlLength);\\r\\n				if( strlen($this->getValue()) > $maxUrlLength ) {\\r\\n					$html .= $this->getParam(\'clippedSymbol\');\\r\\n				}\\r\\n			}\\r\\n		}\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n\\r\\n		$showGo = $this->getParam(\'showGo\',1);\\r\\n		$showSpider = $this->getParam(\'showSpider\',0);\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area inputbox\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . $this->getSize() . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		if($showGo && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript:window.open(\\"index3.php?option=com_mtree&task=openurl&url=\\"+escape(document.getElementById(\\"website\\").value))\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->GO . \'\\" />\';\\r\\n		}\\r\\n		\\r\\n		if($showSpider && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript: \';\\r\\n			$html .= \'jQuery(\\"#spiderwebsite\\").html(\\"\' . $_MT_LANG->SPIDER_PROGRESS . \'\\");\';\\r\\n			$html .= \'jQuery.ajax({\\r\\n			  type: \\"POST\\",\\r\\n			  url: mosConfig_live_site+\\"/administrator/index2.php\\",\\r\\n			  data: \\"option=com_mtree&task=ajax&task2=spiderurl&url=\\"+document.getElementById(\\"website\\").value+\\"&no_html=1\\",\\r\\n			  dataType: \\"script\\"\\r\\n			});\';\\r\\n			$html .= \'\\\\\'\';\\r\\n			$html .= \'value=\\"\' . $_MT_LANG->SPIDER . \'\\" />\';\\r\\n			$html .= \'<span id=\\"spider\' . $this->getInputFieldName(1) . \'\\" style=\\"margin-left:5px;background-color:white\\"></span>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "corewebsite" LIMIT 1');
     $database->query();
     // Update corewebsite version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corewebsite field type to version 2.');
     // Changing date field type name from 'date' to 'mdate'
     $database->setQuery('UPDATE jos_mt_customfields SET field_type = "mdate" WHERE field_type = "date"');
     $database->query();
     $database->setQuery('UPDATE jos_mt_fieldtypes SET field_type = "mdate" WHERE field_type = "date"');
     $database->query();
     // Update mdate class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_mDate extends mFieldType_date {\\r\\n}"  WHERE field_type = "mdate" LIMIT 1');
     $database->query();
     // Update mdate version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "1.00" WHERE ft_id = "47" LIMIT 1');
     $database->query();
     $this->printStatus('Updated mdate field type to version 2.');
     // Update coreprice params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D22646973706C6179467265652220747970653D22726164696F222064656661756C743D223122206C6162656C3D22446973706C61792046726565207768656E207072696365206973203022206465736372697074696F6E3D2253657474696E67207468697320746F205965732077696C6C20646973706C61792074686520746578742046726565207768656E2074686520707269636520697320302E30302E223E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A09093C2F706172616D3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 313 WHERE ft_id = 2 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     updateVersion(2, 0, 6);
     $this->updated = true;
     return true;
 }
コード例 #11
0
ファイル: jl_install.php プロジェクト: hfmprs/JoomLeague
    $praefix = 'COM_JOOMLEAGUE_ST_';
    foreach ($strings as $key => $value) {
        // Add all Sport-types e.g. Soccer to #__joomleague_sports_type
        $pos = strpos($key, $praefix);
        if ($pos !== false) {
            $name = strtolower(substr($key, strlen($praefix)));
            $tblSportsType = JTable::getInstance("SportsType", "Table");
            //fix for existing items
            $tblSportsType->load(array("name" => $key));
            $tblSportsType->name = $key;
            $tblSportsType->icon = JPATH::clean('images/com_joomleague/database/sport_types/' . $name . '.png');
            if (!$tblSportsType->store()) {
                //echo($tblSportsType->getError());
                $status = 2;
            }
            JFolder::create(JPATH::clean(JPATH_ROOT . '/images/com_joomleague/database/events/' . $name));
        }
    }
    return $status;
}
//_checkVersionTable();
$versionData = getVersion();
$major = $versionData->major;
$minor = $versionData->minor;
$build = $versionData->build;
$revision = $versionData->revision;
$version = sprintf('v%1$s.%2$s.%3$s.%4$s', $major, $minor, $build, $revision);
echo PrintStepResult(addGhostPlayer());
echo PrintStepResult(addSportsType());
echo PrintStepResult(updateVersion($versionData));
コード例 #12
0
                $params = array();
                $params["width"] = $imageSize[0];
                if (strpos($thumb, "crop") != false) {
                    $params['crop'] = 1;
                    if (strpos($thumb, "--") == false) {
                        $params["height"] = $imageSize[1];
                    }
                }
                $params[WatermarkSupport::FORCE_TRANSFORM] = true;
                $params[WatermarkSupport::ADD_WATERMARK] = true;
                if ($removeWatermarks == true) {
                    $params[WatermarkSupport::ADD_WATERMARK] = false;
                }
                if ($dryRun == true) {
                    continue;
                }
                $result = $imageFile->getHandler()->doTransform($imageFile, $thumbPath, $thumbUrl, $params, $flags);
                if (get_class($result) == MediaTransformError) {
                    echo "there was an error processing this file \n";
                    echo $result->toText();
                    complete($time, $processedCount);
                }
            }
        }
    }
    if ($dryRun == true) {
        continue;
    }
    updateVersion($version, $articleId, $fname);
}
complete($time, $processedCount);
コード例 #13
0
ファイル: update.php プロジェクト: rodneyshupe/mediafrontpage
<?php

if (isset($_GET['update']) && $_GET['update']) {
    updateVersion();
}
function updateVersion()
{
    require_once 'lib/class.settings.php';
    require_once 'lib/class.github.php';
    $github = new GitHub('gugahoi', 'mediafrontpage');
    $commit = $github->getCommits();
    $commitNo = $commit['0']['sha'];
    $config = new ConfigMagik('config.ini', true, true);
    try {
        $config->set('version', $commitNo, 'ADVANCED');
    } catch (Exception $e) {
        echo false;
        exit;
    }
    echo true;
}
コード例 #14
0
ファイル: updateDB.php プロジェクト: a349944418/kaopu
function updateDB()
{
    DBchang();
    updateVersion();
}
コード例 #15
0
ファイル: 2_1_0.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     global $mtconf;
     $database =& JFactory::getDBO();
     $do = JRequest::getCmd('do');
     switch ($do) {
         default:
             // Insert att_id column, in preparation to move attachments to filesystem.
             $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` DROP PRIMARY KEY");
             $database->query();
             $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` ADD `raw_filename` VARCHAR( 255 ) NOT NULL AFTER `cf_id` ;");
             $database->query();
             $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` ADD `att_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;");
             $database->query();
             // Check to make sure the new attachments directory is writable. Otherwise abort upgrade.
             if (!$this->attachments_is_writable() && $this->get_total_attachments() > 0) {
                 printRow('Please make sure this ' . JPATH_SITE . '/components/com_mtree/attachments/' . ' directory is writable. This upgrade has been aborted. Refresh this page once you have made the directory writable.', 0);
                 $this->updated = false;
                 return true;
             }
         case 'move_attachments':
             $this->move_attachments();
             if ($this->hasMovableAttachments()) {
                 $this->updated = false;
                 $this->continue_url = JRoute::_("index.php?option=com_mtree&task=upgrade&do=move_attachments");
                 $this->continue_message = 'Processing upgrade: Moving ' . $this->hasMovableAttachments() . ' attachments...';
                 return false;
             }
             break;
         case 'continue':
             break;
     }
     // Drop filedata column in #__mt_cfvalues_att
     $database->setQuery('ALTER TABLE #__mt_cfvalues_att DROP `filedata`');
     $database->query();
     // Add columns for aliases
     $database->setQuery("ALTER TABLE `#__mt_cats` ADD `alias` VARCHAR( 255 ) NOT NULL AFTER `cat_name` ;");
     $database->query();
     // Add columns for titles
     $database->setQuery("ALTER TABLE `#__mt_cats` ADD `title` VARCHAR( 255 ) NOT NULL AFTER `alias` ;");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cats` ADD INDEX `alias` ( `alias` )");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_links` ADD `alias` VARCHAR( 255 ) NOT NULL AFTER `link_name` ;");
     $database->query();
     $aliased = $this->populate_category_alias();
     $this->printStatus('Created default alias for ' . $aliased . ' categories.');
     $aliased = $this->populate_listing_alias();
     $this->printStatus('Created default alias for ' . $aliased . ' listings.');
     // Updating database schema
     $database->setQuery("UPDATE `#__mt_config` SET `varname` = 'fe_num_of_favourite' WHERE varname = 'fe_num_of_mostfavoured' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `varname` = 'fe_num_of_new' WHERE varname = 'fe_num_of_newlisting' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `varname` = 'fe_num_of_popular' WHERE varname = 'fe_num_of_popularlisting' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `varname` = 'fe_num_of_updated' WHERE varname = 'fe_num_of_recentlyupdated' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `varname` = 'fe_total_new' WHERE `varname` = 'fe_total_newlisting' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `configcode` = 'text' WHERE `varname` = 'template' LIMIT 1 ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_config` SET `ordering` = '4175' WHERE `varname` = 'show_favourite' LIMIT 1 ;");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_archived_reviews` ADD `send_email` TINYINT NOT NULL , ADD `email_message` MEDIUMTEXT NOT NULL ;");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_reviews` DROP INDEX `link_id` , ADD INDEX `link_id` ( `link_id` , `rev_approved` , `rev_date` ) ;");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_favourites` ADD INDEX `link_id` ( `link_id` ); ");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_reviews` ADD INDEX `user_id` ( `user_id` , `rev_approved` , `rev_date` )");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` ADD INDEX `primary2` ( `link_id` , `cf_id` )");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cfvalues` ADD `counter` INT NOT NULL DEFAULT '0';");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_links` ADD `lat` FLOAT NOT NULL COMMENT 'Latitude',\nADD `lng` FLOAT NOT NULL COMMENT 'Longitude',\nADD `zoom` TINYINT UNSIGNED NOT NULL COMMENT 'Map''s zoom level';");
     $database->query();
     // Update #__mt_archived_log character set & collation
     $database->setQuery("ALTER TABLE `#__mt_archived_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_archived_log` CHANGE `log_ip` `log_ip` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `log_type` `log_type` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_archived_reviews character set & collation
     $database->setQuery("ALTER TABLE `#__mt_archived_reviews` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_archived_reviews` CHANGE `guest_name` `guest_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `rev_title` `rev_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `rev_text` `rev_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `admin_note` `admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ownersreply_text` `ownersreply_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ownersreply_admin_note` `ownersreply_admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_archived_users character set & collation
     $database->setQuery("ALTER TABLE `#__mt_archived_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_archived_users` CHANGE `name` `name` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `username` `username` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `email` `email` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `password` `password` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `usertype` `usertype` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `activation` `activation` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `params` `params` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_links character set & collation
     $database->setQuery("ALTER TABLE `#__mt_links` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_links` CHANGE `link_name` `link_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `link_desc` `link_desc` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `link_template` `link_template` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `attribs` `attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `metakey` `metakey` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `metadesc` `metadesc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `internal_notes` `internal_notes` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `address` `address` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `city` `city` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `state` `state` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `country` `country` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `postcode` `postcode` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `telephone` `telephone` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `fax` `fax` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `email` `email` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `website` `website` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;");
     $database->query();
     // Update #__mt_cats character set & collation
     $database->setQuery("ALTER TABLE `#__mt_cats` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cats` CHANGE `cat_name` `cat_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `cat_desc` `cat_desc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `cat_image` `cat_image` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\tCHANGE `cat_template` `cat_template` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `metakey` `metakey` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `metadesc` `metadesc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_cfvalues character set & collation
     $database->setQuery("ALTER TABLE `#__mt_cfvalues` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cfvalues` CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_cfvalues_att character set & collation
     $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_cfvalues_att` CHANGE `filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `extension` `extension` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_cl character set & collation
     $database->setQuery("ALTER TABLE `#__mt_cl` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     // Update #__mt_claims character set & collation
     $database->setQuery("ALTER TABLE `#__mt_claims` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_claims` CHANGE `comment` `comment` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `admin_note` `admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_clone_owners character set & collation
     $database->setQuery("ALTER TABLE `#__mt_clone_owners` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     // Update #__mt_configgroup character set & collation
     $database->setQuery("ALTER TABLE `#__mt_configgroup` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_configgroup` CHANGE `groupname` `groupname` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_customfields character set & collation
     $database->setQuery("ALTER TABLE `#__mt_customfields` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_customfields` CHANGE `field_type` `field_type` VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `caption` `caption` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `default_value` `default_value` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `field_elements` `field_elements` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `prefix_text_mod` `prefix_text_mod` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `suffix_text_mod` `suffix_text_mod` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `prefix_text_display` `prefix_text_display` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `suffix_text_display` `suffix_text_display` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `search_caption` `search_caption` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `params` `params` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_favourites character set & collation
     $database->setQuery("ALTER TABLE `#__mt_favourites` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     // Update #__mt_fieldtypes character set & collation
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes` CHANGE `field_type` `field_type` VARCHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ft_caption` `ft_caption` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ft_class` `ft_class` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_fieldtypes_att character set & collation
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes_att` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes_att` CHANGE `filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `extension` `extension` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_fieldtypes_info character set & collation
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes_info` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes_info` CHANGE `ft_version` `ft_version` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ft_website` `ft_website` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ft_desc` `ft_desc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_images character set & collation
     $database->setQuery("ALTER TABLE `#__mt_images` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_images` CHANGE `filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_linkcheck character set & collation
     $database->setQuery("ALTER TABLE `#__mt_linkcheck` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_linkcheck` CHANGE `field` `field` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `link_name` `link_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `domain` `domain` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `path` `path` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_log character set & collation
     $database->setQuery("ALTER TABLE `#__mt_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_log` CHANGE `log_ip` `log_ip` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `log_type` `log_type` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_relcats character set & collation
     $database->setQuery("ALTER TABLE `#__mt_relcats` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     // Update #__mt_reports character set & collation
     $database->setQuery("ALTER TABLE `#__mt_reports` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_reports` CHANGE `guest_name` `guest_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `subject` `subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `comment` `comment` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `admin_note` `admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_reviews character set & collation
     $database->setQuery("ALTER TABLE `#__mt_reviews` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_reviews` CHANGE `guest_name` `guest_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `rev_title` `rev_title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `rev_text` `rev_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `admin_note` `admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ownersreply_text` `ownersreply_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `ownersreply_admin_note` `ownersreply_admin_note` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `email_message` `email_message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_searchlog character set & collation
     $database->setQuery("ALTER TABLE `#__mt_searchlog` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_searchlog` CHANGE `search_text` `search_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_templates character set & collation
     $database->setQuery("ALTER TABLE `#__mt_templates` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_templates` CHANGE `tem_name` `tem_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,\n\t\tCHANGE `params` `params` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Update #__mt_config character set & collation
     $database->setQuery("ALTER TABLE `#__mt_config` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
     $database->query();
     $database->setQuery("ALTER TABLE `#__mt_config` CHANGE `varname` `varname` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `groupname` `groupname` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `default` `default` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `configcode` `configcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");
     $database->query();
     // Add tag_search coloum to search table
     $database->setQuery("ALTER TABLE `#__mt_customfields` ADD `tag_search` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `simple_search` ;");
     $database->query();
     // Add Tag custom field
     $database->setQuery("INSERT INTO `#__mt_customfields` VALUES ('', 'mtags', 'Tags', '', 40, '', '', '', '', '', 0, 25, 0, 0, 1, 0, 0, 0, 1, 1, 1, '', '', 0);");
     $database->query();
     // Add taggable column to fieldtype table
     $database->setQuery("ALTER TABLE `#__mt_fieldtypes` ADD `taggable` TINYINT( 3 ) NOT NULL DEFAULT '0' AFTER `use_columns` ;");
     $database->query();
     // Set Country, State & City field type to taggable
     $database->setQuery("UPDATE `#__mt_fieldtypes` SET `taggable` = '1' WHERE `ft_id` IN (4,5,6) ;");
     $database->query();
     $database->setQuery("UPDATE `#__mt_customfields` SET `tag_search` = '1' WHERE `field_type` IN ('corecity','corestate','corecountry','coremetakey') ;");
     $database->query();
     // Set coremetakey to taggable
     $database->setQuery("UPDATE `#__mt_fieldtypes` SET `taggable` = '1' WHERE `field_type` IN ('coremetakey');");
     $database->query();
     // Add Tag fieldtype custom field
     $database->setQuery("INSERT INTO `#__mt_fieldtypes` VALUES ('', 'mtags', 'Tags', 'class mFieldType_mTags extends mFieldType_tags {\r\n\r\n}', 0, 1, 0, 1, 0);");
     $database->query();
     $ft_id_mtags = $database->insertid();
     // Add mtags params.xml
     $database->setQuery("INSERT INTO `#__mt_fieldtypes_att` VALUES ('', " . $ft_id_mtags . ", 'params.xml', 0x3c6d6f73706172616d7320747970653d226d6f64756c65223e0a093c706172616d733e0a09093c706172616d206e616d653d226d617843686172732220747970653d2274657874222064656661756c743d22383022206c6162656c3d224d61782e206368617261637465727322206465736372697074696f6e3d22546865206d6178696d756d206e756d626572206f66206368617261637465727320616c6c6f77656420696e2074686973206669656c642e222f3e0a093c2f706172616d733e0a3c2f6d6f73706172616d733e, 205, 'text/xml', 1);");
     $database->query();
     // Updating MT's configs
     $database->setQuery("INSERT INTO `#__mt_configgroup` (`groupname` ,`ordering` ,`displayed` )VALUES ('sef', '685', '1');");
     $database->query();
     $database->setQuery("INSERT INTO `#__mt_configgroup` (`groupname` ,`ordering` ,`displayed` )VALUES ('email', '999', '0');");
     $database->query();
     $database->setQuery("INSERT INTO `#__mt_config` (`varname` ,`groupname` ,`value` ,`default` ,`configcode` ,`ordering` ,`displayed` )\n\t\tVALUES ('note_map', 'feature', '', '', 'note', '3925', '1'), ('note_other_features', 'feature', '', '', 'note', '4170', '1'), ('gmaps_api_key', 'feature', '', '', 'text', '3955', '1'), ('map_default_lat', 'feature', '12.554563528593656', '12.554563528593656', 'text', '3985', '0'), ('map_default_lng', 'feature', '18.984375', '18.984375', 'text', '3986', '0'),('map_default_zoom', 'feature', '1', '1', 'text', '3987', '0'), \n\t\t('map_control', 'feature', 'GSmallMapControl,GMapTypeControl', 'GSmallMapControl,GMapTypeControl', 'text', '3988', '0'),  ('notifyowner_review_added', 'notify', '1', '1', 'yesno', '9900', '1'),\n\t\t('load_css', 'core', '1', '1', 'yesno', '0', '0'),\n\t\t('small_image_click_target_size', 'admin', '', 'o', 'text', '13000', '0'),\n\t\t('rss_secret_token', 'rss', '', '', 'text', '', '0'),\n\t\t('show_category_rss', 'rss', '1', '1', 'yesno', '', '1'),\n\t\t('log_visit', 'feature', '1', '1', 'yesno', '', '0'),\n\t\t('banned_email', 'email', '', '', 'text', '', '0'),\n\t\t('banned_text', 'email', '', '', 'text', '', '0'),\n\t\t('banned_subject', 'email', '', '', 'text', '', '0'),\n\t\t('default_search_condition', 'search', '2', '2', 'text', '', '0'),\n\t\t('reset_created_date_upon_approval', 'core', '1', '1', 'yesno', '', '0'),\n\t\t('fe_total_updated', 'listing', '60', '60', 'text', '6050', '0'),\n\t\t('fe_total_popular', 'listing', '60', '60', 'text', '5750', '0'),\n\t\t('fe_total_favourite', 'listing', '60', '60', 'text', '6150', '0'),\n\t\t('fe_total_mostrated', 'listing', '60', '60', 'text', '6350', '0'),\n\t\t('fe_total_toprated', 'listing', '60', '60', 'text', '6450', '0'),\n\t\t('fe_total_mostreview', 'listing', '60', '60', 'text', '6550', '0'),\n\t\t('relative_path_to_attachments', 'core', '/components/com_mtree/attachments/', '/components/com_mtree/attachments/', 'text', '', '0'),\n\t\t ('unpublished_message_cfid', 'listing', '0', '0', 'text', '6600', '0'),\n\t\t ('cache_registered_viewlink', 'main', '0', '0', 'yesno', '0', '0'),\n\t\t ('display_pending_approval_listings_to_owners', 'listing', '0', '0', 'yesno', '4000', '0'),\n\t\t('sef_link_slug_type', 'sef', '1', '1', 'sef_link_slug_type', '100', '1'),\n\t\t('sef_details', 'sef', 'details', 'details', 'text', '175', '0'),\n\t\t('sef_image', 'sef', 'image', 'image', 'text', '200', '1'),\n\t\t('sef_gallery', 'sef', 'gallery', 'gallery', 'text', '300', '1'),\n\t\t('sef_review', 'sef', 'review', 'review', 'text', '400', '1'),\n\t\t('sef_replyreview', 'sef', 'replyreview', 'replyreview', 'text', '500', '1'),\n\t\t('sef_reportreview', 'sef', 'reportreview', 'reportreview', 'text', '600', '1'),\n\t\t('sef_recommend', 'sef', 'recommend', 'recommend', 'text', '800', '1'),\n\t\t('sef_print', 'sef', 'print', 'print', 'text', '850', '1'),\n\t\t('sef_contact', 'sef', 'contact', 'contact', 'text', '900', '1'),\n\t\t('sef_report', 'sef', 'report', 'report', 'text', '1000', '1'),\n\t\t('sef_claim', 'sef', 'claim', 'claim', 'text', '1100', '1'),\n\t\t('sef_visit', 'sef', 'visit', 'visit', 'text', '1200', '1'),\n\t\t('sef_category_page', 'sef', 'page', 'page', 'text', '1300', '1'),\n\t\t('sef_delete', 'sef', 'delete', 'delete', 'text', '1400', '1'),\n\t\t('sef_reviews_page', 'sef', 'reviews', 'reviews', 'text', '1500', '1'),\n\t\t('sef_addlisting', 'sef', 'add', 'add', 'text', '1600', '1'),\n\t\t('sef_editlisting', 'sef', 'edit', 'edit', 'text', '1650', '1'),\n\t\t('sef_addcategory', 'sef', 'add-category', 'add-category', 'text', '1700', '1'),\n\t\t('sef_mypage', 'sef', 'my-page', 'my-page', 'text', '1800', '1'),\n\t\t('sef_new', 'sef', 'new', 'new', 'text', '1900', '1'),\n\t\t('sef_updated', 'sef', 'updated', 'updated', 'text', '2000', '1'),\n\t\t('sef_favourite', 'sef', 'most-favoured', 'most-favoured', 'text', '2100', '1'),\n\t\t('sef_featured', 'sef', 'featured', 'featured', 'text', '2200', '1'),\n\t\t('sef_popular', 'sef', 'popular', 'popular', 'text', '2300', '1'),\n\t\t('sef_mostrated', 'sef', 'most-rated', 'most-rated', 'text', '2400', '1'),\n\t\t('sef_toprated', 'sef', 'top-rated', 'top-rated', 'text', '2500', '1'),\n\t\t('sef_mostreview', 'sef', 'most-reviewed', 'most-reviewed', 'text', '2600', '1'),\n\t\t('sef_listalpha', 'sef', 'list-alpha', 'list-alpha', 'text', '2700', '1'),\n\t\t('sef_owner', 'sef', 'owner', 'owner', 'text', '2800', '1'),\n\t\t('sef_favourites', 'sef', 'favourites', 'favourites', 'text', '2900', '1'),\n\t\t('sef_reviews', 'sef', 'reviews', 'reviews', 'text', '3000', '1'),\n\t\t('sef_searchby', 'sef', 'search-by', 'search-by', 'text', '3050', '1'),\n\t\t('sef_search', 'sef', 'search', 'search', 'text', '3100', '1'),\n\t\t('sef_advsearch', 'sef', 'advanced-search', 'advanced-search', 'text', '3200', '1'),\n\t\t('sef_advsearch2', 'sef', 'advanced-search-results', 'advanced-search-results', 'text', '3300', '1'),\n\t\t('sef_rss', 'sef', 'rss', 'rss', 'text', '3400', '1'),\n\t\t('sef_rss_new', 'sef', 'new', 'new', 'text', '3500', '1'),\n\t\t('sef_rss_updated', 'sef', 'updated', 'updated', 'text', '3600', '1'),\n\t\t('sef_space', 'sef', '-', '-', 'text', '3700', '1'),\n\t\t('use_map', 'feature', '1', '1', 'yesno', '3950', '1'),\n\t\t('map_default_country', 'feature', '', '', 'text', '3960', '1'),\n\t\t('map_default_state', 'feature', '', '', 'text', '3970', '1'),\n\t\t('map_default_city', 'feature', '', '', 'text', '3980', '1'),\n\t\t('note_sef_translations', 'sef', '', '', 'note', '150', '1'),\n\t\t('show_image_rss', 'rss', '1', '1', 'yesno', '250', '0');");
     $database->query();
     $database->setQuery("DELETE FROM `#__mt_config` WHERE `varname` IN ('language','relative_path_to_attachment_php','fulltext_search') LIMIT 3;");
     $database->query();
     // Update corecity class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corecity extends mFieldType {\\r\\n	var $name = \'city\';\\r\\n}"  WHERE field_type = "corecity" LIMIT 1');
     $database->query();
     // Update corecountry class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corecountry extends mFieldType {\\r\\n	var $name = \'country\';\\r\\n}"  WHERE field_type = "corecountry" LIMIT 1');
     $database->query();
     // Update corestate class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corestate extends mFieldType {\\r\\n	var $name = \'state\';\\r\\n}"  WHERE field_type = "corestate" LIMIT 1');
     $database->query();
     // Update digg class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldtype_digg extends mFieldType { \\r\\n    var $numOfSearchFields = 0; \\r\\n    var $numOfInputFields = 0; \\r\\n\\r\\n    function getOutput($view=1) { \\r\\n        global $mtconf, $Itemid; \\r\\n        $html = \'\'; \\r\\n        $html .= \'<script type=\\"text/javascript\\">\'; \\r\\n        $html .= \'digg_url=\\\\\'\'; \\r\\n        $uri =& JURI::getInstance(); \\r\\n        if(substr($mtconf->getjconf(\'live_site\'),0,16) == \'http://localhost\') { \\r\\n            // Allow for debugging \\r\\n            $html .= str_replace(\'http://localhost\',\'http://127.0.0.1\',$uri->toString(array( \'scheme\', \'host\', \'port\' ))); \\r\\n        } else { \\r\\n            $html .= $uri->toString(array( \'scheme\', \'host\', \'port\' )); \\r\\n        } \\r\\n        $html .= JRoute::_(\'index.php?option=com_mtree&task=viewlink&link_id=\'.$this->getLinkId().\'&Itemid=\'.$Itemid, false) .\'\\\\\';\'; \\r\\n        // Display the compact version when displayed in Summary view \\r\\n        if($view==2) { \\r\\n            $html .= \'digg_skin = \\\\\'compact\\\\\';\'; \\r\\n        } \\r\\n        $html .= \'</script>\'; \\r\\n        $html .= \'<script src=\\"http://digg.com/tools/diggthis.js\\" type=\\"text/javascript\\"></script>\'; \\r\\n        return $html; \\r\\n    } \\r\\n}"  WHERE field_type = "digg" LIMIT 1');
     $database->query();
     // Update digg version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "54" LIMIT 1');
     $database->query();
     $this->printStatus('Updated digg field type to version 2.');
     // Update audioplayer class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_audioplayer extends mFieldType_file {\\r\\n	function getJSValidation() {\\r\\n\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' . $this->getName() . \'.value,\\\\\'mp3\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . addslashes($this->getCaption()) . \': Please select a mp3 file.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$id = $this->getId();\\r\\n		$params[\'text\'] = $this->getParam(\'textColour\');\\r\\n		$params[\'displayfilename\'] = $this->getParam(\'displayfilename\',1);\\r\\n		$params[\'slider\'] = $this->getParam(\'sliderColour\');\\r\\n		$params[\'loader\'] = $this->getParam(\'loaderColour\');\\r\\n		$params[\'track\'] = $this->getParam(\'trackColour\');\\r\\n		$params[\'border\'] = $this->getParam(\'borderColour\');\\r\\n		$params[\'bg\'] = $this->getParam(\'backgroundColour\');\\r\\n		$params[\'leftbg\'] = $this->getParam(\'leftBackgrounColour\');\\r\\n		$params[\'rightbg\'] = $this->getParam(\'rightBackgrounColour\');\\r\\n		$params[\'rightbghover\'] = $this->getParam(\'rightBackgroundHoverColour\');\\r\\n		$params[\'lefticon\'] = $this->getParam(\'leftIconColour\');\\r\\n		$params[\'righticon\'] = $this->getParam(\'rightIconColour\');\\r\\n		$params[\'righticonhover\'] = $this->getParam(\'rightIconHoverColour\');\\r\\n		\\r\\n		$html = \'\';\\r\\n		$html .= \'<script language=\\"JavaScript\\" src=\\"\' . $this->getFieldTypeAttachmentURL(\'audio-player.js\'). \'\\"></script>\';\\r\\n		$html .= \\"\\\\n\\" . \'<object type=\\"application/x-shockwave-flash\\" data=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\'). \'\\" id=\\"audioplayer\' . $id . \'\\" height=\\"24\\" width=\\"290\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"movie\\" value=\\"\' . $this->getFieldTypeAttachmentURL(\'player.swf\') . \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"FlashVars\\" value=\\"\';\\r\\n		$html .= \'playerID=\' . $id;\\r\\n		$html .= \'&amp;soundFile=\' . urlencode($this->getDataAttachmentURL());\\r\\n		foreach( $params AS $key => $value ) {\\r\\n			if(!empty($value)) {\\r\\n				$html .= \'&amp;\' . $key . \'=0x\' . $value;\\r\\n			}\\r\\n		}\\r\\n		$html .= \'\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"quality\\" value=\\"high\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"menu\\" value=\\"false\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'<param name=\\"wmode\\" value=\\"transparent\\">\';\\r\\n		$html .= \\"\\\\n\\" . \'</object>\';\\r\\n		if($params[\'displayfilename\']) {\\r\\n			$html .= \\"\\\\n<br />\\";\\r\\n			$html .= \\"\\\\n\\" . \'<a href=\\"\' . $this->getDataAttachmentURL() . \'\\" target=\\"_blank\\">\';\\r\\n			$html .= $this->getValue();\\r\\n			$html .= \'</a>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "audioplayer" LIMIT 1');
     $database->query();
     // Update audioplayer version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "24" LIMIT 1');
     $database->query();
     $this->printStatus('Updated audioplayer field type to version 3.');
     // Update coredesc class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coredesc extends mFieldType {\\r\\n	var $name = \'link_desc\';\\r\\n	function parseValue($value) {\\r\\n		$params[\'maxChars\'] = intval($this->getParam(\'maxChars\',3000));\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,blockquote,strong,em\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		if($params[\'maxChars\'] > 0) {\\r\\n			$value = JString::substr( $value, 0, $params[\'maxChars\']);\\r\\n		}\\r\\n		return $value;\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		global $mtconf;\\r\\n		\\r\\n		if( ($this->inBackEnd() AND $mtconf->get(\'use_wysiwyg_editor_in_admin\')) || (!$this->inBackEnd() AND $mtconf->get(\'use_wysiwyg_editor\')) ) {\\r\\n			$editor = &JFactory::getEditor();\\r\\n			$html = $editor->display( $this->getInputFieldName(1), $this->getValue() , \'100%\', \'250\', \'75\', \'25\', array(\'pagebreak\', \'readmore\') );\\r\\n		} else {\\r\\n			$html = \'<textarea class=\\"inputbox\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" style=\\"width:95%;height:\' . $this->getSize() . \'px\\">\' . htmlspecialchars($this->getValue()) . \'</textarea>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'parseMambots\'] = $this->getParam(\'parseMambots\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,blockquote,strong,em\');\\r\\n		$params[\'showReadMore\'] = $this->getParam(\'showReadMore\',0);\\r\\n		$params[\'whenReadMore\'] = $this->getParam(\'whenReadMore\',0);\\r\\n		$params[\'txtReadMore\'] = $this->getParam(\'txtReadMore\',JTEXT::_( \'Read More...\' ));\\r\\n		\\r\\n		$html = $this->getValue();\\r\\n		$output = \'\';\\r\\n		\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			global $mtconf;\\r\\n			$output = $html;\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$output = $this->stripTags($output,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\']) {\\r\\n				$regex = \'/http:\\\\/\\\\/(.*?)(\\\\s|$)/i\';\\r\\n				$output = preg_replace_callback( $regex, array($this,\'linkcreator\'), $output );\\r\\n			}\\r\\n			if (!$mtconf->get(\'use_wysiwyg_editor\') && $params[\'stripDetailsTags\'] && !in_array(\'br\',explode(\',\',$params[\'allowedTags\'])) && !in_array(\'p\',explode(\',\',$params[\'allowedTags\'])) ) {\\r\\n				$output = nl2br(trim($output));\\r\\n			}\\r\\n			if($params[\'parseMambots\']) {\\r\\n				$this->parseMambots($output);\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'@{[\\\\/\\\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			}\\r\\n			if($params[\'summaryChars\'] > 0) {\\r\\n				$trimmed_desc = trim(JString::substr($html,0,$params[\'summaryChars\']));\\r\\n			} else {\\r\\n				$trimmed_desc = \'\';\\r\\n			}\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = htmlspecialchars( $html );\\r\\n				$trimmed_desc = htmlspecialchars( $trimmed_desc );\\r\\n			}\\r\\n			if (JString::strlen($html) > $params[\'summaryChars\']) {\\r\\n				$output .= $trimmed_desc;\\r\\n				$output .= \' <b>...</b>\';\\r\\n			} else {\\r\\n				$output = $html;\\r\\n			}\\r\\n			if( $params[\'showReadMore\'] && ($params[\'whenReadMore\'] == 1 || ($params[\'whenReadMore\'] == 0 && JString::strlen($html) > $params[\'summaryChars\'])) ) {\\r\\n				if(!empty($trimmed_desc)) {\\r\\n					$output .= \'<br />\';\\r\\n				}\\r\\n				$output .= \' <a href=\\"\' . JRoute::_(\'index.php?option=com_mtree&task=viewlink&link_id=\' . $this->getLinkId()) . \'\\" class=\\"readon\\">\' . $params[\'txtReadMore\'] . \'</a>\';\\r\\n			}\\r\\n		}\\r\\n		return $output;\\r\\n	}\\r\\n}"  WHERE field_type = "coredesc" LIMIT 1');
     $database->query();
     // Update coredesc params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D2273756D6D61727943686172732220747970653D2274657874222064656661756C743D2232353522206C6162656C3D224E756D626572206F662053756D6D617279206368617261637465727322202F3E0A09093C706172616D206E616D653D226D617843686172732220747970653D2274657874222064656661756C743D223330303022206C6162656C3D224D61782E206368617261637465727322206465736372697074696F6E3D22546865206D6178696D756D206E756D626572206F66206368617261637465727320616C6C6F77656420696E2074686973206669656C642E204465736372697074696F6E207468617420666F6573206F7665722074686973206C696D69742077696C6C206265207472696D6D65642E222F3E0A09093C706172616D206E616D653D22737472697053756D6D617279546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2053756D6D617279207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773207468617420636F756C6420706F74656E7469616C6C7920616666656374207768656E2076696577696E672061206C697374206F66206C697374696E67732E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22737472697044657461696C73546167732220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C207461677320696E2044657461696C73207669657722206465736372697074696F6E3D2253657474696E67207468697320746F207965732077696C6C2072656D6F766520616C6C2074616773206578636570742074686F73652074686174206172652073706563696669656420696E2027416C6C6F7765642074616773272E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22706172736555726C2220747970653D22726164696F222064656661756C743D223122206C6162656C3D2250617273652055524C206173206C696E6B20696E2044657461696C732076696577223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A0A09093C706172616D206E616D653D227374726970416C6C546167734265666F7265536176652220747970653D22726164696F222064656661756C743D223122206C6162656C3D22537472697020616C6C2048544D4C2074616773206265666F72652073746F72696E6720746F20646174616261736522206465736372697074696F6E3D224966205759535957494720656469746F7220697320656E61626C656420696E207468652066726F6E742D656E642C2074686973206665617475726520616C6C6F7720796F7520746F20737472697020616E7920706F74656E7469616C6C79206861726D66756C20636F6465732E20596F752063616E207374696C6C20616C6C6F7720736F6D6520746167732077697468696E206465736372697074696F6E206669656C642C2077686963682063616E206265207370656369666965642062656C6F772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22616C6C6F776564546167732220747970653D2274657874222064656661756C743D22752C622C692C612C756C2C6C692C7072652C626C6F636B71756F74652C7374726F6E672C656D22206C6162656C3D22416C6C6F776564207461677322206465736372697074696F6E3D22456E7465722074686520746167206E616D65732073657065726174656420627920636F6D6D612E205468697320706172616D6574657220616C6C6F7720796F7520746F2061636365707420736F6D652048544D4C2074616773206576656E20696620796F75206861766520656E61626C65207374726970696E67206F6620616C6C2048544D4C20746167732061626F76652E22202F3E0A09093C706172616D206E616D653D2270617273654D616D626F74732220747970653D22726164696F222064656661756C743D223022206C6162656C3D225061727365204D616D626F747322206465736372697074696F6E3D22456E61626C696E6720746869732077696C6C207061727365206D616D626F747320636F646573732077697468696E20746865206465736372697074696F6E206669656C64223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F77526561644D6F72652220747970653D22726164696F222064656661756C743D223022206C6162656C3D2253686F77202671756F743B52656164204D6F72652E2E2E2671756F743B22206465736372697074696F6E3D2253686F77202671756F743B52656164204D6F72652E2E2671756F743B2069662061206465736372697074696F6E207465787420636C697070656420696E2053756D6D61727920566965772E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D227768656E526561644D6F72652220747970653D226C697374222064656661756C743D223022206C6162656C3D225768656E20746F2073686F77202671756F743B52656164204D6F72652E2E2671756F743B22206465736372697074696F6E3D225468697320616C6C6F7720796F7520746F20736574207768656E20746F2073686F7720746865202671756F743B52656164204D6F72652E2E2671756F743B206C696E6B2E223E0A0909093C6F7074696F6E2076616C75653D2230223E5768656E206465736372697074696F6E20697320636C69707065643C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E416C6C207468652074696D653C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22747874526561644D6F72652220747970653D2274657874222064656661756C743D2252656164204D6F72652E2E2E22206C6162656C3D2252656164204D6F7265207465787422206465736372697074696F6E3D22456E74657220746865202671756F743B52656164204D6F72652E2E2671756F743B20746578742E22202F3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 2733 WHERE ft_id = 21 AND filename = 'params.xml' LIMIT 1");
     // Update coredesc version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "21" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coredesc field type to version 2.');
     // Update corefeatured class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corefeatured extends mFieldType {\\r\\n	var $name = \'link_featured\';\\r\\n	var $numOfInputFields = 0;\\r\\n	function getOutput() {\\r\\n		$featured = $this->getValue();\\r\\n		$html = \'\';\\r\\n		if($featured) {\\r\\n			$html .= JText::_( \'Yes\' );\\r\\n		} else {\\r\\n			$html .= JText::_( \'No\' );\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		$html = \'<select name=\\"\' . $this->getSearchFieldName(1) . \'\\" class=\\"inputbox text_area\\" size=\\"1\\">\';\\r\\n		$html .= \'<option value=\\"-1\\" selected=\\"selected\\">\' . JText::_( \'Any\' ) . \'</option>\';\\r\\n		$html .= \'<option value=\\"1\\">\' . JText::_( \'FEATURED ONLY\' ) . \'</option>\';\\r\\n		$html .= \'<option value=\\"0\\">\' . JText::_( \'NON FEATURED ONLY\' ) . \'</option>\';\\r\\n		$html .= \'</select>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getWhereCondition() {\\r\\n		$args = func_get_args();\\r\\n\\r\\n		$fieldname = $this->getName();\\r\\n		\\r\\n		if(  is_numeric($args[0]) ) {\\r\\n			switch($args[0]) {\\r\\n				case -1:\\r\\n					return null;\\r\\n					break;\\r\\n				case 1:\\r\\n					return $fieldname . \' = 1\';\\r\\n					break;\\r\\n				case 0:\\r\\n				return $fieldname . \' = 0\';\\r\\n					break;\\r\\n			}\\r\\n		} else {\\r\\n			return null;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "corefeatured" LIMIT 1');
     $database->query();
     // Update corefeatured version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "14" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corefeatured field type to version 2.');
     // Update corename class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corename extends mFieldType {\\r\\n	var $name = \'link_name\';\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'maxSummaryChars\'] = intval($this->getParam(\'maxSummaryChars\',55));\\r\\n		$params[\'maxDetailsChars\'] = intval($this->getParam(\'maxDetailsChars\',0));\\r\\n		$value = $this->getValue();\\r\\n		$output = \'\';\\r\\n		if($view == 1 AND $params[\'maxDetailsChars\'] > 0 AND JString::strlen($value) > $params[\'maxDetailsChars\']) {\\r\\n			$output .= JString::substr($value,0,$params[\'maxDetailsChars\']);\\r\\n			$output .= \'...\';\\r\\n		} elseif($view == 2 AND $params[\'maxSummaryChars\'] > 0 AND JString::strlen($value) > $params[\'maxSummaryChars\']) {\\r\\n			$output .= JString::substr($value,0,$params[\'maxSummaryChars\']);\\r\\n			$output .= \'...\';\\r\\n		} else {\\r\\n			$output = $value;\\r\\n		}\\r\\n		return $output;\\r\\n	}\\r\\n}"  WHERE field_type = "corename" LIMIT 1');
     $database->query();
     // Update corename version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "20" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corename field type to version 2.');
     // Update coreprice class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coreprice extends mFieldType_number {\\r\\n	var $name = \'price\';\\r\\n	function getOutput() {\\r\\n		$price = $this->getValue();\\r\\n		$displayFree = $this->getParam(\'displayFree\',1);\\r\\n		if($price == 0 && $displayFree == 1) {\\r\\n			return JText::_( \'FREE\' );\\r\\n		} else {\\r\\n			return $price;\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "coreprice" LIMIT 1');
     $database->query();
     // Update coreprice version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "2" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coreprice field type to version 2.');
     // Update coreuser class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_coreuser extends mFieldType {\\r\\n	var $name = \'user_id\';\\r\\n	var $numOfSearchFields = 0;\\r\\n	var $numOfInputFields = 0;\\r\\n	\\r\\n	function getOutput() {\\r\\n		$html = \'<a href=\\"\' . JRoute::_(\'index.php?option=com_mtree&amp;task=viewowner&amp;user_id=\' . $this->getValue(1)) . \'\\">\';\\r\\n		$html .= $this->getValue(2);\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n}\\r\\n"  WHERE field_type = "coreuser" LIMIT 1');
     $database->query();
     // Update coreuser version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "19" LIMIT 1');
     $database->query();
     $this->printStatus('Updated coreuser field type to version 2.');
     // Update corewebsite class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corewebsite extends mFieldType_weblink {\\r\\n	var $name = \'website\';\\r\\n\\r\\n	function getOutput() {\\r\\n		$maxUrlLength = $this->getParam(\'maxUrlLength\',60);\\r\\n		$text = $this->getParam(\'text\',\'\');\\r\\n		$openNewWindow = $this->getParam(\'openNewWindow\',1);\\r\\n		$useMTVisitRedirect = $this->getParam(\'useMTVisitRedirect\',1);\\r\\n		$hideProtocolOutput = $this->getParam(\'hideProtocolOutput\',1);\\r\\n	\\r\\n		$html = \'\';\\r\\n		$html .= \'<a href=\\"\';\\r\\n		if($useMTVisitRedirect) {\\r\\n			global $Itemid;\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=visit&link_id=\' . $this->getLinkId() . \'&Itemid=\' . $Itemid);\\r\\n		} else {\\r\\n			$html .= $this->getValue();\\r\\n		}\\r\\n		$html .= \'\\"\';\\r\\n		if( $openNewWindow == 1 ) {\\r\\n			$html .= \' target=\\"_blank\\"\';\\r\\n		}\\r\\n		$html .= \'>\';\\r\\n		if(!empty($text)) {\\r\\n			$html .= $text;\\r\\n		} else {\\r\\n			$value = $this->getValue();\\r\\n			if(strpos($value,\'://\') !== false && $hideProtocolOutput) {\\r\\n				$value = substr($value,(strpos($value,\'://\')+3));\\r\\n\\r\\n				// If $value has a single slash and this is at the end of the string, we can safely remove this.\\r\\n				if( substr($value,-1) == \'/\' && substr_count($value,\'/\') == 1 )\\r\\n				{\\r\\n					$value = substr($value,0,-1);\\r\\n				}\\r\\n			}\\r\\n			if( empty($maxUrlLength) || $maxUrlLength == 0 ) {\\r\\n				$html .= $value;\\r\\n			} else {\\r\\n				$html .= substr($value,0,$maxUrlLength);\\r\\n				if( strlen($value) > $maxUrlLength ) {\\r\\n					$html .= $this->getParam(\'clippedSymbol\');\\r\\n				}\\r\\n			}\\r\\n		}\\r\\n		$html .= \'</a>\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n	function getInputHTML() {\\r\\n		$showGo = $this->getParam(\'showGo\',1);\\r\\n		$showSpider = $this->getParam(\'showSpider\',0);\\r\\n		$inBackEnd = (substr(dirname($_SERVER[\'PHP_SELF\']),-13) == \'administrator\') ? true : false;\\r\\n		$html = \'\';\\r\\n		$html .= \'<input class=\\"text_area inputbox\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . ($this->getSize()?$this->getSize():\'30\') . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		if($showGo && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript:window.open(\\"index3.php?option=com_mtree&task=openurl&url=\\"+escape(document.getElementById(\\"website\\").value))\\\\\'\';\\r\\n			$html .= \'value=\\"\' . JText::_( \'Go\' ) . \'\\" />\';\\r\\n		}\\r\\n		\\r\\n		if($showSpider && $inBackEnd) {\\r\\n			$html .= \'&nbsp;\';\\r\\n			$html .= \'<input type=\\"button\\" class=\\"button\\" onclick=\\\\\'\';\\r\\n			$html .= \'javascript: \';\\r\\n			$html .= \'jQuery(\\"#spiderwebsite\\").html(\\"\' . JText::_( \'SPIDER PROGRESS\' ) . \'\\");\';\\r\\n			$html .= \'jQuery.ajax({\\r\\n			  type: \\"POST\\",\\r\\n			  url: mosConfig_live_site+\\"/administrator/index2.php\\",\\r\\n			  data: \\"option=com_mtree&task=ajax&task2=spiderurl&url=\\"+document.getElementById(\\"website\\").value+\\"&no_html=1\\",\\r\\n			  dataType: \\"script\\"\\r\\n			});\';\\r\\n			$html .= \'\\\\\'\';\\r\\n			$html .= \'value=\\"\' . JText::_( \'SPIDER\' ) . \'\\" />\';\\r\\n			$html .= \'<span id=\\"spider\' . $this->getInputFieldName(1) . \'\\" style=\\"margin-left:5px;background-color:white\\"></span>\';\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "corewebsite" LIMIT 1');
     $database->query();
     // Update corewebsite version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "11" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corewebsite field type to version 2.');
     // Update corecountry class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_corecountry extends mFieldType {\\r\\n	var $name = \'country\';\\r\\n	function getInputHTML() {\\r\\n		if( !empty($this->arrayFieldElements[0]) )\\r\\n		{\\r\\n			$html = \'<select name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" class=\\"inputbox text_area\\">\';\\r\\n			$html .= \'<option value=\\"\\">&nbsp;</option>\';\\r\\n			foreach($this->arrayFieldElements AS $fieldElement) {\\r\\n				$html .= \'<option value=\\"\'.$fieldElement.\'\\"\';\\r\\n				if( $fieldElement == $this->getValue() ) {\\r\\n					$html .= \' selected\';\\r\\n				}\\r\\n				$html .= \'>\' . $fieldElement . \'</option>\';\\r\\n			}\\r\\n			$html .= \'</select>\';\\r\\n			return $html;\\r\\n		} else {\\r\\n			return \'<input class=\\"inputbox text_area\\" type=\\"text\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" size=\\"\' . ($this->getSize()?$this->getSize():\'30\') . \'\\" value=\\"\' . htmlspecialchars($this->getValue()) . \'\\" />\';\\r\\n		}\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		$html = \'<select name=\\"\' . $this->getName() . \'\\" class=\\"inputbox text_area\\">\';\\r\\n		$html .= \'<option value=\\"\\">&nbsp;</option>\';\\r\\n		foreach($this->arrayFieldElements AS $fieldElement) {\\r\\n			$html .= \'<option value=\\"\'.$fieldElement.\'\\"\';\\r\\n			$html .= \'>\' . $fieldElement . \'</option>\';\\r\\n		}\\r\\n		$html .= \'</select>\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		if( $this->tagSearch && $this->hasValue() )\\r\\n		{\\r\\n			$html = \'\';\\r\\n			$html .= \'<a class=\\"tag\\" href=\\"\';\\r\\n			$html .= JRoute::_(\'index.php?option=com_mtree&task=searchby&cf_id=\'.$this->getId().\'&value=\'.$this->getValue());\\r\\n			$html .= \'\\">\';\\r\\n			$html .= $this->getValue();\\r\\n			$html .= \'</a>\';\\r\\n			return $html;\\r\\n		} else {\\r\\n			return $this->getValue();\\r\\n		}\\r\\n	}\\r\\n}"  WHERE field_type = "corecountry" LIMIT 1');
     $database->query();
     // Update corecountry version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "6" LIMIT 1');
     $database->query();
     $this->printStatus('Updated corecountry field type to version 2.');
     // Update image class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_image extends mFieldType_file {\\r\\n	function parseValue($value) {\\r\\n		global $mtconf;\\r\\n		$params[\'size\'] = intval(trim($this->getParam(\'size\')));\\r\\n		if($params[\'size\'] <= 0) {\\r\\n			$size = $mtconf->get(\'resize_listing_size\');\\r\\n		} else {\\r\\n			$size = intval($params[\'size\']);\\r\\n		}\\r\\n		$mtImage = new mtImage();\\r\\n		$mtImage->setMethod( $mtconf->get(\'resize_method\') );\\r\\n		$mtImage->setQuality( $mtconf->get(\'resize_quality\') );\\r\\n		$mtImage->setSize( $size );\\r\\n		$mtImage->setTmpFile( $value[\'tmp_name\'] );\\r\\n		$mtImage->setType( $value[\'type\'] );\\r\\n		$mtImage->setName( $value[\'name\'] );\\r\\n		$mtImage->setSquare(false);\\r\\n		$mtImage->resize();\\r\\n		$value[\'data\'] = $mtImage->getImageData();\\r\\n		$value[\'size\'] = strlen($value[\'data\']);\\r\\n		\\r\\n		return $value;\\r\\n	}\\r\\n	function getJSValidation() {\\r\\n		$js = \'\';\\r\\n		$js .= \'} else if (!hasExt(form.\' .$this->getInputFieldName(1) . \'.value,\\\\\'gif|png|jpg|jpeg\\\\\')) {\'; \\r\\n		$js .= \'alert(\\"\' . addslashes($this->getCaption()) . \': Please select an image with one of these extensions - gif,png,jpg,jpeg.\\");\';\\r\\n		return $js;\\r\\n	}\\r\\n	function getOutput() {\\r\\n		$html = \'\';\\r\\n		$html .= \'<img src=\\"\' . $this->getDataAttachmentURL() . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$html = \'\';\\r\\n		if( $this->attachment > 0 ) {\\r\\n			$html .= $this->getKeepFileCheckboxHTML($this->attachment);\\r\\n			$html .= \'<label for=\\"\' . $this->getKeepFileName() . \'\\"><img src=\\"\' . $this->getDataAttachmentURL() . \'\\" hspace=\\"5\\" vspace=\\"0\\" /></label>\';\\r\\n			$html .= \'</br >\';\\r\\n		}\\r\\n		$html .= \'<input class=\\"inputbox\\" type=\\"file\\" name=\\"\' . $this->getInputFieldName(1) . \'\\" />\';\\r\\n		return $html;\\r\\n	}\\r\\n	\\r\\n}"  WHERE field_type = "image" LIMIT 1');
     $database->query();
     // Update image version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "3" WHERE ft_id = "25" LIMIT 1');
     $database->query();
     $this->printStatus('Updated image field type to version 3.');
     // Update multilineTextbox class code
     $database->setQuery('UPDATE #__mt_fieldtypes SET ft_class = "class mFieldType_multilineTextbox extends mFieldType {\\r\\n	function parseValue($value) {\\r\\n		$params[\'stripAllTagsBeforeSave\'] = $this->getParam(\'stripAllTagsBeforeSave\',0);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n		if($params[\'stripAllTagsBeforeSave\']) {\\r\\n			$value = $this->stripTags($value,$params[\'allowedTags\']);\\r\\n		}\\r\\n		return $value;		\\r\\n	}\\r\\n	function getInputHTML() {\\r\\n		$params[\'cols\'] = $this->getParam(\'cols\',60);\\r\\n		$params[\'rows\'] = $this->getParam(\'rows\',6);\\r\\n		$params[\'style\'] = $this->getParam(\'style\',\'\');\\r\\n		$html = \'\';\\r\\n		$html .= \'<textarea name=\\"\' . $this->getInputFieldName(1) . \'\\" id=\\"\' . $this->getInputFieldName(1) . \'\\" class=\\"inputbox\\"\';\\r\\n		$html .= \' cols=\\"\' . $params[\'cols\'] . \'\\" rows=\\"\' . $params[\'rows\'] . \'\\"\';\\r\\n		if(!empty($params[\'style\'])) {\\r\\n			$html .=  \' style=\\"\' . $params[\'style\'] . \'\\"\';\\r\\n		}\\r\\n		$html .=  \'>\' . $this->getValue() . \'</textarea>\';\\r\\n		return $html;\\r\\n	}\\r\\n	function getSearchHTML() {\\r\\n		return \'<input class=\\"inputbox\\" type=\\"text\\" name=\\"\' . $this->getName() . \'\\" size=\\"30\\" />\';\\r\\n	}\\r\\n	function getOutput($view=1) {\\r\\n		$params[\'parseUrl\'] = $this->getParam(\'parseUrl\',1);\\r\\n		$params[\'summaryChars\'] = $this->getParam(\'summaryChars\',255);\\r\\n		$params[\'stripSummaryTags\'] = $this->getParam(\'stripSummaryTags\',1);\\r\\n		$params[\'stripDetailsTags\'] = $this->getParam(\'stripDetailsTags\',1);\\r\\n		$params[\'allowedTags\'] = $this->getParam(\'allowedTags\',\'u,b,i,a,ul,li,pre,br,blockquote\');\\r\\n	\\r\\n		$html = $this->getValue();\\r\\n	\\r\\n		// Details view\\r\\n		if($view == 1) {\\r\\n			if($params[\'stripDetailsTags\']) {\\r\\n				$html = $this->stripTags($html,$params[\'allowedTags\']);\\r\\n			}\\r\\n			if($params[\'parseUrl\'] AND $view == 0) {\\r\\n				$regex = \'/http:\\\\/\\\\/(.*?)(\\\\s|$)/i\';\\r\\n				$html = preg_replace_callback( $regex, array($this,\'linkcreator\'), $html );\\r\\n			}\\r\\n		// Summary view\\r\\n		} else {\\r\\n			$html = preg_replace(\'@{[\\\\/\\\\!]*?[^<>]*?}@si\', \'\', $html);\\r\\n			if($params[\'stripSummaryTags\']) {\\r\\n				$html = strip_tags( $html );\\r\\n			} else {\\r\\n			}\\r\\n			$trimmed_desc = trim(JString::substr($html,0,$params[\'summaryChars\']));\\r\\n			if (JString::strlen($html) > $params[\'summaryChars\']) {\\r\\n				$html = $trimmed_desc . \' <b>...</b>\';\\r\\n			}\\r\\n		}\\r\\n		return $html;\\r\\n	}\\r\\n}"  WHERE field_type = "multilineTextbox" LIMIT 1');
     $database->query();
     // Update multilineTextbox version number
     $database->setQuery('UPDATE #__mt_fieldtypes_info SET ft_version = "2" WHERE ft_id = "26" LIMIT 1');
     $database->query();
     $this->printStatus('Updated multilineTextbox field type to version 2.');
     // Update corecreated params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D227374617274596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D225374617274207965617222206465736372697074696F6E3D22456E74657220746865207374617274696E672079656172206F72206561726C69657374207965617220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C2069742077696C6C2064656661756C7420746F2037302079656172732061676F2066726F6D207468652063757272656E7420796561722E22202F3E0A09093C706172616D206E616D653D22656E64596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D22456E64207965617222206465736372697074696F6E3D22456E74657220746865206C61746573742079656172206F7220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C207468652063757272656E7420796561722077696C6C20626520757365642E22202F3E0A09093C706172616D206E616D653D2264617465466F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D224461746520466F726D617422203E0A0909093C6F7074696F6E2076616C75653D2225592D256D2D2564223E323030372D30362D30313C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2225642E256D2E2559223E30312E30362E323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D222564202542202559223E3031204A756E6520323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2225642F256D2F2559223E30312F30362F323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D22256D2F25642F2559223E30362F30312F323030373C2F6F7074696F6E3E0A09093C2F706172616D3E09090A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 784 WHERE ft_id = 22 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update coremodified params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D227374617274596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D225374617274207965617222206465736372697074696F6E3D22456E74657220746865207374617274696E672079656172206F72206561726C69657374207965617220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C2069742077696C6C2064656661756C7420746F2037302079656172732061676F2066726F6D207468652063757272656E7420796561722E22202F3E0A09093C706172616D206E616D653D22656E64596561722220747970653D2274657874222064656661756C743D2222206C6162656C3D22456E64207965617222206465736372697074696F6E3D22456E74657220746865206C61746573742079656172206F7220617661696C61626C6520666F722073656C656374696F6E2E204966206C65667420656D7074792C207468652063757272656E7420796561722077696C6C20626520757365642E22202F3E0A09093C706172616D206E616D653D2264617465466F726D61742220747970653D226C697374222064656661756C743D2222206C6162656C3D224461746520466F726D617422203E0A0909093C6F7074696F6E2076616C75653D2225592D256D2D2564223E323030372D30362D30313C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2225642E256D2E2559223E30312E30362E323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D222564202542202559223E3031204A756E6520323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2225642F256D2F2559223E30312F30362F323030373C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D22256D2F25642F2559223E30362F30312F323030373C2F6F7074696F6E3E0A09093C2F706172616D3E09090A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 784 WHERE ft_id = 15 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update mfile params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D7320616464706174683D222F61646D696E6973747261746F722F636F6D706F6E656E74732F636F6D5F6D747265652F656C656D656E7473223E200A09093C706172616D206E616D653D2266696C65457874656E73696F6E732220747970653D22706970656474657874222064656661756C743D2222206C6162656C3D2241636365707461626C652066696C6520657874656E73696F6E7322206465736372697074696F6E3D22456E746572207468652061636365707461626C652066696C652074797065206F6620657874656E73696F6E20666F722074686973206669656C642E20496620796F752068617665206D6F7265207468616E206F6E6520657874656E73696F6E2C20706C656173652073657065726174652074686520657874656E73696F6E207769746820612062617220277C272E204578616D706C653A20276769667C706E677C6A70677C6A70656727206F722027706466272E20506C6561736520646F206E6F74207374617274206F7220656E64207468652076616C756520776974682061206261722E2022202F3E0A09093C706172616D206E616D653D2273686F77436F756E7465722220747970653D22726164696F222064656661756C743D223122206C6162656C3D2253686F7720636F756E746572223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22757365496D6167652220747970653D2274657874222064656661756C743D2222206C6162656C3D2255736520496D61676522206465736372697074696F6E3D22456E746572207468652055524C20746F2074686520696D61676520796F7520776F756C64206C696B6520746F2075736520746F206C696E6B20746F20616E2075706C6F616465642066696C652E20596F752063616E20757365207B6C6976655F736974657D20617320746865207265706C6163656D656E7420666F72207468652076616C7565206F662073697465277320646F6D61696E2E2069653A207B6C6976655F736974657D2F696D616765732F736176655F66322E706E6722202F3E0A09093C706172616D206E616D653D2273686F77546578742220747970653D2274657874222064656661756C743D2222206C6162656C3D2253686F77205465787422202F3E0A09093C706172616D206E616D653D2273686F7746696C656E616D652220747970653D22726164696F222064656661756C743D223122206C6162656C3D2253686F772046696C656E616D6522206465736372697074696F6E3D225468697320616C6C6F777320796F7520746F2068696465207468652066696C656E616D65206C696E6B2E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 1162 WHERE ft_id = 48 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update corewebsite params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D226F70656E4E657757696E646F772220747970653D22726164696F222064656661756C743D223122206C6162656C3D224F70656E204E65772057696E646F7722206465736372697074696F6E3D224F70656E2061206E65772077696E646F77207768656E20746865206C696E6B20697320636C69636B65642E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D227573654D54566973697452656469726563742220747970653D22726164696F222064656661756C743D223122206C6162656C3D2255736520696E7465726E616C20726564697265637422206465736372697074696F6E3D225573696E6720696E7465726E65742072656469726563742077696C6C206272696E672076697369746F7273207468726F75676820616E20696E7465726E616C2055524C206265666F7265207265646972656374696E67207468656D20746F207468652061637475616C20776562736974652E205468697320616C6C6F7773204D6F73657473205472656520746F206B65657020747261636B206F6620746865206869747320616E64206869646573207468652061637475616C792055524C2066726F6D2076697369746F722E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22746578742220747970653D2274657874222064656661756C743D2222206C6162656C3D224C696E6B205465787422206465736372697074696F6E3D22557365207468697320706172616D6574657220746F207370656369667920746865206C696E6B20746578742E204966206C65667420656D7074792C207468652066756C6C2055524C2077696C6C20626520646973706C6179656420617320746865206C696E6B277320746578742E22202F3E0A09093C706172616D206E616D653D226D617855726C4C656E6774682220747970653D2274657874222064656661756C743D22363022206C6162656C3D224D61782E2055524C204C656E67746822206465736372697074696F6E3D22456E74657220746865206D6178696D756D2055524C2773206C656E677468206265666F726520697420697320636C697070656422202F3E0A09093C706172616D206E616D653D22636C697070656453796D626F6C2220747970653D2274657874222064656661756C743D222E2E2E22206C6162656C3D22436C69707065642073796D626F6C22202F3E0A0A09093C706172616D206E616D653D226869646550726F746F636F6C4F75747075742220747970653D22726164696F222064656661756C743D223122206C6162656C3D22486964652027687474703A2F2F2720647572696E67206F7574707574223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F77476F2220747970653D22726164696F222064656661756C743D223122206C6162656C3D2253686F7720476F20627574746F6E22206465736372697074696F6E3D225468697320476F20627574746F6E2077696C6C20626520617661696C61626C6520696E20746865206261636B2D656E642045646974204C697374696E67207061676520746F20616C6C6F772061646D696E206120666173742077617920746F206F70656E20746865206C697374696E67277320776562736974652E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F775370696465722220747970653D22726164696F222064656661756C743D223022206C6162656C3D2253686F772053706964657220627574746F6E22206465736372697074696F6E3D225768656E20656E61626C65642C20612053706964657220627574746F6E2077696C6C20626520617661696C61626C65206E65787420746F20746865207765627369746520696E707574206669656C6420696E206261636B2D656E642E205768656E2074686520627574746F6E20697320636C69636B65642C2069742077696C6C20636865636B20746865207765627369746520696E20746865206261636B67726F756E20616E6420706F70756C61746520746865206C697374696E672773204D455441204B65797320616E64204D455441204465736372697074696F6E206669656C642E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 1948 WHERE ft_id = 11 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Update weblinknewwin params.xml
     $database->setQuery("UPDATE #__mt_fieldtypes_att SET filedata = 0x3C6D6F73706172616D7320747970653D226D6F64756C65223E0A093C706172616D733E0A09093C706172616D206E616D653D226F70656E4E657757696E646F772220747970653D22726164696F222064656661756C743D223122206C6162656C3D224F70656E204E65772057696E646F7722206465736372697074696F6E3D224F70656E2061206E65772077696E646F77207768656E20746865206C696E6B20697320636C69636B65642E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D22746578742220747970653D2274657874222064656661756C743D2222206C6162656C3D224C696E6B205465787422206465736372697074696F6E3D22557365207468697320706172616D6574657220746F207370656369667920746865206C696E6B20746578742E204966206C65667420656D7074792C207468652066756C6C2055524C2077696C6C20626520646973706C6179656420617320746865206C696E6B277320746578742E22202F3E0A09093C706172616D206E616D653D226D617855726C4C656E6774682220747970653D2274657874222064656661756C743D22363022206C6162656C3D224D61782E2055524C204C656E67746822206465736372697074696F6E3D22456E74657220746865206D6178696D756D2055524C2773206C656E677468206265666F726520697420697320636C697070656422202F3E0A09093C706172616D206E616D653D22636C697070656453796D626F6C2220747970653D2274657874222064656661756C743D222E2E2E22206C6162656C3D22436C69707065642073796D626F6C22202F3E0A09093C706172616D206E616D653D22757365496E7465726E616C52656469726563742220747970653D22726164696F222064656661756C743D223022206C6162656C3D2255736520696E7465726E616C20726564697265637422206465736372697074696F6E3D225573696E6720696E7465726E616C2072656469726563742077696C6C2068696465207468652061637475616C2064657374696E6174696F6E2055524C20616E642075736520616E20696E7465726E616C2055524C20746F20726564697265637420757365727320746F207468652061637475616C2055524C2E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D226869646550726F746F636F6C4F75747075742220747970653D22726164696F222064656661756C743D223122206C6162656C3D22486964652027687474703A2F2F2720647572696E67206F7574707574223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A09093C706172616D206E616D653D2273686F77476F2220747970653D22726164696F222064656661756C743D223022206C6162656C3D2253686F7720476F20627574746F6E22206465736372697074696F6E3D225468697320476F20627574746F6E2077696C6C20626520617661696C61626C6520696E20746865206261636B2D656E642045646974204C697374696E67207061676520746F20616C6C6F772061646D696E206120666173742077617920746F206F70656E20746865206C697374696E67277320776562736974652E223E0A0909093C6F7074696F6E2076616C75653D2230223E4E6F3C2F6F7074696F6E3E0A0909093C6F7074696F6E2076616C75653D2231223E5965733C2F6F7074696F6E3E0A09093C2F706172616D3E0A093C2F706172616D733E0A3C2F6D6F73706172616D733E, filesize = 1464 WHERE ft_id = 23 AND filename = 'params.xml' LIMIT 1");
     $database->query();
     // Change Admin Icon to Mosets icon
     $database->setQuery("UPDATE #__components SET admin_menu_img='../components/com_mtree/img/icon-16-mosetstree.png' WHERE admin_menu_link='option=com_mtree'");
     $database->query();
     updateVersion(2, 1, 0);
     $this->updated = true;
     return true;
 }
コード例 #16
0
    echo Delete_Table_Columns($updates3, 'joomleague_eventtype');
    echo Delete_Table_Columns($updates3, 'joomleague_position');
    echo Delete_Table_Columns($updates3, 'joomleague_team_staff');
    echo Delete_Table_Columns($updates3, 'joomleague_team_player');
    echo Delete_Table_Columns($updates3, 'joomleague_division');
    echo Delete_Table_Columns($updates3, 'joomleague_team');
    echo Delete_Table_Columns($updates3, 'joomleague_project_team');
    echo Delete_Table_Columns($updates3, 'joomleague_season');
    echo Delete_Table_Columns($updates3, 'joomleague_league');
    echo Delete_Table_Columns($updates3, 'joomleague_club');
    echo Delete_Table_Columns($updates3, 'joomleague_playground');
    echo Delete_Table_Columns($updates3, 'joomleague_person');
    echo Delete_Table_Columns($updates3, 'joomleague_project');
    echo '<br />';
    echo '<hr>';
    echo updateVersion($version, $updatefilename) . '<br />';
    echo '<hr>';
    echo '<p><h1 style="text-align:center; color:green; ">';
    echo JText::_('COM_JOOMLEAGUE_DB_UPDATE_CONGRATULATIONS');
    echo '<br />';
    echo JText::_('COM_JOOMLEAGUE_DB_UPDATE_ALL_STEPS_FINISHED');
    echo '<br />';
    echo JText::_('COM_JOOMLEAGUE_DB_UPDATE_USE_NOW');
    echo '</h1></p>';
    setUpdatePart(0);
} else {
    echo '<h3 style="text-align:center; ">';
    echo '<a href="javascript:location.reload(true)">';
    echo '<strong>';
    echo JText::sprintf('COM_JOOMLEAGUE_DB_UPDATE_CLICK_HERE', getUpdatePart() + 1, $totalUpdateParts) . '<br />';
    echo JText::_('COM_JOOMLEAGUE_DB_UPDATE_MAY_NEED_TIME') . '<br />';
コード例 #17
0
ファイル: 2_1_2.php プロジェクト: rsemedo/Apply-Within
 function upgrade()
 {
     updateVersion(2, 1, 2);
     $this->updated = true;
     return true;
 }