-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2010 at 01:28 PM -- Server version: 5.1.40 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `bmcforu_transfer` -- -- -------------------------------------------------------- -- -- Table structure for table `adv_setting` -- CREATE TABLE IF NOT EXISTS `adv_setting` ( `varname` varchar(100) NOT NULL DEFAULT '', `grouptitle` varchar(50) NOT NULL DEFAULT '', `value` mediumtext NOT NULL, `defaultvalue` varchar(250) NOT NULL DEFAULT '', `optioncode` mediumtext NOT NULL, `displayorder` smallint(3) unsigned NOT NULL DEFAULT '0', `serialize` smallint(3) unsigned NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `adv_setting` -- INSERT INTO `adv_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `serialize`) VALUES ('global_navbar_replace', 'adv_global', 'memberlist.php\r\nusercp.php\r\nregister.php\r\nfaq.php\r\ncalendar.php\r\nsearch.php\r\nlogin.php\r\nforumdisplay.php\r\nprofile.php\r\nprivate.php\r\nsubscription.php\r\nmember.php\r\nonline.php', '', 'textarea', 2, 0), ('global_footer_replace', 'adv_global', 'archive\r\nsendmessage.php\r\nprofile.php', '', 'textarea', 3, 0), ('global_header_replace', 'adv_global', '', '', 'textarea', 1, 0), ('portal_calendarid', 'adv_portal_calendar', '-1', '', 'calendarselect', 10, 0), ('portal_threadids', 'adv_portal_latestthreads', '', '', 'threadselect', 10, 1), ('portal_threads_forumids', 'adv_portal_latestthreads', 'a:146:{i:0;s:2:"44";i:1;s:3:"148";i:2;s:2:"54";i:3;s:3:"106";i:4;s:3:"152";i:5;s:2:"69";i:6;s:2:"19";i:7;s:2:"80";i:8;s:3:"161";i:9;s:3:"265";i:10;s:3:"278";i:11;s:1:"5";i:12;s:3:"122";i:13;s:3:"205";i:14;s:3:"138";i:15;s:3:"272";i:16;s:3:"206";i:17;s:3:"155";i:18;s:3:"220";i:19;s:3:"140";i:20;s:3:"166";i:21;s:3:"196";i:22;s:3:"195";i:23;s:3:"194";i:24;s:2:"11";i:25;s:3:"190";i:26;s:3:"189";i:27;s:3:"188";i:28;s:3:"208";i:29;s:3:"209";i:30;s:3:"210";i:31;s:3:"211";i:32;s:2:"10";i:33;s:3:"176";i:34;s:3:"178";i:35;s:3:"177";i:36;s:3:"168";i:37;s:3:"108";i:38;s:2:"20";i:39;s:2:"13";i:40;s:3:"184";i:41;s:3:"183";i:42;s:3:"182";i:43;s:2:"14";i:44;s:3:"179";i:45;s:3:"180";i:46;s:3:"181";i:47;s:2:"12";i:48;s:3:"191";i:49;s:3:"192";i:50;s:3:"193";i:51;s:3:"212";i:52;s:3:"139";i:53;s:2:"15";i:54;s:3:"197";i:55;s:3:"198";i:56;s:3:"199";i:57;s:2:"16";i:58;s:3:"202";i:59;s:3:"201";i:60;s:3:"200";i:61;s:3:"274";i:62;s:3:"167";i:63;s:3:"273";i:64;s:3:"267";i:65;s:3:"275";i:66;s:3:"269";i:67;s:3:"263";i:68;s:3:"258";i:69;s:3:"276";i:70;s:3:"217";i:71;s:3:"271";i:72;s:3:"203";i:73;s:2:"37";i:74;s:3:"213";i:75;s:3:"214";i:76;s:2:"43";i:77;s:3:"215";i:78;s:2:"22";i:79;s:3:"133";i:80;s:1:"8";i:81;s:3:"218";i:82;s:3:"250";i:83;s:3:"242";i:84;s:3:"243";i:85;s:3:"244";i:86;s:3:"245";i:87;s:3:"246";i:88;s:3:"174";i:89;s:3:"225";i:90;s:3:"247";i:91;s:3:"163";i:92;s:3:"248";i:93;s:3:"224";i:94;s:3:"251";i:95;s:3:"237";i:96;s:3:"238";i:97;s:3:"239";i:98;s:3:"240";i:99;s:3:"241";i:100;s:2:"57";i:101;s:2:"95";i:102;s:2:"58";i:103;s:3:"255";i:104;s:3:"256";i:105;s:3:"257";i:106;s:2:"55";i:107;s:3:"113";i:108;s:3:"252";i:109;s:3:"235";i:110;s:3:"231";i:111;s:3:"232";i:112;s:3:"234";i:113;s:3:"233";i:114;s:2:"64";i:115;s:2:"60";i:116;s:3:"249";i:117;s:2:"94";i:118;s:3:"142";i:119;s:2:"75";i:120;s:3:"254";i:121;s:2:"76";i:122;s:3:"141";i:123;s:1:"6";i:124;s:2:"79";i:125;s:2:"99";i:126;s:3:"143";i:127;s:2:"29";i:128;s:3:"105";i:129;s:2:"28";i:130;s:2:"23";i:131;s:2:"24";i:132;s:3:"268";i:133;s:2:"25";i:134;s:2:"86";i:135;s:3:"157";i:136;s:3:"204";i:137;s:3:"116";i:138;s:3:"151";i:139;s:3:"117";i:140;s:3:"134";i:141;s:2:"74";i:142;s:3:"125";i:143;s:2:"92";i:144;s:3:"207";i:145;s:1:"9";}', '', 'forumselect', 20, 1), ('portal_threads_maxthreads', 'adv_portal_latestthreads', '5', '', '', 30, 0), ('portal_threads_maxchars', 'adv_portal_latestthreads', '200', '', '', 50, 0), ('portal_threads_maxwordchars', 'adv_portal_latestthreads', '15', '', '', 60, 0), ('portal_threads_orderby', 'adv_portal_latestthreads', 'lastpost', '', '', 70, 0), ('portal_threads_direction', 'adv_portal_latestthreads', 'DESC', '', '', 80, 0), ('portal_applypermissions', 'adv_portal_latestthreads', '1', '', 'yesno', 100, 0), ('portal_threads_showdate', 'adv_portal_latestthreads', '1', '', 'yesno', 120, 0), ('portal_threads_lastpost', 'adv_portal_latestthreads', '1', '', 'yesno', 150, 0), ('portal_threads_showforum', 'adv_portal_latestthreads', '0', '', 'yesno', 160, 0), ('portal_threads_showpreview', 'adv_portal_latestthreads', '1', '', 'yesno', 170, 0), ('portal_threads_showicon', 'adv_portal_latestthreads', '0', '', 'yesno', 180, 0), ('portal_threads_showsubscribed', 'adv_portal_latestthreads', '0', '', 'yesno', 190, 0), ('portal_threads_showrating', 'adv_portal_latestthreads', '0', '', 'yesno', 200, 0), ('portal_version', 'adv_portal_main', '3.0.0', '', 'hidden', 0, 0), ('portal_homeurl', 'adv_portal_main', '/cmps_index.php', '', '', 10, 0), ('portal_pagevar', 'adv_portal_main', 'page', '', '', 20, 0), ('portal_outputglobals', 'adv_portal_main', '', '', 'textarea', 40, 0), ('portal_replaceadmin', 'adv_portal_main', '0', '', 'yesno', 50, 0), ('portal_navigation_excludepages', 'adv_portal_navigation', '', '', 'pageselect', 10, 1), ('portal_navigation_mark1', 'adv_portal_navigation', '»', '', '', 20, 0), ('portal_navigation_mark2', 'adv_portal_navigation', '>', '', '', 30, 0), ('portal_navigation_addpages', 'adv_portal_navigation', 'a:6:{i:0;a:4:{s:5:"order";s:1:"1";s:5:"level";s:0:"";s:4:"link";s:34:"http://www.bmcforums.com/index.php";s:4:"text";s:6:"Forums";}i:1;a:4:{s:5:"order";s:1:"2";s:5:"level";s:0:"";s:4:"link";s:45:"http://www.bmcforums.com/forumdisplay.php?f=4";s:4:"text";s:6:"Events";}i:2;a:4:{s:5:"order";s:1:"3";s:5:"level";s:0:"";s:4:"link";s:44:"http://www.bmcforums.com/photopost/index.php";s:4:"text";s:7:"Gallery";}i:3;a:4:{s:5:"order";s:1:"4";s:5:"level";s:0:"";s:4:"link";s:73:"http://www.bmcperformance.com/store/index.php?main_page=index&cPath=32_17";s:4:"text";s:20:"Preferred Membership";}i:4;a:4:{s:5:"order";s:1:"5";s:5:"level";s:0:"";s:4:"link";s:70:"http://www.bmcperformance.com/store/index.php?main_page=index&cPath=32";s:4:"text";s:4:"Gear";}i:5;a:4:{s:5:"order";s:1:"6";s:5:"level";s:0:"";s:4:"link";s:37:"http://www.blackmustangclub.com/email";s:4:"text";s:21:"Email (Platinum Only)";}}', '', 'pageselect_add', 40, 1), ('portal_threadids', 'adv_portal_news', '', '', 'threadselect', 10, 1), ('portal_news_forumid', 'adv_portal_news', 'a:6:{i:0;s:2:"44";i:1;s:3:"148";i:2;s:2:"54";i:3;s:3:"106";i:4;s:3:"152";i:5;s:2:"69";}', '', 'forumselect', 20, 1), ('portal_news_maxposts', 'adv_portal_news', '5', '', '', 30, 0), ('portal_news_maxchars', 'adv_portal_news', '200', '', '', 60, 0), ('portal_news_dateformat', 'adv_portal_news', 'M d, Y - g:i A', '', '', 70, 0), ('portal_news_orderby', 'adv_portal_news', 'postdateline', '', '', 80, 0), ('portal_news_direction', 'adv_portal_news', 'DESC', '', '', 90, 0), ('portal_applypermissions', 'adv_portal_news', '1', '', 'yesno', 110, 0), ('portal_news_showattachments', 'adv_portal_news', '2', '', '
\n
\n
\n \n
', 100, 0), ('portal_news_allowreplies', 'adv_portal_news', '1', '', 'yesno', 120, 0), ('portal_news_showavatar', 'adv_portal_news', '0', '', 'yesno', 140, 0), ('portal_news_showicon', 'adv_portal_news', '0', '', 'yesno', 150, 0), ('portal_news_showrating', 'adv_portal_news', '0', '', 'yesno', 160, 0), ('portal_news_showsubscribed', 'adv_portal_news', '0', '', 'yesno', 170, 0), ('portal_news_showprintable', 'adv_portal_news', '0', '', 'yesno', 180, 0), ('portal_news_showsendfriend', 'adv_portal_news', '1', '', 'yesno', 190, 0), ('portal_news_showsignature', 'adv_portal_news', '0', '', 'yesno', 200, 0), ('portal_news_sticky', 'adv_portal_news', '0', '', 'yesno', 210, 0), ('portal_news_legacy', 'adv_portal_news', '1', '', 'yesno', 220, 0), ('portal_news_enablehtml', 'adv_portal_news', '0', '', 'yesno', 270, 0), ('portal_news_enablevbcode', 'adv_portal_news', '1', '', 'yesno', 280, 0), ('portal_news_enablevbimage', 'adv_portal_news', '1', '', 'yesno', 290, 0), ('portal_news_enablesmilies', 'adv_portal_news', '1', '', 'yesno', 300, 0), ('portal_news_enablearchive', 'adv_portal_newsarchive', '5', '', '', 10, 0), ('portal_news_archivepreview', 'adv_portal_newsarchive', '1', '', 'yesno', 40, 0), ('portal_newsarchive_lastpost', 'adv_portal_newsarchive', '1', '', 'yesno', 90, 0), ('portal_newsarchive_showforum', 'adv_portal_newsarchive', '0', '', 'yesno', 100, 0), ('portal_threadids', 'adv_portal_poll', '', '', 'threadselect', 10, 1), ('portal_poll_forumid', 'adv_portal_poll', '', '', 'forumselect', 20, 1), ('portal_applypermissions', 'adv_portal_poll', '1', '', 'yesno', 60, 0), ('portal_poll_allowreplies', 'adv_portal_poll', '1', '', 'yesno', 70, 0), ('portal_poll_allowsmilies', 'adv_portal_poll', '1', '', 'yesno', 80, 0), ('portal_poll_orderby', 'adv_portal_poll', 'dateline', '', '', 40, 0), ('portal_poll_direction', 'adv_portal_poll', 'DESC', '', '', 50, 0), ('portal_leftcolwidth', 'adv_portal_style', '175', '', '', 10, 0), ('portal_rightcolwidth', 'adv_portal_style', '175', '', '', 20, 0), ('portal_colspacing', 'adv_portal_style', '15', '', '', 30, 0), ('portal_vspace', 'adv_portal_style', '15', '', '', 40, 0), ('portal_blockbullet', 'adv_portal_style', '»', '', '', 50, 0), ('portal_shownavbar', 'adv_portal_style', '1', '', 'yesno', 60, 0), ('portal_collapsemods', 'adv_portal_style', '1', '', 'yesno', 70, 0), ('portal_welcome_lastvisit_date', 'adv_portal_welcomeblock', 'm-d-y', '', '', 10, 0), ('portal_welcome_lastvisit_time', 'adv_portal_welcomeblock', 'g:i a', '', '', 20, 0), ('portal_welcome_newpms', 'adv_portal_welcomeblock', '1', '', 'yesno', 50, 0), ('portal_welcome_avatar', 'adv_portal_welcomeblock', '1', '', 'yesno', 60, 0), ('portal_welcome_newposts', 'adv_portal_welcomeblock', '1', '', 'yesno', 70, 0), ('portal_welcome_rep', 'adv_portal_welcomeblock', '0', '', 'yesno', 80, 0), ('portal_welcome_rank', 'adv_portal_welcomeblock', '0', '', 'yesno', 90, 0), ('portal_threads_cutoffdate', 'adv_portal_latestthreads', '0', '', '', 40, 0), ('portal_news_cutoffdate', 'adv_portal_news', '0', '', '', 50, 0), ('portal_news_postcache', 'adv_portal_news', '1', '', 'yesno', 260, 0), ('portal_poll_cutoffdate', 'adv_portal_poll', '0', '', '', 30, 0), ('portal_stats_updatefrequency', 'adv_portal_stats', '24', '', '', 10, 0), ('portal_calendar_birthdays', 'adv_portal_calendar', '1', '', 'yesno', 20, 0), ('portal_calendar_cache', 'adv_portal_calendar', '12', '', '', 30, 0), ('portal_threads_expanded', 'adv_portal_latestthreads', '2', '', '
\n
\n
\n \n
', 90, 0), ('portal_threads_threadstarter', 'adv_portal_latestthreads', '1', '', 'yesno', 110, 0), ('portal_threads_views', 'adv_portal_latestthreads', '1', '', 'yesno', 130, 0), ('portal_threads_replies', 'adv_portal_latestthreads', '1', '', 'yesno', 140, 0), ('portal_threads_stickyicon', 'adv_portal_latestthreads', '0', '', 'yesno', 210, 0), ('portal_threads_multipage', 'adv_portal_latestthreads', '0', '', 'yesno', 220, 0), ('portal_threads_showpaperclip', 'adv_portal_latestthreads', '0', '', 'yesno', 230, 0), ('portal_threads_newpostarrow', 'adv_portal_latestthreads', '0', '', 'yesno', 240, 0), ('portal_threads_prefix', 'adv_portal_latestthreads', '0', '', 'yesno', 250, 0), ('portal_news_threadsperpage', 'adv_portal_news', '0', '', '', 40, 0), ('portal_news_showviews', 'adv_portal_news', '1', '', 'yesno', 130, 0), ('portal_news_attachpaperclip', 'adv_portal_news', '0', '', 'yesno', 230, 0), ('portal_news_bbcode_attach', 'adv_portal_news', '1', '', 'yesno', 240, 0), ('portal_news_prefix', 'adv_portal_news', '0', '', 'yesno', 250, 0), ('portal_archive_maxchars', 'adv_portal_newsarchive', '200', '', '', 20, 0), ('portal_archive_expanded', 'adv_portal_newsarchive', '2', '', '
\n
\n
\n \n
', 30, 0), ('portal_archive_threadstarter', 'adv_portal_newsarchive', '1', '', 'yesno', 50, 0), ('portal_archive_showdate', 'adv_portal_newsarchive', '1', '', 'yesno', 60, 0), ('portal_archive_showviews', 'adv_portal_newsarchive', '1', '', 'yesno', 70, 0), ('portal_archive_showreplies', 'adv_portal_newsarchive', '1', '', 'yesno', 80, 0), ('portal_archive_showrating', 'adv_portal_newsarchive', '0', '', 'yesno', 110, 0), ('portal_archive_showicon', 'adv_portal_newsarchive', '0', '', 'yesno', 120, 0), ('portal_archive_showsubscribed', 'adv_portal_newsarchive', '0', '', 'yesno', 130, 0), ('portal_archive_stickyicon', 'adv_portal_newsarchive', '0', '', 'yesno', 140, 0), ('portal_archive_multipage', 'adv_portal_newsarchive', '0', '', 'yesno', 150, 0), ('portal_archive_attachpaperclip', 'adv_portal_newsarchive', '0', '', 'yesno', 160, 0), ('portal_stats_topposter_posts', 'adv_portal_stats', '0', '', 'yesno', 20, 0), ('portal_stats_cacheforums', 'adv_portal_stats', '0', '', '', 30, 0), ('portal_stats_threads', 'adv_portal_stats', '1', '', 'yesno', 40, 0), ('portal_stats_posts', 'adv_portal_stats', '1', '', 'yesno', 50, 0), ('portal_stats_members', 'adv_portal_stats', '1', '', 'yesno', 60, 0), ('portal_stats_newestmember', 'adv_portal_stats', '1', '', 'yesno', 70, 0), ('portal_stats_topposter', 'adv_portal_stats', '1', '', 'yesno', 80, 0), ('portal_noavatarurl', 'adv_portal_welcomeblock', '{$vbulletin->options[bburl]}/images/misc/noavatar.gif', '', '', 30, 0), ('portal_welcome_expanded', 'adv_portal_welcomeblock', '2', '', '
\n
\n
\n \n
', 40, 0), ('portal_integrate', 'adv_portal_main', 'a:4:{s:11:"vbfilenames";a:0:{}s:11:"otfilenames";a:0:{}s:10:"thisscript";a:0:{}s:8:"vba_page";i:0;}', '', 'hidden', 0, 1), ('portal_column_array', 'adv_portal_main', 'a:3:{i:1;s:4:"left";i:2;s:6:"center";i:3;s:5:"right";}', '', 'location_input', 30, 1), ('portal_use_module_function', 'adv_portal_main', '0', '', 'yesno', 60, 0), ('portal_guestcache', 'adv_portal_main', '0', '', '', 70, 0);