Changeset 30702 for extensions/manage_properties_photos/maintain.class.php

Timestamp:

Dec 6, 2014, 8:32:09 AM (10 years ago)

Author:

ddtddt

Message:

[extensions] - manage_properties_photos -beta 4

File:

• extensions/manage_properties_photos/maintain.class.php (modified) (4 diffs)

extensions/manage_properties_photos/maintain.class.php

@@ -2 +2 @@
 defined('PHPWG_ROOT_PATH') or die('Hacking attempt!');
 
-class manage_info_photos_maintain extends PluginMaintain
+class manage_properties_photos_maintain extends PluginMaintain
 {
   private $installed = false;
@@ -13 +13 @@
        global $prefixeTable;
 
-if (!defined('ADD_INFO_PHOTO_TABLE')) define('ADD_INFO_PHOTO_TABLE', $prefixeTable.'add_Info_photos');
-        $query = "CREATE TABLE IF NOT EXISTS ". ADD_INFO_PHOTO_TABLE ." (
-id_info_pho SMALLINT(5) UNSIGNED NOT NULL auto_increment,
-designation VARCHAR(255) NOT NULL ,
-orderinfo SMALLINT(5) UNSIGNED NOT NULL ,
+if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos');
+        $query = "CREATE TABLE IF NOT EXISTS ". ADD_PROP_PHOTO_TABLE ." (
+id_prop_pho SMALLINT(5) UNSIGNED NOT NULL auto_increment,
+wording VARCHAR(255) NOT NULL ,
+orderprop SMALLINT(5) UNSIGNED NOT NULL ,
 active SMALLINT(5) UNSIGNED NOT NULL ,
 edit SMALLINT(5) UNSIGNED NOT NULL ,
-PRIMARY KEY (id_info_pho))DEFAULT CHARSET=utf8;";
+PRIMARY KEY (id_prop_pho))DEFAULT CHARSET=utf8;";
         $result = pwg_query($query);
 
-if (!defined('ADD_INFO_PHOTO_DATA_TABLE')) define('ADD_INFO_PHOTO_DATA_TABLE', $prefixeTable.'add_Info_photos_data');
-        $query = "CREATE TABLE IF NOT EXISTS ". ADD_INFO_PHOTO_DATA_TABLE ." (
+if (!defined('ADD_PROP_PHOTO_DATA_TABLE')) define('ADD_PROP_PHOTO_DATA_TABLE', $prefixeTable.'add_properties_photos_data');
+        $query = "CREATE TABLE IF NOT EXISTS ". ADD_PROP_PHOTO_DATA_TABLE ." (
 id_img SMALLINT(5) UNSIGNED NOT NULL ,
-id_info_pho SMALLINT(5) UNSIGNED NOT NULL ,
+id_prop_pho SMALLINT(5) UNSIGNED NOT NULL ,
 data VARCHAR(255) NOT NULL ,
-PRIMARY KEY (id_img,id_info_pho))DEFAULT CHARSET=utf8;";
+PRIMARY KEY (id_img,id_prop_pho))DEFAULT CHARSET=utf8;";
         $result = pwg_query($query);
         
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (1,"author",1,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (1,"author",1,0,0);';
     pwg_query($q);
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (2,"Created on",2,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (2,"Created on",2,0,0);';
     pwg_query($q);
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (3,"Posted on",3,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (3,"Posted on",3,0,0);';
     pwg_query($q);
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (4,"Dimensions",4,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (4,"Dimensions",4,0,0);';
     pwg_query($q);    
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (5,"File",5,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (5,"File",5,0,0);';
     pwg_query($q);          
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (6,"Filesize",6,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (6,"Filesize",6,0,0);';
     pwg_query($q);
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (7,"Tags",7,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (7,"Tags",7,0,0);';
     pwg_query($q);   
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (8,"Albums",8,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (8,"Albums",8,0,0);';
     pwg_query($q);      
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (9,"Visits",9,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (9,"Visits",9,0,0);';
     pwg_query($q);       
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (10,"Average",10,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (10,"Average",10,0,0);';
     pwg_query($q);
-$q = 'INSERT INTO ' . $prefixeTable . 'add_Info_photos(id_info_pho,designation,orderinfo,active,edit)VALUES (11,"Who can see this photo?",11,0,0);';
+$q = 'INSERT INTO ' . $prefixeTable . 'add_properties_photos(id_prop_pho,wording,orderprop,active,edit)VALUES (11,"Who can see this photo?",11,0,0);';
     pwg_query($q); 
     
@@ -61 +61 @@
 
   function update($old_version, $new_version, &$errors=array()){
-    global $conf;
-    if (!isset($conf['add_Info_photos'])) {
-        conf_update_param('add_Info_photos','Categories',true);
-    }
+
   }
   
@@ -71 +68 @@
 
   function uninstall(){
-    conf_delete_param('add_Info_photos');
-    $q = 'DROP TABLE ' . $prefixeTable . 'add_Info_photos;';
+    $q = 'DROP TABLE ' . $prefixeTable . 'add_properties_photos;';
     pwg_query($q);
-    $q = 'DROP TABLE ' . $prefixeTable . 'add_Info_photos_data;';
+    $q = 'DROP TABLE ' . $prefixeTable . 'add_properties_photos_data;';
     pwg_query($q);
   }