} 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>-->