[ABD] Medal System MOD for phpBB3

Lord Phobos · 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.

Gremlinn · 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 · 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

Gremlinn · 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.

Kamahl19 · 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.

Gremlinn · 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.

Kamahl19 · 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.

Gremlinn · 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.

Kamahl19 · 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

Kamahl19 · 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

Gremlinn · 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__ · Post by **flaps__** » Thu Oct 29, 2009 9:56 am

Hey

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

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

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

Are you setup as an admin?

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

Yes, I am in the administrators group.

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

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

advertisements