$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); $smarty->assign('mediaRows', $returnRows); $smarty->assign('mediaArray', $mediaArray); } /* * Get paging info and pass it to smarty */ //$mediaPages->setTotalResults($returnRows); // Pass the total number of results to the $pages object $mediaPagingArray = $mediaPages->getPagingArray(); $mediaPagingArray['pageNumbers'] = range(0, $mediaPagingArray['totalPages']);
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>"; } }
// 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); if ($_SESSION['loggedIn']) { $user = $_SESSION['member']['f_name'] . ' ' . $_SESSION['member']['l_name'];
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); // Assign to smarty $smarty->assign('popularMedia', $popularMediaArray); // Assign to smarty }