1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering2
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 2 )
ORDER BY menuid DESC
LIMIT 13
DELETE FROM jos_session
WHERE (
( time < '1729607582' )
AND guest = 0
AND gid > 0
) OR (
( time < '1729607582' )
AND guest = 1
AND userid = 0
)4
SELECT *
FROM jos_session
WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'5
UPDATE jos_session SET `time`='1729608482',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'6
SELECT *
FROM jos_menu
WHERE id = 27
SELECT *
FROM jos_puarcade_config
WHERE id = '1'8
Select id FROM jos_puarcade_games WHERE lower(gamename) = 'arkanoid_flash'9
Select title FROM jos_puarcade_games WHERE id = '20'10
select count(*) as count from jos_puarcade where gameid = 20 and published = 111
SELECT *
FROM jos_puarcade_config
WHERE id = '1'12
SELECT *
FROM jos_puarcade_config
WHERE id = '1'13
select c.id, c.name, c.description, c.imagename, c.minaccesslevelrequired, c.startdatetime as startdatetime , c.enddatetime as enddatetime from jos_puarcade_contest as c, jos_users as u where c.published = 1 and c.startdatetime <= now() and c.enddatetime >= now() and u.id = 0 and u.gid >= c.minaccesslevelrequired14
select c.id, c.name, c.description, c.imagename, c.minaccesslevelrequired, c.startdatetime as startdatetime , c.enddatetime as enddatetime from jos_puarcade_contest as c, jos_users as u where c.published = 1 and c.enddatetime <= now() and u.id = 0 and u.gid >= c.minaccesslevelrequired15
SELECT jos_puarcade_games.id,numplayed,jos_puarcade_games.description,jos_puarcade_games.imagename,jos_puarcade_games.published,gamename,title,reverse_score,scoring,numplayed,window,permissions,folderid FROM jos_puarcade_folders left join jos_puarcade_games on (jos_puarcade_folders.id = jos_puarcade_games.folderid) WHERE jos_puarcade_games.published = '1' and jos_puarcade_games.id = 2016
SELECT *
FROM jos_puarcade_config
WHERE id = '1'17
SELECT reverse_score FROM jos_puarcade_games WHERE id = '20'18
SELECT jos_puarcade.score,jos_puarcade.date,jos_puarcade.published,jos_puarcade_games.gamename,jos_users.id,jos_puarcade_games.title,jos_users.username FROM jos_puarcade left join jos_puarcade_games on (jos_puarcade.gameid = jos_puarcade_games.id) left join jos_users on (jos_users.id = jos_puarcade.userid) WHERE gameid = '20' AND jos_puarcade.published = '1' ORDER BY score DESC LIMIT 0,4019
Select id FROM jos_users WHERE username = 'Loser'20
Select id FROM jos_users WHERE username = 'Nobbi'21
Select id FROM jos_users WHERE username = 'Daukel'22
Select id FROM jos_users WHERE username = 'foxi'23
Select id FROM jos_users WHERE username = ''24
Select id FROM jos_users WHERE username = 'Mr.Heli'25
Select id FROM jos_users WHERE username = 'Totti'26
Select id FROM jos_users WHERE username = 'Philipp95'27
Select id FROM jos_users WHERE username = 'siebenschlaefer'28
Select id FROM jos_users WHERE username = ''29
Select id FROM jos_users WHERE username = 'Sandy'30
Select id FROM jos_users WHERE username = 'Noah'31
Select id FROM jos_users WHERE username = 'Tom'32
Select id FROM jos_users WHERE username = 'FlixXx'33
Select id FROM jos_users WHERE username = 'Josie'34
Select id FROM jos_users WHERE username = 'Lokemaster'35
Select id FROM jos_users WHERE username = 'Domy56'36
Select id FROM jos_users WHERE username = 'Nikki'37
Select id FROM jos_users WHERE username = 'Domy'38
Select id FROM jos_users WHERE username = 'Domy77'39
Select id FROM jos_users WHERE username = 'Städter'40
Select id FROM jos_users WHERE username = 'Thomas'41
Select id FROM jos_users WHERE username = '*Jacky*'42
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'43
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 2 )
ORDER BY ordering44
SELECT guest, usertype
FROM jos_session45
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE a.guest = 0 AND usertype <> 'Super Administrator'46
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering47
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 148
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=15'49
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=60'50
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 151
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=70'52
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=71'53
SELECT *
FROM jos_banner
WHERE showBanner=154
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 8
Datum
