Beiträge von Shibo84

<?php
    $sql = "SELECT
                post_name,
                DATE_FORMAT(post_date_gmt, '%d. %m %Y') as post_date_gmt,
                post_title,
                post_content,
                post_excerpt
            FROM
                wp3__posts
            WHERE
                post_type = 'post' 
              AND
              post_status = 'publish'


            ORDER BY
                post_date DESC
            LIMIT
                5
           ";
?> 


 <?php
    $result = mysql_query($sql);
    $blogpath = "http://cabinet-of-curiosities.de/";
    $excerpt = "";
    if(mysql_num_rows($result)){
                echo "<ul>\n";
        while($row = mysql_fetch_assoc($result)){
            // Falls Auszuge vorhanden wird dieser genommen,
            // ansonsten eine Kurzversion des Inhalts
            if(trim($row['post_excerpt']) == "")
                $excerpt = substr(strip_tags($row['post_content']),0,160)."..."; 
            else
                $excerpt = strip_tags($row['post_excerpt']);
            echo "<li>".
                 "<a href=\"".$blogpath.$row['post_name']."/\" ".
                 "title=\"".$excerpt."\">".
                 $row['post_title'].
                 "</a> ".
                 "</li>";
        }
        echo "</ul>";
    }
?>

<?php get_header(); ?>
<div class="art-content-layout" >
    <div class="art-content-layout-row">
        <div class="art-layout-cell art-sidebar1">
          <?php get_sidebar('default'); ?>
          <div class="cleared"></div>
        </div>
        <div class="art-layout-cell art-content">


            <?php get_sidebar('top'); ?>
            <?php 
                if(have_posts()) {
                
                    theme_post_wrapper(
                          array('content' => '<h4 class="box-title">' . sprintf( __( 'Search Results for: %s', THEME_NS ), 
                              '<span>' . get_search_query() . '</span>' ) . '</h4>' 
                          )
                      );
                
                    /* Display navigation to next/previous pages when applicable */
                    if (theme_get_option('theme_top_posts_navigation')) {
                        theme_page_navigation();
                    }
                    
                    /* Start the Loop */ 
                    while (have_posts()) {
                        the_post();
                        get_template_part('content', get_post_format());
                    }
                    
                    /* Display navigation to next/previous pages when applicable */
                    if (theme_get_option('theme_bottom_posts_navigation')) {
                         theme_page_navigation();
                    }
                
                } else {
                
                
                    theme_post_wrapper(
                        array(
                                'title' =>__('Nothing Found', THEME_NS),
                                'content' => '<p class="center">' .  __('Sorry, but nothing matched your search criteria. Please try again with some different keywords.', THEME_NS) . '</p>'
                                            .  "\n" . theme_get_search()
                        )
                    );
                     
                } 
            ?>
            <?php get_sidebar('bottom'); ?>
          <div class="cleared"></div>
        </div>
        <div class="art-layout-cell art-sidebar2">
          <?php get_sidebar('secondary'); ?>
          <div class="cleared"></div>
        </div>
    </div>
</div>
<div class="cleared"></div>
<?php get_footer(); ?>

<?php
    $sql = "SELECT
                post_name,
                DATE_FORMAT(post_date_gmt, '%d. %m %Y') as post_date_gmt,
                post_title,
                post_content,
                post_excerpt
            FROM
                wp_posts
            WHERE
                post_type = 'post' 
              AND
              post_status = 'publish'


            ORDER BY
                post_date DESC
            LIMIT
                5
           ";
?> 


 <?php
    $result = mysql_query($sql);
    $blogpath = "http://judys-tears.de/";
    $excerpt = "";
    if(mysql_num_rows($result)){
                echo "<ul>\n";
        while($row = mysql_fetch_assoc($result)){
            // Falls Auszuge vorhanden wird dieser genommen,
            // ansonsten eine Kurzversion des Inhalts
            if(trim($row['post_excerpt']) == "")
                $excerpt = substr(strip_tags($row['post_content']),0,160)."..."; 
            else
                $excerpt = strip_tags($row['post_excerpt']);
            echo "<li>".
                 "<a href=\"".$blogpath.$row['post_name']."/\" ".
                 "title=\"".$excerpt."\">".
                 $row['post_title'].
                 "</a> ".
                 "</li>";
        }
        echo "</ul>";
    }
?>