Changeset 9372 for extensions/community/maintain.inc.php

Timestamp:

Feb 25, 2011, 12:22:52 AM (13 years ago)

Author:

plg

Message:

Rewritten version of Community plugin :

• user upload (web form on gallery side)
• precise permission manage (who, where, with moderation or not, ability to create sub-albums)
• email notification to administrators when photos are uploaded

Requires Piwigo 2.2.0RC3

File:

• extensions/community/maintain.inc.php (modified) (1 diff)

extensions/community/maintain.inc.php

@@ -10 +10 @@
 function plugin_install()
 {
-  $query = "
-CREATE TABLE IF NOT EXISTS ".COMMUNITY_TABLE." (
-  user_id smallint(5) NOT NULL default '0',
-  permission_level tinyint NOT NULL default 1,
-  PRIMARY KEY  (user_id)
+  global $conf, $prefixeTable;
+
+  if ('mysql' == $conf['dblayer'])
+  {
+    $query = '
+CREATE TABLE '.$prefixeTable.'community_permissions (
+  id int(11) NOT NULL AUTO_INCREMENT,
+  type varchar(255) NOT NULL,
+  group_id smallint(5) unsigned DEFAULT NULL,
+  user_id smallint(5) DEFAULT NULL,
+  category_id smallint(5) unsigned DEFAULT NULL,
+  create_subcategories enum(\'true\',\'false\') NOT NULL DEFAULT \'false\',
+  moderated enum(\'true\',\'false\') NOT NULL DEFAULT \'true\',
+  PRIMARY KEY (id)
+) ENGINE=MyISAM DEFAULT CHARACTER SET utf8
+;';
+    pwg_query($query);
+
+    $query = '
+CREATE TABLE '.$prefixeTable.'community_pendings (
+  image_id mediumint(8) unsigned NOT NULL,
+  state varchar(255) NOT NULL,
+  added_on datetime NOT NULL,
+  validated_by smallint(5) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARACTER SET utf8
+;';
+    pwg_query($query);
+  }
+  elseif ('pgsql' == $conf['dblayer'])
+  {
+    $query = '
+CREATE TABLE "'.$prefixeTable.'community_permissions" (
+  "id" serial NOT NULL,
+  "type" VARCHAR(255) NOT NULL,
+  "group_id" INTEGER,
+  "user_id" INTEGER,
+  "category_id" INTEGER,
+  "create_subcategories" BOOLEAN default false,
+  "moderated" BOOLEAN default true,
+  PRIMARY KEY ("id")
 )
-;";
-  pwg_query($query);
+;';
+    pwg_query($query);
+
+    $query = '
+CREATE TABLE "'.$prefixeTable.'community_pendings" (
+  image_id INTEGER NOT NULL,
+  state VARCHAR(255) NOT NULL,
+  added_on TIMESTAMP NOT NULL,
+  validated_by INTEGER
+)
+;';
+    pwg_query($query);
+  }
+  else
+  {
+    $query = '
+CREATE TABLE "'.$prefixeTable.'community_permissions" (
+  "id" INTEGER NOT NULL,
+  "type" VARCHAR(255) NOT NULL,
+  "group_id" INTEGER,
+  "user_id" INTEGER,
+  "category_id" INTEGER,
+  "create_subcategories" BOOLEAN default false,
+  "moderated" BOOLEAN default true,
+  PRIMARY KEY ("id")
+)
+;';
+    pwg_query($query);
+
+    $query = '
+CREATE TABLE "'.$prefixeTable.'community_pendings" (
+  image_id INTEGER NOT NULL,
+  state VARCHAR(255) NOT NULL,
+  added_on TIMESTAMP NOT NULL,
+  validated_by INTEGER
+)
+;';
+    pwg_query($query);
+  }
 }
 
 function plugin_uninstall()
 {
-  $query = 'DROP TABLE '.COMMUNITY_TABLE.';';
+  global $prefixeTable;
+  
+  $query = 'DROP TABLE '.$prefixeTable.'community_permissions;';
+  pwg_query($query);
+
+  $query = 'DROP TABLE '.$prefixeTable.'community_pendings;';
   pwg_query($query);
 }