[ABD] Medal System MOD for phpBB3

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Lord Phobos » Thu Oct 22, 2009 5:26 pm

Is this mod stable, working and updated?
Do I have to download it from the first post or do anyone have a better link?

Thanks in advance.

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Fri Oct 23, 2009 12:25 pm

This mod is pretty stable and is being used by many. The first link it the only official location.

black001
Registered User
Posts: 23
Joined: Sun Jan 08, 2006 7:51 pm
Location: Montreal
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by black001 » Fri Oct 23, 2009 3:42 pm

I made some performance tweaks to this MOD (I run a board with 115,000 medals awarded and our medals page was getting slow to load):

1) Replaced the phpbb_medals_awarded index on time field with an index on user_id. According to MySQL Explain command, the time index wasn't being used, and the table is queried on user_id repeatedly in viewtopic.php.

2) In medals.php I replaced this query:

Code: Select all

		$sql = "SELECT u.username, u.user_colour, ma.user_id, ma.medal_id, ma.nominated
				FROM " . USERS_TABLE . " u, " . MEDALS_AWARDED_TABLE . " ma
				WHERE u.user_id = ma.user_id
				GROUP BY ma.nominated, ma.user_id, u.username, ma.medal_id
				ORDER BY u.username_clean";
with this one:

Code: Select all

		$sql = "SELECT DISTINCT u.username, u.user_colour, ma.user_id, ma.medal_id, ma.nominated
				FROM " . USERS_TABLE . " u, " . MEDALS_AWARDED_TABLE . " ma
				WHERE u.user_id = ma.user_id
				ORDER BY u.username_clean";
The results are the same, and it takes half the time :)

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Mon Oct 26, 2009 12:29 pm

black001: Thanks for the tweak. I'm glad to see it works well with 115,000 medals awarded. Sweet.

FYI: I am looking at getting multiple pages in for the next release.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by Kamahl19 » Tue Oct 27, 2009 12:43 pm

hello

i installed this MOD on 5th board and all are working, but on the last board i cant see ACP - Medals CP - Medals management. there is only Configuration. where is the problem? i added ane allowed that modul for 2 times, but nothing happend.

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Tue Oct 27, 2009 2:25 pm

I have not determined the root cause for this issue. It seems to happen randomly. Double check your phpbb_acp_options table for duplicate permissions. As long as this was the last mod you installed, they should be the ones with the highest id numbers.

My next release is planned to have a different method for install. UMIL and AutoMod compatable.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by Kamahl19 » Tue Oct 27, 2009 5:24 pm

hmm strange. now it is not the last mod installed .. i will check it but really dont know if success. can i use remove duplicate permittions via STK ? i have never tried it

edit: i looked at phpbb_acl_options and i have there

Code: Select all

auth_option_id 166 	auth_option a_manage_medals 	is_global 1 	is_local 0 	founder_only 0
just once.

i checked permittions via phpmyadmin and it looks that Administrators (id 5) have auth_option_id 166 with value 1 so i should manage medals.

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Tue Oct 27, 2009 6:09 pm

NEWS: I have completed a major step in the next version of the mod. I have re-done the install method. It is completely UMIL and automod compatible. This should eliminate the ACP module issues some of you have/are having.

Next step is to put in a few updates to make this a bit nicer.
* UCP module
* Pagnation on the medals display panel



Kamahl19: Permissions look good then. I could send you the database install I just finished for the next version. You would need to remove everything for the medals mod currently in the database (not the files, just the DB). If you're interested, let me know.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by Kamahl19 » Tue Oct 27, 2009 6:12 pm

hmm i tried one more think. in phpbb_modules i found management and changed module_aut from acl_a_manage_medals to acl_a_board like configuration. then i changed in includes/acp/info/acp_medals.php from

Code: Select all

'management'	=> array(
					'title'			=> 'ACP_MEDALS_TITLE',
					'auth'			=> 'acl_a_manage_medals',
					'cat' 			=> array('ACP_CAT_USERS'),
				),
to

Code: Select all

'auth'			=> 'acl_a_board',
and nothing happend

to gremlinn, yes i am very interested in. thanks


edit: ok i deleted all from config, acl_options, imageset, all 3 tables and modules

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by Kamahl19 » Wed Oct 28, 2009 3:09 pm

it looks UMIL is working great. just fix bug with medals_active and medals_activate

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Thu Oct 29, 2009 2:17 am

Good to hear. UMIL is in the next release. The active/activate typos will be corrected too. Along with a UCP change and pagnation option on the medals.php view.

flaps__
Registered User
Posts: 100
Joined: Wed Apr 22, 2009 9:52 pm

Re: [Beta] Medal System MOD for phpBB3

Post by flaps__ » Thu Oct 29, 2009 9:56 am

Hey

Awsome mod! It is perfect for what we are looking for! :D

I have installed it on my local test server first (as i do with all mods) and it looks pretty sweet!
Although I am having trouble with permissions...

I have removed permissions for a certain group to be able to 'Award Medals' - yet I am still able to?
Any help will be much appreciated. Thanks

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Thu Oct 29, 2009 12:04 pm

Are you setup as an admin?

flaps__
Registered User
Posts: 100
Joined: Wed Apr 22, 2009 9:52 pm

Re: [Beta] Medal System MOD for phpBB3

Post by flaps__ » Thu Oct 29, 2009 12:21 pm

Yes, I am in the administrators group.

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [Beta] Medal System MOD for phpBB3

Post by Gremlinn » Mon Nov 02, 2009 1:30 pm

As admin, you will always be able to work with the medals.

Locked

Return to “[3.0.x] Abandoned MODs”