X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;ds=sidebyside;f=src%2Fdb%2Fmysql.cpp;h=304d4963dcaed689e54751ca1b6ed756405e6f80;hb=c51272489a64903f976c6d502fd79925cb537d9b;hp=35bd507efd48979544b5b08b038aee8344342839;hpb=0a2b926f675f3aeb9aba18d0598eebb06e8691f7;p=cassiopeia.git

diff --git a/src/db/mysql.cpp b/src/db/mysql.cpp
index 35bd507..304d496 100644
--- a/src/db/mysql.cpp
+++ b/src/db/mysql.cpp
@@ -319,8 +319,7 @@ void MySQLJobProvider::writeBack( std::shared_ptr<Job> job, std::shared_ptr<Sign
         read_id = std::string( row[0], row[0] + l[0] );
     }
 
-    std::string q = "UPDATE certs SET crt_name='" + this->escape_string( res->crt_name ) + "', serial='" + this->escape_string( res->serial ) + "', caId = '" + this->escape_string( read_id ) + "', created=NOW() WHERE id='" + this->escape_string( job->target ) + "' LIMIT 1";
-
+    std::string q = "UPDATE certs SET crt_name='" + this->escape_string( res->crt_name ) + "', serial='" + this->escape_string( res->serial ) + "', caId = '" + this->escape_string( read_id ) + "', created='" + this->escape_string( res->before ) + "', expire='" + this->escape_string( res->after ) + "'  WHERE id='" + this->escape_string( job->target ) + "' LIMIT 1";
     // TODO write more thingies back
 
     if( query( q ).first ) {