[mirrorbrain-commits] [opensuse-svn] r6320 - trunk/tools/download-redirector-v2/scanner

Author: poeml
Date: 2009-02-02 14:02:06 -0700 (Mon, 02 Feb 2009)
New Revision: 6320

Modified:
   trunk/tools/download-redirector-v2/scanner/scanner.pl
Log:
mirrorbrain scanner: 
Use NOW(), rather than MySQL-specific synonyms.


Modified: trunk/tools/download-redirector-v2/scanner/scanner.pl
===================================================================
--- trunk/tools/download-redirector-v2/scanner/scanner.pl	2009-02-02 20:48:29 UTC (rev 6319)
+++ trunk/tools/download-redirector-v2/scanner/scanner.pl	2009-02-02 21:02:06 UTC (rev 6320)
_at_@ -314,7 +314,7 @@
   }
 
   unless ($extra_schedule_run) {
-    $sql = "UPDATE server SET last_scan = CURRENT_TIMESTAMP, scan_fpm = $fpm WHERE id = $row->{id};";
+    $sql = "UPDATE server SET last_scan = NOW(), scan_fpm = $fpm WHERE id = $row->{id};";
     print "$sql\n" if $verbose > 1;
     my $sth = $dbh->prepare( $sql );
     $sth->execute() or die $sth->err;
_at_@ -754,7 +754,7 @@
   if(checkfileserver_fileid($serverid, $fileid)) {
     my $sql = "UPDATE file_server SET 
       timestamp_file = FROM_UNIXTIME(?),
-      timestamp_scanner = CURRENT_TIMESTAMP()
+      timestamp_scanner = NOW()
       WHERE fileid = ? AND serverid = ?;";
 
     my $sth = $dbh->prepare( $sql );
_at_@ -764,7 +764,7 @@
     my $sql = "INSERT INTO file_server SET fileid = ?,
       serverid = ?,
       timestamp_file = FROM_UNIXTIME(?), 
-      timestamp_scanner = CURRENT_TIMESTAMP();";
+      timestamp_scanner = NOW();";
     #convert timestamp to mysql timestamp
     my $sth = $dbh->prepare( $sql );
     $sth->execute( $fileid, $serverid, $file_tstamp ) or die $sth->errstr;

_______________________________________________
Opensuse-svn mailing list
Opensuse-svn_at_forge.novell.com
http://forge.novell.com/mailman/listinfo/opensuse-svn


_______________________________________________
mirrorbrain-commits mailing list

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org