Re: lib/Gallery.php patch for date-uploaded change
"Heath S. Hendrickson" <[email protected]>
| Newsgroups | gmane.comp.horde.ansel |
|---|---|
| Message-ID | <[email protected]> |
Chuck Hagenbuch wrote:
> date('r') isn't really optimal for searches, either. I'd much rather
> see it be
> stored as YYYY-MM-DD HH:MM:SS. That way it's both searchable,
> sortable, and
> easily turned into a timestamp/formatted other ways.
>
ok. attached is a new patch that uses date("Y-m-d h:i:s O").
Also attached is a new script that will convert from timecode based
values to the new format.
h
--
ansel mailing list - Join the hunt: http://horde.org/bounties/#ansel
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]
fix_date-uploaded.php
(text/plain, 1.8 KB)
#!/usr/local/bin/php
<?php
/**
* $Horde: ansel/scripts/fix_paths_vfs_sql.php,v 1.6 2004/01/24 20:04:32 chuck Exp $
*
* This is a script to fix the value stored in the date-uploaded attribute
*/
/**
** Set this to true if you want DB inserts done.
**/
$live = false;
@define('AUTH_HANDLER', true);
@define('ANSEL_BASE', dirname(__FILE__) . '/..');
@define('HORDE_BASE', ANSEL_BASE . '/..');
// Do CLI checks and environment setup first.
require_once HORDE_BASE . '/lib/core.php';
require_once 'Horde/CLI.php';
// Make sure no one runs this from the web.
if (!Horde_CLI::runningFromCLI()) {
exit("Must be run from the command line\n");
}
// Load the CLI environment - make sure there's no time limit, init
// some variables, etc.
require_once ANSEL_BASE . '/lib/base.php';
require_once 'Horde/Share.php';
Horde_CLI::init();
Horde_CLI::init();
$cli = &Horde_CLI::singleton();
$registry = &Registry::singleton();
$registry->pushApp('ansel', false);
$shares = &Horde_Share::singleton($registry->getApp());
$crit['AND'] = array( array('field' => 'name', 'op' => '=', 'test' => 'date-uploaded'),
array('field' => 'value', 'op' => '!=', 'test' => ''));
$images = &$ansel_shares->searchAllImages($crit);
$count = 0;
foreach ($images as $id => $name) {
$image = &$ansel_shares->getImage($name);
$timeVal = $image->get('date-uploaded');
$count++;
if (strstr($timeVal, ",")){
$timecode = strtotime($timeVal);
} else {
$timecode = $timeVal;
}
echo "$count: $id => $timeVal = " . date('Y-m-d h:i:s O', $timecode) . "\n";
if ($live) {
$image->set('date-uploaded', date("Y-m-d h:i:s O", $timecode), true);
}
}
if ($live) {
echo $count . " row(s) updated.\n";
} else {
echo $count . " row(s) would have been updated.\n";
}
Gallery.php.patch_formatDateUploaded
(text/plain, 597 B)
Index: lib/Gallery.php
===================================================================
RCS file: /usr/local/horde/cvs/ansel/lib/Gallery.php,v
retrieving revision 1.61
diff -u -r1.61 Gallery.php
--- lib/Gallery.php 17 May 2004 21:49:02 -0000 1.61
+++ lib/Gallery.php 19 May 2004 03:57:52 -0000
@@ -531,7 +531,7 @@
$this->_image->reset();
$this->data['gallery'] = '-1';
- $this->data['date-uploaded'] = time();
+ $this->data['date-uploaded'] = date("Y-m-d h:i:s O");
if (is_array($image)) {
$this->data['filename'] = $image['filename'];