source: extensions/WiredForSound/admin/add_page_on_index.php @ 3302

<?php

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
load_language('plugin.lang', WFS_PATH);

$wfs_conf = explode(',' , $conf['wired_for_sound']);
$mp3_path = $wfs_conf[0];

$cat_id = $_GET['catid'];
$back_url = $_GET['backurl'];
$volume = '';

// Changement de repertoire
if (isset($_POST['change_path']))
{
  $mp3_path = $_POST['mp3_path'];
  if (strrpos($mp3_path , '/') != (strlen($mp3_path) - 1))
  {
    $mp3_path .= '/';
  }
}

// Suppression de l'association
if (isset($_POST['delete']))
{
  pwg_query('DELETE FROM ' . WFS_IMG_CAT_TABLE . ' WHERE image_id IS NULL AND cat_id = ' . $cat_id . ';');
}

// Enregistrement de l'association
if (isset($_POST['submit']) and !empty($_POST['mp3_select']))
{
  pwg_query('DELETE FROM ' . WFS_IMG_CAT_TABLE . ' WHERE image_id IS NULL AND cat_id = ' . $cat_id . ';');
  if (empty($_POST['volume'])) $_POST['volume'] = 'NULL';

  $q = 'SELECT id FROM ' . WFS_SOUNDS_TABLE . ' WHERE file = "' . $_POST['mp3_select'] . '";';
  $result = mysql_fetch_assoc(pwg_query($q));

  if (empty($result))
  {
    $q = 'SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id  FROM ' . WFS_SOUNDS_TABLE . ' ;';
    list($next_element_id) = mysql_fetch_array(pwg_query($q));
    $q = 'INSERT INTO ' . WFS_SOUNDS_TABLE . ' ( id , file ) VALUES ( ' . $next_element_id . ' , "' . $_POST['mp3_select'] . '");';
    pwg_query($q);
    $result['id'] = $next_element_id;
  }

  $q = 'INSERT INTO ' . WFS_IMG_CAT_TABLE . ' ( image_id , cat_id , sound_id , volume )
VALUES ( NULL , ' . $cat_id . ' , ' . $result['id'] . ' , ' . $_POST['volume'] . ');';
  pwg_query($q);
}

// Recupération des données de la table
$q = 'SELECT sound.file AS sound, ic.volume AS volume
FROM ' . WFS_SOUNDS_TABLE . ' AS sound
INNER JOIN ' . WFS_IMG_CAT_TABLE . ' AS ic
ON sound.id = ic.sound_id
WHERE ic.cat_id = ' . $cat_id . ' AND ic.image_id IS NULL;';
$result = mysql_fetch_assoc(pwg_query($q));

// Bouton de suppression
if (!empty($result))
{
  $template->assign('delete', true);
}

// Dossier mp3
if (isset($result['sound']) and !isset($_POST['change_path']) and !isset($wfs_param[2]))
{
  $mp3_path = substr($result['sound'] , 0 , strrpos($result['sound'] , '/') + 1);
}
  
// Volume
if (isset($result['volume']))
{
  $volume = $result['volume'];
}

// Liste des mp3 du dossier spécifié
if (is_dir('./' . $mp3_path) and $contents = opendir($mp3_path))
{
  $options[] = '----------------';
  $selected = 0;
  while (($node = readdir($contents)) !== false)
  {
    if (is_file('./' . $mp3_path . $node))
    {
      $extension = strtolower(get_extension($node));
      if ($extension == 'mp3')
      {
        $value = $mp3_path . $node;
        if (isset($result['sound']) and $result['sound'] == $value)
        {
          $selected = $value;
        }
        $options[$value] = $node;
      }
    }
  }
  closedir($contents);
  // Erreur si pas de mp3
  if (count($options) == 1)
  {
    array_push($page['errors'], l10n('wfs_no_mp3'));
  }
  else
  {
    $template->assign('mp3_select', array(
      'OPTIONS' => $options,
      'SELECTED' => $selected));
  }
}
else
{
  array_push($page['errors'], l10n('wfs_no_path'));
}

// Affichage du fichier associé
if (isset($result['sound']))
{
  $template->assign('ACTUAL_FILE', $result['sound']);
}

$template->assign(array(
  'MP3_PATH' => $mp3_path,
  'BACK' => $back_url,
  'VOLUME' => $volume));

$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/../template/add_page_on_index.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');

?>