/**
* nv_set_status_module()
*
* @return
*/
function nv_set_status_module()
{
global $db, $module_name, $module_data, $global_config;
$check_run_cronjobs = NV_ROOTDIR . '/' . NV_LOGS_DIR . '/data_logs/cronjobs_' . md5($module_data . 'nv_set_status_module' . $global_config['sitekey']) . '.txt';
$p = NV_CURRENTTIME - 300;
if (file_exists($check_run_cronjobs) and @filemtime($check_run_cronjobs) > $p) {
return;
}
file_put_contents($check_run_cronjobs, '');
//status_0 = "Cho duyet";
//status_1 = "Xuat ban";
//status_2 = "Hen gio dang";
//status_3= "Het han";
// Dang cai bai cho kich hoat theo thoi gian
$query = $db->query('SELECT id, listcatid FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE status=2 AND publtime < ' . NV_CURRENTTIME . ' ORDER BY publtime ASC');
while (list($id, $listcatid) = $query->fetch(3)) {
$array_catid = explode(',', $listcatid);
foreach ($array_catid as $catid_i) {
$catid_i = intval($catid_i);
if ($catid_i > 0) {
$db->query('UPDATE ' . NV_PREFIXLANG . '_' . $module_data . '_' . $catid_i . ' SET status=1 WHERE id=' . $id);
}
}
$db->query('UPDATE ' . NV_PREFIXLANG . '_' . $module_data . '_rows SET status=1 WHERE id=' . $id);
}
// Ngung hieu luc cac bai da het han
$query = $db->query('SELECT id, listcatid, archive FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE status=1 AND exptime > 0 AND exptime <= ' . NV_CURRENTTIME . ' ORDER BY exptime ASC');
while (list($id, $listcatid, $archive) = $query->fetch(3)) {
if (intval($archive) == 0) {
nv_del_content_module($id);
} else {
nv_archive_content_module($id, $listcatid);
}
}
// Tim kiem thoi gian chay lan ke tiep
$time_publtime = $db->query('SELECT min(publtime) FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE status=2 AND publtime > ' . NV_CURRENTTIME)->fetchColumn();
$time_exptime = $db->query('SELECT min(exptime) FROM ' . NV_PREFIXLANG . '_' . $module_data . '_rows WHERE status=1 AND exptime > ' . NV_CURRENTTIME)->fetchColumn();
$timecheckstatus = min($time_publtime, $time_exptime);
if (!$timecheckstatus) {
$timecheckstatus = max($time_publtime, $time_exptime);
}
$sth = $db->prepare("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = :config_value WHERE lang = '" . NV_LANG_DATA . "' AND module = :module_name AND config_name = 'timecheckstatus'");
$sth->bindValue(':module_name', $module_name, PDO::PARAM_STR);
$sth->bindValue(':config_value', intval($timecheckstatus), PDO::PARAM_STR);
$sth->execute();
nv_del_moduleCache('settings');
nv_del_moduleCache($module_name);
unlink($check_run_cronjobs);
clearstatcache();
}
/**
* nv_set_status_module()
*
* @return
*/
function nv_set_status_module()
{
global $db, $module_name, $module_data, $global_config;
$check_run_cronjobs = NV_ROOTDIR . '/' . NV_LOGS_DIR . '/data_logs/cronjobs_' . md5($module_data . 'nv_set_status_module' . $global_config['sitekey']) . '.txt';
$p = NV_CURRENTTIME - 300;
if (file_exists($check_run_cronjobs) and @filemtime($check_run_cronjobs) > $p) {
return;
}
file_put_contents($check_run_cronjobs, '');
//status_0 = "Cho duyet";
//status_1 = "Xuat ban";
//status_2 = "Hen gio dang";
//status_3= "Het han";
// Dang cai bai cho kich hoat theo thoi gian
$query = $db->sql_query("SELECT `id`, `listcatid` FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` WHERE `status`=2 AND `publtime` < " . NV_CURRENTTIME . " ORDER BY `publtime` ASC");
while (list($id, $listcatid) = $db->sql_fetchrow($query)) {
$array_catid = explode(",", $listcatid);
foreach ($array_catid as $catid_i) {
$catid_i = intval($catid_i);
if ($catid_i > 0) {
$db->sql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "_" . $catid_i . "` SET `status`='1' WHERE `id`=" . $id . "");
}
}
$db->sql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "_rows` SET `status`='1' WHERE `id`=" . $id . "");
}
// Ngung hieu luc cac bai da het han
$query = $db->sql_query("SELECT `id`, `listcatid`, `archive` FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` WHERE `status`=1 AND `exptime` > 0 AND `exptime` <= " . NV_CURRENTTIME . " ORDER BY `exptime` ASC");
while (list($id, $listcatid, $archive) = $db->sql_fetchrow($query)) {
if (intval($archive) == 0) {
nv_del_content_module($id);
} else {
nv_archive_content_module($id, $listcatid);
}
}
// Tim kiem thoi gian chay lan ke tiep
list($time_publtime) = $db->sql_fetchrow($db->sql_query("SELECT min(publtime) FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` WHERE `status`=2 AND `publtime` > " . NV_CURRENTTIME));
list($time_exptime) = $db->sql_fetchrow($db->sql_query("SELECT min(exptime) FROM `" . NV_PREFIXLANG . "_" . $module_data . "_rows` WHERE `status`=1 AND `exptime` > " . NV_CURRENTTIME));
$timecheckstatus = min($time_publtime, $time_exptime);
if (!$timecheckstatus) {
$timecheckstatus = max($time_publtime, $time_exptime);
}
$db->sql_query("REPLACE INTO `" . NV_CONFIG_GLOBALTABLE . "` (`lang`, `module`, `config_name`, `config_value`) VALUES('" . NV_LANG_DATA . "', " . $db->dbescape($module_name) . ", 'timecheckstatus', '" . intval($timecheckstatus) . "')");
nv_del_moduleCache('settings');
nv_del_moduleCache($module_name);
unlink($check_run_cronjobs);
clearstatcache();
}
$result = $db->sql_query($sql);
while (list($catid_i, $parentid_i, $title_i, $alias_i, $is_top_menu_i, $is_leaf_i, $viewcat_i, $subcatid_i, $numlinks_i, $del_cache_time_i, $description_i, $inhome_i, $keywords_i, $who_view_i, $groups_view_i) = $db->sql_fetchrow($result)) {
$link_i = NV_BASE_SITEURL . "index.php?" . NV_LANG_VARIABLE . "=" . NV_LANG_DATA . "&" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $alias_i;
$global_array_cat[$catid_i] = array("catid" => $catid_i, "parentid" => $parentid_i, "title" => $title_i, "alias" => $alias_i, "is_top_menu" => $is_top_menu_i, "is_leaf" => $is_leaf_i, "link" => $link_i, "viewcat" => $viewcat_i, "subcatid" => $subcatid_i, "numlinks" => $numlinks_i, "description" => $description_i, "inhome" => $inhome_i, "keywords" => $keywords_i, "who_view" => $who_view_i, "groups_view" => $groups_view_i);
if ($alias_cat_url == $alias_i) {
$catid = $catid_i;
$parentid = $parentid_i;
}
if (NV_CURRENTTIME > $del_cache_time_i) {
$sql = "SELECT `id`, `listcatid`, `exptime`, `archive` FROM `" . NV_PREFIXLANG . "_" . $module_data . "_" . $catid_i . "` WHERE `exptime` > 0 AND `exptime` <= UNIX_TIMESTAMP() AND `archive`!='2' ORDER BY `exptime` ASC LIMIT 0 , 1";
list($id, $listcatid, $minexptime, $archive) = $db->sql_fetchrow($db->sql_query($sql));
if (intval($id) > 0) {
if (intval($archive) == 0) {
nv_del_content_module($id);
} else {
nv_archive_content_module($id, $listcatid);
}
nv_del_moduleCache($module_name);
}
list($minpubltime) = $db->sql_fetchrow($db->sql_query("SELECT min(publtime) FROM `" . NV_PREFIXLANG . "_" . $module_data . "_" . $catid_i . "` WHERE `publtime` > UNIX_TIMESTAMP()"));
$minpubltime = empty($minpubltime) ? NV_CURRENTTIME + 26000000 : intval($minpubltime);
list($id, $listcatid, $minexptime, $archive) = $db->sql_fetchrow($db->sql_query($sql));
$minexptime = empty($minexptime) ? NV_CURRENTTIME + 26000000 : intval($minexptime);
$del_cache_time = min($minpubltime, $minexptime);
$db->sql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "_cat` SET `del_cache_time`=" . $db->dbescape($del_cache_time) . " WHERE `catid`=" . $catid_i . "");
}
}
foreach ($global_array_cat as $catid_i => $array_cat_i) {
if ($catid_i > 0 and $array_cat_i['parentid'] == 0) {
$act = 0;
$submenu = array();
/**
* nv_set_status_module()
*
* @return
*/
function nv_set_status_module()
{
global $db, $module_name, $module_data, $global_config, $db_config;
$check_run_cronjobs = NV_ROOTDIR . '/' . NV_LOGS_DIR . '/data_logs/cronjobs_' . md5($module_data . 'nv_set_status_module' . $global_config['sitekey']) . '.txt';
$p = NV_CURRENTTIME - 300;
if (file_exists($check_run_cronjobs) and @filemtime($check_run_cronjobs) > $p) {
return;
}
file_put_contents($check_run_cronjobs, '');
// status_0 = "Cho duyet";
// status_1 = "Xuat ban";
// status_2 = "Hen gio dang";
// status_3= "Het han";
// Dang cac san pham cho kich hoat theo thoi gian
$result = $db->query('SELECT id FROM ' . $db_config['prefix'] . '_' . $module_data . '_rows WHERE status =2 AND publtime < ' . NV_CURRENTTIME . ' ORDER BY publtime ASC');
while (list($id) = $result->fetch(3)) {
$db->query('UPDATE ' . $db_config['prefix'] . '_' . $module_data . '_rows SET status =1 WHERE id=' . $id);
}
// Ngung hieu luc cac san pham da het han
$result = $db->query('SELECT id, archive FROM ' . $db_config['prefix'] . '_' . $module_data . '_rows WHERE status =1 AND exptime > 0 AND exptime <= ' . NV_CURRENTTIME . ' ORDER BY exptime ASC');
while (list($id, $archive) = $result->fetch(3)) {
if (intval($archive) == 0) {
nv_del_content_module($id);
} else {
nv_archive_content_module($id);
}
}
// Tim kiem thoi gian chay lan ke tiep
$time_publtime = $db->query('SELECT MIN(publtime) FROM ' . $db_config['prefix'] . '_' . $module_data . '_rows WHERE status =2 AND publtime > ' . NV_CURRENTTIME)->fetchColumn();
$time_exptime = $db->query('SELECT MIN(exptime) FROM ' . $db_config['prefix'] . '_' . $module_data . '_rows WHERE status =1 AND exptime > ' . NV_CURRENTTIME)->fetchColumn();
$timecheckstatus = min($time_publtime, $time_exptime);
if (!$timecheckstatus) {
$timecheckstatus = max($time_publtime, $time_exptime);
}
$db->query("REPLACE INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES('" . NV_LANG_DATA . "', " . $db->quote($module_name) . ", 'timecheckstatus', '" . intval($timecheckstatus) . "')");
$nv_Cache->delMod('settings');
$nv_Cache->delMod($module_name);
unlink($check_run_cronjobs);
clearstatcache();
}