blob: f92248cc03227d117dd82ea5db53af0e80a1f470 (
plain)
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
|
<?php
/**
* Elgg garbage collector.
*
* @package ElggGarbageCollector
* @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU Public License version 2
* @author Curverider Ltd
* @copyright Curverider Ltd 2008
* @link http://elgg.com/
*/
/**
* Initialise the plugin.
*
*/
function garbagecollector_init()
{
$period = get_plugin_setting('period','garbagecollector');
switch ($period)
{
case 'weekly':
case 'monthly' :
case 'yearly' :
break;
default: $period = 'monthly';
}
// Register cron hook
register_plugin_hook('cron', $period, 'garbagecollector_cron');
}
/**
* Cron job
*
*/
function garbagecollector_cron($hook, $entity_type, $returnvalue, $params)
{
global $CONFIG;
$resulttext = elgg_echo('garbagecollector');
// Garbage collect metastrings
$resulttext .= elgg_echo('garbagecollector:gc:metastrings');
$query = "
DELETE
from {$CONFIG->dbprefix}metastrings where
(
(id not in (select name_id from {$CONFIG->dbprefix}metadata)) AND
(id not in (select value_id from {$CONFIG->dbprefix}metadata)) AND
(id not in (select name_id from {$CONFIG->dbprefix}annotations)) AND
(id not in (select value_id from {$CONFIG->dbprefix}annotations))
)";
if (delete_data($query)!==false) {
$resulttext .= elgg_echo('garbagecollector:ok');
} else
$resulttext .= elgg_echo('garbagecollector:error');
$resulttext .= "\n";
// Now we optimize all tables
$tables = get_db_tables();
foreach ($tables as $table) {
$resulttext .= sprintf(elgg_echo('garbagecollector:optimize'), $table);
if (update_data("optimize table $table")!==false)
$resulttext .= elgg_echo('garbagecollector:ok');
else
$resulttext .= elgg_echo('garbagecollector:error');
$resulttext .= "\n";
}
$resulttext .= elgg_echo('garbagecollector:done');
return $returnvalue . $resulttext;
}
// Initialise plugin
register_elgg_event_handler('init','system','garbagecollector_init');
?>
|
