mod_sort_sons PHP Code Examples

Example #1

0

Show file

File: function.module.php Project: xubo245/liuyangzhang

/**
*更新栏目有几个子栏目
**/
function mod_sort_sons($table, $fid)
{
    global $db;
    $query = $db->query("SELECT * FROM {$table} WHERE fup='{$fid}'");
    $sons = $db->num_rows($query);
    $db->query("UPDATE {$table} SET sons='{$sons}' WHERE fid='{$fid}' ");
    while (@extract($db->fetch_array($query))) {
        mod_sort_sons($table, $fid);
    }
}

Example #2

0

Show file

File: admin.php Project: xubo245/liuyangzhang

} elseif ($action == "delete") {
    $db->query(" DELETE FROM `{$pre}area` WHERE fid='{$fid}' ");
    mod_sort_class("{$pre}area", 0, 0);
    //更新class
    mod_sort_sons("{$pre}area", 0);
    //更新sons
    /*更新导航缓存*/
    cache_area();
    refreshto($FROMURL, "删除成功");
} elseif ($action == "editlist") {
    foreach ($order as $key => $value) {
        $db->query("UPDATE {$pre}area SET list='{$value}' WHERE fid='{$key}' ");
    }
    mod_sort_class("{$pre}area", 0, 0);
    //更新class
    mod_sort_sons("{$pre}area", 0);
    //更新sons
    /*更新导航缓存*/
    cache_area();
    refreshto("{$FROMURL}", "修改成功", 1);
}
/**
*更新缓存
**/
function cache_area()
{
    global $db, $pre;
    $show = "<?php\r\n";
    $query = $db->query("SELECT fid,fup,name FROM {$pre}area LIMIT 500");
    while ($rs = $db->fetch_array($query)) {
        $rs[name] = addslashes($rs[name]);

Example #3

0

Show file

File: global.php Project: GHubgenius/qbbj

/**
*更新栏目有几个子栏目
**/
function mod_sort_sons($table, $fid)
{
    global $db, $webdb, $pre;
    if ($table == "{$pre}sort" && $webdb[sortNUM] > 500) {
        return;
    }
    $query = $db->query("SELECT * FROM {$table} WHERE fup='{$fid}'");
    $sons = $db->num_rows($query);
    $db->query("UPDATE {$table} SET sons='{$sons}' WHERE fid='{$fid}' ");
    while (@extract($db->fetch_array($query))) {
        mod_sort_sons($table, $fid);
    }
}

Example #4

0

Show file

File: fu_sort.php Project: GHubgenius/qbbj

    if (!$ofid) {
        showmsg("请选择一个源栏目");
    } elseif (!$nfid) {
        showmsg("请选择一个目标栏目");
    }
    if ($ofid == $nfid) {
        showmsg("出错了，栏目本身不能合并为自己,请选择合并到其他栏目去吧");
    }
    $erp = $Fid_db[iftable][$ofid];
    $db->query("UPDATE {$pre}article{$erp} SET fid='{$nfid}',fname='{$Fid_db[name][$nfid]}' WHERE fid='{$ofid}'");
    $db->query("UPDATE {$pre}reply{$erp} SET fid='{$nfid}' WHERE fid='{$ofid}'");
    $db->query("UPDATE {$pre}comment SET fid='{$nfid}' WHERE fid='{$ofid}'");
    $db->query("DELETE FROM {$pre}fu_sort WHERE fid='{$ofid}'");
    mod_sort_class("{$pre}fu_sort", 0, 0);
    //更新class
    mod_sort_sons("{$pre}fu_sort", 0);
    //更新sons
    /*更新导航缓存*/
    cache_guide();
    jump("操作完毕", "{$FROMURL}", 1);
}
/*
elseif($job=="config"&&$Apower[sort_config])
{
	$webdb[viewNoPassArticle]==='0' || $webdb[viewNoPassArticle]=1;
	$viewNoPassArticle[$webdb[viewNoPassArticle]]=" checked ";

	$webdb[ifContribute]==='0' || $webdb[ifContribute]=1;
	$ifContribute[$webdb[ifContribute]]=" checked ";

	$webdb[autoGetSmallPic]=(int)$webdb[autoGetSmallPic];

Example #5

0

Show file

File: sort.php Project: GHubgenius/qbbj

    jump("修改成功", "{$FROMURL}");
} elseif ($action == "delete") {
    $db->query(" DELETE FROM `{$_pre}sort` WHERE fid='{$fid}' ");
    mod_sort_class("{$_pre}sort", 0, 0);
    //更新class
    mod_sort_sons("{$_pre}sort", 0);
    //更新sons
    module_fid_cache();
    jump("删除成功", $FROMURL);
} elseif ($action == "editlist") {
    foreach ($order as $key => $value) {
        $db->query("UPDATE {$_pre}sort SET list='{$value}' WHERE fid='{$key}' ");
    }
    mod_sort_class("{$_pre}sort", 0, 0);
    //更新class
    mod_sort_sons("{$_pre}sort", 0);
    //更新sons
    module_fid_cache();
    jump("修改成功", "{$FROMURL}", 1);
}
//后台栏目管理用
function module_list_all_sort($fid, $Class)
{
    global $db, $_pre, $listdb;
    $Class++;
    $query = $db->query("SELECT S.* FROM {$_pre}sort S WHERE S.fup='{$fid}' ORDER BY S.list DESC");
    while ($rs = $db->fetch_array($query)) {
        $icon = "";
        for ($i = 1; $i < $Class; $i++) {
            $icon .= "&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;";
        }

Example #6

0

Show file

File: spsort.php Project: GHubgenius/qbbj

    cache_guide();
    jump("修改成功", "{$FROMURL}", 1);
} elseif ($job == 'save' && $Apower[spsort_listsort]) {
    $errsort = sort_error("{$pre}spsort", 'fid');
    $sort_fup = $Guidedb->Select("{$pre}spsort", "fup", $rsdb[fup]);
    require dirname(__FILE__) . "/" . "head.php";
    require dirname(__FILE__) . "/" . "template/spsort/menu.htm";
    require dirname(__FILE__) . "/" . "template/spsort/save.htm";
    require dirname(__FILE__) . "/" . "foot.php";
} elseif ($action == 'save' && $Apower[spsort_listsort]) {
    if (!$fid) {
        showmsg("请选择一个栏目");
    }
    $db->query("UPDATE {$pre}spsort SET fid='{$fup}' WHERE fid='{$fid}' ");
    mod_sort_class("{$pre}spsort", 0, 0);
    //更新class
    mod_sort_sons("{$pre}spsort", 0);
    //更新sons
    /*更新导航缓存*/
    cache_guide();
    jump("本栏目修正成功", "{$FROMURL}", 1);
}
/**
*更新导航缓存
**/
function cache_guide()
{
    global $Guidedb, $pre;
    //$Guidedb->FidSonCache("{$pre}spsort","../data/guideSP_fid.php",1);
    $Guidedb->GuideFidCache("{$pre}spsort", "../data/guideSP_fid.php", 1);
}

PHP mod_sort_sons Examples