} function criterion_label($title, $content) { global $bgcolor2, $bgcolor4, $textcolor2; return '<div style="float:left; padding:3px 5px; border:solid 1px ' . $bgcolor4 . '; background-color:' . $bgcolor2 . '; margin:2px 5px 4px 0;"><span style="color:' . $textcolor2 . '; font-weight:bold;">' . $title . ':</span> ' . $content . '</div>'; } function hl_label($content) { global $bgcolor2, $bgcolor4, $textcolor2; 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) {
<option selected="selected" label="none" value="none">select a category</option>'; foreach ($cats as $cat) { if ($cat['level'] == 1) { if ($selects != '') { $selects .= '</optgroup>'; } $selects .= '<optgroup label="' . $cat['crumb'] . '">'; } else { $selects .= '<option value="' . $cat['cid'] . '"' . (isset($_GET['c']) && $cat['cid'] == intval($_GET['c']) || $cat['cid'] == $in['cat'] ? ' selected="selected"' : '') . '>' . $cat['crumb'] . '</option>'; } } $selects .= '</optgroup></select>'; } require_once 'header.php'; $images = DL_Image::output_list($mng_id, $in['screen']); $cpgtpl->assign_vars(array('DL_MENU' => dl_menu(), 'DL_ERRORS' => !empty($errors), 'DL_WARNINGS' => !empty($warnings), 'DL_MIRRORS' => DL_Mirror::output_list($mng_id), 'DL_IMAGES' => $images, 'IS_NEW_DL' => !can_admin($module_name), 'CAN_ADMIN' => can_admin($module_name), 'B_SCREENSHOT' => $dl_config['screen_active'] || can_admin($module_name), 'B_ADD_IMAGE' => $dl_config['screen_active'] && $images < $dl_config['screen_max'], 'B_NOTES' => false, 'B_REASON' => false, 'B_UPL_FILE' => $dl_config['upl_file'] || can_admin($module_name), 'B_UPL_IMAGE' => $dl_config['upl_image'] || can_admin($module_name), 'B_PENDING' => false, 'B_FETCH_PAD' => $fetch_pad, 'B_REM_MD5' => $dl_config['md5_remote'], 'L_YES' => _YES, 'L_NO' => _NO, 'L_DELETE' => _DELETE, 'L_UPDATE' => 'Update', 'L_CATEGORY' => _CATEGORY, 'L_SHORT_DESC' => 'Short Description', 'L_MAX_CHARS' => sprintf(_M_CHARS, 255), 'L_DESCRIPTION' => _DESCRIPTION, 'L_AUTHORNAME' => _AUTHORNAME, 'L_AUTHOREMAIL' => _AUTHOREMAIL, 'L_MD5' => 'MD5', 'S_BBCODE' => bbcode_table('in[desc_long]', 'add_download', true), 'DL_TITLE' => htmlprepare($in['title']), 'DL_ACCESS' => group_selectbox('in[access]', $in['access']), 'DL_CATSEL' => $selects, 'DL_DESC_SHORT' => htmlprepare($in['desc_short']), 'DL_DESC_LONG' => htmlprepare($in['desc_long']), 'DL_NOTES' => '', 'DL_REASON' => '', 'DL_NAME' => htmlprepare($in['name']), 'DL_EMAIL' => $in['email'], 'U_DL_FORM' => URL::index('&file=add'))); foreach ($errors as $error) { $cpgtpl->assign_block_vars('dl_errors', array('S_ENTRY' => $error)); } foreach ($warnings as $warning) { $cpgtpl->assign_block_vars('dl_warnings', array('S_ENTRY' => $warning)); } $result = $db->sql_uquery("SELECT * FROM " . $dl_prefix . "_fields \n\tWHERE visible > 0" . (!can_admin($module_name) ? ' AND visible < 3' : '') . " \n\tORDER BY title"); while ($field = $db->sql_fetchrow($result)) { $f_title = defined($field['title']) ? constant($field['title']) : $field['title']; $f_title = $field['visible'] == 2 ? '* ' . $f_title : $f_title; if ($field['type'] == 1 || $field['type'] == 3) { $f_value = isset($in[$field['field']]) ? intval($in[$field['field']]) : $field['size']; $f_value = $f_value > 0 ? array(' checked="checked"', '') : array('', ' checked="checked"'); $cpgtpl->assign_block_vars('fields', array('TITLE' => $f_title, 'TYPE' => $field['type'], 'NAME' => $field['field'], 'S_YES' => $f_value[0], 'S_NO' => $f_value[1])); } else {
$entries[$entry['updated']] = $entry; } ksort($entries); # Top downloads $result2 = $db->sql_query("SELECT DISTINCT d.lid, d.title, SUM(s.hits) AS hits FROM " . $dl_prefix . "_downloads d\n\tLEFT JOIN " . $dl_prefix . "_stats s ON (s.id = d.lid)\n\tWHERE d.active=1 \n\tGROUP BY d.lid, d.title \n\tORDER BY hits DESC \n\tLIMIT {$dl_config['front_rank']}"); $show = false; if (count($entries) && $db->sql_numrows($result2)) { $cpgtpl->assign_vars(array('LATEST_DOWNLOADS' => sprintf('Recently added or updated', $dl_config['front_rank']), 'TOP_DOWNLOADS' => sprintf('Top %s downloads', $dl_config['front_rank']))); $color = ''; for ($i = 0; $i < $dl_config['front_rank']; $i++) { $row = array_pop($entries); if (!isset($row)) { break; } $color = $color == $bgcolor1 ? $bgcolor3 : $bgcolor1; $cpgtpl->assign_block_vars('latest', array('NUM' => $i + 1, 'COLOR' => $color, 'S_TITLE' => $row['title'], 'S_TYPE' => $row['new'] ? _NEW : 'Update', 'U_DETAILS' => URL::index('&file=details&id=' . $row['lid']))); } $color = $bgcolor3; $i = 0; while (list($pop_id, $pop_title, $pop_hits) = $db->sql_fetchrow($result2)) { $color = $color == $bgcolor1 ? $bgcolor3 : $bgcolor1; $cpgtpl->assign_block_vars('top', array('NUM' => $i + 1, 'COLOR' => $color, 'S_TITLE' => $pop_title, 'S_HITS' => $pop_hits . ' ' . strtolower(_HITS), 'U_DETAILS' => URL::index('&file=details&id=' . $pop_id))); $i++; } $show = true; } $cpgtpl->assign_vars(array('DL_MENU' => dl_menu(), 'B_LATEST_TOP' => $show)); $db->sql_freeresult($result2); $cpgtpl->set_filenames(array('body' => 'downloads/index.html')); $cpgtpl->display('body'); }