[3978] | 1 | <?php |
---|
| 2 | |
---|
| 3 | if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); |
---|
| 4 | |
---|
[7539] | 5 | function plugin_activate() |
---|
| 6 | { |
---|
| 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'); |
---|
[22769] | 13 | define('METAPERSO_TABLE', $prefixeTable.'metaperso'); |
---|
| 14 | |
---|
| 15 | $query = "CREATE TABLE IF NOT EXISTS ". METAPERSO_TABLE ." ( |
---|
| 16 | id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment, |
---|
| 17 | metaname VARCHAR( 255 ) NOT NULL , |
---|
| 18 | metaval lONGTEXT NOT NULL , |
---|
| 19 | metatype VARCHAR( 255 ) NOT NULL , |
---|
| 20 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 21 | $result = pwg_query($query); |
---|
[24393] | 22 | |
---|
[26359] | 23 | if (!isset($conf['contactmeta'])) |
---|
[24393] | 24 | { |
---|
[26359] | 25 | conf_update_param('contactmeta', ''); |
---|
[24393] | 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 ." ( |
---|
| 30 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 31 | metaKeyap VARCHAR( 255 ) NOT NULL , |
---|
| 32 | metadesap VARCHAR( 255 ) NOT NULL , |
---|
| 33 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 34 | $result = pwg_query($query); |
---|
| 35 | |
---|
| 36 | |
---|
[7539] | 37 | //Gestion MAJ2 |
---|
| 38 | $majm2='meta 2.1.0'; |
---|
| 39 | $query = ' |
---|
| 40 | select param,value |
---|
| 41 | FROM ' . CONFIG_TABLE . ' |
---|
| 42 | WHERE param = \''.$majm2.'\' |
---|
| 43 | ;'; |
---|
| 44 | $result = pwg_query($query); |
---|
| 45 | |
---|
[21161] | 46 | $row = pwg_db_fetch_assoc($result); |
---|
[7539] | 47 | $majparam2=$row['param']; |
---|
| 48 | $majvalue2=$row['value']; |
---|
| 49 | |
---|
| 50 | if (!$majvalue2==1 and !is_adviser()) |
---|
| 51 | { |
---|
| 52 | |
---|
| 53 | //Gestion MAJ1 |
---|
| 54 | $majm1='meta 2.0.5'; |
---|
| 55 | $query = ' |
---|
| 56 | select param,value |
---|
| 57 | FROM ' . CONFIG_TABLE . ' |
---|
| 58 | WHERE param = \''.$majm1.'\' |
---|
| 59 | ;'; |
---|
| 60 | $result = pwg_query($query); |
---|
| 61 | |
---|
[21161] | 62 | $row = pwg_db_fetch_assoc($result); |
---|
[7539] | 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 ." ( |
---|
| 70 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 71 | metaKeyimg VARCHAR( 255 ) NOT NULL , |
---|
| 72 | 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 ." ( |
---|
| 77 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 78 | metaKeycat VARCHAR( 255 ) NOT NULL , |
---|
| 79 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 80 | $result = pwg_query($query); |
---|
| 81 | |
---|
| 82 | $query = ' |
---|
| 83 | select id |
---|
| 84 | FROM ' . CATEGORIES_TABLE . ' |
---|
| 85 | ORDER BY id DESC;'; |
---|
| 86 | $result = pwg_query($query); |
---|
[21161] | 87 | $row = pwg_db_fetch_assoc($result); |
---|
[7539] | 88 | |
---|
| 89 | $comp=$row['id']+1; |
---|
| 90 | $i=1; |
---|
| 91 | |
---|
| 92 | while($i < $comp) |
---|
| 93 | { |
---|
| 94 | $query = ' |
---|
| 95 | select id,metaKeywords |
---|
| 96 | FROM ' . CATEGORIES_TABLE . ' |
---|
| 97 | WHERE id = \''.$i.'\''; |
---|
| 98 | $result = pwg_query($query); |
---|
[21161] | 99 | $row = pwg_db_fetch_assoc($result); |
---|
[7539] | 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 | } |
---|
| 136 | } |
---|
| 137 | |
---|
[3978] | 138 | function plugin_install() |
---|
| 139 | { |
---|
[24393] | 140 | global $conf, $prefixeTable; |
---|
[3978] | 141 | |
---|
| 142 | $q = 'CREATE TABLE ' . $prefixeTable . 'meta( |
---|
| 143 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 144 | metaname VARCHAR( 255 ) NOT NULL , |
---|
| 145 | metaval lONGTEXT NOT NULL , |
---|
| 146 | metatype VARCHAR( 255 ) NOT NULL , |
---|
| 147 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;'; |
---|
| 148 | pwg_query($q); |
---|
| 149 | |
---|
| 150 | $q = ' |
---|
| 151 | INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (1,"author","","name");'; |
---|
| 152 | pwg_query($q); |
---|
| 153 | |
---|
| 154 | $q = ' |
---|
| 155 | INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (2,"keywords","","name");'; |
---|
| 156 | pwg_query($q); |
---|
| 157 | |
---|
| 158 | $q = ' |
---|
| 159 | INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (3,"Description","","name");'; |
---|
| 160 | pwg_query($q); |
---|
| 161 | |
---|
[4174] | 162 | $q = ' |
---|
[3978] | 163 | INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");'; |
---|
| 164 | pwg_query($q); |
---|
| 165 | |
---|
[4174] | 166 | if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img'); |
---|
| 167 | $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." ( |
---|
| 168 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 169 | metaKeyimg VARCHAR( 255 ) NOT NULL , |
---|
[7468] | 170 | metadesimg VARCHAR( 255 ) NOT NULL , |
---|
[4174] | 171 | 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 ." ( |
---|
| 176 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 177 | metaKeycat VARCHAR( 255 ) NOT NULL , |
---|
[7468] | 178 | metadescat VARCHAR( 255 ) NOT NULL , |
---|
[4174] | 179 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 180 | $result = pwg_query($query); |
---|
[22769] | 181 | |
---|
| 182 | if (!defined('METAPERSO_TABLE')) define('METAPERSO_TABLE', $prefixeTable.'metaperso'); |
---|
| 183 | $query = "CREATE TABLE IF NOT EXISTS ". METAPERSO_TABLE ." ( |
---|
| 184 | id SMALLINT( 5 ) UNSIGNED NOT NULL auto_increment, |
---|
| 185 | metaname VARCHAR( 255 ) NOT NULL , |
---|
| 186 | metaval lONGTEXT NOT NULL , |
---|
| 187 | metatype VARCHAR( 255 ) NOT NULL , |
---|
| 188 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 189 | $result = pwg_query($query); |
---|
[4176] | 190 | |
---|
[7468] | 191 | $majm1='meta 2.0.5'; |
---|
| 192 | $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");'; |
---|
| 193 | pwg_query($query); |
---|
| 194 | |
---|
| 195 | $majm2='meta 2.1.0'; |
---|
| 196 | $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");'; |
---|
[4174] | 197 | pwg_query($query); |
---|
[24393] | 198 | |
---|
| 199 | |
---|
| 200 | |
---|
| 201 | if (empty($conf['contactmeta'])) |
---|
| 202 | { |
---|
[26359] | 203 | conf_update_param('contactmeta', ''); |
---|
[24393] | 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 ." ( |
---|
| 208 | id SMALLINT( 5 ) UNSIGNED NOT NULL , |
---|
| 209 | metaKeyap VARCHAR( 255 ) NOT NULL , |
---|
| 210 | metadesap VARCHAR( 255 ) NOT NULL , |
---|
| 211 | PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; |
---|
| 212 | $result = pwg_query($query); |
---|
| 213 | |
---|
| 214 | |
---|
| 215 | |
---|
[3978] | 216 | } |
---|
| 217 | |
---|
| 218 | function plugin_uninstall() |
---|
| 219 | { |
---|
[4177] | 220 | |
---|
[7468] | 221 | $majm1='meta 2.0.5'; |
---|
| 222 | $majm2='meta 2.1.0'; |
---|
| 223 | |
---|
| 224 | global $prefixeTable; |
---|
[3978] | 225 | |
---|
| 226 | $q = 'DROP TABLE ' . $prefixeTable . 'meta;'; |
---|
| 227 | pwg_query($q); |
---|
| 228 | |
---|
[7468] | 229 | $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm1.'" LIMIT 1;'; |
---|
[3978] | 230 | pwg_query($q); |
---|
| 231 | |
---|
[7468] | 232 | $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm2.'" LIMIT 1;'; |
---|
| 233 | pwg_query($q); |
---|
| 234 | |
---|
[4174] | 235 | $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;'; |
---|
| 236 | pwg_query($q); |
---|
| 237 | |
---|
| 238 | $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;'; |
---|
| 239 | pwg_query($q); |
---|
[24393] | 240 | |
---|
[26359] | 241 | conf_delete_param('contactmeta'); |
---|
[24393] | 242 | |
---|
| 243 | $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;'; |
---|
| 244 | pwg_query($q); |
---|
[3978] | 245 | } |
---|
| 246 | |
---|
| 247 | |
---|
| 248 | ?> |
---|