/
maintain.class.php
85 lines (70 loc) · 2.08 KB
/
maintain.class.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
defined('PHPWG_ROOT_PATH') or die('Hacking attempt!');
class photo_from_email_maintain extends PluginMaintain
{
private $installed = false;
function __construct($plugin_id)
{
parent::__construct($plugin_id);
}
function install($plugin_version, &$errors=array())
{
global $conf, $prefixeTable;
$query = '
CREATE TABLE IF NOT EXISTS '.$prefixeTable.'pfemail_mailboxes (
id int(11) NOT NULL AUTO_INCREMENT,
path varchar(255) NOT NULL,
login varchar(255) NOT NULL,
password varchar(255) NOT NULL,
category_id smallint(5) unsigned DEFAULT NULL,
moderated enum(\'true\',\'false\') NOT NULL DEFAULT \'true\',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;';
pwg_query($query);
$query = '
CREATE TABLE IF NOT EXISTS '.$prefixeTable.'pfemail_pendings (
image_id mediumint(8) unsigned NOT NULL,
state varchar(255) NOT NULL,
added_on datetime NOT NULL,
validated_by mediumint(8) unsigned DEFAULT NULL,
from_name varchar(255) DEFAULT NULL,
from_address varchar(255) DEFAULT NULL,
subject varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;';
pwg_query($query);
$result = pwg_query('SHOW COLUMNS FROM `'.GROUPS_TABLE.'` LIKE "pfemail_notify";');
if (!pwg_db_num_rows($result))
{
pwg_query('ALTER TABLE '.GROUPS_TABLE.' ADD pfemail_notify enum(\'true\', \'false\') DEFAULT \'false\';');
}
$this->installed = true;
}
function activate($plugin_version, &$errors=array())
{
global $prefixeTable;
if (!$this->installed)
{
$this->install($plugin_version, $errors);
}
}
function update($old_version, $new_version, &$errors=array())
{
$this->install($new_version, $errors);
}
function deactivate()
{
}
function uninstall()
{
global $prefixeTable;
$query = 'DROP TABLE '.$prefixeTable.'pfemail_mailboxes;';
pwg_query($query);
$query = 'DROP TABLE '.$prefixeTable.'pfemail_pendings;';
pwg_query($query);
// delete configuration
pwg_query('DELETE FROM `'. CONFIG_TABLE .'` WHERE param IN ("pfemail_last_check");');
}
}
?>