SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
DELETE
FROM jos_session
WHERE ( time < '1268279405' )
SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
UPDATE `jos_session`
SET `time`='1268280305',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1268279880;s:18:\"session.timer.last\";i:1268280278;s:17:\"session.timer.now\";i:1268280288;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:77:\"/home/diniegi1/public_html/ekitap.org/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"f1ca4c1d9f671fb300eef820f5018f2a\";}aliro_auth|a:5:{s:10:\"subj_found\";a:1:{s:11:\"remosFolder\";a:3:{s:8:\"download\";a:1:{s:1:\"*\";i:1268280204;}s:4:\"edit\";a:20:{s:1:\"*\";i:1268280204;i:1;i:1268280204;i:10;i:1268280204;i:11;i:1268280204;i:12;i:1268280204;i:13;i:1268280204;i:14;i:1268280204;i:15;i:1268280204;i:16;i:1268280204;i:17;i:1268280204;i:18;i:1268280204;i:19;i:1268280204;i:2;i:1268280204;i:3;i:1268280204;i:4;i:1268280204;i:5;i:1268280204;i:6;i:1268280204;i:7;i:1268280204;i:8;i:1268280204;i:9;i:1268280204;}s:6:\"upload\";a:20:{s:1:\"*\";i:1268280279;i:1;i:1268280279;i:10;i:1268280279;i:11;i:1268280279;i:12;i:1268280279;i:13;i:1268280279;i:14;i:1268280279;i:15;i:1268280279;i:16;i:1268280279;i:17;i:1268280279;i:18;i:1268280279;i:19;i:1268280279;i:2;i:1268280279;i:3;i:1268280279;i:4;i:1268280279;i:5;i:1268280279;i:6;i:1268280279;i:7;i:1268280279;i:8;i:1268280279;i:9;i:1268280279;}}}s:11:\"permissions\";a:1:{s:11:\"remosFolder\";a:2:{s:4:\"edit\";a:19:{i:1;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:10;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:11;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:12;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:13;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:14;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:15;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:16;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:17;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:18;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:19;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:2;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:3;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:4;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:5;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:6;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:7;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:8;a:1:{s:6:\"Nobody\";s:1:\"2\";}i:9;a:1:{s:6:\"Nobody\";s:1:\"2\";}}s:6:\"upload\";a:19:{i:1;a:1:{s:10:\"Registered\";s:1:\"2\";}i:10;a:1:{s:10:\"Registered\";s:1:\"2\";}i:11;a:1:{s:10:\"Registered\";s:1:\"2\";}i:12;a:1:{s:10:\"Registered\";s:1:\"2\";}i:13;a:1:{s:10:\"Registered\";s:1:\"2\";}i:14;a:1:{s:10:\"Registered\";s:1:\"2\";}i:15;a:1:{s:10:\"Registered\";s:1:\"2\";}i:16;a:1:{s:10:\"Registered\";s:1:\"2\";}i:17;a:1:{s:10:\"Registered\";s:1:\"2\";}i:18;a:1:{s:10:\"Registered\";s:1:\"2\";}i:19;a:1:{s:10:\"Registered\";s:1:\"2\";}i:2;a:1:{s:10:\"Registered\";s:1:\"2\";}i:3;a:1:{s:10:\"Registered\";s:1:\"2\";}i:4;a:1:{s:10:\"Registered\";s:1:\"2\";}i:5;a:1:{s:10:\"Registered\";s:1:\"2\";}i:6;a:1:{s:10:\"Registered\";s:1:\"2\";}i:7;a:1:{s:10:\"Registered\";s:1:\"2\";}i:8;a:1:{s:10:\"Registered\";s:1:\"2\";}i:9;a:1:{s:10:\"Registered\";s:1:\"2\";}}}}s:12:\"access_found\";a:1:{s:5:\"aUser\";a:5:{i:62;i:1268280187;i:3255;i:1268280252;i:3486;i:1268280262;i:3057;i:1268280262;i:3613;i:1268280262;}}s:12:\"access_roles\";a:0:{}s:5:\"timer\";i:1268280187;}'
WHERE session_id='f7394325c31421adcc5f268e2b36b610'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT id
FROM jos_core_acl_aro_groups
WHERE name = ''
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT *
FROM jos_sefurls
WHERE ((`sefurl` = 'component/remository/işletim-sistemleri/Windows-Problemlerinin-Cozumu.rar') OR (`sefurl` = 'component/remository/işletim-sistemleri/Windows-Problemlerinin-Cozumu.rar/'))
AND (`origurl` != '')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'component/remository/işletim-sistemleri/Windows-Problemlerinin-Cozumu.rar') OR (`old` = 'component/remository/işletim-sistemleri/Windows-Problemlerinin-Cozumu.rar/')
SELECT *
FROM jos_downloads_repository
ORDER BY id
LIMIT 1
SELECT *
FROM jos_downloads_containers
ORDER BY sequence, name
SELECT f.id, f.containerid, f.filetitle, f.realname
FROM jos_downloads_files AS f
WHERE f.containerid = 7
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT role, subject_id, action
FROM jos_permissions
WHERE subject_type = 'remosFolder'
AND action IN('download','edit')
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count
FROM jos_downloads_files AS f
LEFT JOIN jos_downloads_log AS l
ON l.type=3
AND l.fileid=f.id
WHERE f.id = 40
AND published=1
GROUP BY f.id
SELECT fileid, COUNT(fileid) AS number
FROM jos_downloads_log
WHERE type = 1
AND ipaddress = '38.107.191.85'
AND date > SUBDATE(NOW(), INTERVAL 24 HOUR)
GROUP BY fileid
SELECT id
FROM jos_downloads_files
WHERE (submitdate > '2009-09-11 07:38:43' OR ('2009-09-11 07:38:43' = submitdate
AND id < 40))
ORDER BY submitdate DESC, id DESC
LIMIT 1
SELECT id
FROM jos_downloads_files
WHERE (submitdate < '2009-09-11 07:38:43' OR ('2009-09-11 07:38:43' = submitdate
AND id > 40))
ORDER BY submitdate DESC, id
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_remository.xml'
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT *
FROM jos_users
WHERE id = '62'
SELECT c.id, c.title, c.comment, c.date, u.id AS userid, u.name, u.username
FROM jos_downloads_reviews AS c
INNER JOIN jos_users AS u
ON c.userid=u.id
WHERE c.itemid=40
SELECT c.*, CASE WHEN c.type = '' THEN 0 ELSE 9 END AS typseq
FROM jos_downloads_classify AS c
INNER JOIN jos_downloads_file_classify AS fc
ON c.id = fc.classify_id
WHERE c.published != 0
AND c.hidden = 0
AND fc.file_id = 40
ORDER BY typseq, c.name
SELECT menutype, id, name, link
FROM jos_menu
WHERE id = 0
AND link LIKE '%com_remository%'
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 40
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_ijseo_metags
WHERE id = 40
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_menu
WHERE home = '1'
ORDER BY ordering
LIMIT 1
