SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
DELETE
FROM jos_session
WHERE ( time < '1268279351' )
SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
UPDATE `jos_session`
SET `time`='1268280251',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:18;s:19:\"session.timer.start\";i:1268279880;s:18:\"session.timer.last\";i:1268280232;s:17:\"session.timer.now\";i:1268280243;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:2:{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:11:\"permissions\";a:1:{s:11:\"remosFolder\";a:1:{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:12:\"access_found\";a:1:{s:5:\"aUser\";a:1:{i:62;i:1268280187;}}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/Dini---Manevi/orderby,2/page,2') OR (`sefurl` = 'component/remository/Dini---Manevi/orderby,2/page,2/'))
AND (`origurl` != '')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'component/remository/Dini---Manevi/orderby,2/page,2') OR (`old` = 'component/remository/Dini---Manevi/orderby,2/page,2/')
SELECT *
FROM jos_downloads_repository
ORDER BY id
LIMIT 1
SELECT *
FROM jos_downloads_containers
ORDER BY sequence, name
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 count(*)
FROM jos_downloads_files AS f
WHERE f.containerid = 3
AND f.published=1
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count, 0 AS active_feature
FROM jos_downloads_files AS f
LEFT JOIN jos_downloads_log AS l
ON l.type=3
AND l.fileid=f.id
AND l.value != 0
WHERE f.containerid = 3
AND f.published=1
GROUP BY f.id
ORDER BY filetitle
LIMIT 10,10
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 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 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 f.id, f.containerid, f.filetitle, f.realname
FROM jos_downloads_files AS f
INNER JOIN jos_downloads_files AS f2
ON f.containerid = f2.containerid
WHERE f2.id = 211
SELECT *
FROM jos_users
WHERE id = '62'
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 = '3255'
SELECT role, access_id
FROM jos_assignments AS a
WHERE a.access_type='aUser'
AND a.access_id='3255'
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 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 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 = 3
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_ijseo_metags
WHERE id = 3
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_menu
WHERE home = '1'
ORDER BY ordering
LIMIT 1
