upgrade_safe_editing_for_thumbnails.php

<?php
error_reporting(E_ALL);
if ((php_sapi_name() != 'cli')) {
    trigger_error("You can only run this script from the command line\n", E_USER_ERROR);
}

$SYSTEM_ROOT = (isset($_SERVER['argv'][1])) ? $_SERVER['argv'][1] : '';
if (empty($SYSTEM_ROOT)) {
    echo "ERROR: You need to supply the path to the System Root as the first argument\n";
    exit();
}

if (!is_dir($SYSTEM_ROOT) || !is_readable($SYSTEM_ROOT.'/core/include/init.inc')) {
    echo "ERROR: Path provided doesn't point to a Matrix installation's System Root. Please provide correct path and try again.\n";
    exit();
}

require_once $SYSTEM_ROOT.'/core/include/init.inc';
require_once SQ_FUDGE_PATH.'/general/file_system.inc';

// log in as root
$root_user = $GLOBALS['SQ_SYSTEM']->am->getSystemAsset('root_user');
if (!$GLOBALS['SQ_SYSTEM']->setCurrentUser($root_user)) {
    echo "ERROR: Failed logging in as root user\n";
    exit();
}

// forced run level
$GLOBALS['SQ_SYSTEM']->setRunLevel(SQ_RUN_LEVEL_FORCED);

$am = $GLOBALS['SQ_SYSTEM']->am;
$count = 0;
$done_asset = 1;
$bad_assetids = Array();

// get all the assets in the system who are in safe edit status and have a thumbnail attached to it
$sql = "SELECT assetid from sq_ast where status = '64' and assetid IN (select majorid from sq_ast_lnk where value = 'thumbnail')";

$results = MatrixDAL::executeSqlAssoc($sql);
echo "Found ".count($results)." assets that are in 'Safe Editing' status and has thumbnail applied.\n";

foreach ($results as $result) {
    $content = Array();
    echo "Updating $done_asset of ".count($results)." Assets\r";
    $assetid = $result['assetid'];
    $asset   = $GLOBALS['SQ_SYSTEM']->am->getAsset($assetid);
    $notice_link = $GLOBALS['SQ_SYSTEM']->am->getLink($assetid, SQ_LINK_NOTICE, '', TRUE, 'thumbnail');

    // if file exists, write to it else create new one
    if (file_exists($asset->data_path.'/.sq_system/.sq_notice_links')) {
        $content = unserialize(file_to_string($asset->data_path.'/.sq_system/.sq_notice_links'));

        $thumbnail_exists = FALSE;
        foreach ($content as $link) {
            if ($link['value'] == 'thumbnail') {
                $thumbnail_exists = TRUE;
                break;
            }
        }

        $content[] = $notice_link;
        if (!$thumbnail_exists && !string_to_file(serialize($content), $asset->data_path.'/.sq_system/.sq_notice_links')) {
            print_r('Still writing :(');
            $count++;
            $bad_assetids[] = $assetid;
        }
    } else {
        $content[] = $notice_link;
        if (!string_to_file(serialize($content), $asset->data_path.'/.sq_system/.sq_notice_links')) {
            $count++;
            $bad_assetids[] = $assetid;
        }
    }
    $done_asset++;

    unset($assetid);
}


// Warn the user if an error happened
if (!empty($count)) {
    echo "There were $count errors in creating .sq_notice_links files.\nThese assets may need to be reviewed manually.\n";
    echo "Assetids that need to be looked into (These are in error.log too):\n";
    print_r($bad_assetids);

    // put them in error.log too
    log_dump("There were ".$count." errors in creating .sq_notice_links files.\nThese assets may need to be reviewed manually.");
    log_dump("Assetids that need to be looked into :");
    log_dump($bad_assetids);
} else {
    echo "Successfully upgraded ".count($results)." assets.\n";
}

$GLOBALS['SQ_SYSTEM']->restoreRunLevel();


?>