[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.
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 »

Gilligan53: I see where the issue is. Thank you for uncovering it. I would have to assume the use could not be awarded the medal because he already has it and/or the medal is not setup to be awarded multiple times or enough times.

Mircea007: Did you upload the template images? (I would assume yes). Did you refresh your template imageset and theme? Clear your cache?
Mircea007
Registered User
Posts: 74
Joined: Mon Jun 15, 2009 9:24 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Mircea007 »

Gremlinn wrote:Gilligan53: I see where the issue is. Thank you for uncovering it. I would have to assume the use could not be awarded the medal because he already has it and/or the medal is not setup to be awarded multiple times or enough times.

Mircea007: Did you upload the template images? (I would assume yes). Did you refresh your template imageset and theme? Clear your cache?
yes i did all that ... everything else works perfect except that
Flash Games like you never seen before
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 »

hmm. Probably has to do with the location of the image file. I have a ticket on my site to fix that. I may be the answer to your issue with the image. But, you should be able to use the image "button" sill.
Mircea007
Registered User
Posts: 74
Joined: Mon Jun 15, 2009 9:24 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Mircea007 »

in firefox it apears normal but in IE it doesnt
Flash Games like you never seen before
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 »

Mircea007: Ok, here is a potentially stupid thought. ;) Did you refresh your browser's cache?
Gilligan53
Registered User
Posts: 10
Joined: Mon Jan 12, 2009 8:46 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Gilligan53 »

Gremlinn wrote:Gilligan53: I see where the issue is. Thank you for uncovering it. I would have to assume the use could not be awarded the medal because he already has it and/or the medal is not setup to be awarded multiple times or enough times.

Mircea007: Did you upload the template images? (I would assume yes). Did you refresh your template imageset and theme? Clear your cache?
Will this issue be resolved?
RadiantAlpha
Registered User
Posts: 27
Joined: Tue Mar 17, 2009 9:06 pm

Re: [Beta] Medal System MOD for phpBB3

Post by RadiantAlpha »

Hey there,

We have this mod installed and we have recently tried to add some new ones and we are getting this SQL Error, can anyone help us out? Please?

SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'id' at row 1 [1264]

SQL

INSERT INTO phpbb_medals (name, image, device, dynamic, number, parent, nominated, order_id, description, points) VALUES ('Test Medal', 'achievment_001.jpg', 'device', '0', '2', '9', '1', 15, 'this is a Test Medal', '0')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_medals.php
LINE: 470
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_medals->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
User avatar
madmartyau
Registered User
Posts: 440
Joined: Sun Sep 12, 2004 12:42 pm
Location: Brisbane,Australia
Name: Marty
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by madmartyau »

RadiantAlpha wrote:Hey there,

We have this mod installed and we have recently tried to add some new ones and we are getting this SQL Error, can anyone help us out? Please?

SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'id' at row 1 [1264]

SQL

INSERT INTO phpbb_medals (name, image, device, dynamic, number, parent, nominated, order_id, description, points) VALUES ('Test Medal', 'achievment_001.jpg', 'device', '0', '2', '9', '1', 15, 'this is a Test Medal', '0')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_medals.php
LINE: 470
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_medals->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
It's because you have more than 127 medals. This one did my head in.

TINYINT

Integer data. The signed range is -128 to 127. The unsigned range is 0 to 255. Storage size is 1 byte.

You'll need to go in to phpmyadmin and change the column 'id' to

SMALLINT

Integer data. The signed range is -32768 to 32767. The unsigned range is 0 to 65535. Storage size is 2 bytes.
Call me Grumpy.
RadiantAlpha
Registered User
Posts: 27
Joined: Tue Mar 17, 2009 9:06 pm

Re: [Beta] Medal System MOD for phpBB3

Post by RadiantAlpha »

Thank you so, so very much!
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 »

Gilligan: Their are two things you are seeing. One is that the medal doesn't seem to be setup properly for multiple awards. Check the medal to make sure that the medal can be awarded more than the number of times the user has it awarded to them now. Second, the username is just not displaying properly and should not be stopping the medal from being awarded, check the first issue.

Have you tried to use the username_clean value when awarding the medal? Check in the users table for that users clean value and award the medal to that. It may be that what you're typing in to award is not the same as what the user typed.

The displaying of the name on that error page will be corrected.


RadiantAlpha: You have done some big changes to the medals code. Good to see you have made it work for your needs. I shall double check the table setups. I didn't expect anyone to use an extreme number of medals. And, might have be using signed values on accident. I shall double check that.
Mircea007
Registered User
Posts: 74
Joined: Mon Jun 15, 2009 9:24 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Mircea007 »

Gremlinn wrote:Mircea007: Ok, here is a potentially stupid thought. ;) Did you refresh your browser's cache?

hehe i did that 2 :D i thought of that 2 ... its weird how in firefox its works perfectly and IE the stupid image goes crazy ( well its not there :) )
Flash Games like you never seen before
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 »

structor wrote:Hello!

This is a great MOD for phpbb3.
I administrate an Icy Phoenix site about whist and backgammon tournaments, and I want to convert it to phpbb3 (I already did that on a test subdomain and works perfect).

Now, we have hundreds of users that were awarded with medals and I wonder if it's possible to consider making a page that shows a top of the awarded users, by number of medals received.
At this moment I only have a simple, ugly page that I manually made for it, but I show you for example of what I have in mind.

http://doizecisti.ro/hall_of_fame.php

Thank you for the translation. I saw you posted it over at my test site. TY.

Creating something along these lines very possible and shouldn't be too difficult. Much of it is just layout. The rest is doing the DB queries to gather the data you need to be able to display. I am very busy with other projects at the moment. Might I suggest you create a feature request using the tracker on my test site? This way, I don't forget. And if anyone else would like to take a crack at it, I would be happy to make it available via my site's contributions or within the mod's contrib folder.
User avatar
Rotsblok
Registered User
Posts: 648
Joined: Fri Nov 11, 2005 12:47 pm
Location: Upper north of Holland
Name: Rikkert Westa
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by Rotsblok »

There is an error in the isntall file, and some of your root files..

You need to find medals_active in includes/functions.php, /medals.php and i believe also in includes/acp/acp_medals.php

and replace it to medals_activate

or asp I just reliazed you can also just adjust in your phpmyadmin config table the medals_activate to medals_active :S

Otherwise you get some nice errors
Nederlandse Support site
Several dutch translations for 3.1 extensions if you need one or there is an update of an extension feel free to notify me.
Shauku
Registered User
Posts: 21
Joined: Sun Aug 16, 2009 3:52 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Shauku »

Is there a possiblity to replace one Medal with another? I want some medals of a typ, who only can be changed, but can´t be collected.

For example (with point & shop mod), a user buys medal_1 and now have enought points for medal_2. He buys medal_2, so its not necessary that he still have medal_1.
Medal_2 have to replace medal_1. Does someone have a idea or a snippet, to get this work?
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 »

Rotsblok: Thank you for the info. I will investigate and update.

Shauku: You could use the Device to put the second/third/etc... medals over the first. They buy the same medal and each time it could "add" the device to the first medal and as long as your medals are the same size, it will cover the first.
Locked

Return to “[3.0.x] Abandoned MODs”