| Query | Stack |
|---|
| Connection successfully | D:\nall-chan.net\www.neo-ami.net\data\_localdb.php call __construct from \inc\_main.inc call include from \register.php 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 |
| INSERT INTO user_online (user_id, uin, expire, ip, browser) VALUES (?,?,?,?,?) | \inc\MySQL\_session.inc call prepare from \inc\_session.inc call CreateSession from \inc\_session.inc call Session\usr_session_start |
| 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 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.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 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 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 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 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 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 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 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 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 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 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\_nafs.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\_nafs.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\_nafs.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\_nafs.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\_nafs.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\_nafs.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 files.file_id as id, ausgabe.ausgabe_jahr as jahr 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\_layout.inc call query from \inc\_layout.inc call GetLastImpressum from \inc\_layout.inc call GetLastImpressum |
| SELECT filename FROM nafs_files WHERE file_id = ? | \inc\MySQL\_nafs.inc call prepare from \inc\_nafs.inc call FileIdToName from \inc\_layout.inc call NaFS\GetUrlFromFileId |
| 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\_nafs.inc call NaFS\GetParentFolderId |
| 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 * FROM user_setting_typ ORDER BY sort | \inc\MySQL\_UserAccess.inc call query from \inc\_UserData.inc call GetAllSettings from \register.php call UserData\PrintForm |
