(Unter)Kategorien mit Titel und Beschreibung darstellen

<?php




        global $table_prefix, $wpdb,$post;
        $currentcat = get_query_var('cat');
        if($currentcat == 0 || $currentcat == '') {
            $name = $post->post_name;
            $id = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_name = '$name'");
            $tempcat = mysql_query("SELECT category_id FROM $wpdb->post2cat WHERE post_id = '$id' ORDER BY category_id ASC LIMIT 1");
            $currentcat = @mysql_result($tempcat,0);
        }
        
        $catstable = $table_prefix . "categories";
        $tempcat = mysql_query("SELECT category_parent FROM $catstable WHERE cat_id = '$currentcat'");
        $tempcat = @mysql_result($tempcat,0);
        if($tempcat != 0) {
            $currentcat = $tempcat;
        }


/*
Template Name: Category List


Category List Page template for WordPress 2
created by Kaf Oseo (http://szub.net/)


Category List is based on the Page template of the default (Kubrick)
theme in WordPress. It may require layout changes to work with other
themes. The template is commented throughout to explain the various
elements and provide detailed *clues* on modifying it.


Notes:


1. Set the variables in the 'user-configurable variables' section
   below if you need to customize the categories query.


2. In the 'category list loop' a category's table column values are
   output by echo'ing properties of $category (defined in the loop).
   An example is:


    <?php echo $category->cat_name; ?>


   which displays the name of the category. The columns/properties
   are:


    cat_ID : Category ID number.
    cat_name : Name of category.
    category_nicename : Category name in url format.
    category_description : Description of category.
    category_parent : Category ID of parent category.
    category_count : Number of posts in category.
*/


/* >> user-configurable variables >> */


// $exclude - Category ID# to exclude (i.e. '100'); delimit multiple
// categories with comma ('1, 2, 3').
$exclude = '';


// $orderby - Category table column (record) to sort on; for column
// options see note #2 above.
$orderby = 'cat_name';


// $order - The sort order method. Use 'ASC'ending or 'DESC'ending.
$order = 'ASC';


/* << user-configurable variables << */


if($exclude) { // set up the category exclude list for the query
    $and = '';
    $wherecat = 'AND (';
    $exclude_cat = preg_split('/[\s,]+/', $exclude);
    foreach ($exclude_cat as $xcat) {
        $wherecat .= $and . ' cat_ID <> ' . $xcat . ' ';
        $and = 'AND';
    }
    $wherecat .= ')';
}


global $wpdb; // making sure the WP database object is around
/* the next line assigns the query results to $categories */
$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE category_count > 0 AND category_parent = $currentcat $wherecat ORDER BY $orderby $sort"); // $wp_object_cache->cache['category'];


?>








<?php get_header(); ?>
    
    <?php wp_quotes_random(); ?>
    <div id="content">
        
        <?php /* >> category list loop >> the important part! */ ?>
        <?php while(list(,$category) = each($categories)) : // start loop ?>
                
                <h3 id="cat-<?php echo $category->cat_ID; ?>"><a href="<?php echo get_category_link($category->cat_ID); // returns category url ?>" title="<?php echo $category->cat_name; ?>"><?php echo $category->cat_name; ?></a> &nbsp;&nbsp;<span>(<?php echo $category->category_count; ?> Beitr&auml;ge)</span></h3>
                <p><?php echo $category->category_description; ?></p>
                
        <?php endwhile; // end loop ?>
        <?php /* << category list loop << */ ?>
            
        <hr />
    
    <?php if (have_posts()) : while (have_posts()) : the_post(); ?>
        
            <h3><a class="mehr" href="<?php the_permalink() ?>"><?php the_title(); ?></a></h3>
            <?php the_content(); ?>


    <?php endwhile; else: ?>


            <p><?php _e('Sorry, no posts matched your criteria.'); ?></p>


    <?php endif; ?>
    </div>
<?php get_footer(); ?>

<?php


$exclude = '';
$orderby = 'cat_name';
$order = 'ASC';


if($exclude) {
    $and = '';
    $wherecat = 'AND (';
    $exclude_cat = preg_split('/[\s,]+/', $exclude);
    foreach ($exclude_cat as $xcat) {
        $wherecat .= $and . ' cat_ID <> ' . $xcat . ' ';
        $and = 'AND';
    }
    $wherecat .= ')';
}


global $wpdb;


$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE category_count > 0 AND category_parent = $cat $wherecat ORDER BY $orderby $sort"); // $wp_object_cache->cache['category'];
?>
<?php get_header(); ?>


<?php wp_quotes_random(); ?>
<div id="content">
    <p id="bcnav"><?php breadcrumb('home_title=Startseite'); ?></p>
    <?php while(list(,$category) = each($categories)) : ?>
        <h5 id="cat-<?php echo $category->cat_ID; ?>">&raquo; <a href="<?php echo get_category_link($category->cat_ID); // returns category url ?>" title="<?php echo $category->cat_name; ?>"><?php echo $category->cat_name; ?></a> &nbsp;&nbsp;<span>(<?php echo $category->category_count; ?> Beitr&auml;ge)</span></h5>
        <p><?php echo $category->category_description; ?></p>
    <?php endwhile; ?>


    <?php if (have_posts()) : while (have_posts()) : the_post(); ?>
        <h3><a class="mehr" href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title('-image-'); ?></a></h3>
        <?php the_content(); ?>
    <?php endwhile; else: ?>
        <p><?php _e('Sorry, no posts matched your criteria.'); ?></p>
    <?php endif; ?>


</div>
<?php get_footer(); ?>

<?php
$mycount = 1;
$exclude = '';
$orderby = 'cat_name';
$order = 'ASC';


if($exclude) {
    $and = '';
    $wherecat = 'AND (';
    $exclude_cat = preg_split('/[\s,]+/', $exclude);
    foreach ($exclude_cat as $xcat) {
        $wherecat .= $and . ' cat_ID <> ' . $xcat . ' ';
        $and = 'AND';
    }
    $wherecat .= ')';
}


global $wpdb;


$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE category_count > 0 AND category_parent = $cat $wherecat ORDER BY $orderby $sort"); // $wp_object_cache->cache['category'];
?>


<?php get_header(); ?>


<?php wp_quotes_random(); ?>
<div id="content">
    <p id="bcnav"><?php breadcrumb('home_title=Startseite&sep=:'); ?></p>
    <table class="mycattable">
    <?php while(list(,$category) = each($categories)) : ?>
        <?php
        if ($mycount == 1) {
            echo "<tr>";
            }
        ?>
        <td>
        <h5 id="cat-<?php echo $category->cat_ID; ?>">&raquo; <a href="<?php echo get_category_link($category->cat_ID); // returns category url ?>" title="<?php echo $category->cat_name; ?>"><?php echo $category->cat_name; ?></a> &nbsp;&nbsp;<span>(<?php echo $category->category_count; ?> Beitr&auml;ge)</span></h5>
        <p><?php echo $category->category_description; ?></p>
        </td>
        <?php
        if ($mycount == 1) {
            $mycount = $mycount+1;
            }
        else {
            echo "</tr>";
            $mycount = $mycount-1;
            }
        ?>
    <?php endwhile; ?>
    <?php
        if ($mycount == 2) {
            echo "<td></td></tr>";
            }
        ?>
    </table>
    <?php if (have_posts()) : while (have_posts()) : the_post(); ?>
        <h3><a class="mehr" href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title('-image-'); ?></a></h3>
        <?php the_content(); ?>
    <?php endwhile; else: ?>
        <p><?php _e('Sorry, no posts matched your criteria.'); ?></p>
    <?php endif; ?>


</div>
<?php get_footer(); ?>