-- phpMyAdmin SQL Dump -- version 2.11.3 -- http://www.phpmyadmin.net -- -- Host: mysql50-31.wc1:3306 -- Generation Time: Apr 09, 2009 at 01:01 PM -- Server version: 5.0.51 -- PHP Version: 4.3.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `376373_vbull` -- -- -------------------------------------------------------- -- -- Table structure for table `vb_forum` -- CREATE TABLE `vb_forum` ( `forumid` smallint(5) unsigned NOT NULL auto_increment, `styleid` smallint(5) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `title_clean` varchar(100) NOT NULL default '', `description` text, `description_clean` text, `options` int(10) unsigned NOT NULL default '0', `showprivate` tinyint(3) unsigned NOT NULL default '0', `displayorder` smallint(6) NOT NULL default '0', `replycount` int(10) unsigned NOT NULL default '0', `lastpost` int(11) NOT NULL default '0', `lastposter` varchar(100) NOT NULL default '', `lastpostid` int(10) unsigned NOT NULL default '0', `lastthread` varchar(250) NOT NULL default '', `lastthreadid` int(10) unsigned NOT NULL default '0', `lasticonid` smallint(6) NOT NULL default '0', `lastprefixid` varchar(25) NOT NULL default '', `threadcount` mediumint(8) unsigned NOT NULL default '0', `daysprune` smallint(6) NOT NULL default '0', `newpostemail` text, `newthreademail` text, `parentid` smallint(6) NOT NULL default '0', `parentlist` varchar(250) NOT NULL default '', `password` varchar(50) NOT NULL default '', `link` varchar(200) NOT NULL default '', `childlist` text, `defaultsortfield` varchar(50) NOT NULL default 'lastpost', `defaultsortorder` enum('asc','desc') NOT NULL default 'desc', `imageprefix` varchar(100) NOT NULL default '', `importforumid` bigint(20) NOT NULL default '0', `importcategoryid` bigint(20) NOT NULL default '0', PRIMARY KEY (`forumid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ; -- -- Dumping data for table `vb_forum` -- INSERT INTO `vb_forum` VALUES(1, 0, 'Main Category', 'Main Category', 'Main Category Description', 'Main Category Description', 86017, 0, 1, 0, 0, '', 0, '', 0, 0, '', 0, -1, '', '', -1, '1,-1', '', '', '1,2,-1', 'lastpost', 'desc', '', 0, 0); INSERT INTO `vb_forum` VALUES(2, 0, 'Main Forum', 'Main Forum', 'Main Forum Description', 'Main Forum Description', 89799, 0, 1, 0, 0, '', 0, '', 0, 0, '', 0, -1, '', '', 1, '2,1,-1', '', '', '2,-1', 'lastpost', 'desc', '', 0, 0); INSERT INTO `vb_forum` VALUES(3, 0, 'Shop Talk', 'Shop Talk', '!Forum description', '!Forum description', 89795, 0, 60, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '3,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 2); INSERT INTO `vb_forum` VALUES(4, 0, 'Key Pro Workshops & Events', 'Key Pro Workshops & Events', '!Forum description', '!Forum description', 89795, 0, 50, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '4,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 1); INSERT INTO `vb_forum` VALUES(5, 0, 'Technical Vehicle Specific', 'Technical Vehicle Specific', '!Forum description', '!Forum description', 89795, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '5,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 3); INSERT INTO `vb_forum` VALUES(6, 0, 'Rookies area', 'Rookies area', '!Forum description', '!Forum description', 89795, 0, 70, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '6,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 4); INSERT INTO `vb_forum` VALUES(7, 0, 'Out of the U.S.A.', 'Out of the U.S.A.', '!Forum description', '!Forum description', 89795, 0, 80, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '7,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 5); INSERT INTO `vb_forum` VALUES(8, 0, 'Forum Feedback', 'Forum Feedback', '!Forum description', '!Forum description', 89795, 0, 100, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '8,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 6); INSERT INTO `vb_forum` VALUES(9, 0, 'General Vehicle Information', 'General Vehicle Information', '!Forum description', '!Forum description', 89795, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '9,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 7); INSERT INTO `vb_forum` VALUES(10, 0, 'PUBLIC AREA!!!!', 'PUBLIC AREA!!!!', '!Forum description', '!Forum description', 89795, 0, 90, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '10,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 8); INSERT INTO `vb_forum` VALUES(11, 0, 'General Locksmithing', 'General Locksmithing', '!Forum description', '!Forum description', 89795, 0, 40, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '11,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 9); INSERT INTO `vb_forum` VALUES(12, 0, 'Open Forum non-specific', 'Open Forum non-specific', '!Forum description', '!Forum description', 89795, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '12,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 10); INSERT INTO `vb_forum` VALUES(13, 0, 'Private & Out of sync', 'Private & Out of sync', 'This is a default category for private imported forums', 'This is a default category for private imported forums', 89795, 0, 1, 0, 0, '', 0, '', 0, 0, '', 0, 30, NULL, NULL, -1, '13,-1', '', '', NULL, 'lastpost', 'desc', '', 0, 99999); INSERT INTO `vb_forum` VALUES(14, 0, 'Education Classes', 'Education Classes', 'Find information about upcoming workshops in your area.', 'Find information about upcoming workshops in your area.', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 4, '14,-1', '', '', '14,-1', '', '', '', 1, 0); INSERT INTO `vb_forum` VALUES(15, 0, 'Distributors/Ilco/Strattec/etc.', 'Distributors/Ilco/Strattec/etc.', 'This area is for discussions regarding Distributors and Suppliers.', 'This area is for discussions regarding Distributors and Suppliers.', 89799, 0, 40, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '15,-1', '', '', '15,-1', '', '', '', 2, 0); INSERT INTO `vb_forum` VALUES(16, 0, 'Transponder Talk', 'Transponder Talk', 'Talk about the latest information and technology on Transponders.', 'Talk about the latest information and technology on Transponders.', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 5, '16,-1', '', '', '16,-1', '', '', '', 3, 0); INSERT INTO `vb_forum` VALUES(17, 0, 'New Key Ways', 'New Key Ways', 'Talk about new OEM key systems.', 'Talk about new OEM key systems.', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 5, '17,-1', '', '', '17,-1', '', '', '', 4, 0); INSERT INTO `vb_forum` VALUES(18, 0, 'Remotes', 'Remotes', 'Various automotive remotes and programming techiques.', 'Various automotive remotes and programming techiques.', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 5, '18,-1', '', '', '18,-1', '', '', '', 6, 0); INSERT INTO `vb_forum` VALUES(19, 0, 'Questions?', 'Questions?', 'Need help on something?', 'Need help on something?', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 6, '19,-1', '', '', '19,-1', '', '', '', 7, 0); INSERT INTO `vb_forum` VALUES(20, 0, 'Tools and supplies', 'Tools and supplies', '', '', 89799, 0, 50, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '20,-1', '', '', '20,-1', '', '', '', 8, 0); INSERT INTO `vb_forum` VALUES(21, 0, 'JUST CARS!', 'JUST CARS!', 'Comments and questions.', 'Comments and questions.', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 4, '21,-1', '', '', '21,-1', '', '', '', 11, 0); INSERT INTO `vb_forum` VALUES(22, 0, 'New Tools or Equipment', 'New Tools or Equipment', 'Anything out there you want to tell us about?', 'Anything out there you want to tell us about?', 89799, 0, 60, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '22,-1', '', '', '22,-1', '', '', '', 13, 0); INSERT INTO `vb_forum` VALUES(23, 0, 'New Vehicles/Models', 'New Vehicles/Models', 'If you come across something new post it up.', 'If you come across something new post it up.', 89799, 0, 40, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 5, '23,-1', '', '', '23,-1', '', '', '', 15, 0); INSERT INTO `vb_forum` VALUES(24, 0, 'AustraliaAsia', 'AustraliaAsia', '', '', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 7, '24,-1', '', '', '24,-1', '', '', '', 17, 0); INSERT INTO `vb_forum` VALUES(25, 0, 'Key Pro Forum Feedback', 'Key Pro Forum Feedback', 'Post feedback about the forum in here.', 'Post feedback about the forum in here.', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 8, '25,-1', '', '', '25,-1', '', '', '', 20, 0); INSERT INTO `vb_forum` VALUES(26, 0, 'Technical Automotive', 'Technical Automotive', 'Post technical questions not fitting any other catagory.', 'Post technical questions not fitting any other catagory.', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '26,-1', '', '', '26,-1', '', '', '', 21, 0); INSERT INTO `vb_forum` VALUES(27, 0, 'Automotive Questions or Statements', 'Automotive Questions or Statements', 'Questions not related to the WEB site primary function.', 'Questions not related to the WEB site primary function.', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '27,-1', '', '', '27,-1', '', '', '', 22, 0); INSERT INTO `vb_forum` VALUES(28, 0, 'Buy/Sell/Trade', 'Buy/Sell/Trade', 'This is for you to work a deal with other locksmiths! Get the best deal you can but keep it honest and fair.... Jim', 'This is for you to work a deal with other locksmiths! Get the best deal you can but keep it honest and fair.... Jim', 89799, 0, 40, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '28,-1', '', '', '28,-1', '', '', '', 23, 0); INSERT INTO `vb_forum` VALUES(29, 0, 'NASTF', 'NASTF', 'National Automotive Service Task Force. This is the committee of Aftermarket Service Providers and OEM''s working under direction of the EPA.', 'National Automotive Service Task Force. This is the committee of Aftermarket Service Providers and OEM''s working under direction of the EPA.', 89799, 0, 70, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '29,-1', '', '', '29,-1', '', '', '', 24, 0); INSERT INTO `vb_forum` VALUES(30, 0, 'Ask Key Pro Info', 'Ask Key Pro Info', 'This area is for general visitors of KeyPro.info. Please stop in and ask questions about our site and membership requirements. This Forum is open to all visitors.', 'This area is for general visitors of KeyPro.info. Please stop in and ask questions about our site and membership requirements. This Forum is open to all visitors.', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 10, '30,-1', '', '', '30,-1', '', '', '', 26, 0); INSERT INTO `vb_forum` VALUES(31, 0, 'South Africa', 'South Africa', 'Capelockie, Moderator', 'Capelockie, Moderator', 89799, 0, 50, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 7, '31,-1', '', '', '31,-1', '', '', '', 27, 0); INSERT INTO `vb_forum` VALUES(32, 0, 'Europe', 'Europe', 'Across the big pond area!', 'Across the big pond area!', 89799, 0, 60, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 7, '32,-1', '', '', '32,-1', '', '', '', 28, 0); INSERT INTO `vb_forum` VALUES(33, 0, 'Membership', 'Membership', 'New members and anything related to membership.', 'New members and anything related to membership.', 89799, 0, 60, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '33,-1', '', '', '33,-1', '', '', '', 29, 0); INSERT INTO `vb_forum` VALUES(34, 0, 'Admin', 'Admin', '', '', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 8, '34,-1', '', '', '34,-1', '', '', '', 30, 0); INSERT INTO `vb_forum` VALUES(35, 0, 'Ilco Key Guide', 'Ilco Key Guide', 'I am making this forum for you to post any errors you find in this key guide. I am in talks with Ilco to help get the key guide back to what it used to be for all of us.', 'I am making this forum for you to post any errors you find in this key guide. I am in talks with Ilco to help get the key guide back to what it used to be for all of us.', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '35,-1', '', '', '35,-1', '', '', '', 31, 0); INSERT INTO `vb_forum` VALUES(36, 0, 'Aftermarket Alarms', 'Aftermarket Alarms', 'This is being tested for traffic volume at the request of some locksmiths.', 'This is being tested for traffic volume at the request of some locksmiths.', 89799, 0, 50, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '36,-1', '', '', '36,-1', '', '', '', 32, 0); INSERT INTO `vb_forum` VALUES(37, 0, 'Laser Key Products', 'Laser Key Products', 'This site is for owners of any Laser Security Products to post information, problems and get updates.', 'This site is for owners of any Laser Security Products to post information, problems and get updates.', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '37,-1', '', '', '37,-1', '', '', '', 33, 0); INSERT INTO `vb_forum` VALUES(38, 0, 'PUBLIC AREA Chip and Transponder Questions', 'PUBLIC AREA Chip and Transponder Questions', 'Do you have a key for you car with a chip/Transponder and need help?', 'Do you have a key for you car with a chip/Transponder and need help?', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 10, '38,-1', '', '', '38,-1', '', '', '', 34, 0); INSERT INTO `vb_forum` VALUES(39, 0, 'Do you have a remote question?', 'Do you have a remote question?', 'Need a remote? Or is you remote broken or missing? Post a question here to solve your problem.', 'Need a remote? Or is you remote broken or missing? Post a question here to solve your problem.', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 10, '39,-1', '', '', '39,-1', '', '', '', 35, 0); INSERT INTO `vb_forum` VALUES(40, 0, 'Keys lost or broken?', 'Keys lost or broken?', 'If you have lost your keys or broken them post it here and we can help you out.', 'If you have lost your keys or broken them post it here and we can help you out.', 89799, 0, 40, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 10, '40,-1', '', '', '40,-1', '', '', '', 36, 0); INSERT INTO `vb_forum` VALUES(41, 0, 'Need a Automotive Specialist in your area?', 'Need a Automotive Specialist in your area?', 'If you need help in a certain area please post a question here and we can get help to you.', 'If you need help in a certain area please post a question here and we can get help to you.', 89799, 0, 50, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 10, '41,-1', '', '', '41,-1', '', '', '', 37, 0); INSERT INTO `vb_forum` VALUES(42, 0, 'Motorcycles', 'Motorcycles', 'This is for posting Motorcycle questions and answers', 'This is for posting Motorcycle questions and answers', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 9, '42,-1', '', '', '42,-1', '', '', '', 38, 0); INSERT INTO `vb_forum` VALUES(43, 0, 'Technical Non-Automotive', 'Technical Non-Automotive', 'Issue''s of general locksmith problems or information to shared!', 'Issue''s of general locksmith problems or information to shared!', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 11, '43,-1', '', '', '43,-1', '', '', '', 39, 0); INSERT INTO `vb_forum` VALUES(44, 0, 'Questions Non-Automotive', 'Questions Non-Automotive', 'Any question reference the trade not technical in nature.', 'Any question reference the trade not technical in nature.', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 11, '44,-1', '', '', '44,-1', '', '', '', 40, 0); INSERT INTO `vb_forum` VALUES(45, 0, 'Buy, Sell or Trade', 'Buy, Sell or Trade', 'Non - Automotive stuff!', 'Non - Automotive stuff!', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 11, '45,-1', '', '', '45,-1', '', '', '', 41, 0); INSERT INTO `vb_forum` VALUES(46, 0, 'Questions', 'Questions', 'Have a questions not specific to any other area? Monitored!', 'Have a questions not specific to any other area? Monitored!', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 12, '46,-1', '', '', '46,-1', '', '', '', 43, 0); INSERT INTO `vb_forum` VALUES(47, 0, 'Statements!', 'Statements!', 'Not specific to any other area! Monitored!!', 'Not specific to any other area! Monitored!!', 89799, 0, 20, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 12, '47,-1', '', '', '47,-1', '', '', '', 44, 0); INSERT INTO `vb_forum` VALUES(48, 0, 'Open Post!', 'Open Post!', 'Anything not fitted any other area! Monitored!', 'Anything not fitted any other area! Monitored!', 89799, 0, 30, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 12, '48,-1', '', '', '48,-1', '', '', '', 45, 0); INSERT INTO `vb_forum` VALUES(49, 0, 'Keylessride Tech Support', 'Keylessride Tech Support', 'Post technical issues here for remotes or Hotwire Problems. Noel', 'Post technical issues here for remotes or Hotwire Problems. Noel', 89799, 0, 10, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '49,-1', '', '', '49,-1', '', '', '', 46, 0); INSERT INTO `vb_forum` VALUES(50, 0, 'ZedBULL Tech Support', 'ZedBULL Tech Support', 'Problems and Questions can be answered here!', 'Problems and Questions can be answered here!', 89799, 0, 70, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '50,-1', '', '', '50,-1', '', '', '', 47, 0); INSERT INTO `vb_forum` VALUES(51, 0, 'Advanced-Diagnostics', 'Advanced-Diagnostics', 'Advanced-Diagnostics UK and AD-USA information and exchange data forum.', 'Advanced-Diagnostics UK and AD-USA information and exchange data forum.', 89799, 0, 80, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '51,-1', '', '', '51,-1', '', '', '', 48, 0); INSERT INTO `vb_forum` VALUES(52, 0, 'JMA Products', 'JMA Products', 'For all JMA Tech Support issues and discussions.', 'For all JMA Tech Support issues and discussions.', 89799, 0, 90, 0, 0, '', 0, '', 0, 0, '', 0, 0, '', '', 3, '52,-1', '', '', '52,-1', '', '', '', 49, 0);