<?php
/**
 * Copyright (C) 2010  Hendro Wicaksono (hide@address.com)
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * This program is for generating SWF cache from uploaded PDF files.
 * Only can be run from command line.
 * Go into lib/contents folder. then run:
 * "php update_swfcache.php"
 */

if ($_SERVER['SERVER_ADDR'] == '') {

    include ('../../sysconfig.inc.php');
    mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);
    mysql_select_db(DB_NAME);
    $sql = "SELECT files.file_id,files.file_dir,files.file_name FROM files,biblio_attachment WHERE mime_type='application/pdf' AND biblio_attachment.file_id=files.file_id";
    $query = mysql_query($sql);

    while ($data = mysql_fetch_array($query)) {
        $sha1_name = sha1($data['file_name']);
        $swf = $sha1_name.'.swf';
        $file_loc = REPO_BASE_DIR.str_ireplace('/', DIRECTORY_SEPARATOR, $data['file_dir']).DIRECTORY_SEPARATOR.$data['file_name'];
        $file_loc = preg_replace("/\/\//i", "/", $file_loc);

        echo 'Processing ...'."\n\n";
        echo $data['file_id'].'-'.$data['file_name'].' - '.$sha1_name."\n";
        echo $file_loc."\n";

        if (!file_exists('../../files/swfs/'.$swf.'')) {
            if (stripos(PHP_OS, 'Darwin') !== false) {
                exec('../swftools/bin/darwin/pdf2swf -o ../../files/swfs/'.$swf.' '.$file_loc.'');
            } else if (stripos(PHP_OS, 'Linux') !== false) {
                exec('../swftools/bin/linux/pdf2swf -o ../../files/swfs/'.$swf.' '.$file_loc.'');
            } else {
                exec('..\swftools\bin\windows\pdf2swf.exe -o ../../files/swfs/'.$swf.' '.$file_loc.'');
            }
        } else {
            echo "\n".'SWF File is already exist. Skipped.'."\n";
        }

        echo "\n".'---------------------------------------'."\n";
    }

} else {
    header ("location:index.php");
}

?>