UserPoints integration with Eshop

You are welcome to browse here, but need to register and login to download.
Submitted On: 16 Feb 2025
File Size: 19
Downloads: 5
File Version: 1.0.1

With this plugin you can do two things:

  • Award points for making purchases in the shop
  • Let customers buy EShop coupons with their points

To use, install the plugin into Joomla in the usual way. Look at the plugin configuration and set values to suit. Go to the UserPoints Control Panel and click on the "Auto detect new rules" button, which will create two new rules. Publish either or both rules. For coupons, users need access to the Profile page - an extra drop down will show information about coupons.

File Rating (0/0)
Log in to cast your vote
Be the first to comment! Please sign in or register.

Main Menu

Login Form

Explore Repository

open all | close all

Repository
Martin Brampton

Offline

Sorry, but we're currently offline. Please fill out the form below, and we will get back to you as soon as possible.

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.

Ok Decline
J! InfoRequestSessionProfileQueries37
3.772MBMemory Usage171msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.28
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.11-MariaDB-0+deb12u1-log
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "view" => "fileinfo" "id" => 749 ]
$_POST
[]
$_SESSION
array:2 [ "aliro_auth" => array:5 [ "subj_found" => & array:1 [ "remosFolder" => array:2...
$_COOKIE
[]
$_SERVER
array:54 [ "USER" => "remos" "HOME" => "/var/www/remos" "SCRIPT_NAME" => "" "REQUEST_URI" =>...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1742072097 "last" => 1742072097...
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) (2.53ms)
  • afterInitialise (1.02MB) (29.37ms)
  • afterRoute (367.8KB) (22.5ms)
  • beforeRenderComponent com_remository (46.16KB) (5.09ms)
  • afterRenderComponent com_remository (1.25MB) (63.72ms)
  • afterDispatch (2.27KB) (494μs)
  • beforeRenderRawModule mod_menu (Main Menu) (63.78KB) (3.54ms)
  • afterRenderRawModule mod_menu (Main Menu) (188.33KB) (5.02ms)
  • beforeRenderRawModule mod_login (Login Form) (976B) (49μs)
  • afterRenderRawModule mod_login (Login Form) (38.06KB) (2.32ms)
  • beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (59μs)
  • afterRenderRawModule mod_remositorytree (Explore Repository) (10.34KB) (7.26ms)
  • beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (2.19ms)
  • afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (44.55KB) (2.51ms)
  • beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (18μs)
  • Before Access::preloadComponents (all components) (12.5KB) (2.6ms)
  • After Access::preloadComponents (all components) (114.68KB) (4.13ms)
  • Before Access::getAssetRules (id:1 name:root.1) (536B) (67μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.05KB) (174μs)
  • afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (520B) (268μs)
  • beforeRenderModule mod_menu (Main Menu) (12.26KB) (161μs)
  • afterRenderModule mod_menu (Main Menu) (4.19KB) (208μs)
  • beforeRenderModule mod_login (Login Form) (640B) (36μs)
  • afterRenderModule mod_login (Login Form) (6.47KB) (120μs)
  • beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (21μs)
  • afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (90μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (173μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.98KB) (3.2ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (16μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (560μs)
  • afterRender (70.48KB) (11.63ms)
  • 1 x afterRenderComponent com_remository (1.25MB) (37.3%)
    63.72ms
    1 x afterInitialise (1.02MB) (17.19%)
    29.37ms
    1 x afterRoute (367.8KB) (13.17%)
    22.50ms
    1 x afterRender (70.48KB) (6.81%)
    11.63ms
    1 x afterRenderRawModule mod_remositorytree (Explore Repository) (10.34KB) (4.25%)
    7.26ms
    1 x beforeRenderComponent com_remository (46.16KB) (2.98%)
    5.09ms
    1 x afterRenderRawModule mod_menu (Main Menu) (188.33KB) (2.94%)
    5.02ms
    1 x After Access::preloadComponents (all components) (114.68KB) (2.42%)
    4.13ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (63.78KB) (2.07%)
    3.54ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.98KB) (1.88%)
    3.20ms
    1 x Before Access::preloadComponents (all components) (12.5KB) (1.52%)
    2.60ms
    1 x afterLoad (73.79KB) (1.48%)
    2.53ms
    1 x afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (44.55KB) (1.47%)
    2.51ms
    1 x afterRenderRawModule mod_login (Login Form) (38.06KB) (1.36%)
    2.32ms
    1 x beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (1.28%)
    2.19ms
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (0.33%)
    560μs
    1 x afterDispatch (2.27KB) (0.29%)
    494μs
    1 x afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (520B) (0.16%)
    268μs
    1 x afterRenderModule mod_menu (Main Menu) (4.19KB) (0.12%)
    208μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.05KB) (0.1%)
    174μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (0.1%)
    173μs
    1 x beforeRenderModule mod_menu (Main Menu) (12.26KB) (0.09%)
    161μs
    1 x afterRenderModule mod_login (Login Form) (6.47KB) (0.07%)
    120μs
    1 x afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (0.05%)
    90μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (536B) (0.04%)
    67μs
    1 x beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (0.03%)
    59μs
    1 x beforeRenderRawModule mod_login (Login Form) (976B) (0.03%)
    49μs
    1 x beforeRenderModule mod_login (Login Form) (640B) (0.02%)
    36μs
    1 x beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (0.01%)
    18μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.01%)
    16μs
37 statements were executed, 4 of which were duplicates, 33 unique53.98ms92.11KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;167μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?297μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1307μs1.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)2.06ms944BParams/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` = 11.95ms17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`300μs656B/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` = :guest405μs1.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`1.39ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));166μs640B/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`949μs19.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SHOW TABLES LIKE 'jos_downloads_repository'683μs520B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT `path`, `link` FROM `jos_menu` WHERE `link` LIKE '%remository%' AND `published` > 0 AND `client_id` = 01.44ms608BsameCopy
  • SELECT f.id, f.containerid, f.filetitle, f.realname FROM jos_downloads_files AS f WHERE f.containerid = 128569μs720BsameCopy
  • SELECT `config_key`,`config_value` FROM jos_osmembership_configs564μs3.06KB/administrator/components/com_osmembership/libraries/mpf/config/config.php:42Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC493μs1.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` = 1576μs832B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT role, subject_id, action FROM jos_permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')1.32ms2.38KBsameCopy
  • SELECT NOW()223μs536B/components/com_userpoints/src/Problems/SQL.php:31Copy
  • SELECT UNIX_TIMESTAMP(NOW())420μs536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT COUNT(`id`) FROM `jos_usergroups`476μs536B/libraries/src/Helper/UserGroupsHelper.php:207Copy
  • SELECT * FROM `jos_usergroups` ORDER BY `lft` ASC321μs976B/libraries/src/Helper/UserGroupsHelper.php:266Copy
  • UPDATE jos_extensions SET params = '{\"Update_Key\":\"138ba94176ac95778fbb6601ae51b4e5b6a9a4b378b122f1b11753d7ba1f9aff\",\"MaxSize\":\"50000\",\"Max_Up_Dir_Space\":\"500000\",\"User_Remote_Files\":\"0\",\"ExtsOk\":\"txt,exe,tar,gz,rar,zip,png,gif,jpg,pdf,doc,rtf,odt,odc,odp,odg,mp3,mov\",\"Anti_Leach\":\"0\",\"Date_Format\":\"d M Y\",\"Set_date_locale\":\"\",\"Driver_type\":\"Blob\",\"Down_Path\":\"\\/var\\/www\\/remos\\/remository_downloads\",\"Real_With_ID\":\"1\",\"Allow_Up_Overwrite\":\"1\",\"Fallback_username\":\"admin\",\"Large_Text_Len\":\"300\",\"Small_Text_Len\":\"150\",\"Max_Thumbnails\":\"1\",\"Large_Image_Width\":\"600\",\"Large_Image_Height\":\"600\",\"Small_Image_Width\":\"100\",\"Small_Image_Height\":\"100\",\"Time_Stamp\":\"1136491012\",\"Cron_Timer\":1742072097,\"Main_Page_Title\":\"Remository Files\",\"headerpic\":\"\\/components\\/com_remository\\/images\\/header.gif\",\"Remository_Pathway\":\"1\",\"Show_RSS_feeds\":\"1\",\"Show_SubCategories\":\"0\",\"Items_per_page\":\"50\",\"Page_spread\":\"9\",\"Default_ordering\":\"2\",\"Show_search_box\":\"1\",\"Apply_content_plugins\":\"0\",\"See_Containers_no_download\":\"1\",\"See_Files_no_download\":\"1\",\"Featured_Number\":\"0\",\"Show_File_Folder_Counts\":\"1\",\"Immediate_Download\":\"0\",\"Allow_File_Info\":\"1\",\"Show_download_counts\":\"1\",\"Allow_Large_Images\":\"1\",\"Show_Footer\":\"1\",\"Show_all_containers\":\"0\",\"Display_FolderIcons\":\"1\",\"Display_FileIcons\":\"1\",\"ExtsDisplay\":\"\",\"Large_icon_size\":\"32\",\"Small_icon_size\":\"16\",\"Use_CMS_Groups\":\"1\",\"Allow_Comments\":\"1\",\"Min_Comment_length\":\"10\",\"Allow_Votes\":\"1\",\"Allow_Visitor_Votes\":\"0\",\"Enable_List_Download\":\"0\",\"Max_Down_Per_Day\":\"5\",\"Max_Down_Reg_Day\":\"10\",\"Max_Down_File_Day\":\"5\",\"Max_Up_Per_Day\":\"5\",\"ExtsAudio\":\"\",\"Audio_Download\":\"0\",\"ExtsVideo\":\"\",\"Video_Download\":\"0\",\"Favourites_Max\":\"0\",\"Max_Cache_Size\":\"3000\",\"File_Block_Size\":\"60000\",\"Download_Delay\":\"20\",\"Profile_URI\":\"\",\"Classification_Types\":\"ProductLines,Services\",\"Update_Server_Salt\":\"I wish I was a little grub\",\"Count_Down\":\"0\",\"Allow_User_Sub\":\"1\",\"Allow_Container_Add\":\"0\",\"Allow_Container_Edit\":\"0\",\"Allow_Container_Delete\":\"0\",\"Allow_User_Edit\":\"1\",\"Allow_User_Delete\":\"0\",\"Upload_create_folder\":\"0\",\"Enable_Admin_Autoapp\":\"1\",\"Enable_User_Autoapp\":\"0\",\"Make_Auto_Thumbnail\":\"0\",\"Default_Version\":\"1.0\",\"Send_Sub_Mail\":\"0\",\"Sub_Mail_Alt_Addr\":\"\",\"Email_on_new_file\":\"0\",\"Email_on_new_comment\":\"0\",\"SEF_lower_case\":\"0\",\"SEF_add_ID\":\"0\",\"Checkfail_file_ID\":\"0\",\"s3region\":\"eu-west-2\",\"s3key\":\"AKIA3DQLIQ6Y3NTCPGT4\",\"s3secret\":\"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\",\"s3bucket\":\"remository.site.newfiles\",\"download_text\":\"\",\"preamble\":\"\",\"Default_Licence\":\"\",\"custom-D-filedate\":\"10\",\"custom-D-description\":\"20\",\"custom-D-price\":\"0\",\"custom-D-submittedby\":\"0\",\"custom-D-submitdate\":\"0\",\"custom-D-filesize\":\"80\",\"custom-D-downloads\":\"90\",\"custom-D-vote_value\":\"100\",\"custom-D-license\":\"0\",\"custom-D-fileversion\":\"120\",\"custom-D-fileauthor\":\"130\",\"custom-D-filehomepage\":\"140\"}' WHERE type = 'component' AND element = 'com_remository'2.9ms48B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT NOW()985μs488BsameCopy
  • SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count, CASE WHEN fv.user_id IS NULL THEN 0 WHEN fv.user_id = 0 THEN 0 ELSE 1 END AS favourite FROM jos_downloads_files AS f LEFT JOIN jos_downloads_log AS l ON l.type=3 AND l.fileid=f.id LEFT JOIN jos_downloads_favour AS fv ON fv.file_id = f.id AND fv.user_id = 0 WHERE f.id = 749 AND published=1 GROUP BY f.id1.6ms9.72KBsameCopy
  • SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')380μs536BsameCopy
  • SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')339μs944BsameCopy
  • SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='edit' OR `action`='*')280μs536BsameCopy
  • SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='edit' OR `action`='*')304μs1008BsameCopy
  • SELECT c.*, CASE WHEN c.type = 'ProductLines' THEN 0 WHEN c.type = 'Services' THEN 1 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 = 749 ORDER BY typseq, c.name1.72ms1.42KB/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:173Copy
  • SELECT COUNT(*) FROM jos_downloads_log WHERE type=3 AND ipaddress='3.15.173.49' AND fileid=7491.41ms536B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT COUNT(*) FROM jos_downloads_log WHERE type=3 AND ipaddress='3.15.173.49' AND fileid=7491.03ms0BsameCopy
  • SELECT c.id, c.title, c.comment, c.date, c.imgcount, 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=749 ORDER BY c.date DESC1.18ms912B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:173Copy
  • 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`1.22ms4.39KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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)1.38ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • 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` = 11.38ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?509μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?22.29ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy