jplayer_protect.admin.inc in jPlayer 7.2

Page callback for the jPlayer protection statistics page.

This page is useful in determining if a browser is misbehaving and blocking legitimiate file accesses, or if a user is trying to download a protected file.

File

jplayer_protect/jplayer_protect.admin.inc

<?php

/**
 * @file
 * Page callback for the jPlayer protection statistics page.
 *
 * This page is useful in determining if a browser is misbehaving and blocking
 * legitimiate file accesses, or if a user is trying to download a protected
 * file.
 */

/**
 * Statistics of the page.
 * @return string
 * @throws \Exception
 */
function jplayer_protection_statistics() {
  if (!variable_get('jplayer_protect', FALSE)) {
    drupal_set_message(t('<a href="@jplayer-settings">jPlayer content protection</a> is not currently enabled.', array(
      '@jplayer-settings' => url('admin/settings/jplayer', array(
        'query' => drupal_get_destination(),
      )),
    )));
  }
  $output = '<p>' . t('This table shows the 50 top users who have been denied access to direct downloads of jPlayer files.') . '</p>';

  // 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 .= '<p>' . t('There have been no files that have been denied access within the last week.') . '</p>';
  }
  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 <a href="@file-system-settings">set a Private file system path and set protected file fields to use it</a>.', 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.'));
  }
}

Functions

Name	Description
jplayer_protection_statistics	Statistics of the page.
jplayer_protect_settings_form	Settings form for enabling jPlayer protection.
jplayer_protect_settings_form_validate	Validate the access time setting.