Changeset 29429 for extensions/meta/maintain.inc.php
- Timestamp:
- Sep 8, 2014, 7:24:59 AM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/meta/maintain.inc.php
r28236 r29429 1 1 <?php 2 2 3 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');4 5 function plugin_activate() 6 {7 8 define('meta_DIR', basename(dirname(__FILE__)));9 define('meta_PATH', PHPWG_PLUGINS_PATH . meta_DIR . '/');10 define('meta_TABLE', $prefixeTable . 'meta');11 define('meta_img_TABLE', $prefixeTable . 'meta_img');12 define('meta_cat_TABLE', $prefixeTable . 'meta_cat');13 define('METAPERSO_TABLE', $prefixeTable.'metaperso');14 15 $query = "CREATE TABLE IF NOT EXISTS ". METAPERSO_TABLE ." (3 if (!defined('PHPWG_ROOT_PATH')) 4 die('Hacking attempt!'); 5 6 function plugin_activate() { 7 global $prefixeTable, $template; 8 define('meta_DIR', basename(dirname(__FILE__))); 9 define('meta_PATH', PHPWG_PLUGINS_PATH . meta_DIR . '/'); 10 define('meta_TABLE', $prefixeTable . 'meta'); 11 define('meta_img_TABLE', $prefixeTable . 'meta_img'); 12 define('meta_cat_TABLE', $prefixeTable . 'meta_cat'); 13 define('METAPERSO_TABLE', $prefixeTable . 'metaperso'); 14 15 $query = "CREATE TABLE IF NOT EXISTS " . METAPERSO_TABLE . " ( 16 16 id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment, 17 17 metaname VARCHAR( 255 ) NOT NULL , … … 19 19 metatype VARCHAR( 255 ) NOT NULL , 20 20 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 21 22 23 if (!isset($conf['contactmeta']))24 {25 conf_update_param('contactmeta', ',');26 } 27 28 if (!defined('META_AP_TABLE')) define('META_AP_TABLE', $prefixeTable.'meta_ap');29 $query = "CREATE TABLE IF NOT EXISTS ". META_AP_TABLE ." (21 $result = pwg_query($query); 22 23 if (!isset($conf['contactmeta'])) { 24 conf_update_param('contactmeta', ','); 25 } 26 27 if (!defined('META_AP_TABLE')) 28 define('META_AP_TABLE', $prefixeTable . 'meta_ap'); 29 $query = "CREATE TABLE IF NOT EXISTS " . META_AP_TABLE . " ( 30 30 id SMALLINT( 5 ) UNSIGNED NOT NULL , 31 31 metaKeyap VARCHAR( 255 ) NOT NULL , 32 32 metadesap VARCHAR( 255 ) NOT NULL , 33 33 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 34 $result = pwg_query($query); 35 36 34 $result = pwg_query($query); 35 37 36 //Gestion MAJ2 38 $majm2='meta 2.1.0';39 $query = '37 $majm2 = 'meta 2.1.0'; 38 $query = ' 40 39 select param,value 41 40 FROM ' . CONFIG_TABLE . ' 42 WHERE param = \'' .$majm2.'\'41 WHERE param = \'' . $majm2 . '\' 43 42 ;'; 44 $result = pwg_query($query); 45 46 $row = pwg_db_fetch_assoc($result); 47 $majparam2=$row['param']; 48 $majvalue2=$row['value']; 49 50 if (!$majvalue2==1) 51 { 43 $result = pwg_query($query); 44 45 $row = pwg_db_fetch_assoc($result); 46 $majparam2 = $row['param']; 47 $majvalue2 = $row['value']; 48 49 if (!$majvalue2 == 1) { 52 50 53 51 //Gestion MAJ1 54 $majm1='meta 2.0.5';55 $query = '52 $majm1 = 'meta 2.0.5'; 53 $query = ' 56 54 select param,value 57 55 FROM ' . CONFIG_TABLE . ' 58 WHERE param = \'' .$majm1.'\'56 WHERE param = \'' . $majm1 . '\' 59 57 ;'; 60 $result = pwg_query($query);61 62 $row = pwg_db_fetch_assoc($result);63 $majparam1=$row['param'];64 $majvalue1=$row['value'];65 66 if (!$majvalue1==1) 67 { 68 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img');69 $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." (58 $result = pwg_query($query); 59 60 $row = pwg_db_fetch_assoc($result); 61 $majparam1 = $row['param']; 62 $majvalue1 = $row['value']; 63 64 if (!$majvalue1 == 1) { 65 if (!defined('meta_img_TABLE')) 66 define('meta_img_TABLE', $prefixeTable . 'meta_img'); 67 $query = "CREATE TABLE IF NOT EXISTS " . meta_img_TABLE . " ( 70 68 id SMALLINT( 5 ) UNSIGNED NOT NULL , 71 69 metaKeyimg VARCHAR( 255 ) NOT NULL , 72 70 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 73 $result = pwg_query($query); 74 75 if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat'); 76 $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." ( 71 $result = pwg_query($query); 72 73 if (!defined('meta_cat_TABLE')) 74 define('meta_cat_TABLE', $prefixeTable . 'meta_cat'); 75 $query = "CREATE TABLE IF NOT EXISTS " . meta_cat_TABLE . " ( 77 76 id SMALLINT( 5 ) UNSIGNED NOT NULL , 78 77 metaKeycat VARCHAR( 255 ) NOT NULL , 79 78 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 80 81 82 79 $result = pwg_query($query); 80 81 $query = ' 83 82 select id 84 83 FROM ' . CATEGORIES_TABLE . ' 85 84 ORDER BY id DESC;'; 86 $result = pwg_query($query); 87 $row = pwg_db_fetch_assoc($result); 88 89 $comp=$row['id']+1; 90 $i=1; 91 92 while($i < $comp) 93 { 94 $query = ' 85 $result = pwg_query($query); 86 $row = pwg_db_fetch_assoc($result); 87 88 $comp = $row['id'] + 1; 89 $i = 1; 90 91 while ($i < $comp) { 92 $query = ' 95 93 select id,metaKeywords 96 94 FROM ' . CATEGORIES_TABLE . ' 97 WHERE id = \''.$i.'\''; 98 $result = pwg_query($query); 99 $row = pwg_db_fetch_assoc($result); 100 101 if(!$row['id']==0 and !$row['metaKeywords']==0) 102 { 103 $query = ' 104 INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$row['id'].',"'.$row['metaKeywords'].'");'; 105 $result = pwg_query($query); 106 } 107 ++$i; 108 } 109 110 $query = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`'; 111 pwg_query($query); 112 113 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");'; 114 pwg_query($query); 115 $majvalue1==1; 116 $maj =0; 117 } 118 119 120 $q = ' 121 ALTER TABLE '.meta_cat_TABLE.' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL '; 122 pwg_query($q); 123 124 $q = ' 125 ALTER TABLE '.meta_img_TABLE.' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL '; 126 pwg_query($q); 127 128 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");'; 129 pwg_query($query); 130 131 $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 132 133 $majvalue2==1; 134 $maj =0; 135 } 95 WHERE id = \'' . $i . '\''; 96 $result = pwg_query($query); 97 $row = pwg_db_fetch_assoc($result); 98 99 if (!$row['id'] == 0 and ! $row['metaKeywords'] == 0) { 100 $query = ' 101 INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES (' . $row['id'] . ',"' . $row['metaKeywords'] . '");'; 102 $result = pwg_query($query); 103 } 104 ++$i; 105 } 106 107 $query = ' ALTER TABLE ' . CATEGORIES_TABLE . ' DROP COLUMN `metaKeywords`'; 108 pwg_query($query); 109 110 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm1 . '",1,"MAJ meta");'; 111 pwg_query($query); 112 $majvalue1 == 1; 113 $maj = 0; 114 } 115 116 $q = ' 117 ALTER TABLE ' . meta_cat_TABLE . ' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL '; 118 pwg_query($q); 119 120 $q = ' 121 ALTER TABLE ' . meta_img_TABLE . ' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL '; 122 pwg_query($q); 123 124 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm2 . '",1,"MAJ meta");'; 125 pwg_query($query); 126 127 $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 128 129 $majvalue2 == 1; 130 $maj = 0; 131 } 136 132 } 137 133 138 function plugin_install() 139 { 140 global $conf, $prefixeTable; 141 134 function plugin_install() { 135 global $conf, $prefixeTable; 142 136 $q = 'CREATE TABLE ' . $prefixeTable . 'meta( 143 137 id SMALLINT( 5 ) UNSIGNED NOT NULL , … … 147 141 PRIMARY KEY (id))DEFAULT CHARSET=utf8;'; 148 142 pwg_query($q); 149 150 143 144 $q = ' 151 145 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (1,"author","","name");'; 152 146 pwg_query($q); 153 154 147 148 $q = ' 155 149 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (2,"keywords","","name");'; 156 150 pwg_query($q); 157 158 151 152 $q = ' 159 153 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (3,"Description","","name");'; 160 154 pwg_query($q); 161 162 155 156 $q = ' 163 157 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");'; 164 158 pwg_query($q); 165 159 166 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img'); 167 $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." ( 160 if (!defined('meta_img_TABLE')) 161 define('meta_img_TABLE', $prefixeTable . 'meta_img'); 162 $query = "CREATE TABLE IF NOT EXISTS " . meta_img_TABLE . " ( 168 163 id SMALLINT( 5 ) UNSIGNED NOT NULL , 169 164 metaKeyimg VARCHAR( 255 ) NOT NULL , 170 165 metadesimg VARCHAR( 255 ) NOT NULL , 171 166 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 172 $result = pwg_query($query); 173 174 if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat'); 175 $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." ( 167 $result = pwg_query($query); 168 169 if (!defined('meta_cat_TABLE')) 170 define('meta_cat_TABLE', $prefixeTable . 'meta_cat'); 171 $query = "CREATE TABLE IF NOT EXISTS " . meta_cat_TABLE . " ( 176 172 id SMALLINT( 5 ) UNSIGNED NOT NULL , 177 173 metaKeycat VARCHAR( 255 ) NOT NULL , 178 174 metadescat VARCHAR( 255 ) NOT NULL , 179 175 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 180 $result = pwg_query($query); 181 182 if (!defined('METAPERSO_TABLE')) define('METAPERSO_TABLE', $prefixeTable.'metaperso'); 183 $query = "CREATE TABLE IF NOT EXISTS ". METAPERSO_TABLE ." ( 176 $result = pwg_query($query); 177 178 if (!defined('METAPERSO_TABLE')) 179 define('METAPERSO_TABLE', $prefixeTable . 'metaperso'); 180 $query = "CREATE TABLE IF NOT EXISTS " . METAPERSO_TABLE . " ( 184 181 id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment, 185 182 metaname VARCHAR( 255 ) NOT NULL , … … 187 184 metatype VARCHAR( 255 ) NOT NULL , 188 185 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 189 190 191 $majm1='meta 2.0.5';192 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");';186 $result = pwg_query($query); 187 188 $majm1 = 'meta 2.0.5'; 189 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm1 . '",1,"MAJ meta");'; 193 190 pwg_query($query); 194 191 195 $majm2='meta 2.1.0'; 196 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");'; 197 pwg_query($query); 198 199 200 201 if (empty($conf['contactmeta'])) 202 { 203 conf_update_param('contactmeta', ''); 204 } 205 206 if (!defined('META_AP_TABLE')) define('META_AP_TABLE', $prefixeTable.'meta_ap'); 207 $query = "CREATE TABLE IF NOT EXISTS ". META_AP_TABLE ." ( 192 $majm2 = 'meta 2.1.0'; 193 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("' . $majm2 . '",1,"MAJ meta");'; 194 pwg_query($query); 195 196 if (empty($conf['contactmeta'])) { 197 conf_update_param('contactmeta', ''); 198 } 199 200 if (!defined('META_AP_TABLE')) 201 define('META_AP_TABLE', $prefixeTable . 'meta_ap'); 202 $query = "CREATE TABLE IF NOT EXISTS " . META_AP_TABLE . " ( 208 203 id SMALLINT( 5 ) UNSIGNED NOT NULL , 209 204 metaKeyap VARCHAR( 255 ) NOT NULL , 210 205 metadesap VARCHAR( 255 ) NOT NULL , 211 206 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 212 $result = pwg_query($query); 213 214 215 207 $result = pwg_query($query); 216 208 } 217 209 218 function plugin_uninstall() 219 { 220 221 $majm1='meta 2.0.5'; 222 $majm2='meta 2.1.0'; 223 224 global $prefixeTable; 225 226 $q = 'DROP TABLE ' . $prefixeTable . 'meta;'; 227 pwg_query($q); 228 229 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm1.'" LIMIT 1;'; 230 pwg_query($q); 231 232 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm2.'" LIMIT 1;'; 233 pwg_query($q); 234 235 $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;'; 236 pwg_query($q); 237 238 $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;'; 239 pwg_query($q); 240 241 conf_delete_param('contactmeta'); 210 function plugin_uninstall() { 211 212 $majm1 = 'meta 2.0.5'; 213 $majm2 = 'meta 2.1.0'; 214 215 global $prefixeTable; 216 217 $q = 'DROP TABLE ' . $prefixeTable . 'meta;'; 218 pwg_query($q); 219 220 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="' . $majm1 . '" LIMIT 1;'; 221 pwg_query($q); 222 223 $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="' . $majm2 . '" LIMIT 1;'; 224 pwg_query($q); 225 226 $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;'; 227 pwg_query($q); 228 229 $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;'; 230 pwg_query($q); 231 232 conf_delete_param('contactmeta'); 242 233 } 243 234 244 245 235 ?>
Note: See TracChangeset
for help on using the changeset viewer.