return JFile::move($source, $destination); } function updateCB_db() { $db =& JFactory::getDBO(); $cbVersion = caclInstaller::get_xml_tag_value('version', 'com_comprofiler'); if (version_compare($cbVersion, '1.2.2', '>=')) { $query = "ALTER TABLE `#__comprofiler` ADD `cb_caclmembertype` VARCHAR(255) NOT NULL DEFAULT ''"; } else { $query = "ALTER TABLE `#__comprofiler` ADD `cb_caclmembertype` INT( 11 ) NOT NULL DEFAULT '0'"; } $db->setQuery($query); $db->query(); $cb_caclmemebertype_search = NULL; $query = "SELECT `fieldid` FROM `#__comprofiler_fields` WHERE `tablecolumns` = 'cb_caclmembertype' AND `table` = '#__comprofiler' "; $db->setQuery($query); $cb_caclmemebertype_search = $db->loadResult(); if (is_null($cb_caclmemebertype_search)) { //Disable the Dropdown list $query = "INSERT INTO `#__comprofiler_fields` (`fieldid`, `name`, `tablecolumns`, `table`, `title`, `description`, `type`, `maxlength`, `size`, `required`, `tabid`, `ordering`, `cols`, `rows`, `value`, `default`, `published`, `registration`, `profile`, `displaytitle`, `readonly`, `searchable`, `calculated`, `sys`, `pluginid`, `params`) VALUES\r\n\t\t\t\t\t\t('', 'cb_caclmembertype', 'cb_caclmembertype', '#__comprofiler', 'Registration Membership Type', '', 'select', 0, 0, 0, 11, -27, 0, 0, NULL, '1', 1, 1, 1, 1, 0, 0, 0, 0, 1, '');\r\n\t\t\t\t\t\t\t"; $db->setQuery($query); $db->query(); } else { //Enable the Dropdown list $query = "UPDATE `#__comprofiler_fields` SET published = '1' " . " WHERE `tablecolumns` = 'cb_caclmembertype' AND `table` = '#__comprofiler' "; $db->setQuery($query); $db->query();