Current Events
How often is AT0 purged?
miikrr x (9)Board List | Topic List | Post New Message | FAQ | TOS | Log Out | Online: 5
From: ns1987 Posted: 8/2/2004 1:52:31 PM | Options | #001
7: Regular User
Online
>_>
---
... >_> <_< ...
From: Onion Posted: 8/2/2004 1:59:50 PM | Options | #002
30: Administrator
Online
The actual purge file is ran nightly at 12:00a EST.

But the topic purge's code is as follows:
# Topic and Message Purge
# (Deletes topics and messages in those topics which are older than two weeks from boards with a count of 500 topics or more)
$result = mysql_query ('SELECT DISTINCT(`board`), COUNT(`topicid`)
FROM `topics`
GROUP BY `board`') or exit(mysql_error());
while ($myrow = mysql_fetch_row ($result)) {
if ($myrow[1] >= 500) {
for ($topics = mysql_query ('SELECT `topicid` FROM `topics` WHERE `lastpost` <= UNIX_TIMESTAMP()-60*60*24*7*2 AND `board` = \''.$myrow[0].'\''); $topicid = mysql_fetch_row ($topics); ) {
mysql_query ('DELETE FROM `messages` WHERE `topic` = \''.$topicid[0].'\'') or exit(mysql_error());
mysql_query ('DELETE FROM `marked` WHERE `topic` = \''.$topicid[0].'\'') or exit(mysql_error());
mysql_query ('DELETE FROM `topics` WHERE `topicid` = \''.$topicid[0].'\'') or exit(mysql_error());
}
}
}