Ejemplo n.º 1
0
function sub_search($id, $forum_sub, $forum_sub2)
{
    if (count($forum_sub[$id]) > 0) {
        $list = "";
        for ($jj = 0; $jj < count($forum_sub[$id]); $jj++) {
            $list .= $forum_sub[$id][$jj];
            $list .= sub_search($forum_sub2[$id][$jj], $forum_sub, $forum_sub2);
        }
    }
    return $list;
}
Ejemplo n.º 2
0
function get_sub_list($id)
{
    global $db;
    $sql = "select cat_id,cat_title from " . CATEGORIES_TABLE . " order by cat_order  ";
    if (!($result = $db->sql_query($sql))) {
        message_die(GENERAL_ERROR, "Couldn't get list of Categories/Forums", "", __LINE__, __FILE__, $sql);
    }
    $cat_data = array();
    while ($row = $db->sql_fetchrow($result)) {
        $cat_data[] = $row;
    }
    $db->sql_freeresult($result);
    $sql = "SELECT cat_id,forum_id,forum_name,sort_sub,forum_sub,main_sub from " . FORUMS_TABLE . "  ORDER BY cat_id,forum_order";
    if (!($result = $db->sql_query($sql))) {
        message_die(GENERAL_ERROR, "Couldn't get list of Categories/Forums", "", __LINE__, __FILE__, $sql);
    }
    $forum_data = array();
    $forum_sub = array();
    $forum_sub2 = array();
    while ($row = $db->sql_fetchrow($result)) {
        $s = "";
        if ($row[forum_sub] == 0) {
            $forum_data[$row['cat_id']][] = $row;
        } else {
            if ($row[forum_id] == $id) {
                $s = " selected=\"selected\"";
            }
            $forum_sub[$row['forum_sub']][] = "add_select('" . $row[cat_id] . "," . $row[forum_id] . "," . $row[sort_sub] . "," . $row[main_sub] . "','" . str_replace("'", "\\'", $row[forum_name]) . "','{$s}'," . ($row[sort_sub] + 1) . ");";
            $forum_sub2[$row['forum_sub']][] = $row[forum_id];
        }
    }
    $db->sql_freeresult($result);
    $sub_list = "";
    for ($i = 0; $i < count($cat_data); $i++) {
        $s = "";
        $cat_id = $cat_data[$i][cat_id];
        $sub_list .= "add_select('" . $cat_id . ",0,0,0','" . str_replace("'", "\\'", $cat_data[$i][cat_title]) . "','{$s}',0);";
        for ($j = 0; $j < count($forum_data[$cat_id]); $j++) {
            $s = "";
            if ($forum_data[$cat_id][$j][forum_id] == $id) {
                $s = " selected=\"selected\"";
            }
            $sub_list .= "add_select('" . $forum_data[$cat_id][$j][cat_id] . "," . $forum_data[$cat_id][$j][forum_id] . "," . $forum_data[$cat_id][$j][sort_sub] . "," . $forum_data[$cat_id][$j][forum_id] . "','" . str_replace("'", "\\'", $forum_data[$cat_id][$j][forum_name]) . "','{$s}'," . ($forum_data[$cat_id][$j][sort_sub] + 1) . ");";
            if (count($forum_sub[$forum_data[$cat_id][$j][forum_id]]) > 0) {
                for ($jj = 0; $jj < count($forum_sub[$forum_data[$cat_id][$j][forum_id]]); $jj++) {
                    $sub_list .= $forum_sub[$forum_data[$cat_id][$j][forum_id]][$jj];
                    $sub_list .= sub_search($forum_sub2[$forum_data[$cat_id][$j][forum_id]][$jj], $forum_sub, $forum_sub2);
                }
            }
        }
    }
    return $sub_list;
}