From 0e638df77d8d343b3a162049763e0c225b5c0576 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Sat, 2 Oct 2004 15:28:11 +0000
Subject: [PATCH] gpl + cron

---
 scripts/cron/checkdb.php          | 23 +++++++++++++-
 scripts/cron/clean.php            | 21 +++++++++++++
 scripts/cron/cron_validations.php | 63 +++++++++++++++++++++++++++++++++++++++
 3 files changed, 106 insertions(+), 1 deletion(-)
 create mode 100755 scripts/cron/cron_validations.php

diff --git a/scripts/cron/checkdb.php b/scripts/cron/checkdb.php
index 6668597..f2d87d8 100755
--- a/scripts/cron/checkdb.php
+++ b/scripts/cron/checkdb.php
@@ -1,9 +1,30 @@
 #!/usr/bin/php4 -q
 <?php
+/***************************************************************************
+ *  Copyright (C) 2003-2004 Polytechnique.org                              *
+ *  http://opensource.polytechnique.org/                                   *
+ *                                                                         *
+ *  This program is free software; you can redistribute it and/or modify   *
+ *  it under the terms of the GNU General Public License as published by   *
+ *  the Free Software Foundation; either version 2 of the License, or      *
+ *  (at your option) any later version.                                    *
+ *                                                                         *
+ *  This program is distributed in the hope that it will be useful,        *
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
+ *  GNU General Public License for more details.                           *
+ *                                                                         *
+ *  You should have received a copy of the GNU General Public License      *
+ *  along with this program; if not, write to the Free Software            *
+ *  Foundation, Inc.,                                                      *
+ *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
+ ***************************************************************************
+        $Id: checkdb.php,v 1.2 2004-10-02 15:28:11 x2000habouzit Exp $
+ ***************************************************************************/
 /*
  * verifie qu'il n'y a pas d'incoherences dans les tables de jointures
  * 
- * $Id: checkdb.php,v 1.1 2004-10-02 15:23:38 x2000habouzit Exp $
+ * $Id: checkdb.php,v 1.2 2004-10-02 15:28:11 x2000habouzit Exp $
 */ 
 
 ini_set("include_path","/usr/share/php");
diff --git a/scripts/cron/clean.php b/scripts/cron/clean.php
index 1dac9da..54fe871 100755
--- a/scripts/cron/clean.php
+++ b/scripts/cron/clean.php
@@ -1,5 +1,26 @@
 #!/usr/bin/php4 -q
 <?php
+/***************************************************************************
+ *  Copyright (C) 2003-2004 Polytechnique.org                              *
+ *  http://opensource.polytechnique.org/                                   *
+ *                                                                         *
+ *  This program is free software; you can redistribute it and/or modify   *
+ *  it under the terms of the GNU General Public License as published by   *
+ *  the Free Software Foundation; either version 2 of the License, or      *
+ *  (at your option) any later version.                                    *
+ *                                                                         *
+ *  This program is distributed in the hope that it will be useful,        *
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
+ *  GNU General Public License for more details.                           *
+ *                                                                         *
+ *  You should have received a copy of the GNU General Public License      *
+ *  along with this program; if not, write to the Free Software            *
+ *  Foundation, Inc.,                                                      *
+ *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
+ ***************************************************************************
+        $Id: clean.php,v 1.2 2004-10-02 15:28:11 x2000habouzit Exp $
+ ***************************************************************************/
 require("../../include/xorg.misc.inc.php");
 require("../../include/config.xorg.inc.php");
 mysql_connect($globals->dbhost,$globals->dbuser,$globals->dbpwd);
diff --git a/scripts/cron/cron_validations.php b/scripts/cron/cron_validations.php
new file mode 100755
index 0000000..30f4c67
--- /dev/null
+++ b/scripts/cron/cron_validations.php
@@ -0,0 +1,63 @@
+#!/usr/bin/php4 -q
+<?php
+/***************************************************************************
+ *  Copyright (C) 2003-2004 Polytechnique.org                              *
+ *  http://opensource.polytechnique.org/                                   *
+ *                                                                         *
+ *  This program is free software; you can redistribute it and/or modify   *
+ *  it under the terms of the GNU General Public License as published by   *
+ *  the Free Software Foundation; either version 2 of the License, or      *
+ *  (at your option) any later version.                                    *
+ *                                                                         *
+ *  This program is distributed in the hope that it will be useful,        *
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
+ *  GNU General Public License for more details.                           *
+ *                                                                         *
+ *  You should have received a copy of the GNU General Public License      *
+ *  along with this program; if not, write to the Free Software            *
+ *  Foundation, Inc.,                                                      *
+ *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
+ ***************************************************************************
+        $Id: cron_validations.php,v 1.1 2004-10-02 15:28:11 x2000habouzit Exp $
+ ***************************************************************************/
+/* vim: set sw=4 ts=4 sts=4 tw=100:
+ * vérifie qu'il n'y a pas de validations en cours, et maile si c'est le cas
+ * 
+ * $Id: cron_validations.php,v 1.1 2004-10-02 15:28:11 x2000habouzit Exp $
+*/ 
+
+$M_PERIOD = "INTERVAL 3 HOUR"; // période d'envoi des mails de 3h
+$R_PERIOD = "INTERVAL 6 HOUR"; // période de réponse moyenne de 6h
+
+ini_set("include_path","/usr/share/php");
+require("../../include/xorg.misc.inc.php");
+require("../../include/config.xorg.inc.php");
+require("../../../diogenes/lib/diogenes.mailer.inc.php");
+
+mysql_connect($globals->dbhost,$globals->dbuser,$globals->dbpwd);
+mysql_select_db($globals->dbdb);
+
+$sql = mysql_query("SELECT count(stamp), sum(stamp < NOW() - $M_PERIOD), sum(stamp < NOW() - $R_PERIOD) FROM x4dat.requests");
+list($nb,$nbold,$nbveryold) = mysql_fetch_row($sql);
+mysql_free_result($sql);
+
+if(empty($nb))
+	exit;
+
+$mymail = new DiogenesMailer('validation@polytechnique.org', 
+		"validation@polytechnique.org",
+		(empty($nbveryold)?"":"[urgent] ")."il y a $nb validations non effectuées",
+		false, "");
+
+$message =
+	"il y a $nb validation à effectuer \n"
+	.(empty($nbold)?"":"dont $nbold depuis le dernier mail !!!\n")
+	.(empty($nbveryold)?"":"et dont *$nbveryold* sont en retard de plus de 6h !!!")
+	."\n"
+	."https://www.polytechnique.org/admin/valider.php\n";
+
+$message = wordwrap($message,78);  
+$mymail->setBody($message);
+$mymail->send();
+?>
-- 
2.1.4