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 = 56 )
ORDER BY menuid DESC
LIMIT 13
DELETE FROM jos_session
WHERE (
( time < '1729607578' )
AND guest = 0
AND gid > 0
) OR (
( time < '1729607578' )
AND guest = 1
AND userid = 0
)4
SELECT *
FROM jos_session
WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'5
UPDATE jos_session SET `time`='1729608478',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'6
SELECT *
FROM jos_menu
WHERE id = 567
SELECT *
FROM jos_puarcade_config
WHERE id = '1'8
select c.id, c.name, c.description, c.imagename, c.minaccesslevelrequired, c.startdatetime as startdatetime , c.enddatetime as enddatetime, c.hasadvertisedstarted as hasadvertisedstarted, c.hasadvertisedended as hasadvertisedended ,'ENDED' as conteststate from jos_puarcade_contest as c where c.published = 1 AND ( c.enddatetime <= now() and c.hasadvertisedended = 0 ) UNION select c.id, c.name, c.description, c.imagename, c.minaccesslevelrequired, c.startdatetime as startdatetime , c.enddatetime as enddatetime, c.hasadvertisedstarted as hasadvertisedstarted, c.hasadvertisedended as hasadvertisedended ,'STARTED' as conteststate from jos_puarcade_contest as c where c.published = 1 AND ( c.startdatetime <= now() and c.hasadvertisedstarted = 0 ) ORDER BY conteststate DESC9
SELECT *
FROM jos_puarcade_games
WHERE id = '22'10
SELECT *
FROM jos_puarcade_config
WHERE id = '1'11
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 = 2212
SELECT numplayed FROM jos_puarcade_games WHERE id = '22'13
UPDATE jos_puarcade_games SET numplayed = '4189' WHERE id = '22'14
SELECT *
FROM jos_puarcade_config
WHERE id = '1'15
SELECT parentid
FROM jos_puarcade_folders
WHERE id = '10000'16
SELECT name
FROM jos_puarcade_folders
WHERE id = '10000'17
SELECT *
FROM jos_puarcade_config
WHERE id = '1'18
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.minaccesslevelrequired19
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.minaccesslevelrequired20
SELECT *
FROM jos_puarcade_config
WHERE id = '1'21
Select COUNT(*) FROM jos_puarcade WHERE gameid = '22' AND published = 122
SELECT *
FROM jos_puarcade_config
WHERE id = '1'23
SELECT reverse_score FROM jos_puarcade_games WHERE id = '22'24
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 = '22' AND jos_puarcade.published = '1' ORDER BY score DESC LIMIT 0,1025
Select id FROM jos_users WHERE username = 'foxi'26
Select id FROM jos_users WHERE username = 'Mr.Heli'27
Select id FROM jos_users WHERE username = 'FlixXx'28
Select id FROM jos_users WHERE username = 'Loser'29
Select id FROM jos_users WHERE username = ''30
Select id FROM jos_users WHERE username = 'Daukel'31
Select id FROM jos_users WHERE username = 'Domy'32
Select id FROM jos_users WHERE username = 'Nobbi'33
Select id FROM jos_users WHERE username = 'Totti'34
Select id FROM jos_users WHERE username = 'Philipp95'35
SELECT id FROM `jos_menu` WHERE link LIKE '%com_puarcade%' AND published=136
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'37
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 = 56 )
ORDER BY ordering38
SELECT guest, usertype
FROM jos_session39
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE a.guest = 0 AND usertype <> 'Super Administrator'40
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering41
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 142
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=15'43
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=60'44
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 145
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=70'46
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=71'47
SELECT *
FROM jos_puarcade_config
WHERE id = '1'48
select count(*) as count, p.userid as userid ,username from
( select f.userid as userid, f.gameid as gameid
from (
select gameid, max(score) as maxscore
from jos_puarcade group by gameid
) as x inner join jos_puarcade as f on f.gameid= x.gameid and f.score = x.maxscore order by f.gameid ) as p LEFT JOIN jos_users on (p.userid = jos_users.id) group by p.userid order by count DESC limit 949
Select id FROM jos_users WHERE username = 'Loser'50
Select id FROM jos_users WHERE username = 'Nobbi'51
Select id FROM jos_users WHERE username = 'Daukel'52
Select id FROM jos_users WHERE username = 'siebenschlaefer'53
Select id FROM jos_users WHERE username = 'Totti'54
Select id FROM jos_users WHERE username = 'Sandy'55
Select id FROM jos_users WHERE username = 'Domy'56
Select id FROM jos_users WHERE username = 'foxi'57
SELECT *
FROM jos_puarcade_config
WHERE id = '1'58
SELECT * FROM jos_puarcade WHERE published = 1 ORDER BY jos_puarcade.date DESC LIMIT 559
Select username from jos_users where id LIKE '260'60
Select title from jos_puarcade_games where id LIKE '16'61
Select username from jos_users where id LIKE '106'62
Select title from jos_puarcade_games where id LIKE '100'63
Select username from jos_users where id LIKE '260'64
Select title from jos_puarcade_games where id LIKE '1'65
Select username from jos_users where id LIKE '260'66
Select title from jos_puarcade_games where id LIKE '60'67
Select title from jos_puarcade_games where id LIKE '50'68
SELECT *
FROM jos_banner
WHERE showBanner=169
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5
Datum
