Changeset 4220 for extensions/Mail_supervisor/maintain.inc.php
- Timestamp:
- Nov 6, 2009, 1:52:37 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/Mail_supervisor/maintain.inc.php
r4206 r4220 27 27 if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/'); 28 28 include_once (MAIL_SUPERV_PATH.'include/constants.php'); 29 include_once (MAIL_SUPERV_PATH.'include/fonctions.php'); 29 30 31 global $superv_champs , $superv_type ,$superv_bl_champs , $superv_bl_type ; 32 $superv_champs = array( 33 "id", 34 "nb_mails", 35 "date_mail", 36 "nb_mails_maxi", 37 "nb_mails_periode", 38 "nb_spams", 39 "date_spam", 40 "nb_spams_maxi", 41 "nb_spams_periode", 42 "quarantaine", 43 "date_quarantaine", 44 "quarantaine_periode", 45 "message", 46 "message_test", 47 "header_text", 48 49 ); 50 51 $superv_type = array( 52 " SMALLINT( 5 ) NOT NULL DEFAULT '0'" , 53 "INT NOT NULL DEFAULT '0'" , 54 "INT NOT NULL DEFAULT '0'" , 55 "INT NOT NULL DEFAULT '2000'", 56 "TEXT" , 57 "INT NOT NULL DEFAULT '0'", 58 "INT NOT NULL DEFAULT '0'", 59 "INT NOT NULL DEFAULT '10'", 60 "TEXT" , 61 "TEXT" , 62 "INT NOT NULL DEFAULT '0'", 63 "TEXT" , 64 "TEXT" , 65 "TEXT" , 66 "TEXT" , 67 68 ); 69 30 70 71 $superv_bl_champs = array( 72 "id", 73 "ip", 74 "pays", 75 "region", 76 "ville", 77 "adresse", 78 "fai", 79 "nb" 80 ); 81 82 $superv_bl_type = array( 83 " smallint(5) UNSIGNED NOT NULL auto_increment ", 84 "TEXT" , 85 "TEXT" , 86 "TEXT" , 87 "TEXT" , 88 "TEXT" , 89 "TEXT" , 90 " smallint(5) UNSIGNED " 91 ); 92 93 31 94 function plugin_install() 32 95 { 33 34 35 global $superv_bl_champs,$superv_bl_type ; 36 37 // efface free mail 38 $q = ' 39 SELECT count(`id`) as total FROM `'.PLUGINS_TABLE.'` WHERE `id` LIKE "free_mail" ;'; 40 $plugs = mysql_fetch_array(pwg_query($q),MYSQL_ASSOC); 41 $nb= $plugs['total']; 42 43 if (count($nb)>=1) { 44 /* $q = ' 45 UPDATE ' . PLUGINS_TABLE . ' SET state="inactive" WHERE `id` LIKE "free_mail"'; 46 pwg_query($q); 47 pwg_query( $q );*/ 48 $q = ' 49 DELETE FROM '.PLUGINS_TABLE.' 50 WHERE `id` LIKE "free_mail" 51 ;'; 52 pwg_query($q); 53 $q = 'DROP TABLE IF EXISTS '.FREE_MAIL_TABLE.';'; 54 55 pwg_query( $q ); 56 $q = ' 57 DELETE FROM '.CONFIG_TABLE.' 58 WHERE param="free_mail" 59 ;'; 60 pwg_query($q); 61 62 63 64 } 65 66 67 68 pwg_query( $q ); 69 $q = ' 70 DELETE FROM '.CONFIG_TABLE.' 71 WHERE param="mail_superv" 72 ;'; 73 pwg_query($q); 74 75 76 $q = ' 96 global $conf ; 97 if ( !isset($conf['mail_superv']) ) 98 { 99 plugin_uninstall() ; 100 $query = ' 77 101 INSERT INTO '.CONFIG_TABLE.' (param, value, comment) 78 102 VALUES ("mail_superv","off,off,off,off,off,off,127.0.0.1","Parametres du plugin Mail superviseur") 79 ;'; 80 pwg_query($q); 81 82 83 84 vérif_base(); 85 create_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type) ; 103 ;'; 104 pwg_query($query); 105 //================================================================== 106 107 } 86 108 87 109 } … … 91 113 function plugin_uninstall() 92 114 { 93 global $conf;94 115 95 if (isset($conf['mail_superv'])) 96 { 97 98 $q = ' 116 $query = ' 99 117 DELETE FROM '.CONFIG_TABLE.' 100 118 WHERE param="mail_superv" 101 119 ;'; 102 103 pwg_query($q); 104 105 $q = 'DROP TABLE IF EXISTS '.MAIL_BLACK_LISTE_TABLE.';'; 106 pwg_query( $q ); 107 $q = 'DROP TABLE IF EXISTS '.MAIL_SUPERV_TABLE.';'; 108 pwg_query( $q ); 120 pwg_query($query); 121 $query = 'DROP TABLE IF EXISTS '.MAIL_BLACK_LISTE_TABLE.';'; 122 pwg_query( $query ); 123 $query = 'DROP TABLE IF EXISTS '.MAIL_SUPERV_TABLE.';'; 124 pwg_query( $query); 109 125 110 }111 126 112 127 } … … 114 129 function plugin_activate() 115 130 { 116 131 132 include_once (MAIL_SUPERV_PATH.'include/fonctions.php'); 133 vérif_base() ; 117 134 118 135 }
Note: See TracChangeset
for help on using the changeset viewer.