source: extensions/Copyrights/maintain.inc.php @ 10931

<?php
// +-----------------------------------------------------------------------+
// | Piwigo - a PHP based picture gallery                                  |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2008-2009 Piwigo Team                  http://piwigo.org |
// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
// +-----------------------------------------------------------------------+
// | 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                                          |
// |                                                                       |
// | 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.                                                                  |
// +-----------------------------------------------------------------------+

function plugin_install() {
  global $conf, $prefixeTable;
  $query = "
    CREATE TABLE IF NOT EXISTS ".$prefixeTable."copyrights_admin (
      cr_id int(11) NOT NULL AUTO_INCREMENT,
      name varchar(255) UNIQUE NOT NULL,
      url varchar(255) NOT NULL,
      visible bool DEFAULT 0,
      PRIMARY KEY (cr_id)
    ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8
    ;";
  pwg_query($query);

  $query = "
    CREATE TABLE IF NOT EXISTS ".$prefixeTable."copyrights_media (
      media_id int(11) NOT NULL,
      cr_id int(11) default NULL
    ) ENGINE = MyISAM DEFAULT CHARACTER SET utf8
    ;";
  pwg_query($query);
}

function plugin_activate() {
  global $prefixeTable;

  $query = "
    SELECT COUNT(*)
    FROM ".$prefixeTable."copyrights_admin
    ;";
  list($counter) = pwg_db_fetch_row(pwg_query($query));
  if (0 == $counter) {
    copyrights_create_default();
  }
}

function plugin_uninstall() {
  global $prefixeTable;

  $query = "
    DROP TABLE ".$prefixeTable."copyrights_admin
    ;";
  pwg_query($query);

  $query = "
    DROP TABLE ".$prefixeTable."copyrights_media
    ;";
  pwg_query($query);
}

function copyrights_create_default() {
  global $prefixeTable;

  // Insert the copyrights of Creative Commons
  $inserts = array(
    array(
      'name' => 'Creative Commons (BY)',
      'url' => 'http://creativecommons.org/licenses/by/3.0/',
      'visible' => 1
    ),
    array(
      'name' => 'Creative Commons (BY-SA)',
      'url' => 'http://creativecommons.org/licenses/by-sa/3.0/',
      'visible' => 1
    ),
    array(
      'name' => 'Creative Commons (BY-ND)',
      'url' => 'http://creativecommons.org/licenses/by-nd/3.0/',
      'visible' => 1
    ),
    array(
      'name' => 'Creative Commons (BY-NC)',
      'url' => 'http://creativecommons.org/licenses/by-nc/3.0/',
      'visible' => 1
    ),
    array(
      'name' => 'Creative Commons (BY-NC-SA)',
      'url' => 'http://creativecommons.org/licenses/by-nc-sa/3.0/',
      'visible' => 1
    ),
    array(
      'name' => 'Creative Commons (BY-NC-ND)',
      'url' => 'http://creativecommons.org/licenses/by-nc-nd/3.0/',
      'visible' => 1
    )
  );

  mass_inserts(
    $prefixeTable.'copyrights_admin',
    array(
      'name',
      'url',
      'visible'
    ),
    $inserts
  );
}