1 files changed, 14 insertions, 0 deletions
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)');
+?>