Changeset 7539
- Timestamp:
- Nov 1, 2010, 2:00:17 PM (13 years ago)
- Location:
- extensions/meta
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/meta/admin/admin.php
r7468 r7539 12 12 13 13 //-------------------------------------------------------- sections definitions 14 15 //Gestion MAJ216 $majm2='meta 2.1.0';17 $query = '18 select param,value19 FROM ' . CONFIG_TABLE . '20 WHERE param = \''.$majm2.'\'21 ;';22 $result = pwg_query($query);23 24 $row = mysql_fetch_array($result);25 $majparam2=$row['param'];26 $majvalue2=$row['value'];27 28 if (!$majvalue2==1 and !is_adviser())29 {30 $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl'));31 $maj = 'maj';32 $template->assign(33 $maj,34 array(35 'meta'=>l10n('meta_name'),36 ));37 if (isset($_POST['maj']) and !is_adviser())38 {39 40 41 //Gestion MAJ142 $majm1='meta 2.0.5';43 $query = '44 select param,value45 FROM ' . CONFIG_TABLE . '46 WHERE param = \''.$majm1.'\'47 ;';48 $result = pwg_query($query);49 50 $row = mysql_fetch_array($result);51 $majparam1=$row['param'];52 $majvalue1=$row['value'];53 54 if (!$majvalue1==1)55 {56 global $prefixeTable;57 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img');58 $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." (59 id SMALLINT( 5 ) UNSIGNED NOT NULL ,60 metaKeyimg VARCHAR( 255 ) NOT NULL ,61 PRIMARY KEY (id))DEFAULT CHARSET=utf8;";62 $result = pwg_query($query);63 64 if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat');65 $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." (66 id SMALLINT( 5 ) UNSIGNED NOT NULL ,67 metaKeycat VARCHAR( 255 ) NOT NULL ,68 PRIMARY KEY (id))DEFAULT CHARSET=utf8;";69 $result = pwg_query($query);70 71 $query = '72 select id73 FROM ' . CATEGORIES_TABLE . '74 ORDER BY id DESC;';75 $result = pwg_query($query);76 $row = mysql_fetch_array($result);77 78 $comp=$row['id']+1;79 $i=1;80 81 while($i < $comp)82 {83 $query = '84 select id,metaKeywords85 FROM ' . CATEGORIES_TABLE . '86 WHERE id = \''.$i.'\'';87 $result = pwg_query($query);88 $row = mysql_fetch_array($result);89 90 if(!$row['id']==0 and !$row['metaKeywords']==0)91 {92 $query = '93 INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$row['id'].',"'.$row['metaKeywords'].'");';94 $result = pwg_query($query);95 }96 ++$i;97 }98 99 $query = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`';100 pwg_query($query);101 102 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");';103 pwg_query($query);104 $majvalue1==1;105 $maj =0;106 }107 108 109 $q = '110 ALTER TABLE '.meta_cat_TABLE.' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL ';111 pwg_query($q);112 113 $q = '114 ALTER TABLE '.meta_img_TABLE.' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL ';115 pwg_query($q);116 117 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");';118 pwg_query($query);119 120 $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl'));121 122 array_push($page['infos'], l10n('meta_majt'));123 124 $majvalue2==1;125 $maj =0;126 }127 128 }129 else{130 14 131 15 // Gestion des onglets … … 415 299 416 300 } 417 } 301 418 302 $template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 419 303 $template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content'); -
extensions/meta/admin/admin.tpl
r7468 r7539 2 2 <h2>meta</h2> 3 3 </div> 4 {if isset ($maj)}5 <form method="post" >6 <div style="text-align:center;">7 <input class="submit" name="maj" type="submit" value="{'meta_maj'|@translate}" {$TAG_INPUT_ENABLED} />8 </div>9 </form>10 {/if}11 4 {if isset ($gestionA)} 12 5 <h3>{'meta_desh3'|@translate}</h3> -
extensions/meta/language/en_UK/plugin.lang.php
r7469 r7539 58 58 none : Prevent the robot from pursuing the indexation of the site<br> 59 59 '; 60 61 //upgrade62 $lang['meta_maj'] = 'Upgrade';63 $lang['meta_majt'] = 'Upgrade Complete<br>Please click on the menu meta to return to management plugin';64 65 60 ?> -
extensions/meta/language/es_ES/plugin.lang.php
r7469 r7539 59 59 '; 60 60 61 //upgrade62 $lang['meta_maj'] = 'Actualización';63 $lang['meta_majt'] = 'Actualización acabada <br> haga clic en el menu meta para volver a la gestión del plugin';64 65 61 ?> -
extensions/meta/language/fr_FR/plugin.lang.php
r7469 r7539 58 58 none : Empêche le robot de poursuivre l\'indexation du site<br> 59 59 '; 60 61 //upgrade62 $lang['meta_maj'] = 'Mise à jour';63 $lang['meta_majt'] = 'Mise à jour terminée<br> Faites un clic sur le menu meta pour revenir à la gestion du plugin';64 65 60 ?> -
extensions/meta/language/hu_HU/plugin.lang.php
r7532 r7539 58 58 none : Tiltja a robotoknak, hogy indexeljék a weboldalt<br> 59 59 '; 60 61 //upgrade62 $lang['meta_maj'] = 'Frissítés';63 $lang['meta_majt'] = 'Frissítés sikeres<br>Kérjük kattintson a menüre a meta kezelő bővítményhez történő visszatéréshez';64 65 60 ?> -
extensions/meta/language/it_IT/plugin.lang.php
r7471 r7539 59 59 '; 60 60 61 //upgrade62 $lang['meta_maj'] = 'Aggiornamento';63 $lang['meta_majt'] = 'Aggiornamento completato<br> Cliccare sul menu Meta per ritornare alla pagina di gestione del plugin';64 65 61 ?> -
extensions/meta/maintain.inc.php
r7468 r7539 2 2 3 3 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); 4 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'); 13 14 //Gestion MAJ2 15 $majm2='meta 2.1.0'; 16 $query = ' 17 select param,value 18 FROM ' . CONFIG_TABLE . ' 19 WHERE param = \''.$majm2.'\' 20 ;'; 21 $result = pwg_query($query); 22 23 $row = mysql_fetch_array($result); 24 $majparam2=$row['param']; 25 $majvalue2=$row['value']; 26 27 if (!$majvalue2==1 and !is_adviser()) 28 { 29 30 //Gestion MAJ1 31 $majm1='meta 2.0.5'; 32 $query = ' 33 select param,value 34 FROM ' . CONFIG_TABLE . ' 35 WHERE param = \''.$majm1.'\' 36 ;'; 37 $result = pwg_query($query); 38 39 $row = mysql_fetch_array($result); 40 $majparam1=$row['param']; 41 $majvalue1=$row['value']; 42 43 if (!$majvalue1==1) 44 { 45 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img'); 46 $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." ( 47 id SMALLINT( 5 ) UNSIGNED NOT NULL , 48 metaKeyimg VARCHAR( 255 ) NOT NULL , 49 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 50 $result = pwg_query($query); 51 52 if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat'); 53 $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." ( 54 id SMALLINT( 5 ) UNSIGNED NOT NULL , 55 metaKeycat VARCHAR( 255 ) NOT NULL , 56 PRIMARY KEY (id))DEFAULT CHARSET=utf8;"; 57 $result = pwg_query($query); 58 59 $query = ' 60 select id 61 FROM ' . CATEGORIES_TABLE . ' 62 ORDER BY id DESC;'; 63 $result = pwg_query($query); 64 $row = mysql_fetch_array($result); 65 66 $comp=$row['id']+1; 67 $i=1; 68 69 while($i < $comp) 70 { 71 $query = ' 72 select id,metaKeywords 73 FROM ' . CATEGORIES_TABLE . ' 74 WHERE id = \''.$i.'\''; 75 $result = pwg_query($query); 76 $row = mysql_fetch_array($result); 77 78 if(!$row['id']==0 and !$row['metaKeywords']==0) 79 { 80 $query = ' 81 INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$row['id'].',"'.$row['metaKeywords'].'");'; 82 $result = pwg_query($query); 83 } 84 ++$i; 85 } 86 87 $query = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`'; 88 pwg_query($query); 89 90 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");'; 91 pwg_query($query); 92 $majvalue1==1; 93 $maj =0; 94 } 95 96 97 $q = ' 98 ALTER TABLE '.meta_cat_TABLE.' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL '; 99 pwg_query($q); 100 101 $q = ' 102 ALTER TABLE '.meta_img_TABLE.' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL '; 103 pwg_query($q); 104 105 $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");'; 106 pwg_query($query); 107 108 $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 109 110 $majvalue2==1; 111 $maj =0; 112 } 113 } 4 114 5 115 function plugin_install()
Note: See TracChangeset
for help on using the changeset viewer.