<?php 
/**  
* 
* @author Ernst Bernt 
* 
* @package phpBB3 
* @version $Id: seite3.php 
* @copyright (c) 2008 SEO phpBB phpbb-seo.de 
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
* 
*/ 
 
/** 
* @ignore 
*/ 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
$phpEx = substr(strrchr(__FILE__, '.'), 1); 
include($phpbb_root_path . 'common.' . $phpEx); 
include($phpbb_root_path . 'includes/functions_display.' . $phpEx); 
 
 
 
// Start session management 
$user->session_begin(); 
$auth->acl($user->data); 
$user->setup('mods/my_language_file'); 
if ($user->data['user_id'] == ANONYMOUS)  
 
{  
   login_box('', $user->lang['LOGIN']);  
}  
 
 
    $_db_host = "server.net";            # meist localhost 
    $_db_datenbank = "datenbank"; 
    $_db_username = "user"; 
    $_db_passwort = "*****"; 
   
    SESSION_START(); 
 
    # Datenbankverbindung herstellen 
    $link = mysql_connect($_db_host, $_db_username, $_db_passwort); 
 
    # Hat die Verbindung geklappt ? 
    if (!$link) 
        { 
        die("Keine Datenbankverbindung möglich: " . mysql_error()); 
        } 
 
    # Verbindung zur richtigen Datenbank herstellen 
    $datenbank = mysql_select_db($_db_datenbank, $link); 
 
    if (!$datenbank) 
        { 
        echo "Kann die Datenbank nicht benutzen: " . mysql_error(); 
        mysql_close($link);        # Datenbank schliessen 
        exit;                    # Programm beenden ! 
        } 
         
page_header($user->lang['my_language_file']); 
 
$template->set_filenames(array( 
    'body' => 'suedmaehrendatenbank.html', 
)); 
       
 
$_pfarre = mysql_real_escape_string($_POST["pfarre"]); 
$_jahr = mysql_real_escape_string($_POST["jahr"]); 
$_nachname = mysql_real_escape_string($_POST["nachname"]); 
$_vorname = mysql_real_escape_string($_POST["vorname"]); 
 
$matrikenart = $_POST["matrikenart"]; 
$selected[$matrikenart] = "selected"; 
 
if($matrikenart == "1") { 
// Get all the data from the "example" table 
$baptism = mysql_query("SELECT 
pfarre_deutsch, 
bezirk, 
archiv, 
url, 
jahr, 
nachname, 
vorname, 
seite, 
buch, 
bemerkung, 
username   
   
                        
FROM 
sm_ind_bapt_view 
                        
WHERE 
pfarre_deutsch LIKE '%$_pfarre%' OR jahr='$_jahr' OR nachname LIKE '%$_nachname%' OR vorname LIKE '%$_vorname%'"); 
 
$title = 'Personenliste'; 
 
} 
 
elseif($matrikenart == "2")  
{ 
$marriage = mysql_query("SELECT 
jahr, 
nn_ehemann, 
vn_ehemann, 
nn_ehefrau, 
vn_ehefrau, 
archiv, 
username   
                        
FROM 
sm_ind_marr_view 
                        
WHERE 
pfarre_deutsch='$_pfarre' AND jahr='$_jahr'"); 
 
}  
 
else { 
$perish = mysql_query("SELECT 
jahr, 
nachname, 
vorname, 
archiv, 
username   
                        
FROM 
sm_ind_per_view 
                        
WHERE 
pfarre_deutsch='$_pfarre' AND jahr='$_jahr'"); 
 
} 
 
$db->sql_freeresult($result); 
 
 
page_footer(); 
 
?> 

<!-- INCLUDE overall_header.html -->  
 
 
<form method="post" action="new_page.php"> 
 
<h1><?php echo $title; ?></h1> 
   
 
<br /><b><h2>S&Uuml;DM&Auml;HREN-DATENBANK</b><br><br> 
Suchergebnis:<br /></h2> 
 
         
<div class="forumbg forumbg-table"> 
 <div class="inner"><span class="corners-top"><span></span></span> 
 
		<table class="table1" cellspacing="1" id="smdboutput"> 
    		<h2<!-- IF GROUP_COLOR --> style="color:#{GROUP_COLOR};"<!-- ENDIF -->>{GROUP_NAME}</h2> 
		<p>{GROUP_DESC} {GROUP_TYPE}</p> 
        <thead> 
        <tr> 
         <th class="name"><a href="{PARISH}">{L_PARISH}</a></th> 
         <th class="name"><a href="{YEAR}">{L_YEAR}</a></th> 
         <th class="name"><a href="{ARCHIV}">{L_ARCHIV}</a></th> 
         <th class="name"><a href="{SURNAME}">{L_SURNAME}</a></th> 
         <th class="name"><a href="{FORENAME}">{L_FORENAME}</a></th> 
         <th class="name"><a href="{USERNAME}">{L_USERNAME}</a></th> 
        </tr> 
        </thead> 
        <tbody> 
       <tr class="<!-- IF memberrow.S_ROW_COUNT is even -->bg1<!-- ELSE -->bg2<!-- ENDIF -->"> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
               </tr> 
        </tbody> 
</table>  
<span class="corners-bottom"><span></span></span> 
</div></div> 
<br> 
 
<input type="submit" name="submitbutton" id="submitbutton" value="neue Suche" height="50" width="100" style="width:100px; height:50px /> 
 <br /><br /> 
 
 
 
<!-- INCLUDE overall_footer.html -->