[ABD] Medal System MOD for phpBB3

Lord Phobos · 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 · 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 · 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 · Post by **fasko** » Sun Nov 08, 2009 5:11 pm

Plees You could add a medal group

Gremlinn · Post by **Gremlinn** » Mon Nov 09, 2009 1:47 pm

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

fasko · 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

[BL] Briggers810 · 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?

Gremlinn · 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 · 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 ?

Gremlinn · 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++).

Gremlinn · 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

madmartyau · 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.

Gremlinn · 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

teeg · 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?

Gremlinn · 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.

advertisements