1 | <?php |
---|
2 | |
---|
3 | if(!defined("MAIL_SUPERV_PATH")) |
---|
4 | define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/'); |
---|
5 | |
---|
6 | include_once (MAIL_SUPERV_PATH.'include/constants.php'); |
---|
7 | include_once (MAIL_SUPERV_PATH.'include/fonctions.php'); |
---|
8 | |
---|
9 | function plugin_install() |
---|
10 | { |
---|
11 | |
---|
12 | $q = ' |
---|
13 | INSERT INTO '.CONFIG_TABLE.' (param, value, comment) |
---|
14 | VALUES ("mail_superv","off,on,off ,off,off","Parametres du plugin Mail superviseur") |
---|
15 | ;'; |
---|
16 | pwg_query($q); |
---|
17 | |
---|
18 | |
---|
19 | vérif_base(); |
---|
20 | |
---|
21 | } |
---|
22 | |
---|
23 | |
---|
24 | |
---|
25 | function plugin_uninstall() |
---|
26 | { |
---|
27 | global $conf; |
---|
28 | |
---|
29 | if (isset($conf['mail_superv'])) |
---|
30 | { |
---|
31 | |
---|
32 | $q = ' |
---|
33 | DELETE FROM '.CONFIG_TABLE.' |
---|
34 | WHERE param="mail_superv" |
---|
35 | ;'; |
---|
36 | |
---|
37 | pwg_query($q); |
---|
38 | |
---|
39 | |
---|
40 | |
---|
41 | $q = 'DROP TABLE '.MAIL_SUPERV_TABLE.';'; |
---|
42 | pwg_query( $q ); |
---|
43 | } |
---|
44 | |
---|
45 | } |
---|
46 | |
---|
47 | |
---|
48 | function vérif_base() |
---|
49 | { |
---|
50 | |
---|
51 | $q = " |
---|
52 | CREATE TABLE IF NOT EXISTS ".MAIL_SUPERV_TABLE." ( |
---|
53 | `id` SMALLINT( 5 ) NOT NULL DEFAULT '0', |
---|
54 | |
---|
55 | `nb_mails` INT NOT NULL DEFAULT '0', |
---|
56 | `date_mail` INT NOT NULL DEFAULT '0', |
---|
57 | `nb_mails_maxi` INT NOT NULL DEFAULT '2000', |
---|
58 | `nb_mails_periode` TEXT , |
---|
59 | |
---|
60 | `nb_spams` INT NOT NULL DEFAULT '0', |
---|
61 | `date_spam` INT NOT NULL DEFAULT '0', |
---|
62 | |
---|
63 | `nb_spams_maxi` INT NOT NULL DEFAULT '10', |
---|
64 | `nb_spams_periode` TEXT , |
---|
65 | |
---|
66 | `quarantaine` TEXT NOT NULL , |
---|
67 | `date_quarantaine` INT NOT NULL DEFAULT '0', |
---|
68 | |
---|
69 | |
---|
70 | `message` TEXT NOT NULL , |
---|
71 | `header_text` TEXT NOT NULL , |
---|
72 | PRIMARY KEY (`id` ) |
---|
73 | ) |
---|
74 | ;"; |
---|
75 | pwg_query($q); |
---|
76 | |
---|
77 | $nb = Get_colonnes_de(MAIL_SUPERV_TABLE); |
---|
78 | $table=$nb[MAIL_SUPERV_TABLE]; |
---|
79 | //================================================================================ |
---|
80 | if (!in_array( "nb_mails",$table)) { |
---|
81 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails` INT NOT NULL default '0' "; |
---|
82 | pwg_query($query); } |
---|
83 | if (!in_array( "date_mail",$table)) { |
---|
84 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_mail` INT NOT NULL default '0' "; |
---|
85 | pwg_query($query); } |
---|
86 | |
---|
87 | if (!in_array( "nb_mails_maxi",$table)) { |
---|
88 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails_maxi` INT NOT NULL default '2000' "; |
---|
89 | pwg_query($query); } |
---|
90 | |
---|
91 | if (!in_array( "nb_spams",$table)) { |
---|
92 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams` INT NOT NULL default '0' "; |
---|
93 | pwg_query($query); } |
---|
94 | if (!in_array( "date_spam",$table)) { |
---|
95 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_spam` INT NOT NULL default '0' "; |
---|
96 | pwg_query($query); } |
---|
97 | |
---|
98 | if (!in_array( "nb_spams_maxi",$table)) { |
---|
99 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams_maxi` INT NOT NULL default '10' "; |
---|
100 | pwg_query($query); } |
---|
101 | |
---|
102 | if (!in_array( "quarantaine",$table)) { |
---|
103 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `quarantaine` TEXT NOT NULL , "; |
---|
104 | pwg_query($query); } |
---|
105 | |
---|
106 | if (!in_array( "date_quarantaine",$table)) { |
---|
107 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_quarantaine` INT NOT NULL default '0' "; |
---|
108 | pwg_query($query); } |
---|
109 | |
---|
110 | if (!in_array( "message",$table)) { |
---|
111 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `message` TEXT "; |
---|
112 | pwg_query($query); } |
---|
113 | |
---|
114 | if (!in_array( "header_text",$table)) { |
---|
115 | $query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `header_text` TEXT "; |
---|
116 | pwg_query($query); } |
---|
117 | |
---|
118 | |
---|
119 | $query = " |
---|
120 | SELECT COUNT(*) |
---|
121 | FROM ".MAIL_SUPERV_TABLE." |
---|
122 | ;"; |
---|
123 | //============================================================================== |
---|
124 | list($count) = mysql_fetch_row(pwg_query($query)); |
---|
125 | if ($count == 0) |
---|
126 | { |
---|
127 | $next_day = time() ; |
---|
128 | $date_quarantaine=time(); |
---|
129 | $q = ' |
---|
130 | INSERT INTO '.MAIL_SUPERV_TABLE.' (id, |
---|
131 | nb_mails,date_mail,nb_mails_maxi,nb_mails_periode, |
---|
132 | nb_spams,date_spam,nb_spams_maxi,nb_spams_periode, |
---|
133 | quarantaine, date_quarantaine,message,header_text) |
---|
134 | VALUES (1, |
---|
135 | 0, |
---|
136 | '.time().', |
---|
137 | 2000, |
---|
138 | "1W", |
---|
139 | |
---|
140 | 0, |
---|
141 | '.time().', |
---|
142 | 10, |
---|
143 | "2D", |
---|
144 | |
---|
145 | false, |
---|
146 | '.time().', |
---|
147 | |
---|
148 | "Init.", |
---|
149 | "'.l10n('hello').'" |
---|
150 | ) |
---|
151 | ;'; |
---|
152 | |
---|
153 | |
---|
154 | pwg_query($q); |
---|
155 | |
---|
156 | } |
---|
157 | } |
---|
158 | function Get_colonnes_de($table) |
---|
159 | { |
---|
160 | $columns_of = array(); |
---|
161 | $query = 'DESC '.$table.';'; |
---|
162 | $result = mysql_query($query); |
---|
163 | $columns_of[$table] = array(); |
---|
164 | while ($row = mysql_fetch_row($result)) |
---|
165 | { |
---|
166 | array_push($columns_of[$table], $row[0]); |
---|
167 | } |
---|
168 | return $columns_of; |
---|
169 | } |
---|
170 | ?> |
---|