diff options
Diffstat (limited to 'modules-available/main')
-rw-r--r-- | modules-available/main/hooks/cron.inc.php | 15 | ||||
-rw-r--r-- | modules-available/main/install.inc.php | 8 |
2 files changed, 23 insertions, 0 deletions
diff --git a/modules-available/main/hooks/cron.inc.php b/modules-available/main/hooks/cron.inc.php new file mode 100644 index 00000000..bab27287 --- /dev/null +++ b/modules-available/main/hooks/cron.inc.php @@ -0,0 +1,15 @@ +<?php + +switch (mt_rand(1, 10)) { +case 2: + Database::exec("DELETE FROM property_list WHERE dateline <> 0 AND dateline < UNIX_TIMESTAMP()"); + break; +case 3: + Database::exec("DELETE FROM property WHERE dateline <> 0 AND dateline < UNIX_TIMESTAMP()"); + break; +case 4: + Database::exec("DELETE FROM callback WHERE (UNIX_TIMESTAMP() - dateline) > 86400"); + break; +} + +Trigger::checkCallbacks(); diff --git a/modules-available/main/install.inc.php b/modules-available/main/install.inc.php index 4c9d4baa..e364a905 100644 --- a/modules-available/main/install.inc.php +++ b/modules-available/main/install.inc.php @@ -26,6 +26,14 @@ $res[] = tableCreate('property', " KEY `dateline` (`dateline`) "); +$res[] = tableCreate('property_list', " + `name` varchar(50) NOT NULL, + `dateline` int(10) unsigned NOT NULL DEFAULT '0', + `value` text NOT NULL, + KEY (`name`), + KEY `dateline` (`dateline`) +"); + $res[] = tableCreate('user', " `userid` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(100) NOT NULL, |