} else {
    $quelle = $_SERVER['HTTP_REFERER'];
}
//echo $quelle;
if (array_key_exists('user_id', $_GET)) {
    $user_id = $_GET['user_id'];
}
if (array_key_exists('method', $_GET)) {
    $method = $_GET['method'];
} else {
    $method = '';
}
//echo $navi;
echo "\n<div class='page'>\n\n\t<p id='kopf'>pic2base :: Doublettenpr&uuml;fung <span class='klein'>(User: {$username})</span></p>\n\t\n\t<div class='navi' style='clear:right;'>\n\t\t<div class='menucontainer'>";
if (strstr($quelle, "edit_start.php") or strstr($quelle, "stapel2.php") or strstr($quelle, "doublettenliste1.php")) {
    createNavi3($uid);
} elseif (strstr($quelle, "db_wartung1.php")) {
    include '../admin/adminnavigation.php';
}
echo "</div>\n\t</div>\n\t\n\t<div class='content'>\n\t\t<center>\n\t\t<table class='liste1'>\n\t\t<tbody>";
//Tabelle doubletten von alten Eintraegen bereinigen:
$result = mysql_query("DELETE FROM {$table21} WHERE user_id = '{$user_id}'");
//Ermittlung der Datensaetze, bei denen die md5-Summe mehrfach gleich sind:
$result0 = mysql_query("SELECT P1.pic_id, P1.FileNameOri, P1.md5sum, P1.aktiv \n\t\t\tFROM {$table2} AS P1, \n\t\t\t(SELECT P.md5sum FROM {$table2} as P GROUP BY P.md5sum HAVING COUNT( * ) > 1) \n\t\t\tas P2 \n\t\t\tWHERE P1.md5sum = P2.md5sum\n\t\t\tAND P1.aktiv = '1' \n\t\t\tORDER BY P1.pic_id DESC");
/* original:
			//Ermittlung der Datensaetze, bei denen der Original-Dateiname und die md5-Summe mehrfach gleich sind:
			$result0 = mysql_query("SELECT P1.pic_id, P1.FileNameOri, P1.md5sum, P1.aktiv 
			FROM $table2 AS P1, 
			(SELECT P.FileNameOri, P.md5sum FROM $table2 as P GROUP BY P.FileNameOri, P.md5sum HAVING COUNT( * ) > 1) 
			as P2 
			WHERE P1.FileNameOri = P2.FileNameOri 
$fh = fopen($p2b_path . 'pic2base/log/p2b.log', 'a');
fwrite($fh, date('d.m.Y H:i:s') . " " . isset($REMOTE_ADDR) . " " . $_SERVER['PHP_SELF'] . " " . $_SERVER['HTTP_USER_AGENT'] . " " . $c_username . "\n");
fclose($fh);
?>

<div class="page">

	<p id="kopf">pic2base :: Datensatz-Bearbeitung <span class='klein'>(User: <?php 
echo $c_username;
?>
)</span></p>
	
	<div class="navi" style="clear:right;">
		<div class="menucontainer">
		<?php 
createNavi3($c_username);
//echo $navigation;
?>
		</div>
	</div>
	
	<div id="spalte1">
		<!--<a class='subnavi' href='#'>EXIF-Daten bearbeiten</a>-->
		<center>
		<a class='subnavi' href='edit_geo_daten.php?pic_id=0&mod=kat'>Geo-Referenzierung</a>
		<a class='subnavi' href='edit_bewertung.php?pic_id=0&mod=kat'>Bilder bewerten / Bewertung &auml;ndern</a>
		<a class='subnavi' href='edit_beschreibung.php?pic_id=0&mod=kat'>Beschreibungen zuweisen / &auml;ndern</a>
		<a class='subnavi' href='edit_kat_daten.php?pic_id=0&mod=edit'>Kategorien zuweisen</a>
		<a class='subnavi' href='edit_remove_kat.php?pic_id=0&mod=kat'>Kategorie-Zuweisungen aufheben</a>
		<a class='subnavi_blind'></a>
		<!--<a class='subnavi' href='double_check0.php'>Doubletten-Pr&uuml;fung</a>-->