Name der zu prüfenden Variablen = lDebug Wert der input_variable = 1 soll_typ = integer ist_typ = string soll_maximal_laenge = 0 Fall 1 Fall 3 STRING-Prüfung 0 String-Wert der input_variable = 1 1 String-Wert der input_variable = 1 2 String-Wert der input_variable = 1 3 String-Wert der input_variable = 1 Name der zu prüfenden Variablen = lDebug Wert der input_variable = 1 soll_typ = integer ist_typ = string soll_maximal_laenge = 0 Fall 1 Fall 3 STRING-Prüfung 0 String-Wert der input_variable = 1 1 String-Wert der input_variable = 1 2 String-Wert der input_variable = 1 3 String-Wert der input_variable = 1
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 357
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 2
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
Aufruf Headerbild ermitteln
query addHeaderImage: SELECT *
FROM geis23_mm_binaries b
JOIN geis23_navigation n ON b.b_version_id = n.n_local_banner_id
WHERE n.n_id = 2
headerimage pfad:
gefundenes headerimage:
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1168
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 928
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 80
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 915
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 69
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 4
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
Aufruf Headerbild ermitteln
query addHeaderImage: SELECT *
FROM geis23_mm_binaries b
JOIN geis23_navigation n ON b.b_version_id = n.n_local_banner_id
WHERE n.n_id = 4
headerimage pfad:
gefundenes headerimage:
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 98
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 23
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 119
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1098
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 41
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 149
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 205
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 40
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 42
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 99
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
Aufruf Headerbild ermitteln
query addHeaderImage: SELECT *
FROM geis23_mm_binaries b
JOIN geis23_navigation n ON b.b_version_id = n.n_local_banner_id
WHERE n.n_id = 99
headerimage pfad:
gefundenes headerimage:
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 3
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1097
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 243
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1105
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 200
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 333
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1147
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1132
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1169
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 54
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 400
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
Aufruf Headerbild ermitteln
query addHeaderImage: SELECT *
FROM geis23_mm_binaries b
JOIN geis23_navigation n ON b.b_version_id = n.n_local_banner_id
WHERE n.n_id = 400
headerimage pfad:
gefundenes headerimage:
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 279
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 837
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 877
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 77
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 7
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 335
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 250
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 59
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 821
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 216
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 759
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 914
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 125
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 5
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
Aufruf Headerbild ermitteln
query addHeaderImage: SELECT *
FROM geis23_mm_binaries b
JOIN geis23_navigation n ON b.b_version_id = n.n_local_banner_id
WHERE n.n_id = 5
headerimage pfad:
gefundenes headerimage:
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1103
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 46
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1146
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 82
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 127
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 47
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 847
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 562
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1163
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
query erzeuge_struktur: SELECT n_id, n_title, n_style, n_path, n_button_id, n_button_path
FROM geis23_navigation
WHERE n_parent_id = 1148
AND n_active_bool = 1
AND (n_gid_list = 0
OR n_gid_list = '')
AND n_style IN (56,57)
ORDER BY n_order_number
v_select_kategorie = SELECT DISTINCT KATEGORIE
FROM geis23_vereine
WHERE LENGTH(TRIM(KATEGORIE)) > 0
AND 6=6
ORDER BY UPPER(KATEGORIE)
mcounter_kategorie = 6
v_select_kategorie = SELECT DISTINCT KATEGORIE
FROM geis23_vereine
WHERE LENGTH(TRIM(KATEGORIE)) > 0
AND 6=6
ORDER BY UPPER(KATEGORIE)
sql_niceurl = SELECT objid,
navid
FROM geis23_slugs
WHERE slug LIKE ('vereine-geisenfeld-suchergebnisseite')
OR CONCAT('cms/',slug) LIKE ('vereine-geisenfeld-suchergebnisseite')
OR CONCAT('cms2/',slug) LIKE ('vereine-geisenfeld-suchergebnisseite')
v_select_mit_Suche = SELECT ID,
VEREINSNAME,
ANREDE,
TITEL,
VORSTANDSTITEL,
VORNAME,
NACHNAME,
STRASSE,
PLZ,
ORT,
ORTSTEILNAME,
TELEFON,
TELEFON2,
TELEFAX,
MOBIL,
EMAIL,
WEB,
RELATED_ARTIKEL,
VEREINSNAME_SORT,
BEMERKUNG,
KATEGORIE
FROM geis23_vereine
WHERE 1=1 AND 3=3 AND ( UPPER(VEREINSNAME) LIKE 'H%' OR UPPER(VEREINSNAME_SORT) LIKE 'H%')
AND 6=6
ORDER BY VEREINSNAME_SORT
mcounter_mit_Suche = 2
Tabelle mit den 2 Vereinen der Stadt Geisenfeld mit Anfangsbuchstaben H in alphabetischer Reihenfolge
