Changeset 29429 for extensions/meta/admin/admin.php
- Timestamp:
- Sep 8, 2014, 7:24:59 AM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/meta/admin/admin.php
r28236 r29429 1 1 <?php 2 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); 2 3 if (!defined('PHPWG_ROOT_PATH')) 4 die('Hacking attempt!'); 3 5 global $template, $conf, $user; 4 include_once(PHPWG_ROOT_PATH . 'admin/include/tabsheet.class.php');6 include_once(PHPWG_ROOT_PATH . 'admin/include/tabsheet.class.php'); 5 7 load_language('plugin.lang', meta_PATH); 6 8 $my_base_url = get_admin_plugin_menu_link(__FILE__); … … 12 14 13 15 //-------------------------------------------------------- sections definitions 14 15 16 // TAB gest 16 17 if (!isset($_GET['tab'])) … … 18 19 else 19 20 $page['tab'] = $_GET['tab']; 20 21 21 $tabsheet = new tabsheet(); 22 $tabsheet->add('gestion', 23 l10n('meta_onglet_gestion'), 24 $my_base_url.'&tab=gestion'); 25 $tabsheet->add('persometa', 26 l10n('Personal Metadata'), 27 $my_base_url.'&tab=persometa'); 28 29 $MPC = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'ContactForm';")); 30 if($MPC['state'] == 'active') 31 { 32 $tabsheet->add('contactmeta', 33 l10n('Contact page Metadata'), 34 $my_base_url.'&tab=contactmeta'); 35 } 36 $MAP = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'AdditionalPages';")); 37 if($MAP['state'] == 'active') 38 { 39 $tabsheet->add('AdditionalPagesmeta', 40 l10n('Additional Pages Metadata'), 41 $my_base_url.'&tab=AdditionalPagesmeta'); 42 } 43 44 $tabsheet->add('description', 45 l10n('meta_onglet_description'), 46 $my_base_url.'&tab=description'); 22 $tabsheet->add('gestion', l10n('meta_onglet_gestion'), $my_base_url . '&tab=gestion'); 23 $tabsheet->add('persometa', l10n('Personal Metadata'), $my_base_url . '&tab=persometa'); 24 25 $MPC = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'ContactForm';")); 26 if ($MPC['state'] == 'active') { 27 $tabsheet->add('contactmeta', l10n('Contact page Metadata'), $my_base_url . '&tab=contactmeta'); 28 } 29 $MAP = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'AdditionalPages';")); 30 if ($MAP['state'] == 'active') { 31 $tabsheet->add('AdditionalPagesmeta', l10n('Additional Pages Metadata'), $my_base_url . '&tab=AdditionalPagesmeta'); 32 } 33 34 $tabsheet->add('description', l10n('meta_onglet_description'), $my_base_url . '&tab=description'); 47 35 $tabsheet->select($page['tab']); 48 36 $tabsheet->assign(); 49 37 50 38 // Tab gest 51 switch ($page['tab']) 52 { 53 case 'gestion': 39 switch ($page['tab']) { 40 case 'gestion': 54 41 55 42 //read metadata list 56 $groups = array();57 $query = '43 $groups = array(); 44 $query = ' 58 45 select id,metaname 59 46 FROM ' . meta_TABLE . ' 60 47 ORDER BY metaname ASC;'; 61 $result = pwg_query($query); 62 63 while ($row = pwg_db_fetch_assoc($result)) 64 { 65 $groups[$row['id']] = $row['metaname']; 66 } 67 68 $selected = 0; 69 $options[] = l10n('meta_select2'); 70 $options['a'] = '----------------------'; 71 72 73 foreach ($groups as $metalist => $metalist2) 74 { 75 $options[$metalist] = $metalist2; 76 } 77 $template->assign( 78 'gestionA', 79 array( 80 'OPTIONS' => $options, 81 'SELECTED' => $selected 82 )); 83 48 $result = pwg_query($query); 49 while ($row = pwg_db_fetch_assoc($result)) { 50 $groups[$row['id']] = $row['metaname']; 51 } 52 $selected = 0; 53 $options[] = l10n('meta_select2'); 54 $options['a'] = '----------------------'; 55 56 foreach ($groups as $metalist => $metalist2) { 57 $options[$metalist] = $metalist2; 58 } 59 $template->assign( 60 'gestionA', array( 61 'OPTIONS' => $options, 62 'SELECTED' => $selected 63 )); 84 64 85 65 //edit meta 86 if (isset($_POST['submitchoixmeta']) and is_numeric($_POST['metalist']) and (!$_POST['metalist'])==0) 87 { 88 $lire=$_POST['metalist']; 89 $query = ' 66 if (isset($_POST['submitchoixmeta']) and is_numeric($_POST['metalist']) and ( !$_POST['metalist']) == 0) { 67 $lire = $_POST['metalist']; 68 $query = ' 90 69 select id,metaname,metaval 91 70 FROM ' . meta_TABLE . ' 92 WHERE id = \''.$lire.'\' 93 ;'; 94 $result = pwg_query($query); 95 96 $row = pwg_db_fetch_assoc($result); 97 $chname=$row['metaname']; 98 $chval=$row['metaval']; 99 100 $selected2 = ""; 101 102 $template->assign( 103 'meta_edit', 104 array( 105 'VALUE' => $chname, 106 'CONTENT' => $chval, 107 'SELECTED' => $selected2 108 )); 109 } 71 WHERE id = \'' . $lire . '\' 72 ;'; 73 $result = pwg_query($query); 74 75 $row = pwg_db_fetch_assoc($result); 76 $chname = $row['metaname']; 77 $chval = $row['metaval']; 78 79 $selected2 = ""; 80 81 $template->assign( 82 'meta_edit', array( 83 'VALUE' => $chname, 84 'CONTENT' => $chval, 85 'SELECTED' => $selected2 86 )); 87 } 110 88 111 89 //inser metadata in table 112 if (isset($_POST['submitinsmeta'])) 113 { 114 $query = ' 90 if (isset($_POST['submitinsmeta'])) { 91 $query = ' 115 92 UPDATE ' . meta_TABLE . ' 116 SET metaval= \'' .$_POST['inser'].'\'117 WHERE metaname = \'' .$_POST['invisible'].'\'93 SET metaval= \'' . $_POST['inser'] . '\' 94 WHERE metaname = \'' . $_POST['invisible'] . '\' 118 95 ;'; 119 $result = pwg_query($query); 120 array_push($page['infos'], l10n('Metadata updated')); 121 } 122 123 break; 96 $result = pwg_query($query); 97 array_push($page['infos'], l10n('Metadata updated')); 98 } 99 break; 124 100 125 101 //description TAB 126 case 'description': 127 128 $blockdesc = 'description'; 129 $template->assign( 130 $blockdesc, 131 array( 132 'meta'=>l10n('meta_name'), 133 )); 134 break; 102 case 'description': 103 $blockdesc = 'description'; 104 $template->assign( 105 $blockdesc, array( 106 'meta' => l10n('meta_name'), 107 )); 108 break; 135 109 136 110 // TAB personnal metadata 137 case 'persometa': 138 139 $template->assign( 140 'metapersoT', 141 array( 142 'meta'=>l10n('meta_name'), 143 )); 144 $admin_base_url = $my_base_url.'&tab=persometa'; 145 $metapersos = pwg_query("SELECT * FROM `". METAPERSO_TABLE .";"); 146 147 if (pwg_db_num_rows($metapersos)) { 148 while ($metaperso = pwg_db_fetch_assoc($metapersos)) 149 { 150 $items = array( 151 'METANAME' => $metaperso['metaname'], 152 'METAVAL' => $metaperso['metaval'], 153 'METATYPE' => $metaperso['metatype'], 154 'U_DELETE' => $admin_base_url.'&delete='.$metaperso['id'], 155 'U_EDIT' => $admin_base_url.'&edit='.$metaperso['id'], 156 ); 157 158 $template->append('metapersos', $items); 159 } 160 } 161 if (isset($_POST['submitaddpersonalmeta'])) 162 { 163 $template->assign( 164 'meta_edit2', 165 array( 166 'meta'=>l10n('meta_name'), 167 'METAID' => 0, 168 )); 169 } 170 171 if (isset($_POST['submitaddmetaperso'])) 172 { 173 $query = ' 111 case 'persometa': 112 $template->assign( 113 'metapersoT', array( 114 'meta' => l10n('meta_name'), 115 )); 116 $admin_base_url = $my_base_url . '&tab=persometa'; 117 $metapersos = pwg_query("SELECT * FROM `" . METAPERSO_TABLE . ";"); 118 119 if (pwg_db_num_rows($metapersos)) { 120 while ($metaperso = pwg_db_fetch_assoc($metapersos)) { 121 $items = array( 122 'METANAME' => $metaperso['metaname'], 123 'METAVAL' => $metaperso['metaval'], 124 'METATYPE' => $metaperso['metatype'], 125 'U_DELETE' => $admin_base_url . '&delete=' . $metaperso['id'], 126 'U_EDIT' => $admin_base_url . '&edit=' . $metaperso['id'], 127 ); 128 129 $template->append('metapersos', $items); 130 } 131 } 132 if (isset($_POST['submitaddpersonalmeta'])) { 133 $template->assign( 134 'meta_edit2', array( 135 'meta' => l10n('meta_name'), 136 'METAID' => 0, 137 )); 138 } 139 140 if (isset($_POST['submitaddmetaperso'])) { 141 $query = ' 174 142 DELETE 175 143 FROM ' . METAPERSO_TABLE . ' 176 WHERE id = '.$_POST['invisibleID'].' 177 ;'; 178 $result = pwg_query($query); 179 180 181 $q = ' 182 INSERT INTO ' . $prefixeTable . 'metaperso(metaname,metaval,metatype)VALUES ("'.$_POST['insername'].'","'.$_POST['inserval'].'","'.$_POST['insertype'].'");'; 183 pwg_query($q); 184 $_SESSION['page_infos'] = array(l10n('Personal metadata update')); 185 redirect($admin_base_url); 186 } 187 188 if (isset($_GET['edit'])) 189 { 190 check_input_parameter('edit', $_GET, false, PATTERN_ID); 191 192 $query = ' 144 WHERE id = ' . $_POST['invisibleID'] . ' 145 ;'; 146 $result = pwg_query($query); 147 $q = ' 148 INSERT INTO ' . $prefixeTable . 'metaperso(metaname,metaval,metatype)VALUES ("' . $_POST['insername'] . '","' . $_POST['inserval'] . '","' . $_POST['insertype'] . '");'; 149 pwg_query($q); 150 $_SESSION['page_infos'] = array(l10n('Personal metadata update')); 151 redirect($admin_base_url); 152 } 153 154 if (isset($_GET['edit'])) { 155 check_input_parameter('edit', $_GET, false, PATTERN_ID); 156 157 $query = ' 193 158 select id,metaname,metaval,metatype 194 159 FROM ' . METAPERSO_TABLE . ' 195 WHERE id = \''.$_GET['edit'].'\' 196 ;'; 197 $result = pwg_query($query); 198 $row = pwg_db_fetch_assoc($result); 199 $template->assign( 200 'meta_edit2', 201 array( 202 'METAID' => $row['id'], 203 'METANAME' => $row['metaname'], 204 'METAVAL' => $row['metaval'], 205 'METATYPE' => $row['metatype'], 206 )); 207 208 } 209 210 if (isset($_GET['delete'])) 211 { 212 check_input_parameter('delete', $_GET, false, PATTERN_ID); 213 214 $query = ' 160 WHERE id = \'' . $_GET['edit'] . '\' 161 ;'; 162 $result = pwg_query($query); 163 $row = pwg_db_fetch_assoc($result); 164 $template->assign( 165 'meta_edit2', array( 166 'METAID' => $row['id'], 167 'METANAME' => $row['metaname'], 168 'METAVAL' => $row['metaval'], 169 'METATYPE' => $row['metatype'], 170 )); 171 } 172 173 if (isset($_GET['delete'])) { 174 check_input_parameter('delete', $_GET, false, PATTERN_ID); 175 $query = ' 215 176 DELETE 216 FROM ' .METAPERSO_TABLE.'217 WHERE id = ' .$_GET['delete'].'177 FROM ' . METAPERSO_TABLE . ' 178 WHERE id = ' . $_GET['delete'] . ' 218 179 ;'; 219 pwg_query($query); 220 221 $_SESSION['page_infos'] = array(l10n('Personal metadata update')); 222 redirect($admin_base_url); 223 } 224 225 226 break; 227 228 case 'contactmeta': 229 if (empty($conf['contactmeta'])) 230 { 231 $conf['contactmeta'] = ','; 232 } 233 234 $metacontact = explode(',', $conf['contactmeta']); 235 236 $template->assign('contactmetaT', 237 array('CMKEY' => $metacontact[0],'CMDESC' => $metacontact[1],)); 238 239 if (isset($_POST['submitcm'])) 240 { 241 $INSCM = $_POST['inser'].",".$_POST['inser2']; 242 conf_update_param('contactmeta', $INSCM); 243 array_push($page['infos'], l10n('Metadata updated')); 244 $template->assign( 245 'contactmetaT', 246 array('CMKEY' => stripslashes($_POST['inser']),'CMDESC' => stripslashes($_POST['inser2']))); 247 } 248 249 break; 250 251 case 'AdditionalPagesmeta': 252 if (!defined('TITLE_AP_TABLE')) define('TITLE_AP_TABLE', $prefixeTable.'title_ap'); 253 $groups = array(); 254 $query = ' 180 pwg_query($query); 181 182 $_SESSION['page_infos'] = array(l10n('Personal metadata update')); 183 redirect($admin_base_url); 184 } 185 break; 186 187 case 'contactmeta': 188 if (empty($conf['contactmeta'])) { 189 $conf['contactmeta'] = ','; 190 } 191 $metacontact = explode(',', $conf['contactmeta']); 192 $template->assign('contactmetaT', array('CMKEY' => $metacontact[0], 'CMDESC' => $metacontact[1],)); 193 194 if (isset($_POST['submitcm'])) { 195 $INSCM = $_POST['inser'] . "," . $_POST['inser2']; 196 conf_update_param('contactmeta', $INSCM); 197 array_push($page['infos'], l10n('Metadata updated')); 198 $template->assign( 199 'contactmetaT', array('CMKEY' => stripslashes($_POST['inser']), 'CMDESC' => stripslashes($_POST['inser2']))); 200 } 201 break; 202 203 case 'AdditionalPagesmeta': 204 if (!defined('TITLE_AP_TABLE')) 205 define('TITLE_AP_TABLE', $prefixeTable . 'title_ap'); 206 $groups = array(); 207 $query = ' 255 208 select id,title 256 209 FROM ' . ADD_PAGES_TABLE . ' 257 210 ORDER BY id ASC;'; 258 $result = pwg_query($query); 259 260 while ($row = pwg_db_fetch_assoc($result)) 261 { 262 $groups[$row['id']] = $row['id'].' : '.$row['title']; 263 } 264 265 $selected = 0; 266 $options[] = l10n('Choose it page'); 267 $options['a'] = '----------------------'; 268 269 foreach($groups as $listid => $listid2) 270 { 271 $options[$listid] = $listid2; 272 } 273 $template->assign( 274 'gestionC', 275 array( 276 'OPTIONS' => $options, 277 'SELECTED' => $selected 278 )); 279 280 if (isset($_POST['submitchoixAP'])and is_numeric($_POST['APchoix']) and (!$_POST['APchoix'])==0) 281 { 282 $lire=$_POST['APchoix']; 283 $query = ' 211 $result = pwg_query($query); 212 while ($row = pwg_db_fetch_assoc($result)) { 213 $groups[$row['id']] = $row['id'] . ' : ' . $row['title']; 214 } 215 216 $selected = 0; 217 $options[] = l10n('Choose it page'); 218 $options['a'] = '----------------------'; 219 220 foreach ($groups as $listid => $listid2) { 221 $options[$listid] = $listid2; 222 } 223 $template->assign( 224 'gestionC', array( 225 'OPTIONS' => $options, 226 'SELECTED' => $selected 227 )); 228 229 if (isset($_POST['submitchoixAP'])and is_numeric($_POST['APchoix']) and ( !$_POST['APchoix']) == 0) { 230 $lire = $_POST['APchoix']; 231 $query = ' 284 232 select id,metaKeyap,metadesap 285 233 FROM ' . META_AP_TABLE . ' 286 WHERE id = \'' .$lire.'\'287 ;'; 288 $result = pwg_query($query);289 $row = pwg_db_fetch_assoc($result);290 $metaKeyapap=$row['metaKeyap'];291 $metadesap=$row['metadesap'];292 293 $query = '234 WHERE id = \'' . $lire . '\' 235 ;'; 236 $result = pwg_query($query); 237 $row = pwg_db_fetch_assoc($result); 238 $metaKeyapap = $row['metaKeyap']; 239 $metadesap = $row['metadesap']; 240 241 $query = ' 294 242 select id,title 295 243 FROM ' . ADD_PAGES_TABLE . ' 296 WHERE id = \'' .$lire.'\'244 WHERE id = \'' . $lire . '\' 297 245 ;'; 298 $result = pwg_query($query); 299 $row = pwg_db_fetch_assoc($result); 300 $idap=$row['id']; 301 $nameap=$row['title']; 302 303 $selected3 = 0; 304 305 $template->assign( 306 'ap_edit', 307 array( 308 'VALUE' => $idap, 309 'VALUEN' => $nameap, 310 'CONTENTMKAP' => $metaKeyapap, 311 'CONTENTMDAP' => $metadesap, 312 'SELECTED' => $selected3 313 )); 314 } 315 316 if (isset($_POST['submitinsapm'])) 317 { 318 $query = ' 246 $result = pwg_query($query); 247 $row = pwg_db_fetch_assoc($result); 248 $idap = $row['id']; 249 $nameap = $row['title']; 250 251 $selected3 = 0; 252 253 $template->assign( 254 'ap_edit', array( 255 'VALUE' => $idap, 256 'VALUEN' => $nameap, 257 'CONTENTMKAP' => $metaKeyapap, 258 'CONTENTMDAP' => $metadesap, 259 'SELECTED' => $selected3 260 )); 261 } 262 263 if (isset($_POST['submitinsapm'])) { 264 $query = ' 319 265 DELETE 320 266 FROM ' . META_AP_TABLE . ' 321 WHERE id = \''.$_POST['invisible'].'\' 322 ;'; 323 $result = pwg_query($query); 324 $q = ' 325 INSERT INTO ' . $prefixeTable . 'meta_ap(id,metaKeyap,metadesap)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'","'.$_POST['inser2'].'");'; 326 pwg_query($q); 327 array_push($page['infos'], l10n('Metadata updated')); 328 } 329 330 break; 331 332 } 333 334 $template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 267 WHERE id = \'' . $_POST['invisible'] . '\' 268 ;'; 269 $result = pwg_query($query); 270 $q = ' 271 INSERT INTO ' . $prefixeTable . 'meta_ap(id,metaKeyap,metadesap)VALUES (' . $_POST['invisible'] . ',"' . $_POST['inser'] . '","' . $_POST['inser2'] . '");'; 272 pwg_query($q); 273 array_push($page['infos'], l10n('Metadata updated')); 274 } 275 break; 276 } 277 278 $template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 335 279 $template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content'); 336 280 ?>
Note: See TracChangeset
for help on using the changeset viewer.