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()); } } } |