if (!empty($key)) {
        $keyword = '%' . addcslashes($key, '_%') . '%';
        $sth->bindParam(':keyword1', $keyword, PDO::PARAM_STR);
        $sth->bindParam(':keyword2', $keyword, PDO::PARAM_STR);
        $sth->bindParam(':keyword3', $keyword, PDO::PARAM_STR);
    }
    $sth->execute();
    while ($row = $sth->fetch()) {
        $cattitle = '<a href="' . NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;' . NV_OP_VARIABLE . '=' . $list_cats[$row['catid']]['alias'] . '">' . $list_cats[$row['catid']]['title'] . '</a>';
        $uploadtime = (int) $row['uploadtime'];
        if ($uploadtime >= $today) {
            $uploadtime = $lang_module['today'] . ', ' . date('H:i', $row['uploadtime']);
        } elseif ($uploadtime >= $yesterday) {
            $uploadtime = $lang_module['yesterday'] . ', ' . date('H:i', $row['uploadtime']);
        } else {
            $uploadtime = nv_date('d/m/Y H:i', $row['uploadtime']);
        }
        $array[$row['id']] = array('id' => $row['id'], 'title' => $row['title'], 'cattitle' => $cattitle, 'introtext' => $row['introtext'], 'uploadtime' => $uploadtime, 'author_name' => $row['author_name'], 'filesize' => !empty($row['filesize']) ? nv_convertfromBytes($row['filesize']) : '', 'imagesrc' => !empty($row['fileimage']) ? NV_BASE_SITEURL . NV_FILES_DIR . $row['fileimage'] : '', 'view_hits' => $row['view_hits'], 'download_hits' => $row['download_hits'], 'more_link' => NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;' . NV_OP_VARIABLE . '=' . $list_cats[$row['catid']]['alias'] . '/' . $row['alias'] . $global_config['rewrite_exturl'], 'edit_link' => defined('NV_IS_MODADMIN') ? NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;edit=1&amp;id=' . $row['id'] : '', 'del_link' => defined('NV_IS_MODADMIN') ? NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name : '');
    }
    $generate_page = nv_alias_page($page_title, $base_url, $num_items, $per_page, $page);
    $contents = theme_viewcat_list($array, $generate_page);
    if ($page > 1) {
        $page_title .= ' ' . NV_TITLEBAR_DEFIS . ' ' . $lang_global['page'] . ' ' . $page;
    }
} else {
    $contents = $lang_module['search_noresult'];
}
$key_words = $description = 'no';
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';
/**
 * theme_viewcat_main()
 *
 * @param mixed $viewcat
 * @param mixed $array_cats
 * @param mixed $list_cats
 * @param mixed $download_config
 * @return
 */
function theme_viewcat_main($viewcat, $array_cats, $array_files = array(), $cat_data = array(), $generate_page = '')
{
    global $global_config, $site_mods, $lang_module, $lang_global, $module_info, $module_name, $module_file, $my_head, $download_config, $list_cats;
    $xtpl = new XTemplate($viewcat . '.tpl', NV_ROOTDIR . '/themes/' . $module_info['template'] . '/modules/' . $module_file . '/');
    $xtpl->assign('LANG', $lang_module);
    $xtpl->assign('GLANG', $lang_global);
    $xtpl->assign('IMG_FOLDER', NV_BASE_SITEURL . 'themes/' . $module_info['template'] . '/images/download/');
    $xtpl->assign('MODULELINK', NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;' . NV_OP_VARIABLE . '=');
    foreach ($array_cats as $cat) {
        if (empty($cat['parentid'])) {
            if ($download_config['is_addfile_allow']) {
                $cat['uploadurl'] = NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;' . NV_OP_VARIABLE . '=' . $site_mods[$module_name]['alias']['upload'] . '/' . $cat['catid'];
            }
            $xtpl->assign('catbox', $cat);
            if (!empty($cat['subcats'])) {
                $i = 0;
                foreach ($list_cats as $subcat) {
                    if ($subcat['parentid'] == $cat['catid']) {
                        $subcat['link'] = NV_BASE_SITEURL . "index.php?" . NV_LANG_VARIABLE . "=" . NV_LANG_DATA . "&amp;" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=" . $subcat['alias'];
                        $xtpl->assign('listsubcat', $subcat);
                        if (++$i >= 3) {
                            $xtpl->assign('MORE', $cat['link']);
                            $xtpl->parse('main.catbox.subcatbox.more');
                            break;
                        }
                        $xtpl->parse('main.catbox.subcatbox.listsubcat');
                    }
                }
                $xtpl->parse('main.catbox.subcatbox');
            }
            $items = $cat['items'];
            #parse the first items
            $thefirstcat = current($items);
            $xtpl->assign('itemcat', $thefirstcat);
            if (!empty($thefirstcat['imagesrc'])) {
                $xtpl->parse('main.catbox.itemcat.image');
            }
            if (defined('NV_IS_MODADMIN')) {
                $xtpl->assign('EDIT', NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;edit=1&amp;id=' . $thefirstcat['id']);
                $xtpl->assign('DEL', NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name);
                $xtpl->parse('main.catbox.itemcat.adminlink');
            }
            if ($download_config['is_addfile_allow']) {
                $xtpl->parse('main.catbox.is_addfile_allow');
            }
            $xtpl->parse('main.catbox.itemcat');
            foreach ($items as $item) {
                if ($item['id'] != $thefirstcat['id']) {
                    $xtpl->assign('loop', $item);
                    $xtpl->parse('main.catbox.related.loop');
                }
            }
            $xtpl->parse('main.catbox.related');
            $xtpl->parse('main.catbox');
        }
    }
    // Danh sach file trong chu de
    if (!empty($array_files)) {
        if (!empty($cat_data)) {
            $xtpl->assign('CAT_TITLE', sprintf($lang_module['viewcat_listfile'], $cat_data['title']));
        }
        $xtpl->assign('FILE_LIST', theme_viewcat_list($array_files, $generate_page, $cat_data, false));
        $xtpl->parse('main.filelist');
    }
    $xtpl->parse('main');
    return $xtpl->text('main');
}
Beispiel #3
0
                $array_cats[$catid_i]['items'] = $array_item;
            }
        }
    }
    $contents = theme_viewcat_main($viewcat, $array_cats);
} elseif ($viewcat == 'viewcat_list_new') {
    $array_files = array();
    $base_url = NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name;
    // Fetch Limit
    $db->sqlreset()->select('COUNT(*)')->from(NV_PREFIXLANG . '_' . $module_data)->where('status=1');
    $all_page = $db->query($db->sql())->fetchColumn();
    $db->select('id, catid, title, alias, introtext , uploadtime, author_name, filesize, fileimage, view_hits, download_hits, comment_hits')->order('uploadtime DESC')->limit($per_page)->offset(($page - 1) * $per_page);
    $_query = $db->query($db->sql());
    while ($row = $_query->fetch()) {
        $uploadtime = (int) $row['uploadtime'];
        if ($uploadtime >= $today) {
            $uploadtime = $lang_module['today'] . ', ' . date('H:i', $row['uploadtime']);
        } elseif ($uploadtime >= $yesterday) {
            $uploadtime = $lang_module['yesterday'] . ', ' . date('H:i', $row['uploadtime']);
        } else {
            $uploadtime = nv_date('d/m/Y H:i', $row['uploadtime']);
        }
        $array_files[$row['id']] = array('id' => (int) $row['id'], 'title' => $row['title'], 'introtext' => $row['introtext'], 'uploadtime' => $uploadtime, 'author_name' => !empty($row['author_name']) ? $row['author_name'] : $lang_module['unknown'], 'filesize' => !empty($row['filesize']) ? nv_convertfromBytes($row['filesize']) : '', 'imagesrc' => !empty($row['fileimage']) ? NV_BASE_SITEURL . NV_FILES_DIR . $row['fileimage'] : '', 'view_hits' => (int) $row['view_hits'], 'download_hits' => (int) $row['download_hits'], 'comment_hits' => (int) $row['comment_hits'], 'more_link' => NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;' . NV_OP_VARIABLE . '=' . $list_cats[$row['catid']]['alias'] . '/' . $row['alias'] . $global_config['rewrite_exturl'], 'edit_link' => defined('NV_IS_MODADMIN') ? NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&amp;' . NV_NAME_VARIABLE . '=' . $module_name . '&amp;edit=1&amp;id=' . $row['id'] : '', 'del_link' => defined('NV_IS_MODADMIN') ? NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name : '');
    }
    $page_title = $page > 1 ? $page_title . ' - ' . $lang_module['page'] . ' ' . $page : $page_title;
    $page = nv_alias_page($page_title, $base_url, $all_page, $per_page, $page);
    $contents = theme_viewcat_list($array_files, $page);
}
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';
Beispiel #4
0
/**
 * theme_search()
 *
 * @param mixed $array
 * @param mixed $generate_page
 * @param mixed $is_search
 * @return
 */
function theme_search($array, $generate_page, $is_search)
{
    global $module_info, $module_name, $module_file, $lang_module, $lang_global;
    $xtpl = new XTemplate('search.tpl', NV_ROOTDIR . '/themes/' . $module_info['template'] . '/modules/' . $module_file . '/');
    $xtpl->assign('LANG', $lang_module);
    if ($is_search) {
        if (!empty($array)) {
            $xtpl->assign('SEARCH', theme_viewcat_list($array, $generate_page, array(), false, false));
            $xtpl->parse('main.is_search.data');
        } else {
            $xtpl->parse('main.is_search.empty');
        }
        $xtpl->parse('main.is_search');
    } else {
        $xtpl->parse('main.not_search');
    }
    $xtpl->parse('main');
    return $xtpl->text('main');
}