From be182874f72c4813b649fcdb0d74ba8dfbb363a1 Mon Sep 17 00:00:00 2001 From: "Ole B. Rosentreter" Date: Sat, 28 Sep 2024 22:40:07 +0200 Subject: [PATCH] Initial project version --- pom.xml | 17 ++ src/domainmanager.php | 176 +++++++++++++++++ src/lib/database_functions.php | 12 ++ src/lib/db/database_functions_delete.php | 16 ++ src/lib/db/database_functions_insert.php | 38 ++++ src/lib/db/database_functions_mysql.php | 118 ++++++++++++ src/lib/db/database_functions_pgsql.php | 76 ++++++++ src/lib/db/database_functions_select.php | 50 +++++ src/lib/db/database_functions_update.php | 4 + src/lib/glob_vars.php | 13 ++ src/lib/gui/gui_functions_button.php | 62 ++++++ src/lib/gui/gui_functions_checkbox.php | 16 ++ src/lib/gui/gui_functions_input.php | 90 +++++++++ src/lib/gui/gui_functions_select.php | 93 +++++++++ src/lib/gui/gui_functions_textarea.php | 30 +++ src/lib/gui_functions.php | 9 + src/lib/session/session_functions.php | 33 ++++ src/lib/session_functions.php | 5 + src/lib/util/util_functions.php | 67 +++++++ src/lib/util_functions.php | 6 + src/mailboxmanager.php | 228 +++++++++++++++++++++++ src/mailmanager.php | 3 + src/passwordmanager.php | 3 + 23 files changed, 1165 insertions(+) create mode 100644 pom.xml create mode 100644 src/domainmanager.php create mode 100644 src/lib/database_functions.php create mode 100644 src/lib/db/database_functions_delete.php create mode 100644 src/lib/db/database_functions_insert.php create mode 100644 src/lib/db/database_functions_mysql.php create mode 100644 src/lib/db/database_functions_pgsql.php create mode 100644 src/lib/db/database_functions_select.php create mode 100644 src/lib/db/database_functions_update.php create mode 100755 src/lib/glob_vars.php create mode 100644 src/lib/gui/gui_functions_button.php create mode 100644 src/lib/gui/gui_functions_checkbox.php create mode 100644 src/lib/gui/gui_functions_input.php create mode 100644 src/lib/gui/gui_functions_select.php create mode 100644 src/lib/gui/gui_functions_textarea.php create mode 100644 src/lib/gui_functions.php create mode 100644 src/lib/session/session_functions.php create mode 100644 src/lib/session_functions.php create mode 100644 src/lib/util/util_functions.php create mode 100644 src/lib/util_functions.php create mode 100644 src/mailboxmanager.php create mode 100644 src/mailmanager.php create mode 100644 src/passwordmanager.php diff --git a/pom.xml b/pom.xml new file mode 100644 index 0000000..e82ec26 --- /dev/null +++ b/pom.xml @@ -0,0 +1,17 @@ + + 4.0.0 + de.laktatnebel.tools + scripts + 0.0.1-SNAPSHOT + pom + + scripts + + + de.laktatnebel.maven + laktatnebelscript + 2.1.7 + + + diff --git a/src/domainmanager.php b/src/domainmanager.php new file mode 100644 index 0000000..717fc1b --- /dev/null +++ b/src/domainmanager.php @@ -0,0 +1,176 @@ +"; +echo "\n"; +echo "\n"; +echo "\n"; +echo "\n"; +echo "\nDomain-Manager"; + +echo "\n"; +echo "\n"; + +echo "
"; +echo "\$_POST:\t"; print_r($_POST); +echo "
"; + +$tabindex = 1; + +echo "\n
"; + +echo "\n\t
"; +echo "\n\t\tDomain pflegen"; +echo "\n\t\t\t
\n"; +makeSelect("domainlist_1", $domainsFromDB, "domainlist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, "vorhandene Domains:", false, false, 3); +makeButton("domain_delete_submit", "delete", "Löschen", "domain_delete_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\t\t\t
"; +echo "\n\t\t
"; +echo "\n\t\t\t
\n"; +makeInput("newdomain", null, "newdomain", null, $tabindex++, "text", 50, 200, null, true, "Domain einfügen:", false, false, 3); +makeButton("domain_new_submit", "save", "Speichern", "domain_new_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\n\t\t\t
"; +echo "\n\t
"; + +echo "\n\t
"; +echo "\n\t\tSubdomain pflegen"; +echo "\n\t\t\t
\n"; +makeSelect("subDomainlist_1", $subDomainsFromDB, "subDomainlist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, "vorhandene Subdomains:", false, false, 3); +makeButton("subdomain_delete_submit", "delete", "Löschen", "subdomain_delete_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\t\t\t
"; +echo "\n\t\t
"; +echo "\n\t\t\t
\n"; +makeInput("newsubdomain", null, "newsubdomain", null, $tabindex++, "text", 50, 200, null, true, "Subdomain einfügen:", false, false, 3); +makeButton("subdomain_new_submit", "save", "Speichern", "subdomain_new_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\n\t\t\t
"; +echo "\n\t
"; + +echo "\n\t
"; +echo "\n\t\tTopleveldomain pflegen"; +echo "\n\t\t\t
\n"; +makeSelect("tldlist_1", $toplevelDomainsFromDB, "tldlist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, "vorhandene Topleveldomains:", false, false, 3); +makeButton("tld_delete_submit", "delete", "Löschen", "tld_delete_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\t\t\t
"; +echo "\n\t\t
"; +echo "\n\t\t\t
\n"; +makeInput("newtld", null, "newtld", null, $tabindex++, "text", 50, 200, null, true, "Topleveldomain einfügen:", false, false, 3); +makeButton("tld_new_submit", "save", "Speichern", "tld_new_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\n\t\t\t
"; +echo "\n\t
"; + +echo "\n
"; + +echo "\n
"; + +echo "\n\t
"; +echo "\n\t\tVerknüpfung Domain mit Topleveldomain pflegen"; +echo "\n\t\t\t
\n"; +makeSelect("domainlist_2", $domainsFromDB, "domainlist_2", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +echo "\t\t\t.\n"; +makeSelect("tldlist_2", $toplevelDomainsFromDB, "tldlist_2", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +echo "\t\t\tUser:\n"; +makeSelect("peoplelist_1", $peopleFromDB, "peoplelist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +echo "\t\t\treg. Datum:\n"; + +makeSelect("regDateD", null, "regDateD", null, $tabindex++, 1, 31, date("j"), false, 1, null, true, null, false, false, 3); +echo "\t\t\t.\n"; +makeSelect("regDateM", null, "regDateM", null, $tabindex++, 1, 12, date("n"), false, 1, null, false, null, false, false, 3); +echo "\t\t\t.\n"; +makeSelect("regDateY", null, "regDateY", null, $tabindex++, 2000, date("Y"), date("Y"), false, 1, null, false, null, false, false, 3); + +makeButton("regdomain_new_submit", "save", "Verknüpfen", "regdomain_new_submit", null, $tabindex++, "submit", null, null, false , false, 3); +echo "\t\t\t
"; +echo "\n\t\t
"; +echo "\n\t\t\t
\n"; +makeSelect("regdomainlist_1", $regDomainsFromDB, "regdomainlist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +makeButton("regdomain_delete_submit", "delete", "Verknüpfung lösen", "regdomain_delete_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\t\t\t
"; +echo "\n\t
"; + +echo "\n\t
"; +echo "\n\t\tVerknüpfung reg. Domain mit Subdomain pflegen"; +echo "\n\t\t\t
\n"; +makeSelect("subdomainlist_2", $subDomainsFromDB, "subdomainlist_2", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +echo "\t\t\t.\n"; +makeSelect("regdomainlist_2", $regDomainsFromDB, "regdomainlist_2", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +makeButton("fulldomain_new_submit", "save", "Verknüpfen", "fulldomain_new_submit", null, $tabindex++, "submit", null, null, false , false, 3); +echo "\t\t\t
"; +echo "\n\t\t
"; +echo "\n\t\t\t
\n"; +makeSelect("fulldomainlist_1", $fullDomainsFromDB, "fulldomainlist_1", null, $tabindex++, -1, -1, -1, false, 1, null, false, null, false, false, 3); +makeButton("fulldomain_delete_submit", "delete", "Verknüpfung lösen", "fulldomain_delete_submit", null, $tabindex++, "submit", null, null, false, false, 3); +echo "\n\t\t\t
"; +echo "\n\t
"; + +echo "\n
"; + +echo "\n"; +echo "\n"; + +closeDBConnection($mysql_connection); + +?> diff --git a/src/lib/database_functions.php b/src/lib/database_functions.php new file mode 100644 index 0000000..224b1c5 --- /dev/null +++ b/src/lib/database_functions.php @@ -0,0 +1,12 @@ + \ No newline at end of file diff --git a/src/lib/db/database_functions_delete.php b/src/lib/db/database_functions_delete.php new file mode 100644 index 0000000..f12d7d5 --- /dev/null +++ b/src/lib/db/database_functions_delete.php @@ -0,0 +1,16 @@ + \ No newline at end of file diff --git a/src/lib/db/database_functions_insert.php b/src/lib/db/database_functions_insert.php new file mode 100644 index 0000000..4e90056 --- /dev/null +++ b/src/lib/db/database_functions_insert.php @@ -0,0 +1,38 @@ + \ No newline at end of file diff --git a/src/lib/db/database_functions_mysql.php b/src/lib/db/database_functions_mysql.php new file mode 100644 index 0000000..7deda41 --- /dev/null +++ b/src/lib/db/database_functions_mysql.php @@ -0,0 +1,118 @@ +".$res_sql_result; + $return_bool_value = true; + } else { + return "Datenbankabfrage fehlgeschlagen!"; + } + } else { + return "DB-Verbindung fehlgeschlagen!"; + } + + return $return_bool_value; +} + + +// SQL an DB absetzen +// Parameter: Tablle, Feld(er), Wert(e) +// Rückgabewert: Array +function getData ($dbms_connection, $db_query, $db_name) { + $return_arr_data = array(); // Rückgabewert als Array + //echo "\n

SQL:
".$ref_str_db_query."

"; + + // DB-Verbindung + $db_connection = mysql_select_db($db_name, $dbms_connection); + if ($db_connection) { + + // DB Abfage starten + //echo $db_query; + $res_sql_result = mysql_query ($db_query, $dbms_connection); + // Gültigkeit der DB Abfage testen + if ($res_sql_result) { + //echo "
  • ".$res_sql_result; + while ($arr_sql_data = mysql_fetch_row($res_sql_result)) { + //echo debugPrint($arr_sql_data); + array_push ($return_arr_data, $arr_sql_data); + } + //var_dump( $return_arr_data); + } else { + return "Datenbankabfrage fehlgeschlagen!"; + } + } else { + return "DB-Verbindung fehlgeschlagen!"; + } + + return $return_arr_data; +} + +// Funktion ÜberprÜfung des Logins +// Parameter: Eingegebener Username , eingegebenes Passwort +// Rückgabewert: boolean +/** + * @deprecated + */ +function check_login ($dbms_connection, $ref_str_user_name, $ref_str_user_pass) { + $return_data = false; // Rückgabewert als Array + + $ref_str_db_query = "SELECT count(*) FROM frauke.login WHERE (login_name='".trim($ref_str_user_name)."') AND (login_pass='".$ref_str_user_pass."')"; + //echo $ref_str_db_query; + + // DB Abfage starten + $res_sql_result = pg_query ($dbms_connection, $ref_str_db_query); + //echo "

    _".$res_sql_result."_

    "; + + // Gültigkeit der DB Abfage testen + if ($res_sql_result) { + $arr_sql_data = pg_fetch_row($res_sql_result); + //print_r($arr_sql_data); + + if ($arr_sql_data[0] == 1) { + $return_data = true; + } + //var_dump( $return_arr_data); + } else { + return "Datenbankabfrage fehlgeschlagen!"; + } + + return $return_data; +} + +?> \ No newline at end of file diff --git a/src/lib/db/database_functions_pgsql.php b/src/lib/db/database_functions_pgsql.php new file mode 100644 index 0000000..7eb2a35 --- /dev/null +++ b/src/lib/db/database_functions_pgsql.php @@ -0,0 +1,76 @@ +".$res_sql_result; + $return_bool_value = true; + } else { + return "Datenbankabfrage fehlgeschlagen!"; + } + + return $return_bool_value; +} + + +// SQL an DB absetzen +// Parameter: Tablle, Feld(er), Wert(e) +// Rückgabewert: Array +function getData ($dbms_connection, $db_query) { + $return_arr_data = array(); // Rückgabewert als Array + //echo "\n

    SQL:
    ".$ref_str_db_query."

    "; + + // DB Abfage starten + //echo $db_query; + $res_sql_result = pg_query ($db_query, $dbms_connection); + // Gültigkeit der DB Abfage testen + if ($res_sql_result) { + //echo "
  • ".$res_sql_result; + while ($arr_sql_data = pg_fetch_row($res_sql_result)) { + //echo debugPrint($arr_sql_data); + array_push ($return_arr_data, $arr_sql_data); + } + //var_dump( $return_arr_data); + } else { + return "Datenbankabfrage fehlgeschlagen!"; + } + + return $return_arr_data; +} + + +?> \ No newline at end of file diff --git a/src/lib/db/database_functions_select.php b/src/lib/db/database_functions_select.php new file mode 100644 index 0000000..d118a5c --- /dev/null +++ b/src/lib/db/database_functions_select.php @@ -0,0 +1,50 @@ + \ No newline at end of file diff --git a/src/lib/db/database_functions_update.php b/src/lib/db/database_functions_update.php new file mode 100644 index 0000000..dc10d56 --- /dev/null +++ b/src/lib/db/database_functions_update.php @@ -0,0 +1,4 @@ + \ No newline at end of file diff --git a/src/lib/glob_vars.php b/src/lib/glob_vars.php new file mode 100755 index 0000000..a960196 --- /dev/null +++ b/src/lib/glob_vars.php @@ -0,0 +1,13 @@ + diff --git a/src/lib/gui/gui_functions_button.php b/src/lib/gui/gui_functions_button.php new file mode 100644 index 0000000..383c18d --- /dev/null +++ b/src/lib/gui/gui_functions_button.php @@ -0,0 +1,62 @@ + + * $ref_value_button Daten; null möglich + * $ref_html_button HTML zwischen ; null möglich + * $ref_id Id des \n"; + + if ($ref_p_flag) { + echo $intend; + echo "

    \n"; + } +} + + +?> \ No newline at end of file diff --git a/src/lib/gui/gui_functions_checkbox.php b/src/lib/gui/gui_functions_checkbox.php new file mode 100644 index 0000000..2c95fad --- /dev/null +++ b/src/lib/gui/gui_functions_checkbox.php @@ -0,0 +1,16 @@ +\n"; + +} + + +?> \ No newline at end of file diff --git a/src/lib/gui/gui_functions_input.php b/src/lib/gui/gui_functions_input.php new file mode 100644 index 0000000..45c4d88 --- /dev/null +++ b/src/lib/gui/gui_functions_input.php @@ -0,0 +1,90 @@ + + * $ref_value_input Daten; null möglich + * $ref_id Id des + * $ref_class Class des ; null möglich + * $ref_tabindex Tabindex in der + + * $ref_type -type (hidden, password, text ...) + * $ref_size Größe des Feldes + * $ref_maxlength Max. Größe der Eingabe + * $ref_javascript Javascript; null möglich + + * $ref_mandantory Pflichtfeldmarkierung; null möglich + * $ref_labeltitle