From 96b0043571247cfc9df5e0387b6486dadba2bb2a Mon Sep 17 00:00:00 2001 From: x2004lefloch Date: Mon, 30 Apr 2007 15:18:04 +0000 Subject: [PATCH] Correction des stamps des Validations : ils ne sortaient plus au format YmdHis de MySQL. git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1783 839d8a87-29fc-0310-9880-83ba4fa771e5 --- include/validations.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/include/validations.inc.php b/include/validations.inc.php index 1fcbb24..b064108 100644 --- a/include/validations.inc.php +++ b/include/validations.inc.php @@ -32,7 +32,7 @@ class ValidateIterator extends XOrgDBIterator public function __construct () { - parent::__construct('SELECT data,stamp FROM requests ORDER BY stamp', MYSQL_NUM); + parent::__construct('SELECT data, DATE_FORMAT(stamp, "%Y%m%d%H%i%s") FROM requests ORDER BY stamp', MYSQL_NUM); } // }}} @@ -274,7 +274,7 @@ abstract class Validate if ($stamp == -1) { $res = XDB::query('SELECT data FROM requests WHERE user_id={?} and type={?}', $uid, $type); } else { - $res = XDB::query("SELECT data, stamp FROM requests WHERE user_id={?} AND type={?} and stamp={?}", $uid, $type, $stamp); + $res = XDB::query('SELECT data, DATE_FORMAT(stamp, "%Y%m%d%H%i%s") FROM requests WHERE user_id={?} AND type={?} and stamp={?}', $uid, $type, $stamp); } if ($result = $res->fetchOneCell()) { $result = unserialize($result); -- 2.1.4