function db_send_query($sql) { #echo("Sending query: " . enc_html($sql) . "<br>\n"); $result = mysql_query($sql, $GLOBALS['wfpl_db_handle']); if (!$result) { die(enc_html('DATABASE ERROR: ' . mysql_error($GLOBALS['wfpl_db_handle']) . ' in the following query: ' . $sql)); } return $result; }
} else { $cmp = -1; } if ($timetolive-- <= 0) { echo "Error 12"; exit(0); } //Notfall-Abbruch um Endlosschleife zuvermeiden } while ($cmp > 0); } //echo "<td>FOUND: $lisa_compare_field with $bbsplan_compare_field</td>"; if (strtolower($lisa_compare_field) == strtolower($bbsplan_compare_field)) { //Feld darf nicht leer sein if ($lisa_compare_field != "") { //$tbl.="<tr><td>$i</td><td>$lisa_compare_field </td><td>$bbsplan_compare_field</td></tr>"; $tbl .= "<tr><td>{$i}</td><td>" . enc_html($lisa_val["picfile"]) . "</td><td>" . enc_html($bbsplan_val["picfile"]) . "</td><td><input type='checkbox' name='ok[]' value='{$i}' checked></td></tr>\n"; //Array Keys der übereinstimmenden speichern $match = array(); $match["lisa"] = $lisa_val; $match["bbsplan"] = $bbsplan_val; $match["checked"] = 0; //Übernehmen aber als nicht geprüft markieren $matches_found[$i] = $match; $i++; //Anzahl Matches erhöhen //Gefundene Einträge merken um diese später zu entfernen $lisa_key_delete[] = $lisa_val["nr"]; $bbsplan_key_delete[] = $bbsplan_val["nr"]; } } //else{
//====== Menü/Verzeichnisse ausgeben echo "<br><br>"; function buttonpath($source, $path) { return "<form action='matching_source.php' method='POST' >\n\t\t\t\t\t<input type='hidden' name='source' value='{$source}'>\n\t\t\t\t\t<input type='hidden' name='path' value='{$path}'>\n\t\t\t\t\t<input type='submit' name='chdir' value='auswählen'>\n\t\t\t\t</form>"; } function buttondelete($source, $path, $dirname) { return "<form action='matching_source.php' method='POST' >\n\t\t\t\t\t<input type='hidden' name='source' value='{$source}'>\n\t\t\t\t\t<input type='hidden' name='path' value='{$path}'>\n\t\t\t\t\t<input type='hidden' name='dirname' value='{$dirname}'>\n\t\t\t\t\t<input type='submit' name='delete' value='löschen'>\n\t\t\t\t</form>"; } echo "<table border='1'>"; $directory = opendir($path); echo "<tr><td>Hauptordner</td><td colspan='2'>" . buttonpath($source, $_SESSION["lisa_path"] . "/" . $_SESSION["settings"]["images_matching"]) . "</td>"; echo "<tr><td>Eine Ebende zurück</td><td colspan='2'>" . buttonpath($source, prepath($path)) . "</td>"; echo "<tr><td>\n\t\t\t\t\t<form action='matching_source.php' method='POST'>\n\t\t\t\t\t\t<input type='text' name='dirname'>\n\t\t\t\t\t\t<input type='hidden' name='source' value='{$source}'>\n\t\t\t\t\t\t<input type='hidden' name='path' value='{$path}'>\n\t\t\t\t</td>\n\t\t\t\t<td colspan='2'>\n\t\t\t\t\t\t<input type='submit' name='createdir' value='Ordner erstellen'>\n\t\t\t\t\t</form>\n\t\t\t\t</td>"; while ($file = readdir($directory)) { $extention = pathinfo($file, PATHINFO_EXTENSION); if ($file != "." && $file != ".." && is_dir($path . "/" . $file)) { echo "<tr><td>" . enc_html($path . "/" . $file) . "</td><td>" . buttonpath($source, $path . "/" . $file) . "</td><td>" . buttondelete($source, $path, $file) . "</td>"; } else { if ($extention == "zip") { echo "<tr><td>" . enc_html($path . "/" . $file) . "</td><td> </td><td>" . buttondelete($source, $path, $file) . "</td>"; } } } closedir($directory); echo "</table>"; echo "<br><h2>Neue ZIP-Datei mit Bildern hochladen</h2><br>\n\t\t<form action='matching_source.php' method='post' enctype='multipart/form-data'>\n\t\t\t<input type='hidden' name='source' value='{$source}'>\n\t\t\t<input type='hidden' name='path' value='{$path}'>\n\t\t\t<input type='hidden' name='path' value='{$path}'>\n\t\t\t<table border='0'>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<label for='file'>Filename:</label>\n\t\t\t\t\t\t<input type='file' name='file' id='file'>\n\t\t\t\t\t\t<input type='submit' name='submit' value='Submit'>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\tDateinamen-Kodierung ZIP-Datei:\n\t\t\t\t\t\t<input type='text' name='zipencsource' value='{$zipencsource}'>\n\t\t\t\t\t</td>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\tDateinamen-Kodierung Server-Datei-System:\n\t\t\t\t\t\t<input type='text' name='zipenctarget' value='{$zipenctarget}'>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\tMögliche Kodierungen u.a.: auto oder CP850,CP437,UTF-8,ISO-8859-1\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t</table>\n\t\t</form>"; echo "<a href='matching_index.php'> Zurück </a>"; $body = "<br>IP:" . $_SERVER["REMOTE_ADDR"] . "<br>"; echo create_footer("{$body}");
$birthday_month = "<td bgcolor='#00FF00'>OK</td>"; } else { $birthday_month = "<td bgcolor='#FF0000'>Error</td>"; $different++; } if ($match["lisa"]["birthday_year"] == $match["bbsplan"]["birthday_year"]) { $birthday_year = "<td bgcolor='#00FF00'>OK</td>"; } else { $birthday_year = "<td bgcolor='#FF0000'>Error</td>"; $different++; } if ($match["lisa"]["class"] == $match["bbsplan"]["class"]) { $class = "<td bgcolor='#00FF00'>OK</td>"; } else { $class = "<td bgcolor='#FF0000'>Error</td>"; $different++; } echo "<tr><td>{$different}</td><td>" . enc_html($match["lisa"]["picfile"]) . "</td><td>" . enc_html($match["bbsplan"]["picfile"]) . "</td>{$checked} {$lastname} {$givenname} {$birthday_day} {$birthday_month} {$birthday_year} {$class}</tr>\n"; } echo "<tr><td colspan='10'> <input type='submit' name='checked' value='Speichere Aktivierungen'></td></tr>"; echo "</form>"; echo "</table>"; } else { echo "<br>Keine Matches gefunden!<br>\n"; } echo "<a href='matching_index.php'> Zurück </a>"; ?>
function enc_htmlnbsp($str) { $str = enc_html($str); $str = str_replace(' ', ' ', $str); return $str; }