PHP XoopsTree::getAllChildId方法代码示例

function b_gnavi_d3pipes_joints($options)
{
    global $xoopsDB;
    $mydirname = empty($options[0]) ? basename(dirname(dirname(__FILE__))) : $options[0];
    if (preg_match('/[^0-9a-zA-Z_-]/', $mydirname)) {
        die('Invalid mydirname');
    }
    require dirname(dirname(__FILE__)) . '/include/read_configs.php';
    $cat_limitation = empty($options[1]) ? 0 : 1;
    $photos_num = empty($options[2]) ? 10 : intval($options[2]);
    $show_desc = empty($options[3]) ? 0 : 1;
    $query = "ORDER BY unixtime DESC";
    $title_max_length = 255;
    // Category limitation
    if ($cat_limitation) {
        include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
        $cattree = new XoopsTree($table_cat, "cid", "pid");
        $children = $cattree->getAllChildId($cat_limitation);
        $whr_cat = "l.cid IN (";
        foreach ($children as $child) {
            $whr_cat .= "{$child},";
        }
        $whr_cat .= "{$cat_limitation})";
        for ($i = 1; $i <= 4; $i++) {
            $whr_cat .= " OR l.cid{$i} IN (";
            foreach ($children as $child) {
                $whr_cat .= "{$child},";
            }
            $whr_cat .= "{$cat_limitation})";
        }
        $whr_cat = "(" . $whr_cat . ")";
    } else {
        $whr_cat = '1';
    }
    $block = array();
    $myts =& MyTextSanitizer::getInstance();
    if ($show_desc) {
        $result = $xoopsDB->query("SELECT l.lid , l.cid , l.title , l.ext , l.res_x , l.res_y , l.submitter , l.status , l.date AS unixtime , l.hits , l.rating , l.votes , l.comments , c.title AS cat_title ,t.description ,t.arrowhtml FROM {$table_photos} l LEFT JOIN {$table_cat} c ON l.cid=c.cid LEFT JOIN {$table_text} t ON l.lid=t.lid WHERE l.status>0 AND {$whr_cat} {$query}", $photos_num, 0);
    } else {
        $result = $xoopsDB->query("SELECT l.lid , l.cid , l.title , l.ext , l.res_x , l.res_y , l.submitter , l.status , l.date AS unixtime , l.hits , l.rating , l.votes , l.comments , c.title AS cat_title FROM {$table_photos} l LEFT JOIN {$table_cat} c ON l.cid=c.cid WHERE l.status>0 AND {$whr_cat} {$query}", $photos_num, 0);
    }
    $count = 1;
    while ($photo = $xoopsDB->fetchArray($result)) {
        $photo['title'] = xoops_substr($myts->makeTboxData4Show($photo['title']), 0, $title_max_length + 3);
        $photo['cat_title'] = $myts->makeTboxData4Show($photo['cat_title']);
        $photo['date'] = formatTimestamp($photo['unixtime'], 's');
        if ($show_desc) {
            $photo['body'] = xoops_substr(strip_tags($myts->displayTarea($photo['description'], $photo['arrowhtml'], 1, 1, 1, 1, 1)), 0, 512);
        } else {
            $photo['body'] = '';
        }
        $photo['date'] = formatTimestamp($photo['unixtime'], 's');
        $block['photo'][$count++] = $photo;
    }
    $block['mod_url'] = $mod_url;
    return $block;
}

    die(_MD_D3FORUM_ERR_READFORUM);
}
// get&check this category ($category4assign, $category_row), override options
if (!(include dirname(dirname(__FILE__)) . '/include/process_this_category.inc.php')) {
    die(_MD_D3FORUM_ERR_READCATEGORY);
}
// get $post4assign
include dirname(dirname(__FILE__)) . '/include/process_this_post.inc.php';
// check delete permission
if (empty($can_delete)) {
    die(_MD_D3FORUM_ERR_DELETEPOST);
}
// count children
include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
$mytree = new XoopsTree($db->prefix($mydirname . "_posts"), "post_id", "pid");
$children = $mytree->getAllChildId($post_id);
// special permission check for delete
if ($isadminormod) {
    // admin delete
    // ok
} else {
    if (($uid == $post_row['uid'] || $uid == $post_row['uid_hidden']) && $xoopsModuleConfig['selfdellimit'] > 0) {
        // self delete
        if (time() < $post_row['post_time'] + intval($xoopsModuleConfig['selfdellimit'])) {
            // before time limit
            if (count($children) > 0) {
                // child(ren) exist(s)
                redirect_header(XOOPS_URL . "/modules/{$mydirname}/index.php?post_id={$post_id}", 2, _MD_D3FORUM_DELCHILDEXISTS);
                exit;
            } else {
                // all green for self delete

    }
    if ($max_h / $max_w > $p['res_y'] / $p['res_x']) {
        if ($p['res_x'] > $max_w) {
            $photo['width_height'] = "width='{$max_w}'";
        }
    } else {
        if ($p['res_y'] > $max_h) {
            $photo['width_height'] = "height='{$max_h}'";
        }
    }
}
$xoopsTpl->assign_by_ref('photo', $photo);
// Category Information
$cid = empty($p['cid']) ? $cid : $p['cid'];
$xoopsTpl->assign('category_id', $cid);
$cids = $cattree->getAllChildId($cid);
$sub_title = preg_replace("/\\'\\>/", "'><img src='{$mod_url}/images/folder16.gif' alt='' />", $cattree->getNicePathFromId($cid, 'title', "viewcat.php?num=" . intval($myalbum_perpage)));
$sub_title = preg_replace("/^(.+)folder16/", '$1folder_open', $sub_title);
$xoopsTpl->assign('album_sub_title', $sub_title);
// Orders
include XOOPS_ROOT_PATH . "/modules/{$mydirname}/include/photo_orders.php";
if (isset($_GET['orderby']) && isset($myalbum_orders[$_GET['orderby']])) {
    $orderby = $_GET['orderby'];
} else {
    if (isset($myalbum_orders[$myalbum_defaultorder])) {
        $orderby = $myalbum_defaultorder;
    } else {
        $orderby = 'lidA';
    }
}
// create category navigation

 function b_myalbum_rphoto_show($options)
 {
     global $xoopsDB;
     $mydirname = empty($options[0]) ? basename(dirname(dirname(__FILE__))) : $options[0];
     $box_size = empty($options[1]) ? 140 : intval($options[1]);
     $photos_num = empty($options[2]) ? 1 : intval($options[2]);
     $cat_limitation = empty($options[3]) ? 0 : intval($options[3]);
     $cat_limit_recursive = empty($options[4]) ? 0 : 1;
     $cycle = empty($options[5]) ? 60 : intval($options[5]);
     $cols = empty($options[6]) ? 1 : intval($options[6]);
     include XOOPS_ROOT_PATH . "/modules/{$mydirname}/include/read_configs.php";
     // Category limitation
     if ($cat_limitation) {
         if ($cat_limit_recursive) {
             include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
             $cattree = new XoopsTree($table_cat, "cid", "pid");
             $children = $cattree->getAllChildId($cat_limitation);
             $whr_cat = "l.cid IN (";
             foreach ($children as $child) {
                 $whr_cat .= "{$child},";
             }
             $whr_cat .= "{$cat_limitation})";
         } else {
             $whr_cat = "l.cid='{$cat_limitation}'";
         }
     } else {
         $whr_cat = '1';
     }
     // WHERE clause for ext
     // $whr_ext = "l.ext IN ('" . implode( "','" , $myalbum_normal_exts ) . "')" ;
     $whr_ext = "1";
     $block = array();
     $myts =& MyTextSanitizer::getInstance();
     // Get number of photo
     $result = $xoopsDB->query("SELECT count(l.lid) FROM {$table_photos} l WHERE status>0 AND {$whr_cat} AND {$whr_ext}");
     list($numrows) = $xoopsDB->fetchRow($result);
     if ($numrows < 1) {
         return $block;
     }
     if ($numrows <= $photos_num) {
         $result = $xoopsDB->query("SELECT l.lid , l.cid , l.title , l.ext , l.res_x , l.res_y , l.submitter , l.status , l.date AS unixtime , l.hits , l.rating , l.votes , l.comments , c.title AS cat_title FROM {$table_photos} l LEFT JOIN {$table_cat} c ON l.cid=c.cid WHERE l.status>0 AND {$whr_cat} AND {$whr_ext}");
     } else {
         $result = $xoopsDB->query("SELECT l.lid FROM {$table_photos} l WHERE l.status>0 AND {$whr_cat} AND {$whr_ext}");
         $lids = array();
         $sel_lids = array();
         while (list($lid) = $xoopsDB->fetchRow($result)) {
             $lids[] = $lid;
         }
         srand(intval(time() / $cycle) * $cycle);
         $sel_lids = array_rand($lids, $photos_num);
         if (is_array($sel_lids)) {
             $whr_lid = '';
             foreach ($sel_lids as $key) {
                 $whr_lid .= $lids[$key] . ",";
             }
             $whr_lid = substr($whr_lid, 0, -1);
         } else {
             $whr_lid = $lids[$sel_lids];
         }
         $result = $xoopsDB->query("SELECT l.lid , l.cid , l.title , l.ext , l.res_x , l.res_y , l.submitter , l.status , l.date AS unixtime , l.hits , l.rating , l.votes , l.comments , c.title AS cat_title FROM {$table_photos} l LEFT JOIN {$table_cat} c ON l.cid=c.cid WHERE l.status>0 AND l.lid IN ({$whr_lid})");
     }
     $count = 1;
     while ($photo = $xoopsDB->fetchArray($result)) {
         $photo['title'] = $myts->makeTboxData4Show($photo['title']);
         $photo['cat_title'] = $myts->makeTboxData4Show($photo['cat_title']);
         $photo['suffix'] = $photo['hits'] > 1 ? 'hits' : 'hit';
         $photo['date'] = formatTimestamp($photo['unixtime'], 's');
         $photo['thumbs_url'] = $thumbs_url;
         if (in_array(strtolower($photo['ext']), $myalbum_normal_exts)) {
             // width&height attirbs for <img>
             if ($box_size <= 0) {
                 $photo['img_attribs'] = "";
             } else {
                 list($width, $height, $type) = getimagesize("{$thumbs_dir}/{$photo['lid']}.{$photo['ext']}");
                 if ($width > $box_size || $height > $box_size) {
                     if ($width > $height) {
                         $photo['img_attribs'] = "width='{$box_size}'";
                     } else {
                         $photo['img_attribs'] = "height='{$box_size}'";
                     }
                 } else {
                     $photo['img_attribs'] = "";
                 }
             }
         } else {
             $photo['ext'] = 'gif';
             $photo['img_attribs'] = '';
         }
         $block['photo'][$count++] = $photo;
     }
     $block['mod_url'] = $mod_url;
     $block['cols'] = $cols;
     return $block;
 }

$xoopsTpl->assign('lang_sortby', $sort);
$xoopsTpl->assign('lang_rank', _MD_RANK);
$xoopsTpl->assign('lang_title', _MD_TITLE);
$xoopsTpl->assign('lang_category', _MD_CATEGORY);
$xoopsTpl->assign('lang_hits', _MD_HITS);
$xoopsTpl->assign('lang_rating', _MD_RATING);
$xoopsTpl->assign('lang_vote', _MD_VOTE);
$arr = array();
$result = $xoopsDB->query("select cid, title from " . $xoopsDB->prefix("mylinks_cat") . " where pid=0");
$e = 0;
$rankings = array();
while (list($cid, $ctitle) = $xoopsDB->fetchRow($result)) {
    $rankings[$e]['title'] = sprintf(_MD_TOP10, $myts->htmlSpecialChars($ctitle));
    $query = "select lid, cid, title, hits, rating, votes from " . $xoopsDB->prefix("mylinks_links") . " where status>0 and (cid={$cid}";
    // get all child cat ids for a given cat id
    $arr = $mytree->getAllChildId($cid);
    $size = count($arr);
    for ($i = 0; $i < $size; $i++) {
        $query .= " or cid=" . $arr[$i] . "";
    }
    $query .= ") order by " . $sortDB . " DESC";
    $result2 = $xoopsDB->query($query, 10, 0);
    $rank = 1;
    while (list($lid, $lcid, $ltitle, $hits, $rating, $votes) = $xoopsDB->fetchRow($result2)) {
        $catpath = $mytree->getPathFromId($lcid, "title");
        $catpath = substr($catpath, 1);
        $catpath = str_replace("/", " <span class='fg2'>&raquo;</span> ", $catpath);
        $rankings[$e]['links'][] = array('id' => $lid, 'cid' => $cid, 'rank' => $rank, 'title' => $myts->htmlSpecialChars($ltitle), 'category' => $catpath, 'hits' => $hits, 'rating' => number_format($rating, 2), 'votes' => $votes);
        $rank++;
    }
    $e++;

 // Ticket Check
 if (!$xoopsGTicket->check()) {
     redirect_header(XOOPS_URL . '/', 3, $xoopsGTicket->getErrors());
 }
 // Delete
 $cid = intval($_POST['delcat']);
 // Category2Group permission の削除 (2.0.3 以前でもうまく動くように)
 // xoops_groupperm_deletebymoditem( $xoopsModule->mid() , 'pical_cat' , $cid ) ;
 $criteria = new CriteriaCompo(new Criteria('gperm_modid', $xoopsModule->mid()));
 $criteria->add(new Criteria('gperm_name', 'pical_cat'));
 $criteria->add(new Criteria('gperm_itemid', intval($cid)));
 $gperm_handler->deleteAll($criteria);
 // Category Notify の削除
 // (必要であれば該当イベント削除の機能も)
 // 対象カテゴリーの子供をWHERE節に追加し、Cat2Group Permissionを削除
 $children = $cattree->getAllChildId($cid);
 $whr = "cid IN (";
 foreach ($children as $child) {
     // WHERE節への追加
     $whr .= "{$child},";
     // Category2Group permission の削除 (2.0.3 以前でもうまく動くように)
     // xoops_groupperm_deletebymoditem( $xoopsModule->mid() , 'pical_cat' , $child ) ;
     $criteria = new CriteriaCompo(new Criteria('gperm_modid', $xoopsModule->mid()));
     $criteria->add(new Criteria('gperm_name', 'pical_cat'));
     $criteria->add(new Criteria('gperm_itemid', intval($child)));
     $gperm_handler->deleteAll($criteria);
 }
 $whr .= "{$cid})";
 // catテーブルからの削除
 if (!mysql_query("DELETE FROM {$cal->cat_table} WHERE {$whr}", $conn)) {
     die(mysql_error());

 function itemsCount($inSubCat = 0, $status = '')
 {
     global $xoopsUser;
     include_once XOOPS_ROOT_PATH . '/modules/smartsection/include/functions.php';
     $hModule =& xoops_gethandler('module');
     $smartModule =& $hModule->getByDirname('smartsection');
     $module_id = $smartModule->getVar('mid');
     $gperm_handler =& xoops_gethandler('groupperm');
     $groups = $xoopsUser ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
     $userIsAdmin = ss_userIsAdmin();
     if (!$userIsAdmin) {
         $itemsGranted = $gperm_handler->getItemIds('item_read', $groups, $module_id);
         $grantedItem = new Criteria('itemid', "(" . implode(',', $itemsGranted) . ")", 'IN');
     }
     $criteriaCategory = new criteria('categoryid', $this->categoryid());
     $criteriaStatus = new CriteriaCompo();
     if (!empty($status) && is_array($status)) {
         foreach ($status as $v) {
             $criteriaStatus->add(new Criteria('status', $v), 'OR');
         }
     } elseif (!empty($status) && $status != -1) {
         $criteriaStatus->add(new Criteria('status', $status), 'OR');
     }
     $criteria = new CriteriaCompo();
     $criteria->add($criteriaCategory);
     if (!$userIsAdmin) {
         $criteria->add($grantedItem);
     }
     $criteria->add($criteriaStatus);
     global $smartsection_item_handler;
     $count = $smartsection_item_handler->getCount($criteria);
     unset($criteria);
     if ($inSubCat) {
         include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
         $mytree = new XoopsTree($this->db->prefix("smartsection_categories"), "categoryid", "parentid");
         $subCats = $mytree->getAllChildId($this->categoryid());
         foreach ($subCats as $key => $value) {
             $categoryid = $value['categoryid'];
             // TODO : If I could just go through the CriteriaCompo to only change the categoryCriteria...
             $criteriaCategory = new criteria('categoryid', $categoryid);
             $criteria = new CriteriaCompo();
             $criteria->add($criteriaCategory);
             if (!$userIsAdmin) {
                 $criteria->add($grantedItem);
             }
             $criteria->add($criteriaStatus);
             $count = $count + $smartsection_item_handler->getCount($criteria);
             unset($criteria);
         }
     }
     return $count;
 }

    if ($cid == intval($_POST['pid'])) {
        $xoopsDB->query("UPDATE {$table_cat} SET pid='0' WHERE cid='{$cid}'");
    }
    redirect_header("index.php", 1, _AM_CAT_INSERTED);
    exit;
} else {
    if ($action == "update" && !empty($_POST['cid'])) {
        // anti-CSRF (Double Check)
        if (!xoops_refcheck()) {
            die("XOOPS_URL is not included in your REFERER");
        }
        $cid = intval($_POST['cid']);
        $pid = intval($_POST['pid']);
        // Check if new pid was a child of cid
        if ($pid != 0) {
            $children = $cattree->getAllChildId($cid);
            $children[] = $cid;
            foreach ($children as $child) {
                if ($child == $pid) {
                    die("category looping has occurred");
                }
            }
        }
        // update
        $sql = "UPDATE {$table_cat} SET ";
        $cols = array("pid" => "I:N:0", "title" => "50:E:1", "imgurl" => "150:E:0");
        $sql .= mysql_get_sql_set($cols) . " WHERE cid='{$cid}'";
        $xoopsDB->query($sql) or die("DB Error: update category");
        redirect_header("index.php", 1, _AM_CAT_UPDATED);
        exit;
    } else {

 function b_myalbum_tophits_show($options)
 {
     global $xoopsDB;
     // For myAlbum-P < 2.70
     if (strncmp($options[0], 'myalbum', 7) != 0) {
         $title_max_length = intval($options[1]);
         $photos_num = intval($options[0]);
         $mydirname = 'myalbum';
     } else {
         $title_max_length = intval($options[2]);
         $photos_num = intval($options[1]);
         $mydirname = $options[0];
     }
     $cat_limitation = empty($options[3]) ? 0 : intval($options[3]);
     $cat_limit_recursive = empty($options[4]) ? 0 : 1;
     $cols = empty($options[6]) ? 1 : intval($options[6]);
     include XOOPS_ROOT_PATH . "/modules/{$mydirname}/include/read_configs.php";
     // Category limitation
     if ($cat_limitation) {
         if ($cat_limit_recursive) {
             include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
             $cattree = new XoopsTree($table_cat, "cid", "pid");
             $children = $cattree->getAllChildId($cat_limitation);
             $whr_cat = "cid IN (";
             foreach ($children as $child) {
                 $whr_cat .= "{$child},";
             }
             $whr_cat .= "{$cat_limitation})";
         } else {
             $whr_cat = "cid='{$cat_limitation}'";
         }
     } else {
         $whr_cat = '1';
     }
     $block = array();
     $myts =& MyTextSanitizer::getInstance();
     $result = $xoopsDB->query("SELECT lid , cid , title , ext , res_x , res_y , submitter , status , date AS unixtime , hits , rating , votes , comments FROM {$table_photos} WHERE status>0 AND {$whr_cat} ORDER BY hits DESC", $photos_num, 0);
     $count = 1;
     while ($photo = $xoopsDB->fetchArray($result)) {
         $photo['title'] = $myts->makeTboxData4Show($photo['title']);
         if (strlen($photo['title']) >= $title_max_length) {
             if (!XOOPS_USE_MULTIBYTES) {
                 $photo['title'] = substr($photo['title'], 0, $title_max_length - 1) . "...";
             } else {
                 if (function_exists('mb_strcut')) {
                     $photo['title'] = mb_strcut($photo['title'], 0, $title_max_length - 1) . "...";
                 }
             }
         }
         $photo['suffix'] = $photo['hits'] > 1 ? 'hits' : 'hit';
         $photo['date'] = formatTimestamp($photo['unixtime'], 's');
         $photo['thumbs_url'] = $thumbs_url;
         if (in_array(strtolower($photo['ext']), $myalbum_normal_exts)) {
             $width_spec = "width='{$myalbum_thumbsize}'";
             if ($myalbum_makethumb) {
                 list($width, $height, $type) = getimagesize("{$thumbs_dir}/{$photo['lid']}.{$photo['ext']}");
                 if ($width <= $myalbum_thumbsize) {
                     // if thumb images was made, 'width' and 'height' will not set.
                     $width_spec = '';
                 }
             }
             $photo['width_spec'] = $width_spec;
         } else {
             $photo['ext'] = 'gif';
             $photo['width_spec'] = '';
         }
         $block['photo'][$count++] = $photo;
     }
     $block['mod_url'] = $mod_url;
     $block['cols'] = $cols;
     return $block;
 }

function pico_updatecategory($mydirname, $cat_id)
{
    $db =& Database::getInstance();
    $requests = pico_get_requests4category($mydirname, $cat_id);
    $set = '';
    foreach ($requests as $key => $val) {
        if ($key == 'cat_vpath' && empty($val)) {
            $set .= "`{$key}`=null,";
        } else {
            $set .= "`{$key}`='" . mysql_real_escape_string($val) . "',";
        }
    }
    // get children
    include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
    $mytree = new XoopsTree($db->prefix($mydirname . "_categories"), "cat_id", "pid");
    $children = $mytree->getAllChildId($cat_id);
    $children[] = $cat_id;
    // loop check
    if (in_array($requests['pid'], $children)) {
        die(_MD_PICO_ERR_PIDLOOP);
    }
    if (!$db->queryF("UPDATE " . $db->prefix($mydirname . "_categories") . " SET " . substr($set, 0, -1) . " WHERE cat_id={$cat_id}")) {
        die(_MD_PICO_ERR_DUPLICATEDVPATH);
    }
    // rebuild category tree
    pico_sync_cattree($mydirname);
    return $cat_id;
}

function b_bulletin_category_new_show($options)
{
    $mydirname = $options[0];
    if (preg_match('/[^0-9a-zA-Z_-]/', $mydirname)) {
        die('Invalid mydirname');
    }
    $selected_order = empty($options[1]) || !in_array($options[1], b_bulletin_category_new_allowed_order()) ? 'published DESC' : $options[1];
    require dirname(dirname(__FILE__)) . '/include/configs.inc.php';
    require_once XOOPS_ROOT_PATH . '/class/xoopstree.php';
    $mytree = new XoopsTree($table_topics, 'topic_id', 'topic_pid');
    $arr = array();
    // ルートカテゴリを得るクエリ
    if (empty($options[4])) {
        // 全ルートカテゴリを得る
        $result = $xoopsDB->query("SELECT topic_id, topic_title, topic_imgurl FROM {$table_topics} WHERE topic_pid=0 ORDER BY topic_title");
    } else {
        // 指定カテゴリのみ
        $result = $xoopsDB->query("SELECT topic_id, topic_title, topic_imgurl FROM {$table_topics} WHERE topic_id=" . $options[4]);
    }
    $block = array();
    while (list($topic_id, $topic_title, $topic_imgurl) = $xoopsDB->fetchRow($result)) {
        $topic = array();
        $topic['title'] = $myts->makeTboxData4Show($topic_title);
        $topic['id'] = $topic_id;
        // トピック画像をセット
        if ($topic_imgurl != '' && file_exists($bulletin_topicon_path . $topic_imgurl) && $options[6]) {
            $topic['topic_url'] = str_replace(XOOPS_ROOT_PATH, XOOPS_URL, $bulletin_topicon_path) . $topic_imgurl;
        }
        $where = sprintf("s.type > 0 AND s.published < %u AND s.published > 0 AND (s.expired = 0 OR s.expired > %1\$u) AND s.block = 1 AND (s.topicid=%u", time(), $topic_id);
        // 子ディレクトリを対象に含める
        $arr = $mytree->getAllChildId($topic_id);
        $size = count($arr);
        for ($i = 0; $i < $size; $i++) {
            $where .= " OR s.topicid=" . $arr[$i];
        }
        $where .= ")";
        $order = "ORDER BY {$selected_order}";
        // more をセット
        $sql = sprintf('SELECT COUNT(*) FROM %s s WHERE %s', $table_stories, $where);
        list($count) = $xoopsDB->fetchRow($xoopsDB->query($sql));
        if ($count > $options[2]) {
            $topic['morelink'] = 1;
        }
        // 本文を表示する
        if ($options[5] > 0) {
            $sql = sprintf('SELECT s.storyid, s.topicid, s.title, s.hometext, s.bodytext, s.published, s.expired, s.counter, s.comments, s.uid, s.topicimg, s.html, s.smiley, s.br, s.xcode, t.topic_title, t. topic_imgurl FROM %s s, %s t WHERE %s AND s.topicid = t.topic_id %s', $table_stories, $table_topics, $where, $order);
            $result2 = $xoopsDB->query($sql, $options[5], 0);
            while ($myrow = $xoopsDB->fetchArray($result2)) {
                $fullstory = array();
                // GIJ
                $fullstory['id'] = $myrow['storyid'];
                $fullstory['posttime'] = formatTimestamp($myrow['published'], $bulletin_date_format);
                $fullstory['date'] = formatTimestamp($myrow['published'], $bulletin_date_format);
                $fullstory['published'] = intval($myrow['published']);
                $fullstory['topicid'] = $myrow['topicid'];
                $fullstory['topic'] = $myts->makeTboxData4Show($myrow['topic_title']);
                $fullstory['title'] = $myts->makeTboxData4Show($myrow['title']);
                $fullstory['text'] = $myts->displayTarea($myrow['hometext'], $myrow['html'], $myrow['smiley'], $myrow['xcode'], 1, $myrow['br']);
                $fullstory['hits'] = $myrow['counter'];
                $fullstory['title_link'] = true;
                //ユーザ情報をアサイン
                $fullstory['uid'] = $myrow['uid'];
                $fullstory['uname'] = XoopsUser::getUnameFromId($myrow['uid']);
                $fullstory['realname'] = XoopsUser::getUnameFromId($myrow['uid'], 1);
                $fullstory['morelink'] = '';
                // 文字数カウント処理
                if (myStrlenText($myrow['bodytext']) > 1) {
                    $fullstory['bytes'] = sprintf(_MB_BULLETIN_BYTESMORE, myStrlenText($myrow['bodytext']));
                    $fullstory['readmore'] = true;
                } else {
                    $fullstory['bytes'] = 0;
                    $fullstory['readmore'] = false;
                }
                // コメントの数をアサイン
                $ccount = $myrow['comments'];
                if ($ccount == 0) {
                    $fullstory['comentstotal'] = _MB_BULLETIN_COMMENTS;
                } elseif ($ccount == 1) {
                    $fullstory['comentstotal'] = _MB_BULLETIN_ONECOMMENT;
                } else {
                    $fullstory['comentstotal'] = sprintf(_MB_BULLETIN_NUMCOMMENTS, $ccount);
                }
                // 管理者用のリンク
                $fullstory['adminlink'] = 0;
                // トピック画像
                if ($myrow['topicimg']) {
                    $fullstory['topic_url'] = makeTopicImgURL($bulletin_topicon_path, $myrow['topic_imgurl']);
                    $fullstory['align'] = topicImgAlign($myrow['topicimg']);
                }
                $topic['fullstories'][] = $fullstory;
            }
        }
        if ($options[2] - $options[5] > 0) {
            $sql = sprintf('SELECT s.storyid, s.title, s.published, s.expired, s.counter, s.uid FROM %s s WHERE %s %s', $table_stories, $where, $order);
            $result3 = $xoopsDB->query($sql, $options[2] - $options[5], $options[5]);
            while ($myrow = $xoopsDB->fetchArray($result3)) {
                // マルチバイト環境に対応
                $story['title'] = $myts->makeTboxData4Show(xoops_substr($myrow['title'], 0, $options[3] + 3, '...'));
                $story['id'] = $myrow['storyid'];
                $story['date'] = formatTimestamp($myrow['published'], $bulletin_date_format);
//.........这里部分代码省略.........

foreach (array("cat_description", "cat_template", "cat_entry", "cat_sponsor") as $tag) {
    if (@$_POST[$tag] != $category->getVar($tag)) {
        $category->setVar($tag, $_POST[$tag]);
    }
}
if (art_isAdministrator()) {
    foreach (array("cat_title", "cat_order") as $tag) {
        if ($_POST[$tag] != $category->getVar($tag)) {
            $category->setVar($tag, $_POST[$tag]);
        }
    }
    $cat_pid = @$_POST["cat_pid"];
    if ($cat_pid != $category->getVar("cat_pid") && $cat_pid != $category->getVar("cat_id")) {
        require_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
        $mytree = new XoopsTree(art_DB_prefix("category"), "cat_id", "cat_pid");
        $idarray = $mytree->getAllChildId($category->getVar("cat_id"));
        if (!in_array($cat_pid, $idarray)) {
            $category->setVar("cat_pid", $cat_pid);
        }
    }
    $category->setVar("cat_moderator", empty($_POST["cat_moderator"]) ? array() : $_POST["cat_moderator"]);
}
$error_upload = "";
$cat_image = "";
if (!empty($_FILES['userfile']['name'])) {
    $uploader = new art_uploader(XOOPS_ROOT_PATH . "/" . $xoopsModuleConfig['path_image']);
    if ($uploader->fetchMedia($_POST['xoops_upload_file'][0])) {
        if (!$uploader->upload()) {
            $error_upload = $uploader->getErrors();
        } elseif (file_exists($uploader->getSavedDestination())) {
            $cat_image = $uploader->getSavedFileName();

<?php

include dirname(dirname(__FILE__)) . '/include/common_prepend.php';
require_once dirname(dirname(__FILE__)) . '/class/gtickets.php';
$cat_id = intval(@$_GET['cat_id']);
// get&check this category ($category4assign, $category_row), override options
if (!(include dirname(dirname(__FILE__)) . '/include/process_this_category.inc.php')) {
    die(_MD_D3FORUM_ERR_READCATEGORY);
}
// count children
include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
$mytree = new XoopsTree($db->prefix($mydirname . "_categories"), "cat_id", "pid");
$children = $mytree->getAllChildId($cat_id);
// special check for categorymanager
if (!$isadmin) {
    die(_MD_D3FORUM_ERR_CREATECATEGORY);
}
// TRANSACTION PART
require_once dirname(dirname(__FILE__)) . '/include/transact_functions.php';
if (isset($_POST['categoryman_post'])) {
    if (!$xoopsGTicket->check(true, 'd3forum')) {
        redirect_header(XOOPS_URL . '/', 3, $xoopsGTicket->getErrors());
    }
    d3forum_updatecategory($mydirname, $cat_id);
    if (!empty($_POST['batch_action_turnsolvedon'])) {
        d3forum_transact_turnsolvedon_in_category($mydirname, $cat_id);
    }
    redirect_header(XOOPS_URL . "/modules/{$mydirname}/index.php?cat_id={$cat_id}", 2, _MD_D3FORUM_MSG_CATEGORYUPDATED);
    exit;
}
if (isset($_POST['categoryman_delete']) && count($children) == 0) {

function b_bulletin_category_new_show($options) {

	$mydirname = empty( $options[0] ) ? basename( dirname( dirname( __FILE__ ) ) ) : $options[0] ;
	if( preg_match( '/[^0-9a-zA-Z_-]/' , $mydirname ) ) die( 'Invalid mydirname' ) ;
	$selected_order = empty( $options[1] ) || ! in_array( $options[1] , b_bulletin_category_new_allowed_order() ) ? 'published DESC' : $options[1] ;
	$display_count = empty($options[2]) ? 0 :intval($options[2]);//Number display for each category
	$Length_title = empty($options[3]) ? 255 :intval($options[3]);//Length of the title
	$categories = empty($options[4]) ? 0 : array_map( 'intval' , explode( ',' , $options[4] ) ) ;//(0=show all)
	$show_body = empty($options[5]) ? 0 :intval($options[5]);//Number of articles showing body for each category
	$show_category_icon = empty($options[6]) ? 0 :intval($options[6]);//(yes or no) ,Display category icon
//ver3.0 fix
	if ($show_body > $display_count){
		$show_body = $display_count;
	}

	require dirname( dirname( __FILE__ ) ).'/include/configs.inc.php';
	require_once XOOPS_ROOT_PATH.'/class/xoopstree.php';
	require_once dirname(dirname(__FILE__)).'/class/bulletingp.php' ;

	$mytree = new XoopsTree($table_topics,'topic_id','topic_pid');

	$arr = array();
//ver3.0 can_read access
	$gperm =& BulletinGP::getInstance($mydirname) ;
	$can_read_topic_ids = $gperm->makeOnTopics('can_read');
	if (empty($can_read_topic_ids)){
		return false;
	}

	// Query to get the root category
		$sql_topics = "SELECT topic_id, topic_title, topic_imgurl";
		$sql_topics .= " FROM ".$xoopsDB->prefix($mydirname."_topics") ;
	if( empty($categories) ){
		// Get categories all from route
		$sql_topics .= " WHERE topic_pid=0";
		$sql_topics .= " AND topic_id IN (".implode(",",$can_read_topic_ids).")";
		$sql_topics .= " ORDER BY topic_title";
	}else{
		// when category
		$sql_topics .= " WHERE topic_id IN (".implode(",",$categories).")";
		$sql_topics .= " AND topic_id IN (".implode(",",$can_read_topic_ids).")";
	}
	$result = $xoopsDB->query($sql_topics);
	$topics_count = $xoopsDB->getRowsNum($result);
	if (empty($topics_count)){
		return false;
	}

	$block = array();

	while( list($topic_id, $topic_title, $topic_imgurl) = $xoopsDB->fetchRow($result) ){
		$topic = array();
		$topic['title'] = $myts->makeTboxData4Show($topic_title);
		$topic['id'] = $topic_id;

		// Set the image topic
		if ($topic_imgurl != '' && file_exists($bulletin_topicon_path.$topic_imgurl) && $show_category_icon) {
			$topic['topic_url'] = str_replace(XOOPS_ROOT_PATH,XOOPS_URL,$bulletin_topicon_path).$topic_imgurl;
			$topic['show_category_icon'] = 1;
		}else{
			$topic['show_category_icon'] = 0;
		}

		$where = sprintf("s.published < %u AND s.published > 0 AND (s.expired = 0 OR s.expired > %1\$u) AND s.block = 1 AND (s.topicid=%u", time(), $topic_id);
		if (!$gperm->group_perm(2)){
			$where .= " AND s.type > 0";
		}

		// View the directory to include children categorys
		$arr = $mytree->getAllChildId($topic_id);
		$size = count($arr);
		for($i=0;$i<$size;$i++){
			$where .= " OR s.topicid=".$arr[$i];
		}
		$where .= ")";
//ver3.0 can_read access
		$where .= " AND s.topicid IN (".implode(',',$can_read_topic_ids).")";

		// see more... for topics
		$sql = sprintf("SELECT COUNT(*) FROM %s s WHERE %s", $xoopsDB->prefix($mydirname."_stories"), $where);
		list($count) = $xoopsDB->fetchRow($xoopsDB->query($sql));
		if($count>$display_count){
			$topic['morelink'] = 1;
		}
		$topic['lang_morelink'] = _MORE;

//ver3.0
		$sql = "SELECT s.*, t.topic_pid, t.topic_imgurl, t.topic_title, t.topic_created, t.topic_modified";
		$sql .= " FROM " . $xoopsDB->prefix($mydirname."_stories") . " s, " . $xoopsDB->prefix($mydirname."_topics") . " t";
		$sql .= " WHERE " . $where . " AND s.topicid = t.topic_id";
		$sql .= " ORDER BY $selected_order";

		// Show body
		if($show_body > 0){

//ver2.0	$sql  = sprintf('SELECT s.storyid, s.topicid, s.title, s.hometext, s.bodytext, s.published, s.expired, s.counter, s.comments, s.uid, s.topicimg, s.html, s.smiley, s.br, s.xcode, t.topic_title, t. topic_imgurl FROM %s s, %s t WHERE %s AND s.topicid = t.topic_id %s', $table_stories, $table_topics, $where, $order);

			$result2 = $xoopsDB->query($sql,$show_body,0);

			while ( $myrow = $xoopsDB->fetchArray($result2) ) {
//.........这里部分代码省略.........

 /**
  * @return array
  */
 public function getAllChildTopicsId()
 {
     $xt = new XoopsTree($this->table, 'topic_id', 'topic_pid');
     $ret = $xt->getAllChildId($this->topic_id, 'topic_title');
     return $ret;
 }