cpg_error(_DLP_UNKNOWNDL, 404);
}
if ($row['active'] != 1 && !can_admin($module_name)) {
cpg_error(_DLP_INACTIVEDL);
}
$rating_info = get_rating($row['score'], $row['votes']);
if (!is_admin() && $row['submitter'] != is_user()) {
update_views($global_id);
}
//$modheader .= '<link rel="stylesheet" type="text/css" href="modules/'.$module_name.'/include/style.css" />';
$pagetitle .= $module_title . ' ' . _BC_DELIM . ' ' . $row['title'];
if ($row['img_url']) {
if (ereg('://', $row['img_url'])) {
$row['img_url'] .= '" width="' . $dl_config['dimension_thumb'];
} else {
$row['img_url'] = dl_thumbimage($row['img_url']);
}
}
$can_dl = can_download($row['active'], $row['access']);
//$submitter_count = $db->sql_count($dl_prefix.'_downloads', "submitter='".Fix_Quotes($row['submitter'])."'")-1;
$cpgtpl->assign_vars(array('L_SUBMITTEDBY' => _DLP_SUBMITTEDBY, 'L_AUTHORNAME' => _AUTHORNAME, 'L_AUTHOREMAIL' => _AUTHOREMAIL, 'L_PUBLISHED' => _DLP_PUBLISHED, 'L_UPDATED' => _DLP_UPDATED, 'L_DESCRIPTION' => _DESCRIPTION, 'L_CATEGORY' => _CATEGORY, 'L_RATING' => _RATING, 'L_VOTES' => _VOTES, 'L_DOWNLOADS' => _DOWNLOADS, 'L_ACTIVE' => _ACTIVE, 'L_EDIT' => _EDIT, 'L_DELETE' => _DELETE, 'L_ISDLOWNER' => sprintf(_DLP_ISDLOWNER, URL::index('&file=manage&edit=' . $global_id)), 'L_MIRSUB' => sprintf(_DLP_MIRSUB, URL::index('&file=manage&mirrors=' . $global_id)), 'L_EDNOTE' => _DLP_EDNOTE, 'L_MEMREVIEWS' => _DLP_MEMREVIEWS, 'L_PENDREVIEWS' => _DLP_PENDREVIEWS, 'L_BY' => _BY, 'L_ON' => _ON, 'L_PAGE' => _DLP_PAGE, 'L_VIEWALLSCREENS' => _DLP_VIEWALLSCREENS, 'L_POPULARITY' => _POPULARITY, 'L_PAGEVIEWS' => _DLP_PAGEVIEWS, 'L_ADMINTOOLS' => _ADMINISTRATION, 'L_EDPICK' => _DLP_EDPICK, 'DL_MENU' => dl_detail_menu($global_id, $row['title'], $row['pick'], $row['active'], 1), 'DL_CATEGORY' => DL_Cat::breadcrumb($row['cid']), 'DL_SUBMITTER' => is_numeric($row['submitter']) ? '<a href="' . URL::index('&file=search&sa=' . $row['submitter']) . '">' . $row['username'] . '</a>' : $row['submitter'], 'DL_AUTHORNAME' => $row['name'], 'DL_AUTHOREMAIL' => $row['email'] ? spam_protect($row['email']) : false, 'DL_PUBLISHED' => generate_date($row['date']), 'DL_PUBLISHTYPE' => mark_date($row['date'], 3, 1, 'right'), 'DL_UPDATED' => $row['updated'] > $row['date'] ? generate_date($row['updated']) : false, 'DL_UPDATE_TYPE' => $row['updated'] > $row['date'] ? mark_date($row['updated'], 3, 2, 'right') : false, 'DL_DESCRIPTION' => nl2br($row['desc_short']) . (!empty($row['desc_long']) ? decode_bbcode("\n\n" . $row['desc_long'], true) : ''), 'DL_NOTES' => decode_bbcode($row['notes']), 'DL_REVIEWS_ACTIVE' => $dl_config['r_active'], 'IMG_DL_RATING' => $rating_info['image'], 'DL_VOTES' => intval($row['votes']), 'DL_POPULARITY' => popularity($global_id), 'DL_HITS' => intval($row['hits']), 'DL_VIEWS' => intval($row['views']), 'DL_SUB_MIRRORS' => $dl_config['pub_mirror'], 'U_DL_SCREENSHOT' => URL::index('&screen=' . $row['screen']), 'IMG_DL_SCREENSHOT' => $row['img_url'], 'B_DL_ADMIN' => can_admin($module_name), 'DL_IS_OWNER' => $row['submitter'] == $userinfo['user_id'], 'U_DL_DELETE' => URL::admin('&del_dl=' . $global_id), 'U_DL_EDIT' => URL::index('&file=manage&edit=' . $global_id), 'U_DL_MIRSUB' => URL::index('&file=manage&mirrors=' . $global_id), 'U_DL_MIRROR' => URL::index('&mirror=' . $global_id), 'U_DL_MIRRORS' => URL::index('&get=' . $global_id), 'U_DL_ACTIVE' => URL::admin('&active=' . $global_id), 'U_DL_PICK' => URL::admin('&pick=' . $global_id), 'IMG_DL_MIRRORS' => dl_image($can_dl ? 'download.png' : 'register.png'), 'IMG_DL_ACTIVE' => dl_image($row['active'] == 1 ? 'checked.png' : 'unchecked.png'), 'IMG_DL_PICK' => dl_image($row['pick'] ? 'checked.png' : 'unchecked.png'), 'S_DL_ACTIVE' => $row['active'] == 1 ? _YES : _NO, 'S_DL_PICK' => $row['pick'] ? _YES : _NO, 'S_DL_MIRRORS' => $can_dl ? _DLP_DLNOW : _DLP_NADL));
$result = $db->sql_query("SELECT field, title, type FROM " . $dl_prefix . "_fields \n\tWHERE type!=3 AND visible > 0");
if ($db->sql_numrows($result)) {
while ($row2 = $db->sql_fetchrow($result)) {
if ($row2['type'] == 1) {
$row[$row2['field']] = $row[$row2['field']] ? _YES : _NO;
}
if ($row[$row2['field']]) {
$row2['title'] = defined($row2['title']) ? constant($row2['title']) : $row2['title'];
if ($row2['field'] == 'homepage' && $row[$row2['field']]) {
$row[$row2['field']] = '<a href="' . $row[$row2['field']] . '" target="_blank">' . shrink_url($row[$row2['field']]) . '</a>';
function add_result($row)
{
global $db, $dl_prefix, $cpgtpl, $module_name;
$this->result[$this->result_count++] = $row;
$rating_info = get_rating($row['score'], $row['votes']);
if ($row['date'] >= $row['updated']) {
$row['date'] = _DLP_PUBLISHED . ': ' . generate_date($row['date']) . mark_date($row['date'], 3, 1, '', 2);
} else {
$row['date'] = _DLP_UPDATED . ': ' . generate_date($row['updated']) . mark_date($row['updated'], 3, 2, '', 2);
}
if (can_download($row['active'], $row['access'])) {
$img = dl_image($row['access'] > 0 ? 'download_small_yes.png' : 'download_small.png');
$img_title = _DLP_DLNOW;
} else {
$img = dl_image('download_small_no.png');
$img_title = _DLP_DLFORBIDDEN;
}
if ($row['img_url']) {
if (ereg('://', $row['img_url'])) {
$row['img_url'] .= '" width="100';
} else {
$row['img_url'] = dl_thumbimage($row['img_url']) . '" width="100';
}
}
$cpgtpl->assign_block_vars('dl_item', array('TITLE' => $row['title'], 'U_INFO' => URL::index('&file=details&id=' . $row['lid']), 'U_GET' => URL::index('&get=' . $row['lid']), 'U_IMG' => $row['screen'] ? URL::index('&screen=' . $row['screen']) : '', 'U_HOME' => $row['homepage'], 'U_WRITE' => URL::index('&review=' . $row['lid']), 'U_REVIEWS' => URL::index('&file=details&id=' . $row['lid'] . '#reviews'), 'NO_REVIEWS' => $row['votes'] == 0 && is_user(), 'REVIEWS' => sprintf($row['votes'] == 1 ? '%s review' : '%s reviews', $row['votes']), 'VERSION' => !empty($row['version']) ? _VERSION . ' ' . $row['version'] : '', 'NOT_ACTIVE' => $row['active'] == 0 && can_admin($module_name) ? _DLP_INACTIVE : '', 'E_PICK' => $row['pick'] ? _DLP_EDPICK : '', 'SECURE' => isset($row['cpgcs']) && $row['cpgcs'] ? 'Certified Secure' : '', 'SUBMITTER' => is_numeric($row['submitter']) ? '<a href="' . URL::index('&file=search&sa=' . $row['submitter']) . '">' . $row['username'] . '</a>' : $row['submitter'], 'DL_IMG' => $img, 'DL_IMG_TITLE' => $img_title, 'RATING_IMG' => $rating_info['image'], 'POP_IMG' => popularity($row['lid']), 'DATE' => $row['date'], 'DESC' => nl2br($row['desc_short']), 'U_SCREEN' => URL::index('&screen=' . $row['screen']), 'IMG_SCREEN' => $row['img_url'], 'IMG_MISSING' => dl_image('missing.png'), 'L_VIEWALLSCREENS' => _DLP_VIEWALLSCREENS, 'L_NOSCREENS' => _DLP_NOSCREENSHOTS, 'L_SUBMITTEDBY' => _DLP_SUBMITTEDBY));
}
$cpgtpl->assign_block_vars('mirror', array('FILENAME' => $filename, 'S_MD5' => $mirror['uploaded'] && !$dl_config['md5_local'] || !$mirror['uploaded'] && !$dl_config['md5_remote'] ? 'N/A' : $mirror['md5'], 'S_SITE' => $site, 'S_SIZE' => notate_size($mirror['filesize']), 'U_GET' => URL::index("&get={$get_id}&mirror=" . $mirror['id']), 'U_BROKEN' => URL::index('&broken=' . $mirror['id']), 'U_POPUP' => URL::index('&time=' . $mirror['id'], false, true)));
}
}
require_once 'header.php';
$cpgtpl->set_filenames(array('body' => 'downloads/mirrors.html'));
}
$cpgtpl->display('body');
} else {
require_once 'header.php';
// Editors pick
$result = $db->sql_query("SELECT d.lid, d.cid, d.title, d.desc_short, d.screen, s.url as img_url FROM " . $dl_prefix . "_downloads d\n\t\tLEFT JOIN " . $dl_prefix . "_screenshots s ON (s.id = d.screen)\n\t\tWHERE d.pick=1 AND d.active=1 \n\t\tORDER BY RAND()");
$count = $db->sql_numrows($result);
$cpgtpl->assign_vars(array('B_EDITORSPICK' => $count));
if ($count) {
$picks = $db->sql_fetchrowset($result);
$cpgtpl->assign_vars(array('L_READ_MORE' => 'Details', 'U_MOREPICKS' => URL::index('&file=search&key=pick'), 'L_MOREPICKS' => 'View more featured', 'L_VIEW_SHOT' => 'View Screenshot', 'L_FEATURED' => 'Featured download', 'TITLE' => $picks[0]['title'], 'SRC_IMG' => dl_thumbimage($picks[0]['img_url']), 'URL_IMG' => URL::index('&screen=' . $picks[0]['screen']), 'DESC' => nl2br($picks[0]['desc_short']), 'DETAILS' => URL::index('&file=details&id=' . $picks[0]['lid'])));
unset($picks);
}
$db->sql_freeresult($result);
// Categories
DL_Cat::show();
// Latest downloads
$entries = array();
$result = $db->sql_uquery("SELECT lid, title, date FROM " . $dl_prefix . "_downloads \n\t\tWHERE active=1 AND updated<=date \n\t\tORDER BY date DESC \n\t\tLIMIT {$dl_config['front_rank']}");
while ($entry = $db->sql_fetchrow($result)) {
$entry['new'] = true;
$entries[$entry['date']] = $entry;
}
$result = $db->sql_uquery("SELECT lid, title, updated FROM " . $dl_prefix . "_downloads \n\t\tWHERE active=1 AND updated>date \n\t\tORDER BY updated DESC \n\t\tLIMIT {$dl_config['front_rank']}");
while ($entry = $db->sql_fetchrow($result)) {
$entry['new'] = false;
