Changeset 26434

Timestamp:

01/09/10 16:44:17 (3 years ago)

Author:

ornicar2

Message:

[Diem][dmChessPlugin]
- automatically clear old games

Files:

• plugins/dmChessPlugin (modified) (1 prop)
• plugins/dmChessPlugin/lib/model/doctrine/PluginDmChessGameTable.class.php (modified) (1 diff)
• plugins/dmChessPlugin/modules/dmChessGame/actions/actions.class.php (modified) (1 diff)

plugins/dmChessPlugin/lib/model/doctrine/PluginDmChessGameTable.class.php

@@ -4 +4 @@
-class PluginDmChessGameTable extends myDoctrineTable
-{
+
+  public function broom()
+  {
+    $query = $this->createQuery('g')
+    // games created yesterday, without a move
+    ->where('g.created_at < ? AND g.turns = ?', array(date ("Y-m-d H:i:s", strtotime('-1 day')), 0))
+    // games with last move one month ago, and not finished
+    ->orWhere('g.updated_at < ? AND g.is_finished = ?', array(date ("Y-m-d H:i:s", strtotime('-1 month')), false));
+
+    $query->delete()->execute();
+  }
-
-  public function preload($id)

plugins/dmChessPlugin/modules/dmChessGame/actions/actions.class.php

@@ -171 +171 @@
-  public function executeCreate(dmWebRequest $request)
-  {
+    // clean old games
+    dmDb::table('DmChessGame')->broom();
+
-    return $this->redirect($this->getHelper()->£link($this->getPage())->param('p', dmDb::table('DmChessPlayer')->startNewGame()->code)->getHref());
-  }