The users extension lets your site visitors register, login and logout, change their passwords and other information, and recover lost passwords. In the administrator it allows you to create, block and manage users and create user groups and access levels. Help
Please note that some of the user views will not display if you are not logged-in to the site.
Application 0.000 seconds (+0.000); 0.60 MB (+0.598) - afterLoadApplication 0.029 seconds (+0.029); 4.82 MB (+4.221) - afterInitialiseApplication 0.044 seconds (+0.015); 7.20 MB (+2.385) - afterRouteApplication 0.071 seconds (+0.026); 9.95 MB (+2.746) - afterDispatchApplication 0.088 seconds (+0.018); 10.73 MB (+0.777) - afterRender10.72 MB (11,244,640 Bytes)SELECT `data`
FROM `b3k8r_session`
WHERE `session_id` = '7teqo06r02g5r74ei4s1e18974'DELETE
FROM `b3k8r_session`
WHERE `time` < '1713294953'SELECT `session_id`
FROM `b3k8r_session`
WHERE `session_id` = '7teqo06r02g5r74ei4s1e18974'
LIMIT 0, 1INSERT INTO `b3k8r_session`
(`session_id`, `client_id`, `time`)
VALUES
('7teqo06r02g5r74ei4s1e18974', 0, '1713295853')SELECT extension_id AS id, element AS "option", params, enabled
FROM b3k8r_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM b3k8r_usergroups AS a
LEFT JOIN b3k8r_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `b3k8r_viewlevels`SELECT folder AS type, element AS name, params
FROM b3k8r_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM b3k8r_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SHOW TABLESSELECT file_id
from b3k8r_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2024-04-16 19:30:53'SELECT file_id
from b3k8r_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2024-04-16 19:30:53'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b3k8r_menu AS m
LEFT JOIN b3k8r_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT id, home, template, s.params
FROM b3k8r_template_styles as s
LEFT JOIN b3k8r_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SHOW TABLESSELECT extension_id AS id, element AS "option", params, enabled
FROM b3k8r_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM b3k8r_languages
WHERE published=1
ORDER BY ordering ASCSELECT a.rules
FROM b3k8r_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM b3k8r_assets AS a
LEFT JOIN b3k8r_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM b3k8r_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM b3k8r_content AS a
LEFT JOIN b3k8r_categories AS c
on c.id = a.catid
LEFT JOIN b3k8r_users AS u
on u.id = a.created_by
LEFT JOIN b3k8r_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b3k8r_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM b3k8r_categories AS cat JOIN b3k8r_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 52
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 19:30:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 19:30:53')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM b3k8r_categories as c
LEFT JOIN b3k8r_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM b3k8r_categories AS cat JOIN b3k8r_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=21
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftUPDATE b3k8r_content
SET hits = hits + 1
WHERE id = 52SHOW FULL COLUMNS
FROM `b3k8r_users`SELECT *
FROM `b3k8r_users`
WHERE `id` = 42SELECT `g`.`id`,`g`.`title`
FROM `b3k8r_usergroups` AS g
INNER JOIN `b3k8r_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 42SELECT extension_id AS id, element AS "option", params, enabled
FROM b3k8r_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM b3k8r_categories as c
LEFT JOIN b3k8r_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM b3k8r_categories AS cat JOIN b3k8r_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_contact'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=1
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftselect last_check_date
from b3k8r_digistore_settings
where id=1select last_check_date
from b3k8r_digistore_settings
where id=1select id
from b3k8r_digistore_plans
where duration_count=-1
and duration_type=0select id
from b3k8r_digistore_plans
where duration_count=-1
and duration_type=0select l.licenseid, l.userid, l.productid, l.purchase_date, l.expires, l.plan_id
from b3k8r_digistore_licenses l
where l.plan_id <> 6
and l.published = 1
order by id ascselect l.licenseid, l.userid, l.productid, l.purchase_date, l.expires, l.plan_id
from b3k8r_digistore_licenses l
where l.plan_id <> 6
and l.published = 1
order by id ascselect *
from b3k8r_digistore_plansselect *
from b3k8r_digistore_plansSELECT DISTINCT(`userid`)
FROM b3k8r_digistore_licenses
WHERE DATE(`expires`) = CURDATE()
AND `expires` < NOW()SELECT DISTINCT(`userid`)
FROM b3k8r_digistore_licenses
WHERE DATE(`expires`) = CURDATE()
AND `expires` < NOW()SHOW TABLESUPDATE `b3k8r_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713295853;s:18:\"session.timer.last\";i:1713295853;s:17:\"session.timer.now\";i:1713295853;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1713295853'
WHERE `session_id` = '7teqo06r02g5r74ei4s1e18974'4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM b3k8r_extensions2 × select last_check_date
from b3k8r_digistore_settings2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM b3k8r_categories as c
LEFT JOIN b3k8r_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM b3k8r_categories AS cat JOIN b3k8r_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT file_id
from b3k8r_jdownloads_files2 × select id
from b3k8r_digistore_plans2 × SELECT DISTINCT(`userid`)
FROM b3k8r_digistore_licenses2 × select *
from b3k8r_digistore_plan2 × select l.licenseid, l.userid, l.productid, l.purchase_date, l.expires, l.plan_id
from b3k8r_digistore_licenses l1 × SELECT *
FROM `b3k8r_users`1 × SELECT `g`.`id`,`g`.`title`
FROM `b3k8r_usergroups` AS g
INNER JOIN `b3k8r_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM b3k8r_contact_details AS contact1 × SELECT a.rules
FROM b3k8r_assets AS a1 × SELECT id, rules
FROM `b3k8r_viewlevels1 × SELECT b.id
FROM b3k8r_usergroups AS a
LEFT JOIN b3k8r_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `b3k8r_session`1 × SELECT folder AS type, element AS name, params
FROM b3k8r_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b3k8r_menu AS m
LEFT JOIN b3k8r_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `b3k8r_session`1 × SELECT *
FROM b3k8r_languages1 × SELECT id, home, template, s.params
FROM b3k8r_template_styles as s
LEFT JOIN b3k8r_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.rules
FROM b3k8r_assets AS a
LEFT JOIN b3k8r_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt3 × SHOW TABLE1 × UPDATE `b3k8r_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713295853;s:18:\"session.timer.last\";i:1713295853;s:17:\"session.timer.now\";i:1713295853;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;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:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1713295853'1 × SHOW FULL COLUMNS
FROM `b3k8r_users1 × UPDATE b3k8r_content
SET hits = hits + 11 × DELETE
FROM `b3k8r_session`1 × INSERT INTO `b3k8r_session` (`session_id`, `client_id`, `time`)
VALUES ('7teqo06r02g5r74ei4s1e18974', 0, '1713295853'