#!/usr/bin/php
<?php

include( "config.php" );
include( "misc.php" );
require( "constants.php" );
require( "gfx.php" );


function rescale( $filename )
{
    $timv = gfx_read_timv( $filename . ".timv" );
    if( !$timv )
    {
        echo "reading timv failed<br />\n";
        return null;
    }
    gfx_scale( $filename, $filename, $timv["angle"]*90 );
}

function autoturn( $id, $filename )
{
	$filename = "/var/borg/pics/library/" . $filename;
    $timv = gfx_read_timv( $filename . ".timv" );
    if( !$timv )
    {
        echo "reading timv failed ($filename)<br />\n";
        return null;
    }
	if( $timv["angle"] == 0 )
	{
		return;
	}
	echo "re-scaling $filename\n";
    gfx_scale( $filename, $filename, $timv["angle"]*90 );
}

function main( $argc, $argv )
{
    global $G_CFG_DB_CONNECTION;
    // global $G_CFG_DIR_LIB;

    // chdir( $G_CFG_DIR_LIB );

    $conn = pg_pconnect( $G_CFG_DB_CONNECTION );
    if( !$conn )
    {
        echo "Can't connect to database.\n";
        exit;
    }
    if( $argc < 2 || $argc > 3 )
    {
        echo "usage: scalomat.php first-pic-nr [last-pic-nr]\n";
    }
    else
    {
		$sql = "select ff_id, ff_filename from fotolib_foto where ff_id >= \$1";
		$values = array( 1 => $argv[1] );
		if( $argc == 3 )
		{
			$sql .= " and ff_id <= \$2";
			$values[2] = $argv[2];
		}
		$ress = pg_query_params( $conn, $sql, $values );
		if( $ress )
		{
			$row = pg_fetch_array( $ress, NULL, PGSQL_BOTH );
			while( $row )
			{
				$id = $row["ff_id"];
				$fn = $row["ff_filename"];
				// echo "$id - $fn\n";
				autoturn( $id, $fn );
				$row = pg_fetch_array( $ress, NULL, PGSQL_BOTH );
			}
		}
    }
}

main( count($argv), $argv );

?>