Datatype fix
EOF;
// Start fix
if ($_GET['set'] == '1') {
include('dbconn.php');
include('config.php');
// Resolve 1.1 vs 1.2 config file compatibility
if (isset ($cfg['op_pics'])) {
// v1.2
$OPpics = $cfg['op_pics'];
$OPPrefix = $cfg['op_pre'];
}
web_line('Set pic properties:');
/*
It's possible the source image can be a JPEG or PNG but there's no way to tell which is the primarty image unless we search the filesystem for both. This is partly my fault thanks to my upload script which allows people to upload JPEGs if $jpgcompression is enabled.
If a PNG exists, we always use that, but if a JPEG exists exclusively, we use that instead. Rather than bang the filesys, we'll read the directory and do lots of string searching to find out what's available. There's probably a better way, but I'm stupid. :)
*/
$path = $OPpics.'/'.$OPPrefix;
// Read the dir
$handle = opendir ($OPpics);
while ($file = readdir ($handle)) {
$extension = strtolower (substr ($file, -3));
if ($extension == 'png' || $extension == 'jpg' || $extension == 'gif') {
$files[] = $file;
}
}
closedir ($handle);
// Collect database entries and let's sort things out
$result = mysql_query('SELECT PIC_ID, px, py, ptype FROM '.$OekakiPoteto_Prefix.'oekakidta');
$total_rows = mysql_num_rows ($result);
// For each DB entry, check filesys
for ($i = 0; $i < $total_rows; $i++) {
$row = mysql_fetch_array ($result);
// If ptype is occupied and $override is 0, we do nothing.
if (empty ($row['ptype']) || $override == 1) {
// Use a PNG by default. If file doesn't exist, DB is not updated.
$row['ptype'] = 'png';
// Check for GIF or JPEG to ensure orphaned PNG files don't cause issues.
$gif_check = $OPPrefix.$row['PIC_ID'].'.gif';
$jpg_check = $OPPrefix.$row['PIC_ID'].'.jpg';
if (in_array ($gif_check, $files)) {
// Found GIF. Use it.
$row['ptype'] = 'gif';
} elseif (in_array ($jpg_check, $files)) {
// Found JPEG. Use it.
$row['ptype'] = 'jpg';
}
$image = $path.$row['PIC_ID'].'.'.$row['ptype'];
if (file_exists ($image)) {
$sizes = GetImageSize ($image);
// OK, we've got all our info. Insert it into DB
echo ("\n");
web_line("PIC: {$row['PIC_ID']}, X: {$sizes[0]}, Y: {$sizes[1]}, TYPE: {$row['ptype']}");
if ($debug != 1) {
$result2 = mysql_query('UPDATE '.$OekakiPoteto_Prefix."oekakidta SET px={$sizes[0]}, py={$sizes[1]}, ptype='{$row['ptype']}' WHERE PIC_ID='{$row['PIC_ID']}'");
sql_check($result2);
} else {
web_line(" “{$image}”");
web_line(" “UPDATE {$OekakiPoteto_Prefix}oekakidta SET px={$sizes[0]}, py={$sizes[1]}, ptype='{$row['ptype']}' WHERE PIC_ID='{$row['PIC_ID']}'”");
}
echo ("
\n");
} else {
// D'OH! Picture missing!
p_line("MISSING PICTURE: {$row['PIC_ID']}, TYPE: {$row['ptype']}");
}
}
}
web_line('Finished pic properties.');
web_line('Done');
echo "\n