$item['imghome'] = NV_BASE_SITEURL . NV_FILES_DIR . '/' . $module_upload . '/' . $item['homeimgfile'];
} elseif ($item['homeimgthumb'] == 2) {
//image file
$item['imghome'] = NV_BASE_SITEURL . NV_UPLOADS_DIR . '/' . $module_upload . '/' . $item['homeimgfile'];
} elseif ($item['homeimgthumb'] == 3) {
//image url
$item['imghome'] = $item['homeimgfile'];
} elseif (!empty($show_no_image)) {
//no image
$item['imghome'] = NV_BASE_SITEURL . $show_no_image;
} else {
$item['imghome'] = '';
}
$item['newday'] = $global_array_cat[$item['catid']]['newday'];
$item['link'] = $global_array_cat[$item['catid']]['link'] . '/' . $item['alias'] . '-' . $item['id'] . $global_config['rewrite_exturl'];
$array_catpage[] = $item;
}
$viewcat = 'viewcat_list_new';
$generate_page = nv_alias_page($page_title, $base_url, $num_items, $per_page, $page);
$contents = call_user_func($viewcat, $array_catpage, 0, ($page - 1) * $per_page, $generate_page);
}
if (!defined('NV_IS_MODADMIN') and $contents != '' and $cache_file != '') {
$nv_Cache->setItem($module_name, $cache_file, $contents);
}
}
if ($page > 1) {
$page_title .= ' ' . NV_TITLEBAR_DEFIS . ' ' . $lang_global['page'] . ' ' . $page;
}
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';
$compare_id = unserialize($compare_id);
$link = NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=';
$base_url = NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=group/' . $global_array_group[$groupid]['alias'];
$array_pro_id = array();
$_sql = 'SELECT pro_id FROM ' . $db_config['prefix'] . '_' . $module_data . '_group_items WHERE group_id IN (' . implode(',', $chirld_groupid) . ')';
$_query = $db->query($_sql);
while (list($pro_id) = $_query->fetch(3)) {
$array_pro_id[] = $pro_id;
}
$array_pro_id = array_unique($array_pro_id);
$array_pro_id = !empty($array_pro_id) ? implode(',', $array_pro_id) : 0;
// Fetch Limit
$db->sqlreset()->select('COUNT(*)')->from($db_config['prefix'] . '_' . $module_data . '_rows')->where('status=1 AND id IN ( ' . $array_pro_id . ' )');
$num_items = $db->query($db->sql())->fetchColumn();
$db->select('id, listcatid, publtime, ' . NV_LANG_DATA . '_title, ' . NV_LANG_DATA . '_alias, ' . NV_LANG_DATA . '_hometext, homeimgalt, homeimgfile, homeimgthumb, product_code, product_number, product_price, money_unit, discount_id, showprice, ' . NV_LANG_DATA . '_gift_content, gift_from, gift_to')->order('id DESC')->limit($per_page)->offset(($page - 1) * $per_page);
$result = $db->query($db->sql());
$data_content = GetDataInGroup($result, $groupid);
$data_content['count'] = $num_items;
if (sizeof($data_content['data']) < 1 and $page > 1) {
Header('Location: ' . nv_url_rewrite(NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name, true));
exit;
}
$pages = nv_alias_page($page_title, $base_url, $num_items, $per_page, $page);
if ($page > 1) {
$page_title .= ' ' . NV_TITLEBAR_DEFIS . ' ' . $lang_global['page'] . ' ' . $page;
$description .= ' ' . $page;
}
$contents = call_user_func($global_array_group[$groupid]['viewgroup'], $data_content, $compare_id, $pages, $sorts, $viewtype);
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';
$item['alt'] = !empty($item['homeimgalt']) ? $item['homeimgalt'] : $item['title'];
$item['width'] = $module_config[$module_name]['homewidth'];
$end_weight = $item['weight'];
$item['link'] = $global_array_cat[$item['catid']]['link'] . "/" . $item['alias'] . "-" . $item['id'];
$topic_array[] = $item;
}
$db->sql_freeresult($query);
unset($query, $row);
$topic_other_array = array();
$query = $db->sql_query("SELECT t1.id, t1.catid, t1.addtime, t1.edittime, t1.publtime, t1.title, t1.alias, t1.hitstotal FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` as t1 INNER JOIN `" . NV_PREFIXLANG . "_" . $module_data . "_block` AS t2 ON t1.id = t2.id WHERE t2.bid= " . $bid . " AND t2.weight > " . $end_weight . " ORDER BY t2.weight ASC LIMIT 0," . $st_links . "");
while ($item = $db->sql_fetch_assoc($query)) {
$item['link'] = $global_array_cat[$item['catid']]['link'] . "/" . $item['alias'] . "-" . $item['id'];
$topic_other_array[] = $item;
}
unset($query, $row, $arr_listcatid);
$generate_page = nv_alias_page($page_title, $base_url, $all_page, $per_page, $page);
$contents = topic_theme($topic_array, $topic_other_array, $generate_page);
if ($page > 1) {
$page_title .= ' ' . NV_TITLEBAR_DEFIS . ' ' . $lang_global['page'] . ' ' . $page;
}
}
} else {
$array_cat = array();
$key = 0;
$query_cat = $db->sql_query("SELECT `bid`, `number`, `title`, `alias` FROM `" . NV_PREFIXLANG . "_" . $module_data . "_block_cat` ORDER BY `weight` ASC");
while (list($bid, $numberlink, $btitle, $balias) = $db->sql_fetchrow($query_cat, 1)) {
$array_cat[$key] = array('catid' => $bid, 'alias' => '', 'subcatid' => '', 'title' => $btitle, 'link' => NV_BASE_SITEURL . "index.php?" . NV_LANG_VARIABLE . "=" . NV_LANG_DATA . "&" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=groups/" . $balias);
$query = $db->sql_query("SELECT t1.id, t1.catid, t1.admin_id, t1.author, t1.sourceid, t1.addtime, t1.edittime, t1.publtime, t1.title, t1.alias, t1.hometext, t1.homeimgfile, t1.homeimgalt, t1.homeimgthumb, t1.allowed_rating, t1.hitstotal, t1.hitscm, t1.total_rating, t1.click_rating, t1.keywords FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` as t1 INNER JOIN `" . NV_PREFIXLANG . "_" . $module_data . "_block` AS t2 ON t1.id = t2.id WHERE t2.bid= " . $bid . " AND t1.status= 1 ORDER BY t2.weight ASC LIMIT 0," . $numberlink);
while ($item = $db->sql_fetch_assoc($query)) {
$array_img = !empty($item['homeimgthumb']) ? explode("|", $item['homeimgthumb']) : ($array_img = array("", ""));
if ($array_img[0] != "" and file_exists(NV_ROOTDIR . '/' . NV_FILES_DIR . '/' . $module_name . '/' . $array_img[0])) {
$orderby = 'rand() ';
}
$base_url = $global_array_cat[$catid]['link'];
$sql = "SELECT SQL_CALC_FOUND_ROWS `id`, `author`, `title`, `alias`, `url`, `urlimg`, `add_time`, `description`,`hits_total` FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` WHERE status='1' AND catid='" . $catid . "' ORDER BY " . $orderby . $sort . " LIMIT " . ($page - 1) * $per_page . "," . $per_page;
$result = $db->sql_query($sql);
$result_all = $db->sql_query("SELECT FOUND_ROWS()");
list($all_page) = $db->sql_fetchrow($result_all);
while ($row = $db->sql_fetchrow($result)) {
$author = explode('|', $row['author']);
if ($author[0] == 1) {
$sql1 = "SELECT * FROM `" . NV_AUTHORS_GLOBALTABLE . "` WHERE `id`=" . $author[1] . "";
$result1 = $db->sql_query($sql1);
$row1 = $db->sql_fetchrow($result1);
$row['author'] = $row1;
}
$row['link'] = $global_array_cat[$catid]['link'] . "/" . $row['alias'] . "-" . $row['id'];
$row['visit'] = NV_BASE_SITEURL . "index.php?" . NV_LANG_VARIABLE . "=" . NV_LANG_DATA . "&" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=visitlink-" . $row['alias'] . "-" . $row['id'];
$row['report'] = NV_BASE_SITEURL . "index.php?" . NV_LANG_VARIABLE . "=" . NV_LANG_DATA . "&" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=reportlink-" . $row['alias'] . "-" . $row['id'];
$urlimg = NV_ROOTDIR . '/' . NV_UPLOADS_DIR . '/' . $row['urlimg'];
$imageinfo = nv_ImageInfo($urlimg, 300, true, NV_UPLOADS_REAL_DIR . '/' . $module_name . '/thumb');
$row['urlimg'] = $imageinfo['src'];
$items[] = $row;
}
$contents = call_user_func("viewcat", $array_subcat, $array_cat, $items);
$contents .= nv_alias_page($page_title, $base_url, $all_page, $per_page, $page);
if ($page > 1) {
$page_title .= ' ' . NV_TITLEBAR_DEFIS . ' ' . $lang_global['page'] . ' ' . $page;
}
include NV_ROOTDIR . "/includes/header.php";
echo nv_site_theme($contents);
include NV_ROOTDIR . "/includes/footer.php";
