function catGetMenuCategoryList($cats)
{
$arr = array();
$cats_tree = array();
foreach ($cats as $cat => $val) {
$level = (int) $val['level'];
$parentID = (int) $val['parent'];
$categoryID = (int) $val['categoryID'];
$subcount = (int) $val['subcount'];
// $uri = (int) $val['uri'];
if ($level === 0) {
$arr[$categoryID] = $val;
}
if ($level === 1) {
if ($subcount > 0) {
$val['sub'] = get_sub_cat($cats, $categoryID, 2);
}
$arr[$parentID]['sub'][] = $val;
}
}
foreach ($arr as $cat => $val) {
$cats_tree[] = $val;
}
return $cats_tree;
}
function ssm_list_categories($number)
{
global $wpdb, $options;
$options = get_option('ssMenu_widget_options');
extract($options[$number]);
// check for exclusion or inclusion of categories
$inExclusions = array();
//echo 'the inExclude : '.$inExclude.'.<br />';
//echo 'the inExcludeCats : '.$inExcludeCats.'.<br />';
if (!empty($inExclude) && !empty($inExcludeCats)) {
$exterms = preg_split('/[,]+/', $inExcludeCats);
if ($inExclude == 'include') {
$in = 'IN';
} else {
$in = 'NOT IN';
}
if (count($exterms)) {
foreach ($exterms as $exterm) {
if (empty($inExclusions)) {
$inExclusions = "'" . sanitize_title($exterm) . "'";
} else {
$inExclusions .= ", '" . sanitize_title($exterm) . "' ";
}
}
}
}
//echo 'the inExclusions : '.$inExclusions.'.<br />';
$isPage = '';
if (!$showPages) {
$isPage = "AND {$wpdb->posts}.post_type='post'";
}
if (empty($inExclusions)) {
$inExcludeQuery = "''";
} else {
$inExcludeQuery = "AND {$wpdb->terms}.term_id {$in} ({$inExclusions})";
}
if ($catSort == 'catName') {
$catSortColumn = "ORDER BY {$wpdb->terms}.name";
} elseif ($catSort == 'catId') {
$catSortColumn = "ORDER BY {$wpdb->terms}.term_id";
} elseif ($catSort == 'catSlug') {
$catSortColumn = "ORDER BY {$wpdb->terms}.slug";
} elseif ($catSort == 'catOrder') {
$catSortColumn = "ORDER BY {$wpdb->terms}.term_order";
} elseif ($catSort == 'catCount') {
$catSortColumn = "ORDER BY {$wpdb->term_taxonomy}.count";
}
if ($postSort == 'postDate') {
$postSortColumn = "ORDER BY {$wpdb->posts}.post_date";
} elseif ($postSort == 'postId') {
$postSortColumn = "ORDER BY {$wpdb->posts}.id";
} elseif ($postSort == 'postTitle') {
$postSortColumn = "ORDER BY {$wpdb->posts}.post_title";
} elseif ($postSort == 'postComment') {
$postSortColumn = "ORDER BY {$wpdb->posts}.comment_count";
}
$catquery = "SELECT {$wpdb->term_taxonomy}.count as 'count',\n\t\t\t{$wpdb->terms}.term_id, {$wpdb->terms}.name, {$wpdb->terms}.slug,\n\t\t\t{$wpdb->term_taxonomy}.parent, {$wpdb->term_taxonomy}.description FROM\n\t\t\t{$wpdb->terms}, {$wpdb->term_taxonomy} WHERE {$wpdb->terms}.term_id =\n\t\t\t{$wpdb->term_taxonomy}.term_id AND {$wpdb->terms}.name != 'Blogroll' AND\n\t\t\t{$wpdb->term_taxonomy}.taxonomy = 'category' {$inExcludeQuery} {$catSortColumn}\n\t\t\t{$catSortOrder}";
$postquery = "SELECT {$wpdb->terms}.term_id, {$wpdb->terms}.name,\n\t\t\t{$wpdb->terms}.slug, {$wpdb->term_taxonomy}.count, {$wpdb->posts}.id,\n\t\t\t{$wpdb->posts}.post_title, {$wpdb->posts}.post_name,\n\t\t\tdate({$wpdb->posts}.post_date) as 'date' FROM {$wpdb->posts}, {$wpdb->terms},\n\t\t\t{$wpdb->term_taxonomy}, {$wpdb->term_relationships} WHERE {$wpdb->posts}.id =\n\t\t\t{$wpdb->term_relationships}.object_id AND {$wpdb->posts}.post_status='publish'\n\t\t\tAND {$wpdb->terms}.term_id = {$wpdb->term_taxonomy}.term_id AND\n\t\t\t{$wpdb->term_relationships}.term_taxonomy_id =\n\t\t\t{$wpdb->term_taxonomy}.term_taxonomy_id AND {$wpdb->term_taxonomy}.taxonomy =\n\t\t\t'category' {$isPage} {$postSortColumn} {$postSortOrder}";
/* changing to use only one query
* don't forget to exclude pages if so desired
*/
$categories = $wpdb->get_results($catquery);
$posts = $wpdb->get_results($postquery);
//echo 'the catquery is :<br />'.$catquery.'.<br />';
/*
echo 'the categories are :<br />';
var_dump($categories);
echo '___________________.<br />';
*/
$grandChildren = array();
$children = array();
$parents = array();
$grandParents = array();
$subCatPosts = array();
$mycats = $categories;
// let's remove any empty categories if showEmptyCat is set to no
foreach ($categories as $cat) {
if ($cat->count == 0 && $showEmptyCat == 'no') {
$key = array_search($cat, $categories);
unset($categories[$key]);
}
if ($cat->parent == '0') {
array_push($grandParents, $cat->term_id);
$key = array_search($cat, $categories);
unset($categories[$key]);
}
if ($cat->parent != '0') {
array_push($parents, $cat->term_id);
}
}
foreach ($categories as $cat) {
if (in_array($cat->parent, $parents)) {
array_push($children, $cat->term_id);
}
}
foreach ($categories as $cat) {
if (in_array($cat->parent, $children)) {
array_push($grandChildren, $cat->term_id);
}
}
$categories = $mycats;
// knock total number of posts to work with down to a max of 1000
$totalPostCount = count($posts);
if ($totalPostCount > 1000) {
$posts = array_slice($posts, 0, 1000);
}
// start the html structure
echo '<div id="ssMenuHolder"><div id="ssMenuList">';
foreach ($categories as $cat) {
if ($cat->parent == 0) {
$subCatPostCount = 0;
$subCatCount = 0;
$myposts = array();
$subCatPosts = array();
// get the sub cats and their posts
list($subCatLinks, $subCatCount, $subCatPostCount, $subCatPosts) = get_sub_cat($cat, $categories, $posts, $subCatCount, $subCatPostCount, $number, $grandParents, $parents, $children, $grandChildren);
//$cat, $categories, $posts, $subCatCount, $subCatPostCount, $number, $grandParents, $parents, $children, $grandChildren
$theCount = $cat->count + $subCatPostCount;
print "\n<div class='ssmToggleBar ssm_" . $cat->slug . "'><span class='subsym show_1'> </span>";
$link = make_cat_link($cat, $tipText, $useDescription);
if ($showPostCount == 'yes') {
$link .= ' <span class="postCount">(' . $theCount . ')</span>';
}
$link .= add_feedlink($catfeed, $cat) . '</div>';
print $link;
print '<div class="showme_1 ssm_' . $cat->slug . '"><div class="linkList">';
// Now print out the post info
if (!is_array($subCatPosts)) {
$subCatPosts = array();
}
foreach ($posts as $post) {
if ($post->term_id == $cat->term_id && !in_array($post->id, $subCatPosts)) {
array_push($myposts, $post);
}
}
$postsincat = count($myposts);
if ($postsincat > $limitPosts) {
$moreposts = 1;
}
$myposts = array_slice($myposts, 0, $limitPosts);
foreach ($myposts as $post) {
echo " <span class='ssMenuPost'><a href='" . get_permalink($post->id) . "'>" . strip_tags($post->post_title) . "</a></span>\n";
}
if ($moreposts == 1 && $showMorePosts == 'yes' && $postsincat > $limitPosts) {
echo '<span class="ssMenuPost ssMore"><a href="' . get_category_link($cat->term_id) . '">' . $moretext . ' ' . $cat->name . '</a></span>';
}
// list the sub cats and their posts
echo $subCatLinks;
if ($subCatCount = 1) {
echo "</div><!-- ending second level with sub cats -->\n ";
}
echo "</div><!-- ending first level category -->\n";
}
// end if theCount>0
}
echo "\n</div></div><!-- closeing the superslider-menu plugin -->\n";
}
function list_categories($posts, $categories, $parents, $options)
{
/* returns a list of categories, and optionally subcategories and posts,
which can be collapsed or expanded with javascript */
global $collapsCatItems, $wpdb, $options, $wp_query, $autoExpand, $postsToExclude, $totalCatPostCount, $thisCatID, $cur_terms, $thisPost, $wp_rewrite, $catlink, $postsInCat;
extract($options);
$cur_terms = array();
if (is_single()) {
$tmp_terms = wp_get_object_terms($wp_query->post->ID, $taxonomy);
foreach ($tmp_terms as $tmp_cat) {
$cur_terms[] = $tmp_cat->term_id;
}
$thisPost = $wp_query->post->ID;
foreach ($categories as $cat) {
if (!empty($cur_terms) && in_array($cat->term_id, $cur_terms)) {
checkCurrentCat($cat, $categories);
}
}
}
if (is_archive()) {
$thisCatID = $wp_query->get_queried_object_id();
$thisCat = get_term($thisCatID, $taxonomy);
checkCurrentCat($thisCat, $categories);
}
$catlink = $wp_rewrite->get_category_permastruct();
foreach ($categories as $cat) {
$totalCatPostCount = 0;
if ($inExclude == 'include' && !empty($includeCatArray)) {
if (!in_array($cat->term_id, $includeCatArray) && !in_array($cat->post_parent, $includeCatArray)) {
continue;
} else {
}
}
if ($cat->parent != 0) {
continue;
}
if (is_archive() && $cat->term_id == $thisCatID) {
$self = " self";
} else {
$self = "";
}
if (in_array($cat->slug, $autoExpand)) {
$parent = " parent";
} else {
$parent = "";
}
$rssLink = addFeedLink($catfeed, $cat);
$subCatPostCount = 0;
$subCatCount = 0;
list($subCatLinks, $subCatCount, $subCatPostCount) = get_sub_cat($cat, $categories, $parents, $posts, $subCatCount, $subCatPostCount, $expanded, 0);
list($subCatPostCount2, $posttext2) = getSubPosts($postsInCat[$cat->term_id], $cat, $showPosts, $theID);
$theCount = $subCatPostCount2 + $totalCatPostCount;
if ($theCount > 0 || $showEmptyCat) {
$expanded = 'none';
$theID = 'collapsCat-' . $cat->term_id . ":{$number}";
if ((in_array($cat->name, $autoExpand) || in_array($cat->slug, $autoExpand)) && $expandCatPost || $useCookies && $_COOKIE[$theID] == 1) {
$expanded = 'block';
}
if ($showPosts || $subCatPostCount > 0 || $showEmptyCat) {
if ($expanded == 'block') {
$show = 'collapse';
$symbol = $collapseSym;
} else {
$show = 'expand';
$symbol = $expandSym;
}
$span = " <li class='collapsing categories expandable" . $self . $parent . "'>" . "<span class='collapsing categories {$show}'>" . "<span class='sym'>{$symbol}</span>";
} else {
$span = " <li class='collapsing categories item" . $self . "'>";
}
$link = getCollapsCatLink($cat, $catlink);
if (empty($cat->description)) {
$link .= 'title="' . sprintf(__("View all posts filed under %s", 'collapsing-categories'), wp_specialchars(apply_filters('single_cat_title', $cat->name))) . '"';
} else {
$link .= 'title="' . wp_specialchars(apply_filters('description', $cat->description, $cat)) . '"';
}
$link .= '>';
if ($linkToCat == 'yes') {
$link .= apply_filters('single_cat_title', $cat->name) . '</a>';
if ($showPosts || $subCatPostCount > 0) {
$span .= '</span>';
}
} else {
if ($showPosts || $subCatPostCount > 0) {
$link .= apply_filters('single_cat_title', $cat->name) . '</a></span>';
} else {
// don't include the triangles if posts are not shown and there
// are no more subcategories
$link .= apply_filters('single_cat_title', $cat->name) . '</a>';
$span = " <li class='collapsing categories item'>";
}
}
// Now print out the post info
$posttext = '';
if (!empty($postsInCat[$cat->term_id])) {
list($subCatPostCount, $posttext) = getSubPosts($posts, $cat, $collapsCatItems, $showPosts);
}
if ($showPostCount) {
$link .= ' (' . $theCount . ')';
}
$link .= $rssLink;
if ($theCount < 1 && !$showEmptyCat) {
$link = '';
$span = '';
}
if ($showTopLevel) {
$collapsCatText .= $span . $link;
if ($subCatPostCount > 0 || $showPosts) {
$collapsCatText .= "\n <div id='{$theID}'" . " style=\"display:{$expanded}\">\n";
}
}
if ($showPosts) {
if ($subCatPostCount > 0 && $subCatLinks != '' && $addMisc) {
$posttext = miscPosts($cat, $catlink, $subCatPostCount2, $posttext);
}
}
/* we only actually add the posts if it is expanded. Otherwise we add
the posts dynamically to the dom from a javascript array
However, we can't have an empty ul, so we create one emtpy li here */
if ($postsBeforeCats) {
$text = $posttext . $subCatLinks;
} else {
$text = $subCatLinks . $posttext;
}
if ($theID != '' && !$collapsCatItems[$theID]) {
$collapsCatItems[$theID] = "<ul>{$text}</ul>";
}
if ($expanded != 'block' && $showTopLevel && $showPosts) {
$posttext = '';
}
if ($postsBeforeCats) {
$text = $posttext . $subCatLinks;
} else {
$text = $subCatLinks . $posttext;
}
if ($text != '') {
$collapsCatText .= "<ul>{$text}</ul>";
}
if ($showTopLevel) {
if ($subCatPostCount > 0 || $showPosts) {
$collapsCatText .= " </div>\n";
}
$collapsCatText .= " </li> <!-- ending category -->\n";
}
}
// end if theCount>0
}
return array($collapsCatText, $postsInCat);
}
<section class="search-ad" >
<!--<img src="images/web_protection-128.png" />-->
<br />
<div class="clear"></div>
<?php
if (isset($sub_cat_id)) {
$select_par = "SELECT parent_off,name,id FROM categories WHERE id='" . $sub_cat_id . "' order by name asc";
$run_par = mysql_query($select_par);
$fetch_par = mysql_fetch_array($run_par);
$parent_d = $fetch_par['parent_off'];
$name = ucfirst($fetch_par['name']);
$safid = get_sub_cat($sub_cat_id);
//$tipids=get_sub_cat();
$select_tips = "SELECT * FROM safity_tipds WHERE cat_id IN (" . $safid . ")";
$run_tips = mysql_query($select_tips);
$num_rows = mysql_num_rows($run_tips);
$fetch_tips = mysql_fetch_array($run_tips);
if ($num_rows > 0) {
?>
<div style="color:#FFF; font-size:16px; margin-bottom:15px;"><?php
echo $name . " " . "Safity Tips";
?>
</div>
function get_all_cat($fid)
{
global $db, $pre;
$query = $db->query("SELECT * FROM {$pre}sort WHERE fup=0");
while ($rs = $db->fetch_array($query)) {
$listdb[] = $rs;
}
foreach ($listdb as $key => $row) {
$curpid = get_parent_id($fid);
$pid = get_parent_id($row['fid']);
$ishighlight = $curpid == $pid ? 1 : 0;
$arr[$key] = array('pid' => $pid, 'fid' => $row['fid'], 'name' => $row['name'], 'sid' => get_sub_cat($row['fid']), 'ishighlight' => $ishighlight);
}
return $arr;
}
<div id="contant_area">
<?php
$df = 'main_cat_id';
$urlids = get_sub_cat($sub_cat_id);
function get_lan_lat($postcode = '')
{
$postcode = str_replace(" ", "+", $postcode);
$url = "http://maps.googleapis.com/maps/api/geocode/xml?address=" . $postcode . "+UK&sensor=false";
$result = simplexml_load_file($url);
if (!empty($result->result->geometry->location)) {
$lat = get_object_vars($result->result->geometry->location);
} else {
$lat = array(0, 0);
}
return $lat;
}
// end of function
function get_top($id)
{
do {
$query = mysql_query("select * from categories where id={$id}");
$rs = mysql_fetch_array($query);
$arr[] = $rs['id'] . '|' . $rs['name'] . '|' . $rs['cat_url'];
$id = $rs['parent_off'];
} while ($rs != 0);
krsort($arr);
// end($arr);
foreach ($arr as $key => $list) {
$ex = explode("|", $list);
$ex[0] . "<br>";
// get all the sub cats of current id
$ids = get_sub_cat($res1['id']);
// end of getting all sub cats
$sqlcount = "select count(id) from `postcode_location` WHERE main_cat_id IN (" . $ids . ")";
$rscount = mysql_query($sqlcount);
$rescount = mysql_fetch_array($rscount);
// end cout
echo '<li><a style="margin-left:10px;" href="test.php?url=' . $res1['cat_url'] . '">' . $res1['name'] . ' id = ' . $res1['id'] . '</a> (' . $rescount[0] . ') </li>';
}
echo '</ul></li>';
}
}
} else {
echo '<ul>';
foreach ($main as $key => $m) {
$ids = get_sub_cat($key);
$sqlcount = "select count(id) from `postcode_location` WHERE main_cat_id IN (" . $ids . ")";
$rscount = mysql_query($sqlcount);
$rescount = mysql_fetch_array($rscount);
echo '<li>' . $m . '(' . $rescount[0] . ') </li>';
}
echo '</ul>';
}
function get_sub_cat($id = 0)
{
$ids = $id;
// Add this line to the function
$res_ids[] = $ids;
do {
$subsql = "select id from `categories` where parent_off IN (" . $ids . ") ";
$subrs = mysql_query($subsql);
function get_cat($cat_id)
{
global $db;
// phpBB 2.0.9
$category_rows = array();
//
if ($cat_id <= 0) {
$cat_id = -1;
}
if ($cat_id > 0) {
$sql = "SELECT * FROM " . CATEGORIES_TABLE . " WHERE cat_id={$cat_id}";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query this categories', '', __LINE__, __FILE__, $sql);
}
if (!($row = $db->sql_fetchrow($result))) {
$cat_id = -1;
}
}
//
// no cat selected : get all
if ($cat_id <= 0) {
//-- v 1.0.5
$sql = "SELECT * FROM " . CATEGORIES_TABLE . " ORDER BY cat_order";
//--
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result)) {
$category_rows[] = $row;
}
}
//
// a cat selected : get it and its sub-cats
if ($cat_id > 0) {
// add the current one
$catrow[] = $row;
// get sub-cats
$catrow = get_sub_cat($cat_id, $catrow);
// get cats
//-- v 1.0.5
$sql = "SELECT * FROM " . CATEGORIES_TABLE . " ORDER BY cat_order";
//--
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result)) {
$found = false;
for ($i = 0; $i < count($catrow) && !$found; $i++) {
$found = $row['cat_id'] == $catrow[$i]['cat_id'];
}
if ($found) {
$category_rows[] = $row;
}
}
}
return $category_rows;
}
echo get_aktiv_layout_data(layout_path); ?> images/dicpic.jpg"></div> <div id="cat_item_right"> <a href="<?php echo $page_url . "/" . $get_cat['alias']; ?> /2.html" class="link"><strong><?php echo $get_cat['titel']; ?> </strong></a> (<?php echo $alllinksincat; ?> )<br /> <div id="prew_sub_cats"><?php echo get_sub_cat($get_cat_id); ?> ...</div></div> </div> <? echo $tab_br; } ?> </div> <br clear="left"><br> <div id="cont_box"> <?php echo $p_content; ?>
