| Code:
|
CREATE TABLE `nuke_bbmedal` (
`medal_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cat_id` mediumint(8) UNSIGNED NOT NULL default '1',
`medal_name` varchar(40) NOT NULL,
`medal_description` varchar(255) NOT NULL,
`medal_image` varchar(40) NULL,
PRIMARY KEY (`medal_id`)
);
CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`medal_id` mediumint(8) UNSIGNED NOT NULL,
`user_id` mediumint(8) UNSIGNED NOT NULL,
`issue_reason` varchar(255) NOT NULL,
`issue_time` int(11) NOT NULL,
PRIMARY KEY (`issue_id`)
);
CREATE TABLE `nuke_bbmedal_mod` (
`mod_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`medal_id` mediumint(8) UNSIGNED NOT NULL,
`user_id` mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (`mod_id`)
);
CREATE TABLE `nuke_bbmedal_cat` (
`cat_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cat_title` varchar(100) NOT NULL,
`cat_order` mediumint(8) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
);
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', '');
INSERT INTO `nuke_bbmedal_cat` VALUES ('1', 'Main', '10');
|
| Code:
|
Couldn't obtain medal data
DEBUG MODE
SQL Error : 1146 Table 'wwwexit_nuke.MEDAL_TABLE' doesn't exist
SELECT * FROM MEDAL_TABLE ORDER BY medal_name
Line : 435
File : admin_medal.php
|
38.107.179.220
