From 5fd9fa480f302902328b81f912dd67ce378284f8 Mon Sep 17 00:00:00 2001
From: citizenz7 <citizenz7@protonmail.com>
Date: Thu, 20 Apr 2017 18:50:55 +0200
Subject: V.1.4.6

---
 Autres/crontab.php | 14 ++++++++++++++
 Autres/crontab.txt |  4 ++++
 2 files changed, 18 insertions(+)
 create mode 100644 Autres/crontab.php
 create mode 100644 Autres/crontab.txt

(limited to 'Autres')

diff --git a/Autres/crontab.php b/Autres/crontab.php
new file mode 100644
index 0000000..b23b83c
--- /dev/null
+++ b/Autres/crontab.php
@@ -0,0 +1,14 @@
+<?php
+
+//Identifiants SQL
+define('DBHOST','localhost');
+define('DBUSER','c4_freetorrent');
+define('DBPASS','1b10"yujl/qnN2)?L{WtT]),%s)y|(Tm');
+define('DBNAME','c4_freetorrent');
+
+//Connexion SQL
+$db = new PDO("mysql:host=".DBHOST.";port=8889;dbname=".DBNAME, DBUSER, DBPASS);
+$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+$stmt = $db->query('DELETE FROM xbt_announce_log WHERE mtime < (NOW() - INTERVAL 59 MINUTE)');
+?>
diff --git a/Autres/crontab.txt b/Autres/crontab.txt
new file mode 100644
index 0000000..d8ac47e
--- /dev/null
+++ b/Autres/crontab.txt
@@ -0,0 +1,4 @@
+# sudo -s
+# crontab -e
+# Freetorrent.fr : on vide xbt_announce_log - crontab toutes les 2 heures
+0 */2 * * * php /var/www/freetorrent.fr/private/crontab.php
-- 
cgit v1.2.1