//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();
}