[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.
evina
Registered User
Posts: 110
Joined: Mon Nov 10, 2008 2:06 am

Re: [Beta] Medal System MOD for phpBB3

Post by evina »

Can there be a future feature that can allow the admins to remove 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 »

evina: Admins can remove medals if you give them permissions to do so.
Gen.Centralnui
Registered User
Posts: 24
Joined: Tue Jun 12, 2007 2:15 am

Re: [Beta] Medal System MOD for phpBB3

Post by Gen.Centralnui »

Hello all.
I got this error when I trying to award someone:

Code: Select all

SQL ERROR [ mysql4 ]

Field 'id' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_medals_awarded (medal_id, user_id, awarder_id, awarder_un, awarder_color, nominated, nominated_reason, points, time, bitfield, bbuid) VALUES (9, 113, '2', 'ЦентральныЙ', '000066', 0, '33', '10', 1245217540, '', '')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: medals.php
LINE: 1055
CALL: dbal_mysql->sql_query()

FILE: medals.php
LINE: 570
CALL: award_medal()
Anyone know how to sort it out?
evina
Registered User
Posts: 110
Joined: Mon Nov 10, 2008 2:06 am

Re: [Beta] Medal System MOD for phpBB3

Post by evina »

Gremlinn wrote:evina: Admins can remove medals if you give them permissions to do so.
Ok, I gave myself full awards permissions. Where do I go to remove 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 »

evina: Are you talking about deleting a medal or removing an awarded medal from a user? Delete a medal from the ACP (same place you created them). Remove an awarded medal from a user using the Medal Management link in that user's profile view.

Gen.Centralnui: First, I would suggest moving to mysql 5. The id field in the medals tables are auto incrementing. I don't know about mysql 4 compatibility. Does anyone else have mysql 4 that could verify it works?
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 »

Gremlinn wrote:evina: Are you talking about deleting a medal or removing an awarded medal from a user? Delete a medal from the ACP (same place you created them). Remove an awarded medal from a user using the Medal Management link in that user's profile view.

Gen.Centralnui: First, I would suggest moving to mysql 5. The id field in the medals tables are auto incrementing. I don't know about mysql 4 compatibility. Does anyone else have mysql 4 that could verify it works?
It works with 4.
Call me Grumpy.
Gen.Centralnui
Registered User
Posts: 24
Joined: Tue Jun 12, 2007 2:15 am

Re: [Beta] Medal System MOD for phpBB3

Post by Gen.Centralnui »

So what I have to do?I can't change mysql because of my provider, another way?
zepherion
Registered User
Posts: 5
Joined: Sun Jun 21, 2009 11:43 am

Re: [Beta] Medal System MOD for phpBB3

Post by zepherion »

Hi,

Is it easy to change the references of 'Medals' into 'Awards'?
Also how hard is it to add this mod onto a different customised theme?

Sidenote: I can manage in following the steps in the install files. But I'm in no way able to understand the whole php thing from A to Z. (This might be helpfull when replying :D)
User avatar
SAFFLEUR
Registered User
Posts: 323
Joined: Thu Nov 24, 2005 5:56 am
Location: Lenoir NC
Contact:

Re: [Beta] Medal System MOD for phpBB3

Post by SAFFLEUR »

zepherion wrote:Hi,

Is it easy to change the references of 'Medals' into 'Awards'?
Also how hard is it to add this mod onto a different customised theme?

Sidenote: I can manage in following the steps in the install files. But I'm in no way able to understand the whole php thing from A to Z. (This might be helpfull when replying :D)
Should be able to change the word "Medals" to "Awards" in the language files.
Gen.Centralnui
Registered User
Posts: 24
Joined: Tue Jun 12, 2007 2:15 am

Re: [Beta] Medal System MOD for phpBB3

Post by Gen.Centralnui »

Maybe someone will help me?
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 »

Gen.Centralnui: In php, drop the medals table. In the phpbb_config table, find the medals_mod_version entry and delete that line. Then, re-visit the ACP medals configuration page. It should re-install the table, the deleted entry and permissions if any where missing. Post the output here. Then, see if the problem goes away.
Gen.Centralnui
Registered User
Posts: 24
Joined: Tue Jun 12, 2007 2:15 am

Re: [Beta] Medal System MOD for phpBB3

Post by Gen.Centralnui »

I did it, but problem is still exist.
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 »

Can you find out what the version number is for your mysql server? Also, what tool do you have to interact with your database? Let's see if the ID field is setup as auto-incrementing.
Gen.Centralnui
Registered User
Posts: 24
Joined: Tue Jun 12, 2007 2:15 am

Re: [Beta] Medal System MOD for phpBB3

Post by Gen.Centralnui »

MySQL Version is: 5.0.67.
I'm using phpMyAdmin which version is: 5.0.51
Mircea007
Registered User
Posts: 74
Joined: Mon Jun 15, 2009 9:24 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Mircea007 »

will this work with Ultimate points ?
Flash Games like you never seen before
Locked

Return to “[3.0.x] Abandoned MODs”