Changeset 32205


Ignore:
Timestamp:
May 16, 2020, 11:37:10 PM (4 years ago)
Author:
ddtddt
Message:

[manage_properties_photos]

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/manage_properties_photos/maintain.class.php

    r32180 r32205  
    115115
    116116  function activate($plugin_version, &$errors=array()){
    117  
     117        global $prefixeTable, $pwg_loaded_plugins;
     118        if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos');
     119        /*Update to manage Typ select date*/
     120        $col = pwg_db_fetch_assoc(pwg_query("SHOW COLUMNS FROM " . ADD_PROP_PHOTO_TABLE . " LIKE 'Typ';"));
     121     if ($col == NULL){
     122                pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `Typ` SMALLINT(5) DEFAULT 1;');
     123                pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `dataprop` LONGTEXT;');
     124                pwg_query('UPDATE '. ADD_PROP_PHOTO_TABLE.' set Typ = 0 where edit =0;');
     125         }
     126       
     127        /*Update for manage date*/
     128        if (!defined('ADD_PROP_PHOTO_DATADATE_TABLE')) define('ADD_PROP_PHOTO_DATADATE_TABLE', $prefixeTable.'add_properties_photos_datadate');
     129        $datatable= pwg_db_fetch_assoc(pwg_query("SHOW TABLES LIKE '" . ADD_PROP_PHOTO_DATADATE_TABLE . "';"));
     130         if ($datatable == NULL){
     131                $query = "CREATE TABLE IF NOT EXISTS ". ADD_PROP_PHOTO_DATADATE_TABLE ." (
     132                id_img SMALLINT(5) UNSIGNED NOT NULL ,
     133                id_prop_pho SMALLINT(5) UNSIGNED NOT NULL ,
     134                datadate datetime ,
     135                PRIMARY KEY (id_img,id_prop_pho))DEFAULT CHARSET=utf8;";
     136                $result = pwg_query($query);
     137         }
    118138  }
    119139
Note: See TracChangeset for help on using the changeset viewer.