' . t('This table shows the 50 top users who have been denied access to direct downloads of jPlayer files.') . '
'; // TODO: convert to DBTNG. $result = db_query("SELECT COUNT(1) as total, uid as user, MAX(timestamp) as timestamp FROM {jplayer_protect_denied} GROUP BY uid ORDER BY total DESC, timestamp DESC LIMIT 50;"); $rows = array(); foreach ($result as $denied) { $denied = (array) $denied; // Format data from the query. $uid = $denied['user']; $denied['user'] = theme('username', array('account' => user_load($denied['user']))); $denied['timestamp'] = format_date($denied['timestamp']); // Find the top-denied file for the user. // TODO: convert to DBTNG. $top_file = db_query("SELECT COUNT(fid) as fid_count, fid FROM {jplayer_protect_denied} WHERE uid = :uid GROUP BY fid ORDER BY fid_count DESC LIMIT 1", array(':uid' => $uid))->fetchObject(); $top_file = file_load($top_file->fid); $denied['file'] = str_replace($GLOBALS['base_url'], '', file_create_url($top_file->uri)); // Find the top hostname for the user. // TODO: convert to DBTNG. $top_hostname = db_query("SELECT COUNT(hostname) as hostname_count, hostname FROM {jplayer_protect_denied} WHERE uid = :uid GROUP BY hostname ORDER BY hostname_count DESC LIMIT 1", array(':uid' => $uid))->fetchObject(); $denied['hostname'] = $top_hostname->hostname; $rows[] = $denied; } $header = array( t('Accesses denied'), t('User'), t('Last denied'), t('Top Denied File'), t('Top Hostname'), ); if (!empty($rows)) { $output .= theme('table', array('header' => $header, 'rows' => $rows)); } else { $output .= '' . t('There have been no files that have been denied access within the last week.') . '
'; } return $output; } /** * Settings form for enabling jPlayer protection. */ function jplayer_protect_settings_form(&$form, &$form_state) { $form['jplayer_protect'] = array( '#title' => t('Protect audio files from direct downloads'), '#type' => 'checkbox', '#default_value' => variable_get('jplayer_protect', FALSE), ); if (variable_get('file_private_path', '') == '') { $form['jplayer_protect']['#description'] = t('To enable file download protection, first set a Private file system path and set protected file fields to use it.', array('@file-system-settings' => url('admin/config/media/file-system', array('query' => drupal_get_destination())))); } $form['jplayer_protect_access_time'] = array( '#title' => t('Access delay'), '#type' => 'textfield', '#default_value' => variable_get('jplayer_protect_access_time', 30), '#size' => 5, '#description' => t('The number of seconds that a client will have access to download a protected file after it is requested by jPlayer.'), ); $form['#validate'][] = 'jplayer_protect_settings_form_validate'; } /** * Validate the access time setting. */ function jplayer_protect_settings_form_validate($form, &$form_state) { $time = $form_state['values']['jplayer_protect_access_time']; if ($form_state['values']['jplayer_protect'] && !is_numeric($time)) { form_error($form['jplayer_protect_access_time'], t('Access time must be a value in seconds.')); } if (intval($time) < 0) { form_error($form['jplayer_protect_access_time'], t('Access time must be at least 0 seconds.')); } }