source: trunk/scripts/attach-fix-case @ 1184

#! /usr/bin/env php
<?php
// This script is used to repair bad filenames in the IA_ROOT_DIR/attach folder.
// Previously infoarena lowercased the filename for any attachment making "test" and "Test" 
// having the same file in the attach folder. This script tries to fix this behavior.

require_once(dirname($argv[0]) . "/utilities.php");
require_once(IA_ROOT_DIR."common/db/attachment.php");

ini_set("memory_limit", "128M");

function attachment_get_bad_filepath($attach) {
    assert(is_array($attach));
    return IA_ROOT_DIR.'attach/'.
            strtolower(preg_replace('/[^a-z0-9\.\-_]/i', '_', $attach['page'])) . '_' .
            strtolower(preg_replace('/[^a-z0-9\.\-_]/i', '_', $attach['name'])) . '_' .
            $attach['id'];
}

db_connect();
$query = "SELECT * FROM ia_file;";
$attachments = db_fetch_all($query);
$fixed = $errors = 0;

log_print("Exista ".count($attachments)." atasamente...");
foreach ($attachments as $attach) {
    if ($attach['name'] == strtolower($attach['name'])) {
        continue;
    }
    log_print('Verific '.$attach['page'].'\\'.$attach['name']);
    $bad_name = attachment_get_bad_filepath($attach);
    if (file_exists($bad_name)) {
        log_print('Repar '.$attach['page'].'\\'.$attach['name']);
        $good_name = attachment_get_filepath($attach);
        if (!@rename($bad_name, $good_name)) {
            log_error("Eroare la redenumire!");
            $errors++;
        }
        $fixed++;
    }
}
log_print("S-au reparat ".$fixed." atasamente!");
log_print("Au avut loc ".$errors." erori!");