| LukeH wrote:
|
Ok, I have finally found the time to try and install this.
I believe I have got the SQL sorted (is it right to query in PHPMyAdmin to create the tables? - if not I dont know how to do it ... Help! :))
Problem is that I am trying to install this onto a stand-alone phpBB forum rather than the PHP-Nuke forum. Can anyone give me a list of the fiiles that need to be edited as they are not the same as the ones within PHP-Nuke which means Im lost for which ones I need to change.
Thanks
LukeH
|
| Code:
|
#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`medal_name` varchar(40) NOT NULL default '',
`medal_description` varchar(255) NOT NULL default '',
`medal_image` varchar(40) default NULL,
PRIMARY KEY (`medal_id`)
) TYPE=MyISAM;
#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(11) NOT NULL default '',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;
#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_mod` (
`mod_id` mediumint(8) unsigned NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
PRIMARY KEY (`mod_id`)
) TYPE=MyISAM;
#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `nuke_bbconfig` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_row', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_col', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_width', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_height', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_order', '');
|