Debug-Info
Übergabeparameter (Request):
sql-Anfragen:
- SELECT group_id,module_id FROM {prefix}_groups_modules
- SELECT * FROM `{prefix}_modules`
- SELECT sesskey, expiry FROM {prefix}_sys_session WHERE sesskey = '4aa1c0cfb33c10791e0b557802cccf7e'
- DELETE FROM {prefix}_sys_session WHERE expiry < 1710847644
- SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.hooks'
- SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.themes'
- SELECT * FROM {prefix}_plugins ORDER BY type, position ASC
- SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='54.172.169.199'
- SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='Documents'
- SHOW TABLES LIKE '{prefix}_content%'
- SHOW COLUMNS FROM {prefix}_content
- SELECT * FROM {prefix}_content WHERE module_name='Documents' AND leftID=1 LIMIT 1
- SELECT p.* FROM {prefix}_content as n,{prefix}_content as p
WHERE p.module_name='Documents'
and n.module_name='Documents'
and n.id=1
and n.leftID BETWEEN p.leftID AND p.rightID
ORDER BY p.leftID asc
- SELECT p.* FROM {prefix}_content as p,{prefix}_content as n
WHERE n.module_name='Documents'
and p.module_name='Documents'
and n.id=1
and p.leftID < n.leftID
AND p.rightID >n.rightID
AND p.publish=1
AND p.leftID>1
ORDER BY p.leftID
- SELECT s.*,FLOOR((s.rightID-s.leftID)/2) AS childs ,count(*)+(v.leftID >1) AS level
FROM {prefix}_content AS s,{prefix}_content AS v
WHERE s.module_name='Documents' AND v.module_name='Documents'
AND s.leftID BETWEEN v.leftID AND v.rightID
AND s.id=1
AND s.leftID>1
- SELECT id FROM {prefix}_content where module_name='Documents' and id=1
- SET sql_mode=(SELECT REPLACE (@@sql_mode,'ONLY_FULL_GROUP_BY',''))
- SELECT s.id, s.parent_id, s.title, s.date_created, s.date_edit, s.owner_id, s.publish, s.access, s.language, s.text1, s.text2, s.info, s.link, s.leftID,
count(*)+(s.leftID >1) As level,
FLOOR((s.rightID-s.leftID)/2) as childs ,
((min(v.rightID)-s.rightID-(s.leftID >1))/2) > 0 AS lower,
(((s.leftID-max(v.leftID)>1))) AS upper ,
((min(v.leftID)>s.rightID)) AS upperid
from {prefix}_content as n,
{prefix}_content as v,
{prefix}_content as s
WHERE s.module_name='Documents'
AND v.module_name='Documents'
AND n.module_name='Documents'
AND n.id='1'
AND s.leftID >'1'
AND s.leftID BETWEEN v.leftID AND v.rightID
AND s.leftID BETWEEN n.leftID AND n.rightID
AND (v.id != s.id OR s.leftID = 1)
AND s.publish=1 AND s.language IN ('ALL','german') AND s.date_created<1710847644
GROUP BY s.leftID
ORDER by s.leftID
- SELECT p.id, p.title FROM {prefix}_content as n,{prefix}_content as p
WHERE p.module_name='Documents'
and n.module_name='Documents'
and n.id=1 and p.leftID>1
and n.leftID BETWEEN p.leftID AND p.rightID
ORDER BY p.leftID asc
- SELECT * ,FLOOR((rightID-leftID)/2) AS childs
FROM {prefix}_content
WHERE module_name='Documents'
AND leftID>1 AND publish=1 AND language IN ('ALL','german') AND date_created<1710847644
AND TRUE ORDER BY date_created DESC LIMIT 5
- SELECT id FROM {prefix}_content where module_name='Documents' and id=1
- SET sql_mode=(SELECT REPLACE (@@sql_mode,'ONLY_FULL_GROUP_BY',''))
- SELECT s.id, s.title, s.leftID,
count(*)+(s.leftID >1) As level,
FLOOR((s.rightID-s.leftID)/2) as childs ,
((min(v.rightID)-s.rightID-(s.leftID >1))/2) > 0 AS lower,
(((s.leftID-max(v.leftID)>1))) AS upper ,
((min(v.leftID)>s.rightID)) AS upperid
from {prefix}_content as n,
{prefix}_content as v,
{prefix}_content as s
WHERE s.module_name='Documents'
AND v.module_name='Documents'
AND n.module_name='Documents'
AND n.id='1'
AND s.leftID >'1'
AND s.leftID BETWEEN v.leftID AND v.rightID
AND s.leftID BETWEEN n.leftID AND n.rightID
AND (v.id != s.id OR s.leftID = 1)
GROUP BY s.leftID
ORDER by s.leftID
- SELECT p.* FROM {prefix}_content as p,{prefix}_content as n
WHERE n.module_name='Documents'
and p.module_name='Documents'
and n.id=1
and p.leftID < n.leftID
AND p.rightID >n.rightID
AND p.publish=1
AND p.leftID>1
ORDER BY p.leftID
- SELECT s.*,FLOOR((s.rightID-s.leftID)/2) AS childs ,count(*)+(v.leftID >1) AS level
FROM {prefix}_content AS s,{prefix}_content AS v
WHERE s.module_name='Documents' AND v.module_name='Documents'
AND s.leftID BETWEEN v.leftID AND v.rightID
AND s.id=1
AND s.leftID>1
- SELECT * ,FLOOR((rightID-leftID)/2) AS childs
FROM {prefix}_content
WHERE module_name='Documents'
AND leftID>1 AND publish=1 AND position>0 AND language IN ('ALL','german')
AND TRUE ORDER BY position asc
- select main_module from {prefix}_main
- SELECT m.title
FROM `{prefix}_modules` AS m LEFT JOIN {prefix}_groups_modules AS g
ON m.mid = g.module_id
WHERE ((m.title = 'News') OR (m.view = 0 AND m.active=1) OR (m.view = 3 AND m.active=1))
ORDER BY m.title ASC
- SELECT * FROM {prefix}_blocks
WHERE (active=1) AND (blanguage LIKE 'german%' OR blanguage = '') AND (position <> 'r') AND (position NOT IN('c','d')) AND NOT (position='r' AND blockfile LIKE('block-vkp_News_%') AND module='News') AND ((view = 0) OR (view = 3)) and position >''
ORDER BY position, weight ASC
- SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='wkadm'
- SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
- SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
- SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
- SELECT datum, zeit, nr, bez, comments, erglst_art, erg_erfasst, link2album, vid FROM `{prefix}_wka_veranstaltung` where link_datum='2023-09-24' and link_zeit = '10:00:00' and link_nr = '01' ORDER BY datum, zeit, nr
- SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
- SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
- SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
- SELECT datum, zeit, nr, bez, comments, erglst_art, erg_erfasst, link2album, vid FROM `{prefix}_wka_veranstaltung` where link_datum='2023-09-24' and link_zeit = '10:00:00' and link_nr = '01' ORDER BY datum, zeit, nr
- SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_one'
- SELECT `key`, `value`, `serialized`
FROM `{prefix}_sys_config`
WHERE `section`='pmx.seo'
- SELECT * FROM {prefix}_blocks WHERE blockfile='block-Menu.php' AND title='{TVE_MENU}' ORDER BY title ASC
- SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=20 ORDER BY pid,weight,id ASC