Changeset 15995 for extensions/Comments_on_Albums/maintain.inc.php

Timestamp:

Jun 24, 2012, 1:49:50 PM (12 years ago)

Author:

mistic100

Message:

improve anti-spam system (Piwigo 2.5 feature)

File:

• extensions/Comments_on_Albums/maintain.inc.php (modified) (2 diffs)

extensions/Comments_on_Albums/maintain.inc.php

@@ -13 +13 @@
   `author` varchar(255) DEFAULT NULL,
   `author_id` smallint(5) DEFAULT NULL,
+  `anonymous_id` varchar(45) NOT NULL,
   `content` longtext,
   `validated` enum('true','false') NOT NULL DEFAULT 'false',
@@ -23 +24 @@
 function plugin_activate()
 {
-  global $conf;
+  global $conf, $prefixeTable;
   
   if (isset($conf['comments_on_albums']))
   {
     pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param="comments_on_albums" LIMIT 1;');
+  }
+  
+  $query = 'SHOW COLUMNS FROM `' . $prefixeTable . 'comments_categories`;';
+  $columns = hash_from_query($query, 'Field');
+  if (!isset($columns['anonymous_id']))
+  {
+    pwg_query('ALTER TABLE `' . $prefixeTable . 'comments_categories` ADD `anonymous_id` VARCHAR( 45 ) DEFAULT NULL;');
   }
 }