$month = zerofill($month);
$fromMonth[$month] = $month;
$toMonth[$month] = $month;
}
foreach (range(1, 31) as $day) {
$day = zerofill($day);
$fromDay[$day] = $day;
$toDay[$day] = $day;
}
if ($_SESSION['searchForm']['searchDate']['dateRangeSearch']) {
$searchDateObj = new kdate();
// Setup a new kdate object to use specifically on media details
$searchDateObj->setMemberSpecificDateInfo();
$searchDateObj->distime = 0;
$searchDateObj->adjust_date = 0;
$fromDateText = $searchDateObj->showdate("{$_SESSION[searchForm][searchDate][fromYear]}-{$_SESSION[searchForm][searchDate][fromMonth]}-{$_SESSION[searchForm][searchDate][fromDay]} 00:00:00");
$toDateText = $searchDateObj->showdate("{$_SESSION[searchForm][searchDate][toYear]}-{$_SESSION[searchForm][searchDate][toMonth]}-{$_SESSION[searchForm][searchDate][toDay]} 00:00:00");
$smarty->assign('fromDateText', $fromDateText);
$smarty->assign('toDateText', $toDateText);
}
// Default is sortnumber, id desc
if ($_SESSION['searchForm']['hex']) {
$searchSortByOptions['color'] = 'Color';
}
// [t]
$searchSortByOptions['date_added'] = 'Date Added';
$searchSortByOptions['media_id'] = 'ID';
$searchSortByOptions['title'] = 'Title';
$searchSortByOptions['filesize'] = 'Filesize';
$searchSortByOptions['width'] = 'Width';
$searchSortByOptions['height'] = 'Height';
//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';
try {
$customNewsDate = new kdate();
$customNewsDate->setMemberSpecificDateInfo();
$customNewsDate->distime = 0;
if ($id) {
/*
* Grab selected news article
*/
$news['article'] = $news['article_' . $selectedLanguage] ? $news['article_' . $selectedLanguage] : $news['article'];
// Choose the correct language
$news['display_date'] = $customNewsDate->showdate($news['add_date']);
// Create a local time and date
$smarty->assign('newsArticle', $news);
if ($news and $news['active'] == 1 and $news['add_date'] < $nowGMT and ($news['expire_type'] == 0 or $news['expire_date'] > $nowGMT)) {
$smarty->display('news.article.tpl');
} else {
$smarty->display('noaccess.tpl');
}
// Smarty template
} else {
/*
* Grab a list of active news articles
*/
$newsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM {$dbinfo[pre]}news\r\n\t\t\t\tWHERE active = 1\r\n\t\t\t\tAND add_date < '{$nowGMT}'\r\n\t\t\t\tAND (expire_type = 0 OR expire_date > '{$nowGMT}') \r\n\t\t\t\tORDER BY sortorder,add_date DESC\r\n\t\t\t\t");
if ($returnRows = mysqli_num_rows($newsResult)) {
while ($news = mysqli_fetch_assoc($newsResult)) {
if ($id) {
if ($publicAccess) {
if ($contributor['avatar_status'] == 1) {
// Avatar Status
$contributor['avatar'] = true;
} else {
$contributor['avatar'] = false;
}
$customContributorDate = new kdate();
$customContributorDate->setMemberSpecificDateInfo();
$customContributorDate->distime = 0;
//if(!$contributor['display_name']) // Set display name if none exists
// $contributor['display_name'] = $contributor['f_name'].' '.$contributor['l_name'];
$contributor['useMemID'] = $useMemID;
// Get the original member id
$contributor['memberSince'] = $customContributorDate->showdate($contributor['signup_date']);
$contributor['country'] = getCountryName($contributor['country']);
$contributor['state'] = getStateName($contributor['state']);
// Redo this so only galleries that a member should be able to see are displayed XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
// Contributor Albums
if ($_SESSION['galleriesData']) {
foreach ($_SESSION['galleriesData'] as $key => $value) {
if ($value['owner'] == $id and $value['publicgal'] == 1) {
$countMediaAlbums[] = $key;
// Galleries to count media for
$contrAlbums[$key] = $value;
}
}
}
if (count($countMediaAlbums) > 0) {
@($flatMediaAlbums = implode(',', $countMediaAlbums));
while ($featuredNews = mysqli_fetch_assoc($featuredNewsResult)) {
$featuredNews['title'] = $featuredNews['title_' . $selectedLanguage] ? $featuredNews['title_' . $selectedLanguage] : $featuredNews['title'];
// Choose the correct language
$featuredNews['short'] = $featuredNews['short_' . $selectedLanguage] ? $featuredNews['short_' . $selectedLanguage] : $featuredNews['short'];
// Choose the correct language
$featuredNews['seoTitle'] = cleanForSEO($featuredNews['title']);
// Name cleaned for SEO usage
$parms['page'] = "news.php?id={$featuredNews[news_id]}";
// Link to page
if ($modRewrite) {
$parms['page'] .= "&seoTitle={$featuredNews[seoTitle]}";
}
// Link to page with seoName added
$featuredNews['linkto'] = linkto($parms);
// Create the link using SEO if needed
$featuredNews['display_date'] = $customNewsDate->showdate($featuredNews['add_date']);
// Create a local time and date
$featuredNewsArray[] = $featuredNews;
}
$smarty->assign('featuredNewsRows', count($featuredNewsArray));
$smarty->assign('featuredNews', $featuredNewsArray);
} catch (Exception $e) {
die(exceptionError($e));
}
}
/*
* Get featured homepage prints
*/
if ($config['settings']['hpprints']) {
try {
$featuredPrintsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT *\r\n\t\t\t\tFROM {$dbinfo[pre]}prints\r\n\t\t\t\tLEFT JOIN {$dbinfo[pre]}perms\r\n\t\t\t\tON ({$dbinfo[pre]}prints.print_id = {$dbinfo[pre]}perms.item_id AND {$dbinfo[pre]}perms.perm_area = 'prints') \r\n\t\t\t\tWHERE {$dbinfo[pre]}prints.active = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}prints.homepage = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}prints.deleted = 0\r\n\t\t\t\tAND ({$dbinfo[pre]}prints.everyone = 1 OR {$dbinfo[pre]}perms.perm_value IN ({$memberPermissionsForDB}))\r\n\t\t\t\tORDER BY {$dbinfo[pre]}prints.sortorder\r\n\t\t\t\t");
