[Spidertree-cvs] spidertree thumbnailer.php,NONE,1.1

[<sp...@us...>]

Update of /cvsroot/spidertree/spidertree
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25018

Added Files:
	thumbnailer.php 
Log Message:
first pass at quasi-working thumbnails


--- NEW FILE: thumbnailer.php ---
<?php
 
	require_once( '../setup_inc.php' );

	global $dbTiki;

	$dbTiki->StartTrans();

	$sql = "SELECT tq.image_id, i.user_id FROM thumbnail_queue tq, image i
			WHERE tq.begin_date IS NULL AND tq.image_id=i.image_id
			ORDER BY tq.create_date LIMIT 10 FOR UPDATE";
	$rs = $dbTiki->Execute($sql );
	$processIMID = array();
	while( !$rs->EOF ) {
		$processIMID[$rs->fields['image_id']] = $rs->fields['user_id'];
		$sql2 = "UPDATE thumbnail_queue SET begin_date='now' WHERE image_id=?";
		$rs2 = $dbTiki->Execute( $sql2, array( $rs->fields['image_id'] ) );
		$rs->MoveNext();
	}
	
	$dbTiki->CompleteTrans();

	foreach( array_keys( $processIMID ) as $IMID ) {
		$image = new SImage( $IMID, $processIMID[$IMID] );
		$image->generateThumbnails();
	}

?>