Hi again !
It didn't take long before I cuold check !
The overall work seems to work perfectly FINE !
I have 2 galleries : one 1.3 (modified)... and one 1.4.10.
After this mod, the photos are shown the same way which, TO ME, is vital !!!!
Thanx again Crabboy !!!
ALTHOUGH, there are a few typos that need to be corrected...
In the util.php
1- The text area side has been cut so it's not that easy to import it if your a beginner...
Replace
'exif_date' => array('updatesortingdate', $lang_util_php['update_sort'],'
<b>'. $lang_util_php['update_sort_what'] .' (2):<br />
<input type="radio" name="dateselect" checked="checked" value="0" id="exif
" class="nobg" /><label for="exif" accesskey="x" class="labelradio">'. $lang_util_
php['update_sort_exif'] .'</label><br />
<input type="radio" name="dateselect" value="1" id="cdate" class="nobg" />
<label for="cdate" accesskey="c" class="labelradio">'. $lang_util_php['update_sort
_creation'] .'</label><br /> <br />'),
By :
'exif_date' => array('updatesortingdate', $lang_util_php['update_sort'],'<b>'. $lang_util_php['update_sort_what'] .' (2):</b><br />
<input type="radio" name="dateselect" checked="checked" value="0" id="exif" class="nobg" /><label for="exif" accesskey="x" class="labelradio">'. $lang_util_php['update_sort_exif'] .'</label><br />
<input type="radio" name="dateselect" value="1" id="cdate" class="nobg" /><label for="cdate" accesskey="c" class="labelradio">'.$lang_util_php['update_sort_creation'] .'</label><br /> <br />'),<br />'),
2- the updatesortingdate function has { problems... MEANING YOU CAN'T EVEN OPEN THE UTIL PAGE !!!!
Replace
function updatesortingdate()
{
$albumid = $_POST['albumid'];
$dateselect = $_POST['dateselect'];
global $lang_util_php, $CONFIG;
$query = "SELECT UNIX_TIMESTAMP(mtime) as mtime, {$CONFIG['TABLE_PICTURES']}.* FROM $CONFIG['TABLE_PICTURES']} WHERE aid = '$albumid'";
$result = MYSQL_QUERY($query);
$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {
$filename = $CONFIG['fullpath'] . mysql_result($result, $i, "filepath") . mysql_result($result, $i, "filename");
$pid = mysql_result($result, $i, "pid");
$pdate = mysql_result($result, $i, "ctime");
if($dateselect == '0')
{
$query = "SELECT * FROM {$CONFIG['TABLE_EXIF']} WHERE filename='$filename' ";
$result2 = MYSQL_QUERY($query);
if(mysql_numrows($result2) == 1)
{
$exif = unserialize(mysql_result($result2, 0, "exifData"));
if (isset($exif) && is_array($exif) && isset($exif['DateTime']))
{
$pdate = mktime(substr($exif['DateTime'], 11, 2), substr($exif['DateTime'], 14, 2), substr($exif['DateTime'], 17, 2), substr($exif['DateTime'], 5, 2), substr($exif['DateTime'], 8, 2), substr($exif['DateTime'], 0, 4) );
}
$newdate = date('Y:m:d H:i:s', $pdate);
}
else
{
$newdate = $lang_util_php['update_sort_no_exif'];
}
else // Creation date
{
$newdate = date('Y:m:d H:i:s', $pdate);
}
print $lang_util_php['file'] . ': '. $filename.' ⇒ '. $newdate .'<br />';
my_flush();
$query = "UPDATE {$CONFIG['TABLE_PICTURES']} SET ptime='$pdate' WHERE pid='$pid' ";
MYSQL_QUERY($query);
++$i;
}
}
By :
function updatesortingdate()
{
$albumid = $_POST['albumid'];
$dateselect = $_POST['dateselect'];
global $lang_util_php, $CONFIG;
$query = "SELECT UNIX_TIMESTAMP(mtime) as mtime, {$CONFIG['TABLE_PICTURES']}.* FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$albumid'";
$result = MYSQL_QUERY($query);
$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {
$filename = $CONFIG['fullpath'] . mysql_result($result, $i, "filepath") . mysql_result($result, $i, "filename");
$pid = mysql_result($result, $i, "pid");
$pdate = mysql_result($result, $i, "ctime");
if($dateselect == '0')
{
$query = "SELECT * FROM {$CONFIG['TABLE_EXIF']} WHERE filename='$filename' ";
$result2 = MYSQL_QUERY($query);
if(mysql_numrows($result2) == 1)
{
$exif = unserialize(mysql_result($result2, 0, "exifData"));
if (isset($exif) && is_array($exif) && isset($exif['DateTime']))
{
$pdate = mktime(substr($exif['DateTime'], 11, 2), substr($exif['DateTime'], 14, 2), substr($exif['DateTime'], 17, 2), substr($exif['DateTime'], 5, 2), substr($exif['DateTime'], 8, 2), substr($exif['DateTime'], 0, 4) );
}
$newdate = date('Y:m:d H:i:s', $pdate);
}
else
{
$newdate = $lang_util_php['update_sort_no_exif'];
}
}
else // Creation date
{
$newdate = date('Y:m:d H:i:s', $pdate);
}
print $lang_util_php['file'] . ': '. $filename.' ⇒ '. $newdate .'<br />';
my_flush();
$query = "UPDATE {$CONFIG['TABLE_PICTURES']} SET ptime='$pdate' WHERE pid='$pid' ";
MYSQL_QUERY($query);
++$i;
}
}
Finally, a smal addon if you're using the French language :
On the French.php, after line 1904 :
$lang_util_php = array(
Add :
'update_sort' => 'Mettre ŕ jour le champs qui permet de trier par date',
'update_sort_what' => 'Choisir la date qui servira pour trier les photos',
'update_sort_exif' => 'Date de la prise de photo - EXIF (S\'il n\'y a pas de date, la date du téléchargement sera utilisée.)',
'update_sort_creation' => 'Date du téléchargement',
'update_sort_no_exif' => 'Aucune donnée EXIF',
Now, if you're lazy ( :-) ), here's a zip file containing the 7 modified files :
Bye and thanx again Crabboy !