| [ Index ] |
PHP Cross Reference of Nuke-Evolution v2.0.5 |
[Summary view] [Print] [Text view]
1 CREATE TABLE `nuke_authors` ( 2 `aid` varchar(25) NOT NULL default '', 3 `name` varchar(50) default NULL, 4 `url` varchar(255) NOT NULL default '', 5 `email` varchar(255) NOT NULL default '', 6 `pwd` varchar(40) default NULL, 7 `counter` int(11) NOT NULL default '0', 8 `radminsuper` tinyint(1) NOT NULL default '1', 9 `admlanguage` varchar(30) NOT NULL default '', 10 PRIMARY KEY (`aid`) 11 ) TYPE=MyISAM; 12 13 -- 14 -- Dumping data for table `nuke_authors` 15 -- 16 17 18 -- -------------------------------------------------------- 19 20 -- 21 -- Table structure for table `nuke_autonews` 22 -- 23 24 CREATE TABLE `nuke_autonews` ( 25 `anid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 26 `catid` INT(11) DEFAULT '0' NOT NULL, 27 `aid` VARCHAR(30) NOT NULL, 28 `title` VARCHAR(80) NOT NULL, 29 `time` varchar(19) NOT NULL default '', 30 `hometext` TEXT NOT NULL, 31 `bodytext` TEXT NOT NULL, 32 `topic` INT(11) DEFAULT '1' NOT NULL, 33 `informant` VARCHAR(40) NOT NULL, 34 `notes` TEXT NOT NULL, 35 `ihome` TINYINT(4) DEFAULT '0' NOT NULL, 36 `alanguage` VARCHAR(30) NOT NULL, 37 `acomm` TINYINT(4) DEFAULT '0' NOT NULL, 38 `associated` TEXT NOT NULL, 39 `ticon` tinyint(1) NOT NULL default '0', 40 `writes` TINYINT( 1 ) DEFAULT '1' NOT NULL, 41 PRIMARY KEY (`anid`), 42 UNIQUE `anid` (`anid`) 43 ); 44 45 -- 46 -- Dumping data for table `nuke_autonews` 47 -- 48 49 -- -------------------------------------------------------- 50 51 -- 52 -- Table structure for table `nuke_banner` 53 -- 54 55 CREATE TABLE `nuke_banner` ( 56 `bid` int(11) NOT NULL auto_increment, 57 `cid` int(11) NOT NULL default '0', 58 `name` varchar(50) NOT NULL default '', 59 `imptotal` int(11) NOT NULL default '0', 60 `impmade` int(11) NOT NULL default '0', 61 `clicks` int(11) NOT NULL default '0', 62 `imageurl` varchar(100) NOT NULL default '', 63 `clickurl` varchar(200) NOT NULL default '', 64 `alttext` varchar(255) NOT NULL default '', 65 `date` datetime default NULL, 66 `dateend` datetime default NULL, 67 `position` int(10) NOT NULL default '0', 68 `active` tinyint(1) NOT NULL default '1', 69 `ad_class` varchar(5) NOT NULL default '', 70 `ad_code` text NOT NULL, 71 `ad_width` int(4) default '0', 72 `ad_height` int(4) default '0', 73 `type` varchar(255) NOT NULL default '', 74 PRIMARY KEY (`bid`), 75 KEY `cid` (`cid`) 76 ) TYPE=MyISAM; 77 78 -- 79 -- Dumping data for table `nuke_banner` 80 -- 81 82 83 -- -------------------------------------------------------- 84 85 -- 86 -- Table structure for table `nuke_banner_clients` 87 -- 88 89 CREATE TABLE `nuke_banner_clients` ( 90 `cid` int(11) NOT NULL auto_increment, 91 `name` varchar(60) NOT NULL default '', 92 `contact` varchar(60) NOT NULL default '', 93 `email` varchar(60) NOT NULL default '', 94 `login` varchar(10) NOT NULL default '', 95 `passwd` varchar(10) NOT NULL default '', 96 `extrainfo` text NOT NULL, 97 PRIMARY KEY (`cid`) 98 ) TYPE=MyISAM; 99 100 -- 101 -- Dumping data for table `nuke_banner_clients` 102 -- 103 104 105 -- -------------------------------------------------------- 106 107 -- 108 -- Table structure for table `nuke_banner_plans` 109 -- 110 111 CREATE TABLE `nuke_banner_plans` ( 112 `pid` int(10) NOT NULL auto_increment, 113 `active` tinyint(1) NOT NULL default '0', 114 `name` varchar(255) NOT NULL default '', 115 `description` text NOT NULL, 116 `delivery` varchar(10) NOT NULL default '', 117 `delivery_type` varchar(25) NOT NULL default '', 118 `price` varchar(25) NOT NULL default '0', 119 `buy_links` text NOT NULL, 120 PRIMARY KEY (`pid`) 121 ) TYPE=MyISAM; 122 123 -- 124 -- Dumping data for table `nuke_banner_plans` 125 -- 126 127 128 -- -------------------------------------------------------- 129 130 -- 131 -- Table structure for table `nuke_banner_positions` 132 -- 133 134 CREATE TABLE `nuke_banner_positions` ( 135 `apid` int(10) NOT NULL auto_increment, 136 `position_number` int(5) NOT NULL default '0', 137 `position_name` varchar(255) NOT NULL default '', 138 PRIMARY KEY (`apid`), 139 KEY `position_number` (`position_number`) 140 ) TYPE=MyISAM AUTO_INCREMENT=4 ; 141 142 -- 143 -- Dumping data for table `nuke_banner_positions` 144 -- 145 146 INSERT INTO `nuke_banner_positions` VALUES (1, 0, 'Page Top'); 147 INSERT INTO `nuke_banner_positions` VALUES (2, 1, 'Left Block'); 148 INSERT INTO `nuke_banner_positions` VALUES (3, 2, 'Page Bottom'); 149 150 -- -------------------------------------------------------- 151 152 -- 153 -- Table structure for table `nuke_banner_terms` 154 -- 155 156 CREATE TABLE `nuke_banner_terms` ( 157 `terms_body` text NOT NULL, 158 `country` varchar(255) NOT NULL default '' 159 ) TYPE=MyISAM; 160 161 -- 162 -- Dumping data for table `nuke_banner_terms` 163 -- 164 165 INSERT INTO `nuke_banner_terms` VALUES ('<div align="justify"><strong>Introduction:</strong> 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.<br /><strong><br />Uses:</strong> 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.<br /><br /></div><div align="justify"><strong>Parties'' Responsibilities:</strong> 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.<br /><br /></div><div align="justify"><strong>Impressions Count:</strong> 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.<br /><br /></div><div align="justify"><strong>Termination, Cancellation:</strong> [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.<br /><br /></div><div align="justify"><strong>Content:</strong> [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.<br /><br /></div><div align="justify"><strong>Confidentiality:</strong> 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.<br /><br /></div><div align="justify"><strong>No Guarantee:</strong> [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.<br /><br /></div><div align="justify"><strong>No Warranty:</strong> [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.<br /><br /></div><div align="justify"><strong>Limitations of Liability:</strong> 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.<br /><br /></div><div align="justify"><strong>Payment:</strong> 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.<br /><br /></div><div align="justify"><strong>Representations and Warranties:</strong> 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.<br /><br /></div><div align="justify"><strong>Your Obligation to Indemnify:</strong> 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.<br /><br /></div><div align="justify"><strong>Information Rights:</strong> [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.<br /><br /></div><div align="justify"><strong>Miscellaneous:</strong> 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.</div>', 'Canada'); 166 167 -- -------------------------------------------------------- 168 169 -- 170 -- Table structure for table `nuke_bbadvanced_username_color` 171 -- 172 173 CREATE TABLE `nuke_bbadvanced_username_color` ( 174 `group_id` int(10) unsigned NOT NULL auto_increment, 175 `group_name` varchar(255) NOT NULL default '', 176 `group_color` varchar(6) NOT NULL default '', 177 `group_weight` smallint(2) NOT NULL default '0', 178 PRIMARY KEY (`group_id`) 179 ) TYPE=MyISAM AUTO_INCREMENT=3 ; 180 181 -- 182 -- Dumping data for table `nuke_bbadvanced_username_color` 183 -- 184 185 INSERT INTO `nuke_bbadvanced_username_color` VALUES (1, 'Administrators', 'FFA34F', 1); 186 INSERT INTO `nuke_bbadvanced_username_color` VALUES (2, 'Moderators', '006600', 2); 187 188 -- -------------------------------------------------------- 189 190 -- 191 -- Table structure for table `nuke_bbattach_quota` 192 -- 193 194 CREATE TABLE `nuke_bbattach_quota` ( 195 `user_id` mediumint(8) unsigned NOT NULL default '0', 196 `group_id` mediumint(8) unsigned NOT NULL default '0', 197 `quota_type` smallint(2) NOT NULL default '0', 198 `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', 199 KEY `quota_type` (`quota_type`) 200 ) TYPE=MyISAM; 201 202 -- 203 -- Dumping data for table `nuke_bbattach_quota` 204 -- 205 206 207 -- -------------------------------------------------------- 208 209 -- 210 -- Table structure for table `nuke_bbattachments` 211 -- 212 213 CREATE TABLE `nuke_bbattachments` ( 214 `attach_id` mediumint(8) unsigned NOT NULL default '0', 215 `post_id` mediumint(8) unsigned NOT NULL default '0', 216 `privmsgs_id` mediumint(8) unsigned NOT NULL default '0', 217 `user_id_1` mediumint(8) NOT NULL default '0', 218 `user_id_2` mediumint(8) NOT NULL default '0', 219 KEY `attach_id_post_id` (`attach_id`,`post_id`), 220 KEY `attach_id_privmsgs_id` (`attach_id`,`privmsgs_id`), 221 KEY `post_id` (`post_id`), 222 KEY `privmsgs_id` (`privmsgs_id`) 223 ) TYPE=MyISAM; 224 225 -- 226 -- Dumping data for table `nuke_bbattachments` 227 -- 228 229 230 -- -------------------------------------------------------- 231 232 -- 233 -- Table structure for table `nuke_bbattachments_config` 234 -- 235 236 CREATE TABLE `nuke_bbattachments_config` ( 237 `config_name` varchar(255) NOT NULL default '', 238 `config_value` varchar(255) NOT NULL default '', 239 PRIMARY KEY (`config_name`) 240 ) TYPE=MyISAM; 241 242 -- 243 -- Dumping data for table `nuke_bbattachments_config` 244 -- 245 246 INSERT INTO `nuke_bbattachments_config` VALUES ('upload_dir', 'modules/Forums/files'); 247 INSERT INTO `nuke_bbattachments_config` VALUES ('upload_img', 'modules/Forums/images/icon_clip.gif'); 248 INSERT INTO `nuke_bbattachments_config` VALUES ('topic_icon', 'modules/Forums/images/icon_clip.gif'); 249 INSERT INTO `nuke_bbattachments_config` VALUES ('display_order', '0'); 250 INSERT INTO `nuke_bbattachments_config` VALUES ('max_filesize', '262144'); 251 INSERT INTO `nuke_bbattachments_config` VALUES ('attachment_quota', '52428800'); 252 INSERT INTO `nuke_bbattachments_config` VALUES ('max_filesize_pm', '262144'); 253 INSERT INTO `nuke_bbattachments_config` VALUES ('max_attachments', '3'); 254 INSERT INTO `nuke_bbattachments_config` VALUES ('max_attachments_pm', '1'); 255 INSERT INTO `nuke_bbattachments_config` VALUES ('disable_mod', '0'); 256 INSERT INTO `nuke_bbattachments_config` VALUES ('allow_pm_attach', '1'); 257 INSERT INTO `nuke_bbattachments_config` VALUES ('attachment_topic_review', '1'); 258 INSERT INTO `nuke_bbattachments_config` VALUES ('allow_ftp_upload', '0'); 259 INSERT INTO `nuke_bbattachments_config` VALUES ('show_apcp', '0'); 260 INSERT INTO `nuke_bbattachments_config` VALUES ('attach_version', '2.4.5'); 261 INSERT INTO `nuke_bbattachments_config` VALUES ('default_upload_quota', '0'); 262 INSERT INTO `nuke_bbattachments_config` VALUES ('default_pm_quota', '0'); 263 INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_server', 'ftp.yoursite.com'); 264 INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_path', '/public_html/modules/Forums/files'); 265 INSERT INTO `nuke_bbattachments_config` VALUES ('download_path', 'http://www.yoursite.com/modules/Forums/files'); 266 INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_user', ''); 267 INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_pass', ''); 268 INSERT INTO `nuke_bbattachments_config` VALUES ('ftp_pasv_mode', '1'); 269 INSERT INTO `nuke_bbattachments_config` VALUES ('img_display_inlined', '1'); 270 INSERT INTO `nuke_bbattachments_config` VALUES ('img_max_width', '0'); 271 INSERT INTO `nuke_bbattachments_config` VALUES ('img_max_height', '0'); 272 INSERT INTO `nuke_bbattachments_config` VALUES ('img_link_width', '0'); 273 INSERT INTO `nuke_bbattachments_config` VALUES ('img_link_height', '0'); 274 INSERT INTO `nuke_bbattachments_config` VALUES ('img_create_thumbnail', '1'); 275 INSERT INTO `nuke_bbattachments_config` VALUES ('img_min_thumb_filesize', '12000'); 276 INSERT INTO `nuke_bbattachments_config` VALUES ('img_imagick', '/usr/bin/convert'); 277 INSERT INTO `nuke_bbattachments_config` VALUES ('use_gd2', '0'); 278 INSERT INTO `nuke_bbattachments_config` VALUES ('wma_autoplay', '0'); 279 INSERT INTO `nuke_bbattachments_config` VALUES ('flash_autoplay', '0'); 280 281 -- -------------------------------------------------------- 282 283 -- 284 -- Table structure for table `nuke_bbattachments_desc` 285 -- 286 287 CREATE TABLE `nuke_bbattachments_desc` ( 288 `attach_id` mediumint(8) unsigned NOT NULL auto_increment, 289 `physical_filename` varchar(255) NOT NULL default '', 290 `real_filename` varchar(255) NOT NULL default '', 291 `download_count` mediumint(8) unsigned NOT NULL default '0', 292 `comment` varchar(255) default NULL, 293 `extension` varchar(100) default NULL, 294 `mimetype` varchar(100) default NULL, 295 `filesize` int(20) NOT NULL default '0', 296 `filetime` int(11) NOT NULL default '0', 297 `thumbnail` tinyint(1) NOT NULL default '0', 298 PRIMARY KEY (`attach_id`), 299 KEY `filetime` (`filetime`), 300 KEY `physical_filename` (`physical_filename`(10)), 301 KEY `filesize` (`filesize`) 302 ) TYPE=MyISAM; 303 304 -- 305 -- Dumping data for table `nuke_bbattachments_desc` 306 -- 307 308 309 -- -------------------------------------------------------- 310 311 -- 312 -- Table structure for table `nuke_bbauth_access` 313 -- 314 315 CREATE TABLE `nuke_bbauth_access` ( 316 `group_id` mediumint(8) NOT NULL default '0', 317 `forum_id` smallint(5) unsigned NOT NULL default '0', 318 `auth_view` tinyint(1) NOT NULL default '0', 319 `auth_read` tinyint(1) NOT NULL default '0', 320 `auth_post` tinyint(1) NOT NULL default '0', 321 `auth_reply` tinyint(1) NOT NULL default '0', 322 `auth_edit` tinyint(1) NOT NULL default '0', 323 `auth_delete` tinyint(1) NOT NULL default '0', 324 `auth_sticky` tinyint(1) NOT NULL default '0', 325 `auth_announce` tinyint(1) NOT NULL default '0', 326 `auth_globalannounce` tinyint(1) NOT NULL default '0', 327 `auth_vote` tinyint(1) NOT NULL default '0', 328 `auth_pollcreate` tinyint(1) NOT NULL default '0', 329 `auth_attachments` tinyint(1) NOT NULL default '0', 330 `auth_mod` tinyint(1) NOT NULL default '0', 331 `auth_download` tinyint(1) NOT NULL default '0', 332 KEY `group_id` (`group_id`), 333 KEY `forum_id` (`forum_id`) 334 ) TYPE=MyISAM; 335 336 -- 337 -- Dumping data for table `nuke_bbauth_access` 338 -- 339 340 341 -- -------------------------------------------------------- 342 343 -- 344 -- Table structure for table `nuke_bbbanlist` 345 -- 346 347 CREATE TABLE `nuke_bbbanlist` ( 348 `ban_id` mediumint(8) unsigned NOT NULL auto_increment, 349 `ban_userid` mediumint(8) NOT NULL default '0', 350 `ban_ip` varchar(8) NOT NULL default '', 351 `ban_email` varchar(255) default NULL, 352 `ban_time` int(11) default NULL, 353 PRIMARY KEY (`ban_id`), 354 KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`) 355 ) TYPE=MyISAM; 356 357 -- 358 -- Dumping data for table `nuke_bbbanlist` 359 -- 360 361 -- -------------------------------------------------------- 362 363 -- 364 -- Table structure for table `nuke_bbcategories` 365 -- 366 367 CREATE TABLE `nuke_bbcategories` ( 368 `cat_id` mediumint(8) unsigned NOT NULL auto_increment, 369 `cat_title` varchar(100) default NULL, 370 `cat_order` mediumint(8) unsigned NOT NULL default '0', 371 PRIMARY KEY (`cat_id`), 372 KEY `cat_order` (`cat_order`) 373 ) TYPE=MyISAM AUTO_INCREMENT=2 ; 374 375 -- 376 -- Dumping data for table `nuke_bbcategories` 377 -- 378 379 INSERT INTO `nuke_bbcategories` VALUES (1, 'General', 10); 380 381 -- -------------------------------------------------------- 382 383 -- 384 -- Table structure for table `nuke_bbconfig` 385 -- 386 387 CREATE TABLE `nuke_bbconfig` ( 388 `config_name` varchar(255) NOT NULL default '', 389 `config_value` varchar(255) NOT NULL default '', 390 PRIMARY KEY (`config_name`) 391 ) TYPE=MyISAM; 392 393 -- 394 -- Dumping data for table `nuke_bbconfig` 395 -- 396 397 INSERT INTO `nuke_bbconfig` VALUES ('config_id', '1'); 398 INSERT INTO `nuke_bbconfig` VALUES ('board_disable', '0'); 399 INSERT INTO `nuke_bbconfig` VALUES ('board_disable_adminview', '1'); 400 INSERT INTO `nuke_bbconfig` VALUES ('board_disable_msg', 'The board is currently disabled...'); 401 INSERT INTO `nuke_bbconfig` VALUES ('sitename', 'My Site'); 402 INSERT INTO `nuke_bbconfig` VALUES ('site_desc', ''); 403 INSERT INTO `nuke_bbconfig` VALUES ('cookie_name', 'nukeevo'); 404 INSERT INTO `nuke_bbconfig` VALUES ('cookie_path', '/'); 405 INSERT INTO `nuke_bbconfig` VALUES ('cookie_domain', 'MySite.com'); 406 INSERT INTO `nuke_bbconfig` VALUES ('cookie_secure', '0'); 407 INSERT INTO `nuke_bbconfig` VALUES ('session_length', '3600'); 408 INSERT INTO `nuke_bbconfig` VALUES ('allow_html', '1'); 409 INSERT INTO `nuke_bbconfig` VALUES ('allow_html_tags', 'b,i,u,pre'); 410 INSERT INTO `nuke_bbconfig` VALUES ('allow_bbcode', '1'); 411 INSERT INTO `nuke_bbconfig` VALUES ('allow_smilies', '1'); 412 INSERT INTO `nuke_bbconfig` VALUES ('allow_sig', '1'); 413 INSERT INTO `nuke_bbconfig` VALUES ('allow_namechange', '0'); 414 INSERT INTO `nuke_bbconfig` VALUES ('allow_theme_create', '0'); 415 INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_local', '1'); 416 INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_remote', '0'); 417 INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_upload', '0'); 418 INSERT INTO `nuke_bbconfig` VALUES ('override_user_style', '1'); 419 INSERT INTO `nuke_bbconfig` VALUES ('posts_per_page', '15'); 420 INSERT INTO `nuke_bbconfig` VALUES ('topics_per_page', '50'); 421 INSERT INTO `nuke_bbconfig` VALUES ('hot_threshold', '25'); 422 INSERT INTO `nuke_bbconfig` VALUES ('max_poll_options', '10'); 423 INSERT INTO `nuke_bbconfig` VALUES ('max_sig_chars', '255'); 424 INSERT INTO `nuke_bbconfig` VALUES ('max_smilies', '15'); 425 INSERT INTO `nuke_bbconfig` VALUES ('max_inbox_privmsgs', '100'); 426 INSERT INTO `nuke_bbconfig` VALUES ('max_sentbox_privmsgs', '100'); 427 INSERT INTO `nuke_bbconfig` VALUES ('max_savebox_privmsgs', '100'); 428 INSERT INTO `nuke_bbconfig` VALUES ('board_email_sig', 'Thanks, Webmaster@MySite.com'); 429 INSERT INTO `nuke_bbconfig` VALUES ('board_email', 'Webmaster@MySite.com'); 430 INSERT INTO `nuke_bbconfig` VALUES ('smtp_delivery', '0'); 431 INSERT INTO `nuke_bbconfig` VALUES ('smtp_host', ''); 432 INSERT INTO `nuke_bbconfig` VALUES ('require_activation', '0'); 433 INSERT INTO `nuke_bbconfig` VALUES ('flood_interval', '15'); 434 INSERT INTO `nuke_bbconfig` VALUES ('search_flood_interval', '15'); 435 INSERT INTO `nuke_bbconfig` VALUES ('board_email_form', '0'); 436 INSERT INTO `nuke_bbconfig` VALUES ('avatar_filesize', '6144'); 437 INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_width', '80'); 438 INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_height', '80'); 439 INSERT INTO `nuke_bbconfig` VALUES ('avatar_path', 'modules/Forums/images/avatars'); 440 INSERT INTO `nuke_bbconfig` VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars'); 441 INSERT INTO `nuke_bbconfig` VALUES ('smilies_path', 'modules/Forums/images/smiles'); 442 INSERT INTO `nuke_bbconfig` VALUES ('default_style', '1'); 443 INSERT INTO `nuke_bbconfig` VALUES ('default_dateformat', 'D M d, Y g:i a'); 444 INSERT INTO `nuke_bbconfig` VALUES ('board_timezone', '10'); 445 INSERT INTO `nuke_bbconfig` VALUES ('prune_enable', '0'); 446 INSERT INTO `nuke_bbconfig` VALUES ('privmsg_disable', '0'); 447 INSERT INTO `nuke_bbconfig` VALUES ('gzip_compress', '0'); 448 INSERT INTO `nuke_bbconfig` VALUES ('coppa_fax', ''); 449 INSERT INTO `nuke_bbconfig` VALUES ('coppa_mail', ''); 450 INSERT INTO `nuke_bbconfig` VALUES ('board_startdate', '1131089812'); 451 INSERT INTO `nuke_bbconfig` VALUES ('default_lang', 'english'); 452 INSERT INTO `nuke_bbconfig` VALUES ('smtp_username', ''); 453 INSERT INTO `nuke_bbconfig` VALUES ('smtp_password', ''); 454 INSERT INTO `nuke_bbconfig` VALUES ('record_online_users', '2'); 455 INSERT INTO `nuke_bbconfig` VALUES ('record_online_date', '1034668530'); 456 INSERT INTO `nuke_bbconfig` VALUES ('server_name', 'MySite.com'); 457 INSERT INTO `nuke_bbconfig` VALUES ('server_port', '80'); 458 INSERT INTO `nuke_bbconfig` VALUES ('script_path', '/modules/Forums/'); 459 INSERT INTO `nuke_bbconfig` VALUES ('version', '.0.22'); 460 INSERT INTO `nuke_bbconfig` VALUES ('enable_confirm', '0'); 461 INSERT INTO `nuke_bbconfig` VALUES ('sendmail_fix', '0'); 462 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_lines', '5'); 463 INSERT INTO `nuke_bbconfig` VALUES ('sig_wordwrap', '100'); 464 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_font_sizes', '1'); 465 INSERT INTO `nuke_bbconfig` VALUES ('sig_min_font_size', '7'); 466 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_font_size', '12'); 467 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_bold', '1'); 468 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_italic', '1'); 469 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_underline', '1'); 470 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_colors', '1'); 471 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_quote', '0'); 472 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_code', '0'); 473 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_list', '0'); 474 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_url', '1'); 475 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_images', '1'); 476 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_images', '0'); 477 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_height', '75'); 478 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_width', '500'); 479 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_on_max_img_size_fail', '0'); 480 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_files_size', '10'); 481 INSERT INTO `nuke_bbconfig` VALUES ('sig_max_img_av_files_size', '0'); 482 INSERT INTO `nuke_bbconfig` VALUES ('sig_exotic_bbcodes_disallowed', ''); 483 INSERT INTO `nuke_bbconfig` VALUES ('sig_allow_smilies', '1'); 484 INSERT INTO `nuke_bbconfig` VALUES ('report_email', '1'); 485 INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply', '1'); 486 INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply_bbc', '1'); 487 INSERT INTO `nuke_bbconfig` VALUES ('ropm_quick_reply_smilies', '22'); 488 INSERT INTO `nuke_bbconfig` VALUES ('wrap_enable', '1'); 489 INSERT INTO `nuke_bbconfig` VALUES ('wrap_min', '50'); 490 INSERT INTO `nuke_bbconfig` VALUES ('wrap_max', '99'); 491 INSERT INTO `nuke_bbconfig` VALUES ('wrap_def', '70'); 492 INSERT INTO `nuke_bbconfig` VALUES ('allow_quickreply', '1'); 493 INSERT INTO `nuke_bbconfig` VALUES ('anonymous_show_sqr', '0'); 494 INSERT INTO `nuke_bbconfig` VALUES ('anonymous_sqr_mode', '0'); 495 INSERT INTO `nuke_bbconfig` VALUES ('quick_search_enable', '1'); 496 INSERT INTO `nuke_bbconfig` VALUES ('sig_line', '<hr>'); 497 INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_guests_url', 'modules/Forums/images/avatars/blank.gif'); 498 INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_users_url', 'modules/Forums/images/avatars/blank.gif'); 499 INSERT INTO `nuke_bbconfig` VALUES ('default_avatar_set', '2'); 500 INSERT INTO `nuke_bbconfig` VALUES ('pm_allow_threshold', '0'); 501 INSERT INTO `nuke_bbconfig` VALUES ('welcome_pm', '0'); 502 INSERT INTO `nuke_bbconfig` VALUES ('default_time_mode', '6'); 503 INSERT INTO `nuke_bbconfig` VALUES ('default_dst_time_lag', '60'); 504 INSERT INTO `nuke_bbconfig` VALUES ('glance_show', '1'); 505 INSERT INTO `nuke_bbconfig` VALUES ('glance_show_override', '1'); 506 INSERT INTO `nuke_bbconfig` VALUES ('glance_news_id', '0'); 507 INSERT INTO `nuke_bbconfig` VALUES ('glance_num_news', '0'); 508 INSERT INTO `nuke_bbconfig` VALUES ('glance_num', '6'); 509 INSERT INTO `nuke_bbconfig` VALUES ('glance_ignore_forums', '0'); 510 INSERT INTO `nuke_bbconfig` VALUES ('glance_table_width', '100%'); 511 INSERT INTO `nuke_bbconfig` VALUES ('glance_auth_read', '1'); 512 INSERT INTO `nuke_bbconfig` VALUES ('glance_topic_length', '0'); 513 INSERT INTO `nuke_bbconfig` VALUES ('online_time', '300'); 514 INSERT INTO `nuke_bbconfig` VALUES ('display_users_today', '0'); 515 INSERT INTO `nuke_bbconfig` VALUES ('locked_view_open', 'Locked: <strike>'); 516 INSERT INTO `nuke_bbconfig` VALUES ('locked_view_close', '</strike>'); 517 INSERT INTO `nuke_bbconfig` VALUES ('global_view_open', 'Global Announcement:'); 518 INSERT INTO `nuke_bbconfig` VALUES ('global_view_close', ''); 519 INSERT INTO `nuke_bbconfig` VALUES ('announce_view_open', 'Announcement:'); 520 INSERT INTO `nuke_bbconfig` VALUES ('announce_view_close', ''); 521 INSERT INTO `nuke_bbconfig` VALUES ('sticky_view_open', 'Sticky:'); 522 INSERT INTO `nuke_bbconfig` VALUES ('sticky_view_close', ''); 523 INSERT INTO `nuke_bbconfig` VALUES ('moved_view_open', 'Moved:'); 524 INSERT INTO `nuke_bbconfig` VALUES ('moved_view_close', ''); 525 INSERT INTO `nuke_bbconfig` VALUES ('initial_group_id', '5'); 526 INSERT INTO `nuke_bbconfig` VALUES ('hide_links', '0'); 527 INSERT INTO `nuke_bbconfig` VALUES ('hide_emails', '0'); 528 INSERT INTO `nuke_bbconfig` VALUES ('hide_images', '0'); 529 INSERT INTO `nuke_bbconfig` VALUES ('use_dhtml', '1'); 530 INSERT INTO `nuke_bbconfig` VALUES ('anonymous_open_sqr', '0'); 531 INSERT INTO `nuke_bbconfig` VALUES ('smilies_in_titles', '1'); 532 INSERT INTO `nuke_bbconfig` VALUES ('show_edited_logs', '1'); 533 INSERT INTO `nuke_bbconfig` VALUES ('show_locked_logs', '1'); 534 INSERT INTO `nuke_bbconfig` VALUES ('show_unlocked_logs', '1'); 535 INSERT INTO `nuke_bbconfig` VALUES ('show_splitted_logs', '1'); 536 INSERT INTO `nuke_bbconfig` VALUES ('show_moved_logs', '1'); 537 INSERT INTO `nuke_bbconfig` VALUES ('logs_view_level', '2'); 538 INSERT INTO `nuke_bbconfig` VALUES ('aprvmArchive', '0'); 539 INSERT INTO `nuke_bbconfig` VALUES ('aprvmVersion', '1.6.0'); 540 INSERT INTO `nuke_bbconfig` VALUES ('aprvmView', '0'); 541 INSERT INTO `nuke_bbconfig` VALUES ('aprvmRows', '25'); 542 INSERT INTO `nuke_bbconfig` VALUES ('aprvmIP', '1'); 543 INSERT INTO `nuke_bbconfig` VALUES ('image_resize_width', '400'); 544 INSERT INTO `nuke_bbconfig` VALUES ('image_resize_height', '400'); 545 INSERT INTO `nuke_bbconfig` VALUES ('use_theme_style', '1'); 546 INSERT INTO `nuke_bbconfig` VALUES ('allow_autologin','1'); 547 INSERT INTO `nuke_bbconfig` VALUES ('max_autologin_time','0'); 548 INSERT INTO `nuke_bbconfig` VALUES ('max_login_attempts', '5'); 549 INSERT INTO `nuke_bbconfig` VALUES ('login_reset_time', '30'); 550 INSERT INTO `nuke_bbconfig` VALUES ('show_sig_once', '0'); 551 INSERT INTO `nuke_bbconfig` VALUES ('show_avatar_once', '0'); 552 INSERT INTO `nuke_bbconfig` VALUES ('show_rank_once', '0'); 553 INSERT INTO `nuke_bbconfig` VALUES ('loginpage', '1'); 554 INSERT INTO `nuke_bbconfig` VALUES ('rand_seed', '0'); 555 556 -- -------------------------------------------------------- 557 558 -- 559 -- Table structure for table `nuke_bbdisallow` 560 -- 561 562 CREATE TABLE `nuke_bbdisallow` ( 563 `disallow_id` mediumint(8) unsigned NOT NULL auto_increment, 564 `disallow_username` varchar(25) default NULL, 565 PRIMARY KEY (`disallow_id`) 566 ) TYPE=MyISAM; 567 568 -- 569 -- Dumping data for table `nuke_bbdisallow` 570 -- 571 572 573 -- -------------------------------------------------------- 574 575 -- 576 -- Table structure for table `nuke_bbextension_groups` 577 -- 578 579 CREATE TABLE `nuke_bbextension_groups` ( 580 `group_id` mediumint(8) NOT NULL auto_increment, 581 `group_name` varchar(20) NOT NULL default '', 582 `cat_id` tinyint(2) NOT NULL default '0', 583 `allow_group` tinyint(1) NOT NULL default '0', 584 `download_mode` tinyint(1) unsigned NOT NULL default '1', 585 `upload_icon` varchar(100) default '', 586 `max_filesize` int(20) NOT NULL default '0', 587 `forum_permissions` varchar(255) NOT NULL default '', 588 PRIMARY KEY (`group_id`) 589 ) TYPE=MyISAM AUTO_INCREMENT=8 ; 590 591 -- 592 -- Dumping data for table `nuke_bbextension_groups` 593 -- 594 595 INSERT INTO `nuke_bbextension_groups` VALUES (1, 'Images', 1, 1, 2, '', 262144, ''); 596 INSERT INTO `nuke_bbextension_groups` VALUES (2, 'Archives', 0, 1, 2, '', 262144, ''); 597 INSERT INTO `nuke_bbextension_groups` VALUES (3, 'Plain Text', 0, 0, 2, '', 262144, ''); 598 INSERT INTO `nuke_bbextension_groups` VALUES (4, 'Documents', 0, 0, 2, '', 262144, ''); 599 INSERT INTO `nuke_bbextension_groups` VALUES (5, 'Real Media', 0, 0, 2, '', 262144, ''); 600 INSERT INTO `nuke_bbextension_groups` VALUES (6, 'Streams', 2, 0, 2, '', 262144, ''); 601 INSERT INTO `nuke_bbextension_groups` VALUES (7, 'Flash Files', 3, 0, 2, '', 262144, ''); 602 603 -- -------------------------------------------------------- 604 605 -- 606 -- Table structure for table `nuke_bbextensions` 607 -- 608 609 CREATE TABLE `nuke_bbextensions` ( 610 `ext_id` mediumint(8) unsigned NOT NULL auto_increment, 611 `group_id` mediumint(8) unsigned NOT NULL default '0', 612 `extension` varchar(100) NOT NULL default '', 613 `comment` varchar(100) default NULL, 614 PRIMARY KEY (`ext_id`) 615 ) TYPE=MyISAM AUTO_INCREMENT=29 ; 616 617 -- 618 -- Dumping data for table `nuke_bbextensions` 619 -- 620 621 INSERT INTO `nuke_bbextensions` VALUES (1, 1, 'gif', ''); 622 INSERT INTO `nuke_bbextensions` VALUES (2, 1, 'png', ''); 623 INSERT INTO `nuke_bbextensions` VALUES (3, 1, 'jpeg', ''); 624 INSERT INTO `nuke_bbextensions` VALUES (4, 1, 'jpg', ''); 625 INSERT INTO `nuke_bbextensions` VALUES (5, 1, 'tif', ''); 626 INSERT INTO `nuke_bbextensions` VALUES (6, 1, 'tga', ''); 627 INSERT INTO `nuke_bbextensions` VALUES (7, 2, 'gtar', ''); 628 INSERT INTO `nuke_bbextensions` VALUES (8, 2, 'gz', ''); 629 INSERT INTO `nuke_bbextensions` VALUES (9, 2, 'tar', ''); 630 INSERT INTO `nuke_bbextensions` VALUES (10, 2, 'zip', ''); 631 INSERT INTO `nuke_bbextensions` VALUES (11, 2, 'rar', ''); 632 INSERT INTO `nuke_bbextensions` VALUES (12, 2, 'ace', ''); 633 INSERT INTO `nuke_bbextensions` VALUES (13, 3, 'txt', ''); 634 INSERT INTO `nuke_bbextensions` VALUES (14, 3, 'c', ''); 635 INSERT INTO `nuke_bbextensions` VALUES (15, 3, 'h', ''); 636 INSERT INTO `nuke_bbextensions` VALUES (16, 3, 'cpp', ''); 637 INSERT INTO `nuke_bbextensions` VALUES (17, 3, 'hpp', ''); 638 INSERT INTO `nuke_bbextensions` VALUES (18, 3, 'diz', ''); 639 INSERT INTO `nuke_bbextensions` VALUES (19, 4, 'xls', ''); 640 INSERT INTO `nuke_bbextensions` VALUES (20, 4, 'doc', ''); 641 INSERT INTO `nuke_bbextensions` VALUES (21, 4, 'dot', ''); 642 INSERT INTO `nuke_bbextensions` VALUES (22, 4, 'pdf', ''); 643 INSERT INTO `nuke_bbextensions` VALUES (23, 4, 'ai', ''); 644 INSERT INTO `nuke_bbextensions` VALUES (24, 4, 'ps', ''); 645 INSERT INTO `nuke_bbextensions` VALUES (25, 4, 'ppt', ''); 646 INSERT INTO `nuke_bbextensions` VALUES (26, 5, 'rm', ''); 647 INSERT INTO `nuke_bbextensions` VALUES (27, 6, 'wma', ''); 648 INSERT INTO `nuke_bbextensions` VALUES (28, 7, 'swf', ''); 649 650 -- -------------------------------------------------------- 651 652 -- 653 -- Table structure for table `nuke_bbforbidden_extensions` 654 -- 655 656 CREATE TABLE `nuke_bbforbidden_extensions` ( 657 `ext_id` mediumint(8) unsigned NOT NULL auto_increment, 658 `extension` varchar(100) NOT NULL default '', 659 PRIMARY KEY (`ext_id`) 660 ) TYPE=MyISAM AUTO_INCREMENT=11 ; 661 662 -- 663 -- Dumping data for table `nuke_bbforbidden_extensions` 664 -- 665 666 INSERT INTO `nuke_bbforbidden_extensions` VALUES (1, 'php'); 667 INSERT INTO `nuke_bbforbidden_extensions` VALUES (2, 'php3'); 668 INSERT INTO `nuke_bbforbidden_extensions` VALUES (3, 'php4'); 669 INSERT INTO `nuke_bbforbidden_extensions` VALUES (4, 'phtml'); 670 INSERT INTO `nuke_bbforbidden_extensions` VALUES (5, 'pl'); 671 INSERT INTO `nuke_bbforbidden_extensions` VALUES (6, 'asp'); 672 INSERT INTO `nuke_bbforbidden_extensions` VALUES (7, 'cgi'); 673 INSERT INTO `nuke_bbforbidden_extensions` VALUES (8, 'com'); 674 INSERT INTO `nuke_bbforbidden_extensions` VALUES (9, 'bat'); 675 INSERT INTO `nuke_bbforbidden_extensions` VALUES (10, 'scr'); 676 677 -- -------------------------------------------------------- 678 679 -- 680 -- Table structure for table `nuke_bbforum_prune` 681 -- 682 683 CREATE TABLE `nuke_bbforum_prune` ( 684 `prune_id` mediumint(8) unsigned NOT NULL auto_increment, 685 `forum_id` smallint(5) unsigned NOT NULL default '0', 686 `prune_days` tinyint(4) unsigned NOT NULL default '0', 687 `prune_freq` tinyint(4) unsigned NOT NULL default '0', 688 PRIMARY KEY (`prune_id`), 689 KEY `forum_id` (`forum_id`) 690 ) TYPE=MyISAM; 691 692 -- 693 -- Dumping data for table `nuke_bbforum_prune` 694 -- 695 696 697 -- -------------------------------------------------------- 698 699 -- 700 -- Table structure for table `nuke_bbforums` 701 -- 702 703 CREATE TABLE `nuke_bbforums` ( 704 `forum_id` smallint(5) unsigned NOT NULL auto_increment, 705 `cat_id` mediumint(8) unsigned NOT NULL default '0', 706 `forum_name` varchar(150) default NULL, 707 `forum_desc` text, 708 `forum_status` tinyint(4) NOT NULL default '0', 709 `forum_order` mediumint(8) unsigned NOT NULL default '1', 710 `forum_posts` mediumint(8) unsigned NOT NULL default '0', 711 `forum_topics` mediumint(8) unsigned NOT NULL default '0', 712 `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0', 713 `prune_next` int(11) default NULL, 714 `prune_enable` tinyint(1) NOT NULL default '1', 715 `auth_view` tinyint(2) NOT NULL default '0', 716 `auth_read` tinyint(2) NOT NULL default '0', 717 `auth_post` tinyint(2) NOT NULL default '0', 718 `auth_reply` tinyint(2) NOT NULL default '0', 719 `auth_edit` tinyint(2) NOT NULL default '0', 720 `auth_delete` tinyint(2) NOT NULL default '0', 721 `auth_sticky` tinyint(2) NOT NULL default '0', 722 `auth_announce` tinyint(2) NOT NULL default '0', 723 `auth_globalannounce` tinyint(2) NOT NULL default '3', 724 `auth_vote` tinyint(2) NOT NULL default '0', 725 `auth_pollcreate` tinyint(2) NOT NULL default '0', 726 `auth_attachments` tinyint(2) NOT NULL default '0', 727 `forum_display_sort` tinyint(1) NOT NULL default '0', 728 `forum_display_order` tinyint(1) NOT NULL default '0', 729 `auth_download` tinyint(2) NOT NULL default '0', 730 PRIMARY KEY (`forum_id`), 731 KEY `forums_order` (`forum_order`), 732 KEY `cat_id` (`cat_id`), 733 KEY `forum_last_post_id` (`forum_last_post_id`) 734 ) TYPE=MyISAM AUTO_INCREMENT=2 ; 735 736 -- 737 -- Dumping data for table `nuke_bbforums` 738 -- 739 740 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); 741 742 -- -------------------------------------------------------- 743 744 -- 745 -- Table structure for table `nuke_bbgroups` 746 -- 747 748 CREATE TABLE `nuke_bbgroups` ( 749 `group_id` mediumint(8) NOT NULL auto_increment, 750 `group_type` tinyint(4) NOT NULL default '1', 751 `group_name` varchar(40) NOT NULL default '', 752 `group_description` varchar(255) NOT NULL default '', 753 `group_moderator` mediumint(8) NOT NULL default '0', 754 `group_single_user` tinyint(1) NOT NULL default '1', 755 `group_allow_pm` tinyint(2) NOT NULL default '5', 756 `group_color` varchar(15) NOT NULL default '', 757 `group_rank` varchar(5) NOT NULL default '0', 758 `max_inbox` mediumint( 10 ) NOT NULL default '100', 759 `max_sentbox` mediumint( 10 ) NOT NULL default '100', 760 `max_savebox` mediumint( 10 ) NOT NULL default '100', 761 `override_max_inbox` tinyint( 1 ) NOT NULL default '0', 762 `override_max_sentbox` tinyint( 1 ) NOT NULL default '0', 763 `override_max_savebox` tinyint( 1 ) NOT NULL default '0', 764 `group_count` INT (4) UNSIGNED DEFAULT '99999999', 765 `group_count_max` INT (4) UNSIGNED DEFAULT '99999999', 766 `group_count_enable` SMALLINT (2) UNSIGNED DEFAULT '0', 767 PRIMARY KEY (`group_id`), 768 KEY `group_single_user` (`group_single_user`) 769 ) TYPE=MyISAM AUTO_INCREMENT=6 ; 770 771 -- 772 -- Dumping data for table `nuke_bbgroups` 773 -- 774 775 INSERT INTO `nuke_bbgroups` VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1, 0, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0'); 776 INSERT INTO `nuke_bbgroups` VALUES (3, 2, 'Moderators', 'Moderators of this Forum', 2, 0, 5, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0'); 777 INSERT INTO `nuke_bbgroups` VALUES (5, 0, 'Users', 'Default Usergroup', 2, 0, 5, '', '', 0, 0, 0, 0, 0, 0,'99999999','99999999','0'); 778 779 -- -------------------------------------------------------- 780 781 -- 782 -- Table structure for table `nuke_bblogs` 783 -- 784 785 CREATE TABLE `nuke_bblogs` ( 786 `log_id` mediumint(10) NOT NULL auto_increment, 787 `mode` varchar(50) default '', 788 `topic_id` mediumint(10) default '0', 789 `user_id` mediumint(8) default '0', 790 `username` varchar(255) default '', 791 `user_ip` varchar(8) NOT NULL default '0', 792 `time` int(11) default '0', 793 `new_topic_id` mediumint(10) NOT NULL default '0', 794 `forum_id` mediumint(10) NOT NULL default '0', 795 `new_forum_id` mediumint(10) NOT NULL default '0', 796 `last_post_id` mediumint(10) NOT NULL default '0', 797 PRIMARY KEY (`log_id`) 798 ) TYPE=MyISAM; 799 800 -- 801 -- Dumping data for table `nuke_bblogs` 802 -- 803 804 805 -- -------------------------------------------------------- 806 807 -- 808 -- Table structure for table `nuke_bblogs_config` 809 -- 810 811 CREATE TABLE `nuke_bblogs_config` ( 812 `config_name` varchar(255) NOT NULL default '', 813 `config_value` varchar(255) NOT NULL default '', 814 PRIMARY KEY (`config_name`) 815 ) TYPE=MyISAM; 816 817 -- 818 -- Dumping data for table `nuke_bblogs_config` 819 -- 820 821 INSERT INTO `nuke_bblogs_config` VALUES ('all_admin', '0'); 822 823 -- -------------------------------------------------------- 824 825 -- 826 -- Table structure for table `nuke_bbpost_reports` 827 -- 828 829 CREATE TABLE `nuke_bbpost_reports` ( 830 `report_id` mediumint(8) NOT NULL auto_increment, 831 `post_id` mediumint(8) NOT NULL default '0', 832 `reporter_id` mediumint(8) NOT NULL default '0', 833 `report_status` tinyint(1) NOT NULL default '0', 834 `report_time` int(11) NOT NULL default '0', 835 `report_comments` text, 836 `last_action_user_id` mediumint(8) default '0', 837 `last_action_time` int(11) NOT NULL default '0', 838 `last_action_comments` text, 839 PRIMARY KEY (`report_id`) 840 ); 841 842 -- 843 -- Dumping data for table `nuke_bbpost_reports` 844 -- 845 846 847 -- -------------------------------------------------------- 848 849 -- 850 -- Table structure for table `nuke_bbposts` 851 -- 852 853 CREATE TABLE `nuke_bbposts` ( 854 `post_id` mediumint(8) unsigned NOT NULL auto_increment, 855 `topic_id` mediumint(8) unsigned NOT NULL default '0', 856 `forum_id` smallint(5) unsigned NOT NULL default '0', 857 `poster_id` mediumint(8) NOT NULL default '0', 858 `post_time` int(11) NOT NULL default '0', 859 `poster_ip` varchar(8) NOT NULL default '', 860 `post_username` varchar(25) default NULL, 861 `enable_bbcode` tinyint(1) NOT NULL default '1', 862 `enable_html` tinyint(1) NOT NULL default '0', 863 `enable_smilies` tinyint(1) NOT NULL default '1', 864 `enable_sig` tinyint(1) NOT NULL default '1', 865 `post_edit_time` int(11) default NULL, 866 `post_edit_count` smallint(5) unsigned NOT NULL default '0', 867 `post_attachment` tinyint(1) NOT NULL default '0', 868 `post_move` tinyint(1) NOT NULL default '0', 869 PRIMARY KEY (`post_id`), 870 KEY `forum_id` (`forum_id`), 871 KEY `topic_id` (`topic_id`), 872 KEY `poster_id` (`poster_id`), 873 KEY `post_time` (`post_time`) 874 ) TYPE=MyISAM AUTO_INCREMENT=2 ; 875 876 -- 877 -- Dumping data for table `nuke_bbposts` 878 -- 879 880 INSERT INTO `nuke_bbposts` VALUES (1, 1, 1, 2, 1125187439, '7f000001', '', 1, 1, 1, 0, NULL, 0, 0, 0); 881 882 -- -------------------------------------------------------- 883 884 -- 885 -- Table structure for table `nuke_bbposts_text` 886 -- 887 888 CREATE TABLE `nuke_bbposts_text` ( 889 `post_id` mediumint(8) unsigned NOT NULL default '0', 890 `bbcode_uid` varchar(10) NOT NULL default '', 891 `post_subject` varchar(60) default NULL, 892 `post_text` text, 893 PRIMARY KEY (`post_id`) 894 ) TYPE=MyISAM; 895 896 -- 897 -- Dumping data for table `nuke_bbposts_text` 898 -- 899 900 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]'); 901 902 -- -------------------------------------------------------- 903 904 -- 905 -- Table structure for table `nuke_bbprivmsgs` 906 -- 907 908 CREATE TABLE `nuke_bbprivmsgs` ( 909 `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, 910 `privmsgs_type` tinyint(4) NOT NULL default '0', 911 `privmsgs_subject` varchar(255) NOT NULL default '0', 912 `privmsgs_from_userid` mediumint(8) NOT NULL default '0', 913 `privmsgs_to_userid` mediumint(8) NOT NULL default '0', 914 `privmsgs_date` int(11) NOT NULL default '0', 915 `privmsgs_ip` varchar(8) NOT NULL default '', 916 `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', 917 `privmsgs_enable_html` tinyint(1) NOT NULL default '0', 918 `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', 919 `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', 920 `privmsgs_attachment` tinyint(1) NOT NULL default '0', 921 PRIMARY KEY (`privmsgs_id`), 922 KEY `privmsgs_from_userid` (`privmsgs_from_userid`), 923 KEY `privmsgs_to_userid` (`privmsgs_to_userid`) 924 ) TYPE=MyISAM; 925 926 -- 927 -- Dumping data for table `nuke_bbprivmsgs` 928 -- 929 930 931 -- -------------------------------------------------------- 932 933 -- 934 -- Table structure for table `nuke_bbprivmsgs_archive` 935 -- 936 937 CREATE TABLE `nuke_bbprivmsgs_archive` ( 938 `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, 939 `privmsgs_type` tinyint(4) NOT NULL default '0', 940 `privmsgs_subject` varchar(255) NOT NULL default '0', 941 `privmsgs_from_userid` mediumint(8) NOT NULL default '0', 942 `privmsgs_to_userid` mediumint(8) NOT NULL default '0', 943 `privmsgs_date` int(11) NOT NULL default '0', 944 `privmsgs_ip` varchar(8) NOT NULL default '', 945 `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', 946 `privmsgs_enable_html` tinyint(1) NOT NULL default '0', 947 `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', 948 `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', 949 PRIMARY KEY (`privmsgs_id`), 950 KEY `privmsgs_from_userid` (`privmsgs_from_userid`), 951 KEY `privmsgs_to_userid` (`privmsgs_to_userid`) 952 ) TYPE=MyISAM; 953 954 -- 955 -- Dumping data for table `nuke_bbprivmsgs_archive` 956 -- 957 958 959 -- -------------------------------------------------------- 960 961 -- 962 -- Table structure for table `nuke_bbprivmsgs_text` 963 -- 964 965 CREATE TABLE `nuke_bbprivmsgs_text` ( 966 `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0', 967 `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0', 968 `privmsgs_text` text, 969 PRIMARY KEY (`privmsgs_text_id`) 970 ) TYPE=MyISAM; 971 972 -- 973 -- Dumping data for table `nuke_bbprivmsgs_text` 974 -- 975 976 977 -- -------------------------------------------------------- 978 979 -- 980 -- Table structure for table `nuke_bbquicksearch` 981 -- 982 983 CREATE TABLE `nuke_bbquicksearch` ( 984 `search_id` mediumint(8) unsigned NOT NULL auto_increment, 985 `search_name` varchar(255) NOT NULL default '', 986 `search_url1` varchar(255) NOT NULL default '', 987 `search_url2` varchar(255) NOT NULL default '', 988 PRIMARY KEY (`search_id`) 989 ) TYPE=MyISAM AUTO_INCREMENT=2 ; 990 991 -- 992 -- Dumping data for table `nuke_bbquicksearch` 993 -- 994 995 INSERT INTO `nuke_bbquicksearch` VALUES (1, 'Google', 'http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=', ''); 996 997 -- -------------------------------------------------------- 998 999 -- 1000 -- Table structure for table `nuke_bbquota_limits` 1001 -- 1002 1003 CREATE TABLE `nuke_bbquota_limits` ( 1004 `quota_limit_id` mediumint(8) unsigned NOT NULL auto_increment, 1005 `quota_desc` varchar(20) NOT NULL default '', 1006 `quota_limit` bigint(20) unsigned NOT NULL default '0', 1007 PRIMARY KEY (`quota_limit_id`) 1008 ) TYPE=MyISAM; 1009 1010 -- 1011 -- Dumping data for table `nuke_bbquota_limits` 1012 -- 1013 1014 INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144); 1015 INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152); 1016 INSERT INTO `nuke_bbquota_limits` (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880); 1017 1018 1019 -- -------------------------------------------------------- 1020 1021 -- 1022 -- Table structure for table `nuke_bbranks` 1023 -- 1024 1025 CREATE TABLE `nuke_bbranks` ( 1026 `rank_id` smallint(5) unsigned NOT NULL auto_increment, 1027 `rank_title` varchar(100) NOT NULL default '', 1028 `rank_min` mediumint(8) NOT NULL default '0', 1029 `rank_special` tinyint(1) default '0', 1030 `rank_image` varchar(255) default NULL, 1031 PRIMARY KEY (`rank_id`) 1032 ) TYPE=MyISAM AUTO_INCREMENT=3 ; 1033 1034 -- 1035 -- Dumping data for table `nuke_bbranks` 1036 -- 1037 1038 INSERT INTO `nuke_bbranks` VALUES (1, 'Site Owner', -1, 1, 'modules/Forums/images/ranks/site_owner.gif'); 1039 INSERT INTO `nuke_bbranks` VALUES (2, 'Site Admin', -1, 1, 'modules/Forums/images/ranks/admin.gif'); 1040 1041 -- -------------------------------------------------------- 1042 1043 -- 1044 -- Table structure for table `nuke_bbsearch_results` 1045 -- 1046 1047 CREATE TABLE `nuke_bbsearch_results` ( 1048 `search_id` int(11) unsigned NOT NULL default '0', 1049 `session_id` varchar(32) NOT NULL default '', 1050 `search_array` text NOT NULL, 1051 `search_time` int(11) DEFAULT '0' NOT NULL, 1052 PRIMARY KEY (`search_id`), 1053 KEY `session_id` (`session_id`) 1054 ) TYPE=MyISAM; 1055 1056 -- 1057 -- Dumping data for table `nuke_bbsearch_results` 1058 -- 1059 1060 1061 -- -------------------------------------------------------- 1062 1063 -- 1064 -- Table structure for table `nuke_bbsearch_wordlist` 1065 -- 1066 1067 CREATE TABLE `nuke_bbsearch_wordlist` ( 1068 `word_text` varchar(255) binary NOT NULL DEFAULT '', 1069 `word_id` mediumint(8) unsigned NOT NULL auto_increment, 1070 `word_common` mediumint(8) unsigned DEFAULT '0' NOT NULL, 1071 `post_id` mediumint(8) unsigned DEFAULT '0' NOT NULL, 1072 PRIMARY KEY (`word_text`), 1073 KEY `word_id` (`word_id`) 1074 ); 1075 1076 -- 1077 -- Dumping data for table `nuke_bbsearch_wordlist` 1078 -- 1079 1080 1081 -- -------------------------------------------------------- 1082 1083 -- 1084 -- Table structure for table `nuke_bbsearch_wordmatch` 1085 -- 1086 1087 CREATE TABLE `nuke_bbsearch_wordmatch` ( 1088 `post_id` mediumint(8) unsigned NOT NULL default '0', 1089 `word_id` mediumint(8) unsigned NOT NULL default '0', 1090 `title_match` tinyint(1) NOT NULL default '0', 1091 INDEX `post_id` (`post_id`), 1092 KEY `word_id` (`word_id`) 1093 ) TYPE=MyISAM; 1094 1095 -- 1096 -- Dumping data for table `nuke_bbsearch_wordmatch` 1097 -- 1098 1099 1100 -- -------------------------------------------------------- 1101 1102 -- 1103 -- Table structure for table `nuke_bbsessions` 1104 -- 1105 1106 CREATE TABLE `nuke_bbsessions` ( 1107 `session_id` varchar(32) NOT NULL default '', 1108 `session_user_id` mediumint(8) NOT NULL default '0', 1109 `session_start` int(11) NOT NULL default '0', 1110 `session_time` int(11) NOT NULL default '0', 1111 `session_ip` varchar(8) NOT NULL default '0', 1112 `session_page` int(11) NOT NULL default '0', 1113 `session_logged_in` tinyint(1) NOT NULL default '0', 1114 `session_admin` tinyint(2) NOT NULL default '0', 1115 `session_url_qs` text NOT NULL, 1116 `session_url_ps` text NOT NULL, 1117 `session_url_specific` int(10) NOT NULL default '0', 1118 PRIMARY KEY (`session_id`), 1119 KEY `session_user_id` (`session_user_id`), 1120 KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`) 1121 ) TYPE=MyISAM; 1122 1123 -- 1124 -- Dumping data for table `nuke_bbsessions` 1125 -- 1126 1127 -- -------------------------------------------------------- 1128 1129 -- 1130 -- Table structure for table `nuke_bbsessions_keys` 1131 -- 1132 1133 CREATE TABLE `nuke_bbsessions_keys` ( 1134 `key_id` varchar(32) DEFAULT '0' NOT NULL, 1135 `user_id` mediumint(8) DEFAULT '0' NOT NULL, 1136 `last_ip` varchar(8) DEFAULT '0' NOT NULL, 1137 `last_login` int(11) DEFAULT '0' NOT NULL, 1138 PRIMARY KEY (key_id, user_id), 1139 KEY last_login (last_login) 1140 ); 1141 1142 1143 -- 1144 -- Dumping data for table `nuke_bbsessions_keys` 1145 -- 1146 1147 1148 -- -------------------------------------------------------- 1149 1150 -- 1151 -- Table structure for table `nuke_bbsmilies` 1152 -- 1153 1154 CREATE TABLE `nuke_bbsmilies` ( 1155 `smilies_id` smallint(5) unsigned NOT NULL auto_increment, 1156 `code` varchar(50) default NULL, 1157 `smile_url` varchar(100) default NULL, 1158 `emoticon` varchar(75) default NULL, 1159 `smile_stat` mediumint(8) unsigned NOT NULL default '0', 1160 PRIMARY KEY (`smilies_id`) 1161 ) TYPE=MyISAM AUTO_INCREMENT=45 ; 1162 1163 -- 1164 -- Dumping data for table `nuke_bbsmilies` 1165 -- 1166 1167 INSERT INTO `nuke_bbsmilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy', 0); 1168 INSERT INTO `nuke_bbsmilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy', 0); 1169 INSERT INTO `nuke_bbsmilies` VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy', 0); 1170 INSERT INTO `nuke_bbsmilies` VALUES (4, ':)', 'icon_smile.gif', 'Smile', 0); 1171 INSERT INTO `nuke_bbsmilies` VALUES (5, ':-)', 'icon_smile.gif', 'Smile', 0); 1172 INSERT INTO `nuke_bbsmilies` VALUES (6, ':smile:', 'icon_smile.gif', 'Smile', 0); 1173 INSERT INTO `nuke_bbsmilies` VALUES (7, ':(', 'icon_sad.gif', 'Sad', 0); 1174 INSERT INTO `nuke_bbsmilies` VALUES (8, ':-(', 'icon_sad.gif', 'Sad', 0); 1175 INSERT INTO `nuke_bbsmilies` VALUES (9, ':sad:', 'icon_sad.gif', 'Sad', 0); 1176 INSERT INTO `nuke_bbsmilies` VALUES (10, ':o', 'icon_surprised.gif', 'Surprised', 0); 1177 INSERT INTO `nuke_bbsmilies` VALUES (11, ':-o', 'icon_surprised.gif', 'Surprised', 0); 1178 INSERT INTO `nuke_bbsmilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised', 0); 1179 INSERT INTO `nuke_bbsmilies` VALUES (13, '8O', 'icon_eek.gif', 'Shocked', 0); 1180 INSERT INTO `nuke_bbsmilies` VALUES (14, '8-O', 'icon_eek.gif', 'Shocked', 0); 1181 INSERT INTO `nuke_bbsmilies` VALUES (15, ':shock:', 'icon_eek.gif', 'Shocked', 0); 1182 INSERT INTO `nuke_bbsmilies` VALUES (16, ':?', 'icon_confused.gif', 'Confused', 0); 1183 INSERT INTO `nuke_bbsmilies` VALUES (17, ':-?', 'icon_confused.gif', 'Confused', 0); 1184 INSERT INTO `nuke_bbsmilies` VALUES (18, ':???:', 'icon_confused.gif', 'Confused', 0); 1185 INSERT INTO `nuke_bbsmilies` VALUES (19, '8)', 'icon_cool.gif', 'Cool', 0); 1186 INSERT INTO `nuke_bbsmilies` VALUES (20, '8-)', 'icon_cool.gif', 'Cool', 0); 1187 INSERT INTO `nuke_bbsmilies` VALUES (21, ':cool:', 'icon_cool.gif', 'Cool', 0); 1188 INSERT INTO `nuke_bbsmilies` VALUES (22, ':lol:', 'icon_lol.gif', 'Laughing', 0); 1189 INSERT INTO `nuke_bbsmilies` VALUES (23, ':x', 'icon_mad.gif', 'Mad', 0); 1190 INSERT INTO `nuke_bbsmilies` VALUES (24, ':-x', 'icon_mad.gif', 'Mad', 0); 1191