<?php
  /*
Copy this file to where you have your image files, and run it with php makeratio.php to add ratio to older images. MUST BE DONE FOR NEWEST AIDS TO WORK CORRECTLY ON OLD INSTALLATIONS.

Modify the include below to point to correct plage of database functions.
   */
exec('/bin/ls -1 *.jpg',$list);
$time = time();
include("../includes/functions.classes.php");
$db = new dbcon();
$counter = 0;
foreach($list as $foo) {
  $tmp = explode('.',$foo);
  $fil = $tmp[0];
  $size = getimagesize($fil); 
  $ratio = $size[0]/$size[1];
  $query = "UPDATE `%sfiles` SET `ratio` = '$ratio' WHERE `path` = '$fil'";
  $db->query($query);
  echo ".";
  $counter++;
}
$newtime = time();
echo  "It took ".$newtime-$time." seconds to add information about ".$count." images, or approx. ".($newtime-$time)/$count." secs per image";
?>