[Spidertree-cvs] spidertree thumbnailer.php,NONE,1.1
Status: Pre-Alpha
Brought to you by:
spiderr
|
From: <sp...@us...> - 2004-02-13 07:00:22
|
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(); } ?> |