-- 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_modules`
--

CREATE TABLE IF NOT EXISTS `adv_modules` (
  `modid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `identifier` varchar(100) NOT NULL DEFAULT '',
  `filename` text NOT NULL,
  `inctype` varchar(20) NOT NULL DEFAULT '',
  `templatelist` text NOT NULL,
  `userperms` varchar(255) NOT NULL DEFAULT '',
  `parent` varchar(255) NOT NULL DEFAULT '',
  `active` smallint(3) unsigned NOT NULL DEFAULT '1',
  `colspan` smallint(3) unsigned NOT NULL DEFAULT '0',
  `formcode` text NOT NULL,
  `useshell` smallint(3) unsigned NOT NULL DEFAULT '0',
  `altshell` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `options` smallint(3) NOT NULL DEFAULT '0',
  `code_parsed` text NOT NULL,
  PRIMARY KEY (`modid`),
  KEY `identifier` (`identifier`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `adv_modules`
--

INSERT INTO `adv_modules` (`modid`, `title`, `identifier`, `filename`, `inctype`, `templatelist`, `userperms`, `parent`, `active`, `colspan`, `formcode`, `useshell`, `altshell`, `link`, `options`, `code_parsed`) VALUES
(1, 'Online Users', 'onlineusers', 'onlineusers.php', 'php_file', 'adv_portal_onlineusers\r\nforumhome_loggedinuser', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '{$vbulletin->options[bburl]}/online.php{$vbulletin->session->vars[sessionurl_q]}', 0, ''),
(2, 'Buddy List', 'buddylist', 'onlineusers.php', 'php_file', 'adv_portal_buddylistbits', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '{$vbulletin->options[bburl]}/profile.php?{$vbulletin->session->vars[sessionurl]}do=editlist', 0, ''),
(3, 'Mini Calendar', 'calendar', 'minicalendar.php', 'php_file', 'adv_portal_calendar_week\r\nadv_portal_calendar_header\r\nadv_portal_calendar_day\r\nadv_portal_calendar_day_other\r\ncalendar_smallmonth_day', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 7, '', 1, '', '{$vbulletin->options[bburl]}/calendar.php?{$vbulletin->session->vars[sessionurl]}c=$mod_options[portal_calendarid]', 0, ''),
(4, 'Top BMC News', 'news', 'news.php', 'php_file', 'adv_portal_newsbits\r\nbbcode_quote\r\nbbcode_php\r\npostbit_attachment\r\npostbit_attachmentimage\r\npostbit_attachmentthumbnail', '4,64,66,5,6,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 23, ''),
(5, 'Recent Threads', 'latestthreads', 'recentthreads.php', 'php_file', 'adv_portal_recthreads_lean\r\nadv_portal_recthreads_exp\r\nadv_portal_recthreads_exp_head', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 2, ''),
(6, 'Forum Stats', 'stats', 'stats.php', 'php_file', 'adv_portal_stats', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 2, ''),
(7, 'Latest Poll', 'poll', 'currentpoll.php', 'php_file', 'adv_portal_poll\r\nadv_portal_pollresult\r\nadv_portal_polloption\r\nadv_portal_polloption_multiple', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '<form action="{$vbulletin->options[bburl]}/poll.php" method="post">', 1, '', '', 23, ''),
(8, 'Quick Moderation', '', 'moderate.php', 'php_file', 'adv_portal_moderation', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, ''),
(9, 'Welcome to BMC', 'welcomeblock', 'welcomeblock.php', 'php_file', 'adv_portal_welcomeblock\r\npostbit_reputation\r\nadv_portal_welcomeblock_lean\r\nadv_portal_welcomeblock_expanded', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 2, '<script src="{$vbulletin->options[bburl]}//clientscript/vbulletin_md5.js" type="text/javascript"></script> <form action="{$vbulletin->options[bburl]}/login.php" method="post" onsubmit="md5hash(vb_login_password,vb_login_md5password)"> <input name="vb_login_md5password" type="hidden" /> <input name="s" type="hidden" value="" /> <input name="do" type="hidden" value="login" />', 1, '', '{$vbulletin->options[bburl]}/usercp.php{$vbulletin->session->vars[sessionurl_q]}', 0, ''),
(10, 'Search Forums', '', 'search', 'template', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '<form action="{$vbulletin->options[bburl]}/search.php" method="post" name="search"> <input name="s" type="hidden" value="" /> <input name="do" type="hidden" value="process" /> <input name="sortby" type="hidden" value="lastpost" /> <input name="forumchoice" type="hidden" value="0" />', 1, '', '{$vbulletin->options[bburl]}/search.php?$session[sessionurl]', 0, ''),
(11, 'News Archive', 'newsarchive', 'news.php', 'php_file', 'adv_portal_news_archive_head\r\nadv_portal_news_archivebits', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', 'news', 0, 6, '', 1, '', '', 18, ''),
(12, 'Staffpage', 'custompage', '', 'custom', '', '', '', 1, 0, '', 1, '', '', 0, ''),
(13, 'Today''s Birthdays', 'birthdays', 'birthdays.php', 'php_file', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 0, ''),
(14, 'Site Navigation', 'navigation', 'navigation.php', 'php_file', 'adv_portal_navigation\r\nadv_portal_navigationbits', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', 'navigation', 1, 0, '', 1, '', '', 0, ''),
(15, 'Donation to BMC', '', 'paypal', 'template', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 1, '', 1, '', '', 0, ''),
(16, 'Staff Page', 'staff', 'staffpage.php', 'php_file', 'adv_portal_staffmembers', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, ''),
(17, 'BMC Affiliates', '', '[CENTER][URL="http://www.bmcperformance.com"]\n[IMG]http://www.bmcforums.com/photopost/data/728/bmcp_cb_black_120.jpg[/IMG][/URL] \n[URL="http://www.jdoqocy.com/click-1988080-5320012"]\n[IMG]http://www.tqlkg.com/image-1988080-5320012[/IMG][/URL]\n\n[URL="http://rover.ebay.com/rover/1/711-1751-2978-155/1?aid=10296928&pid=1988080"] [IMG]http://www.ftjcfx.com/image-1988080-10296928[/IMG][/URL]\n\n[U][URL="http://www.kqzyfj.com/a781shqnhp46EDD5D546597DC96"] [IMG]http://www.ftjcfx.com/hi117g04tzxIKSRRJRJIKJNLRQNK[/IMG][/URL]\n[URL="http://www.jdoqocy.com/click-1988080-10435267"]\n[IMG]http://www.lduhtrp.net/image-1988080-10435267[/IMG][/URL]\n[/U][/CENTER]\n\n[CENTER][URL="http://www.tkqlhce.com/click-1988080-1533782"] [IMG]http://www.tqlkg.com/image-1988080-1533782[/IMG][/URL]\n[/CENTER]\n\n[CENTER][URL="http://www.anrdoezrs.net/click-1988080-1532902"][IMG]http://www.afcyhf.com/image-1988080-1532902[/IMG][/URL]\n[URL="http://www.anrdoezrs.net/click-1988080-9885394"]\n[IMG]http://www.afcyhf.com/image-1988080-9885394[/IMG][/URL]\n[URL="http://www.jdoqocy.com/click-1988080-541633"]\n[IMG]http://www.ftjcfx.com/image-1988080-541633[/IMG][/URL]\n[IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=102327.10000065&type=4&subid=0[/IMG]\n\n[URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=102327.10000065&type=4&subid=0"][IMG]http://images.tigerdirect.com/email/affiliate_new/120x90upromise.gif[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=102327.10000065&type=4&subid=0[/IMG]\n\n[B][URL="http://www.modularpowerhouse.com"][SIZE=3]Modular Powerhouse[/SIZE][/URL]\n\n[IMG]http://www.bmcforums.com/photopost/data/547/MMissue16_100.jpg[/IMG][/B]\n\n\n\n[URL="http://www.dpbolvw.net/click-1988080-10390926"] [IMG]http://www.lduhtrp.net/image-1988080-10390926[/IMG][/URL][/CENTER]', 'bb_code', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, '<div align="center"><a href="http://www.bmcperformance.com" target="_blank"><br />\n<img src="http://www.bmcforums.com/photopost/data/728/bmcp_cb_black_120.jpg" border="0" alt="" /></a> <br />\n<a href="http://www.jdoqocy.com/click-1988080-5320012" target="_blank"><br />\n<img src="http://www.tqlkg.com/image-1988080-5320012" border="0" alt="" /></a><br />\n<br />\n<a href="http://rover.ebay.com/rover/1/711-1751-2978-155/1?aid=10296928&amp;pid=1988080" target="_blank"> <img src="http://www.ftjcfx.com/image-1988080-10296928" border="0" alt="" /></a><br />\n<br />\n<u><a href="http://www.kqzyfj.com/a781shqnhp46EDD5D546597DC96" target="_blank"> <img src="http://www.ftjcfx.com/hi117g04tzxIKSRRJRJIKJNLRQNK" border="0" alt="" /></a><br />\n<a href="http://www.jdoqocy.com/click-1988080-10435267" target="_blank"><br />\n<img src="http://www.lduhtrp.net/image-1988080-10435267" border="0" alt="" /></a><br />\n</u></div><br />\n<div align="center"><a href="http://www.tkqlhce.com/click-1988080-1533782" target="_blank"> <img src="http://www.tqlkg.com/image-1988080-1533782" border="0" alt="" /></a><br />\n</div><br />\n<div align="center"><a href="http://www.anrdoezrs.net/click-1988080-1532902" target="_blank"><img src="http://www.afcyhf.com/image-1988080-1532902" border="0" alt="" /></a><br />\n<a href="http://www.anrdoezrs.net/click-1988080-9885394" target="_blank"><br />\n<img src="http://www.afcyhf.com/image-1988080-9885394" border="0" alt="" /></a><br />\n<a href="http://www.jdoqocy.com/click-1988080-541633" target="_blank"><br />\n<img src="http://www.ftjcfx.com/image-1988080-541633" border="0" alt="" /></a><br />\n<img src="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=102327.10000065&amp;type=4&amp;subid=0" border="0" alt="" /><br />\n<br />\n<a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=102327.10000065&amp;type=4&amp;subid=0" target="_blank"><img src="http://images.tigerdirect.com/email/affiliate_new/120x90upromise.gif" border="0" alt="" /></a><img src="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=102327.10000065&amp;type=4&amp;subid=0" border="0" alt="" /><br />\n<br />\n<b><a href="http://www.modularpowerhouse.com" target="_blank"><font size="3">Modular Powerhouse</font></a><br />\n<br />\n<img src="http://www.bmcforums.com/photopost/data/547/MMissue16_100.jpg" border="0" alt="" /></b><br />\n<br />\n<br />\n<br />\n<a href="http://www.dpbolvw.net/click-1988080-10390926" target="_blank"> <img src="http://www.lduhtrp.net/image-1988080-10390926" border="0" alt="" /></a></div>'),
(18, 'Downloads', 'Downloads', 'ecdownloads.php', 'php_file', 'adv_portal_ecdownloads\r\ndownloads_panel_bit', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, ''),
(19, 'Navigation Menu', '', 'navmenu', 'template', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, ''),
(20, 'Sponsors & Friends', '', '[CENTER][IMG]http://bmcforums.com/images/sponsors/bmcp_trans_50h.png[/IMG]\n\n[URL="http://ccasr.org"][IMG]http://www.bmcforums.com/gallery/data/723/CCASR-SupportingClub-175x175.png[/IMG][/URL]\n\n[IMG]http://www.bmcforums.com/gallery/data/610/MetallicLogo_big_neg_40h.jpg[/IMG]\n\n[IMG]http://bmcforums.com/images/sponsors/vortech-08_175w.png[/IMG]\n\n[IMG]http://bmcforums.com/images/sponsors/corsa_40h.png[/IMG]\n\n[IMG]http://www.blackmustangclub.com/images/kooks-trans_40h.png[/IMG]\n\n[IMG]http://bmcforums.com/images/sponsors/stangsuspension_43h.png[/IMG]\n\n[IMG]http://bmcforums.com/images/sponsors/autobadges_38h.png[/IMG]\n[/CENTER]', 'bb_code', '', '4,64,66,5,6,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 4, '<div align="center"><img src="http://bmcforums.com/images/sponsors/bmcp_trans_50h.png" border="0" alt="" /><br />\n<br />\n<a href="http://ccasr.org" target="_blank"><img src="http://www.bmcforums.com/gallery/data/723/CCASR-SupportingClub-175x175.png" border="0" alt="" /></a><br />\n<br />\n<img src="http://www.bmcforums.com/gallery/data/610/MetallicLogo_big_neg_40h.jpg" border="0" alt="" /><br />\n<br />\n<img src="http://bmcforums.com/images/sponsors/vortech-08_175w.png" border="0" alt="" /><br />\n<br />\n<img src="http://bmcforums.com/images/sponsors/corsa_40h.png" border="0" alt="" /><br />\n<br />\n<img src="http://www.blackmustangclub.com/images/kooks-trans_40h.png" border="0" alt="" /><br />\n<br />\n<img src="http://bmcforums.com/images/sponsors/stangsuspension_43h.png" border="0" alt="" /><br />\n<br />\n<img src="http://bmcforums.com/images/sponsors/autobadges_38h.png" border="0" alt="" /><br />\n</div>'),
(21, 'old', '', '', 'bb_code', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, ''),
(22, 'BMC Members Receive Discounted Mustang Magazine Subscriptions', '', '[CENTER][URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=50887.118801&type=2&subid=0"][IMG]http://www.netmagazines.com/images/8801.jpg[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=50887.118801&type=2&subid=0[/IMG]  [URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=50887.119827&type=2&subid=0"][IMG]http://www.netmagazines.com/images/9827.jpg[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=50887.119827&type=2&subid=0[/IMG] [URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=50887.110048&type=2&subid=0"][IMG]http://www.netmagazines.com/images/0048.jpg[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=50887.110048&type=2&subid=0[/IMG] [URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=50887.1188115&type=2&subid=0"][IMG]http://www.netmagazines.com/images/88115.jpg[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=50887.1188115&type=2&subid=0[/IMG] [URL="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&offerid=50887.111172&type=2&subid=0"][IMG]http://www.netmagazines.com/images/1172.jpg[/IMG][/URL][IMG]http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&bids=50887.111172&type=2&subid=0[/IMG][/CENTER]', 'bb_code', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 0, 0, '', 1, '', '', 0, '<div align="center"><a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=50887.118801&amp;type=2&amp;subid=0" target="_blank"><a href="http://www.netmagazines.com/images/8801.jpg" target="_blank">http://www.netmagazines.com/images/8801.jpg</a></a><a href="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=50887.118801&amp;type=2&amp;subid=0" target="_blank">http://ad.linksynergy.com/fs-bin/sho...type=2&amp;subid=0</a>  <a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=50887.119827&amp;type=2&amp;subid=0" target="_blank"><a href="http://www.netmagazines.com/images/9827.jpg" target="_blank">http://www.netmagazines.com/images/9827.jpg</a></a><a href="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=50887.119827&amp;type=2&amp;subid=0" target="_blank">http://ad.linksynergy.com/fs-bin/sho...type=2&amp;subid=0</a> <a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=50887.110048&amp;type=2&amp;subid=0" target="_blank"><a href="http://www.netmagazines.com/images/0048.jpg" target="_blank">http://www.netmagazines.com/images/0048.jpg</a></a><a href="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=50887.110048&amp;type=2&amp;subid=0" target="_blank">http://ad.linksynergy.com/fs-bin/sho...type=2&amp;subid=0</a> <a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=50887.1188115&amp;type=2&amp;subid=0" target="_blank"><a href="http://www.netmagazines.com/images/88115.jpg" target="_blank">http://www.netmagazines.com/images/88115.jpg</a></a><a href="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=50887.1188115&amp;type=2&amp;subid=0" target="_blank">http://ad.linksynergy.com/fs-bin/sho...type=2&amp;subid=0</a> <a href="http://click.linksynergy.com/fs-bin/click?id=JekdXqyYweA&amp;offerid=50887.111172&amp;type=2&amp;subid=0" target="_blank"><a href="http://www.netmagazines.com/images/1172.jpg" target="_blank">http://www.netmagazines.com/images/1172.jpg</a></a><a href="http://ad.linksynergy.com/fs-bin/show?id=JekdXqyYweA&amp;bids=50887.111172&amp;type=2&amp;subid=0" target="_blank">http://ad.linksynergy.com/fs-bin/sho...type=2&amp;subid=0</a></div>'),
(23, 'In Memory Of', '', '[CENTER][IMG]http://bmcforums.com/images/Mike_Ribbon_150h.png[/IMG]\n[/CENTER]', 'bb_code', '', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '', 4, '<div align="center"><img src="http://bmcforums.com/images/Mike_Ribbon_150h.png" border="0" alt="" /><br />\n</div>'),
(24, 'Popular Tags', 'vba_tags', 'popular_tags.php', 'php_file', 'tag_cloud_box\r\ntag_cloud_headinclude\r\ntag_cloud_link', '4,6,64,66,5,10,59,54,67,60,7,27,65,2,9,48,14,63,1,3', '', 1, 0, '', 1, '', '{$vbulletin->options[bburl]}/tags.php{$vbulletin->session->vars[sessionurl_q]}', 0, '');