User Points Integration with Membership Pro

Submitted On: 12 Aug 2024
File Size: 2
Downloads: 27
File Version: 1.1.1
File Author: Martin Brampton

Install this plugin using the usual Joomla install facility . It will integrate UserPoints and Membership Pro. After you have installed it, go to the UserPoints admin control panel and run "Auto detect new rules". You should then find two new rules in UserPoints. The plugin also provides the referral function where points will be awarded to the user who referred the person buying a Membership Pro Plan.

One of the new rules relates to these referral points. You must check the "Unique function name" carefully - it ends with a number. Make sure the number corresponds to the ID number of the Membership Pro Plan for which you want to award referral points. If you want to award points to more than one plan, make copies of this rule, changing the "Unique function name" so that the number at the end matches the ID in Membership Pro. Set the number of points to be awarded. Normally, you would leave "Allow referral points" as "no" - so that the referral points do not trigger further awards. Carefully check all the other parameters for the rule.

The other rule relates to accepting points as payment for a Membership Plan. Check all the fields, but you should not need to make any changes. What you must do for payment by points to work is to install the "Payment Plugin to pay for Membership Pro subscriptions with points" into Membership Pro. NOTE: It is not a Joomla plugin, but must be installed using the Membership Pro facility for adding payment methods.

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

RELATED DOCUMENTS

This report falls under the following categories. Click on a link below to explore similar documents.

ProductLines: UserPoints

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.789MBMemory Usage140msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.28
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.6-MariaDB-0+deb12u1-log
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "view" => "fileinfo" "id" => 738 ]
$_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" => 1742003771 "last" => 1742003771...
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) (1.1ms)
  • afterInitialise (1.02MB) (24.9ms)
  • afterRoute (347.37KB) (24.96ms)
  • beforeRenderComponent com_remository (46.16KB) (3.33ms)
  • afterRenderComponent com_remository (1.27MB) (53.36ms)
  • afterDispatch (2.27KB) (342μs)
  • beforeRenderRawModule mod_menu (Main Menu) (63.78KB) (2.91ms)
  • afterRenderRawModule mod_menu (Main Menu) (188.33KB) (3.42ms)
  • beforeRenderRawModule mod_login (Login Form) (976B) (40μs)
  • afterRenderRawModule mod_login (Login Form) (38.06KB) (1.72ms)
  • beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (37μs)
  • afterRenderRawModule mod_remositorytree (Explore Repository) (10.34KB) (4.65ms)
  • beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (415μs)
  • afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (42.06KB) (1.54ms)
  • beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (11μs)
  • Before Access::preloadComponents (all components) (12.5KB) (1.39ms)
  • After Access::preloadComponents (all components) (114.68KB) (5.21ms)
  • Before Access::getAssetRules (id:1 name:root.1) (536B) (45μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.05KB) (103μs)
  • afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (520B) (330μs)
  • beforeRenderModule mod_menu (Main Menu) (12.26KB) (195μs)
  • afterRenderModule mod_menu (Main Menu) (4.19KB) (265μs)
  • beforeRenderModule mod_login (Login Form) (640B) (26μs)
  • afterRenderModule mod_login (Login Form) (6.47KB) (108μs)
  • beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (23μs)
  • afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (91μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (134μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (12.23KB) (1.75ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (9μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (160μs)
  • afterRender (79.73KB) (6.83ms)
  • 1 x afterRenderComponent com_remository (1.27MB) (38.07%)
    53.36ms
    1 x afterRoute (347.37KB) (17.8%)
    24.96ms
    1 x afterInitialise (1.02MB) (17.76%)
    24.90ms
    1 x afterRender (79.73KB) (4.87%)
    6.83ms
    1 x After Access::preloadComponents (all components) (114.68KB) (3.72%)
    5.21ms
    1 x afterRenderRawModule mod_remositorytree (Explore Repository) (10.34KB) (3.32%)
    4.65ms
    1 x afterRenderRawModule mod_menu (Main Menu) (188.33KB) (2.44%)
    3.42ms
    1 x beforeRenderComponent com_remository (46.16KB) (2.38%)
    3.33ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (63.78KB) (2.07%)
    2.91ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (12.23KB) (1.25%)
    1.75ms
    1 x afterRenderRawModule mod_login (Login Form) (38.06KB) (1.22%)
    1.72ms
    1 x afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (42.06KB) (1.1%)
    1.54ms
    1 x Before Access::preloadComponents (all components) (12.5KB) (1%)
    1.39ms
    1 x afterLoad (73.79KB) (0.78%)
    1.10ms
    1 x beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (0.3%)
    415μs
    1 x afterDispatch (2.27KB) (0.24%)
    342μs
    1 x afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (520B) (0.24%)
    330μs
    1 x afterRenderModule mod_menu (Main Menu) (4.19KB) (0.19%)
    265μs
    1 x beforeRenderModule mod_menu (Main Menu) (12.26KB) (0.14%)
    195μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (0.11%)
    160μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (0.1%)
    134μs
    1 x afterRenderModule mod_login (Login Form) (6.47KB) (0.08%)
    108μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.05KB) (0.07%)
    103μs
    1 x afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (0.06%)
    91μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (536B) (0.03%)
    45μs
    1 x beforeRenderRawModule mod_login (Login Form) (976B) (0.03%)
    40μs
    1 x beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (0.03%)
    37μs
    1 x beforeRenderModule mod_login (Login Form) (640B) (0.02%)
    26μs
    1 x beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (0.02%)
    23μs
    1 x beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (0.01%)
    11μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.01%)
    9μs
37 statements were executed, 4 of which were duplicates, 33 unique34.08ms92.13KB
  • SELECT @@SESSION.sql_mode;188μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?301μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1248μ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)1.82ms944BParams/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.06ms17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`320μ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` = :guest376μ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.31ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));185μ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`992μs19.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SHOW TABLES LIKE 'jos_downloads_repository'1.25ms520B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT `path`, `link` FROM `jos_menu` WHERE `link` LIKE '%remository%' AND `published` > 0 AND `client_id` = 0642μs608BsameCopy
  • SELECT f.id, f.containerid, f.filetitle, f.realname FROM jos_downloads_files AS f WHERE f.containerid = 128609μs720BsameCopy
  • SELECT `config_key`,`config_value` FROM jos_osmembership_configs511μs3.06KB/administrator/components/com_osmembership/libraries/mpf/config/config.php:42Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC336μ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` = 1474μ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')520μs2.38KBsameCopy
  • SELECT NOW()154μs536B/components/com_userpoints/src/Problems/SQL.php:31Copy
  • SELECT UNIX_TIMESTAMP(NOW())104μs536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT COUNT(`id`) FROM `jos_usergroups`444μs536B/libraries/src/Helper/UserGroupsHelper.php:207Copy
  • SELECT * FROM `jos_usergroups` ORDER BY `lft` ASC242μ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\":1742003771,\"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.81ms48B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT NOW()262μ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 = 738 AND published=1 GROUP BY f.id9.05ms9.72KBsameCopy
  • SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')547μs536BsameCopy
  • SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')394μs944BsameCopy
  • SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='edit' OR `action`='*')386μs536BsameCopy
  • SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='edit' OR `action`='*')299μ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 = 738 ORDER BY typseq, c.name1.36ms1.44KB/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:173Copy
  • SELECT COUNT(*) FROM jos_downloads_log WHERE type=3 AND ipaddress='3.133.91.217' AND fileid=738530μs536B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT COUNT(*) FROM jos_downloads_log WHERE type=3 AND ipaddress='3.133.91.217' AND fileid=738429μs0BsameCopy
  • 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=738 ORDER BY c.date DESC405μs912B/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.06ms4.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.21ms7.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` = 1806μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?348μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.09ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy