</div>
<?php
echo $line_break;
}
//End foreach loop
?>
<br class="clear"/><br/>
<?php
if (empty($term)) {
$base_link = get_permalink($post->ID);
} else {
$base_link = curPageURL();
}
echo gen_pagination($total, $current_page, $base_link, TRUE, $portfolio_items);
}
//End if have portfolio items
?>
</div>
<!-- End main content -->
<br class="clear"/><br/>
</div>
<?php
if (!isset($hide_header) or !$hide_header) {
?>
return '<span style="padding:1px; background-color:' . $bgcolor2 . '; border-bottom:solid 1px ' . $bgcolor4 . ';">' . $content . '</span>';
}
}
$pagetitle .= $module_title . ' ' . _BC_DELIM . ' Search';
require_once 'header.php';
OpenTable();
echo dl_menu() . '<br /><hr />';
$search = new DL_Search();
if (isset($_POST['search']) || isset($_GET['sa']) || isset($_GET['key']) || isset($_GET['search_id'])) {
$cur_page = isset($_GET['page']) && $_GET['page'] > 0 ? intval($_GET['page']) : 1;
$perpage = $dl_config['perpage'];
$limit = ($cur_page - 1) * $perpage;
$search->search(isset($_GET['search_id']) ? $_GET['search_id'] : '');
if (count($search->criteria) > 0) {
echo '<div style="background-color:' . $bgcolor2 . '; padding:3px;"><span class="genmed">Advanced search results</span></div>
<div style="background-color:' . $bgcolor3 . '; border-bottom:1px solid ' . $bgcolor2 . '; padding:3px;"><span style="float:left;" class="genmed">Searching for downloads that match the following criteria:</span><span class="genmed" style="float:right;"><a href="' . URL::index('&file=search&edit=' . $search->search_id) . '">Edit search criteria</a></span><br />';
foreach ($search->criteria as $key => $value) {
echo $search->criterion_label($key, htmlprepare($value));
}
echo '<br /><br style="clear:both; line-height:0;" /></div>';
}
if (!$search->error && $search->result_count == 0) {
echo $search->show_error('No matching downloads found');
}
$cpgtpl->assign_vars(array('NO_DOWNLOADS' => false, 'DL_REVIEW_ACTIVE' => $dl_config['r_active'], 'DL_PAGINATION' => gen_pagination($search->total_results, $perpage, $cur_page, '&file=search&search_id=' . $search->search_id), 'U_TO_TOP' => htmlprepare(URL::uri()), 'L_TO_TOP' => strtolower(_DLP_BACK2TOP), 'L_PAGE' => _DLP_PAGE, 'L_RATING' => _RATING, 'L_POPULARITY' => _POPULARITY, 'L_HOMEPAGE' => 'Homepage', 'L_SUBMITTEDBY' => _DLP_SUBMITTEDBY, 'L_WRITE_REVIEW' => _DLP_WRITEREVIEW));
$cpgtpl->set_filenames(array('body' => 'downloads/list_downloads.html'));
$cpgtpl->display('body');
} else {
echo $search->search_form(isset($_GET['edit']) ? intval($_GET['edit']) : false);
}
CloseTable();
$rating_info = get_rating($review_score, $review_votes);
$cpgtpl->assign_block_vars('dl_review', array('ID' => $review_id, 'U_ID' => htmlprepare(URL::uri()) . '#r' . $review_id, 'RATING' => _DLP_REVIEW . ' #' . $review_id . ': ' . $rating_info['desc'], 'U_MEMBER' => URL::index('Your_Account&profile=' . $review_uid), 'MEMBERNAME' => $review_uname, 'DATE' => generate_date($review_timestamp), 'U_EDIT' => can_admin($module_name) ? '<a href="' . URL::index('&del_review=' . $review_id) . '">[' . strtolower(_DELETE) . ']</a>' : false, 'TITLE' => $review_title, 'COMMENT' => decode_bb_all($review_comment), 'IP' => decode_ip($review_ip), 'IMG_RATE' => dl_image('stars/' . $rating_info['rating'] . '.png'), 'SPACER' => $i > 0));
$i++;
}
} else {
$cpgtpl->assign_var('DL_REVIEWS', false);
}
$db->sql_freeresult($result);
if (can_admin($module_name) || $row['submitter'] == $userinfo['user_id']) {
// pagination
$cur_page2 = isset($_GET['p_page']) && $_GET['p_page'] > 0 ? intval($_GET['p_page']) : 1;
$limit2 = ($cur_page2 - 1) * $perpage;
$result = $db->sql_query("SELECT r.id, r.uid, r.ip, r.title, r.comment, r.score, r.timestamp, u.username, COUNT(r.score) AS votes FROM " . $dl_prefix . "_ratings r\n\tLEFT JOIN " . $user_prefix . "_users u ON (u.user_id = r.uid)\n\tWHERE r.lid='{$global_id}' AND r.comment!='' AND active=0 \n\tGROUP BY r.id DESC, r.uid, r.ip, r.title, r.comment, r.score, r.timestamp, u.username \n\tLIMIT {$perpage} OFFSET {$limit2}");
list($pending) = $db->sql_ufetchrow("SELECT COUNT(*) FROM " . $dl_prefix . "_ratings \n\tWHERE lid='{$global_id}' AND active=0");
if ($db->sql_numrows($result)) {
$cpgtpl->assign_vars(array('DL_P_REVIEW_PAGES' => ceil($pending / $perpage) > 1 ? gen_pagination($pending, $perpage, $cur_page2, '&file=details&id=' . $global_id, 'p_reviews', 'p_page') : false, 'DL_P_REVIEWS' => $pending));
$i = 0;
while (list($review_id, $review_uid, $review_ip, $review_title, $review_comment, $review_score, $review_timestamp, $review_uname, $review_votes) = $db->sql_fetchrow($result)) {
$rating_info = get_rating($review_score, $review_votes);
$cpgtpl->assign_block_vars('dl_p_review', array('ID' => $review_id, 'U_ID' => htmlprepare(URL::uri()) . '#r' . $review_id, 'RATING' => _DLP_REVIEW . ' #' . $review_id . ': ' . $rating_info['desc'], 'U_MEMBER' => URL::index('Your_Account&profile=' . $review_uid), 'MEMBERNAME' => $review_uname, 'DATE' => generate_date($review_timestamp), 'U_DEL' => can_admin($module_name) || $row['submitter'] == $userinfo['user_id'] ? '<a href="' . URL::index('&del_review=' . $review_id) . '">[' . strtolower(_DELETE) . ']</a>' : false, 'U_APPR' => can_admin($module_name) || $row['submitter'] == $userinfo['user_id'] ? '<a href="' . URL::index('&approve_review=' . $review_id) . '">[' . strtolower(_DLP_APPROVE) . ']</a>' : false, 'TITLE' => $review_title, 'COMMENT' => decode_bb_all($review_comment), 'IP' => decode_ip($review_ip), 'IMG_RATE' => dl_image('stars/' . $rating_info['rating'] . '.png'), 'SPACER' => $i > 0));
$i++;
}
} else {
$cpgtpl->assign_var('DL_P_REVIEWS', false);
}
$db->sql_freeresult($result);
} else {
$cpgtpl->assign_var('DL_P_REVIEWS', false);
}
}
if ($row['pick']) {
'>Runtime</a></li>
</ul>
</div>
<?php
foreach ($movies as $movie) {
$params = $movie['params'];
$cast = $movie['actors'];
include 'templates/gen_entry.php';
}
//////////////////// PAGINATION //////////////////////
if ($movieCount > $numPerPage) {
$num_pages = ceil($movieCount / $numPerPage);
$current = $page;
$url = "genre/{$urlFriendlyGenre}" . ($_GET['o'] ? "/" . $_GET['o'] : "") . "/p";
gen_pagination($current, $numPerPage, $num_pages, $url);
}
//////////////////// PAGINATION //////////////////////
} else {
echo 'We have no movies for <span class="genre-tag">' . $genre . '</span>.<br><br>';
}
// close the connection
$mysqli->close();
?>
</div> <!-- #container -->
<?php
gen_page_footer();
?>
$bgcolor = $bgcolor == $bgcolor2 ? $bgcolor3 : $bgcolor2;
if (ereg('://', $row['mirror_url'])) {
$url = parse_url($row['mirror_url']);
$site = shrink_url($url['host']);
} else {
$site = $MAIN_CFG['server']['domain'];
}
$cpgtpl->assign_block_vars('dl_item', array('BGCOLOR' => $bgcolor, 'DATE' => generate_date($row['date']), 'TITLE' => $row['title'], 'URL' => URL::index('&file=details&id=' . $row['id']), 'MIRROR' => $row['mirror_url'], 'MIRROR_SITE' => $site, 'REPORT' => $row['report'], 'U_USER' => URL::index('Your_Account&profile=' . $row['uid']), 'USERNAME' => $row['username'], 'U_DISMISS' => URL::index('&file=manage&s=2&dismiss=' . $row['id']), 'U_EDIT' => URL::index('&file=manage&edit=' . $row['lid'])));
}
}
$db->sql_freeresult($result);
$cpgtpl->set_filenames(array('body' => 'downloads/my_broken.html'));
} else {
$pagetitle .= ' ' . _BC_DELIM . ' Current';
$total_author = $db->sql_count($dl_prefix . '_downloads', "submitter='{$userinfo['user_id']}' AND active!=2");
$cpgtpl->assign_vars(array('L_CATEGORY' => _CATEGORY, 'L_EDIT' => _EDIT, 'DL_MENU' => '<span class="gen"><strong>My Downloads</strong></span><br /><a href="' . URL::index() . '">Main Page</a> | <strong>Current Downloads</strong> | <a href="' . URL::index('&file=manage&s=1') . '">Pending Downloads</a> | <a href="' . URL::index('&file=manage&s=2') . '">Broken D/L Reports</a>', 'DL_NO_ITEMS' => $total_author < 1 ? sprintf(_ERROR_NONE_TO_DISPLAY, strtolower(_DOWNLOADS)) : false, 'DL_PAGINATION' => ceil($total_author / $perpage) > 1 ? gen_pagination($total_author, $perpage, $cur_page, '&file=manage') : false));
if ($total_author) {
$rating = $db->sql_query("SELECT lid, SUM(score)/COUNT(lid) AS score FROM " . $dl_prefix . "_ratings \n\t\t\tGROUP BY lid");
while ($rows = $db->sql_fetchrow($rating)) {
$ratings[$rows[0]]['score'] = $rows[1];
}
$result = $db->sql_query("SELECT d.lid, d.cid, d.title, d.active, d.desc_short, SUM(s.hits) as hits, SUM(s.views) as views FROM " . $dl_prefix . "_downloads d\n\t\t\t\tLEFT JOIN " . $dl_prefix . "_stats s ON (s.id = d.lid)\n\t\t\t\tWHERE d.submitter='{$userinfo['user_id']}' AND d.active!=2 \n\t\t\t\tGROUP BY d.lid, d.cid, d.title, d.active, d.desc_short \n\t\t\t\tLIMIT {$perpage} OFFSET {$limit}");
while ($row = $db->sql_fetchrow($result)) {
$rating_info = isset($ratings[$row['lid']]['score']) ? get_rating($ratings[$row['lid']]['score'], 1) : get_rating(0, 0);
$cpgtpl->assign_block_vars('dl_item', array('TITLE' => $row['title'], 'U_DETAILS' => URL::index('&file=details&id=' . $row['lid']), 'U_EDIT' => URL::index('&file=manage&edit=' . $row['lid']), 'CATEGORY' => DL_Cat::breadcrumb($row['cid']), 'ACTIVE' => $row['active'] == 1 ? _ACTIVE : _INACTIVE, 'IMG_ACTIVE' => dl_image($row['active'] == 1 ? 'checked.png' : 'unchecked.png'), 'IMG_RATE' => $rating_info['image'], 'IMG_POP' => popularity($row['lid']), 'VIEWS' => $row['views'], 'HITS' => $row['hits']));
}
$db->sql_freeresult($result);
}
$cpgtpl->set_filenames(array('body' => 'downloads/my_downloads.html'));
}
require_once 'header.php';
