require_once BASE_PATH . '/assets/classes/mediatools.php';
require_once BASE_PATH . '/assets/classes/colors.php';
$colorPalette = new GetMostCommonColors();
try {
$x = 0;
$mediaResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}media WHERE active = 1");
// Select the active media
$mediaRows = mysqli_num_rows($mediaResult);
while ($media = mysqli_fetch_assoc($mediaResult)) {
$colorPaletteResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}color_palettes WHERE media_id = '{$media[media_id]}' ORDER BY cp_id");
$colorPaletteRows = mysqli_num_rows($colorPaletteResult);
if (!$colorPaletteRows and $x < 10) {
$mediaInfo = new mediaTools($media['media_id']);
$folderInfo = $mediaInfo->getFolderInfoFromDB($media['folder_id']);
$folderName = $mediaInfo->getFolderName();
$thumbInfo = $mediaInfo->getThumbInfoFromDB($media['media_id']);
$path = BASE_PATH . "/assets/library/{$folderName}/thumbs/{$thumbInfo[thumb_filename]}";
// xxxxxx No encryption detection
//$image = new imagetools($path);
//$colorPalette = $image->colorPalette(10,5);
if ($config['cpResults'] > 0) {
$colors = $colorPalette->Get_Color($path, $config['cpResults'], $config['cpReduceBrightness'], $config['cpReduceGradients'], $config['cpDelta']);
}
@mysqli_query($db, "DELETE FROM {$dbinfo[pre]}color_palettes WHERE media_id = '{$media[media_id]}'");
// Delete old color palette first - just in case
if (count($colors) > 0) {
echo "Updated: {$media[media_id]}<br>";
// Save color palette
foreach ($colors as $hex => $percentage) {
if ($percentage > 0) {
$percentage = round($percentage, 6);
$status = '0';
$errormessage[] = $mgrlang['gen_not_enough_mem'];
}
} else {
$status = '0';
//$errormessage[] = 'An icon image cannot be automatically created from this filetype: ' . $filename_ext;
}
}
$iconFilesize = filesize($iconImage);
$iconSize = getimagesize($iconImage);
$thumbFilesize = filesize($thumbImage);
$thumbSize = getimagesize($thumbImage);
$sampleFilesize = filesize($sampleImage);
$sampleSize = getimagesize($sampleImage);
if (file_exists($iconImage)) {
if ($thumbInfo = $media->getThumbInfoFromDB()) {
// Update thumb
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}media_thumbnails SET \r\n\t\t\t\t\t\t\tthumb_filename='{$thumbImageName}',\r\n\t\t\t\t\t\t\tthumb_width='{$thumbSize[0]}',\r\n\t\t\t\t\t\t\tthumb_height='{$thumbSize[1]}',\r\n\t\t\t\t\t\t\tthumb_filesize='{$thumbFilesize}'\r\n\t\t\t\t\t\t\tWHERE media_id = '{$mediaID}' \r\n\t\t\t\t\t\t\tAND thumbtype = 'thumb'\r\n\t\t\t\t\t\t\t");
// Update icon
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}media_thumbnails SET \r\n\t\t\t\t\t\t\tthumb_filename='{$iconImageName}',\r\n\t\t\t\t\t\t\tthumb_width='{$iconSize[0]}',\r\n\t\t\t\t\t\t\tthumb_height='{$iconSize[1]}',\r\n\t\t\t\t\t\t\tthumb_filesize='{$iconFilesize}'\r\n\t\t\t\t\t\t\tWHERE media_id = '{$mediaID}' \r\n\t\t\t\t\t\t\tAND thumbtype = 'icon'\r\n\t\t\t\t\t\t\t");
} else {
// No sample - upload and create
# INSERT THUMB INFO INTO THE DATABASE
$sql = "INSERT INTO {$dbinfo[pre]}media_thumbnails (\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tthumbtype,\r\n\t\t\t\t\t\t\t\tthumb_filename,\r\n\t\t\t\t\t\t\t\tthumb_width,\r\n\t\t\t\t\t\t\t\tthumb_height,\r\n\t\t\t\t\t\t\t\tthumb_filesize\r\n\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'thumb',\r\n\t\t\t\t\t\t\t\t'{$thumbImageName}',\r\n\t\t\t\t\t\t\t\t'{$thumbSize[0]}',\r\n\t\t\t\t\t\t\t\t'{$thumbSize[1]}',\r\n\t\t\t\t\t\t\t\t'{$thumbFilesize}'\r\n\t\t\t\t\t\t\t\t)";
$result = mysqli_query($db, $sql);
$thumbSaveID = mysqli_insert_id($db);
# INSERT ICON INFO INTO THE DATABASE
$sql = "INSERT INTO {$dbinfo[pre]}media_thumbnails (\r\n\t\t\t\t\t\t\t\tmedia_id,\r\n\t\t\t\t\t\t\t\tthumbtype,\r\n\t\t\t\t\t\t\t\tthumb_filename,\r\n\t\t\t\t\t\t\t\tthumb_width,\r\n\t\t\t\t\t\t\t\tthumb_height,\r\n\t\t\t\t\t\t\t\tthumb_filesize\r\n\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t'{$mediaID}',\r\n\t\t\t\t\t\t\t\t'icon',\r\n\t\t\t\t\t\t\t\t'{$iconImageName}',\r\n\t\t\t\t\t\t\t\t'{$iconSize[0]}',\r\n\t\t\t\t\t\t\t\t'{$iconSize[1]}',\r\n\t\t\t\t\t\t\t\t'{$iconFilesize}'\r\n\t\t\t\t\t\t\t\t)";
$result = mysqli_query($db, $sql);
$iconSaveID = mysqli_insert_id($db);
}
$sharpen = $config['settings']['thumb_sharpen'];
$watermark = $config['settings']['thumb_wm'] ? $config['settings']['thumb_wm'] : false;
// Determine if a watermark is needed
if ($config['settings']['thumbcrop'] or $crop) {
$thumbCropValue = $config['settings']['thumbcrop_height'];
$crop = $crop ? $crop : $thumbCropValue;
// Set cropping if crop was passed or $config['settings']['thumbcrop'] is on
} else {
$crop = 0;
}
if ($size <= 150) {
$iconDetails = $mediaInfo->getIconInfoFromDB();
// Get an array of the icon details from the db
$path = $config['settings']['library_path'] . DIRECTORY_SEPARATOR . $folderName . DIRECTORY_SEPARATOR . "icons" . DIRECTORY_SEPARATOR . $iconDetails['thumb_filename'];
} else {
$thumbDetails = $mediaInfo->getThumbInfoFromDB();
// Get an array of the thumbnail details from the db
$path = $config['settings']['library_path'] . DIRECTORY_SEPARATOR . $folderName . DIRECTORY_SEPARATOR . "thumbs" . DIRECTORY_SEPARATOR . $thumbDetails['thumb_filename'];
}
break;
case "rollover":
if ($size and !is_numeric($size)) {
header("location: error.php?eType=invalidQuery");
exit;
}
$size = ($size and $size <= $config['settings']['rollover_size']) ? $size : $config['settings']['rollover_size'];
$quality = $config['settings']['rollover_quality'];
$sharpen = $config['settings']['rollover_sharpen'];
$watermark = $config['settings']['rollover_wm'] ? $config['settings']['rollover_wm'] : false;
// Determine if a watermark is needed
if ($config['settings']['rollovercrop'] or $crop) {
require_once BASE_PATH . '/assets/includes/init.member.php';
require_once BASE_PATH . '/assets/includes/security.inc.php';
require_once BASE_PATH . '/assets/includes/language.inc.php';
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/classes/mediatools.php';
try {
$unencryptedMediaID = k_decrypt($mediaID);
// Get the mediaID unencrypted
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$unencryptedMediaID}'";
$mediaObj = new mediaList($sql);
// Create a new mediaList object
if ($returnRows = $mediaObj->getRows()) {
$media = $mediaObj->getSingleMediaDetails();
}
$mediaInfo = new mediaTools($unencryptedMediaID);
$thumb = $mediaInfo->getThumbInfoFromDB();
$sample = $mediaInfo->getSampleInfoFromDB();
if ($media['dsp_type'] == 'video') {
if ($video = $mediaInfo->getVidSampleInfoFromDB()) {
$videoCheck = $mediaInfo->verifyVidSampleExists();
if ($videoCheck['status']) {
// Make sure the video exists
//print_k($videoCheck); exit;
if ($videoCheck['url'] and $config['passVideoThroughPHP'] === false) {
$video['url'] = $videoCheck['url'];
} else {
$video['url'] = $config['settings']['site_url'] . '/video.php?mediaID=' . $media['encryptedID'];
}
// Use PHP pass-through
//echo $video['url']; exit;
//print_k($video);
