Codezwiz >> Forums >> General PHP Nuke Help >> Need Help with adding sql files

Hello,

I am not very good with sql files. Well I know how to load them when it is a SQL Dump. I don't know how to upload them when it is in an install file or how to open and edit them. Is there anyway to make an SQL dump for this or could someone possible explain how to do it. Here is the text.

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `phpbb_medal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`cat_id` mediumint(8) unsigned NOT NULL default '1',
`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_phpbb_medal_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_phpbb_medal_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
CREATE TABLE `nuke_phpbb_medal_cat` (
`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(100) NOT NULL default '',
`cat_order` mediumint(8) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `phpbb_config` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `phpbb_config` VALUES ('medal_display_row', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_col', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_width', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_height', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_order', '');
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10');

This should help you.
[ Register or login to view links on this board. ]

Your table prefix comes from your config.php page. I think the default is set to "nuke".
You can check your config file to make sure.

$prefix = "nuke";