$sqlToDate = "{$_SESSION[searchForm][searchDate][toYear]}-{$_SESSION[searchForm][searchDate][toMonth]}-{$_SESSION[searchForm][searchDate][toDay]} 00:00:00";
$sql .= "AND {$dbinfo[pre]}media.date_added > '{$sqlFromDate}' AND {$dbinfo[pre]}media.date_added < '{$sqlToDate}' ";
}
$sql .= "\t\r\n\t\t\t\t\t\tAND {$dbinfo[pre]}media.active = 1 \r\n\t\t\t\t\t\tGROUP BY {$dbinfo[pre]}media.media_id \r\n\t\t\t\t\t";
if ($_SESSION['searchForm']['hex']) {
$sql .= "ORDER BY {$dbinfo[pre]}color_palettes.percentage DESC ";
} else {
$sql .= "ORDER BY {$dbinfo[pre]}media.{$_SESSION[searchForm][searchSortBy]} {$_SESSION[searchForm][searchSortType]}";
}
$sql .= "\r\n\t\t\t\t\t\tLIMIT {$mediaStartRecord},{$mediaPerPage}\r\n\t\t\t\t\t";
//echo $sql; exit;
//$mediaCount = mysqli_num_rows(mysqli_query($db,$sql)); // Get the total number of items
//$mediaPages->setTotalResults($mediaCount); // Pass the total number of results to the $pages object
//$sql.= " LIMIT {$mediaStartRecord},{$mediaPerPage}";
//}
$media = new mediaList($sql);
// Create a new mediaList object
if ($returnRows = $media->getRows()) {
if ($returnRows > $mediaPerPage * $config['searchResultLimit']) {
$returnRows = $mediaPerPage * $config['searchResultLimit'];
}
// Limit the results to X pages
$mediaPages->setTotalResults($returnRows);
// Pass the total number of results to the $pages object
$media->getMediaDetails();
// Run the getMediaDetails function to grab all the media file details
$mediaArray = $media->getMediaArray();
// Get the array of media
$thumbMediaDetailsArray = $media->getDetailsFields('thumb');
// Get thumb details
$smarty->assign('thumbMediaDetails', $thumbMediaDetailsArray);
$maxPrevNext = '';
break;
}
$prevNextResult = mysqli_query($db, str_replace('*', "{$dbinfo[pre]}media.media_id", $sql . $maxPrevNext));
while ($prevNext = mysqli_fetch_assoc($prevNextResult)) {
$prevNextArray[] = $prevNext['media_id'];
}
$_SESSION['prevNextArraySess'] = $prevNextArray;
}
//print_r($_SESSION['prevNextArraySess']);
$sql .= "\r\n\t\t\t\tLIMIT {$mediaStartRecord},{$mediaPerPage}\r\n\t\t\t";
// Add the limit code to the query
/*
* Get all the media information and pass it to smarty
*/
$media = new mediaList($sql);
// Create a new mediaList object
if ($returnRows = $media->getRows()) {
//echo $sql; exit;
switch ($mode) {
case 'newest-media':
case 'featured-media':
case 'popular-media':
if ($returnRows > $mediaPerPage * $config['specMediaPageLimit']) {
$returnRows = $mediaPerPage * $config['specMediaPageLimit'];
}
// Limit the results to 20 pages in certain areas //case 'contributor-media':
break;
}
//echo $returnRows; exit;
$mediaPages->setTotalResults($returnRows);
require_once BASE_PATH . '/assets/includes/language.inc.php';
//require_once BASE_PATH.'/assets/includes/cart.inc.php';
//require_once BASE_PATH.'/assets/includes/affiliate.inc.php';
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
try {
$useMediaID = $mediaID;
// Original untouched media ID
if (!$mediaID) {
// Make sure a media ID was passed
exit;
} else {
idCheck($mediaID);
// Make sure ID is numeric
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'";
$mediaInfo = new mediaList($sql);
if ($mediaInfo->getRows()) {
$media = $mediaInfo->getSingleMediaDetails('preview');
$galleryIDArray = $mediaInfo->getMediaGalleryIDs();
// Get an array of galleries this media is in
switch ($incMode) {
default:
case 'digital':
$galleryIDArrayFlat = $galleryIDArray ? implode(",", $galleryIDArray) : 0;
// Get the gallery IDs for this photo
require_once 'media.details.inc.php';
$smarty->assign('mediaID', $mediaID);
$smarty->display('download.mini.window.tpl');
// Smarty template
break;
}
$smarty->assign('discountRows', $discountReturnRows);
$smarty->assign('discountsArray', $discountsArray);
}
if ($edit) {
$smarty->assign('edit', k_encrypt($edit));
$invoiceOptionsResult = mysqli_query($db, "\r\n\t\t\t\t\t\tSELECT *\r\n\t\t\t\t\t\tFROM {$dbinfo[pre]}invoice_options \r\n\t\t\t\t\t\tWHERE invoice_item_id IN ({$edit})\r\n\t\t\t\t\t\t");
if ($invoiceOptionsRows = mysqli_num_rows($invoiceOptionsResult)) {
while ($invoiceOption = mysqli_fetch_array($invoiceOptionsResult)) {
$optionSelections[$invoiceOption['option_gid'] . '-' . $invoiceOption['option_id']] = true;
}
}
}
if ($mediaID) {
// select the media details
$sql = "SELECT * FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'";
$mediaInfo = new mediaList($sql);
$media = $mediaInfo->getSingleMediaDetails('preview');
$mediaPrice = getMediaPrice($media);
// Get the media price based on the license
$mediaCredits = getMediaCredits($media);
// Get the media credits based on the license
$product['price'] = defaultPrice($product['price']);
// Make sure to assign a default price if needed
$product['credits'] = defaultCredits($product['credits']);
// Make sure to assign default credits if needed
/*
* Custom Pricing calculations
*/
$mediaProductsResult = mysqli_query($db, "SELECT * FROM {$dbinfo[pre]}media_products WHERE media_id = '{$mediaID}' AND prod_id = '{$id}'");
// Find if this has a customization
if (mysqli_num_rows($mediaProductsResult)) {
define('PAGE_ENCODING', '');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
try {
$memberID = $_SESSION['member']['mem_id'];
if (!$memberID) {
die('No member ID exists');
}
// Just to be safe make sure a memberID exists before continuing
$downloadsResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}downloads \r\n\t\t\tWHERE mem_id = {$memberID} \r\n\t\t\tORDER BY dl_id DESC\r\n\t\t\t");
if ($returnRows = mysqli_num_rows($downloadsResult)) {
while ($downloads = mysqli_fetch_array($downloadsResult)) {
$downloadsArray[$downloads['dl_id']] = $downloads;
$downloadsArray[$downloads['dl_id']]['download_date_display'] = $customDate->showdate($downloads['dl_date'], 1);
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$downloads[asset_id]}'";
$mediaObj = new mediaList($sql);
// Create a new mediaList object
if ($returnMediaRows = $mediaObj->getRows()) {
$downloadsArray[$downloads['dl_id']]['media'] = $mediaObj->getSingleMediaDetails();
}
switch ($downloads['dl_type']) {
default:
$downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['unknown'];
break;
case "free":
$downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['freeDownload'];
break;
case "sub":
$downloadsArray[$downloads['dl_id']]['download_type_display'] = $lang['subscription'];
break;
case "order":
// Used to make sure the bills are showing in the admins currency
$saleCur->set_custom_cur_defaults($config['settings']['defaultcur']);
$parms['noDefault'] = true;
$contrSalesResult = mysqli_query($db, "\r\n\t\t\tSELECT * FROM {$dbinfo[pre]}commission \r\n\t\t\tLEFT JOIN {$dbinfo[pre]}invoice_items \r\n\t\t\tON {$dbinfo[pre]}commission.oitem_id = {$dbinfo[pre]}invoice_items.oi_id \r\n\t\t\tWHERE {$dbinfo[pre]}commission.contr_id = '{$_SESSION[member][mem_id]}' \r\n\t\t\tAND {$dbinfo[pre]}commission.order_status = '1' \r\n\t\t\tORDER BY {$dbinfo[pre]}commission.com_id DESC\r\n\t\t");
if ($saleRows = mysqli_num_rows($contrSalesResult)) {
while ($contrSales = mysqli_fetch_assoc($contrSalesResult)) {
if ($contrSales['omedia_id']) {
/*
$media = new mediaTools($contrSales['omedia_id']);
$mediaInfo = $media->getMediaInfoFromDB();
$thumbInfo = $media->getIconInfoFromDB();
$verify = $media->verifyMediaSubFileExists('icons');
$mediaStatus = $verify['status'];
*/
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$contrSales[omedia_id]}'";
$mediaObj = new mediaList($sql);
// Create a new mediaList object
if ($returnMediaRows = $mediaObj->getRows()) {
$contrSales['media'] = $mediaObj->getSingleMediaDetails();
}
}
//print_r($contrSales['media']);
switch ($contrSales['comtype']) {
default:
case "cur":
// Currency based payment
$total = $contrSales['com_total'] * $contrSales['item_qty'];
if ($contrSales['item_percent'] == 0) {
// Change a 0 to a 100%
$contrSales['item_percent'] = 100;
}
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceTotal'] = $lineItemPriceTotal;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceTotalLocal'] = $lineItemPriceTotalLocal;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceEach'] = $lineItemPriceEach;
$cartItemsArray[$cartItem['oi_id']]['lineItemPriceEachLocal'] = $lineItemPriceEachLocal;
$cartItemsArray[$cartItem['oi_id']]['lineItemCreditsEach'] = $lineItemCreditsEach;
$cartItemsArray[$cartItem['oi_id']]['lineItemCreditsTotal'] = $lineItemCreditsTotal;
$cartItemsArray[$cartItem['oi_id']]['itemDetails'] = $creditsDetails;
$cartItemsArray[$cartItem['oi_id']]['itemTypeShort'] = 'credit';
// Update prices and credits for invoice item in the db
mysqli_query($db, "\r\n\t\t\t\t\t\t\tUPDATE {$dbinfo[pre]}invoice_items SET \r\n\t\t\t\t\t\t\tprice_total='{$lineItemPriceTotal}',\r\n\t\t\t\t\t\t\tprice='{$lineItemPriceEach}',\r\n\t\t\t\t\t\t\tcredits_total='{$lineItemCreditsTotal}',\r\n\t\t\t\t\t\t\tcredits='{$lineItemCreditsEach}'\r\n\t\t\t\t\t\t\tWHERE oi_id = '{$cartItem[oi_id]}'\r\n\t\t\t\t\t\t");
break;
case "digital":
//$mediaObj = new mediaTools($cartItem['asset_id']);
//$mediaObj->getMediaInfoFromDB($cartItem['asset_id'],$media);
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$cartItem[asset_id]}'";
$mediaInfo = new mediaList($sql);
// Check for customized profile
/*
$customizedDSPResult = mysqli_query($db,"SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media_digital_sizes WHERE ds_id = '{$cartItem[item_id]}' AND media_id = '{$cartItem[asset_id]}'");
if(getRows())
$customizedDSP = mysqli_fetch_assoc($customizedDSPResult);
*/
//print_r($customizedDSP);
//echo "rows: {$customizedRows}";
if ($mediaInfo->getRows()) {
$media = $mediaInfo->getSingleMediaDetails('thumb');
}
$digital = digitalPrep($cartItem['item_id'], $media);
$numOfDigitals += $cartItem['quantity'];
// Count the number of product items in the cart
//$isOriginal = ($cartItem['item_id']) ? true : false;
// Send email about new tag submitted
echo '{"errorCode": "emailSent","errorMessage": "emailSent"}';
// Send confirmation
break;
case "downloadNotAvailable":
case "emailForFile":
if ($config['EncryptIDs']) {
// Decrypt IDs
$mediaID = k_decrypt($mediaID);
} else {
$mediaID = $mediaID;
}
idCheck($mediaID);
// Make sure ID is numeric
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$mediaID}'";
$mediaObj = new mediaList($sql);
if ($mediaObj->getRows()) {
$mediaObj->getMediaDetails();
// Run the getMediaDetails function so I can grab the info later
$media = $mediaObj->getMediaSingle();
// Grab the single returned media info
$smarty->assign('media', $media);
}
//test('workedA');
if ($profileID) {
$dspResult = mysqli_query($db, "SELECT name,ds_id FROM {$dbinfo[pre]}digital_sizes WHERE ds_id = '{$profileID}'");
$dsp = mysqli_fetch_assoc($dspResult);
} else {
$dsp['name'] = $mgrlang['gen_base_price'];
}
$smarty->assign('dsp', $dsp);
require_once BASE_PATH . '/assets/includes/security.inc.php';
require_once BASE_PATH . '/assets/includes/language.inc.php';
require_once BASE_PATH . '/assets/includes/cart.inc.php';
require_once BASE_PATH . '/assets/includes/affiliate.inc.php';
//define('META_TITLE',''); // Override page title, description, keywords and page encoding here
//define('META_DESCRIPTION','');
//define('META_KEYWORDS','');
//define('PAGE_ENCODING','');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
require_once BASE_PATH . '/assets/classes/mediatools.php';
/*
$mediaObj = new mediaTools(588);
$sample = $mediaObj->getSampleInfoFromDB();
print_r($sample);
*/
//mediaImage mediaID=$media.encryptedID type=thumb folderID=$media.encryptedFID
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media";
$mediaObject = new mediaList($sql);
if ($returnRows = $mediaObject->getRows()) {
$mediaObject->getMediaDetails();
// Run the getMediaDetails function to grab all the media file details
$mediaArray = $mediaObject->getMediaArray();
// Get the array of media
//print_r($mediaArray);
foreach ($mediaArray as $key => $media) {
echo "{$media[media_id]} - {$media[linkto]}<br>";
}
}
define('ACCESS', 'public');
// Page access type - public|private
define('INIT_SMARTY', true);
// Use Smarty
require_once BASE_PATH . '/assets/includes/session.php';
require_once BASE_PATH . '/assets/includes/initialize.php';
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'];
$smarty->assign('collectionRows', $returnRows);
$smarty->assign('collection', $collectionArray);
if ($collection['colltype'] == 1) {
$collectionGalleriesResult = mysqli_query($db, "SELECT gallery_id FROM {$dbinfo[pre]}item_galleries WHERE mgrarea = 'collections' AND item_id = '{$downloadKey[collectionID]}'");
while ($collectionGallery = mysqli_fetch_array($collectionGalleriesResult)) {
$collectionGalleriesArray[] = $collectionGallery['gallery_id'];
}
$collectionGalleries = implode(",", $collectionGalleriesArray);
$sql = "\r\n\t\t\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS * \r\n\t\t\t\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}media_galleries \r\n\t\t\t\t\t\t\tON {$dbinfo[pre]}media.media_id = {$dbinfo[pre]}media_galleries.gmedia_id \r\n\t\t\t\t\t\t\tWHERE {$dbinfo[pre]}media_galleries.gallery_id IN ({$collectionGalleries})\r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.active = 1 \r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.approval_status = 1 \r\n\t\t\t\t\t\t\tGROUP BY {$dbinfo[pre]}media.media_id\r\n\t\t\t\t\t\t\tORDER BY {$dbinfo[pre]}media.date_added DESC\r\n\t\t\t\t\t\t";
// LIMIT {$mediaStartRecord},{$mediaPerPage}
} else {
$sql = "\r\n\t\t\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media \r\n\t\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}media_collections \r\n\t\t\t\t\t\t\tON {$dbinfo[pre]}media.media_id = {$dbinfo[pre]}media_collections.cmedia_id\r\n\t\t\t\t\t\t\tWHERE {$dbinfo[pre]}media_collections.coll_id = '{$downloadKey[collectionID]}'\r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.active = 1 \r\n\t\t\t\t\t\t\tAND {$dbinfo[pre]}media.approval_status = 1 \r\n\t\t\t\t\t\t\tGROUP BY {$dbinfo[pre]}media.media_id\r\n\t\t\t\t\t\t\tORDER BY {$dbinfo[pre]}media.date_added DESC\r\n\t\t\t\t\t\t";
// LIMIT {$mediaStartRecord},{$mediaPerPage}
}
// Get the total number of items
$media = new mediaList($sql);
// Create a new mediaList object
if ($returnRows = $media->getRows()) {
$media->getMediaDetails();
// Run the getMediaDetails function to grab all the media file details
$mediaArray = $media->getMediaArray();
// Get the array of media
$thumbMediaDetailsArray = $media->getDetailsFields('thumb');
//echo $nowGMT . " ---- " . $invoiceItem['expires']; exit; // Testing
foreach ($mediaArray as $key => $media) {
if ($orderInfo['order_status'] == 1) {
// Downloadable Status - 0 = order not approved | 1 = active/ok | 2 = expired | 3 = downloads exceeded | 4 = Not available for download
if ($nowGMT > $invoiceItem['expires'] and $invoiceItem['expires'] != '0000-00-00 00:00:00') {
$downloadableStatus = 2;
} else {
// Check if file is available
"
SELECT SQL_CALC_FOUND_ROWS *
FROM {$dbinfo[pre]}media
LEFT JOIN {$dbinfo[pre]}media_galleries
ON {$dbinfo[pre]}media.media_id = {$dbinfo[pre]}media_galleries.gmedia_id
WHERE {$dbinfo[pre]}media_galleries.gallery_id IN ({$memberPermGalleriesForDB})
AND {$dbinfo[pre]}media.active = 1
AND {$dbinfo[pre]}media.approval_status = 1
GROUP BY {$dbinfo[pre]}media.media_id
ORDER BY {$dbinfo[pre]}media.views DESC
LIMIT {$config[settings][popular_media_count]}
";
*/
$sql = "\r\n\t\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\tWHERE {$dbinfo[pre]}media.active = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}media.approval_status = 1 \t\t\t\t\r\n\t\t\t\tAND {$dbinfo[pre]}media.media_id IN (SELECT DISTINCT(gmedia_id) FROM {$dbinfo[pre]}media_galleries WHERE gallery_id IN ({$memberPermGalleriesForDB})) \t\t\t\t\r\n\t\t\t\tORDER BY {$dbinfo[pre]}media.views DESC\r\n\t\t\t\tLIMIT {$config[settings][popular_media_count]}\r\n\t\t\t";
// New 4.3.2
$popularMedia = new mediaList($sql);
// Create a new mediaList object
if ($returnRows = $popularMedia->getRows()) {
//echo "test: ".$returnRows; exit;
$popularMedia->getMediaDetails();
// Run the getMediaDetails function to grab all the media file details
$popularMedia->addThumbDetails = true;
// Get the thumb details as part of the array
$popularMediaArray = $popularMedia->getMediaArray();
// Get the array of popular media
$popularMediaDetailsFields = $popularMedia->getDetailsFields('thumb');
if ($popularMediaDetailsFields) {
$thumbMediaDetailsArray = $thumbMediaDetailsArray + $popularMediaDetailsFields;
}
// Get the output for the details shown under thumbnails
$smarty->assign('popularMediaRows', $returnRows);
