133 lines
4.1 KiB
PHP
133 lines
4.1 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "include/functions.php";
|
|
include "include/logging-functions.php";
|
|
|
|
$dir = opendir("files");
|
|
$schoolDirs = array();
|
|
while ($file = readdir($dir)) {
|
|
if ($file == ".") continue;
|
|
if ($file == "..") continue;
|
|
if (!is_dir("files/$file")) continue;
|
|
|
|
$schoolDirs[] = $file;
|
|
}
|
|
|
|
closedir($dir);
|
|
sort($schoolDirs);
|
|
|
|
for ($d = 0; $d < count($schoolDirs); $d++) {
|
|
$dir = $schoolDirs[$d];
|
|
$school_num = intval($dir);
|
|
|
|
if ($dir < "00018948") continue;
|
|
|
|
// echo("Directory: $dir\n\n");
|
|
$image_path = "files/$dir/image";
|
|
if (!is_dir($image_path)) {
|
|
echo("Missing Directory: $image_path\n");
|
|
continue;
|
|
}
|
|
|
|
$dp = opendir("files/$dir/image");
|
|
$imagesChanged = array();
|
|
|
|
while ($filename = readdir($dp)) {
|
|
if ($filename == ".") continue;
|
|
if ($filename == "..") continue;
|
|
if ($filename == "_thumbs") continue;
|
|
if (stristr($filename,"-tn.jpg") !== false) continue;
|
|
if (stristr($filename,"-tn.png") !== false) continue;
|
|
if (stristr($filename,"-tn.gif") !== false) continue;
|
|
if (!stripos($filename, ".jpg") &&
|
|
!stripos($filename, ".jpeg") &&
|
|
!stripos($filename, ".jpe") &&
|
|
!stripos($filename, ".gif") &&
|
|
!stripos($filename, ".png")) continue;
|
|
if (!is_file("$image_path/$filename")) continue;
|
|
|
|
// echo("$filename\n");
|
|
$originalName = $filename;
|
|
|
|
// Handle special characters
|
|
$filename = str_replace(' ','_',$filename);
|
|
$filename = str_replace('%20','_',$filename);
|
|
$filename = str_replace('"','',$filename);
|
|
$filename = str_replace("'",'',$filename);
|
|
$filename = str_replace('$','',$filename);
|
|
$filename = str_replace('/','',$filename);
|
|
$filename = str_replace('\\','',$filename);
|
|
$filename = str_replace('(','.',$filename);
|
|
$filename = str_replace(')','',$filename);
|
|
$filename = str_replace('[','',$filename);
|
|
$filename = str_replace(']','',$filename);
|
|
$filename = str_replace('-tn-tn-tn-tn','-tn',$filename);
|
|
$filename = str_replace('-tn-tn-tn','-tn',$filename);
|
|
$filename = str_replace('-tn-tn','-tn',$filename);
|
|
$filename = str_replace('-tn-tn','-tn',$filename);
|
|
$filename = str_replace('-tn-tn','-tn',$filename);
|
|
$filename = str_replace('&','and',$filename);
|
|
$filename = preg_replace('/[^[:print:]]/', '', $filename);
|
|
|
|
if ($originalName != $filename) {
|
|
echo("Rename: $originalName => $filename\n");
|
|
rename("$image_path/$originalName", "$image_path/$filename");
|
|
$imagesChanged[] = array($originalName, $filename);
|
|
}
|
|
|
|
// Resize image and create thumbnail
|
|
resizeImage($filename, $image_path, 1000, 200);
|
|
}
|
|
|
|
if (count($imagesChanged)) {
|
|
echo("======================\n");
|
|
echo("======================\n");
|
|
$query = "SELECT * FROM formatted_content WHERE school_num = $school_num";
|
|
$results = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$record_num = $row['record_num'];
|
|
$content = $row['content'];
|
|
$content_id = $row['content_id'];
|
|
|
|
$ocontent = $content;
|
|
|
|
for ($i = 0; $i < count($imagesChanged); $i++) {
|
|
$oimage = $imagesChanged[$i][0];
|
|
$nimage = $imagesChanged[$i][1];
|
|
|
|
$content = str_replace($oimage, $nimage, $content);
|
|
|
|
if (strpos($oimage, ' ') !== false) {
|
|
$oimage = str_replace(' ','%20',$oimage);
|
|
$content = str_replace($oimage, $nimage, $content);
|
|
}
|
|
}
|
|
|
|
if ($ocontent != $content) {
|
|
echo("ID: $content_id\n");
|
|
echo($ocontent);
|
|
echo("\n");
|
|
|
|
echo("----------------------------------------\n");
|
|
echo($content);
|
|
echo("\n");
|
|
|
|
$content = db_escape_string($content);
|
|
$query = "UPDATE formatted_content SET content = \"$content\" WHERE record_num = $record_num";
|
|
db_query($query);
|
|
}
|
|
else {
|
|
echo("No Change\n");
|
|
}
|
|
|
|
echo("\n");
|
|
}
|
|
// exit();
|
|
}
|
|
|
|
}
|
|
|
|
?>
|