Member Medals

[Chico Gois]

Member Medals — Release Candidate

Hello everyone,

I am pleased to present Member Medals, a phpBB extension created to reward community participation with a complete medals and achievements system.

This version can now be considered a release candidate, with all core features implemented, a stabilized public area, and only minor visual adjustments remaining.

Extension Highlights

• Medal creation and management in the ACP
• Manual awarding of medals to users
• Automatic rules to reward members based on defined criteria
• Native phpBB notifications when a medal is received
• Public medals page
• Public user medals page
• Public medal details page
• Display in the mini profile within topics
• Display in the user profile
• Multilingual support

In this version

• Visual improvements to public pages
• Better mobile responsiveness
• Visual polish for desktop
• Adjustments to profile and mini profile
• Review of text and language keys
• Fixes for empty states and general consistency

Objective

The goal of Member Medals is simple: to offer an elegant and integrated way to recognize members, highlight achievements, and value participation within the community.

Feedback, suggestions, and testing are very welcome.

Demo: https://mundophpbb.com.br/area51/membermedals

Download: https://github.com/mundophpbb/membermedals

[Fred Rimbert]

Hi Chico,
This morning I disabled the **Member Medals** extension, but its uninstall script left behind the notification type and 209 associated notifications.
A properly uninstalled extension should remove those records, so this appears to be a bug in the extension.
The remaining notification records caused an error message to be displayed when users logged into the forum.

Código: Selecionar todos

Fatal error: Uncaught Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException: You have requested a non-existent service "mundophpbb.membermedals.notification.type.medal_awarded". in /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/vendor/symfony/dependency-injection/Container.php:348 Stack trace: #0 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/phpbb/notification/manager.php(935): Symfony\Component\DependencyInjection\Container->get('mundophpbb.memb...') #1 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/phpbb/notification/manager.php(909): phpbb\notification\manager->load_object('mundophpbb.memb...') #2 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/phpbb/notification/method/board.php(229): phpbb\notification\manager->get_item_type_class('mundophpbb.memb...', Array) #3 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/phpbb/notification/manager.php(123): phpbb\notification\method\board->load_notifications(Array) #4 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/includes/functions.php(4010): phpbb\notification\manager->load_notifications('notification.me...', Array) #5 /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/viewtopic.php(2423): page_header('Fin de support ...', true, 47) #6 {main} thrown in /home/clients/aad2674d94bf9fbeb384ebc8b7e1c3be/forum/vendor/symfony/dependency-injection/Container.php on line 348

I've just run a few SQL queries on the database to remove everything that was left behind by the extension.

[Chico Gois]

Use this SQL to clear the entire database.

Código: Selecionar todos

-- Member Medals - complete/emergency removal for phpBB
-- Extension: mundophpbb/membermedals
-- Analyzed version in the package: 0.8.0
--
-- IMPORTANT:
-- 1) Make a database backup before running.
-- 2) This file uses the default prefix phpbb_.
--    If your forum uses a different prefix, replace phpbb_ with the correct one.
-- 3) Run with the extension disabled, if possible.
-- 4) After running, clear the phpBB cache.

SET FOREIGN_KEY_CHECKS = 0;

-- Remove notifications generated by the extension.
DELETE FROM phpbb_notifications
WHERE notification_type_id IN (
    SELECT notification_type_id
    FROM phpbb_notification_types
    WHERE notification_type_name = 'mundophpbb.membermedals.notification.type.medal_awarded'
);

DELETE FROM phpbb_user_notifications
WHERE item_type = 'mundophpbb.membermedals.notification.type.medal_awarded';

DELETE FROM phpbb_notification_types
WHERE notification_type_name = 'mundophpbb.membermedals.notification.type.medal_awarded';

-- Remove ACP/UCP modules of the extension.
DELETE FROM phpbb_modules
WHERE module_basename IN (
    '\\mundophpbb\\membermedals\\acp\\main_module',
    '\\mundophpbb\\membermedals\\ucp\\main_module'
)
OR module_langname IN (
    'ACP_MEMBERMEDALS_TITLE',
    'ACP_MEMBERMEDALS_SETTINGS',
    'ACP_MEMBERMEDALS_MEDALS',
    'ACP_MEMBERMEDALS_RULES',
    'ACP_MEMBERMEDALS_AWARDS',
    'UCP_MEMBERMEDALS_TITLE'
)
OR module_auth LIKE '%ext_mundophpbb/membermedals%';

-- Remove extension configuration settings.
DELETE FROM phpbb_config
WHERE config_name LIKE 'membermedals_%';

-- Remove extension migration records.
DELETE FROM phpbb_migrations
WHERE migration_name LIKE '%mundophpbb%membermedals%migrations%';

-- Remove the extension registration from the phpBB extension manager.
DELETE FROM phpbb_ext
WHERE ext_name = 'mundophpbb/membermedals';

-- Remove the extension's own tables.
DROP TABLE IF EXISTS phpbb_membermedals_featured;
DROP TABLE IF EXISTS phpbb_membermedals_awards;
DROP TABLE IF EXISTS phpbb_membermedals_rules;
DROP TABLE IF EXISTS phpbb_membermedals;

SET FOREIGN_KEY_CHECKS = 1;

-- After running:
-- - Clear the cache via ACP or delete the contents of cache/ while keeping .htaccess and index.htm.
-- - Manually remove the extension files from ext/mundophpbb/membermedals/.
-- - If there are uploaded images, manually remove files/membermedals/ if you do not want to keep the uploads.