/** * Add the infomation about the URL to the attaachment record and then save it * * @param &object &$attachment the attachment object * @param &object &$parent the attachments parent object * @param bool $verify whether the existance of the URL should be checked * @param bool $relative_url allow relative URLs * @param string $update the type of update (or false if it is not an update) * @param int $attachment_id the attachment ID, false if this is a new attachment * * @return an error message if there is a problem */ public static function add_url(&$attachment, &$parent, $verify, $relative_url = false, $update = false, $attachment_id = false) { $user = JFactory::getUser(); // Get the component parameters jimport('joomla.application.component.helper'); $params = JComponentHelper::getParams('com_attachments'); // Get the auto-publish setting $auto_publish = $params->get('publish_default', false); // Figure out if the user has permissions to publish $may_publish = $parent->userMayChangeAttachmentState($attachment->parent_id, $attachment->parent_entity, $attachment->created_by); // If we are updating, note the name of the old filename (if there was one) // (Needed for switching from a file to a URL) $old_filename = null; $old_filename_sys = null; $old_display_name = null; if ($update) { if ($attachment->filename_sys) { $old_filename = $attachment->filename; $old_filename_sys = $attachment->filename_sys; } $old_display_name = JRequest::getString('old_display_name', null); } // Check to make sure the URL is valid $from = JRequest::getWord('from'); // Get the info from the url $result = AttachmentsHelper::get_url_info($attachment->url, $attachment, $verify, $relative_url); // Save the info about the URL flags $attachment->url_verify = $verify; $attachment->url_relative = $relative_url; // If there was an error, bow out if ($result !== true) { $app = JFactory::getApplication(); if ($app->isAdmin()) { return $result; } $update_form = JRequest::getWord('update'); // Redisplay the upload/update form with complaints if ($update) { require_once JPATH_COMPONENT_SITE . '/views/update/view.html.php'; $view = new AttachmentsViewUpdate(); AttachmentsHelper::add_view_urls($view, 'update', $attachment->parent_id, $attachment->parent_type, $attachment_id, $from); $view->update = $update_form; } else { require_once JPATH_COMPONENT_SITE . '/views/upload/view.html.php'; $view = new AttachmentsViewUpload(); AttachmentsHelper::add_view_urls($view, 'upload', $attachment->parent_id, $attachment->parent_type, null, $from); } // Suppress the display filename if we are changing from file to url $display_name = $attachment->display_name; if ($update && ($update == 'file' || $update != $attachment->uri_type)) { $attachment->display_name = ''; } // Set up the view $view->attachment = $attachment; $view->new_parent = $parent->new; $view->parent = $parent; $view->params = $params; $view->from = $from; $view->Itemid = JRequest::getInt('Itemid', 1); $view->error = $result->error; $view->error_msg = $result->error_msg; // Display the view $view->display(); exit; } // Clear out the display_name if the URL has changed $old_url = JRequest::getString('old_url'); if ($attachment->display_name && $attachment->url != $old_url) { $old_display_name = JRequest::getString('old_display_name'); if ($old_display_name == $attachment->display_name) { $attachment->display_name = ''; } } // Get the maximum allowed filename length (for the filename display) $max_filename_length = $params->get('max_filename_length', 0); if (is_numeric($max_filename_length)) { $max_filename_length = (int) $max_filename_length; } else { $max_filename_length = 0; } // Create a display filename, if needed (for long URLs) if ($max_filename_length > 0 && strlen($attachment->display_name) == 0) { if ($attachment->filename) { $attachment->display_name = AttachmentsHelper::truncate_filename($attachment->filename, $max_filename_length); } else { $attachment->display_name = AttachmentsHelper::truncate_url($attachment->url, $max_filename_length); } } // Assume relative URLs are valid if ($relative_url) { $attachment->url_valid = true; } // If there is no filename, do something about it if (!$attachment->filename and !$attachment->display_name) { $attachment->display_name = $attachment->url; } // If the user is not authorised to change the state (eg, publish/unpublish), // ignore the form data and make sure the publish state is set correctly. if (!$may_publish) { $save_type = JString::strtolower(JRequest::getWord('save_type', 'update')); if ($save_type == 'upload') { // Use the default publish state jimport('joomla.application.component.helper'); $params = JComponentHelper::getParams('com_attachments'); $attachment->state = $params->get('publish_default', false); } else { // Restore the old state $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('state')->from('#__attachments')->where('id = ' . (int) $attachment->id); $db->setQuery($query, 0, 1); $old_state = $db->loadResult(); if ($db->getErrorNum()) { $errmsg = $db->stderr() . ' (ERR 39)'; JError::raiseError(500, $errmsg); } $attachment->state = $old_state; } } // Set the create/modify dates $now = JFactory::getDate(); $attachment->created = $now->toSql(); $attachment->modified = $attachment->created; $attachment->uri_type = 'url'; // Check the URL length if (strlen($attachment->url) > AttachmentsDefines::$MAXIMUM_URL_LENGTH) { $errmsg = "URL is too long! (" . strlen($attachment->url) . ")"; // ??? Convert to translated error message JError::raiseError(500, $errmsg); } // Save the updated attachment if (!$attachment->store()) { $errmsg = JText::_('ATTACH_ERROR_SAVING_URL_ATTACHMENT_RECORD') . $attachment->getError() . ' (ERR 40)'; JError::raiseError(500, $errmsg); } // Delete any old attachment file if ($old_filename_sys) { jimport('joomla.filesystem.file'); if (JFile::exists($old_filename_sys)) { JFile::delete($old_filename_sys); AttachmentsHelper::clean_directory($old_filename_sys); } } if ($update) { $msg = JText::_('ATTACH_ATTACHMENT_UPDATED'); } else { $msg = JText::_('ATTACH_ATTACHMENT_SAVED'); } return $msg; }
/** * Validate all URLS and update their "valid" status */ public static function validate_urls() { // Get the component parameters jimport('joomla.application.component.helper'); $params = JComponentHelper::getParams('com_attachments'); // Get all the attachment IDs $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('id')->from('#__attachments')->where('uri_type=' . $db->quote('url')); $db->setQuery($query); $attachments = $db->loadObjectList(); if ($db->getErrorNum()) { $errmsg = $db->stderr() . ' (ERR 83)'; JError::raiseError(500, $errmsg); } if (count($attachments) == 0) { return JText::_('ATTACH_NO_ATTACHMENTS_WITH_URLS'); } $IDs = array(); foreach ($attachments as $attachment) { $IDs[] = $attachment->id; } // Update the system filenames for all the attachments require_once JPATH_SITE . '/components/com_attachments/helper.php'; JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_attachments/tables'); $attachment = JTable::getInstance('Attachment', 'AttachmentsTable'); $numUpdated = 0; $numChecked = 0; foreach ($IDs as $id) { $attachment->load($id); $a = new JObject(); AttachmentsHelper::get_url_info($attachment->url, $a, false, false); if ($attachment->url_valid != $a->url_valid) { $attachment->url_valid = $a->url_valid; // Maybe update the file info with fresh info if ($a->url_valid) { $attachment->file_size = $a->file_size; $attachment->file_type = $a->file_type; } // Update the record if (!$attachment->store()) { $errmsg = $attachment->getError() . ' (ERR 84)'; JError::raiseError(500, $errmsg); } $numUpdated++; } $numChecked++; } return JText::sprintf('ATTACH_VALIDATED_N_URL_ATTACHMENTS_M_CHANGED', $numChecked, $numUpdated); }