[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.
Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Lord Phobos » Sun Nov 08, 2009 3:09 pm

I had some unspecified "sql errors" installing this mod (when you first click the configuration module).

Now, I can access Medal Configuration without problems.
But I can't access Medal Management.
I get this error:

Code: Select all

SQL ERROR [ mysql4 ]

Table 'Sql26579_4.phpbb_medals' doesn't exist [1146]

SQL

SELECT * FROM phpbb_medals ORDER BY order_id ASC

BACKTRACE


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

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

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

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Can you give me an SQL command to create the missing tables?

Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Lord Phobos » Sun Nov 08, 2009 3:32 pm

I've found in the folder the SQL commands, and tried to insert them via php My Admin, but I couldn't.
These are the commands:

Code: Select all

UPDATE phpbb_modules
 SET module_auth = 'acl_a_manage_medals'
 WHERE module_langname='ACP_MEDALS_TITLE';


CREATE TABLE phpbb_medals
 (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,                                 
	`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',    
	`image` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',  
	`dynamic` tinyint(1) NOT NULL DEFAULT '0',                                     
	`device` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',  
	`number` tinyint(2) NOT NULL DEFAULT '1',                                      
	`parent` smallint(5) NOT NULL DEFAULT '0',                                     
	`nominated` tinyint(1) NOT NULL DEFAULT '0',                                   
	`order_id` smallint(5) unsigned NOT NULL DEFAULT '0',                          
	`description` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,   
	`points` smallint(4) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `order_id` (`order_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE phpbb_medals_awarded
 (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,                                       
	`medal_id` bigint(20) NOT NULL DEFAULT '0',                                          
	`user_id` bigint(20) NOT NULL DEFAULT '0',                                           
	`awarder_id` bigint(20) NOT NULL DEFAULT '0',                                        
	`awarder_un` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',   
	`awarder_color` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',  
	`time` int(11) NOT NULL DEFAULT '0',                                                 
	`nominated` tinyint(1) NOT NULL DEFAULT '0',                                         
	`nominated_reason` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,                
	`points` smallint(4) NOT NULL DEFAULT '0',                                           
	`bbuid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,                   
	`bitfield` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
	PRIMARY KEY (`id`), KEY `time` (`time`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE phpbb_medals_cats
 (
	`id` tinyint(5) unsigned NOT NULL AUTO_INCREMENT,                            
	`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',  
	`order_id` tinyint(5) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `order_id` (`order_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO phpbb_styles_imageset_data
 (image_name, image_filename, image_height, image_width, imageset_id)
 VALUES ('icon_post_approve', 'icon_post_approve.gif', '20', '20', '1');
This is probably the same issue happened during the install.

I get this error:

Code: Select all

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_bin NOT NULL DEFAULT '',    
    `image` varchar(100 
It should be simple to fix it by removing the collate part, can you help me?

Thanks.

Lord Phobos
Registered User
Posts: 613
Joined: Tue May 18, 2004 11:41 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Lord Phobos » Sun Nov 08, 2009 4:08 pm

I solved. :)

For anyone with the same problem as me, here is what I changed the SQL file to:

Code: Select all

UPDATE phpbb_modules
 SET module_auth = 'acl_a_manage_medals'
 WHERE module_langname='ACP_MEDALS_TITLE';


CREATE TABLE phpbb_medals
 (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,                                 
	`name` varchar(30) NOT NULL DEFAULT '',    
	`image` varchar(100) NOT NULL DEFAULT '',  
	`dynamic` tinyint(1) NOT NULL DEFAULT '0',                                     
	`device` varchar(32) NOT NULL DEFAULT '',  
	`number` tinyint(2) NOT NULL DEFAULT '1',                                      
	`parent` smallint(5) NOT NULL DEFAULT '0',                                     
	`nominated` tinyint(1) NOT NULL DEFAULT '0',                                   
	`order_id` smallint(5) unsigned NOT NULL DEFAULT '0',                          
	`description` varchar(255) DEFAULT NULL,   
	`points` smallint(4) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `order_id` (`order_id`)
 ) TYPE=MyISAM ;


CREATE TABLE phpbb_medals_awarded
 (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,                                       
	`medal_id` bigint(20) NOT NULL DEFAULT '0',                                          
	`user_id` bigint(20) NOT NULL DEFAULT '0',                                           
	`awarder_id` bigint(20) NOT NULL DEFAULT '0',                                        
	`awarder_un` varchar(255) NOT NULL DEFAULT '',   
	`awarder_color` varchar(6) NOT NULL DEFAULT '',  
	`time` int(11) NOT NULL DEFAULT '0',                                                 
	`nominated` tinyint(1) NOT NULL DEFAULT '0',                                         
	`nominated_reason` text NOT NULL,                
	`points` smallint(4) NOT NULL DEFAULT '0',                                           
	`bbuid` varchar(255) NOT NULL,                   
	`bitfield` varchar(255) NOT NULL,
	PRIMARY KEY (`id`), KEY `time` (`time`)
 ) TYPE=MyISAM ;


CREATE TABLE phpbb_medals_cats
 (
	`id` tinyint(5) unsigned NOT NULL AUTO_INCREMENT,                            
	`name` varchar(30) NOT NULL DEFAULT '',  
	`order_id` tinyint(5) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `order_id` (`order_id`)
 ) TYPE=MyISAM ;


INSERT INTO phpbb_styles_imageset_data
 (image_name, image_filename, image_height, image_width, imageset_id)
 VALUES ('icon_post_approve', 'icon_post_approve.gif', '20', '20', '1');

fasko
Registered User
Posts: 185
Joined: Wed Jan 28, 2009 9:49 am

Re: [Beta] Medal System MOD for phpBB3

Post by fasko » Sun Nov 08, 2009 5:11 pm

Plees You could add a medal group
Sorry for my english

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 » Mon Nov 09, 2009 1:47 pm

fasko: What would be the need for a medal group?

fasko
Registered User
Posts: 185
Joined: Wed Jan 28, 2009 9:49 am

Re: [Beta] Medal System MOD for phpBB3

Post by fasko » Mon Nov 09, 2009 3:02 pm

Gremlinn wrote:fasko: What would be the need for a medal group?
Yes it is possible

VIP group has 30 users and I would add a whole group at once Medal
Sorry for my english

[BL] Briggers810
Registered User
Posts: 2
Joined: Tue Jun 02, 2009 5:34 pm

Re: [Beta] Medal System MOD for phpBB3

Post by [BL] Briggers810 » Mon Nov 09, 2009 4:48 pm

Sorry if this has already been brought up.

But with this modification on my own site, I am trying to do a system of medals whereby if a user reaches say 100posts I award them a medal, and if they get 200posts they get awarded a medal.

But I was wondering how the Dynamic Image thing worked, and if it were possible for me to just keep awarding a medal and the image would increase the more medals awarded.

In other words how exactly does the dynamic image thing 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 » Mon Nov 09, 2009 6:57 pm

fasko: This has been asked before. I do think this could be useful. I will be working on implementing this. I do not have a time frame as of yet.

Briggers: This has been asked many times. I have another function I need to work similar to this idea. In doing so, it will be easy for me to put this in at the same time. I will be doing this eventually. I do not have a time frame for this at the moment.

To explain how the dynamic image creation works: When medal is awarded once, the base image is shown. When it is awarded a second time, it will add device-2 image centered on top of the base image. The third award will center device-3 onto the base image. Notice the numbers. It is a direct relationship to the amount of awards earned.

Virendar
Registered User
Posts: 41
Joined: Fri Apr 14, 2006 9:14 pm

Re: [Beta] Medal System MOD for phpBB3

Post by Virendar » Wed Nov 11, 2009 2:47 am

Hi there. I want to change every instance that the word "Medal" appears on my forum, to the word "Award".

I don't want to limit to giving only Medals as the prize, rather I want to give trophies, plaques, and ribbons aswell (for which I have already prepared the image icons for)

Thus, it seems wierd when it shows "Medals" and a person has a trophy.


Can someone tell me the files I must edit, and what to edit ?

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 » Wed Nov 11, 2009 1:05 pm

You need to edit the language files that came with this mod. And, don't forget to use a good editor that will save them in UTF8 w/o BOM format (like notepad++).

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

MSM 0.11.0 Alpha release

Post by Gremlinn » Thu Nov 12, 2009 6:01 pm

I have made some major changes to the mod. I have tested in a number of times with automod. Everything seems to be working. I would like one or two volunteers to test it out. I do NOT recommend installation on any live sites, just development locations.

I am looking for installation, setup, visual and use evaluations. Need spelling and grammar checked. Any errors reported, functionality issues noted.

If you would like to help, please let me know by checking my announcement on my test site.
MSM 0.11.0 Alpha announcement
Last edited by Gremlinn on Fri Nov 13, 2009 1:09 pm, edited 1 time in total.

User avatar
madmartyau
Registered User
Posts: 440
Joined: Sun Sep 12, 2004 12:42 pm
Location: Brisbane,Australia
Name: Marty
Contact:

Re: MSM 0.11.0 Alapha release

Post by madmartyau » Thu Nov 12, 2009 9:16 pm

Gremlinn wrote:I have made some major changes to the mod. I have tested in a number of times with automod. Everything seems to be working. I would like one or two volunteers to test it out. I do NOT recommend installation on any live sites, just development locations.

I am looking for installation, setup, visual and use evaluations. Need spelling and grammar checked. Any errors reported, functionality issues noted.

If you would like to help, please let me know by checking my announcement on my test site.
MSM 0.11.0 Alpha announcement
I just registered on your site as "grumpybum" but I can't reply to the post. I'm willing to test this for you mate.
Call me Grumpy.

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 » Fri Nov 13, 2009 1:00 pm

Thanks Madmartyau. I revised the post slightly. I forgot that was a read only area :oops:

teeg
Registered User
Posts: 1
Joined: Mon Nov 16, 2009 8:13 pm

Re: [Beta] Medal System MOD for phpBB3

Post by teeg » Mon Nov 16, 2009 8:16 pm

I realize this may be a bit of an anachronism with the impending new release, but I'm wondering if there's any way to allow users to choose which medals are to be displayed.

i.e: Bob has medal_A, medal_B, medal_C and medal_D, but the forum is set so that Bob can only display three medals next to his posts. Is there some method by which he could prioritize his medals or choose which ones are displayed?

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 » Tue Nov 17, 2009 12:59 pm

At this time, there is no choice. It will display them in the order that you set them in the ACP.

Locked

Return to “[3.0.x] Abandoned MODs”