Follow Remository on Bluesky  Follow Remository and UserPoints on Bluesky so we can tell you about every new release

This is the home of Remository, a powerful file repository extension for Joomla! Now also UserPoints, the radically updated successor to the popular Alpha User Points.

Incentives

With all the work done on UserPoints it seemed time to use it here. You can introduce people to the Remository site. While logged in, look for the link to UserPoints Invitation in the main menu and fill in the details. Or just look at your own UserPoints Profile and copy the referral link. If your referral results in a new user, you will be credited with 0.5 points. But if the new user signs up for an All Software, Support and Upgrades plan another 9.5 points will be added to your account. Each point is worth a dollar that you can use to pay for your own subscription. Spread the word!

UserPoints

It has been exciting to see UserPoints in action. It started out based on the old Alpha User Points, via the Alta variant. The features are similar, although with some additions. The code has been radically overhauled. Not just to make it compliant with any of Joomla 3.10.x or 4.x or 5.x but also to make it more efficient and more maintainable. 

Additions include allowing users to buy points (using the complementary free Payage payment handler), a built in rule to incentivise logins, the possibility of buying Membership Pro subscriptions using points, and integration with Remository. 

Standard features include the creation of coupons that can be converted to points, rewards for inviting new members. You can award a bonus or add custom points to a user, and add incentives to do with the articles on your site. Integrations exist for other Joomla extensions - if there is something you particularly want, contact us to see if we can handle it.

The software is looking robust now, but while development is still going on at a rapid pace, UserPoints is available for a bargain price of only $5!

New Remository interface, new features

Remository has been developed over a number of years. But it has undergone a big overhaul. It retains rich functionality, but now has a new, modern user interface. Recently added features in the current version are:

  • Terrific new interfaces, both client side and admin side
  • A fully integrated comment facility
  • All screens support template overrides for customisation
  • New language files also support overrides
  • Control of the configuration through "Options"
  • Integration with UserPoints (coming very soon)

Familiar features:

  • Structure your file repository in folders, nested to any depth you like
  • Store files in the file system, the database or Amazon AWS
  • Flexible, easy to use role based access control system

Remository as Joomla Update Server

The new Remository can be used as a Joomla Update Server. Its powerful role based access controls limit who can get updates, and can be combined with products such as Membership Pro. A pairing like this provides the tools for anyone selling downloads by subscription. Or you can set prices for Remository files and require UserPoints to pay for them - points can be bought for cash if desired.

New File Storage for Remository

Remository has long provided database storage for the files in the repository. This gives excellent security, since the files do not exist in the file system, and so cannot be directly used for any exploit. It also allows Remository to be migrated to another server entirely by moving the database tables. Now, in a further innovation, Remository offers file storage using Amazon S3. This can overcome hosting limitations. It also means that files from the repository are delivered by Amazon at lightning speed, with no overhead on the web server running Remository. Other storage options will be developed if there is a demand for them.

Traditional Remository Features

  • Files can be arranged in folders (or containers) that can be nested to any depth you need.
  • Each folder has independent access controls, separately for uploads, downloads, editing and auto-approve. The controls allow for any combination of user groups to have each permission.
  • Fast and efficient searching of the file repository, on either the file titles or the descriptions, or both.
  • Text descriptions for both folders and files
  • Optional user ratings for files, as well as the comment system
  • A selection of modules to give information about the repository such as newest files
  • Plugins including Quickdown - a plugin that allows information from the repository to be inserted into articles
  • Optional thumbnail images for files, with larger popups of the image
  • Numerous configuration options

Support Services

Subscribers have access to professional support services, backed by a ticket system and the ability to raise questions.

Is there anything we can help you with in this morning ?

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

3.534MBMemory Usage537msRequest Duration
Joomla! Version5.2.2
PHP Version8.2.26
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.6-MariaDB-0+deb12u1-log
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:2 [ "aliro_auth" => array:5 [ "subj_found" => & [] "permissions" => & [] "access...
$_COOKIE
[]
$_SERVER
array:51 [ "USER" => "remos" "HOME" => "/var/www/remos" "SCRIPT_NAME" => "/index.php" "REQUE...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1736232069 "last" => 1736232069...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
gtag
false
  • afterLoad (73.79KB) (5.95ms)
  • afterInitialise (1.01MB) (109ms)
  • afterRoute (148.25KB) (44.48ms)
  • beforeRenderComponent com_content (118.27KB) (16.55ms)
  • Before Access::preloadComponents (all components) (44.21KB) (8.82ms)
  • After Access::preloadComponents (all components) (122.09KB) (31.7ms)
  • Before Access::preloadPermissions (com_content) (424B) (56μs)
  • After Access::preloadPermissions (com_content) (10.01KB) (7.16ms)
  • Before Access::getAssetRules (id:106 name:com_content.article.1) (744B) (50μs)
  • After Access::getAssetRules (id:106 name:com_content.article.1) (8.16KB) (179μs)
  • Before Access::getAssetRules (id:1 name:root.1) (342.82KB) (71.79ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (56μs)
  • afterRenderComponent com_content (655.42KB) (140ms)
  • afterDispatch (2.27KB) (361μs)
  • beforeRenderRawModule mod_menu (Main Menu) (60.07KB) (22.38ms)
  • afterRenderRawModule mod_menu (Main Menu) (91.61KB) (3.53ms)
  • beforeRenderRawModule mod_login (Login Form) (976B) (52μs)
  • afterRenderRawModule mod_login (Login Form) (50.81KB) (1.79ms)
  • beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (45μs)
  • afterRenderRawModule mod_remositorytree (Explore Repository) (73.05KB) (19.81ms)
  • beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (467μs)
  • afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (43.53KB) (1.2ms)
  • beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (13μs)
  • afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (6.06KB) (1.42ms)
  • beforeRenderModule mod_menu (Main Menu) (12.26KB) (179μs)
  • afterRenderModule mod_menu (Main Menu) (4.69KB) (202μs)
  • beforeRenderModule mod_login (Login Form) (640B) (23μs)
  • afterRenderModule mod_login (Login Form) (6.47KB) (97μs)
  • beforeRenderModule mod_remositorytree (Explore Repository) (5.36KB) (21μs)
  • afterRenderModule mod_remositorytree (Explore Repository) (4.98KB) (80μs)
  • beforeRenderRawModule mod_custom (Twitter follow me) (6.91KB) (99μs)
  • afterRenderRawModule mod_custom (Twitter follow me) (3.94KB) (463μs)
  • beforeRenderModule mod_custom (Twitter follow me) (720B) (7μs)
  • afterRenderModule mod_custom (Twitter follow me) (4.13KB) (133μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.4KB) (69μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.36KB) (586μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.75KB) (123μs)
  • afterRender (223.18KB) (46.28ms)
  • 1 x afterRenderComponent com_content (655.42KB) (26.06%)
    140ms
    1 x afterInitialise (1.01MB) (20.34%)
    109ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (342.82KB) (13.38%)
    71.79ms
    1 x afterRender (223.18KB) (8.62%)
    46.28ms
    1 x afterRoute (148.25KB) (8.29%)
    44.48ms
    1 x After Access::preloadComponents (all components) (122.09KB) (5.91%)
    31.70ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (60.07KB) (4.17%)
    22.38ms
    1 x afterRenderRawModule mod_remositorytree (Explore Repository) (73.05KB) (3.69%)
    19.81ms
    1 x beforeRenderComponent com_content (118.27KB) (3.09%)
    16.55ms
    1 x Before Access::preloadComponents (all components) (44.21KB) (1.64%)
    8.82ms
    1 x After Access::preloadPermissions (com_content) (10.01KB) (1.34%)
    7.16ms
    1 x afterLoad (73.79KB) (1.11%)
    5.95ms
    1 x afterRenderRawModule mod_menu (Main Menu) (91.61KB) (0.66%)
    3.53ms
    1 x afterRenderRawModule mod_login (Login Form) (50.81KB) (0.33%)
    1.79ms
    1 x afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (6.06KB) (0.26%)
    1.42ms
    1 x afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (43.53KB) (0.22%)
    1.20ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.36KB) (0.11%)
    586μs
    1 x beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (0.09%)
    467μs
    1 x afterRenderRawModule mod_custom (Twitter follow me) (3.94KB) (0.09%)
    463μs
    1 x afterDispatch (2.27KB) (0.07%)
    361μs
    1 x afterRenderModule mod_menu (Main Menu) (4.69KB) (0.04%)
    202μs
    1 x beforeRenderModule mod_menu (Main Menu) (12.26KB) (0.03%)
    179μs
    1 x After Access::getAssetRules (id:106 name:com_content.article.1) (8.16KB) (0.03%)
    179μs
    1 x afterRenderModule mod_custom (Twitter follow me) (4.13KB) (0.02%)
    133μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.75KB) (0.02%)
    123μs
    1 x beforeRenderRawModule mod_custom (Twitter follow me) (6.91KB) (0.02%)
    99μs
    1 x afterRenderModule mod_login (Login Form) (6.47KB) (0.02%)
    97μs
    1 x afterRenderModule mod_remositorytree (Explore Repository) (4.98KB) (0.01%)
    80μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.4KB) (0.01%)
    69μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    56μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%)
    56μs
    1 x beforeRenderRawModule mod_login (Login Form) (976B) (0.01%)
    52μs
    1 x Before Access::getAssetRules (id:106 name:com_content.article.1) (744B) (0.01%)
    50μs
    1 x beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (0.01%)
    45μs
    1 x beforeRenderModule mod_login (Login Form) (640B) (0%)
    23μs
    1 x beforeRenderModule mod_remositorytree (Explore Repository) (5.36KB) (0%)
    21μs
    1 x beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (0%)
    13μs
    1 x beforeRenderModule mod_custom (Twitter follow me) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
43 statements were executed, 4 of which were duplicates, 39 unique205ms132.41KB
  • SELECT @@SESSION.sql_mode;2.04ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?6.29ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 12.56ms1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)5.05ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 13.83ms17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`1.85ms656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.73ms1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.18ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));1.82ms640B/administrator/components/com_osmembership/loader.php:95Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`20.14ms19.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `config_key`,`config_value` FROM jos_osmembership_configs5.73ms3.06KB/administrator/components/com_osmembership/libraries/mpf/config/config.php:42Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.9ms1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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` = 11.86ms832B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44)2.35ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.56ms1.98KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`7.11ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '1'8.79ms1.3KB/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`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`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)3.86ms22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`2.01ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.67ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT NOW()1.48ms536B/components/com_userpoints/src/Problems/SQL.php:31Copy
  • SELECT UNIX_TIMESTAMP(NOW())1.53ms536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SHOW TABLES LIKE 'jos_downloads_repository'2.47ms520B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT COUNT(`id`) FROM `jos_usergroups`1.77ms536B/libraries/src/Helper/UserGroupsHelper.php:207Copy
  • SELECT * FROM `jos_usergroups` ORDER BY `lft` ASC1.49ms976B/libraries/src/Helper/UserGroupsHelper.php:266Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`2.51ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.97ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT role, subject_id, action FROM jos_permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')4.24ms1.13KBsameCopy
  • SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'hidden' THEN 2 ELSE 99 END) menorder, (CASE type WHEN 'url' THEN 2 ELSE 1 END) typorder FROM jos_menu WHERE link LIKE 'index.php?option=com_remository&view=remository%' AND type LIKE 'component%' AND published=1 ORDER BY typorder, menorder8.15ms656BsameCopy
  • SELECT COUNT(*) FROM `jos_alpha_userpoints`6.17ms536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SHOW FIELDS FROM `jos_alpha_userpoints`5.64ms1.05KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SELECT *, id AS rid FROM `jos_alpha_userpoints_combined` WHERE userid = 1883.76ms2.78KB/components/com_userpoints/src/Problems/SQL.php:65Copy
  • SELECT referreid FROM jos_alpha_userpoints WHERE `referreid`='SELF6643675544B7D5.01584835' AND `published`='1'1.4ms3.02KB/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT * FROM `jos_alpha_userpoints_rules`1.91ms5.05KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SHOW FIELDS FROM `jos_alpha_userpoints_rules`3.72ms1.42KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SELECT UNIX_TIMESTAMP(NOW())1.59ms536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT `id` FROM jos_alpha_userpoints_details WHERE `keyreference`= '1|3.142.98.24|677ccc85b7e18' AND enabled='1'1.83ms520B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`18.6ms1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `path`, `link` FROM `jos_menu` WHERE `link` LIKE '%remository%' AND `published` > 0 AND `client_id` = 02.47ms608BsameCopy
  • SELECT * FROM `jos_schemaorg` WHERE `itemId` = :itemId AND `context` = :context8.06ms1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 15.48ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?10.46ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?22.02ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy