}
$db->sql_query("DELETE FROM " . $dl_prefix . "_broken \n\t\t\t\tWHERE id='{$dismiss_id}'");
URL::redirect(URL::index('&file=manage&s=2'));
}
$pagetitle .= ' ' . _BC_DELIM . ' Broken Download Reports';
$sql = "SELECT b.id, b.uid, b.report, b.date, d.lid, d.title, m.id AS mirror_id, m.url AS mirror_url, u.username FROM " . $dl_prefix . "_broken b\n\t\t\tLEFT JOIN " . $dl_prefix . "_downloads d ON (d.lid = b.lid)\n\t\t\tLEFT JOIN " . $dl_prefix . "_mirrors m ON (m.id = b.mid)\n\t\t\tLEFT JOIN " . $user_prefix . "_users u ON (u.user_id = b.uid)\n\t\t\tWHERE d.submitter='{$userinfo['user_id']}' \n\t\t\tORDER BY b.id";
$result = $db->sql_query($sql);
$total_author = $db->sql_numrows($result);
$cpgtpl->assign_vars(array('DL_MENU' => '<span class="gen"><strong>My Downloads</strong></span><br /><a href="' . URL::index() . '">Main Page</a> | <a href="' . URL::index('&file=manage') . '">Current Downloads</a> | <a href="' . URL::index('&file=manage&s=1') . '">Pending Downloads</a> | <strong>Broken D/L Reports</strong>', 'DL_NO_ITEMS' => $total_author < 1 ? sprintf(_ERROR_NONE_TO_DISPLAY, 'reports') : false, 'TABLE_BGCOLOR' => $bgcolor2));
if ($total_author) {
$bgcolor = $bgcolor3;
while ($row = $db->sql_fetchrow($result)) {
$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)) {
$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>';
}
$cpgtpl->assign_block_vars('dl_field', array('TITLE' => $row2['title'], 'VALUE' => $row[$row2['field']]));
}
}
}
$db->sql_freeresult($result);
// End download info
// pagination
$cur_page = isset($_GET['page']) && $_GET['page'] > 0 ? intval($_GET['page']) : 1;
$perpage = $dl_config['r_perpage'];
$limit = ($cur_page - 1) * $perpage;
if (!$dl_config['r_active']) {
$cpgtpl->assign_vars(array('DL_REVIEWS' => false, 'DL_P_REVIEWS' => false));
} else {
$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=1 \n\tGROUP BY r.id DESC, r.uid, r.ip, r.title, r.comment, r.score, r.timestamp, u.username \n\tLIMIT {$perpage} OFFSET {$limit}");
if (NULL === $item['installed_v']) {
if (!isset($item['status_txt'])) {
$item['status_txt'] = 'Inactive or not installed';
$item['status_bg'] = '#DDDDDD';
}
} else {
switch (version_compare($item['installed_v'], $item['version'])) {
case -1:
$item['status_txt'] = _UPGRADE;
$item['status_bg'] = '#FFDDDD';
break;
case 0:
$item['status_txt'] = _UPTODATE;
$item['status_bg'] = '#DDFFDD';
break;
case 1:
$item['status_txt'] = 'CVS';
$item['status_bg'] = '#DDDDFF';
break;
}
}
$item['description'] = decode_bb_all($item['description'], 0, true);
$item['url_short'] = shrink_url($item['url']);
$cpgtpl->assign_block_vars('channel.item', array_change_key_case(array_key_prefix($item, 's_'), CASE_UPPER));
}
// foreach item
}
// foreach channel
unset($data, $dir, $item, $IOthemes, $IOmodules);
$cpgtpl->set_handle('body', 'admin/plugins.html');
$cpgtpl->display('body');
