$uploadtime = nv_date('d/m/Y H:i', $row['uploadtime']); $array_item[] = array('id' => $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' => $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 . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $list_cats[$row['catid']]['alias'] . '/' . $row['alias'] . $global_config['rewrite_exturl'], 'edit_link' => NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&edit=1&id=' . (int) $row['id'], 'del_link' => NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name); } $numfile = $db->query('SELECT COUNT(*) FROM ' . NV_PREFIXLANG . '_' . $module_data . ' WHERE catid IN ( ' . $allcats . ' )')->fetchColumn(); if ($i) { $subs[] = array('catid' => $sub, 'title' => $list_cats[$sub]['title'], 'link' => NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $list_cats[$sub]['alias'], 'description' => $list_cats[$sub]['description'], 'subcats' => $list_cats[$sub]['subcats'], 'numfile' => $numfile, 'items' => $array_item); } unset($array_item); } } // Chuyen huong neu khong co noi dung gi if (empty($num_items) and empty($subs)) { Header('Location: ' . nv_url_rewrite(NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name, true)); exit; } $contents = theme_viewcat_main($viewcat, $subs, $array, $c, $generate_page); } elseif ($viewcat == 'viewcat_list_new') { $db->sqlreset()->select('COUNT(*)')->from(NV_PREFIXLANG . '_' . $module_data)->where('catid=' . $c['id'] . ' AND status=1'); $num_items = $db->query($db->sql())->fetchColumn(); $c['numfile'] = $num_items; $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); $result = $db->query($db->sql()); while ($row = $result->fetch()) { $cattitle = '<a href="' . NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . 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_item[$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 . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . 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 . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&edit=1&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 : ''); } $numfile = $db->query('SELECT COUNT(*) FROM ' . NV_PREFIXLANG . '_' . $module_data . ' WHERE catid IN ( ' . implode(',', $allcats) . ' )')->fetchColumn(); $array_cats[$catid_i] = array(); $array_cats[$catid_i]['catid'] = $value['id']; $array_cats[$catid_i]['title'] = $value['title']; $array_cats[$catid_i]['link'] = NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $value['alias']; $array_cats[$catid_i]['description'] = $list_cats[$value['id']]['description']; $array_cats[$catid_i]['numfile'] = $numfile; $array_cats[$catid_i]['viewcat'] = $list_cats[$value['id']]['viewcat']; $array_cats[$catid_i]['subcats'] = $list_cats[$value['id']]['subcats']; $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 . '&' . 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 {
$array_item = array(); $result = $db->query($db->where('catid IN (' . implode(',', $array_cat) . ') AND status=1')->sql()); $i = 0; while ($row = $result->fetch()) { ++$i; $uploadtime = nv_date('d/m/Y H:i', $row['uploadtime']); $array_item[] = array('id' => $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' => $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 . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $list_cats[$row['catid']]['alias'] . '/' . $row['alias'] . $global_config['rewrite_exturl'], 'edit_link' => NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&edit=1&id=' . (int) $row['id'], 'del_link' => NV_BASE_ADMINURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name); } $numfile = $db->query('SELECT COUNT(*) FROM ' . NV_MOD_TABLE . ' WHERE catid IN ( ' . implode(',', $array_cat) . ' )')->fetchColumn(); if ($i) { $subs[] = array('catid' => $sub, 'title' => $list_cats[$sub]['title'], 'link' => NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $list_cats[$sub]['alias'], 'description' => $list_cats[$sub]['description'], 'subcats' => $list_cats[$sub]['subcatid'], 'numfile' => $numfile, 'items' => $array_item); } unset($array_item); } } $contents = theme_viewcat_main($cat_data['viewcat'], $subs, $array, $cat_data, $generate_page); } elseif ($cat_data['viewcat'] == 'viewcat_list_new') { $array_cat = GetCatidInParent($cat_data['id']); $db->sqlreset()->select('COUNT(*)')->from(NV_MOD_TABLE)->where('catid IN (' . implode(',', $array_cat) . ') AND status=1'); $num_items = $db->query($db->sql())->fetchColumn(); $cat_data['numfile'] = $num_items; $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); $result = $db->query($db->sql()); while ($row = $result->fetch()) { $cattitle = '<a href="' . NV_BASE_SITEURL . 'index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&' . NV_NAME_VARIABLE . '=' . $module_name . '&' . 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 {