Beiträge von pospiech

<?php 
    $navigation_content_left  = "";
    $navigation_content_right = "";
    $navigation_content_left  = previous_post_link('&laquo; %link');
    $navigation_content_right = next_post_link('%link &raquo;');
    if (($navigation_content_left != "") && ($navigation_content_right != "")) : ?> 
                        <div class="navigation">
                            <div class="left-element"><?php previous_post_link('&laquo; %link') ?></div>
                            <div class="right-element"><?php next_post_link('%link &raquo;') ?></div>
                        </div>
<?php endif; ?>

<ul id="sidebar">
	<h2>Seiten</h2>
	<ul>
<li class="page_item"><a href="http://www.local-wpcqa.de" title="CQa">Home</a></li>
<li class="page_item page-item-6"><a href="http://www.local-wpcqa.de/andere-seite/" title="Andere Seite">Andere Seite</a></li>
<li class="page_item page-item-2 current_page_item "><a href="http://www.local-wpcqa.de/eine-seite/" title="Eine Seite">Eine Seite</a>
	<ul>
		<li class="page_item page-item-5"><a href="http://www.local-wpcqa.de/eine-seite/unterseite/" title="Unterseite">Unterseite</a></li>
	</ul>
	</li>
</ul>
<h2>Kategorien</h2>
	<ul>
		<li class="cat-item cat-item-1"><a href="http://www.local-wpcqa.de/category/allgemein/" title="Alle unter Allgemein abgelegten Beitr&auml;ge ansehen">Allgemein</a></li>
	</ul>

<div id="leftcol">
        <ul id="sidebar">
            <?php   /* Widgetized sidebar, if you have the plugin installed. */ 
                    if ( !function_exists('dynamic_sidebar') || !dynamic_sidebar() ) : ?> 
            <li>
                <?php include (TEMPLATEPATH . '/searchform.php'); ?>
            </li>
    
            <?php if ( is_404() || is_category() || is_day() || is_month() || 
            is_year() || is_search() || is_paged() ) { 
            ?> <li> 
            <?php /* If this is a 404 page */ if (is_404()) { ?>
            <?php /* If this is a category archive */ } elseif (is_category()) { ?>
            <p>du durchsuchst derzeit das Archiv der <?php single_cat_title(''); ?> Kategorie.</p>
            
            <?php /* If this is a daily archive */ } elseif (is_day()) { ?>
            <p>du durchsuchst derzeit das <a href="<?php echo get_settings('siteurl'); ?>"><?php echo bloginfo('url'); ?></a> Archiv
            nach <?php the_time('l,'); ?> den <?php the_time('j. F Y'); ?>.</p>
            
            <?php /* If this is a monthly archive */ } elseif (is_month()) { ?>
            <p>du durchsuchst derzeit das <a href="<?php echo get_settings('siteurl'); ?>"><?php echo bloginfo('url'); ?></a> Archiv
            nach dem Monat <?php the_time('F Y'); ?>.</p>


            <?php /* If this is a yearly archive */ } elseif (is_year()) { ?>
            <p>du durchsuchst derzeit das <a href="<?php echo get_settings('siteurl'); ?>"><?php echo bloginfo('url'); ?></a> Archiv
            nach dem Jahr <?php the_time('Y'); ?>.</p>
            
            <?php /* more links to find */ } elseif (is_search()) { ?>
            <p>du hast das <a href="<?php echo get_settings('siteurl'); ?>"><?php echo bloginfo('url'); ?></a> Archiv nach
            <strong>'<?php the_search_query(); ?>'</strong> durchsucht. Wenn du in den Ergebnissen nichts gefunden hast, helfen dir eventuell die folgenden Links.</p>


            <?php /* If this is not a specified archive */ } elseif (isset($_GET['paged']) && !empty($_GET['paged'])) { ?>
            <p>du durchsuchst derzeit das <a href="<?php echo get_settings('siteurl'); ?>"><?php echo bloginfo('url'); ?></a> Archiv.</p>


            <?php } ?>
            </li> <?php }?> 


            <?php wp_list_pages('title_li=<h2>Seiten</h2>' ); ?>


            <li><h2>Archiv</h2>
                <ul>
                <?php wp_get_archives('type=monthly'); ?>
                </ul>
            </li>
            
            <?php wp_list_categories('show_count=1&title_li=<h2>Kategorien</h2>'); ?>


            <?php /* If this is the frontpage */ if ( is_home() || is_page() ) { ?>                
                <?php wp_list_bookmarks(); ?>
                
                <li><h2>Meta</h2>
                <ul>
                    <?php wp_register(); ?>
                    <li><?php wp_loginout(); ?></li>
                    <li><a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional">Valid <abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a></li>
                    <li><a href="http://gmpg.org/xfn/"><abbr title="XHTML Friends Network">XFN</abbr></a></li>
                    <li><a href="http://wordpress.org/" title="Powered by WordPress, state-of-the-art semantic personal publishing platform.">WordPress</a></li>
                    <li><a href="http://wordpress-deutschland.org/" title="WordPress Deutschland">WPD</a></li>
                    <?php wp_meta(); ?>
                </ul>
                </li>
            <?php } ?>
            <?php endif; ?> 
        </ul>
    </div><!-- ends leftcol -->

<?php get_header(); ?>


    <div id="container">
        <div id="container2">
            <?php get_sidebar(); ?>
            <div id="rightcol"></div>
            <div id="content">


<?php if (have_posts()) : ?>
<?php while (have_posts()) : the_post(); ?>


<div id="contentHeader"><h1><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h1></div>


<?php the_content('Read More'); ?>


<span class="readMore">Continue Reading</span>


<div id="contentFooter"><p>Published <?php the_time('M d, Y') ?> - <?php comments_popup_link('Comments? None yet', '1 Comment so far', '% Comments and counting'); ?> </p></div>


<?php endwhile; ?>


<?php else : ?>
<h2 class="center">Not Found</h2>
<p class="center">Sorry, but you are looking for something that isn't here.</p>
<?php include (TEMPLATEPATH . "/searchform.php"); ?>
<?php endif; ?>


            </div><!-- ends content -->
        </div><!-- ends container2 -->
        <div id="cleardiv"></div>
    </div><!-- ends container -->


<?php get_footer(); ?>

function cqa_add_menus() {
    add_menu_page('CQa Seminare Verändern', 'CQa Seminare', 8, __FILE__, 'cqa_show_seminar_main');    
}
add_action('admin_menu', 'cqa_add_menus');


function cqa_show_seminar_main() { 
    echo "<form name=\"cqa_form_show_SeminarEdit\" method=\"post\" action=\"admin.php?page=cqa-seminare/cqa-seminare-actions.php\" >\n";
    echo "   <input type=\"submit\" name=\"cqa_form_action_Show\"  value=\"Seminar bearbeiten\">\n";
    echo "</form>";
} 


function cqa_show_seminare() { 
    
    echo "<div class=\"CQaFormDivSeminare\">";
    echo "<h3>Seminare</h3>";
...
    echo "</div>";
}

function get_table_Termine_VorbereitungSeminar() 
{
     //db_connect();
    global $sql_hostname,$sql_database,$sql_dbuser,$sql_dbpassword;
    require_once 'cqa-db-config.php';
    global $cqa_dbhandle;    
    $cqa_dbhandle = mysql_connect($sql_hostname, $sql_dbuser, $sql_dbpassword,true) or die("Konnte nicht zum mySQL-Server verbinden: ".mysql_error());
    mysql_select_db($sql_database, $cqa_dbhandle) or die("Konnte die Datenbank ".$sql_database." nicht oeffnen: ".mysql_error());


    // Daten auslesen und in seminare und termine speichern
    $seminare = mysql_query("SELECT * FROM cqa_seminare", $cqa_dbhandle);    
    if (!$seminare) {
            die('Ungültige Abfrage: ' . mysql_error());
    }
    $termine = mysql_query("SELECT * FROM cqa_seminartermine ORDER BY datum", $cqa_dbhandle);
    if (!$termine ) {
            die('Ungültige Abfrage: ' . mysql_error());
    }