| Query | Stack |
|---|
| Connection successfully | D:\nall-chan.net\www.neo-ami.net\data\_localdb.php call __construct from \inc\_main.inc call include from \inc\_ausgaben.inc call include |
| DELETE FROM user_online WHERE expire < ? | \inc\MySQL\_session.inc call prepare from \inc\_session.inc call DeleteExpiredSessions from \inc\_main.inc call Session\KillExpireSessions |
| SELECT sett.setting_value as setting_value, typ.value_typ as settings_typ FROM user_settings as sett left join user_setting_typ as typ using (setting_typ_id) WHERE sett.user_id = ? and typ.setting_typ = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call GetSettingValue from \inc\_session.inc call User\GetSetting |
| UPDATE user_online SET expire = ?, uri = ? WHERE uin = ? | \inc\MySQL\_session.inc call prepare from \inc\_session.inc call UpdateSession from \inc\_session.inc call Session\UpdateSession |
| SELECT url, titel FROM nafs_server WHERE url = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetServerByUrl from \inc\_main.inc call NaFS\Init |
| SELECT file_id FROM nafs_files WHERE filename = ? AND ordner_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call FileNameToId from \inc\_main.inc call NaFS\Init |
| SELECT std_action as action FROM nafs_files as file WHERE file_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetFileStdAction from \inc\_nafs.inc call NaFS\CheckFileRights |
| SELECT concat_ws('',pro.action_prefix,action.action) as useraction, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE action.file_id = ? AND action.action = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetProjectFileDataFromAction from \inc\_nafs.inc call NaFS\CheckFileRights |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_nafs.inc call User\CheckAccess |
| SELECT file_id FROM nafs_files WHERE filename = ? AND ordner_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call FileNameToId from \inc\_main.inc call NaFS\Init |
| SELECT std_action as action FROM nafs_files as file WHERE file_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetFileStdAction from \inc\_nafs.inc call NaFS\CheckFileRights |
| SELECT concat_ws('',pro.action_prefix,action.action) as useraction, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE action.file_id = ? AND action.action = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetProjectFileDataFromAction from \inc\_nafs.inc call NaFS\CheckFileRights |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_nafs.inc call User\CheckAccess |
| SELECT nav.name AS name, nav.img_id AS img_id, nav.img_alt as img_alt, file.filename as filename, file.file_beschreibung as titel, action.file_action_titel as beschreibung, concat_ws('', projekt.action_prefix, file.std_action) as useraction FROM nafs_top_nav AS nav LEFT JOIN nafs_files AS file USING (file_id) LEFT JOIN nafs_projekt AS projekt USING (projekt_id) LEFT JOIN nafs_action AS action ON (file.file_id = action.file_id AND file.std_action = action.action) ORDER BY nav.sort | \inc\MySQL\_nafs.inc call query from \inc\_layout.inc call GetTopNavigationData from \inc\_main.inc call parse_top_nav_bar |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access)!=0 as access from user_user as usr left join user_useraccess using (user_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByUser from \inc\_layout.inc call User\CheckAccess |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_layout.inc call User\CheckAccess |
| SELECT vars_sql_query, vars_type FROM nacode_vars WHERE vars_name = ? | \inc\MySQL\_nacode.inc call prepare from \inc\_na_code.inc call GetVariableCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT concat('Ausgabe ',ausgabe.ausgabe_text) as val FROM ausgaben_ausgabe as ausgabe LEFT JOIN nafs_files as files ON ausgabe.folder_id=files.file_id WHERE files.std_action='view' ORDER BY ausgabe.ausgabe_nr DESC LIMIT 0,1 | \inc\MySQL\_nacode.inc call query from \inc\_na_code.inc call ExecuteVariableSQLCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT vars_sql_query, vars_type FROM nacode_vars WHERE vars_name = ? | \inc\MySQL\_nacode.inc call prepare from \inc\_na_code.inc call GetVariableCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT artikel.titel as val FROM ausgaben_ausgabe as ausgabe LEFT JOIN ausgaben_artikel as artikel USING (ausgabe_id) LEFT JOIN ausgaben_rubrik as rubrik USING (rubrik_id) LEFT JOIN nafs_files as files ON ausgabe.folder_id=files.file_id WHERE files.std_action='view' AND rubrik.ext='ti' ORDER BY ausgabe.ausgabe_nr DESC LIMIT 0,1 | \inc\MySQL\_nacode.inc call query from \inc\_na_code.inc call ExecuteVariableSQLCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT file.ordner_id as ordner_id, file.filename as filename, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE file.file_id = ? AND action.action = file.std_action | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetProjectFileDataDefaultAction from \inc\_layout.inc call NaFS\GetParentFolderId |
| SELECT file.ordner_id as ordner_id, file.filename as filename, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE file.file_id = ? AND action.action = file.std_action | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetProjectFileDataDefaultAction from \inc\_layout.inc call NaFS\GetParentFolderId |
| SELECT file.ordner_id as ordner_id, file.filename as filename, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE file.file_id = ? AND action.action = file.std_action | \inc\MySQL\_nafs.inc call prepare from \inc\_layout.inc call GetProjectFileDataDefaultAction from \inc\_main.inc call parse_bot_nav_bar |
| SELECT file.filename as filename, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel, concat_ws('', pro.action_prefix, file.std_action) as useraction FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using(projekt_id) WHERE file.ordner_id = ? AND action.action = file.std_action AND file.file_sort !=0 ORDER BY file.file_sort | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetFileListOfFolderId from \inc\_layout.inc call NaFS\GetFilelist |
| SELECT count(acc.access) != 0 as access from user_user as usr left join user_usertogroup using (user_id) left join user_groupaccess using (group_id) left join user_access as acc using (access_id) WHERE usr.user_id = ? and acc.access = ? | \inc\MySQL\_UserAccess.inc call prepare from \inc\_UserAccess.inc call CheckAccessByGroup from \inc\_nafs.inc call User\CheckAccess |
| SELECT file.ordner_id as ordner_id, file.filename as filename, action.file_action_titel as file_beschreibung, file.file_beschreibung as file_titel FROM nafs_action as action left join nafs_files as file using (file_id) left join nafs_projekt as pro using (projekt_id) WHERE file.file_id = ? AND action.action = file.std_action | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call GetProjectFileDataDefaultAction from \inc\_ausgaben.inc call NaFS\GetParentFolderId |
| SELECT ausgabe_id FROM ausgaben_ausgabe WHERE folder_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetMagazineIdByFolderId from \index.php call include |
| CREATE TEMPORARY TABLE tmp1 (page_nr INT AUTO_INCREMENT NOT NULL PRIMARY KEY) SELECT artikel.artikel_id AS artikel_id, page.page_id AS page_id FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_pages AS page USING (artikel_id) WHERE artikel.ausgabe_id = ? ORDER BY artikel.sort, page.sort | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call CreateTempPageTableByMagazineId from \index.php call include |
| SELECT count(artikel.ausgabe_id) as pages FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_pages AS page USING (artikel_id) WHERE artikel.ausgabe_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetMagazinePages from \index.php call include |
| SELECT tmp1.page_nr AS page_nr FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_rubrik AS rubrik USING (rubrik_id) RIGHT JOIN tmp1 ON artikel.artikel_id = tmp1.artikel_id WHERE rubrik.ext = ? ORDER BY tmp1.page_id LIMIT 0,1 | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetPageNrFromTempPageTableByCategory from \index.php call include |
| SELECT artikel.artikel_id AS artikel_id, page.page_id AS page_id FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_pages AS page USING (artikel_id) WHERE artikel.ausgabe_id = ? ORDER BY artikel.sort, page.sort LIMIT ?,1 | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetArtikelAndPageIdFromPageNr from \index.php call include |
| SELECT artikel.artikel_id as artikel_id, artikel.titel as titel, artikel.beititel as beititel, artikel.beschreibung as beschreibung, artikel.keywords as keywords, artikel.css_filename as css_filename, rubrik.ext as rubrik FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_rubrik AS rubrik USING(rubrik_id) WHERE artikel.artikel_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetArtikelDataById from \index.php call include |
| SELECT * FROM ausgaben_ausgabe WHERE ausgabe_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetAusgabeData from \index.php call include |
| SELECT filename FROM nafs_files WHERE file_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_ausgaben.inc call FileIdToName from \index.php call include |
| SELECT redak.kuerzel as kuerzel, redak.vorname as vorname, redak.name as name FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_autoren as autoren USING (artikel_id) LEFT JOIN user_redaktion as redak USING (redak_id) WHERE artikel.artikel_id = ? ORDER BY autoren.sort | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetAutorenByArtikelId from \index.php call include |
| SELECT artikel_id, pages_bg_filename as filename FROM ausgaben_pages WHERE page_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetBackgroundByPageId from \index.php call include |
| SELECT tmp1.page_nr AS page_nr, artikel.titel as titel, artikel.beschreibung as beschreibung FROM ausgaben_artikel AS artikel LEFT JOIN tmp1 USING (artikel_id) WHERE tmp1.page_nr IS NOT NULL group by artikel.artikel_id ORDER BY tmp1.page_nr | \inc\MySQL\_magazine.inc call query from \inc\_ausgaben.inc call GetArtikelOverviewFromTempPageTable from \index.php call include |
| SELECT vars_sql_query, vars_type FROM nacode_vars WHERE vars_name = ? | \inc\MySQL\_nacode.inc call prepare from \inc\_na_code.inc call GetVariableCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT vars_sql_query, vars_type FROM nacode_vars WHERE vars_name = ? | \inc\MySQL\_nacode.inc call prepare from \inc\_na_code.inc call GetVariableCode from \inc\_layout.inc call NaCode\get_na_var |
| SELECT count(usron.user_id) as usernum FROM user_online as usron | \inc\MySQL\_layout.inc call query from \inc\_layout.inc call GetOnlineUsers from \inc\_main.inc call print_start |
| SELECT artikel.titel, artikel.beititel, rubrik.sort, artikel.sort AS artikel_sort, count(page.artikel_id) AS pages FROM ausgaben_pages AS page LEFT JOIN ausgaben_artikel AS artikel USING(artikel_id) LEFT JOIN ausgaben_rubrik AS rubrik USING(rubrik_id) WHERE artikel.ausgabe_id = ? GROUP BY page.artikel_id ORDER BY artikel_sort | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetTableOfContent from \index.php call include |
| SELECT rubrik.sort, rubrik.name, rubrik.f_color_head, rubrik.b_color_head FROM ausgaben_artikel AS artikel LEFT JOIN ausgaben_rubrik AS rubrik USING(rubrik_id) WHERE artikel.ausgabe_id = ? GROUP BY rubrik.sort ORDER BY rubrik.sort | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetMagazineCategories from \index.php call include |
| SELECT pages_artikel, artikel_id FROM ausgaben_pages WHERE page_id = ? | \inc\MySQL\_magazine.inc call prepare from \inc\_ausgaben.inc call GetPageTextByPageId from \inc\_ausgaben.inc call GetPageText |
| SELECT nacode.regex_find as 'find', nacode.regex_replace as 'replace' FROM nafs_projekt LEFT JOIN nacode_to_projekt USING(projekt_id) LEFT JOIN nacode_regex_to_html as nacode USING(regex_id) WHERE nafs_projekt.action_prefix = ? | \inc\MySQL\_nacode.inc call prepare from \inc\_na_code.inc call GetRegExToHTML from \inc\_ausgaben.inc call NaCode\convert_nacode_to_html_display |
| DROP TABLE tmp1 | \inc\MySQL\_magazine.inc call query from \inc\_ausgaben.inc call DropTempPageTableFromMagazine from \index.php call include |
