[ABD] Medal System MOD for phpBB3

evina · Post by **evina** » Tue Jun 16, 2009 1:01 am

Can there be a future feature that can allow the admins to remove medals?

Gremlinn · Post by **Gremlinn** » Thu Jun 18, 2009 12:32 pm

evina: Admins can remove medals if you give them permissions to do so.

Gen.Centralnui · Post by **Gen.Centralnui** » Fri Jun 19, 2009 4:07 am

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 · Post by **evina** » Fri Jun 19, 2009 7:35 am

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?

Gremlinn · Post by **Gremlinn** » Fri Jun 19, 2009 1:07 pm

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?

madmartyau · Post by **madmartyau** » Fri Jun 19, 2009 2:21 pm

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.

Gen.Centralnui · Post by **Gen.Centralnui** » Fri Jun 19, 2009 3:48 pm

So what I have to do?I can't change mysql because of my provider, another way?

zepherion · Post by **zepherion** » Sun Jun 21, 2009 11:48 am

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

)

SAFFLEUR · Post by **SAFFLEUR** » Mon Jun 22, 2009 6:02 am

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 )

Should be able to change the word "Medals" to "Awards" in the language files.

Gen.Centralnui · Post by **Gen.Centralnui** » Mon Jun 22, 2009 4:17 pm

Maybe someone will help me?

Gremlinn · Post by **Gremlinn** » Tue Jun 23, 2009 1:05 pm

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 · Post by **Gen.Centralnui** » Wed Jun 24, 2009 9:33 am

I did it, but problem is still exist.

Gremlinn · Post by **Gremlinn** » Wed Jun 24, 2009 12:40 pm

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 · Post by **Gen.Centralnui** » Wed Jun 24, 2009 2:25 pm

MySQL Version is: 5.0.67.
I'm using phpMyAdmin which version is: 5.0.51

Mircea007 · Post by **Mircea007** » Wed Jun 24, 2009 8:01 pm

will this work with Ultimate points ?

advertisements