WordPress Francophone

Plugin : SongManager v1.0
MySQL  : sm_lyrics
                   id      INT (5) auto_increment index
                   author  INT (5)
                   lyrics  TEXT
         sm_authors
                   id        INT (5) auto_increment index
                   name      VARCHAR (50)
                   firstname VARCHAR (50)
                   sex       ENUM ('M', 'F')
                   age       INT (3)
                   songs     INT (4)
                   ...

<?php
/*
Plugin Name: SongManager
Plugin URI:  http://www.newbie-project.net/stuff/wp_plugins.php
Description: Allows admin to manage songs and lyrics
Version:     1.0
Author:      Thomas G ( MS-DOS_1991 )
Author URI:  http://www.newbie-project.net/

Copyright 2006  Thomas G  (email : msdos.1991@gmail.com)

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

class SongManager
{
  /** Class Constructor **/
  function SongManager()
  {
    global $wpdb;
    /** Creating SQL table sm_songs **/
	  $wpdb->query("CREATE TABLE IF NOT EXISTS `sm_songs`
                  (
                    `id`             INT    ( 5 )   NOT NULL AUTO_INCREMENT PRIMARY KEY,
                    `title`          VARCHAR( 255 ) NOT NULL ,
                    `original_title` VARCHAR( 255 ) NOT NULL ,
                    `authors`        VARCHAR( 255 ) NOT NULL ,
                    `interprets`     VARCHAR( 255 ) NOT NULL ,
                    `lyrics`         TEXT           NOT NULL ,
                    `copyright`      TEXT           NOT NULL ,
                    `ccli`           INT    ( 10 )  NOT NULL ,
                    `date`           TIMESTAMP      NOT NULL DEFAULT CURRENT_TIMESTAMP
                  ) ENGINE = InnoDB COMMENT = 'SongManager > Songs'
                 "); 
    /** Creating SQL table sm_authors **/
    $wpdb->query("CREATE TABLE IF NOT EXISTS `sm_authors`
                 (
                   `id`         INT    ( 5 )  NOT NULL AUTO_INCREMENT PRIMARY KEY,
                   `name`       VARCHAR( 50 ) NOT NULL,
                   `first_name` VARCHAR( 50 ) NOT NULL
                 ) ENGINE = InnoDB COMMENT = 'SongManager > Authors'
                ");
    /** Creating SQL table sm_interprets **/
    $wpdb->query("CREATE TABLE IF NOT EXISTS `sm_interprets`
                 (
                   `id`         INT    ( 5 )  NOT NULL AUTO_INCREMENT PRIMARY KEY,
                   `name`       VARCHAR( 50 ) NOT NULL,
                   `first_name` VARCHAR( 50 ) NOT NULL
                 ) ENGINE = InnoDB COMMENT = 'SongManager > Interprets'
                ");
		update_option('is_installed_songmanager', 1);
	}
  /** Creates option page in the DashBoard (Options > Song manager) **/
  function init_plugin()
  {
    add_options_page('Song Manager', 'Song Manager', 1,
                      basename(__FILE__), array($this, 'sm_options_subpanel'));
  }
  /** Displays submenu page in the DashBoard **/
  function sm_options_subpanel()
  {
    global $wpdb;
    if (isset($_GET['search']))
    {
      if ($_GET['search'] == 'title')
        $this->searchLyricsFromTitle(trim(htmlentities($_GET['title'])));
      elseif ($_GET['search'] == 'original_title')
        $this->searchLyricsFromOriginalTitle(trim(htmlentities($_GET['original_title'])));
      elseif ($_GET['search'] == 'author')
        $this->searchLyricsByAuthor(trim(htmlentities($_GET['author'])));
      elseif ($_GET['search'] == 'interprete')
        $this->searchLyricsByInterprete(trim(htmlentities($_GET['interprete'])));
      elseif ($_GET['search'] == 'ccli')
        $this->searchLyricsFromCCLI(trim($_GET['ccli']));
      else
        die('Erreur inconnue.');
    }
    elseif (isset($_GET['add']))
    {
      if ($_GET['add'] == 'song')
      {
        foreach ($_POST AS $key => $value)
          $$key = trim(htmlentities($value));
        
        $wpdb->query("INSERT INTO sm_songs (title, original_title, 
                                            authors, interpretes,
                                            lyrics, copyright, ccli)
                                    VALUES ('$title', '$original_title',
                                            '$authors', '$interpretes',
                                            '$lyrics', '$copyright', '$ccli')
                     ");
        echo '<script type="text/javascript">alert(\'Ajout Effectué !\');window.location = \'',$_SERVER['PHP_SELF'],'?page=songmanager.php\';</script>';
      }
      elseif ($_GET['add'] == 'author')
      {
        if (isset($_POST['first_name']) && isset($_POST['surname']))
        {
          $this->addAuthor($_POST['first_name'], $_POST['surname']);
          echo '<script type="text/javascript">alert(\'Ajout Effectué !\');window.location = \'',$_SERVER['PHP_SELF'],'?page=songmanager.php\';</script>';
        }
        else
          die('Erreur: Veuillez remplir tous les champs.');
      }
      elseif ($_GET['add'] == 'interpret')
      {
        if (isset($_POST['first_name']) && isset($_POST['surname']))
        {
          $this->addInterpret($_POST['first_name'], $_POST['surname']);
          echo '<script type="text/javascript">alert(\'Ajout Effectué !\');window.location = \'',$_SERVER['PHP_SELF'],'?page=songmanager.php\';</script>';
        }
        else
          die('Erreur: Veuillez remplir tous les champs.');
      }
    }
    elseif (isset($_GET['del']))
    {
      if ($_GET['del'] == 'author')
      {
        if (isset($_POST['author']))
        {
          $this->deleteAuthor($_POST['author']);
          echo '<script type="text/javascript">alert(\'Suppression Effectuée.\');window.location = \'',$_SERVER['PHP_SELF'],'?page=songmanager.php\';</script>';
        }
        else
          die('Erreur: Veuillez s&eacute;lectionner un auteur &agrave; supprimer');
      }
      elseif ($_GET['del'] == 'interpret')
      {
        if (isset($_POST['interpret']))
        {
          $this->deleteInterpret($_POST['interpret']);
          echo '<script type="text/javascript">alert(\'Suppression Effectuée.\');window.location = \'',$_SERVER['PHP_SELF'],'?page=songmanager.php\';</script>';
        }
        else
          die('Erreur: Veuillez s&eacute;lectionner un auteur &agrave; supprimer');
      }
    }
    else
    {
?>
<script type="text/javascript">
function addAuthor()
{
  authors_nb = document.getElementById('addsong_authors_nb').value;
  authors_nb++;
  
  if (authors_nb > document.getElementById('addsong_author_1').options.length)
    alert('Tous les auteurs ont été utilisés.');
  else
  {
    newSpan = document.createElement('span');
    newSelect = document.getElementById('addsong_author_1').cloneNode(true);
    newSelect.setAttribute('id', 'addsong_author_'+authors_nb);
    newSpan.appendChild(newSelect);
    document.getElementById('addsong_p_authors').appendChild(newSpan); 
    document.getElementById('addsong_authors_nb').value++;
  }
}
function updateAuthors(id)
{
  // AAAAAAAAAAAAAAAAAAAAAAAARGHHH
}
function delAuthor()
{
  authors_nb = document.getElementById('addsong_authors_nb').value;
  
  if (authors_nb == 1)
    alert('Impossible de supprimer le dernier auteur !');
  else
  {
    lastauthor = document.getElementById('addsong_p_authors').lastChild; 
    while (lastauthor.firstChild)
      lastauthor.removeChild(lastauthor.firstChild);
    document.getElementById('addsong_p_authors').removeChild(lastauthor);
    document.getElementById('addsong_authors_nb').value--;
  }
}
</script>
  <div class="wrap">
    <h2>Song Manager v1.0</h2>
    <h3>Rechercher des paroles de chansons</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&search=title" method="post" style="font-family: 'Courier New';">
      <p>
        <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rechercher par titre : <input type="text" name="title" size="50" /></label>
        <input type="submit" value="Rechercher" />
      </p>
    </form>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&search=original_title" method="post" style="font-family: 'Courier New';">
      <p>
        <label>Rechercher par titre original : <input type="text" name="original_title" size="50" /></label>
        <input type="submit" name="search_original_title" value="Rechercher" />
      </p>
    </form>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&search=author" method="post" style="font-family: 'Courier New';">
      <p>
        <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rechercher par auteur : <input type="text" name="author" size="50" /></label>
        <input type="submit" value="Rechercher" />
      </p>
    </form>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&search=interprete" method="post" style="font-family: 'Courier New';">
      <p>
        <label>&nbsp;&nbsp;&nbsp;&nbsp;Rechercher par interpr&egrave;te : <input type="text" name="interprete" size="50" /></label>
        <input type="submit" value="Rechercher" />
      </p>
    </form>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&search=ccli" method="post" style="font-family: 'Courier New';">
      <p>
        <label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Trouver &agrave; partir du <acronym title="Christian Copyright Licensing International">CCLI</acronym> : <input type="text" name="search_ccli" size="10" /></label>
        <input type="submit" value="Rechercher" />
      </p>
    </form>
    <h3>Derni&egrave;res paroles de chanson</h3>
    <?php $this->getLastLyrics(); ?>
    <h3>Ajouter une chanson</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&add=song" method="post" style="font-family: 'Courier New';">
    <p style="display: none;">
      <input type="hidden" id="addsong_authors_nb" value="1" />
      <input type="hidden" id="addsong_authors" name="addsong_authors" value="1" />
    </p>
    <p><label>Titre de la chanson : <input type="text" name="addsong_title" size="50" /></label></p>
    <p><label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Titre original : <input type="text" name="addsong_original_title" size="50" /></label></p>
    <p id="addsong_p_authors">
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Auteur(s) :
      <select id="addsong_author_1" onChange="updateAuthors(this.selectedIndex)">
      <?php
      $sql_authors = $wpdb->get_results("SELECT id, surname, first_name
                                         FROM sm_authors
                                         ORDER BY surname ASC
                                        ");
      foreach ($sql_authors AS $author)
        echo '<option value="',$author->id,'">',$author->first_name,' ',$author->surname,'</option>';
      ?>
      </select>
    </p>
    <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <span id="addsong_span_addauthor"><input type="button" value="Ajouter un Auteur" onClick="addAuthor()" /></span>
      <span id="addsong_span_delauthor"><input type="button" value="Supprimer un Auteur" onClick="delAuthor()" /></span>
    </p>
    <p><label>Paroles (et/ou accords) :<br /><textarea name="addsong_lyrics" style="width: 85%; height: 400px;"></textarea></label></p>
    <p><label>Copyright : <input type="text" name="addsong_copyright" size="50" /></label></p>
    <p><label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CCLI : <input type="text" name="addsong_ccli" size="10" /></label></p>
    <p><input type="submit" name="addsong_submit" value="Soumettre les Paroles" />
    </form>
    <h3>Nouvel Auteur</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&add=author" method="post" style="font-family: 'Courier New';">
      <p><label>Pr&eacute;nom : <input type="text" name="first_name" size="15" /></label></p>
      <p><label>&nbsp;&nbsp;&nbsp;Nom : <input type="text" name="surname" size="15" /></label>
      <p><input type="submit" value="Ajouter cet Auteur" /></p>
    </form>
    <h3>Supprimer un Auteur</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&del=author" method="post" style="font-family: 'Courier New';">
      <p>
        <?php
        $sql_authors = $wpdb->get_results("SELECT id, surname, first_name
                                           FROM sm_authors
                                           ORDER BY surname ASC
                                          ");
        if ($sql_authors)
        {
?>
        <select name="author">
<?php
          foreach ($sql_authors AS $author)
            echo '<option value="',$author->id,'">',$author->first_name,' ',$author->surname,'</option>';
?>
        </select>
        <input type="submit" value="Supprimer cet Auteur" />
<?php
        }
        else
          echo 'Aucun auteur &agrave; supprimer.';
        ?>
      </p>
    </form>
    <h3>Nouvel Interpr&egrave;te</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&add=interpret" method="post" style="font-family: 'Courier New';">
      <p><label>Pr&eacute;nom : <input type="text" name="first_name" size="15" /></label></p>
      <p><label>&nbsp;&nbsp;&nbsp;Nom : <input type="text" name="surname" size="15" /></label>
      <p><input type="submit" value="Ajouter cet Interpre&egrave;te" /></p>
    </form>
    <h3>Supprimer un Interpr&egrave;te</h3>
    <form action="<?php echo $_SERVER['REQUEST_URI']; ?>&del=interpret" method="post" style="font-family: 'Courier New';">
      <p>
        <?php
        $sql_interprets = $wpdb->get_results("SELECT id, surname, first_name
                                              FROM sm_interprets
                                              ORDER BY surname ASC
                                             ");
        if ($sql_interprets)
        {
?>
        <select name="interpret">
<?php
          foreach ($sql_interprets AS $interpret)
            echo '<option value="',$interpret->id,'">',$interpret->first_name,' ',$interpret->surname,'</option>';
?>
        </select>
        <input type="submit" value="Supprimer cet Interpr&egrave;te" />
<?php
        }
        else
          echo 'Aucun interpr&egrave;te &agrave; supprimer.';
        ?>
      </p>
    </form>
  </div>
<?php
    }
  }
  
  /**  **/
  function getLastLyrics($nb_to_show=5)
  {
    global $wpdb;
    $sql_res = $wpdb->get_results("SELECT id, title, original_title, date, authors
                                   FROM sm_songs 
                                   ORDER BY date DESC
                                   LIMIT 0, $nb_to_show
                                  ");
    if ($sql_res)
    {
?>
  <ul>
<?php
      foreach ($sql_res AS $song)
      {
        $sql_authors = $wpdb->get_results("SELECT   id, surname, first_name
                                           FROM     sm_authors
                                           WHERE    id IN ($song->authors)
                                           ORDER BY surname ASC
                                          ");
        $authors = '';
        foreach ($sql_authors AS $author)
          $authors .= '<a href="'.$_SERVER['REQUEST_URI'].'&show_author='.$author->id.'">'.$author->first_name.' '.$author->name.'</a>'.', ';
?>
    <li>
      <strong><a href="<?php echo $_SERVER['REQUEST_URI']; ?>&show_lyrics=<?php echo $song->id; ?>"><?php echo $song->title; ?></a></strong> (<?php echo $song->original_title; ?>)<br />
      Par <?php echo $authors; ?> (paroles soumises le <?php echo $song->date; ?>)
    </li>
<?php
      }
?>
  </ul>
<?php
    }
    else
      echo '<p>Aucune chanson dans la Base de Données.</p>';
  }
  
  function addAuthor($first_name, $name)
  {
    global $wpdb;
    $first_name = trim(htmlentities($_POST['first_name']));
    $name = trim(htmlentities($_POST['surname']));
    $wpdb->query("INSERT INTO sm_authors (surname, first_name)
                                  VALUES ('$name', '$first_name')
                 ");
  }
  function addInterpret($first_name, $name)
  {
    global $wpdb;
    $first_name = trim(htmlentities($_POST['first_name']));
    $name = trim(htmlentities($_POST['surname']));
    $wpdb->query("INSERT INTO sm_interprets (surname, first_name)
                                     VALUES ('$name', '$first_name')
                 ");
  }
  
  function deleteAuthor($id)
  {
    global $wpdb;
    if (is_numeric($id))
      $wpdb->query("DELETE FROM sm_authors
                    WHERE id = $id
                   ");
    else
      die('Erreur : Valeur incorrecte. Chiffres seulement');
  }
  function deleteInterpret($id)
  {
    global $wpdb;
    if (is_numeric($id))
      $wpdb->query("DELETE FROM sm_interprets
                    WHERE id = $id
                   ");
    else
      die('Erreur : Valeur incorrecte. Chiffres seulement');
  }
}

$SongManager = new SongManager;
add_action('admin_menu', array(&$SongManager, 'init_plugin'));

?>