TV-Westfalia 07 Epe

GET:

• name => WKAdm
• op => sErg/erg/list
• s_vid => 2017092402

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 = '346de4db768f2386ba6c7c6bb5b24cb9'
4. DELETE FROM {prefix}_sys_session WHERE expiry < 1702049261
5. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.hooks'
6. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.themes'
7. SELECT * FROM {prefix}_plugins ORDER BY type, position ASC
8. SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='34.228.52.21'
9. SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='WKAdm'
10. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='wkadm'
11. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
12. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
13. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
14. 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
15. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
16. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
17. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
18. 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
19. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2017092402
20. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
21. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
22. SELECT datum, zeit, nr, bez, comments, erglst_art, erg_erfasst, link2album, vid FROM `{prefix}_wka_veranstaltung` where link_datum='2017-09-24' and link_zeit = '15:00:00' and link_nr = '02' ORDER BY datum, zeit, nr
23. UPDATE `{prefix}_wka_veranstaltung` SET viewcount=viewcount+1 where datum='2017-09-24' AND zeit='15:00:00' AND nr='02'
24. SELECT * FROM `{prefix}_wkas_gesamt` as e LEFT OUTER JOIN `{prefix}_wka_teilnehmer` AS t ON e.sges_t_id = t.t_id WHERE sges_s_vid = 2017092402 AND (t_name like '%%' OR t_vorname like '%%' OR t_verein like '%%' OR sges_a_klasse like '%%' ) AND sges_wertung = 1 ORDER BY sges_a_klasse, sges_wertungplatz
25. select main_module from {prefix}_main
26. 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
27. 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
28. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
29. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
30. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
31. 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
32. SELECT * , EXTRACT(YEAR FROM datum) as v_jahr FROM `{prefix}_wka_veranstaltung` WHERE vid=2023092401
33. SELECT * FROM `{prefix}_wka_verein` WHERE v_id='TV-EPE'
34. SELECT COUNT(*) FROM `{prefix}_wka_teilnehmer` WHERE t_verein = 'TV-EPE'
35. 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
36. SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_one'
37. SELECT pollID FROM `{prefix}_poll_desc` WHERE `artid` = 0 AND `pollactive` = 1 AND (planguage LIKE 'german%' OR planguage = '') ORDER BY `pollID` DESC LIMIT 1
38. SELECT * FROM `{prefix}_poll_desc` WHERE `pollID` = 1
39. SELECT optionText, optionCount, barcolor, voteID FROM `{prefix}_poll_data` WHERE `pollID` =1 AND `optionText` <> '' AND NOT ISNULL(`optionText`) ORDER BY voteID
40. SELECT COUNT(pollID) FROM `{prefix}_pollcomments` WHERE `pollID`=1
41. SELECT `key`, `value`, `serialized` FROM `{prefix}_sys_config` WHERE `section`='pmx.seo'
42. SELECT * FROM {prefix}_blocks WHERE blockfile='block-Menu.php' AND title='{TVE_MENU}' ORDER BY title ASC
43. SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=20 ORDER BY pid,weight,id ASC