} 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ü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 ändern</a>
<a class='subnavi' href='edit_beschreibung.php?pic_id=0&mod=kat'>Beschreibungen zuweisen / ä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üfung</a>-->
