WebFM is a hierarchical file system manager. WebFM does not use a flat file system (a single directory indexed by a database). WebFM allows users to arrange files on the server in the same way they do on their local storage drives. This ability to heirarchically arrange files greatly enhances the managability of large collections of data.
WebFM uses Ajax to provide application intensive functionality such as drag-and-drop and context-sensitive menuing. JavaScript must be enabled for WebFM to function - functionality will not gracefully degrade for clients that have JavaScript disabled.
Installation & Configuration
Download the official release from the project page.
Unzip the archive and copy the \'webfm\' directory to your modules directory (ie:/sites/all/modules). Alternatively copy the tarball to the module directory if you can unzip it on the server.
Enable the module on Drupal\'s admin/build/modules page. An install file updates the database with the necessary table additions.
Configure the module at admin/settings/webfm. Note: The configuration assumes that the \'File system path:\' is set in the usual way at %file-sys. All WebFM directories are sub-directories of this \'File System\' path. Set \'Download method:\' radio to \'Public\' since the module manages downloads.
Create the \'WebFM root directory\'. If this directory doesn\'t already exist, the system will create it in the \'File System\' root. Directory creation is not recursive so multi directory root paths must already exist inside the \'File System\' directory. Set the directory permissions to 775 if the server is linux/bsd.
The icon path allows the user to substitute their own gifs. File names are hardcoded in the javascript so the icons will have to have identical names.
The \'Maximum resolution for uploaded images\' input functions in the same fashion as the upload.module.
The \'Date Format\' radio buttons set the day/month order in the browser listing date field.
The \'Display metadata title\' checkbox sets the browser to display metadata titles rather than the actual filename if the metadata tile exists. Renaming files that use the metadata title must be done via the metadata editor. Note that node attachments always display the metadata title if available.
\'Default File Permissions\' set the file level permissions for files inserted into the database. The exception is file uploads that create a version overwrite whereby the new file inherits the permissions from the previous file.
Roles that are granted the \'access webfm\' permission will receive additional configuration fields for root path, extension white list, max upload file size and max total upload size. Roles with the \'access webfm\' right but without a root directory cannot access the filesystem.
Roles granted the \'attach WebFM files\' permission will be able to see and download attached files. \'Attachment List Properties\' sets the presentation of attached files.
The \'IE Drag-and-Drop Normalization\' is a sub-optimal solution for compensating for relative positioning in theme css. This feature is only available to #1 user.
The \'Webfm javascript debug\' checkbox is only useful for users interested in looking under the covers or who want to develop the module.
The WebFM cron is a \'stored procedure\' used for database cleanup of file records that are deleted outside of the WebFM interface (ie: OS shell, ftp). This feature is only available to #1 user.
Set WebFM rights in admin/user/access per role.
\'administer webfm\' confers full rights to a role. Admins can see and operate on all files, including files not in the database. Only admins can create directories and access admin/settings/webfm.
\'access webfm\' allows a role to download/view files via the WebFM browser. Only files referenced by the webfm_file table in the database are accessible. Only owners of a file (and admins) can move a file or modify it\'s metadata.
\'view webfm attachments\' allows a role to see files attached to nodes via WebFM.
\'webfm upload\' allows a role with the \'access webfm\' right to upload files via the WebFM browser. The user who uploads a file is the the owner of that file.
Admins and File owners can set the following file level permissions from the context menu of each file:
Public download: Allows the file to be downloaded anonymously even if .htaccess exists.
Role View/Download: Allows users of the same role to view/download the file.
Role Attach: Allows users of the same role to attach the file to nodes.
Role Full Access: Allows users of the same role to have the same rights to the file as the owner with the exception of permission edits.
Enable attachments in admin/settings/content-types/*type* for each content type that will accept attachments (default is disabled).
A .htaccess file (apache servers) can be placed in the WebFM root (or sub-path) to secure file access. Webfm streams downloads and thus your browser doesn\'t require direct http access to the directories
Updating the menu cache by navigating to admin/build/menu may be necessary if upgrading from an earlier version of the module with different internal paths.
Translations of the module require revising the string array at the top of webfm.js.
Usage
There are many ways to setup a file system hierarchy. The rules of any given system must be applied carefully if security of data is important.
The basic rules for users in a role with \'access webfm\' rights:
The role root directory defines the domain and all subdirectories are accessible to the user.
The user cannot navigate above the role root directory.
Only files in the webfm_file table are accessible. Files uploaded by the user are owned by the user and are automatically in the database. Only module admins can view/operate on files not in the database.
The user has full control over files that he/she owns that stay within an accessible role root domain. File permissions can be locked down so that only the owner/admins can see or operate on a file. File permissions can be opened up so that anyone within the role can view or operate on the file.
Users with \'access webfm\' rights cannot create/delete/move/rename directories. Only module administrators (users with \'administer webfm\' permission or #1 user) can control the directory structure.
Roles with \'access webfm\' rights can be subsets of other roles with \'access webfm\' rights or they can be exclusive. Users can be members of multiple roles and will consequently have a separate left-hand tree for each unique root directory (roles can even share the same root directory). It is difficult to foresee how diverse users of the module will choose to set up their systems but the following simple examples are typical arrangements. Both examples presume that the drupal file-system directory is set to \'files\', the WebFM module is installed and the \'WebFM root directory\' is set to \'webfm\'.
Example 1
The site requires 1 class of privileged users (A) to administer the file system and 2 classes of WebFM users (B & C) with access to file resources. Both roles will be able to upload files. Some WebFM users are members of both B & C while others are members of only one. Uploaded files are by default only accessible by the file owner and admins.
A site administrator will create 3 the roles A, B and C. Role A will have the \'administer webfm\' permission set in .../admin/user/access. B & C will have the \'access webfm\' and the \'webfm upload\' permission set.
WebFM settings will now have a fieldset for roles B & C where the root directory for each role is set. The root of B is set to \'B\' which automatically creates the \'files/webfm/B\' directory. The root of C is set to \'C\' which creates the directory \'files/webfm/C\'. A user who is a member of only one of B or C will see a single left-hand directory tree that contains their domain. They will have no access to files within the other role domain. Users who are members of both B & C will have two left-hand directory trees and have the ability to move files they own or control between the two domains. Role A\'s root directory is the \'WebFM root directory\' and thus A users see only a single left-hand tree of the entire module file-sys.
In WebFM settings, the \'Default File Permissions\' are configured with all checkboxes unset. This combination of default file permissions means that files that are uploaded will initially only be viewable by the B or C user doing the upload (owner) and by A users. Individual file permissions are editable by the file owner or A user to permit other users to view/attach/modify the file. One consequence of granting the permission \'Role Full Access\' is that a non-admin user with a single domain could lose contact with their own file if a dual domain non-admin user moves it to the other domain.
Example 2
The site requires 1 class of privileged users (A) to administer the file system and 2 classes of users (B & C) with access to file resources. C is determined to be a subset of B such that B can access it\'s own files as well as those of C. C will not be able to upload files to the browser but will only be able to view/download or attach files to nodes. B will be able to upload files.
A site administrator will create 3 the roles A, B and C. Role A will have the \'administer webfm\' permission set in .../admin/user/access. B & C will have the \'access webfm\' permission set. B will also have the \'webfm upload\' permission set.
WebFM settings will now have a fieldset for roles B & C where the root directory for each role is set. First the root of B is set to \'B\' which automatically creates the \'files/webfm/B\' directory. Next the root of C is set to \'B/C\' which creates the directory \'files/webfm/B/C\'. Since C is a sub-dir of B, role B will have access to C but C will not be able to navigate above it\'s root to see B\'s files. The left-hand directory tree will appear different for B & C. B\'s tree will start at \'B\' and have a \'C\' sub-directory (and potentially other sub-directories as set up by A). C\'s tree is a subset of B\'s tree. Role A\'s root directory is the \'WebFM root directory\'.
In WebFM settings, the \'Default File Permissions\' are configured with \'Role View Access\' and \'Role Attach Access\' set. This combination of file permissions means that files that a B user uploads/moves into the C realm will by default be viewable by C and be attachable to nodes that C creates. A B file owner can manually modify the file permissions of each individual file to hide it or prevent it from being attached to content by a C user. Likewise the file permissions can be opened so that a C user can edit file attributes or move the file into another sub-directory of C.
In the above examples the site administrator may simply create the roles/access rules and then let an A user configure WebFM for B & C.
Uninstall
Disable the module on the /admin/build/modules page
Click on the uninstall tab and select the module for removal. This will automatically drop the webfm_file and webfm_attach tables as well as all configuration variables. NOTE: This action will permanently discard all attachment and metedata information and cannot be undone. Execute the first step only if you wish to restore WebFM later without loss of data.
Onunload event handling in template
To explicitly destroy the event closures to minimize browser memory leaks an unload event needs to fire. Unfortunately the control of the body tag happens in the template. Add this function to template.php:
Add the following inside the php tag of the body tag of page.tpl.php:
print phptemplate_unload();
',
array('%file-sys' => url('admin/settings/file-system')));
return $output;
case 'admin/modules#description':
return t('Enable the Web File Manager.');
}
}
/**
* Implementation of hook_link().
*/
function webfm_link($type, $node = NULL, $teaser = FALSE) {
$links = array();
// Display a link with the number of attachments
if ($teaser && $type == 'node' && isset($node->webfm_files) && user_access('view webfm attachments')) {
if($num_files = count($node->webfm_files)) {
$links['webfm_attachments'] = array(
'title' => format_plural($num_files, '1 attachment', '@count attachments'),
'href' => "node/$node->nid",
'attributes' => array('title' => t('Read full article to view attachments.')),
'fragment' => 'attachments');
}
}
return $links;
}
/**
* Implementation of hook_perm().
*/
function webfm_perm() {
return array('access webfm', 'view webfm attachments', 'administer webfm', 'webfm upload');
}
/**
* Implementation of hook_menu().
*/
function webfm_menu() {
$items = array();
$items['webfm'] = array(
'title' => 'Web File Manager',
'page callback' => 'webfm_main',
'access callback' => 'user_access',
'access arguments' => array('access webfm'),
'type' => MENU_NORMAL_ITEM,
);
$items['admin/settings/webfm'] = array(
'title' => 'Web File Manager',
'description' => 'Configure root directories, default file permissions for uploads, upload size limits, attachments, permitted file extensions and formatting.',
'file' => 'webfm.admin.inc',
'page callback' => 'drupal_get_form',
'page arguments' => array('webfm_admin_settings'),
'access arguments' => array('administer webfm'),
'type' => MENU_NORMAL_ITEM,
);
$items['webfm_js'] = array(
'title' => 'Web File Manager',
'page callback' => 'webfm_ajax',
'access callback' => 'user_access',
'access arguments' => array('access webfm'),
'type' => MENU_CALLBACK,
);
$items['webfm/upload'] = array(
'title' => 'Web File Manager',
'page callback' => 'webfm_upload',
'access callback' => 'user_access',
'access arguments' => array('access webfm'),
'type' => MENU_CALLBACK,
);
$items['webfm_send'] = array(
'title' => 'File Not Found',
'page callback' => 'webfm_send_file',
'access callback' => TRUE,
'type' => MENU_CALLBACK,
);
$items['webfm_popup'] = array(
'title' => 'Web File Manager',
'page callback' => 'webfm_popup',
'access arguments' => array('access webfm'),
'type' => MENU_CALLBACK,
);
return $items;
}
/**
* Implementation of hook_block().
*/
function webfm_block($op = 'list', $delta = 0) {
if ($op == 'list') {
$blocks[0]['info'] = t('WebFM File Attachments');
return $blocks;
}
else if ($op == 'view' &&
user_access('access content') &&
user_access('view webfm attachments')) {
$block['content'] = webfm_attach_box();
$block['subject'] = t('Attachments');
return $block;
}
}
/**
* Implementation of hook_cron().
*/
function webfm_cron() {
//cleanup any corrupted file records that have no physical files
//Warning - running this after renaming a directory outside of WebFM will
// delete all file records contained in that directory
if(variable_get('webfm_cron','')) {
$result = db_query('SELECT fpath, fid FROM {webfm_file}');
while ($f = db_fetch_array($result)) {
if(!(is_file($f['fpath']))) {
_webfm_dbdelete_file_fid($f['fid']);
}
}
}
}
/**
* Implementation of hook_comment().
*
* Similar to webfm_nodeapi, but for comments instead of nodes.
* Note: Enabling webfm in the edit form is done in form_alter. Keeping the
* attachments while preview or a failing form_validate is done by form_alter
* and webfm_ajax.
* webfm_comment is only needed to save the attachments to the table and
* for viewing and previewing comments.
* We don't need to initialize js in 'validate' here because a failing form
* validation re-initializes the whole node, including js.
*/
function webfm_comment(&$comment, $op) {
if (is_object($comment)) {
$cid = $comment->cid;
$nid = $comment->nid;
}
else {
$cid = $comment['cid'];
$nid = $comment['nid'];
}
# We need the parent node for checking its permission to view attachments etc.
$node = node_load($nid);
switch ($op) {
case 'view':
if (variable_get("wfm_attach_$node->type", 1) == 1 &&
user_access('view webfm attachments') &&
variable_get('webfm_attach_body', '')) {
// If we preview a comment, $comment->preview is defined because the preview button
// for comments is added with $form['preview']. Thus we know that $_POST['attachlist']
// is ours. If we are previewing another comment and just "view" this one,
// the preview flag is not set and $_POST['attachlist'] belongs to someone else.
// This happens when previewing or editing a comment and the node and/or
// other comments might be shown, too.
// If we preview without 'acces webfm' permissions, we fetch from database,
// cf. nodeapi below.
if ($comment->preview && user_access('access webfm')) {
if ($_POST['attachlist']) {
$show_files = webfm_get_temp_attachments($_POST['attachlist']);
}
}
else {
// Normal view. Try to load attachments. There is no 'load' op for hook_comment.
if (!isset($comment->webfm_files)) {
$comment->webfm_files = webfm_get_attachments($cid, 'cid');
}
if (is_array($comment->webfm_files) && count($comment->webfm_files)) {
$show_files = $comment->webfm_files;
}
}
if ($show_files) {
$comment->comment .= theme('webfm_attachments', $show_files);
drupal_add_css(drupal_get_path('module', 'webfm').'/css/webfm.css');
}
}
break;
case 'insert':
if ($_POST['attachlist']) {
$files = explode(',', $_POST['attachlist']);
$i = 0;
foreach ($files as $fid) {
if ($fid)
// weight argument determined by position in csv
webfm_dbinsert_attach(0, $fid, $i++, $cid);
}
}
break;
case 'update':
// If the user cannot access webfm, $_POST['attachlist'] is always empty
// and therefore will delete existing attachments from the node.
if (user_access('access webfm')) {
$files = explode(',', $_POST['attachlist']);
webfm_dbupdate_attach(0, $files, $cid);
}
break;
case 'delete':
webfm_dbdelete_attachments($cid, 'cid');
break;
}
}
/**
* Implementation of hook_nodeapi().
*/
function webfm_nodeapi(&$node, $op, $teaser) {
global $user, $base_url, $base_path;
switch ($op) {
case 'load':
if((variable_get("wfm_attach_$node->type", 1) == 1) &&
user_access('view webfm attachments')) {
$output['webfm_files'] = webfm_get_attachments($node->nid);
return $output;
}
break;
case 'view':
// Add the attachments list to node body if configured to appear in body.
if(variable_get('webfm_attach_body', '')) {
// We could be viewing or previewing this node.
// Loading a node defines $node->webfm_files, possibly as empty list,
// but loading an edit form unsets $node->webfm_files again. Thus, if
// $node->webfm is not set, we are previewing this node.
// Two cases then:
// 1) The user has no webfm access rights, so he can't change anything
// and $_POST['attachlist'] is empty. Simulate the 'load' operation
// to get the files from the database to show them in the preview.
// 2) If user has webfm access, all attachments (saved/unsaved)
// are in $_POST['attachlist']. But $_POST['attachlist'] is also set if
// we preview e.g. a comment where this node is shown, too, but then
// the attachlist is not ours. So we check for webfm_files *before*
// checking for $_POST to get around this.
if (!user_access('access webfm') && (variable_get("wfm_attach_$node->type", 1) == 1)
&& user_access('view webfm attachments')) {
$node->webfm_files = webfm_get_attachments($node->nid);
}
if(isset($node->webfm_files) && is_array($node->webfm_files)) {
if(count($node->webfm_files) && !$teaser) {
$show_files = $node->webfm_files;
}
}
// We must check for view permissions in a preview, but wfm_attach_$node->type
// is true if we already have attachments here.
elseif(isset($_POST['attachlist']) && user_access('view webfm attachments')) {
$show_files = webfm_get_temp_attachments($_POST['attachlist']);
}
if(isset($show_files) && is_array($show_files)) {
$node->content['webfm_attachments'] = array(
'#value' => theme('webfm_attachments', $show_files),
'#weight' => 10);
drupal_add_css(drupal_get_path('module', 'webfm').'/css/webfm.css');
}
}
break;
case 'validate':
// When form_validate fails for preview or save, we must reinitialize
// javascript, otherwise webfm doesn't work anymore.
$modulepath = drupal_get_path('module', 'webfm');
drupal_add_js($modulepath .'/js/webfm.js');
drupal_add_css($modulepath .'/css/webfm.css');
if(is_null($inline_js)) {
$clean_url = variable_get('clean_url', 0);
$clean = (($clean_url == 0) || ($clean_url == '0')) ? FALSE : TRUE;
$inline_js = webfm_inline_js($base_url, $base_path, $clean, $user->uid);
}
break;
case 'insert':
// We saved the attachment list for preview. Remove before saving.
unset($node->attachlist);
if($_POST['attachlist']) {
$files = explode(',', $_POST['attachlist']);
$i = 0;
foreach($files as $fid) {
if($fid)
// weight argument determined by position in csv
webfm_dbinsert_attach($node->nid, $fid, $i++);
}
}
break;
case 'update':
// If the user cannot access webfm, $_POST['attachlist'] is always empty
// and therefore will delete existing attachments from the node.
if(user_access('access webfm')) {
$files = explode(',', $_POST['attachlist']);
webfm_dbupdate_attach($node->nid, $files);
}
break;
case 'delete':
webfm_dbdelete_attachments($node->nid);
break;
}
}
/**
* Implementation of hook_form_alter().
*/
function webfm_form_alter(&$form, &$form_state, $form_id) {
global $base_url, $base_path, $user;
if(($user->uid == 1) || user_access('administer webfm') || user_access('access webfm'))
$access = TRUE;
else
$access = FALSE;
if ($form_id == 'node_type_form' && $access) {
$form['workflow']['webfm_attach'] = array(
'#type' => 'radios',
'#title' => t('WebFM Attachments'),
'#default_value' => variable_get('webfm_attach_'.$form['#node_type']->type, 0),
'#options' => array(0 => t('Disabled'), 1 => t('Enabled')),
'#description' => t('Should this content type allow upload & file attachment via WebFM?'),
);
}
if (isset($form['type']) || $form_id == 'comment_form') {
// For a comment form, the webfm permissions are inherited from the comments node.
if ($form_id == 'comment_form') {
$node = node_load($form['nid']['#value']);
$formcheck = TRUE;
}
else {
$node = $form['#node'];
$formcheck = ($form['type']['#value'] .'_node_form' == $form_id);
}
if ($access && $formcheck && variable_get('webfm_attach_'. $node->type, 0)) {
$modulepath = drupal_get_path('module', 'webfm');
drupal_add_js($modulepath.'/js/webfm.js');
drupal_add_css($modulepath.'/css/webfm.css');
if(is_null($inline_js)) {
$clean_url = variable_get('clean_url', 0);
$clean = (($clean_url == 0) || ($clean_url == '0')) ? FALSE : TRUE;
$inline_js = webfm_inline_js($base_url, $base_path, $clean, $user->uid);
}
// Attachments fieldset
$form['webfm-attach']['#theme'] = 'webfm_upload_form';
$form['webfm-attach']['attach'] = array(
'#type' => 'fieldset',
'#title' => t('WebFM Attachments'),
'#description' => t('Drag attachments to set order. Changes made to the attachments are not permanent until you save this post.'),
'#collapsible' => TRUE,
'#collapsed' => TRUE,
'#weight' => 29,
);
$form['webfm-attach']['attach']['attachedfiles'] = array(
'#prefix' => '
'."\n";
return $output;
}
function webfm_upload_fieldset() {
$form = array();
$form['webfm_uploads'] = array(
'#type' => 'fieldset',
'#title' => t('File Upload'),
'#collapsible' => TRUE,
'#collapsed' => TRUE,
'#description' => t('Uploaded file will be saved to the current directory.'),
'#prefix' => '
',
'#suffix' => '
',
'#weight' => 30);
// Wrapper for fieldset contents (used by upload JS).
// NOTE: upload.js requires six char prefix on wrapper/button names
$form['webfm_uploads']['wrapper'] = array(
'#prefix' => '
',
'#suffix' => '
');
$form['webfm_uploads']['wrapper'] += webfm_upload_form('webfm/upload');
$form['#attributes'] = array('enctype' => "multipart/form-data");
return $form;
}
function webfm_upload_form($upload_url) {
$form['#theme'] = 'webfm_upload_form';
// This div is hidden when the user uploads through JS.
$form['new'] = array( '#prefix' => '
', '#suffix' => '
');
// this following key used by file_check_upload(()
$form['new']['webfm_upload'] = array('#type' => 'file', '#title' => t('Upload file'), '#size' => 40);
$form['new']['wfmatt'] = array('#type' => 'button', '#value' => t('Upload'), '#name'=> 'attach', '#id' => 'wfmatt-button');
// Hidden input field for js to supply current directory value
$form['webfmuploadpath'] = array('#type' => 'hidden', '#value' => '');
// The class triggers the js upload behaviour.
$form['wfmatt-url'] = array('#type' => 'hidden', '#value' => url($upload_url, array('absolute' => TRUE)), '#attributes' => array('class' => 'webfmupload'));
return $form;
}
function webfm_version_form($filename) {
$form['select'] = array(
'#prefix' => '
',
'#suffix' => '
',
'#type' => 'radios',
'#title' => t('Select File Versioning Option'),
'#options' => array('Replace and rename original copy of '.$filename,'Replace and delete original copy of '.$filename,'Rename new copy of '.$filename,'Cancel'),
'#required' => TRUE,
);
return $form;
}
/**
* Theme the attachment form.
* Note: required to output prefix/suffix.
*/
function theme_webfm_upload_form($form) {
$output = drupal_render($form);
return $output;
}
/**
* Inline javascript
* Function to pass base_url, icon directory, debug and cleanurl flags
*/
function webfm_inline_js($base_url, $base_path, $clean_url, $uid) {
$js = '' ;
drupal_set_html_head($js);
return $js;
}
/**
* Helper function to check for root path at base of input path
*/
function webfm_check_path($path, $root) {
if(strncmp($path, $root, strlen($root)) == 0) {
if((strlen($path) == strlen($root)) ||
(substr($path, strlen($root), 1) == '/')) {
return $path;
}
}
return '';
}
/**
* Helper function to get root path of webfm
*/
function webfm_get_root_path () {
static $webfm_root_path;
//Get root directory of module
if(empty($webfm_root_path)) {
$webfm_root_path = variable_get('webfm_root_dir', '');
if(empty($webfm_root_path)) {
$webfm_root_path = NULL;
} else {
$webfm_root_path = '/'.$webfm_root_path;
}
}
return $webfm_root_path;
}
/**
* Helper function to get array of role root directories for a user
*/
function webfm_get_access_roles($flush = FALSE) {
static $webfm_access_roles = array();
if($flush)
$webfm_access_roles = array();
// Roles with 'access webfm' perm
if(!count($webfm_access_roles)) {
//allow anonymous role to have 'access webfm' right
$webfm_access_roles = user_roles(0, 'access webfm');
}
return $webfm_access_roles;
}
function webfm_get_root_dirs($flush = FALSE) {
global $user;
static $webfm_roots = array();
$webfm_access_roles = webfm_get_access_roles($flush);
$webfm_roots = array();
foreach($user->roles as $rid => $role) {
if(array_key_exists($rid, $webfm_access_roles)) {
// Roles with 'access webfm' perm that user possesses
$path = variable_get("root_dir_".$rid, '');
if(!empty($path)) {
// Prevent redundant trees for roles with common root dir
if(!in_array($path, $webfm_roots)) {
$webfm_roots[$rid] = "/".$path;
}
}
}
}
//If anonymous role has webfm access...
if(array_key_exists(1, $webfm_access_roles)) {
$path = variable_get("root_dir_1", '');
if(!empty($path)) {
$webfm_roots[1] = "/".$path;
}
}
return $webfm_roots;
}
/**
* Helper function to determine if a webfm_file record is modifiable by a
* user with 'access webfm'
*/
function webfm_file_mod_access($webfm_file) {
if((int)$webfm_file->perm & WEBFM_FILE_ACCESS_ROLE_FULL) {
return webfm_path_access($webfm_file->fpath);
}
return FALSE;
}
/**
* Helper function to determine if a webfm_file record is viewable by a
* user with 'access webfm'
*/
function webfm_file_view_access($webfm_file) {
if((int)$webfm_file->perm & WEBFM_FILE_ACCESS_ROLE_VIEW) {
return webfm_path_access($webfm_file->fpath);
}
return FALSE;
}
function webfm_file_att_access($webfm_file) {
if((int)$webfm_file->perm & WEBFM_FILE_ACCESS_ROLE_ATTACH) {
return webfm_path_access($webfm_file->fpath);
}
return FALSE;
}
/**
* Helper function to determine if a path is accessible by a user with 'access webfm'
*/
function webfm_path_access($path) {
//admins don't call this routine so include webfm root path
$root_dir = file_directory_path().webfm_get_root_path();
$webfm_roots = webfm_get_root_dirs();
foreach($webfm_roots as $key => $sub_root) {
// The read path must be contained within a legitimate role root dir for this user
if(webfm_check_path($path, $root_dir.$sub_root)) {
return TRUE;
}
}
return FALSE;
}
/**
* Helper function to set default file permissions
*/
function webfm_default_file_perm() {
$perm = (int)(variable_get('webfm_file_perm_role', '') ? WEBFM_FILE_ACCESS_ROLE_VIEW : 0);
$perm += (int)(variable_get('webfm_file_perm_mod', '') ? WEBFM_FILE_ACCESS_ROLE_FULL : 0);
$perm += (int)(variable_get('webfm_file_perm_attach', '') ? WEBFM_FILE_ACCESS_ROLE_ATTACH : 0);
$perm += (int)(variable_get('webfm_file_public', '') ? WEBFM_FILE_ACCESS_PUBLIC_VIEW : 0);
return $perm;
}
/**
* Helper function to get date format string
*/
function webfm_get_date_format() {
static $dateformat;
if(!$dateformat) {
$date_format_type = (variable_get('webfm_date_format', WEBFM_DATE_FORMAT_DAY));
switch($date_format_type)
{
case WEBFM_DATE_FORMAT_MONTH:
$dateformat = 'm/d/y g:i a';
break;
case WEBFM_DATE_FORMAT_DAY:
default:
$dateformat = 'd/m/y g:i a';
break;
}
}
return $dateformat;
}
/**
* Class to build the directory, file and breadcrumb listings
* ..for the directory at $path for javascript Load_dirlist()
*/
class webfm_build_dir_list {
var $dirs = array();
var $files = array();
var $breadcrumb = array();
//Constructor
function webfm_build_dir_list($root, $path, $perm) {
global $user;
$bl = array('.', '..', '.htaccess');
$_dirs = array();
$_files = array();
$full_path = $root.$path;
if(is_dir($full_path)) {
chdir($full_path);
if($handle = opendir('.')) {
// breadcrumb keeps file-sys root hidden
$non_root_arr = explode('/', trim($path, '/'));
foreach($non_root_arr as $piece) {
$this->breadcrumb[] = $piece;
}
while(($readdir = readdir($handle)) !== false) {
// check that directory element is readable and not in black list
if(!in_array(strtolower($readdir), $bl)){
if(is_dir($readdir))
$_dirs[] = $readdir;
if(is_file($readdir))
$_files[] = $readdir;
}
}
closedir($handle);
}
if(is_array($_dirs)) {
foreach($_dirs as $dir) {
$dd = new stdClass();
$dd->n = $dir;
$dd->p = $path."/".$dir;
$dd->m = (filemtime($dir)) ? @filemtime($dir) : "";
$this->dirs[] = $dd;
}
}
if(is_array($_files)) {
foreach($_files as $file) {
if($_file = webfm_get_file_record('', $full_path.'/'.$file)) {
if(($perm == WEBFM_ADMIN) ||
($_file->uid == $user->uid) ||
((int)$_file->perm & WEBFM_FILE_ACCESS_ROLE_FULL) ||
((int)$_file->perm & WEBFM_FILE_ACCESS_ROLE_VIEW)) {
$fd = new stdClass();
$fd->id = $_file->fid;
if((int)$_file->perm & WEBFM_FILE_ACCESS_ROLE_FULL) {
// A bit of a hack for js functionality but safe since this is
// always validated on server side
$fd->u = $user->uid;
} else {
$fd->u = $_file->uid;
}
$_query = 'SELECT name FROM {users} WHERE uid = %d';
$fd->un = db_result(db_query($_query, $_file->uid));
$fd->m = @filemtime($file);
$fd->s = @filesize($file);
} else {
// permission denied to view this file
continue;
}
} else if($perm == WEBFM_ADMIN) {
$fd = new stdClass();
$fd->id = 0; //invalid fid signals no db entry
$fd->u = 0; //file has no owner
$_query = 'SELECT name FROM {users} WHERE uid = %d';
$fd->un = db_result(db_query($_query, $fd->u));
$fd->m = @filemtime($file);
$fd->s = @filesize($file);
} else {
// permission denied to view this file
continue;
}
if(variable_get('webfm_display_title', '') && $_file->ftitle) {
$fd->ftitle = urldecode($_file->ftitle);
}
$fd->n = $file;
$fd->p = $path;
$fd->i = 0;
if(strpos($file, ".") === FALSE) {
$fd->e = "";
} else {
$fd->e = array_pop(explode('.', $file));
$mime_type = file_get_mimetype($file);
if(preg_match('/^image/', $mime_type)) {
if(!function_exists('exif_imagetype')) {
if($i = @getimagesize($file)) {
//if valid width/height...
if(($i[0] != 0) && ($i[1] != 0)) {
//return type
$fd->i = $i[2];
}
}
} else if($i = @exif_imagetype($file)) {
$fd->i = $i;
}
}
}
$this->files[] = $fd;
}
}
}
}
function get_dir_listing() {
return $this->dirs;
}
function get_file_listing() {
return $this->files;
}
function get_breadcrumb() {
return $this->breadcrumb;
}
}
/**
* Build directory tree
*/
function webfm_tree($rootpath, $path) {
if(!isset($_SESSION['tree_'.$path])) {
$tree = array();
$tree[$path] = recurse_build_tree($rootpath.$path, false);
$_SESSION['tree_'.$path] = $tree;
return $tree;
}
return $_SESSION['tree_'.$path];
}
// Function to recursively read the complete directory tree
function recurse_build_tree($dir, $full) {
if ($handle = opendir($dir)) {
while (false !== ($readdir = readdir($handle))) {
if(($readdir != '.') && ($readdir != '..')) {
$path = $dir.'/'.$readdir;
//directories are array keys with an array value or a null value for
//empty directories (note that a file cannot have a null value)
if(is_dir($path)) {
$tree[$readdir] = recurse_build_tree($path, $full);
}
if($full == true) {
//files are non-null, non-array key values
if(is_file($path))
$tree[] = $readdir;
}
}
}
closedir($handle);
}
return isset($tree)?$tree:'';
}
function webfm_get_attachments($nid, $selector = 'nid') {
// If anything but a existing nid/cid is passed, it is equivalent to 0. This
// happened in webfm_ajax in the past. Although we fixed it there, make sure
// that we never run into this, because now there are entries with nid/cid=0.
if ($nid == 0) {
return array();
}
$files = array();
$file_result = db_query("SELECT * FROM {webfm_file} f INNER JOIN {webfm_attach} a ON f.fid = a.fid WHERE a.%s = %d ORDER BY a.weight", $selector, $nid);
while($file_record = db_fetch_object($file_result)) {
$_file = new webfm_fdesc($file_record);
if($_file->result == TRUE) {
$files[] = $_file;
}
}
return $files;
}
/**
* Return file descriptors for an attachment that have not yet been saved.
* This happens on previewing posts.
*
* @param array $fids - a comma separated list of fids.
* @return array of file descriptors.
*/
function webfm_get_temp_attachments($fids) {
$files = array();
$fids_arr = split(',', $fids);
$file_result = db_query('SELECT * FROM {webfm_file} WHERE fid in ('. db_placeholders($fids_arr) .')', $fids_arr);
while($file_record = db_fetch_object($file_result)) {
$_file = new webfm_fdesc($file_record);
if($_file->result == TRUE) {
$files[] = $_file;
}
}
return $files;
}
/**
* File description class
*/
class webfm_fdesc {
var $result;
// Constructor:
function webfm_fdesc($file) {
$cwd = getcwd();
$this->result = FALSE;
$dir = dirname($file->fpath);
//assume the object $file record path has a directory before the file name
if (is_dir($dir)) {
if(chdir($dir)) {
if($handle = opendir('.')) {
while(($readdir = readdir($handle)) !== false) {
if(is_dir($readdir))
continue;
if(is_file($readdir) && ($readdir == basename($file->fpath))) {
$this->id = $file->fid;
$this->n = strrev(substr(strrev($file->fpath), 0, strpos(strrev($file->fpath), '/')));
$this->p = $dir;
$this->e = array_pop(explode('.', $this->n));
$this->s = $file->fsize;
$this->uid = $file->uid;
$_query = 'SELECT name FROM {users} WHERE uid = %d';
$this->un = db_result(db_query($_query, $file->uid));
// urldecode required for fields where user input is urlencoded
$this->ftitle = urldecode($file->ftitle);
$this->fdesc = urldecode($file->fdesc);
$this->fcreatedate = $file->fcreatedate;
$this->flang = urldecode($file->flang);
$this->fpublisher = urldecode($file->fpublisher);
$this->fformat = urldecode($file->fformat);
$this->fversion = $file->fversion;
$this->m = (filemtime($readdir)) ? @filemtime($readdir) : "";
$this->result = TRUE;
break;
}
}
closedir($handle);
}
// Restore current working directory
chdir($cwd);
}
}
}
}
/**
* Function to sanitize long filenames
*/
function webfm_sanlen($x) {
if(strlen($x) > 80)
return substr($x, 0, 40)."...".substr($x, -40, 40);
return $x;
}
/**
* Class to search for files matching a regexp pattern
*/
class webfm_searchFiles {
var $count = 0;
var $files = array();
var $hidefilepattern;
var $uid = 0;
//Constructor
function webfm_searchFiles($root_dir, $dir, $searchpattern, $regexpsearch = FALSE, $user) {
$this->hidefilepattern = "^(CVS|\..*)$";
/*
if(!$regexpsearch) {
$searchpattern = "^".str_replace("*", ".*", str_replace("?", ".", str_replace(".", "\.", $searchpattern)))."$";
}
*/
$this->uid = $user;
$this->searchFilesRecur($root_dir, $dir, $searchpattern);
}
function get_files() {
return $this->files;
}
function get_count() {
return $this->count;
}
function build_file_list($name, $path, $id) {
$sfd = new stdClass();
$sfd->n = $name;
$sfd->p = $path;
$sfd->id = $id;
$this->files[] = $sfd;
$this->count++;
}
function searchFilesRecur($root_dir, $dir, $searchpattern) {
$dir = rtrim($dir, '/');
//hide filesys root by not returning full path
$full_dir = $root_dir.$dir;
$handle = @opendir($full_dir);
while (($file = @readdir($handle))) {
if(@is_dir($full_dir."/".$file) && ($file != ".") && ($file != "..")) {
$this->searchFilesRecur($root_dir, $dir."/".$file, $searchpattern);
} else if (ereg(strtolower($searchpattern), strtolower($file)) && !ereg($this->hidefilepattern, $file)) {
if($frec = webfm_get_file_record('', $full_dir."/".$file)) {
//return files in db (role level permission)
if($this->uid == 1 || $this->uid == $frec->uid || webfm_file_view_access($frec))
$this->build_file_list($file, $dir, $frec->fid);
} else if($this->uid == 1) {
//admins can search files not in db
$this->build_file_list($file, $dir, 0);
}
}
}
@closedir($handle);
}
}
/**
* webfm_send_file - streams a file privately for download
*
* If $fid arg is numeric then file path is referenced via db, otherwise the arg
* ...is a urlencoded path that must be converted and concatenated to base file dir
*
* @param object $fid - file id
* @param bool $download - true=download / false=stream
* @param bool $bypass_invoke true=do no invoke webfm_send hook / false=invoke
*/
function webfm_send_file($fid, $download = false, $bypass_invoke = false) {
global $user;
$match = FALSE;
$f = false;
// User has either admin access, webfm access or view attach access
if(($user->uid == 1) || user_access('administer webfm')) {
// Admins have total access
$webfm_perm = WEBFM_ADMIN;
$match = TRUE;
} else if(user_access('access webfm')) {
$webfm_perm = WEBFM_USER;
} else if(user_access('view webfm attachments')) {
$webfm_perm = WEBFM_ATTACH_VIEW;
} else {
$webfm_perm = 0;
}
if(is_numeric($fid)) {
if(($f = webfm_get_file_record($fid)) === FALSE) {
return drupal_not_found();
} else {
if($f->uid == $user->uid)
// Even if file has been moved to an inaccessible dir this works
$match = TRUE;
}
} else if($webfm_perm == WEBFM_ADMIN) {
// Only allow admins to download files without fid
$f = new stdClass();
$str_arr = array();
$str_arr = split('[~]', rawurldecode($fid));
$f->fpath = file_directory_path()."/".implode('/', $str_arr);
if(!(is_file($f->fpath))) {
return drupal_not_found();
} else {
$match = TRUE;
}
} else {
return drupal_not_found();
}
// Files that have been attached are always considered public to whoever can
// access that node/comment (nodeaccess/commentaccess security).
if($match == FALSE && $webfm_perm != WEBFM_ADMIN) {
if($f->perm & WEBFM_FILE_ACCESS_PUBLIC_VIEW) {
$match = TRUE;
} else if($webfm_perm == WEBFM_USER || $webfm_perm == WEBFM_ATTACH_VIEW){
//Check if the file is attached to a node or comment.
$query = 'SELECT nid,cid FROM {webfm_attach} WHERE fid = %d';
$result = db_query($query, $f->fid);
if($result !== FALSE) {
while ($dbfid = db_fetch_array($result)) {
if ($dbfid['cid'] != 0 ) {
// For a comment, a user must be able to view the parent node and have "access_comments".
if (!user_access('access comments')) {
continue;
}
$comment = _comment_load($dbfid['cid']);
$dbfid['nid'] = $comment->nid;
}
$node = node_load($dbfid['nid']);
if (node_access('view', $node)) {
$match = TRUE;
break;
}
}
}
}
}
// Files that are viewable via the filebrowser UI are downloadable
if($match == FALSE &&
$webfm_perm == WEBFM_USER &&
(webfm_file_view_access($f) || webfm_file_mod_access($f))) {
$match = TRUE;
}
if(!$match) {
drupal_access_denied();
return;
}
// Hook to allow alternative file streaming
// Bypass allows 2nd pass of file through this function after work done
// in module using this hook
if($bypass_invoke === FALSE) {
$ret = module_invoke_all('webfm_send', $f);
if(array_key_exists('sent', $ret)) {
return;
}
}
$name=basename($f->fpath);
//filenames in IE containing dots will screw up the
//filename unless we add this
if(strstr($_SERVER['HTTP_USER_AGENT'], "MSIE"))
$name = preg_replace('/\./', '%2e', $name, substr_count($name, '.') - 1);
// Get file extension
$type = file_get_mimetype($name);
//download headers:
$header = array();
if($download === '1') {
// prompt for download file or view
$header[] = 'Pragma: no-cache';
$header[] = 'Cache-Control: no-cache, must-revalidate';
$header[] = 'Content-Disposition: attachment; filename="'.$name.'";' ;
if(!empty($f->fid)) {
$cnt = array();
$cnt['dl_cnt'] = (int)$f->dl_cnt + 1;
webfm_dbupdate_file($f->fid, '', $cnt);
}
} else {
// view file via browser
$header[] = 'Pragma: public'; // required
$header[] = 'Expires: 0';
$header[] = 'Cache-Control: must-revalidate, post-check=0, pre-check=0';
$header[] = 'Content-Transfer-Encoding: binary';
$header[] = 'Content-Disposition: inline; filename="'.$name.'";' ;
// consider an app run inside the browser as a 'download'
if(!empty($f->fid) && (strpos($type, "application") === 0)) {
$cnt = array();
$cnt['dl_cnt'] = (int)$f->dl_cnt + 1;
webfm_dbupdate_file($f->fid, '', $cnt);
}
}
$header[] = 'Content-Type: '.$type;
$header[] = 'Content-Length: '.(string)(@filesize($f->fpath));
$header[] = 'Connection: close';
//drupal file_transfer will fail if file is not inside file system directory
file_transfer($f->fpath, $header);
}
/**
* webfm_dbinsert_file - inserts a file object into the webfm_file table
*
* @param object $file - complete file object
* @param string &$error - reference to error string
* @param array $metadata - an array of key => value pairs, where key matches a field in the webfm_file table
*
* @return bool - TRUE if query executed successfully, otherwise FALSE
*/
function webfm_dbinsert_file($file, &$error, $metadata = array()){
//we need our user
global $user;
if(!isset($file->filepath)) {
$error = "No file path supplied";
return FALSE;
} else {
$metadata['fpath'] = $file->filepath;
}
// always a new record
unset($metadata['fid']);
// fill $metadata values not supplied in 3rd arg
if(!isset($metadata['uid']))
$metadata['uid'] = $user->uid;
if(!isset($metadata['fsize']))
$metadata['fsize'] = @filesize($file->filepath);
if(!isset($metadata['fcreatedate']))
$metadata['fcreatedate'] = @filemtime($file->filepath);
if(!isset($metadata['perm']))
$metadata['perm'] = webfm_default_file_perm();
if(!isset($metadata['fmime']))
$metadata['fmime'] = file_get_mimetype($file->filepath);
//create a string of fields for the query
$fields = implode(', ', array_keys($metadata));
//build printf style list of values
foreach($metadata as $key => $value){
if(is_numeric($value)){
$printfvalues[] = '%d';
} else {
$printfvalues[] = "'%s'";
}
}
//create a srting of printf style values
$printfvalues = implode(', ', $printfvalues);
//create an array of just the values for the db_query
$values = array_values($metadata);
//make a db_query friendly query with prinf stuff
$query = "INSERT INTO {webfm_file} ($fields) VALUES ($printfvalues)";
$result = db_query($query, $values);
if($result === FALSE){
$error = $file->filepath.' could not be inserted into db';
drupal_set_message(t('Could not insert %file into the database', array('%file' => $file->filepath)), error);
return FALSE;
} else {
// return fid to calling routine
$query = "SELECT fid FROM {webfm_file} WHERE fpath = '%s'";
$result = db_query($query, $file->filepath);
if(($result !== FALSE) && ($row = db_fetch_object($result))) {
return $row->fid;
} else {
return FALSE;
}
}
}
/**
* webfm_dbupdate_file - updates information about a file
*
* @param int $fid - file id of the file to record to be altered
* @param string $path string containing the destination path relative to drupal root
* @param array $metadata - an array of key => value pairs, where key matches a field in the webfm_file table
*
* @return bool - TRUE if success - else FALSE
*/
function webfm_dbupdate_file($fid, $path = FALSE, $metadata = array()){
if($path){
//add additional values to $metadata
$metadata['fpath'] = $path;
}
//create a string of field value items in printf format
foreach($metadata as $key => $value){
if(is_numeric($value)){
$printfvalues[] = $key .'=%d';
}
else{
$printfvalues[] = $key ."='%s'";
}
}
$printfvalues = implode(', ', $printfvalues);
$values = array_values($metadata);
$values[] = $fid; //tack on the fid at the end for the last param for the update query - i.e. WHERE fid = %d
//make a db_query friendly query with prinf stuff
$query = "UPDATE {webfm_file} SET $printfvalues WHERE fid = %d";
$result = db_query($query, $values);
if($result === FALSE){
drupal_set_message(t('webfm_dbupdate_file() err: fid=%fid', array('%fid' => $fid)), error);
return FALSE;
}
return TRUE;
}
/*
* Reduce number of db queries for role extension whitelist + regex format
*/
function webfm_get_extensions_regex($rid) {
static $role_ext_regex = array();
if($rid == WEBFM_FLUSH) {
//flush static array
$role_ext_regex = array();
return '';
}
if(!$role_ext_regex[$rid]) {
$extensions = variable_get("webfm_extensions_".$rid, '');
$role_ext_regex[$rid] = '/\.('. ereg_replace(' +', '|', preg_quote($extensions)) .')$/i';
}
return $role_ext_regex[$rid];
}
/*
* Check file extension to extension whitelist for db insert
*/
function webfm_enum_validate($file, &$err_msg){
global $user;
$name = $file->filename ? $file->filename : strrev(substr(strrev($file->filepath), 0, strpos(strrev($file->filepath), '/')));
if(strlen($name) > 255) {
$err_msg[] = 'file name has invalid length';
return FALSE;
}
if(($user->uid == 1) || user_access('administer webfm'))
return TRUE;
$webfm_access_roles = webfm_get_access_roles();
$num_roles = 0;
$error = 0;
foreach($user->roles as $rid => $role) {
if(array_key_exists($rid, $webfm_access_roles)) {
$num_roles++;
//compare file to extension whitelist for each role with 'access webfm'
$regex = webfm_get_extensions_regex($rid);
if (!preg_match($regex, $name)) {
$err_msg[] = $name.' has invalid extension for '.$role.' role.';
$error++;
}
}
}
return $error == $num_roles ? FALSE : TRUE;
}
/**
* webfm_upload_validate
* *
* @param object $file - file object
* @param string &$err_arr - ref to error array for client feedback
*
* @return bool - returns TRUE if there are no errors otherwise FALSE
*/
function webfm_upload_validate($file, &$err_arr){
global $user;
if($user->uid == 1)
return TRUE;
$copy_err = is_array($err_arr);
foreach ($user->roles as $rid => $name) {
$regex = webfm_get_extensions_regex($rid);
$uploadsize = variable_get("webfm_uploadsize_".$rid, 1) * 1024 * 1024;
$usersize = variable_get("webfm_usersize_".$rid, 1) * 1024 * 1024;
if (!preg_match($regex, $file->filename)) {
$error['extension']++;
}
if ($uploadsize && $file->filesize > $uploadsize) {
$error['uploadsize']++;
}
if ($usersize && $total_usersize + $file->filesize > $usersize) {
$error['usersize']++;
}
}
$user_roles = count($user->roles);
$valid = TRUE;
if ($error['extension'] == $user_roles) {
if($copy_err)
$err_arr[] = $file->filepath." has an invalid extension";
form_set_error('webfm_uploads', t('%name can not be uploaded because it does not have one of the following extensions: %files-allowed.', array('%name' => $file->filename, '%files-allowed' => $extensions)));
$valid = FALSE;
}
elseif ($error['uploadsize'] == $user_roles) {
if($copy_err)
$err_arr[] = $file->filepath." exceeds the max filesize";
form_set_error('webfm_uploads', t('%name can not be attached to this post, because it exceeded the maximum filesize of %maxsize.', array('%name' => $file->filename, '%maxsize' => format_size($uploadsize))));
$valid = FALSE;
}
elseif ($error['usersize'] == $user_roles) {
if($copy_err)
$err_arr[] = $file->filepath." exceeds the max disk quota";
form_set_error('webfm_uploads', t('%name can not be attached to this post, because the disk quota of %quota has been reached.', array('%name' => $file->filename, '%quota' => format_size($usersize))));
$valid = FALSE;
}
elseif (strlen($file->filename) > 255) {
if($copy_err)
$err_arr[] = $file->filepath." exceeds the max name length";
form_set_error('webfm_uploads', t('The selected file can not be attached to this post, because the filename is too long.'));
$valid = FALSE;
}
return $valid ? TRUE : FALSE;
}
/**
* Given a file path this function returns fid from the webfm file table
*
* @param string $path
* @return int $fid if one exists or FALSE if none was found
*/
function webfm_get_fid($path){
$query = "SELECT fid FROM {webfm_file} WHERE fpath = '%s'";
$result = db_query($query, $path);
if($result !== FALSE)
if($row = db_fetch_object($result))
return $row->fid;
return FALSE;
}
/**
* Given a file id or file path this function returns webfm_file table record
*
* @param int $fid
* @param string $path
* @return row object or FALSE if none was found
*/
function webfm_get_file_record($fid = '', $path = '') {
if(is_numeric($fid)) {
$query = "SELECT * FROM {webfm_file} WHERE fid = %d";
if(($result = db_query($query, $fid)) !== FALSE) {
if($row = db_fetch_object($result)) {
return $row;
}
}
} else if(is_string($path)) {
$query = "SELECT * FROM {webfm_file} WHERE fpath = '%s'";
if(($result = db_query($query, $path)) !== FALSE) {
if($row = db_fetch_object($result)) {
return $row;
}
}
}
return FALSE;
}
function webfm_putmeta($fid, $metadata, $user, &$err) {
//editable metadata columns of webfm_file table
static $metadata_key_arr = array();
if(!count($metadata_key_arr)) {
$metadata_key_arr = array( 't'=>array('field'=>'ftitle', 'size'=>255),
'd'=>array('field'=>'fdesc', 'size'=>1024),
'l'=>array('field'=>'flang', 'size'=>16),
'p'=>array('field'=>'fpublisher', 'size'=>255),
'f'=>array('field'=>'fformat', 'size'=>255),
'u'=>array('field'=>'uid', 'size'=>10));
}
$err = "";
if(($file = webfm_get_file_record($fid)) != false) {
if($user == 1 ||
$user == $file->uid ||
webfm_file_mod_access($file)) {
$fields = explode(',',$metadata);
$metadata = array();
foreach($fields as $field) {
// Parse webfm_file_key/metadata pairs
trim($field);
$key = substr($field, 0, 1);
$separator = substr($field, 1,1);
$value = substr($field, 2, min((strlen($field) - 2), $metadata_key_arr[$key]['size']));
if(array_key_exists($key, $metadata_key_arr) && ($separator == ":")) {
if($key == 'u') {
// Special handling for uid changes (admins only)
if($user == 1) {
$uid_val = strval($value);
if(is_numeric($uid_val) && (strlen($uid_val) << 11)) {
// Check that requested uid exists
$query = "SELECT uid FROM {users} WHERE uid = %d";
$result = db_result(db_query($query, $uid_val));
if(count($result) > 0) {
$metadata[$metadata_key_arr[$key]['field']] = $uid_val;
} else {
$err = "user not found";
return FALSE;
}
} else {
$err = "invalid data";
return FALSE;
}
} else {
$err = "permission denied";
return FALSE;
}
} else {
$metadata[$metadata_key_arr[$key]['field']] = strval($value);
}
}
}
if(count($metadata)) {
$ret = webfm_dbupdate_file($fid, '', $metadata);
if($ret) {
$err = "metadata updated";
return TRUE;
} else {
$err = "webfm_dbupdate_file fail";
}
} else {
if(!strlen($err)) {
$err = "no update required";
}
return TRUE;
}
} else {
$err = "permission denied";
}
} else {
$err = "file not found";
}
return FALSE;
}
/**
* webfm_dbdelete_file - Deletes all database references to a file given and fid
* Calling this function will delete the file from the webfm_file table AS WELL AS the webfm_attach table
* therefore any nodes that have this file attached to them will lose that file.
*
* @param int $fid - file id of the file
* @return bool True if it worked False if it didn't
*
*/
function webfm_dbdelete_file($fid) {
if(_webfm_dbdelete_file_fid($fid)) {
//ignore err return of _webfm_dbdelete_attach_fid()
_webfm_dbdelete_attach_fid($fid);
return TRUE;
}
return FALSE;
}
/**
* Helper function that deletes db entries from the webfm_file table given an fid
* called from webfm_dbdelete_file
*
* @param int $fid
* @return bool
*/
function _webfm_dbdelete_file_fid($fid){
$query = 'DELETE FROM {webfm_file} WHERE fid = %d';
$result = db_query($query, $fid);
if($result === FALSE){
drupal_set_message(t('Query Failed: Could not delete file %fid .', array('%fid' => $fid), error));
return FALSE;
}
return TRUE;
}
/**
* webfm_dbupdate_attach - updates the files in the webfm_attach table IF the order
*
* @param int $nid
* @param array $fids - could be a comma seperated string - we need to work that out - works both ways now
* @param int $cid - Optional, comment id.
* @return TRUE if records were updated - NULL if no changes were required.
*/
function webfm_dbupdate_attach($nid, $fids, $cid = 0){
if ($cid == 0 ) {
$id = $nid;
$selector = 'nid';
}
else {
$id = $cid;
$selector = 'cid';
}
$i = 0;
if (!webfm_check_attach_order($nid, $fids, $cid)) { //the new fids are different from the old ones
$query = "DELETE FROM {webfm_attach} WHERE %s = %d";
if ($result = db_query($query, $selector, $id)) {
foreach($fids as $fid){
if($fid)
webfm_dbinsert_attach($nid, $fid, $i++, $cid);
$flag = TRUE;
}
if($flag === TRUE) return TRUE;
}
}
}
/**
* webfm_check_attach_order - checks to see if the new order of the fids is the same as the old order stored in the database
*
* @param int $nid - node id
* @param array $fids - array of file ids
* @param int $cid - Optional, comment id.
* @return bool - TRUE if the attach order is the same - FALSE if it has changed
*/
function webfm_check_attach_order($nid, $fids, $cid = 0) {
if ($cid == 0 ) {
$id = $nid;
$selector = 'nid';
}
else {
$id = $cid;
$selector = 'cid';
}
//check array against db result
$query = "SELECT fid FROM {webfm_attach} WHERE %s = %d ORDER BY weight";
$result = db_query($query, $selector, $id);
$match = TRUE;
$i = 0;
while ($dbfid = db_fetch_array($result)) {
if($dbfid['fid'] != $fids[$i]) {
$match = FALSE;
break;
}
$i++;
}
if($i < count($fids)) {
$match = FALSE;
}
return($match);
}
/**
* webfm_dbinsert_attach - inserts nid, fid and weight to webfm_attach table (similar to files table)
*
* @param int $nid - node id
* @param int $fid - file id from the webfm_file table
* @param int $weight - weight value
* @param int $cid - Optional, comment id. If given, $nid is set to 0 because
* an attachment is stored either for a node OR a comment.
* @return bool - TRUE if success - else FALSE
*/
function webfm_dbinsert_attach($nid, $fid, $weight, $cid = 0) {
if ($cid == 0 ) {
$selector = 'nid';
$type = 'node';
$id = $nid;
}
else {
$selector = 'cid';
$type = 'comment';
$id = $cid;
$nid = 0;
}
$query = "SELECT * FROM {webfm_attach} WHERE %s = %d AND fid = %d";
$result = db_query($query, $selector, $id, $fid);
$exist = FALSE;
while ($exist = db_fetch_object($result)){
drupal_set_message(t('File is already attached to this %t.', array('%t' => $type)));
return FALSE;
}
if ($exist === FALSE) {
//actually do the attachment if its not already attached....
$query = 'INSERT INTO {webfm_attach} (nid, fid, weight, cid) VALUES (%d, %d, %d, %d)';
$result = db_query($query, $nid, $fid, $weight, $cid);
if($result === FALSE) {
drupal_set_message(t('Query Failed: Could not attach files to %t %n', array('%t' => $type, '%n' => $id)));
return FALSE;
} else {
return TRUE;
}
}
}
/**
* webfm_dbdelete_attachments - deletes nodes/comments file associations.
*
* @param int $id - Node or comment id.
* @param selector - Tell if we handle a node or a comment.
* @return bool - TRUE if success - else FALSE
*
*/
function webfm_dbdelete_attachments($id, $selector = 'nid') {
$type = ($selector == 'nid') ? 'node' : 'comment';
$query = "DELETE FROM {webfm_attach} WHERE %s = %d";
$result = db_query($query, $selector, $id);
if($result === FALSE) {
drupal_set_message(t('Failed to remove file attachments for deleted %type %id',
array('%type' => $type, '%id' => $id)));
return FALSE;
}
return TRUE;
}
/**
* webfm_dbdelete_attach - deletes node file associations given a nid and fid
*
* @param int $nid - node id
* @param int $fid - file id from the webfm_file table
* @return bool - TRUE if success - else FALSE
*
*/
function webfm_dbdelete_attach($nid, $fid){
$query = 'DELETE FROM {webfm_attach} WHERE nid = %d AND fid = %d';
$result = db_query($query, $nid, $fid);
if($result === FALSE) {
drupal_set_message(t('Query Failed: Could not detach file %fid from node %nid', array('%fid' => $fid, '%nid'=>$nid)));
return FALSE;
}
return TRUE;
}
/**
* Helper function that deletes db entries from the webfm_attach table given fid
* called from webfm_dbdelete_file
*
* @param int $fid
* @return bool
*/
function _webfm_dbdelete_attach_fid($fid){
$query = 'DELETE FROM {webfm_attach} WHERE fid = %d';
$result = db_query($query, $fid);
if($result === FALSE) {
return FALSE;
}
return TRUE;
}
/**
* Show the popup window.
*/
function webfm_popup() {
$content = webfm_main();
print theme('webfm_popup', $content);
exit();
}
if(module_exists('views')){
require_once("./".$modulepath."/webfm_views.inc");
}