Page 136 of 157

Re: [Beta] Medal System MOD for phpBB3

Posted: Thu Oct 22, 2009 5:26 pm
by Lord Phobos
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Fri Oct 23, 2009 12:25 pm
by Gremlinn
This mod is pretty stable and is being used by many. The first link it the only official location.

Re: [Beta] Medal System MOD for phpBB3

Posted: Fri Oct 23, 2009 3:42 pm
by black001
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 :)

Re: [Beta] Medal System MOD for phpBB3

Posted: Mon Oct 26, 2009 12:29 pm
by Gremlinn
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Tue Oct 27, 2009 12:43 pm
by Kamahl19
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Tue Oct 27, 2009 2:25 pm
by Gremlinn
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Tue Oct 27, 2009 5:24 pm
by Kamahl19
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Tue Oct 27, 2009 6:09 pm
by Gremlinn
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Tue Oct 27, 2009 6:12 pm
by Kamahl19
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

Re: [Beta] Medal System MOD for phpBB3

Posted: Wed Oct 28, 2009 3:09 pm
by Kamahl19
it looks UMIL is working great. just fix bug with medals_active and medals_activate

Re: [Beta] Medal System MOD for phpBB3

Posted: Thu Oct 29, 2009 2:17 am
by Gremlinn
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.

Re: [Beta] Medal System MOD for phpBB3

Posted: Thu Oct 29, 2009 9:56 am
by flaps__
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

Re: [Beta] Medal System MOD for phpBB3

Posted: Thu Oct 29, 2009 12:04 pm
by Gremlinn
Are you setup as an admin?

Re: [Beta] Medal System MOD for phpBB3

Posted: Thu Oct 29, 2009 12:21 pm
by flaps__
Yes, I am in the administrators group.

Re: [Beta] Medal System MOD for phpBB3

Posted: Mon Nov 02, 2009 1:30 pm
by Gremlinn
As admin, you will always be able to work with the medals.