CREATE TABLE `nuke_authors` (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) default NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) default NULL,
`counter` int(11) NOT NULL default '0',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`aid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_authors`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_autonews`
--
CREATE TABLE `nuke_autonews` (
`anid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`catid` INT(11) DEFAULT '0' NOT NULL,
`aid` VARCHAR(30) NOT NULL,
`title` VARCHAR(80) NOT NULL,
`time` varchar(19) NOT NULL default '',
`hometext` TEXT NOT NULL,
`bodytext` TEXT NOT NULL,
`topic` INT(11) DEFAULT '1' NOT NULL,
`informant` VARCHAR(40) NOT NULL,
`notes` TEXT NOT NULL,
`ihome` TINYINT(4) DEFAULT '0' NOT NULL,
`alanguage` VARCHAR(30) NOT NULL,
`acomm` TINYINT(4) DEFAULT '0' NOT NULL,
`associated` TEXT NOT NULL,
`ticon` tinyint(1) NOT NULL default '0',
`writes` TINYINT( 1 ) DEFAULT '1' NOT NULL,
PRIMARY KEY (`anid`),
UNIQUE `anid` (`anid`)
);
--
-- Dumping data for table `nuke_autonews`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_banner`
--
CREATE TABLE `nuke_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`alttext` varchar(255) NOT NULL default '',
`date` datetime default NULL,
`dateend` datetime default NULL,
`position` int(10) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`ad_class` varchar(5) NOT NULL default '',
`ad_code` text NOT NULL,
`ad_width` int(4) default '0',
`ad_height` int(4) default '0',
`type` varchar(255) NOT NULL default '',
PRIMARY KEY (`bid`),
KEY `cid` (`cid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_banner`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_banner_clients`
--
CREATE TABLE `nuke_banner_clients` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`login` varchar(10) NOT NULL default '',
`passwd` varchar(10) NOT NULL default '',
`extrainfo` text NOT NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_banner_clients`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_banner_plans`
--
CREATE TABLE `nuke_banner_plans` (
`pid` int(10) NOT NULL auto_increment,
`active` tinyint(1) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`delivery` varchar(10) NOT NULL default '',
`delivery_type` varchar(25) NOT NULL default '',
`price` varchar(25) NOT NULL default '0',
`buy_links` text NOT NULL,
PRIMARY KEY (`pid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_banner_plans`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_banner_positions`
--
CREATE TABLE `nuke_banner_positions` (
`apid` int(10) NOT NULL auto_increment,
`position_number` int(5) NOT NULL default '0',
`position_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`apid`),
KEY `position_number` (`position_number`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
--
-- Dumping data for table `nuke_banner_positions`
--
INSERT INTO `nuke_banner_positions` VALUES (1, 0, 'Page Top');
INSERT INTO `nuke_banner_positions` VALUES (2, 1, 'Left Block');
INSERT INTO `nuke_banner_positions` VALUES (3, 2, 'Page Bottom');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_banner_terms`
--
CREATE TABLE `nuke_banner_terms` (
`terms_body` text NOT NULL,
`country` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_banner_terms`
--
INSERT INTO `nuke_banner_terms` VALUES ('Introduction: This Agreement between you and [sitename] consists of these Terms and Conditions. "You" or "Advertiser" means the entity identified in this enrollment form, and/or any agency acting on its behalf, which shall also be bound by the terms of this Agreement. Please read very carefully these Terms and Conditions.
Uses: You agree that your ads may be placed on (i) [sitename] web site and (ii) Any ads may be modified without your consent to comply with any policy of [sitename]. [sitename] reserves the right to, and in its sole discretion may, at any time review, reject, modify, or remove any ad. No liability of [sitename] and/or its owner(s) shall result from any such decision.
Parties'' Responsibilities: You are responsible of your own site and/or service advertised in [sitename] web site. You are solely responsible for the advertising image creation, advertising text and for the content of your ads, including URL links. [sitename] is not responsible for anything regarding your Web site(s) including, but not limited to, maintenance of your Web site(s), order entry, customer service, payment processing, shipping, cancellations or returns.
Impressions Count: Any hit to [sitename] web site is counted as an impression. Due to our advertising price we don''t discriminate from users or automated robots. Even if you access to [sitename] web site and see your own banner ad it will be counted as a valid impression. Only in the case of [sitename] web site administrator, the impressions will not be counted.
Termination, Cancellation: [sitename] may at any time, in its sole discretion, terminate the Campaign, terminate this Agreement, or cancel any ad(s) or your use of any Target. [sitename] will notify you via email of any such termination or cancellation, which shall be effective immediately. No refund will be made for any reason. Remaining impressions will be stored in a database and you''ll be able to request another campaign to complete your inventory. You may cancel any ad and/or terminate this Agreement with or without cause at any time. Termination of your account shall be effective when [sitename] receives your notice via email. No refund will be made for any reason. Remaining impressions will be stored in a database for future uses by you and/or your company.
Content: [sitename] web site doesn''t accepts advertising that contains: (i) pornography, (ii) explicit adult content, (iii) moral questionable content, (iv) illegal content of any kind, (v) illegal drugs promotion, (vi) racism, (vii) politics content, (viii) religious content, and/or (ix) fraudulent suspicious content. If your advertising and/or target web site has any of this content and you purchased an advertising package, you''ll not receive refund of any kind but your banners ads impressions will be stored for future use.
Confidentiality: Each party agrees not to disclose Confidential Information of the other party without prior written consent except as provided herein. "Confidential Information" includes (i) ads, prior to publication, (ii) submissions or modifications relating to any advertising campaign, (iii) clickthrough rates or other statistics (except in an aggregated form that includes no identifiable information about you), and (iv) any other information designated in writing as "Confidential." It does not include information that has become publicly known through no breach by a party, or has been (i) independently developed without access to the other party''s Confidential Information; (ii) rightfully received from a third party; or (iii) required to be disclosed by law or by a governmental authority.
No Guarantee: [sitename] makes no guarantee regarding the levels of clicks for any ad on its site. [sitename] may offer the same Target to more than one advertiser. You may not receive exclusivity unless special private contract between [sitename] and you.
No Warranty: [sitename] MAKES NO WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION WITH RESPECT TO ADVERTISING AND OTHER SERVICES, AND EXPRESSLY DISCLAIMS THE WARRANTIES OR CONDITIONS OF NONINFRINGEMENT, MERCHANTABILITY AND FITNESS FOR ANY PARTICULAR PURPOSE.
Limitations of Liability: In no event shall [sitename] be liable for any act or omission, or any event directly or indirectly resulting from any act or omission of Advertiser, Partner, or any third parties (if any). EXCEPT FOR THE PARTIES'' INDEMNIFICATION AND CONFIDENTIALITY OBLIGATIONS HEREUNDER, (i) IN NO EVENT SHALL EITHER PARTY BE LIABLE UNDER THIS AGREEMENT FOR ANY CONSEQUENTIAL, SPECIAL, INDIRECT, EXEMPLARY, PUNITIVE, OR OTHER DAMAGES WHETHER IN CONTRACT, TORT OR ANY OTHER LEGAL THEORY, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES AND NOTWITHSTANDING ANY FAILURE OF ESSENTIAL PURPOSE OF ANY LIMITED REMEDY AND (ii) [sitename] AGGREGATE LIABILITY TO ADVERTISER UNDER THIS AGREEMENT FOR ANY CLAIM IS LIMITED TO THE AMOUNT PAID TO [sitename] BY ADVERTISER FOR THE AD GIVING RISE TO THE CLAIM. Each party acknowledges that the other party has entered into this Agreement relying on the limitations of liability stated herein and that those limitations are an essential basis of the bargain between the parties. Without limiting the foregoing and except for payment obligations, neither party shall have any liability for any failure or delay resulting from any condition beyond the reasonable control of such party, including but not limited to governmental action or acts of terrorism, earthquake or other acts of God, labor conditions, and power failures.
Payment: You agree to pay in advance the cost of the advertising. [sitename] will not setup any banner ads campaign(s) unless the payment process is complete. [sitename] may change its pricing at any time without prior notice. If you have an advertising campaign running and/or impressions stored for future use for any mentioned cause and [sitename] changes its pricing, you''ll not need to pay any difference. Your purchased banners fee will remain the same. Charges shall be calculated solely based on records maintained by [sitename]. No other measurements or statistics of any kind shall be accepted by [sitename] or have any effect under this Agreement.
Representations and Warranties: You represent and warrant that (a) all of the information provided by you to [sitename] to enroll in the Advertising Campaign is correct and current; (b) you hold all rights to permit [sitename] and any Partner(s) to use, reproduce, display, transmit and distribute your ad(s); and (c) [sitename] and any Partner(s) Use, your Target(s), and any site(s) linked to, and products or services to which users are directed, will not, in any state or country where the ad is displayed (i) violate any criminal laws or third party rights giving rise to civil liability, including but not limited to trademark rights or rights relating to the performance of music; or (ii) encourage conduct that would violate any criminal or civil law. You further represent and warrant that any Web site linked to your ad(s) (i) complies with all laws and regulations in any state or country where the ad is displayed; (ii) does not breach and has not breached any duty toward or rights of any person or entity including, without limitation, rights of publicity or privacy, or rights or duties under consumer protection, product liability, tort, or contract theories; and (iii) is not false, misleading, defamatory, libelous, slanderous or threatening.
Your Obligation to Indemnify: You agree to indemnify, defend and hold [sitename], its agents, affiliates, subsidiaries, directors, officers, employees, and applicable third parties (e.g., all relevant Partner(s), licensors, licensees, consultants and contractors) ("Indemnified Person(s)") harmless from and against any and all third party claims, liability, loss, and expense (including damage awards, settlement amounts, and reasonable legal fees), brought against any Indemnified Person(s), arising out of, related to or which may arise from your use of the Advertising Program, your Web site, and/or your breach of any term of this Agreement. Customer understands and agrees that each Partner, as defined herein, has the right to assert and enforce its rights under this Section directly on its own behalf as a third party beneficiary.
Information Rights: [sitename] may retain and use for its own purposes all information you provide, including but not limited to Targets, URLs, the content of ads, and contact and billing information. [sitename] may share this information about you with business partners and/or sponsors. [sitename] will not sell your information. Your name, web site''s URL and related graphics shall be used by [sitename] in its own web site at any time as a sample to the public, even if your Advertising Campaign has been finished.
Miscellaneous: Any decision made by [sitename] under this Agreement shall be final. [sitename] shall have no liability for any such decision. You will be responsible for all reasonable expenses (including attorneys'' fees) incurred by [sitename] in collecting unpaid amounts under this Agreement. This Agreement shall be governed by the laws of [country]. Any dispute or claim arising out of or in connection with this Agreement shall be adjudicated in [country]. This constitutes the entire agreement between the parties with respect to the subject matter hereof. Advertiser may not resell, assign, or transfer any of its rights hereunder. Any such attempt may result in termination of this Agreement, without liability to [sitename] and without any refund. The relationship(s) between [sitename] and the "Partners" is not one of a legal partnership relationship, but is one of independent contractors. This Agreement shall be construed as if both parties jointly wrote it.
', 'Canada');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbadvanced_username_color`
--
CREATE TABLE `nuke_bbadvanced_username_color` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(255) NOT NULL default '',
`group_color` varchar(6) NOT NULL default '',
`group_weight` smallint(2) NOT NULL default '0',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Dumping data for table `nuke_bbadvanced_username_color`
--
INSERT INTO `nuke_bbadvanced_username_color` VALUES (1, 'Administrators', 'FFA34F', 1);
INSERT INTO `nuke_bbadvanced_username_color` VALUES (2, 'Moderators', '006600', 2);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbattach_quota`
--
CREATE TABLE `nuke_bbattach_quota` (
`user_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`quota_type` smallint(2) NOT NULL default '0',
`quota_limit_id` mediumint(8) unsigned NOT NULL default '0',
KEY `quota_type` (`quota_type`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbattach_quota`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbattachments`
--
CREATE TABLE `nuke_bbattachments` (
`attach_id` mediumint(8) unsigned NOT NULL default '0',
`post_id` mediumint(8) unsigned NOT NULL default '0',
`privmsgs_id` mediumint(8) unsigned NOT NULL default '0',
`user_id_1` mediumint(8) NOT NULL default '0',
`user_id_2` mediumint(8) NOT NULL default '0',
KEY `attach_id_post_id` (`attach_id`,`post_id`),
KEY `attach_id_privmsgs_id` (`attach_id`,`privmsgs_id`),
KEY `post_id` (`post_id`),
KEY `privmsgs_id` (`privmsgs_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbattachments`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbattachments_config`
--
CREATE TABLE `nuke_bbattachments_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbattachments_config`
--
INSERT INTO `nuke_bbattachments_config` VALUES ('upload_dir', 'modules/Forums/files');
INSERT INTO `nuke_bbattachments_config` VALUES ('upload_img', 'modules/Forums/images/icon_clip.gif');
INSERT INTO `nuke_bbattachments_config` VALUES ('topic_icon', 'modules/Forums/images/icon_clip.gif');
INSERT INTO `nuke_bbattachments_config` VALUES ('display_order', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('max_filesize', '262144');
INSERT INTO `nuke_bbattachments_config` VALUES ('attachment_quota', '52428800');
INSERT INTO `nuke_bbattachments_config` VALUES ('max_filesize_pm', '262144');
INSERT INTO `nuke_bbattachments_config` VALUES ('max_attachments', '3');
INSERT INTO `nuke_bbattachments_config` VALUES ('max_attachments_pm', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('disable_mod', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('allow_pm_attach', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('attachment_topic_review', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('allow_ftp_upload', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('show_apcp', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('attach_version', '2.4.5');
INSERT INTO `nuke_bbattachments_config` VALUES ('default_upload_quota', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('default_pm_quota', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_server', 'ftp.yoursite.com');
INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_path', '/public_html/modules/Forums/files');
INSERT INTO `nuke_bbattachments_config` VALUES ('download_path', 'http://www.yoursite.com/modules/Forums/files');
INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_user', '');
INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_pass', '');
INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_pasv_mode', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_display_inlined', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_max_width', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_max_height', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_link_width', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_link_height', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_create_thumbnail', '1');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_min_thumb_filesize', '12000');
INSERT INTO `nuke_bbattachments_config` VALUES ('img_imagick', '/usr/bin/convert');
INSERT INTO `nuke_bbattachments_config` VALUES ('use_gd2', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('wma_autoplay', '0');
INSERT INTO `nuke_bbattachments_config` VALUES ('flash_autoplay', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbattachments_desc`
--
CREATE TABLE `nuke_bbattachments_desc` (
`attach_id` mediumint(8) unsigned NOT NULL auto_increment,
`physical_filename` varchar(255) NOT NULL default '',
`real_filename` varchar(255) NOT NULL default '',
`download_count` mediumint(8) unsigned NOT NULL default '0',
`comment` varchar(255) default NULL,
`extension` varchar(100) default NULL,
`mimetype` varchar(100) default NULL,
`filesize` int(20) NOT NULL default '0',
`filetime` int(11) NOT NULL default '0',
`thumbnail` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`attach_id`),
KEY `filetime` (`filetime`),
KEY `physical_filename` (`physical_filename`(10)),
KEY `filesize` (`filesize`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbattachments_desc`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbauth_access`
--
CREATE TABLE `nuke_bbauth_access` (
`group_id` mediumint(8) NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0',
`auth_read` tinyint(1) NOT NULL default '0',
`auth_post` tinyint(1) NOT NULL default '0',
`auth_reply` tinyint(1) NOT NULL default '0',
`auth_edit` tinyint(1) NOT NULL default '0',
`auth_delete` tinyint(1) NOT NULL default '0',
`auth_sticky` tinyint(1) NOT NULL default '0',
`auth_announce` tinyint(1) NOT NULL default '0',
`auth_globalannounce` tinyint(1) NOT NULL default '0',
`auth_vote` tinyint(1) NOT NULL default '0',
`auth_pollcreate` tinyint(1) NOT NULL default '0',
`auth_attachments` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
`auth_download` tinyint(1) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbauth_access`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbbanlist`
--
CREATE TABLE `nuke_bbbanlist` (
`ban_id` mediumint(8) unsigned NOT NULL auto_increment,
`ban_userid` mediumint(8) NOT NULL default '0',
`ban_ip` varchar(8) NOT NULL default '',
`ban_email` varchar(255) default NULL,
`ban_time` int(11) default NULL,
PRIMARY KEY (`ban_id`),
KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbbanlist`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbcategories`
--
CREATE TABLE `nuke_bbcategories` (
`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(100) default NULL,
`cat_order` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_bbcategories`
--
INSERT INTO `nuke_bbcategories` VALUES (1, 'General', 10);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbconfig`
--
CREATE TABLE `nuke_bbconfig` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbconfig`
--
INSERT INTO `nuke_bbconfig` VALUES ('config_id', '1');
INSERT INTO `nuke_bbconfig` VALUES ('board_disable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('board_disable_adminview', '1');
INSERT INTO `nuke_bbconfig` VALUES ('board_disable_msg', 'The board is currently disabled...');
INSERT INTO `nuke_bbconfig` VALUES ('sitename', 'My Site');
INSERT INTO `nuke_bbconfig` VALUES ('site_desc', '');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_name', 'nukeevo');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_path', '/');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_domain', 'MySite.com');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_secure', '0');
INSERT INTO `nuke_bbconfig` VALUES ('session_length', '3600');
INSERT INTO `nuke_bbconfig` VALUES ('allow_html', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `nuke_bbconfig` VALUES ('allow_bbcode', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_smilies', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_sig', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_namechange', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_theme_create', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_local', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_remote', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_upload', '0');
INSERT INTO `nuke_bbconfig` VALUES ('override_user_style', '1');
INSERT INTO `nuke_bbconfig` VALUES ('posts_per_page', '15');
INSERT INTO `nuke_bbconfig` VALUES ('topics_per_page', '50');
INSERT INTO `nuke_bbconfig` VALUES ('hot_threshold', '25');
INSERT INTO `nuke_bbconfig` VALUES ('max_poll_options', '10');
INSERT INTO `nuke_bbconfig` VALUES ('max_sig_chars', '255');
INSERT INTO `nuke_bbconfig` VALUES ('max_smilies', '15');
INSERT INTO `nuke_bbconfig` VALUES ('max_inbox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('max_savebox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('board_email_sig', 'Thanks, Webmaster@MySite.com');
INSERT INTO `nuke_bbconfig` VALUES ('board_email', 'Webmaster@MySite.com');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_delivery', '0');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_host', '');
INSERT INTO `nuke_bbconfig` VALUES ('require_activation', '0');
INSERT INTO `nuke_bbconfig` VALUES ('flood_interval', '15');
INSERT INTO `nuke_bbconfig` VALUES ('search_flood_interval', '15');
INSERT INTO `nuke_bbconfig` VALUES ('board_email_form', '0');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_filesize', '6144');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_width', '80');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_height', '80');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO `nuke_bbconfig` VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO `nuke_bbconfig` VALUES ('default_style', '1');
INSERT INTO `nuke_bbconfig` VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO `nuke_bbconfig` VALUES ('board_timezone', '10');
INSERT INTO `nuke_bbconfig` VALUES ('prune_enable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('privmsg_disable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('gzip_compress', '0');
INSERT INTO `nuke_bbconfig` VALUES ('coppa_fax', '');
INSERT INTO `nuke_bbconfig` VALUES ('coppa_mail', '');
INSERT INTO `nuke_bbconfig` VALUES ('board_startdate', '1131089812');
INSERT INTO `nuke_bbconfig` VALUES ('default_lang', 'english');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_username', '');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_password', '');
INSERT INTO `nuke_bbconfig` VALUES ('record_online_users', '2');
INSERT INTO `nuke_bbconfig` VALUES ('record_online_date', '1034668530');
INSERT INTO `nuke_bbconfig` VALUES ('server_name', 'MySite.com');
INSERT INTO `nuke_bbconfig` VALUES ('server_port', '80');
INSERT INTO `nuke_bbconfig` VALUES ('script_path', '/modules/Forums/');
INSERT INTO `nuke_bbconfig` VALUES ('version', '.0.22');
INSERT INTO `nuke_bbconfig` VALUES ('enable_confirm', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sendmail_fix', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_lines', '5');
INSERT INTO `nuke_bbconfig` VALUES ('sig_wordwrap', '100');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_font_sizes', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_min_font_size', '7');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_font_size', '12');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_bold', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_italic', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_underline', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_colors', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_quote', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_code', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_list', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_url', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_images', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_images', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_height', '75');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_width', '500');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_on_max_img_size_fail', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_files_size', '10');
INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_av_files_size', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sig_exotic_bbcodes_disallowed', '');
INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_smilies', '1');
INSERT INTO `nuke_bbconfig` VALUES ('report_email', '1');
INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply', '1');
INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply_bbc', '1');
INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply_smilies', '22');
INSERT INTO `nuke_bbconfig` VALUES ('wrap_enable', '1');
INSERT INTO `nuke_bbconfig` VALUES ('wrap_min', '50');
INSERT INTO `nuke_bbconfig` VALUES ('wrap_max', '99');
INSERT INTO `nuke_bbconfig` VALUES ('wrap_def', '70');
INSERT INTO `nuke_bbconfig` VALUES ('allow_quickreply', '1');
INSERT INTO `nuke_bbconfig` VALUES ('anonymous_show_sqr', '0');
INSERT INTO `nuke_bbconfig` VALUES ('anonymous_sqr_mode', '0');
INSERT INTO `nuke_bbconfig` VALUES ('quick_search_enable', '1');
INSERT INTO `nuke_bbconfig` VALUES ('sig_line', '
');
INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_guests_url', 'modules/Forums/images/avatars/blank.gif');
INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_users_url', 'modules/Forums/images/avatars/blank.gif');
INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_set', '2');
INSERT INTO `nuke_bbconfig` VALUES ('pm_allow_threshold', '0');
INSERT INTO `nuke_bbconfig` VALUES ('welcome_pm', '0');
INSERT INTO `nuke_bbconfig` VALUES ('default_time_mode', '6');
INSERT INTO `nuke_bbconfig` VALUES ('default_dst_time_lag', '60');
INSERT INTO `nuke_bbconfig` VALUES ('glance_show', '1');
INSERT INTO `nuke_bbconfig` VALUES ('glance_show_override', '1');
INSERT INTO `nuke_bbconfig` VALUES ('glance_news_id', '0');
INSERT INTO `nuke_bbconfig` VALUES ('glance_num_news', '0');
INSERT INTO `nuke_bbconfig` VALUES ('glance_num', '6');
INSERT INTO `nuke_bbconfig` VALUES ('glance_ignore_forums', '0');
INSERT INTO `nuke_bbconfig` VALUES ('glance_table_width', '100%');
INSERT INTO `nuke_bbconfig` VALUES ('glance_auth_read', '1');
INSERT INTO `nuke_bbconfig` VALUES ('glance_topic_length', '0');
INSERT INTO `nuke_bbconfig` VALUES ('online_time', '300');
INSERT INTO `nuke_bbconfig` VALUES ('display_users_today', '0');
INSERT INTO `nuke_bbconfig` VALUES ('locked_view_open', 'Locked: ');
INSERT INTO `nuke_bbconfig` VALUES ('locked_view_close', '');
INSERT INTO `nuke_bbconfig` VALUES ('global_view_open', 'Global Announcement:');
INSERT INTO `nuke_bbconfig` VALUES ('global_view_close', '');
INSERT INTO `nuke_bbconfig` VALUES ('announce_view_open', 'Announcement:');
INSERT INTO `nuke_bbconfig` VALUES ('announce_view_close', '');
INSERT INTO `nuke_bbconfig` VALUES ('sticky_view_open', 'Sticky:');
INSERT INTO `nuke_bbconfig` VALUES ('sticky_view_close', '');
INSERT INTO `nuke_bbconfig` VALUES ('moved_view_open', 'Moved:');
INSERT INTO `nuke_bbconfig` VALUES ('moved_view_close', '');
INSERT INTO `nuke_bbconfig` VALUES ('initial_group_id', '5');
INSERT INTO `nuke_bbconfig` VALUES ('hide_links', '0');
INSERT INTO `nuke_bbconfig` VALUES ('hide_emails', '0');
INSERT INTO `nuke_bbconfig` VALUES ('hide_images', '0');
INSERT INTO `nuke_bbconfig` VALUES ('use_dhtml', '1');
INSERT INTO `nuke_bbconfig` VALUES ('anonymous_open_sqr', '0');
INSERT INTO `nuke_bbconfig` VALUES ('smilies_in_titles', '1');
INSERT INTO `nuke_bbconfig` VALUES ('show_edited_logs', '1');
INSERT INTO `nuke_bbconfig` VALUES ('show_locked_logs', '1');
INSERT INTO `nuke_bbconfig` VALUES ('show_unlocked_logs', '1');
INSERT INTO `nuke_bbconfig` VALUES ('show_splitted_logs', '1');
INSERT INTO `nuke_bbconfig` VALUES ('show_moved_logs', '1');
INSERT INTO `nuke_bbconfig` VALUES ('logs_view_level', '2');
INSERT INTO `nuke_bbconfig` VALUES ('aprvmArchive', '0');
INSERT INTO `nuke_bbconfig` VALUES ('aprvmVersion', '1.6.0');
INSERT INTO `nuke_bbconfig` VALUES ('aprvmView', '0');
INSERT INTO `nuke_bbconfig` VALUES ('aprvmRows', '25');
INSERT INTO `nuke_bbconfig` VALUES ('aprvmIP', '1');
INSERT INTO `nuke_bbconfig` VALUES ('image_resize_width', '400');
INSERT INTO `nuke_bbconfig` VALUES ('image_resize_height', '400');
INSERT INTO `nuke_bbconfig` VALUES ('use_theme_style', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_autologin','1');
INSERT INTO `nuke_bbconfig` VALUES ('max_autologin_time','0');
INSERT INTO `nuke_bbconfig` VALUES ('max_login_attempts', '5');
INSERT INTO `nuke_bbconfig` VALUES ('login_reset_time', '30');
INSERT INTO `nuke_bbconfig` VALUES ('show_sig_once', '0');
INSERT INTO `nuke_bbconfig` VALUES ('show_avatar_once', '0');
INSERT INTO `nuke_bbconfig` VALUES ('show_rank_once', '0');
INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1');
INSERT INTO `nuke_bbconfig` VALUES ('rand_seed', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbdisallow`
--
CREATE TABLE `nuke_bbdisallow` (
`disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
`disallow_username` varchar(25) default NULL,
PRIMARY KEY (`disallow_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbdisallow`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbextension_groups`
--
CREATE TABLE `nuke_bbextension_groups` (
`group_id` mediumint(8) NOT NULL auto_increment,
`group_name` varchar(20) NOT NULL default '',
`cat_id` tinyint(2) NOT NULL default '0',
`allow_group` tinyint(1) NOT NULL default '0',
`download_mode` tinyint(1) unsigned NOT NULL default '1',
`upload_icon` varchar(100) default '',
`max_filesize` int(20) NOT NULL default '0',
`forum_permissions` varchar(255) NOT NULL default '',
PRIMARY KEY (`group_id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
--
-- Dumping data for table `nuke_bbextension_groups`
--
INSERT INTO `nuke_bbextension_groups` VALUES (1, 'Images', 1, 1, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (2, 'Archives', 0, 1, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (3, 'Plain Text', 0, 0, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (4, 'Documents', 0, 0, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (5, 'Real Media', 0, 0, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (6, 'Streams', 2, 0, 2, '', 262144, '');
INSERT INTO `nuke_bbextension_groups` VALUES (7, 'Flash Files', 3, 0, 2, '', 262144, '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbextensions`
--
CREATE TABLE `nuke_bbextensions` (
`ext_id` mediumint(8) unsigned NOT NULL auto_increment,
`group_id` mediumint(8) unsigned NOT NULL default '0',
`extension` varchar(100) NOT NULL default '',
`comment` varchar(100) default NULL,
PRIMARY KEY (`ext_id`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;
--
-- Dumping data for table `nuke_bbextensions`
--
INSERT INTO `nuke_bbextensions` VALUES (1, 1, 'gif', '');
INSERT INTO `nuke_bbextensions` VALUES (2, 1, 'png', '');
INSERT INTO `nuke_bbextensions` VALUES (3, 1, 'jpeg', '');
INSERT INTO `nuke_bbextensions` VALUES (4, 1, 'jpg', '');
INSERT INTO `nuke_bbextensions` VALUES (5, 1, 'tif', '');
INSERT INTO `nuke_bbextensions` VALUES (6, 1, 'tga', '');
INSERT INTO `nuke_bbextensions` VALUES (7, 2, 'gtar', '');
INSERT INTO `nuke_bbextensions` VALUES (8, 2, 'gz', '');
INSERT INTO `nuke_bbextensions` VALUES (9, 2, 'tar', '');
INSERT INTO `nuke_bbextensions` VALUES (10, 2, 'zip', '');
INSERT INTO `nuke_bbextensions` VALUES (11, 2, 'rar', '');
INSERT INTO `nuke_bbextensions` VALUES (12, 2, 'ace', '');
INSERT INTO `nuke_bbextensions` VALUES (13, 3, 'txt', '');
INSERT INTO `nuke_bbextensions` VALUES (14, 3, 'c', '');
INSERT INTO `nuke_bbextensions` VALUES (15, 3, 'h', '');
INSERT INTO `nuke_bbextensions` VALUES (16, 3, 'cpp', '');
INSERT INTO `nuke_bbextensions` VALUES (17, 3, 'hpp', '');
INSERT INTO `nuke_bbextensions` VALUES (18, 3, 'diz', '');
INSERT INTO `nuke_bbextensions` VALUES (19, 4, 'xls', '');
INSERT INTO `nuke_bbextensions` VALUES (20, 4, 'doc', '');
INSERT INTO `nuke_bbextensions` VALUES (21, 4, 'dot', '');
INSERT INTO `nuke_bbextensions` VALUES (22, 4, 'pdf', '');
INSERT INTO `nuke_bbextensions` VALUES (23, 4, 'ai', '');
INSERT INTO `nuke_bbextensions` VALUES (24, 4, 'ps', '');
INSERT INTO `nuke_bbextensions` VALUES (25, 4, 'ppt', '');
INSERT INTO `nuke_bbextensions` VALUES (26, 5, 'rm', '');
INSERT INTO `nuke_bbextensions` VALUES (27, 6, 'wma', '');
INSERT INTO `nuke_bbextensions` VALUES (28, 7, 'swf', '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbforbidden_extensions`
--
CREATE TABLE `nuke_bbforbidden_extensions` (
`ext_id` mediumint(8) unsigned NOT NULL auto_increment,
`extension` varchar(100) NOT NULL default '',
PRIMARY KEY (`ext_id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
--
-- Dumping data for table `nuke_bbforbidden_extensions`
--
INSERT INTO `nuke_bbforbidden_extensions` VALUES (1, 'php');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (2, 'php3');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (3, 'php4');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (4, 'phtml');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (5, 'pl');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (6, 'asp');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (7, 'cgi');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (8, 'com');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (9, 'bat');
INSERT INTO `nuke_bbforbidden_extensions` VALUES (10, 'scr');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbforum_prune`
--
CREATE TABLE `nuke_bbforum_prune` (
`prune_id` mediumint(8) unsigned NOT NULL auto_increment,
`forum_id` smallint(5) unsigned NOT NULL default '0',
`prune_days` tinyint(4) unsigned NOT NULL default '0',
`prune_freq` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`prune_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbforum_prune`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbforums`
--
CREATE TABLE `nuke_bbforums` (
`forum_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` mediumint(8) unsigned NOT NULL default '0',
`forum_name` varchar(150) default NULL,
`forum_desc` text,
`forum_status` tinyint(4) NOT NULL default '0',
`forum_order` mediumint(8) unsigned NOT NULL default '1',
`forum_posts` mediumint(8) unsigned NOT NULL default '0',
`forum_topics` mediumint(8) unsigned NOT NULL default '0',
`forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`prune_next` int(11) default NULL,
`prune_enable` tinyint(1) NOT NULL default '1',
`auth_view` tinyint(2) NOT NULL default '0',
`auth_read` tinyint(2) NOT NULL default '0',
`auth_post` tinyint(2) NOT NULL default '0',
`auth_reply` tinyint(2) NOT NULL default '0',
`auth_edit` tinyint(2) NOT NULL default '0',
`auth_delete` tinyint(2) NOT NULL default '0',
`auth_sticky` tinyint(2) NOT NULL default '0',
`auth_announce` tinyint(2) NOT NULL default '0',
`auth_globalannounce` tinyint(2) NOT NULL default '3',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_pollcreate` tinyint(2) NOT NULL default '0',
`auth_attachments` tinyint(2) NOT NULL default '0',
`forum_display_sort` tinyint(1) NOT NULL default '0',
`forum_display_order` tinyint(1) NOT NULL default '0',
`auth_download` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`forum_id`),
KEY `forums_order` (`forum_order`),
KEY `cat_id` (`cat_id`),
KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_bbforums`
--
INSERT INTO `nuke_bbforums` VALUES (1, 1, 'Site', '', 0, 10, 1, 1, 1, NULL, 0, 0, 0, 0, 0, 1, 1, 3, 3, 3, 1, 1, 1, 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbgroups`
--
CREATE TABLE `nuke_bbgroups` (
`group_id` mediumint(8) NOT NULL auto_increment,
`group_type` tinyint(4) NOT NULL default '1',
`group_name` varchar(40) NOT NULL default '',
`group_description` varchar(255) NOT NULL default '',
`group_moderator` mediumint(8) NOT NULL default '0',
`group_single_user` tinyint(1) NOT NULL default '1',
`group_allow_pm` tinyint(2) NOT NULL default '5',
`group_color` varchar(15) NOT NULL default '',
`group_rank` varchar(5) NOT NULL default '0',
`max_inbox` mediumint( 10 ) NOT NULL default '100',
`max_sentbox` mediumint( 10 ) NOT NULL default '100',
`max_savebox` mediumint( 10 ) NOT NULL default '100',
`override_max_inbox` tinyint( 1 ) NOT NULL default '0',
`override_max_sentbox` tinyint( 1 ) NOT NULL default '0',
`override_max_savebox` tinyint( 1 ) NOT NULL default '0',
`group_count` INT (4) UNSIGNED DEFAULT '99999999',
`group_count_max` INT (4) UNSIGNED DEFAULT '99999999',
`group_count_enable` SMALLINT (2) UNSIGNED DEFAULT '0',
PRIMARY KEY (`group_id`),
KEY `group_single_user` (`group_single_user`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--
-- Dumping data for table `nuke_bbgroups`
--
INSERT INTO `nuke_bbgroups` VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1, 0, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0');
INSERT INTO `nuke_bbgroups` VALUES (3, 2, 'Moderators', 'Moderators of this Forum', 2, 0, 5, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0');
INSERT INTO `nuke_bbgroups` VALUES (5, 0, 'Users', 'Default Usergroup', 2, 0, 5, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bblogs`
--
CREATE TABLE `nuke_bblogs` (
`log_id` mediumint(10) NOT NULL auto_increment,
`mode` varchar(50) default '',
`topic_id` mediumint(10) default '0',
`user_id` mediumint(8) default '0',
`username` varchar(255) default '',
`user_ip` varchar(8) NOT NULL default '0',
`time` int(11) default '0',
`new_topic_id` mediumint(10) NOT NULL default '0',
`forum_id` mediumint(10) NOT NULL default '0',
`new_forum_id` mediumint(10) NOT NULL default '0',
`last_post_id` mediumint(10) NOT NULL default '0',
PRIMARY KEY (`log_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bblogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bblogs_config`
--
CREATE TABLE `nuke_bblogs_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bblogs_config`
--
INSERT INTO `nuke_bblogs_config` VALUES ('all_admin', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbpost_reports`
--
CREATE TABLE `nuke_bbpost_reports` (
`report_id` mediumint(8) NOT NULL auto_increment,
`post_id` mediumint(8) NOT NULL default '0',
`reporter_id` mediumint(8) NOT NULL default '0',
`report_status` tinyint(1) NOT NULL default '0',
`report_time` int(11) NOT NULL default '0',
`report_comments` text,
`last_action_user_id` mediumint(8) default '0',
`last_action_time` int(11) NOT NULL default '0',
`last_action_comments` text,
PRIMARY KEY (`report_id`)
);
--
-- Dumping data for table `nuke_bbpost_reports`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbposts`
--
CREATE TABLE `nuke_bbposts` (
`post_id` mediumint(8) unsigned NOT NULL auto_increment,
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`poster_id` mediumint(8) NOT NULL default '0',
`post_time` int(11) NOT NULL default '0',
`poster_ip` varchar(8) NOT NULL default '',
`post_username` varchar(25) default NULL,
`enable_bbcode` tinyint(1) NOT NULL default '1',
`enable_html` tinyint(1) NOT NULL default '0',
`enable_smilies` tinyint(1) NOT NULL default '1',
`enable_sig` tinyint(1) NOT NULL default '1',
`post_edit_time` int(11) default NULL,
`post_edit_count` smallint(5) unsigned NOT NULL default '0',
`post_attachment` tinyint(1) NOT NULL default '0',
`post_move` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster_id`),
KEY `post_time` (`post_time`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_bbposts`
--
INSERT INTO `nuke_bbposts` VALUES (1, 1, 1, 2, 1125187439, '7f000001', '', 1, 1, 1, 0, NULL, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbposts_text`
--
CREATE TABLE `nuke_bbposts_text` (
`post_id` mediumint(8) unsigned NOT NULL default '0',
`bbcode_uid` varchar(10) NOT NULL default '',
`post_subject` varchar(60) default NULL,
`post_text` text,
PRIMARY KEY (`post_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbposts_text`
--
INSERT INTO `nuke_bbposts_text` VALUES (1, '16f8943d60', 'Welcome to Nuke-Evolution!', 'Thanks for installing Nuke-Evolution. The Evo Team has put a lot of hard work into this release to make it the fastest, most functional and most secure version of PHP-Nuke ever. We encourage you to read through all of the included documentation so you fully understand the power within Evo. \r\n\r\nInside the original archive you downloaded you will find several folders containing helpful information. \r\n\r\nThe first is the "Install" folder which we hope you are already familiar with. This folder contains three documents which help you properly install and configure your new Evo site. If you haven''t fully gone through these already please do it now! \r\n\r\nThe second is the "Help" folder. Inside this folder you will find some very helpful documents that our team has put together to explain some of the features inside Evo. You will also find some documents that will help resolve a few errors you may run in to due to browser settings or improperly setup software. \r\n\r\nThe third is the "Theme Edits" folder. If you would like to convert a PHP-Nuke theme to work with Evo you must follow the provided instructions within this folder. \r\n\r\nWe trust that Evo will be the best Nuke software you have ever run. Enjoy and be sure to stop by www.nuke-evolution.com for support, updates or just to say hi! \r\n\r\n[b:16f8943d60]- The Nuke-Evolution Team[/b:16f8943d60]');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbprivmsgs`
--
CREATE TABLE `nuke_bbprivmsgs` (
`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
`privmsgs_type` tinyint(4) NOT NULL default '0',
`privmsgs_subject` varchar(255) NOT NULL default '0',
`privmsgs_from_userid` mediumint(8) NOT NULL default '0',
`privmsgs_to_userid` mediumint(8) NOT NULL default '0',
`privmsgs_date` int(11) NOT NULL default '0',
`privmsgs_ip` varchar(8) NOT NULL default '',
`privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
`privmsgs_enable_html` tinyint(1) NOT NULL default '0',
`privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
`privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
`privmsgs_attachment` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`privmsgs_id`),
KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbprivmsgs`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbprivmsgs_archive`
--
CREATE TABLE `nuke_bbprivmsgs_archive` (
`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
`privmsgs_type` tinyint(4) NOT NULL default '0',
`privmsgs_subject` varchar(255) NOT NULL default '0',
`privmsgs_from_userid` mediumint(8) NOT NULL default '0',
`privmsgs_to_userid` mediumint(8) NOT NULL default '0',
`privmsgs_date` int(11) NOT NULL default '0',
`privmsgs_ip` varchar(8) NOT NULL default '',
`privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
`privmsgs_enable_html` tinyint(1) NOT NULL default '0',
`privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
`privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`privmsgs_id`),
KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbprivmsgs_archive`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbprivmsgs_text`
--
CREATE TABLE `nuke_bbprivmsgs_text` (
`privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
`privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
`privmsgs_text` text,
PRIMARY KEY (`privmsgs_text_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbprivmsgs_text`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbquicksearch`
--
CREATE TABLE `nuke_bbquicksearch` (
`search_id` mediumint(8) unsigned NOT NULL auto_increment,
`search_name` varchar(255) NOT NULL default '',
`search_url1` varchar(255) NOT NULL default '',
`search_url2` varchar(255) NOT NULL default '',
PRIMARY KEY (`search_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_bbquicksearch`
--
INSERT INTO `nuke_bbquicksearch` VALUES (1, 'Google', 'http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=', '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbquota_limits`
--
CREATE TABLE `nuke_bbquota_limits` (
`quota_limit_id` mediumint(8) unsigned NOT NULL auto_increment,
`quota_desc` varchar(20) NOT NULL default '',
`quota_limit` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`quota_limit_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbquota_limits`
--
INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144);
INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152);
INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbranks`
--
CREATE TABLE `nuke_bbranks` (
`rank_id` smallint(5) unsigned NOT NULL auto_increment,
`rank_title` varchar(100) NOT NULL default '',
`rank_min` mediumint(8) NOT NULL default '0',
`rank_special` tinyint(1) default '0',
`rank_image` varchar(255) default NULL,
PRIMARY KEY (`rank_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Dumping data for table `nuke_bbranks`
--
INSERT INTO `nuke_bbranks` VALUES (1, 'Site Owner', -1, 1, 'modules/Forums/images/ranks/site_owner.gif');
INSERT INTO `nuke_bbranks` VALUES (2, 'Site Admin', -1, 1, 'modules/Forums/images/ranks/admin.gif');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsearch_results`
--
CREATE TABLE `nuke_bbsearch_results` (
`search_id` int(11) unsigned NOT NULL default '0',
`session_id` varchar(32) NOT NULL default '',
`search_array` text NOT NULL,
`search_time` int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (`search_id`),
KEY `session_id` (`session_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbsearch_results`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsearch_wordlist`
--
CREATE TABLE `nuke_bbsearch_wordlist` (
`word_text` varchar(255) binary NOT NULL DEFAULT '',
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_common` mediumint(8) unsigned DEFAULT '0' NOT NULL,
`post_id` mediumint(8) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (`word_text`),
KEY `word_id` (`word_id`)
);
--
-- Dumping data for table `nuke_bbsearch_wordlist`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsearch_wordmatch`
--
CREATE TABLE `nuke_bbsearch_wordmatch` (
`post_id` mediumint(8) unsigned NOT NULL default '0',
`word_id` mediumint(8) unsigned NOT NULL default '0',
`title_match` tinyint(1) NOT NULL default '0',
INDEX `post_id` (`post_id`),
KEY `word_id` (`word_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbsearch_wordmatch`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsessions`
--
CREATE TABLE `nuke_bbsessions` (
`session_id` varchar(32) NOT NULL default '',
`session_user_id` mediumint(8) NOT NULL default '0',
`session_start` int(11) NOT NULL default '0',
`session_time` int(11) NOT NULL default '0',
`session_ip` varchar(8) NOT NULL default '0',
`session_page` int(11) NOT NULL default '0',
`session_logged_in` tinyint(1) NOT NULL default '0',
`session_admin` tinyint(2) NOT NULL default '0',
`session_url_qs` text NOT NULL,
`session_url_ps` text NOT NULL,
`session_url_specific` int(10) NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `session_user_id` (`session_user_id`),
KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbsessions`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsessions_keys`
--
CREATE TABLE `nuke_bbsessions_keys` (
`key_id` varchar(32) DEFAULT '0' NOT NULL,
`user_id` mediumint(8) DEFAULT '0' NOT NULL,
`last_ip` varchar(8) DEFAULT '0' NOT NULL,
`last_login` int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (key_id, user_id),
KEY last_login (last_login)
);
--
-- Dumping data for table `nuke_bbsessions_keys`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbsmilies`
--
CREATE TABLE `nuke_bbsmilies` (
`smilies_id` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(50) default NULL,
`smile_url` varchar(100) default NULL,
`emoticon` varchar(75) default NULL,
`smile_stat` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`smilies_id`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;
--
-- Dumping data for table `nuke_bbsmilies`
--
INSERT INTO `nuke_bbsmilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy', 0);
INSERT INTO `nuke_bbsmilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 0);
INSERT INTO `nuke_bbsmilies` VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy', 0);
INSERT INTO `nuke_bbsmilies` VALUES (4, ':)', 'icon_smile.gif', 'Smile', 0);
INSERT INTO `nuke_bbsmilies` VALUES (5, ':-)', 'icon_smile.gif', 'Smile', 0);
INSERT INTO `nuke_bbsmilies` VALUES (6, ':smile:', 'icon_smile.gif', 'Smile', 0);
INSERT INTO `nuke_bbsmilies` VALUES (7, ':(', 'icon_sad.gif', 'Sad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (8, ':-(', 'icon_sad.gif', 'Sad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (9, ':sad:', 'icon_sad.gif', 'Sad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (10, ':o', 'icon_surprised.gif', 'Surprised', 0);
INSERT INTO `nuke_bbsmilies` VALUES (11, ':-o', 'icon_surprised.gif', 'Surprised', 0);
INSERT INTO `nuke_bbsmilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised', 0);
INSERT INTO `nuke_bbsmilies` VALUES (13, '8O', 'icon_eek.gif', 'Shocked', 0);
INSERT INTO `nuke_bbsmilies` VALUES (14, '8-O', 'icon_eek.gif', 'Shocked', 0);
INSERT INTO `nuke_bbsmilies` VALUES (15, ':shock:', 'icon_eek.gif', 'Shocked', 0);
INSERT INTO `nuke_bbsmilies` VALUES (16, ':?', 'icon_confused.gif', 'Confused', 0);
INSERT INTO `nuke_bbsmilies` VALUES (17, ':-?', 'icon_confused.gif', 'Confused', 0);
INSERT INTO `nuke_bbsmilies` VALUES (18, ':???:', 'icon_confused.gif', 'Confused', 0);
INSERT INTO `nuke_bbsmilies` VALUES (19, '8)', 'icon_cool.gif', 'Cool', 0);
INSERT INTO `nuke_bbsmilies` VALUES (20, '8-)', 'icon_cool.gif', 'Cool', 0);
INSERT INTO `nuke_bbsmilies` VALUES (21, ':cool:', 'icon_cool.gif', 'Cool', 0);
INSERT INTO `nuke_bbsmilies` VALUES (22, ':lol:', 'icon_lol.gif', 'Laughing', 0);
INSERT INTO `nuke_bbsmilies` VALUES (23, ':x', 'icon_mad.gif', 'Mad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (24, ':-x', 'icon_mad.gif', 'Mad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (25, ':mad:', 'icon_mad.gif', 'Mad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (26, ':P', 'icon_razz.gif', 'Razz', 0);
INSERT INTO `nuke_bbsmilies` VALUES (27, ':-P', 'icon_razz.gif', 'Razz', 0);
INSERT INTO `nuke_bbsmilies` VALUES (28, ':razz:', 'icon_razz.gif', 'Razz', 0);
INSERT INTO `nuke_bbsmilies` VALUES (29, ':oops:', 'icon_redface.gif', 'Embarassed', 0);
INSERT INTO `nuke_bbsmilies` VALUES (30, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (31, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 0);
INSERT INTO `nuke_bbsmilies` VALUES (32, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 0);
INSERT INTO `nuke_bbsmilies` VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 0);
INSERT INTO `nuke_bbsmilies` VALUES (34, ':wink:', 'icon_wink.gif', 'Wink', 0);
INSERT INTO `nuke_bbsmilies` VALUES (35, ';)', 'icon_wink.gif', 'Wink', 0);
INSERT INTO `nuke_bbsmilies` VALUES (36, ';-)', 'icon_wink.gif', 'Wink', 0);
INSERT INTO `nuke_bbsmilies` VALUES (37, ':!:', 'icon_exclaim.gif', 'Exclamation', 0);
INSERT INTO `nuke_bbsmilies` VALUES (38, ':?:', 'icon_question.gif', 'Question', 0);
INSERT INTO `nuke_bbsmilies` VALUES (39, ':idea:', 'icon_idea.gif', 'Idea', 0);
INSERT INTO `nuke_bbsmilies` VALUES (40, ':arrow:', 'icon_arrow.gif', 'Arrow', 0);
INSERT INTO `nuke_bbsmilies` VALUES (41, ':|', 'icon_neutral.gif', 'Neutral', 0);
INSERT INTO `nuke_bbsmilies` VALUES (42, ':-|', 'icon_neutral.gif', 'Neutral', 0);
INSERT INTO `nuke_bbsmilies` VALUES (43, ':neutral:', 'icon_neutral.gif', 'Neutral', 0);
INSERT INTO `nuke_bbsmilies` VALUES (44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_config`
--
CREATE TABLE `nuke_bbstats_config` (
`config_name` varchar(100) NOT NULL default '',
`config_value` varchar(100) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_config`
--
INSERT INTO `nuke_bbstats_config` VALUES ('install_date', '0');
INSERT INTO `nuke_bbstats_config` VALUES ('return_limit', '10');
INSERT INTO `nuke_bbstats_config` VALUES ('version', '3.0.0');
INSERT INTO `nuke_bbstats_config` VALUES ('page_views', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_module_admin_panel`
--
CREATE TABLE `nuke_bbstats_module_admin_panel` (
`module_id` mediumint(8) unsigned NOT NULL default '0',
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
`config_type` varchar(20) NOT NULL default '',
`config_title` varchar(100) NOT NULL default '',
`config_explain` varchar(100) default NULL,
`config_trigger` varchar(20) NOT NULL default '',
PRIMARY KEY (`module_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_module_admin_panel`
--
INSERT INTO `nuke_bbstats_module_admin_panel` VALUES (1, 'num_columns', '2', 'number', 'num_columns_title', 'num_columns_explain', 'integer');
INSERT INTO `nuke_bbstats_module_admin_panel` VALUES (15, 'exclude_images', '0', 'number', 'exclude_images_title', 'exclude_images_explain', 'enum');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_module_cache`
--
CREATE TABLE `nuke_bbstats_module_cache` (
`module_id` mediumint(8) NOT NULL default '0',
`module_cache_time` int(12) NOT NULL default '0',
`db_cache` text NOT NULL,
`priority` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`module_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_module_cache`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_module_group_auth`
--
CREATE TABLE `nuke_bbstats_module_group_auth` (
`module_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`module_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_module_group_auth`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_module_info`
--
CREATE TABLE `nuke_bbstats_module_info` (
`module_id` mediumint(8) NOT NULL default '0',
`long_name` varchar(100) NOT NULL default '',
`author` varchar(50) default NULL,
`email` varchar(50) default NULL,
`url` varchar(100) default NULL,
`version` varchar(10) NOT NULL default '',
`update_site` varchar(100) default NULL,
`extra_info` varchar(255) NOT NULL default '',
PRIMARY KEY (`module_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_module_info`
--
INSERT INTO `nuke_bbstats_module_info` VALUES (1, 'Statistics Overview Section', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module will print out a link Block with Links to the current Module at the Statistics Site.\nYou are able to define the number of columns displayed for this Module within the Administration Panel -> Edit Module.');
INSERT INTO `nuke_bbstats_module_info` VALUES (2, 'Top Posters', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the Top Posters from your board.\nAnonymous Poster are not counted.');
INSERT INTO `nuke_bbstats_module_info` VALUES (3, 'Administrative Statistics', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays some Admin Statistics about your Board.\nIt is nearly the same you are able to see within the first Administration Panel visit.');
INSERT INTO `nuke_bbstats_module_info` VALUES (4, 'Most viewed topics', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the most viewed topics at your board.');
INSERT INTO `nuke_bbstats_module_info` VALUES (5, 'Top Posters this Month (Site History Mod)', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module does NOT require the Site History Mod,\nit will display the Top Posters on a Monthly basis.');
INSERT INTO `nuke_bbstats_module_info` VALUES (6, 'New topics by month', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module will display the topics created at your Board in a monthly statistic.');
INSERT INTO `nuke_bbstats_module_info` VALUES (7, 'Most Interesting Topics', 'JRSweets', 'JRSweets@gmail.com', 'http://www.jeffrusso.net', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This module will show the most intresting topics.');
INSERT INTO `nuke_bbstats_module_info` VALUES (8, 'Top Words', 'JRSweets', 'JRSweets@gmail.com', 'http://www.jeffrusso.net', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the most used words on your board.');
INSERT INTO `nuke_bbstats_module_info` VALUES (9, 'Least Interesting Topics', 'JRSweets', 'JRSweets@gmail.com', 'http://www.jeffrusso.net', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This module will show the least intresting topics.');
INSERT INTO `nuke_bbstats_module_info` VALUES (10, 'Most Active Topicstarter', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the most active topicstarter on your board.\nAnonymous Poster are not counted.');
INSERT INTO `nuke_bbstats_module_info` VALUES (11, 'Top Smilies', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the Top Smilies used at your board.\nThis Module uses an Smilie Index Table for caching the smilie data and to not\nrequire re-indexing of all posts.');
INSERT INTO `nuke_bbstats_module_info` VALUES (12, 'New users by month', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module will display the users registered to your Board in a monthly statistic.');
INSERT INTO `nuke_bbstats_module_info` VALUES (13, 'New posts by month', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module will display the posts created at your Board in a monthly statistic.');
INSERT INTO `nuke_bbstats_module_info` VALUES (14, 'Top Posters this Week (Site History Mod)', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module does NOT require the Site History Mod,\nit will display the Top Posters on a Weekly basis.');
INSERT INTO `nuke_bbstats_module_info` VALUES (15, 'Top Downloaded Attachments', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module will print out the most downloaded Files.\nThe Attachment Mod Version 2.3.x have to be installed in order to let this Module work.\nYou are able to exclude Images from the statistic too.');
INSERT INTO `nuke_bbstats_module_info` VALUES (16, 'Most active Topics', 'Acyd Burn', 'acyd.burn@gmx.de', 'http://www.opentools.de', '3.0.0', 'http://www.opentools.de/board/show_modules.php', 'This Module displays the most active topics at your board.');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_modules`
--
CREATE TABLE `nuke_bbstats_modules` (
`module_id` mediumint(8) unsigned NOT NULL auto_increment,
`short_name` varchar(100) default NULL,
`update_time` mediumint(8) NOT NULL default '0',
`module_order` mediumint(8) NOT NULL default '0',
`active` tinyint(2) NOT NULL default '0',
`perm_all` tinyint(2) unsigned NOT NULL default '1',
`perm_reg` tinyint(2) unsigned NOT NULL default '1',
`perm_mod` tinyint(2) unsigned NOT NULL default '1',
`perm_admin` tinyint(2) unsigned NOT NULL default '1',
PRIMARY KEY (`module_id`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;
--
-- Dumping data for table `nuke_bbstats_modules`
--
INSERT INTO `nuke_bbstats_modules` VALUES (1, 'stats_overview', 360, 10, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (2, 'top_posters', 360, 30, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (3, 'admin_statistics', 360, 20, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (4, 'most_viewed_topics', 360, 80, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (5, 'top_posters_month', 360, 60, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (6, 'topics_by_month', 360, 100, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (7, 'most_interesting_topics', 360, 120, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (8, 'top_words', 360, 90, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (9, 'least_interesting_topics', 360, 130, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (10, 'most_active_topicstarter', 360, 40, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (11, 'top_smilies', 0, 110, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (12, 'users_by_month', 360, 140, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (13, 'posts_by_month', 360, 150, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (14, 'top_posters_week', 360, 50, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (15, 'top_attachments', 360, 160, 1, 1, 1, 1, 1);
INSERT INTO `nuke_bbstats_modules` VALUES (16, 'most_active_topics', 360, 70, 1, 1, 1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_smilies_index`
--
CREATE TABLE `nuke_bbstats_smilies_index` (
`code` varchar(50) NOT NULL default '',
`smile_url` varchar(100) default NULL,
`smile_count` mediumint(8) default '0',
PRIMARY KEY (`code`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_smilies_index`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbstats_smilies_info`
--
CREATE TABLE `nuke_bbstats_smilies_info` (
`last_post_id` mediumint(8) NOT NULL default '0',
`last_update_time` int(12) NOT NULL default '0',
`update_time` mediumint(8) NOT NULL default '10080',
PRIMARY KEY (`last_post_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbstats_smilies_info`
--
INSERT INTO `nuke_bbstats_smilies_info` VALUES (0, 0, 10080);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbthemes`
--
CREATE TABLE `nuke_bbthemes` (
`themes_id` mediumint(8) unsigned NOT NULL auto_increment,
`template_name` varchar(30) NOT NULL default '',
`style_name` varchar(30) NOT NULL default '',
`head_stylesheet` varchar(100) default NULL,
`body_background` varchar(100) default NULL,
`body_bgcolor` varchar(6) default NULL,
`body_text` varchar(6) default NULL,
`body_link` varchar(6) default NULL,
`body_vlink` varchar(6) default NULL,
`body_alink` varchar(6) default NULL,
`body_hlink` varchar(6) default NULL,
`tr_color1` varchar(6) default NULL,
`tr_color2` varchar(6) default NULL,
`tr_color3` varchar(6) default NULL,
`tr_class1` varchar(25) default NULL,
`tr_class2` varchar(25) default NULL,
`tr_class3` varchar(25) default NULL,
`th_color1` varchar(6) default NULL,
`th_color2` varchar(6) default NULL,
`th_color3` varchar(6) default NULL,
`th_class1` varchar(25) default NULL,
`th_class2` varchar(25) default NULL,
`th_class3` varchar(25) default NULL,
`td_color1` varchar(6) default NULL,
`td_color2` varchar(6) default NULL,
`td_color3` varchar(6) default NULL,
`td_class1` varchar(25) default NULL,
`td_class2` varchar(25) default NULL,
`td_class3` varchar(25) default NULL,
`fontface1` varchar(50) default NULL,
`fontface2` varchar(50) default NULL,
`fontface3` varchar(50) default NULL,
`fontsize1` tinyint(4) default NULL,
`fontsize2` tinyint(4) default NULL,
`fontsize3` tinyint(4) default NULL,
`fontcolor1` varchar(6) default NULL,
`fontcolor2` varchar(6) default NULL,
`fontcolor3` varchar(6) default NULL,
`span_class1` varchar(25) default NULL,
`span_class2` varchar(25) default NULL,
`span_class3` varchar(25) default NULL,
`img_size_poll` smallint(5) unsigned default NULL,
`img_size_privmsg` smallint(5) unsigned default NULL,
`online_color` varchar(6) NOT NULL default '',
`offline_color` varchar(6) NOT NULL default '',
`hidden_color` varchar(6) NOT NULL default '',
PRIMARY KEY (`themes_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_bbthemes`
--
INSERT INTO `nuke_bbthemes` VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', '0E3259', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL, '008500', 'DF0000', 'EBD400');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbthemes_name`
--
CREATE TABLE `nuke_bbthemes_name` (
`themes_id` smallint(5) unsigned NOT NULL default '0',
`tr_color1_name` char(50) default NULL,
`tr_color2_name` char(50) default NULL,
`tr_color3_name` char(50) default NULL,
`tr_class1_name` char(50) default NULL,
`tr_class2_name` char(50) default NULL,
`tr_class3_name` char(50) default NULL,
`th_color1_name` char(50) default NULL,
`th_color2_name` char(50) default NULL,
`th_color3_name` char(50) default NULL,
`th_class1_name` char(50) default NULL,
`th_class2_name` char(50) default NULL,
`th_class3_name` char(50) default NULL,
`td_color1_name` char(50) default NULL,
`td_color2_name` char(50) default NULL,
`td_color3_name` char(50) default NULL,
`td_class1_name` char(50) default NULL,
`td_class2_name` char(50) default NULL,
`td_class3_name` char(50) default NULL,
`fontface1_name` char(50) default NULL,
`fontface2_name` char(50) default NULL,
`fontface3_name` char(50) default NULL,
`fontsize1_name` char(50) default NULL,
`fontsize2_name` char(50) default NULL,
`fontsize3_name` char(50) default NULL,
`fontcolor1_name` char(50) default NULL,
`fontcolor2_name` char(50) default NULL,
`fontcolor3_name` char(50) default NULL,
`span_class1_name` char(50) default NULL,
`span_class2_name` char(50) default NULL,
`span_class3_name` char(50) default NULL,
PRIMARY KEY (`themes_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbthemes_name`
--
INSERT INTO `nuke_bbthemes_name` VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbtopic_moved`
--
CREATE TABLE `nuke_bbtopic_moved` (
`moved_id` mediumint(8) unsigned NOT NULL auto_increment,
`moved_topic_id` mediumint(8) unsigned NOT NULL default '0',
`moved_oldtopic_id` mediumint(8) unsigned default '0',
`moved_type` varchar(8) NOT NULL default '0',
`moved_parent` mediumint(8) unsigned default '0',
`moved_target` mediumint(8) unsigned default '0',
`moved_mod` mediumint(8) NOT NULL default '0',
`moved_time` int(11) NOT NULL default '0',
`last_post_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`moved_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbtopic_moved`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbtopics`
--
CREATE TABLE `nuke_bbtopics` (
`topic_id` mediumint(8) unsigned NOT NULL auto_increment,
`forum_id` smallint(8) unsigned NOT NULL default '0',
`topic_title` char(60) NOT NULL default '',
`topic_poster` mediumint(8) NOT NULL default '0',
`topic_time` int(11) NOT NULL default '0',
`topic_views` mediumint(8) unsigned NOT NULL default '0',
`topic_replies` mediumint(8) unsigned NOT NULL default '0',
`topic_status` tinyint(3) NOT NULL default '0',
`topic_vote` tinyint(1) NOT NULL default '0',
`topic_type` tinyint(3) NOT NULL default '0',
`topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
`topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
`topic_priority` smallint(6) NOT NULL default '0',
`topic_attachment` tinyint(1) NOT NULL default '0',
`topic_glance_priority` smallint(6) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_moved_id` (`topic_moved_id`),
KEY `topic_status` (`topic_status`),
KEY `topic_type` (`topic_type`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbtopics`
--
INSERT INTO `nuke_bbtopics` VALUES (1, 1, 'Welcome to Nuke-Evolution!', 2, 1125188724, 3, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbtopics_watch`
--
CREATE TABLE `nuke_bbtopics_watch` (
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`notify_status` tinyint(1) NOT NULL default '0',
KEY `topic_id` (`topic_id`),
KEY `user_id` (`user_id`),
KEY `notify_status` (`notify_status`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbtopics_watch`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbuser_group`
--
CREATE TABLE `nuke_bbuser_group` (
`group_id` mediumint(8) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`user_pending` tinyint(1) default NULL,
KEY `group_id` (`group_id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbuser_group`
--
INSERT INTO `nuke_bbuser_group` VALUES (1, -1, 0);
INSERT INTO `nuke_bbuser_group` VALUES (3, 2, 0);
INSERT INTO `nuke_bbuser_group` VALUES (5, 2, 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbvote_desc`
--
CREATE TABLE `nuke_bbvote_desc` (
`vote_id` mediumint(8) unsigned NOT NULL auto_increment,
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`vote_text` text NOT NULL,
`vote_start` int(11) NOT NULL default '0',
`vote_length` int(11) NOT NULL default '0',
`poll_view_toggle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`vote_id`),
KEY `topic_id` (`topic_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbvote_desc`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbvote_results`
--
CREATE TABLE `nuke_bbvote_results` (
`vote_id` mediumint(8) unsigned NOT NULL default '0',
`vote_option_id` tinyint(4) unsigned NOT NULL default '0',
`vote_option_text` varchar(255) NOT NULL default '',
`vote_result` int(11) NOT NULL default '0',
KEY `vote_option_id` (`vote_option_id`),
KEY `vote_id` (`vote_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbvote_results`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbvote_voters`
--
CREATE TABLE `nuke_bbvote_voters` (
`vote_id` mediumint(8) unsigned NOT NULL default '0',
`vote_user_id` mediumint(8) NOT NULL default '0',
`vote_user_ip` char(8) NOT NULL default '',
`vote_cast` tinyint(4) unsigned NOT NULL default '0',
KEY `vote_id` (`vote_id`),
KEY `vote_user_id` (`vote_user_id`),
KEY `vote_user_ip` (`vote_user_ip`),
KEY `vote_cast` (`vote_cast`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbvote_voters`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbwords`
--
CREATE TABLE `nuke_bbwords` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word` char(100) NOT NULL default '',
`replacement` char(100) NOT NULL default '',
PRIMARY KEY (`word_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_bbwords`
--
-- --------------------------------------------------------
--
-- Table structure for table nuke_bbxdata_fields
--
CREATE TABLE `nuke_bbxdata_fields` (
field_id smallint(5) UNSIGNED NOT NULL,
field_name varchar(255) NOT NULL default '',
field_desc text NOT NULL default '',
field_type varchar(255) NOT NULL default '',
field_order smallint(5) UNSIGNED NOT NULL default '0',
code_name varchar(255) NOT NULL default '',
field_length mediumint(8) UNSIGNED NOT NULL default '0',
field_values text NOT NULL default '',
field_regexp text NOT NULL default '',
manditory TINYINT( 1 ) NOT NULL DEFAULT '0',
default_auth tinyint(1) NOT NULL default '1',
display_register tinyint(1) NOT NULL default '1',
display_viewprofile tinyint(1) NOT NULL default '0',
display_posting tinyint(1) NOT NULL default '0',
handle_input tinyint(1) NOT NULL default '0',
allow_html tinyint(1) NOT NULL default '0',
allow_bbcode tinyint(1) NOT NULL default '0',
allow_smilies tinyint(1) NOT NULL default '0',
viewtopic TINYINT( 1 ) DEFAULT '0' NOT NULL,
signup TINYINT( 1 ) DEFAULT '0' NOT NULL,
PRIMARY KEY (field_id),
UNIQUE KEY code_name (code_name)
);
-- --------------------------------------------------------
--
-- Table structure for table nuke_bbxdata_data
--
CREATE TABLE `nuke_bbxdata_data` (
field_id smallint(5) UNSIGNED NOT NULL,
user_id mediumint(8) UNSIGNED NOT NULL,
xdata_value text NOT NULL
);
-- --------------------------------------------------------
--
-- Table structure for table nuke_bbxdata_auth
--
CREATE TABLE `nuke_bbxdata_auth` (
field_id smallint(5) UNSIGNED NOT NULL,
group_id mediumint(8) UNSIGNED NOT NULL,
auth_value tinyint(1) NOT NULL
);
--
-- Dumping data for table `nuke_bbxdata_field`
--
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (1, 'ICQ Number', 'special', '1', 'icq', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (2, 'AIM Address', 'special', '2', 'aim', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (3, 'MSN Messenger', 'special', '3', 'msn', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (4, 'Yahoo Messenger', 'special', '4', 'yim', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (5, 'Website', 'special', '5', 'website', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (6, 'Location', 'special', '6', 'location', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (7, 'Occupation', 'special', '7', 'occupation', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (8, 'Interests', 'special', '8', 'interests', 2);
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (9, 'Signature', 'special', '9', 'signature', 2);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_blocks`
--
CREATE TABLE `nuke_blocks` (
`bid` int(10) NOT NULL auto_increment,
`bkey` varchar(15) NOT NULL default '',
`title` varchar(60) NOT NULL default '',
`content` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`bposition` char(1) NOT NULL default '',
`weight` int(10) NOT NULL default '1',
`active` int(1) NOT NULL default '1',
`refresh` int(10) NOT NULL default '0',
`time` varchar(14) NOT NULL default '0',
`blanguage` varchar(30) NOT NULL default '',
`blockfile` varchar(255) NOT NULL default '',
`view` VARCHAR( 50 ) NOT NULL default '0',
PRIMARY KEY (`bid`),
KEY `title` (`title`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_blocks`
--
INSERT INTO `nuke_blocks` VALUES (1, '', 'Main Menu', '', '', 'l', 1, 1, 0, '', '', 'block-Modules.php', '0');
INSERT INTO `nuke_blocks` VALUES (2, '', 'Administration', '', '', 'l', 3, 1, 0, '', '', 'block-Administration.php', '4');
INSERT INTO `nuke_blocks` VALUES (3, '', 'Search', '', '', 'l', 6, 0, 3600, '', '', 'block-Search.php', '0');
INSERT INTO `nuke_blocks` VALUES (4, '', 'Survey', '', '', 'r', 5, 1, 3600, '', '', 'block-Survey.php', '0');
INSERT INTO `nuke_blocks` VALUES (5, '', 'Information', '
\r\n
\r\n
\r\n
\r\n
\r\n
', '', 'r', 6, 1, 0, '', '', '', '0');
INSERT INTO `nuke_blocks` VALUES (6, '', 'User Info', '', '', 'r', 3, 1, 0, '', '', 'block-Evo_User_Info.php', '0');
INSERT INTO `nuke_blocks` VALUES (7, '', 'Nuke-Evolution', '', '', 'c', 1, 1, 0, '', '', 'block-Nuke-Evolution.php', '0');
INSERT INTO `nuke_blocks` VALUES (8, '', 'Hacker Beware', '', '', 'l', 7, 1, 3600, '', '', 'block-Hacker_Beware2.php', '0');
INSERT INTO `nuke_blocks` VALUES (9, '', 'Top 10 Downloads', '', '', 'r', 7, 0, 3600, '', '', 'block-Top10_Downloads.php', '0');
INSERT INTO `nuke_blocks` VALUES (10, '', 'Top 10 Links', '', '', 'r', 8, 0, 3600, '', '', 'block-Top10_Links.php', '0');
INSERT INTO `nuke_blocks` VALUES (11, '', 'Forums', '', '', 'c', 1, 0, 3600, '', '', 'block-Forums.php', '0');
INSERT INTO `nuke_blocks` VALUES (12, '', 'Submissions', '', '', 'l', 4, 1, 0, '', '', 'block-Submissions.php', '4');
INSERT INTO `nuke_blocks` VALUES (13, '', 'Link to us', '', '', 'l', 10, 1, 3600, '', '', 'block-Link_to_us.php', '0');
INSERT INTO `nuke_blocks` VALUES (14, '', 'Donations', '', '', 'r', 1, 1, 3600, '0', '', 'block-Donations.php', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_cnbya_config`
--
CREATE TABLE `nuke_cnbya_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` longtext,
UNIQUE KEY `config_name` (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_cnbya_config`
--
INSERT INTO `nuke_cnbya_config` VALUES ('sendaddmail', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('senddeletemail', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('allowuserdelete', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('allowusertheme', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('allowuserreg', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('allowmailchange', '1');
INSERT INTO `nuke_cnbya_config` VALUES ('emailvalidate', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('requireadmin', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('servermail', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('useactivate', '1');
INSERT INTO `nuke_cnbya_config` VALUES ('autosuspend', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('perpage', '100');
INSERT INTO `nuke_cnbya_config` VALUES ('expiring', '86400');
INSERT INTO `nuke_cnbya_config` VALUES ('nick_min', '4');
INSERT INTO `nuke_cnbya_config` VALUES ('nick_max', '20');
INSERT INTO `nuke_cnbya_config` VALUES ('pass_min', '4');
INSERT INTO `nuke_cnbya_config` VALUES ('pass_max', '20');
INSERT INTO `nuke_cnbya_config` VALUES ('bad_mail', 'yoursite.com\r\nmysite.com');
INSERT INTO `nuke_cnbya_config` VALUES ('bad_nick', 'adm\r\nadmin\r\nanonimo\r\nanonymous\r\nannimo\r\ngod\r\nlinux\r\nnobody\r\noperator\r\nroot\r\nstaff\r\nwebmaster');
INSERT INTO `nuke_cnbya_config` VALUES ('coppa', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('tos', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('tosall', '1');
INSERT INTO `nuke_cnbya_config` VALUES ('cookiecheck', '1');
INSERT INTO `nuke_cnbya_config` VALUES ('cookiecleaner', '1');
INSERT INTO `nuke_cnbya_config` VALUES ('cookietimelife', '2592000');
INSERT INTO `nuke_cnbya_config` VALUES ('cookiepath', '');
INSERT INTO `nuke_cnbya_config` VALUES ('cookieinactivity', '-');
INSERT INTO `nuke_cnbya_config` VALUES ('autosuspendmain', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('doublecheckemail', '0');
INSERT INTO `nuke_cnbya_config` VALUES ('version', '4.4.2');
INSERT INTO `nuke_cnbya_config` VALUES ('tos_text', 'This is your default TOS. You may edit this through the Your Account Admin Panel.');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_cnbya_field`
--
CREATE TABLE `nuke_cnbya_field` (
`fid` int(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default 'field',
`value` varchar(255) default NULL,
`size` int(3) default NULL,
`need` int(1) NOT NULL default '1',
`pos` int(3) default NULL,
`public` int(1) NOT NULL default '1',
PRIMARY KEY (`fid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_cnbya_field`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_cnbya_value`
--
CREATE TABLE `nuke_cnbya_value` (
`vid` int(10) NOT NULL auto_increment,
`uid` int(10) NOT NULL default '0',
`fid` int(10) NOT NULL default '0',
`value` varchar(255) default NULL,
PRIMARY KEY (`vid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_cnbya_value`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_cnbya_value_temp`
--
CREATE TABLE `nuke_cnbya_value_temp` (
`vid` int(10) NOT NULL auto_increment,
`uid` int(10) NOT NULL default '0',
`fid` int(10) NOT NULL default '0',
`value` varchar(255) default NULL,
PRIMARY KEY (`vid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_cnbya_value_temp`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_comments`
--
CREATE TABLE `nuke_comments` (
`tid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`date` datetime default NULL,
`name` varchar(60) NOT NULL default '',
`email` varchar(60) default NULL,
`url` varchar(60) default NULL,
`host_name` varchar(60) default NULL,
`subject` varchar(85) NOT NULL default '',
`comment` text NOT NULL,
`score` tinyint(4) NOT NULL default '0',
`reason` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY `pid` (`pid`),
KEY `sid` (`sid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_config`
--
CREATE TABLE `nuke_config` (
`sitename` varchar(255) NOT NULL default '',
`nukeurl` varchar(255) NOT NULL default '',
`site_logo` varchar(255) NOT NULL default '',
`slogan` varchar(255) NOT NULL default '',
`startdate` varchar(50) NOT NULL default '',
`adminmail` varchar(255) NOT NULL default '',
`anonpost` tinyint(1) NOT NULL default '0',
`default_Theme` varchar(255) NOT NULL default '',
`foot1` text NOT NULL,
`foot2` text NOT NULL,
`foot3` text NOT NULL,
`commentlimit` int(9) NOT NULL default '4096',
`anonymous` varchar(255) NOT NULL default '',
`minpass` tinyint(1) NOT NULL default '5',
`pollcomm` tinyint(1) NOT NULL default '1',
`articlecomm` tinyint(1) NOT NULL default '1',
`broadcast_msg` tinyint(1) NOT NULL default '1',
`my_headlines` tinyint(1) NOT NULL default '1',
`top` int(3) NOT NULL default '10',
`storyhome` int(2) NOT NULL default '10',
`user_news` tinyint(1) NOT NULL default '1',
`oldnum` int(2) NOT NULL default '30',
`ultramode` tinyint(1) NOT NULL default '0',
`banners` tinyint(1) NOT NULL default '1',
`backend_title` varchar(255) NOT NULL default '',
`backend_language` varchar(10) NOT NULL default '',
`language` varchar(100) NOT NULL default '',
`locale` varchar(10) NOT NULL default '',
`multilingual` tinyint(1) NOT NULL default '0',
`useflags` tinyint(1) NOT NULL default '0',
`notify` tinyint(1) NOT NULL default '0',
`notify_email` varchar(255) NOT NULL default '',
`notify_subject` varchar(255) NOT NULL default '',
`notify_message` varchar(255) NOT NULL default '',
`notify_from` varchar(255) NOT NULL default '',
`moderate` tinyint(1) NOT NULL default '0',
`admingraphic` tinyint(1) NOT NULL default '1',
`httpref` tinyint(1) NOT NULL default '1',
`httprefmax` int(5) NOT NULL default '1000',
`CensorMode` tinyint(1) NOT NULL default '3',
`CensorReplace` varchar(10) NOT NULL default '',
`copyright` text NOT NULL,
`Version_Num` varchar(10) NOT NULL default '',
`admin_pos` tinyint(1) NOT NULL default '1',
`admin_log_lines` int(11) NOT NULL default '0',
`error_log_lines` int(11) NOT NULL default '0',
`cache_data` MEDIUMBLOB NOT NULL,
PRIMARY KEY (`sitename`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_config`
--
INSERT INTO `nuke_config` VALUES ('My Site', 'http://--------.---', 'logo.gif', 'Your slogan here', 'December 2005', 'webmaster@------.---', 0, 'chromo', 'Spambot Killer
Site Map
', '![[News Feed]](images/powered/feed_20_news.png "News Feed")
![[Forums Feed]](images/powered/feed_20_forums.png "Forums Feed")
![[Downloads Feed]](images/powered/feed_20_down.png "Downloads Feed")
![[Web Links Feed]](images/powered/feed_20_links.png "Web Links Feed")
![[Validate robots.txt]](images/powered/valid-robots.png "Validate robots.txt")
', '', 4096, 'Anonymous', 5, 1, 1, 1, 1, 10, 10, 1, 30, 0, 0, 'Nuke-Evolution Powered Site', 'en-us', 'english', 'en_US', 0, 0, 0, 'webmaster@---------.---', 'NEWS for my site', 'Hey! You got a new submission for your site.', 'webmaster', 0, 1, 1, 1000, 3, '*****', 'PHP-Nuke Copyright © 2006 by Francisco Burzi.
All logos, trademarks and posts in this site are property of their respective owners, all the rest © 2006 by the site owner.
Powered by Nuke-Evolution.
', '7.6.0', 1, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_confirm`
--
CREATE TABLE `nuke_confirm` (
`confirm_id` char(32) NOT NULL default '',
`session_id` char(32) NOT NULL default '',
`code` char(6) NOT NULL default '',
PRIMARY KEY (`session_id`,`confirm_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_confirm`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_counter`
--
CREATE TABLE `nuke_counter` (
`type` varchar(80) NOT NULL default '',
`var` varchar(80) NOT NULL default '',
`count` int(10) unsigned NOT NULL default '0',
KEY `var` (`var`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_counter`
--
INSERT INTO `nuke_counter` VALUES ('total', 'hits', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Avant', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Camino', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Crazy', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'DEVONtech', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Dillo', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Galeon', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'ELinks', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Epiphany', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Firefox', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'iRider', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'K-Meleon', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Konqueror', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Lynx', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Maxthon', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Mozilla', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'MSIE', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'MultiZilla', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'NetCaptor', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Netscape', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'OmniWeb', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Opera', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Safari', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Shiira', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Voyager', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'w3m', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'WAP', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'WebWasher', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Bot', '0');
INSERT INTO `nuke_counter` VALUES ('browser', 'Other', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'Windows', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'Linspire', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'Linux', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'Mac', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'FreeBSD', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'SunOS', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'IRIX', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'OS/2', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'AIX', '0');
INSERT INTO `nuke_counter` VALUES ('os', 'Other', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_country`
--
CREATE TABLE `nuke_country` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_counter`
--
INSERT INTO `nuke_country` VALUES (1,'United States');
INSERT INTO `nuke_country` VALUES (0,'United Kingdom');
INSERT INTO `nuke_country` VALUES (2,'France');
INSERT INTO `nuke_country` VALUES (4,'Switzerland');
INSERT INTO `nuke_country` VALUES (5,'Afghanistan');
INSERT INTO `nuke_country` VALUES (6,'Albania');
INSERT INTO `nuke_country` VALUES (7,'Algeria');
INSERT INTO `nuke_country` VALUES (8,'American Somoa');
INSERT INTO `nuke_country` VALUES (9,'Andorra');
INSERT INTO `nuke_country` VALUES (10,'Angola');
INSERT INTO `nuke_country` VALUES (11,'Anguilla');
INSERT INTO `nuke_country` VALUES (12,'Antartica');
INSERT INTO `nuke_country` VALUES (13,'Antigua & Barbuda');
INSERT INTO `nuke_country` VALUES (14,'Argentina');
INSERT INTO `nuke_country` VALUES (15,'Armenia');
INSERT INTO `nuke_country` VALUES (16,'Aruba');
INSERT INTO `nuke_country` VALUES (17,'Australia');
INSERT INTO `nuke_country` VALUES (18,'Austria');
INSERT INTO `nuke_country` VALUES (19,'Azerbaijan');
INSERT INTO `nuke_country` VALUES (20,'Azores');
INSERT INTO `nuke_country` VALUES (21,'Bahamas');
INSERT INTO `nuke_country` VALUES (22,'Bahrain');
INSERT INTO `nuke_country` VALUES (23,'Balearic Islands');
INSERT INTO `nuke_country` VALUES (24,'Bangladesh');
INSERT INTO `nuke_country` VALUES (25,'Barbados');
INSERT INTO `nuke_country` VALUES (26,'Belarus');
INSERT INTO `nuke_country` VALUES (27,'Belgium');
INSERT INTO `nuke_country` VALUES (28,'Belize');
INSERT INTO `nuke_country` VALUES (29,'Benin');
INSERT INTO `nuke_country` VALUES (30,'Bermuda');
INSERT INTO `nuke_country` VALUES (31,'Bhutan');
INSERT INTO `nuke_country` VALUES (32,'Bolivia');
INSERT INTO `nuke_country` VALUES (33,'Bonaire');
INSERT INTO `nuke_country` VALUES (34,'Bosnia & Herzegovinia');
INSERT INTO `nuke_country` VALUES (35,'Botswana');
INSERT INTO `nuke_country` VALUES (36,'Brazil');
INSERT INTO `nuke_country` VALUES (37,'Brunei');
INSERT INTO `nuke_country` VALUES (38,'Bulgaria');
INSERT INTO `nuke_country` VALUES (39,'BurkinaFaso');
INSERT INTO `nuke_country` VALUES (40,'Burundi');
INSERT INTO `nuke_country` VALUES (41,'Cambodia');
INSERT INTO `nuke_country` VALUES (42,'Cameroon');
INSERT INTO `nuke_country` VALUES (43,'Canada');
INSERT INTO `nuke_country` VALUES (44,'Canary Islands');
INSERT INTO `nuke_country` VALUES (45,'Cape Verde');
INSERT INTO `nuke_country` VALUES (46,'Cayman Islands');
INSERT INTO `nuke_country` VALUES (47,'Central Africa Republic');
INSERT INTO `nuke_country` VALUES (48,'Chad');
INSERT INTO `nuke_country` VALUES (49,'Chile');
INSERT INTO `nuke_country` VALUES (50,'China');
INSERT INTO `nuke_country` VALUES (51,'Colombia');
INSERT INTO `nuke_country` VALUES (52,'Comoros');
INSERT INTO `nuke_country` VALUES (53,'Congo');
INSERT INTO `nuke_country` VALUES (54,'CostaRica');
INSERT INTO `nuke_country` VALUES (55,'Croatia');
INSERT INTO `nuke_country` VALUES (56,'Cuba');
INSERT INTO `nuke_country` VALUES (57,'Curacao');
INSERT INTO `nuke_country` VALUES (58,'Cyprus');
INSERT INTO `nuke_country` VALUES (59,'Czech Republic');
INSERT INTO `nuke_country` VALUES (60,'Denmark');
INSERT INTO `nuke_country` VALUES (61,'Djibouti');
INSERT INTO `nuke_country` VALUES (62,'Dominican Republic');
INSERT INTO `nuke_country` VALUES (63,'Ecuador');
INSERT INTO `nuke_country` VALUES (64,'Egypt');
INSERT INTO `nuke_country` VALUES (65,'ElSalvador');
INSERT INTO `nuke_country` VALUES (66,'Equatorial Guinea');
INSERT INTO `nuke_country` VALUES (67,'Eritrea');
INSERT INTO `nuke_country` VALUES (68,'Estonia');
INSERT INTO `nuke_country` VALUES (69,'Ethiopia');
INSERT INTO `nuke_country` VALUES (70,'Falkland Islands');
INSERT INTO `nuke_country` VALUES (71,'Fiji');
INSERT INTO `nuke_country` VALUES (72,'Finland');
INSERT INTO `nuke_country` VALUES (73,'French Guiana');
INSERT INTO `nuke_country` VALUES (74,'Gambia');
INSERT INTO `nuke_country` VALUES (75,'Georgia');
INSERT INTO `nuke_country` VALUES (76,'Germany');
INSERT INTO `nuke_country` VALUES (77,'Ghana');
INSERT INTO `nuke_country` VALUES (78,'Gibraltar');
INSERT INTO `nuke_country` VALUES (79,'Greece');
INSERT INTO `nuke_country` VALUES (80,'Greenland');
INSERT INTO `nuke_country` VALUES (81,'Grenada');
INSERT INTO `nuke_country` VALUES (82,'Guadeloupe');
INSERT INTO `nuke_country` VALUES (83,'Guatemala');
INSERT INTO `nuke_country` VALUES (84,'Guernsey');
INSERT INTO `nuke_country` VALUES (85,'Guinea Bissau');
INSERT INTO `nuke_country` VALUES (86,'Guyana');
INSERT INTO `nuke_country` VALUES (87,'Haiti');
INSERT INTO `nuke_country` VALUES (88,'Honduras');
INSERT INTO `nuke_country` VALUES (89,'HongKong');
INSERT INTO `nuke_country` VALUES (90,'Hungary');
INSERT INTO `nuke_country` VALUES (91,'Iceland');
INSERT INTO `nuke_country` VALUES (92,'India');
INSERT INTO `nuke_country` VALUES (93,'Indonesia');
INSERT INTO `nuke_country` VALUES (94,'Iran');
INSERT INTO `nuke_country` VALUES (95,'Iraq');
INSERT INTO `nuke_country` VALUES (96,'Ireland');
INSERT INTO `nuke_country` VALUES (97,'Israel');
INSERT INTO `nuke_country` VALUES (98,'Italy');
INSERT INTO `nuke_country` VALUES (99,'IvoryCoast');
INSERT INTO `nuke_country` VALUES (100,'Jamaica');
INSERT INTO `nuke_country` VALUES (101,'Japan');
INSERT INTO `nuke_country` VALUES (102,'Jersey');
INSERT INTO `nuke_country` VALUES (103,'Jordan');
INSERT INTO `nuke_country` VALUES (104,'Kazakhstan');
INSERT INTO `nuke_country` VALUES (105,'Kenya');
INSERT INTO `nuke_country` VALUES (106,'Kuwait');
INSERT INTO `nuke_country` VALUES (107,'Kyrgyzstan');
INSERT INTO `nuke_country` VALUES (108,'Laos');
INSERT INTO `nuke_country` VALUES (109,'Latvia');
INSERT INTO `nuke_country` VALUES (110,'Lebanon');
INSERT INTO `nuke_country` VALUES (111,'Lesotho');
INSERT INTO `nuke_country` VALUES (112,'Liberia');
INSERT INTO `nuke_country` VALUES (113,'Libya');
INSERT INTO `nuke_country` VALUES (114,'Liechtenstein');
INSERT INTO `nuke_country` VALUES (115,'Lithuania');
INSERT INTO `nuke_country` VALUES (116,'Luxembourg');
INSERT INTO `nuke_country` VALUES (117,'Macau');
INSERT INTO `nuke_country` VALUES (118,'Macedonia');
INSERT INTO `nuke_country` VALUES (119,'Madagascar');
INSERT INTO `nuke_country` VALUES (120,'Maderia');
INSERT INTO `nuke_country` VALUES (121,'Malawi');
INSERT INTO `nuke_country` VALUES (122,'Malaysia');
INSERT INTO `nuke_country` VALUES (123,'Maldives');
INSERT INTO `nuke_country` VALUES (124,'Mali');
INSERT INTO `nuke_country` VALUES (125,'Malta');
INSERT INTO `nuke_country` VALUES (126,'Martinique');
INSERT INTO `nuke_country` VALUES (127,'Mauritania');
INSERT INTO `nuke_country` VALUES (128,'Mauritius');
INSERT INTO `nuke_country` VALUES (129,'Mexico');
INSERT INTO `nuke_country` VALUES (130,'Moldova');
INSERT INTO `nuke_country` VALUES (131,'Monaco');
INSERT INTO `nuke_country` VALUES (132,'Mongolia');
INSERT INTO `nuke_country` VALUES (133,'Montserrat');
INSERT INTO `nuke_country` VALUES (134,'Morocco');
INSERT INTO `nuke_country` VALUES (135,'Mozambique');
INSERT INTO `nuke_country` VALUES (136,'Myanmar');
INSERT INTO `nuke_country` VALUES (137,'Myanmer');
INSERT INTO `nuke_country` VALUES (138,'Namibia');
INSERT INTO `nuke_country` VALUES (139,'Nauru');
INSERT INTO `nuke_country` VALUES (140,'Nepal');
INSERT INTO `nuke_country` VALUES (141,'Netherlands');
INSERT INTO `nuke_country` VALUES (142,'New Caledonia');
INSERT INTO `nuke_country` VALUES (143,'New Zealand');
INSERT INTO `nuke_country` VALUES (144,'Nicaragua');
INSERT INTO `nuke_country` VALUES (145,'Niger');
INSERT INTO `nuke_country` VALUES (146,'Nigeria');
INSERT INTO `nuke_country` VALUES (147,'North Korea');
INSERT INTO `nuke_country` VALUES (148,'Norway');
INSERT INTO `nuke_country` VALUES (149,'Oman');
INSERT INTO `nuke_country` VALUES (150,'Pakistan');
INSERT INTO `nuke_country` VALUES (151,'Panama');
INSERT INTO `nuke_country` VALUES (152,'Papua New Guinea');
INSERT INTO `nuke_country` VALUES (153,'Paraguay');
INSERT INTO `nuke_country` VALUES (154,'Peru');
INSERT INTO `nuke_country` VALUES (155,'Philippines');
INSERT INTO `nuke_country` VALUES (156,'Poland');
INSERT INTO `nuke_country` VALUES (157,'Portugal');
INSERT INTO `nuke_country` VALUES (158,'PuertoRico');
INSERT INTO `nuke_country` VALUES (159,'Qatar');
INSERT INTO `nuke_country` VALUES (160,'Reunion');
INSERT INTO `nuke_country` VALUES (161,'Romania');
INSERT INTO `nuke_country` VALUES (162,'Russia');
INSERT INTO `nuke_country` VALUES (163,'Rwanda');
INSERT INTO `nuke_country` VALUES (164,'Saint Eustatius');
INSERT INTO `nuke_country` VALUES (165,'Saint Kitts and Nevis');
INSERT INTO `nuke_country` VALUES (166,'Saint Lucia');
INSERT INTO `nuke_country` VALUES (167,'Saint Vincent and the Grenadines');
INSERT INTO `nuke_country` VALUES (168,'San Marino');
INSERT INTO `nuke_country` VALUES (169,'Sao Tome');
INSERT INTO `nuke_country` VALUES (170,'Saudi Arabia');
INSERT INTO `nuke_country` VALUES (171,'Senegal');
INSERT INTO `nuke_country` VALUES (172,'Seychelles');
INSERT INTO `nuke_country` VALUES (173,'SierraLeone');
INSERT INTO `nuke_country` VALUES (174,'Singapore');
INSERT INTO `nuke_country` VALUES (175,'Slovakia');
INSERT INTO `nuke_country` VALUES (176,'Slovenia');
INSERT INTO `nuke_country` VALUES (177,'Solomon Islands');
INSERT INTO `nuke_country` VALUES (178,'Somalia');
INSERT INTO `nuke_country` VALUES (179,'South Africa');
INSERT INTO `nuke_country` VALUES (180,'South Korea');
INSERT INTO `nuke_country` VALUES (181,'Spain');
INSERT INTO `nuke_country` VALUES (182,'Sri Lanka');
INSERT INTO `nuke_country` VALUES (183,'St Maarten');
INSERT INTO `nuke_country` VALUES (184,'Sudan');
INSERT INTO `nuke_country` VALUES (185,'Suriname');
INSERT INTO `nuke_country` VALUES (186,'Swaziland');
INSERT INTO `nuke_country` VALUES (187,'Sweden');
INSERT INTO `nuke_country` VALUES (188,'Syria');
INSERT INTO `nuke_country` VALUES (189,'Taiwan');
INSERT INTO `nuke_country` VALUES (190,'Tajikistan');
INSERT INTO `nuke_country` VALUES (191,'Tanzania');
INSERT INTO `nuke_country` VALUES (192,'Thailand');
INSERT INTO `nuke_country` VALUES (193,'Togo');
INSERT INTO `nuke_country` VALUES (194,'Trinidad and Tobago');
INSERT INTO `nuke_country` VALUES (195,'Tunisia');
INSERT INTO `nuke_country` VALUES (196,'Turkey');
INSERT INTO `nuke_country` VALUES (197,'Turkmenistan');
INSERT INTO `nuke_country` VALUES (198,'Turks and Caicos Islands');
INSERT INTO `nuke_country` VALUES (199,'Tuvalu');
INSERT INTO `nuke_country` VALUES (200,'Uganda');
INSERT INTO `nuke_country` VALUES (201,'Ukraine');
INSERT INTO `nuke_country` VALUES (202,'UnitedArabEmirates');
INSERT INTO `nuke_country` VALUES (203,'Uruguay');
INSERT INTO `nuke_country` VALUES (205,'Uzbekistan');
INSERT INTO `nuke_country` VALUES (206,'Vanuatu');
INSERT INTO `nuke_country` VALUES (207,'VaticanCity');
INSERT INTO `nuke_country` VALUES (208,'Venezuela');
INSERT INTO `nuke_country` VALUES (209,'Vietnam');
INSERT INTO `nuke_country` VALUES (210,'Virgin Islands - British');
INSERT INTO `nuke_country` VALUES (211,'Virgin Islands - US');
INSERT INTO `nuke_country` VALUES (212,'Yemen');
INSERT INTO `nuke_country` VALUES (213,'Yugoslavia');
INSERT INTO `nuke_country` VALUES (214,'Zaire (Congo)');
INSERT INTO `nuke_country` VALUES (215,'Zambia');
INSERT INTO `nuke_country` VALUES (216,'Zanzibar Island');
INSERT INTO `nuke_country` VALUES (217,'Zimbabwe');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_donators`
--
CREATE TABLE `nuke_donators` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`uname` varchar(60) NOT NULL default '',
`fname` varchar(25) NOT NULL default '',
`lname` varchar(25) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`donated` decimal(8,2) NOT NULL default '0.00',
`dondate` varchar(255) NOT NULL default '',
`donshow` tinyint(1) NOT NULL default '0',
`uip` varchar(255) NOT NULL default '',
`donok` tinyint(1) NOT NULL default '0',
`msg` text,
`donto` VARCHAR( 255 ) NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_donators`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_donators_config`
--
CREATE TABLE `nuke_donators_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` text NOT NULL,
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_donators_config`
--
INSERT INTO `nuke_donators_config` VALUES ('values', '5,10,25,50,100');
INSERT INTO `nuke_donators_config` VALUES ('block_show_amount', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('block_show_anon_amount', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('block_button_image', 'images/donations/x-click-but04.gif');
INSERT INTO `nuke_donators_config` VALUES ('block_num_donations', '10');
INSERT INTO `nuke_donators_config` VALUES ('block_show_dates', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('block_message', 'Find our site useful? Make a small donation to show your support.');
INSERT INTO `nuke_donators_config` VALUES ('block_show_goal', 'no');
INSERT INTO `nuke_donators_config` VALUES ('block_scroll', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('block_numbers', 'no');
INSERT INTO `nuke_donators_config` VALUES ('page_num_donations', '25');
INSERT INTO `nuke_donators_config` VALUES ('page_show_anon_amount', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('page_show_amount', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('page_show_dates', 'no');
INSERT INTO `nuke_donators_config` VALUES ('page_header_image', '');
INSERT INTO `nuke_donators_config` VALUES ('gen_pp_email', '');
INSERT INTO `nuke_donators_config` VALUES ('gen_donation_name', 'Site Donation');
INSERT INTO `nuke_donators_config` VALUES ('gen_donation_code', 'site_donation');
INSERT INTO `nuke_donators_config` VALUES ('gen_button_image', 'images/donations/x-click-butcc-donate.gif');
INSERT INTO `nuke_donators_config` VALUES ('gen_currency', 'USD');
INSERT INTO `nuke_donators_config` VALUES ('gen_monthly_goal', '50.00');
INSERT INTO `nuke_donators_config` VALUES ('gen_date_format', 'm/d/Y');
INSERT INTO `nuke_donators_config` VALUES ('gen_type_private', 'no');
INSERT INTO `nuke_donators_config` VALUES ('gen_type_anon', 'no');
INSERT INTO `nuke_donators_config` VALUES ('gen_thank_image', '');
INSERT INTO `nuke_donators_config` VALUES ('gen_thank_message', 'Thank you for your kind donation!
Please come again!');
INSERT INTO `nuke_donators_config` VALUES ('gen_cancel_image', 'images/logo.gif');
INSERT INTO `nuke_donators_config` VALUES ('gen_cancel_message', 'Sorry you could not donate!
Please come again!');
INSERT INTO `nuke_donators_config` VALUES ('gen_page_image', 'images/logo.gif');
INSERT INTO `nuke_donators_config` VALUES ('gen_message', 'yes');
INSERT INTO `nuke_donators_config` VALUES ('gen_codes', '');
INSERT INTO `nuke_donators_config` VALUES ('gen_cookie', 'no');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_accesses`
--
CREATE TABLE `nuke_downloads_accesses` (
`username` varchar(60) NOT NULL default '',
`downloads` int(11) NOT NULL default '0',
`uploads` int(11) NOT NULL default '0',
PRIMARY KEY (`username`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_accesses`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_categories`
--
CREATE TABLE `nuke_downloads_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`parentid` int(11) NOT NULL default '0',
`whoadd` tinyint(2) NOT NULL default '0',
`uploaddir` varchar(255) NOT NULL default '',
`canupload` tinyint(2) NOT NULL default '0',
`active` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_categories`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_config`
--
CREATE TABLE `nuke_downloads_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` text NOT NULL,
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_config`
--
INSERT INTO `nuke_downloads_config` VALUES ('admperpage', '50');
INSERT INTO `nuke_downloads_config` VALUES ('blockunregmodify', '0');
INSERT INTO `nuke_downloads_config` VALUES ('dateformat', 'D M j G:i:s T Y');
INSERT INTO `nuke_downloads_config` VALUES ('mostpopular', '25');
INSERT INTO `nuke_downloads_config` VALUES ('mostpopulartrig', '0');
INSERT INTO `nuke_downloads_config` VALUES ('perpage', '10');
INSERT INTO `nuke_downloads_config` VALUES ('popular', '500');
INSERT INTO `nuke_downloads_config` VALUES ('results', '10');
INSERT INTO `nuke_downloads_config` VALUES ('show_download', '0');
INSERT INTO `nuke_downloads_config` VALUES ('show_links_num', '0');
INSERT INTO `nuke_downloads_config` VALUES ('usegfxcheck', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_downloads`
--
CREATE TABLE `nuke_downloads_downloads` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`submitter` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
`active` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_downloads`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_extensions`
--
CREATE TABLE `nuke_downloads_extensions` (
`eid` int(11) NOT NULL auto_increment,
`ext` varchar(6) NOT NULL default '',
`file` tinyint(1) NOT NULL default '0',
`image` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`eid`),
KEY `ext` (`ext`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_extensions`
--
INSERT INTO `nuke_downloads_extensions` VALUES (1, '.ace', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (2, '.arj', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (3, '.bz', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (4, '.bz2', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (5, '.cab', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (6, '.exe', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (7, '.gif', 0, 1);
INSERT INTO `nuke_downloads_extensions` VALUES (8, '.gz', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (9, '.iso', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (10, '.jpeg', 0, 1);
INSERT INTO `nuke_downloads_extensions` VALUES (11, '.jpg', 0, 1);
INSERT INTO `nuke_downloads_extensions` VALUES (12, '.lha', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (13, '.lzh', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (14, '.png', 0, 1);
INSERT INTO `nuke_downloads_extensions` VALUES (15, '.rar', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (16, '.tar', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (17, '.tgz', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (18, '.uue', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (19, '.zip', 1, 0);
INSERT INTO `nuke_downloads_extensions` VALUES (20, '.zoo', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_mod`
--
CREATE TABLE `nuke_downloads_mods` (
`rid` int(11) NOT NULL auto_increment,
`lid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`modifier` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`brokendownload` int(3) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
PRIMARY KEY (`rid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_mod`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_new`
--
CREATE TABLE `nuke_downloads_new` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`submitter` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_downloads_new`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_evo_userinfo`
--
CREATE TABLE `nuke_evo_userinfo` (
`name` VARCHAR( 25 ) NOT NULL ,
`filename` VARCHAR( 25 ) NOT NULL ,
`active` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
`position` INT(10) NOT NULL,
`image` VARCHAR( 255 ) NOT NULL
) TYPE = MYISAM;
INSERT INTO `nuke_evo_userinfo` VALUES ('Good Afternoon', 'good_afternoon', 1, 1, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Username', 'username', 0, 3, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Rank', 'rank', 1, 5, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Login/logout/register', 'login', 1, 8, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Current Online', 'online', 1, 10, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('PMs', 'pms', 1, 7, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Users', 'users', 1, 11, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Most Ever', 'mostever', 1, 13, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Members', 'members', 1, 4, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Avatar', 'avatar', 1, 2, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Personal Message', 'personal_message', 0, 2, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Language', 'language', 0, 4, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Posts', 'posts', 1, 15, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Break', 'Break', 1, 12, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Break', 'Break', 1, 9, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Break', 'Break', 1, 6, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Break', 'Break', 1, 3, '');
INSERT INTO `nuke_evo_userinfo` VALUES ('Break', 'Break', 1, 14, '');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_evo_userinfo_addons`
--
CREATE TABLE `nuke_evo_userinfo_addons` (
`name` VARCHAR( 255 ) NOT NULL ,
`value` TEXT NOT NULL
) TYPE = MYISAM;
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('good_afternoon_message', 'Good morning %name%:');
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('personal_message_message', 'Hello %name%,
\r\nWelcome to %site%.
');
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('username_center', 'yes');
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('online_show_hv', 'no');
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('online_scroll', 'yes');
INSERT INTO `nuke_evo_userinfo_addons` VALUES ('online_show_members', 'no');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_evolution`
--
CREATE TABLE `nuke_evolution` (
`evo_field` varchar(50) NOT NULL default '',
`evo_value` text NOT NULL,
PRIMARY KEY (`evo_field`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_evolution`
--
INSERT INTO `nuke_evolution` VALUES ('sub', 'basic');
INSERT INTO `nuke_evolution` VALUES ('ver_check', '0');
INSERT INTO `nuke_evolution` VALUES ('ver_previous', '0');
INSERT INTO `nuke_evolution` VALUES ('lock_modules', '0');
INSERT INTO `nuke_evolution` VALUES ('queries_count', '1');
INSERT INTO `nuke_evolution` VALUES ('adminssl', '0');
INSERT INTO `nuke_evolution` VALUES ('poll_random', '0');
INSERT INTO `nuke_evolution` VALUES ('poll_days', '30');
INSERT INTO `nuke_evolution` VALUES ('censor_words', 'ass asshole arse bitch bullshit c0ck clit cock crap cum cunt fag faggot fuck fucker fucking fuk fuking motherfucker pussy shit tits twat');
INSERT INTO `nuke_evolution` VALUES ('censor', '0');
INSERT INTO `nuke_evolution` VALUES ('usrclearcache', '0');
INSERT INTO `nuke_evolution` VALUES ('cache_last_cleared', UNIX_TIMESTAMP( ));
INSERT INTO `nuke_evolution` VALUES ('textarea', 'none');
INSERT INTO `nuke_evolution` VALUES ('use_colors', '1');
INSERT INTO `nuke_evolution` VALUES ('usegfxcheck', '0');
INSERT INTO `nuke_evolution` VALUES ('codesize', '7');
INSERT INTO `nuke_evolution` VALUES ('codefont', 'verdana');
INSERT INTO `nuke_evolution` VALUES ('useimage', '1');
INSERT INTO `nuke_evolution` VALUES ('lazy_tap', '0');
INSERT INTO `nuke_evolution` VALUES ('img_resize', '1');
INSERT INTO `nuke_evolution` VALUES ('img_width', '300');
INSERT INTO `nuke_evolution` VALUES ('img_height', '300');
INSERT INTO `nuke_evolution` VALUES ('capfile', '');
INSERT INTO `nuke_evolution` VALUES ('module_collapse', '1');
INSERT INTO `nuke_evolution` VALUES ('collapse', '1');
INSERT INTO `nuke_evolution` VALUES ('evouserinfo_ec', '1');
INSERT INTO `nuke_evolution` VALUES ('collapsetype', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_faqanswer`
--
CREATE TABLE `nuke_faqanswer` (
`id` int(25) NOT NULL auto_increment,
`id_cat` int(25) NOT NULL default '0',
`question` varchar(255) default '',
`answer` text,
PRIMARY KEY (`id`),
KEY `id_cat` (`id_cat`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_faqanswer`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_faqcategories`
--
CREATE TABLE `nuke_faqcategories` (
`id_cat` tinyint(3) NOT NULL auto_increment,
`categories` varchar(255) default NULL,
`flanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`id_cat`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_faqcategories`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_headlines`
--
CREATE TABLE `nuke_headlines` (
`hid` int(11) NOT NULL auto_increment,
`sitename` varchar(30) NOT NULL default '',
`headlinesurl` varchar(200) NOT NULL default '',
PRIMARY KEY (`hid`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;
--
-- Dumping data for table `nuke_headlines`
--
INSERT INTO `nuke_headlines` VALUES (1, 'AbsoluteGames', 'http://files.gameaholic.com/agfa.rdf');
INSERT INTO `nuke_headlines` VALUES (2, 'BrunchingShuttlecocks', 'http://www.brunching.com/brunching.rdf');
INSERT INTO `nuke_headlines` VALUES (3, 'DailyDaemonNews', 'http://daily.daemonnews.org/ddn.rdf.php3');
INSERT INTO `nuke_headlines` VALUES (4, 'DigitalTheatre', 'http://www.dtheatre.com/backend.php3?xml=yes');
INSERT INTO `nuke_headlines` VALUES (5, 'DotKDE', 'http://dot.kde.org/rdf');
INSERT INTO `nuke_headlines` VALUES (6, 'FreeDOS', 'http://sourceforge.net/export/rss2_projnews.php?group_id=5109');
INSERT INTO `nuke_headlines` VALUES (7, 'Freshmeat', 'http://freshmeat.net/backend/fm.rdf');
INSERT INTO `nuke_headlines` VALUES (8, 'Gnome Desktop', 'http://www.gnomedesktop.org/backend.php');
INSERT INTO `nuke_headlines` VALUES (9, 'HappyPenguin', 'http://happypenguin.org/html/news.rdf');
INSERT INTO `nuke_headlines` VALUES (10, 'HollywoodBitchslap', 'http://hollywoodbitchslap.com/hbs.rdf');
INSERT INTO `nuke_headlines` VALUES (11, 'Learning Linux', 'http://www.learninglinux.com/backend.php');
INSERT INTO `nuke_headlines` VALUES (12, 'LinuxCentral', 'http://linuxcentral.com/backend/lcnew.rdf');
INSERT INTO `nuke_headlines` VALUES (13, 'LinuxJournal', 'http://www.linuxjournal.com/news.rss');
INSERT INTO `nuke_headlines` VALUES (14, 'LinuxWeelyNews', 'http://lwn.net/headlines/rss');
INSERT INTO `nuke_headlines` VALUES (15, 'Listology', 'http://listology.com/recent.rdf');
INSERT INTO `nuke_headlines` VALUES (16, 'MozillaNews', 'http://www.mozilla.org/news.rdf');
INSERT INTO `nuke_headlines` VALUES (17, 'NewsForge', 'http://www.newsforge.com/newsforge.rdf');
INSERT INTO `nuke_headlines` VALUES (18, 'Nuke-Evolution', 'http://www.nuke-evolution.com/rss.php?feed=news');
INSERT INTO `nuke_headlines` VALUES (19, 'NukeResources', 'http://www.nukeresources.com/backend.php');
INSERT INTO `nuke_headlines` VALUES (20, 'NukeScripts', 'http://www.nukescripts.net/backend.php');
INSERT INTO `nuke_headlines` VALUES (21, 'PDABuzz', 'http://www.pdabuzz.com/Home/tabid/54/moduleid/489/RSS.aspx');
INSERT INTO `nuke_headlines` VALUES (22, 'PHP-Nuke', 'http://phpnuke.org/backend.php');
INSERT INTO `nuke_headlines` VALUES (23, 'PHP.net', 'http://www.php.net/news.rss');
INSERT INTO `nuke_headlines` VALUES (24, 'PHPBuilder', 'http://phpbuilder.com/rss_feed.php');
INSERT INTO `nuke_headlines` VALUES (25, 'PerlMonks', 'http://www.perlmonks.org/headlines.rdf');
INSERT INTO `nuke_headlines` VALUES (26, 'TheNextLevel', 'http://www.the-nextlevel.com/rss/news');
INSERT INTO `nuke_headlines` VALUES (27, 'WebReference', 'http://webreference.com/webreference.rdf');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_jmap`
--
CREATE TABLE `nuke_jmap` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_jmap`
--
INSERT INTO `nuke_jmap` VALUES ('xml', '1');
INSERT INTO `nuke_jmap` VALUES ('ntopics', '10');
INSERT INTO `nuke_jmap` VALUES ('nnews', '15');
INSERT INTO `nuke_jmap` VALUES ('ndown', '10');
INSERT INTO `nuke_jmap` VALUES ('nrev', '10');
INSERT INTO `nuke_jmap` VALUES ('nuser', '5');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_links_categories`
--
CREATE TABLE `nuke_links_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_links_categories`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_links_editorials`
--
CREATE TABLE `nuke_links_editorials` (
`linkid` int(11) NOT NULL default '0',
`adminid` varchar(60) NOT NULL default '',
`editorialtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`editorialtext` text NOT NULL,
`editorialtitle` varchar(100) NOT NULL default '',
PRIMARY KEY (`linkid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_links_editorials`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_links_links`
--
CREATE TABLE `nuke_links_links` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`date` datetime default NULL,
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`submitter` varchar(60) NOT NULL default '',
`linkratingsummary` double(6,4) NOT NULL default '0.0000',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_links_links`
--
-- ---------------------------------------------------