Changeset 32205
- Timestamp:
- May 16, 2020, 11:37:10 PM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/manage_properties_photos/maintain.class.php
r32180 r32205 115 115 116 116 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 } 118 138 } 119 139
Note: See TracChangeset
for help on using the changeset viewer.