TV-Westfalia 07 Epe

GET:

• name => News
• topic => 3

1. SELECT group_id,module_id FROM {prefix}_groups_modules
2. SELECT * FROM `{prefix}_modules`
3. SELECT sesskey, expiry FROM {prefix}_sys_session WHERE sesskey = 'e296346ef3fdd1865e16156d5eeac639'
4. DELETE FROM {prefix}_sys_session WHERE expiry < 1702049727
5. DELETE FROM {prefix}_sys_session WHERE expiry < 1702049727
6. OPTIMIZE TABLE {prefix}_sys_session
7. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.hooks'
8. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.themes'
9. SELECT * FROM {prefix}_plugins ORDER BY type, position ASC
10. SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='34.228.52.21'
11. SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='News'
12. SELECT Count(sid) FROM {prefix}_stories AS s WHERE (s.alanguage LIKE 'german%' OR s.alanguage='') AND topic='3' AND (s.time <= now())
13. SELECT s.sid, s.informant, s.title, s.hometext, s.bodytext, s.comments, s.counter, s.notes, s.time, s.alanguage, s.acomm, s.aid, s.score, s.ratings, s.topic, t.topicname, t.topicimage, t.topictext, c.catid, c.title AS cattitle, a.url, a.email, u.uid, u.uname, u.user_viewemail FROM (({prefix}_stories AS s LEFT JOIN {prefix}_stories_cat AS c ON s.catid = c.catid) LEFT JOIN {prefix}_topics AS t ON s.topic = t.topicid) LEFT JOIN {prefix}_authors AS a ON s.aid = a.aid LEFT JOIN {prefix}_users AS u ON a.user_uid = u.uid WHERE (s.alanguage LIKE 'german%' OR s.alanguage='') AND topic='3' AND (s.time <= now()) ORDER BY s.time DESC, s.sid DESC LIMIT 0,6
14. select main_module from {prefix}_main
15. 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
16. SELECT * FROM {prefix}_blocks WHERE (active=1) AND (blanguage LIKE 'german%' OR blanguage = '') 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
17. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='wkadm'
18. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
19. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
20. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
21. 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
22. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
23. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
24. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
25. 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
26. SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_one'
27. SELECT pollID FROM `{prefix}_poll_desc` WHERE `artid` = 0 AND `pollactive` = 1 AND (planguage LIKE 'german%' OR planguage = '') ORDER BY `pollID` DESC LIMIT 1
28. SELECT * FROM `{prefix}_poll_desc` WHERE `pollID` = 1
29. SELECT optionText, optionCount, barcolor, voteID FROM `{prefix}_poll_data` WHERE `pollID` =1 AND `optionText` <> '' AND NOT ISNULL(`optionText`) ORDER BY voteID
30. SELECT COUNT(pollID) FROM `{prefix}_pollcomments` WHERE `pollID`=1
31. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.seo'
32. SHOW TABLES LIKE '{prefix}_content%'
33. SHOW COLUMNS FROM {prefix}_content
34. SELECT * FROM {prefix}_content WHERE module_name='Documents' AND leftID=1 LIMIT 1
35. SELECT id FROM {prefix}_content where module_name='Documents' and id=1
36. SET sql_mode=(SELECT REPLACE (@@sql_mode,'ONLY_FULL_GROUP_BY',''))
37. SELECT s.id, s.title, s.text1, 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 GROUP BY s.leftID ORDER by s.leftID
38. SELECT * FROM {prefix}_blocks WHERE blockfile='block-Menu.php' AND title='{TVE_MENU}' ORDER BY title ASC
39. SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=20 ORDER BY pid,weight,id ASC