//print_r($_SESSION['lightboxItems']); try { $umemberID = $_SESSION['member']['umem_id']; if (!$umemberID) { die('No unique member ID exists'); } // Just to be safe make sure a memberID exists before continuing //echo "cookie: " . $_COOKIE['member']['umem_id']; //echo $_SESSION['member']['umem_id']; $guestLightbox = $_SESSION['loggedIn'] ? 0 : 1; // Determine the guest lightbox status //echo $guestLightbox; $lightboxResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}lightboxes\r\n\t\t\tWHERE umember_id = '{$umemberID}'\r\n\t\t\tAND deleted = 0 \r\n\t\t\tAND guest = '{$guestLightbox}' \r\n\t\t\tORDER BY created DESC\r\n\t\t\t"); if ($returnRows = mysqli_num_rows($lightboxResult)) { while ($lightbox = mysqli_fetch_array($lightboxResult)) { $itemCount = mysqli_result_patch(mysqli_query($db, "SELECT COUNT(item_id) FROM {$dbinfo[pre]}lightbox_items WHERE lb_id = '{$lightbox[lightbox_id]}'")); $lightboxArray[$lightbox['lightbox_id']] = $lightbox; $lightboxArray[$lightbox['lightbox_id']]['items'] = $itemCount; $lightboxArray[$lightbox['lightbox_id']]['create_date_display'] = $customDate->showdate($lightbox['created'], 0); if ($config['EncryptIDs']) { // Encrypt IDs $lightboxArray[$lightbox['lightbox_id']]['linkto'] = "gallery.php?mode=lightbox&id=" . k_encrypt($lightbox['ulightbox_id']) . "&page=1"; } else { $lightboxArray[$lightbox['lightbox_id']]['linkto'] = "gallery.php?mode=lightbox&id=" . $lightbox['ulightbox_id'] . "&page=1"; } } /* Testing foreach($lightboxArray as $lb) { print_r($lb); echo "<br><br>";
foreach ($blockedEmails as $check) { if ($check) { if (strpos($email, $check) !== false) { $emailBlocked = 1; } } } } if ($emailBlocked) { $formNotice[] = 'emailBlocked'; } else { if ($config['settings']['captcha']) { $resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); } // Check captcha $emailRows = mysqli_result_patch(mysqli_query($db, "SELECT COUNT(mem_id) FROM {$dbinfo[pre]}members WHERE email='{$email}'")); // Check if email already exists if (!$emailRows) { if ($config['settings']['captcha']) { if (!$resp->is_valid) { $formNotice[] = "captchaError"; } // Incorrect Captcha } //$_SESSION['testing']['step1'] = '1'; if (!$f_name) { $formNotice[] = "noFirstName"; } if (!$l_name) { $formNotice[] = "noLastName"; }
$currentAblum['name'] = $lang['approvalStatus2']; $sql = "\r\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\t\tWHERE owner = {$memID} \r\n\t\t\t\t\tAND active = 1 \r\n\t\t\t\t\tAND approval_status = 2 \r\n\t\t\t\t\tGROUP BY media_id\r\n\t\t\t\t\tORDER BY media_id DESC\r\n\t\t\t\t"; $crumbs[1]['linkto'] = $siteURL . "/contributor.my.media.php?mode=failed"; // Check for SEO $crumbs[1]['name'] = $lang['approvalStatus2']; break; case "orphaned": $currentAblum['name'] = $lang['orphanedMedia']; $sql = "\r\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS * \r\n\t\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\t\tWHERE {$dbinfo[pre]}media.owner = '{$memID}' \r\n\t\t\t\t\tAND {$dbinfo[pre]}media.media_id NOT IN (SELECT {$dbinfo[pre]}media_galleries.gmedia_id FROM {$dbinfo[pre]}media_galleries)\r\n\t\t\t\t"; $crumbs[1]['linkto'] = $siteURL . "/contributor.my.media.php?mode=orphaned"; // Check for SEO $crumbs[1]['name'] = $lang['orphanedMedia']; break; case "last": $currentAblum['name'] = $lang['lastBatch']; @($lastBatch = mysqli_result_patch(mysqli_query($db, "SELECT batch_id FROM {$dbinfo[pre]}media WHERE owner = '{$memID}' ORDER BY batch_id DESC"))); if (!$lastBatch) { $lastBatch = '0'; } // Just in case there is no last batch yet $sql = "\r\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\t\t\tFROM {$dbinfo[pre]}media \r\n\t\t\t\t\tWHERE owner = {$memID} \r\n\t\t\t\t\tAND active = 1 \r\n\t\t\t\t\tAND batch_id = '{$lastBatch}' \r\n\t\t\t\t\tGROUP BY media_id\r\n\t\t\t\t\tORDER BY media_id DESC\r\n\t\t\t\t"; $crumbs[1]['linkto'] = $siteURL . "/contributor.my.media.php?mode=last"; // Check for SEO $crumbs[1]['name'] = $lang['lastBatch']; break; case "album": $currentAlbumID = getAlbumID($_SESSION['contrAlbumID']); $currentAblum['name'] = $_SESSION['member']['contrAlbumsData'][$currentAlbumID]['name']; $currentGallery = $_SESSION['galleriesData'][$currentAlbumID]; // Assign the current gallery details if (!$_SESSION['sessGallerySortBy']) {
define('META_KEYWORDS', ''); define('PAGE_ENCODING', ''); require_once BASE_PATH . '/assets/includes/header.inc.php'; require_once BASE_PATH . '/assets/includes/errors.php'; $memberID = $_SESSION['member']['mem_id']; if (!$memberID) { die('No member ID exists'); } // Just to be safe make sure a memberID exists before continuing if ($ticketSystem) { $tickets = mysqli_result_patch(mysqli_query($db, "\r\n\t\t\tSELECT COUNT(ticket_id) \r\n\t\t\tFROM {$dbinfo[pre]}tickets \r\n\t\t\tWHERE member_id = {$memberID}\r\n\t\t\tAND viewed = 0 \r\n\t\t\t")); // Count new messages } $bills = mysqli_result_patch(mysqli_query($db, "\r\n\t\tSELECT COUNT({$dbinfo[pre]}billings.bill_id) \r\n\t\tFROM {$dbinfo[pre]}billings \r\n\t\tLEFT JOIN {$dbinfo[pre]}invoices \r\n\t\tON {$dbinfo[pre]}billings.bill_id = {$dbinfo[pre]}invoices.bill_id \r\n\t\tWHERE {$dbinfo[pre]}invoices.payment_status = 2 \r\n\t\tAND {$dbinfo[pre]}billings.deleted = 0\r\n\t\tAND member_id = {$memberID}\r\n\t\t")); // Count bills due $sales = mysqli_result_patch(mysqli_query($db, "\r\n\t\tSELECT COUNT(com_id) \r\n\t\tFROM {$dbinfo[pre]}commission \r\n\t\tWHERE contr_id = {$memberID} \r\n\t\tAND order_status = '1' \r\n\t\tAND order_date > '{$_SESSION[member][last_login]}'\r\n\t\t")); // Count new sales // Get membership that member is currently on // Get membership that member is assigned to in DB $membership['expires'] = ''; /* * Get membership details */ if ($_SESSION['member']['membership'] != 1) { //echo $_SESSION['member']['membershipDetails']['ms_id']; exit; $membershipResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}memberships\r\n\t\t\tWHERE ms_id = '{$_SESSION[member][membership]}'\r\n\t\t\t"); $membershipDB = mysqli_fetch_array($membershipResult); $membership = membershipsList($membershipDB); $membership['msExpired'] = ($_SESSION['member']['ms_end_date'] > $nowGMT or $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00') ? false : true; $membership['msExpireDate'] = $_SESSION['member']['ms_end_date'] == '0000-00-00 00:00:00' ? $lang['never'] : $customDate->showdate($_SESSION['member']['ms_end_date'], 1); $smarty->assign('membership', $membership);
$memsubArray[$memsub['msub_id']]['expired'] = true; // See if the subscription is expired $memsubArray[$memsub['msub_id']]['status_lang'] = 'expired'; } else { $memsubArray[$memsub['msub_id']]['status_lang'] = 'active'; } if ($memsub['perday']) { $memsubArray[$memsub['msub_id']]['downloads_per_day'] = $memsub['perday']; } else { $memsubArray[$memsub['msub_id']]['downloads_per_day'] = 0; } // Unlimited //$today = explode(" ",$nowGMT); $dateMinus24Hours = date("Y-m-d H:i:s", strtotime("{$nowGMT} -24 hours")); $todayDownloads = mysqli_result_patch(mysqli_query($db, "SELECT COUNT(*) FROM {$dbinfo[pre]}downloads WHERE dl_type = 'sub' AND dl_type_id = '{$memsub[msub_id]}' AND mem_id = '{$memberID}' AND dl_date > '{$dateMinus24Hours}'")); $totalDownloads = mysqli_result_patch(mysqli_query($db, "SELECT COUNT(*) FROM {$dbinfo[pre]}downloads WHERE dl_type = 'sub' AND dl_type_id = '{$memsub[msub_id]}' AND mem_id = '{$memberID}'")); //echo $downloads; exit; @($totalRemaining = $memsub['total_downloads'] - $totalDownloads); @($todayRemaining = $memsub['perday'] - $todayDownloads); $memsubArray[$memsub['msub_id']]['totalDownloads'] = $totalDownloads; $memsubArray[$memsub['msub_id']]['todayDownloads'] = $todayDownloads; $memsubArray[$memsub['msub_id']]['todayRemaining'] = $todayRemaining; $memsubArray[$memsub['msub_id']]['totalRemaining'] = $totalRemaining; } $smarty->assign('memsubArray', $memsubArray); $smarty->assign('memsubRows', $returnRows); } $smarty->display('member.subs.tpl'); } catch (Exception $e) { echo $e->getMessage(); }