-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 26, 2013 at 04:29 PM
-- Server version: 5.0.45
-- PHP Version: 5.1.6
-- 
-- Database: `mld_forum`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `admin_info_files`
-- 

CREATE TABLE `admin_info_files` (
  `id_file` tinyint(4) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `parameters` varchar(255) NOT NULL default '',
  `data` text NOT NULL,
  `filetype` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_file`),
  KEY `filename` (`filename`(30))
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `admin_info_files`
-- 

INSERT INTO `admin_info_files` VALUES (1, 'current-version.js', '/smf/', 'version=%3$s', 'window.smfVersion = "SMF 2.0.4";', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (2, 'detailed-version.js', '/smf/', 'language=%1$s&version=%3$s', 'window.smfVersions = {\n	''SMF'': ''SMF 2.0.4'',\n	''SourcesAdmin.php'': ''2.0'',\n	''SourcesBoardIndex.php'': ''2.0'',\n	''SourcesCalendar.php'': ''2.0'',\n	''SourcesClass-Graphics.php'': ''2.0'',\n	''SourcesClass-Package.php'': ''2.0'',\n	''SourcesDbExtra-mysql.php'': ''2.0'',\n	''SourcesDbExtra-postgresql.php'': ''2.0'',\n	''SourcesDbExtra-sqlite.php'': ''2.0'',\n	''SourcesDbPackages-mysql.php'': ''2.0'',\n	''SourcesDbPackages-postgresql.php'': ''2.0'',\n	''SourcesDbPackages-sqlite.php'': ''2.0'',\n	''SourcesDbSearch-mysql.php'': ''2.0'',\n	''SourcesDbSearch-postgresql.php'': ''2.0'',\n	''SourcesDbSearch-sqlite.php'': ''2.0'',\n	''SourcesDisplay.php'': ''2.0'',\n	''SourcesDumpDatabase.php'': ''2.0'',\n	''SourcesErrors.php'': ''2.0.4'',\n	''SourcesGroups.php'': ''2.0'',\n	''SourcesHelp.php'': ''2.0'',\n	''SourcesKarma.php'': ''2.0'',\n	''SourcesLoad.php'': ''2.0.3'',\n	''SourcesLockTopic.php'': ''2.0'',\n	''SourcesLogInOut.php'': ''2.0.4'',\n	''SourcesManageAttachments.php'': ''2.0'',\n	''SourcesManageBans.php'': ''2.0'',\n	''SourcesManageBoards.php'': ''2.0'',\n	''SourcesManageCalendar.php'': ''2.0'',\n	''SourcesManageErrors.php'': ''2.0.4'',\n	''SourcesManageMail.php'': ''2.0'',\n	''SourcesManageMaintenance.php'': ''2.0.1'',\n	''SourcesManageMembergroups.php'': ''2.0'',\n	''SourcesManageMembers.php'': ''2.0'',\n	''SourcesManageNews.php'': ''2.0'',\n	''SourcesManagePaid.php'': ''2.0.3'',\n	''SourcesManagePermissions.php'': ''2.0'',\n	''SourcesManagePosts.php'': ''2.0'',\n	''SourcesManageRegistration.php'': ''2.0'',\n	''SourcesManageScheduledTasks.php'': ''2.0'',\n	''SourcesManageSearch.php'': ''2.0'',\n	''SourcesManageSearchEngines.php'': ''2.0'',\n	''SourcesManageServer.php'': ''2.0.4'',\n	''SourcesManageSettings.php'': ''2.0'',\n	''SourcesManageSmileys.php'': ''2.0'',\n	''SourcesMemberlist.php'': ''2.0.2'',\n	''SourcesMessageIndex.php'': ''2.0.2'',\n	''SourcesModerationCenter.php'': ''2.0.1'',\n	''SourcesModlog.php'': ''2.0.3'',\n	''SourcesMoveTopic.php'': ''2.0'',\n	''SourcesNews.php'': ''2.0'',\n	''SourcesNotify.php'': ''2.0'',\n	''SourcesPackageGet.php'': ''2.0'',\n	''SourcesPackages.php'': ''2.0.2'',\n	''SourcesPersonalMessage.php'': ''2.0'',\n	''SourcesPoll.php'': ''2.0'',\n	''SourcesPost.php'': ''2.0'',\n	''SourcesPostModeration.php'': ''2.0'',\n	''SourcesPrintpage.php'': ''2.0'',\n	''SourcesProfile.php'': ''2.0'',\n	''SourcesProfile-Actions.php'': ''2.0'',\n	''SourcesProfile-Modify.php'': ''2.0.2'',\n	''SourcesProfile-View.php'': ''2.0'',\n	''SourcesQueryString.php'': ''2.0.3'',\n	''SourcesRecent.php'': ''2.0'',\n	''SourcesRegister.php'': ''2.0.4'',\n	''SourcesReminder.php'': ''2.0.4'',\n	''SourcesRemoveTopic.php'': ''2.0'',\n	''SourcesRepairBoards.php'': ''2.0'',\n	''SourcesReports.php'': ''2.0'',\n	''SourcesSSI.php'': ''2.0.4'',\n	''SourcesScheduledTasks.php'': ''2.0'',\n	''SourcesSearch.php'': ''2.0'',\n	''SourcesSearchAPI-Custom.php'': ''2.0'',\n	''SourcesSearchAPI-Fulltext.php'': ''2.0'',\n	''SourcesSearchAPI-Standard.php'': ''2.0'',\n	''SourcesSecurity.php'': ''2.0.3'',\n	''SourcesSendTopic.php'': ''2.0'',\n	''SourcesSplitTopics.php'': ''2.0'',\n	''SourcesStats.php'': ''2.0'',\n	''SourcesSubs.php'': ''2.0'',\n	''SourcesSubs-Admin.php'': ''2.0'',\n	''SourcesSubs-Auth.php'': ''2.0'',\n	''SourcesSubs-BoardIndex.php'': ''2.0'',\n	''SourcesSubs-Boards.php'': ''2.0'',\n	''SourcesSubs-Calendar.php'': ''2.0'',\n	''SourcesSubs-Categories.php'' : ''2.0'',\n	''SourcesSubs-Charset.php'' : ''2.0'',\n	''SourcesSubs-Compat.php'': ''2.0'',\n	''SourcesSubs-Db-mysql.php'': ''2.0.4'',\n	''SourcesSubs-Db-postgresql.php'': ''2.0.4'',\n	''SourcesSubs-Db-sqlite.php'': ''2.0'',\n	''SourcesSubs-Editor.php'': ''2.0'',\n	''SourcesSubs-Graphics.php'': ''2.0'',\n	''SourcesSubs-List.php'': ''2.0'',\n	''SourcesSubs-Membergroups.php'': ''2.0'',\n	''SourcesSubs-Members.php'': ''2.0.1'',\n	''SourcesSubs-MembersOnline.php'': ''2.0'',\n	''SourcesSubs-Menu.php'': ''2.0.1'',\n	''SourcesSubs-MessageIndex.php'': ''2.0'',\n	''SourcesSubs-OpenID.php'': ''2.0'',\n	''SourcesSubs-Package.php'': ''2.0.1'',\n	''SourcesSubs-Post.php'': ''2.0'',\n	''SourcesSubs-Recent.php'': ''2.0'',\n	''SourcesSubscriptions-PayPal.php'': ''2.0.3'',\n	''Sourcessubscriptions.php'': ''2.0.2'',\n	''SourcesSubs-Sound.php'': ''2.0'',\n	''SourcesThemes.php'': ''2.0.4'',\n	''SourcesViewQuery.php'': ''2.0'',\n	''SourcesWho.php'': ''2.0.2'',\n	''SourcesXml.php'': ''2.0'',\n	''DefaultAdmin.template.php'': ''2.0'',\n	''DefaultBoardIndex.template.php'': ''2.0'',\n	''DefaultCalendar.template.php'': ''2.0'',\n	''DefaultCompat.template.php'': ''2.0'',\n	''DefaultDisplay.template.php'': ''2.0'',\n	''DefaultErrors.template.php'': ''2.0'',\n	''DefaultGenericControls.template.php'': ''2.0'',\n	''DefaultGenericList.template.php'': ''2.0'',\n	''DefaultGenericMenu.template.php'': ''2.0'',\n	''DefaultHelp.template.php'': ''2.0'',\n	''DefaultLogin.template.php'': ''2.0'',\n	''DefaultManageAttachments.template.php'': ''2.0'',\n	''DefaultManageBans.template.php'': ''2.0'',\n	''DefaultManageBoards.template.php'': ''2.0'',\n	''DefaultManageCalendar.template.php'': ''2.0'',\n	''DefaultManageMail.template.php'': ''2.0'',\n	''DefaultManageMaintenance.template.php'': ''2.0'',\n	''DefaultManageMembergroups.template.php'': ''2.0'',\n	''DefaultManageMembers.template.php'': ''2.0'',\n	''DefaultManageNews.template.php'': ''2.0'',\n	''DefaultManagePaid.template.php'': ''2.0'',\n	''DefaultManagePermissions.template.php'': ''2.0'',\n	''DefaultManageScheduledTasks.template.php'': ''2.0'',\n	''DefaultManageSearch.template.php'': ''2.0'',\n	''DefaultManageSmileys.template.php'': ''2.0'',\n	''DefaultMemberlist.template.php'': ''2.0'',\n	''DefaultMessageIndex.template.php'': ''2.0'',\n	''DefaultModerationCenter.template.php'': ''2.0'',\n	''DefaultMoveTopic.template.php'': ''2.0'',\n	''DefaultNotify.template.php'': ''2.0'',\n	''DefaultPackages.template.php'': ''2.0'',\n	''DefaultPersonalMessage.template.php'': ''2.0'',\n	''DefaultPoll.template.php'': ''2.0'',\n	''DefaultPost.template.php'': ''2.0'',\n	''DefaultPrintpage.template.php'': ''2.0'',\n	''DefaultProfile.template.php'': ''2.0'',\n	''DefaultRecent.template.php'': ''2.0'',\n	''DefaultRegister.template.php'': ''2.0'',\n	''DefaultReminder.template.php'': ''2.0'',\n	''DefaultReports.template.php'': ''2.0'',\n	''DefaultSearch.template.php'': ''2.0'',\n	''DefaultSendTopic.template.php'': ''2.0'',\n	''DefaultSettings.template.php'': ''2.0'',\n	''DefaultSplitTopics.template.php'': ''2.0'',\n	''DefaultStats.template.php'': ''2.0'',\n	''DefaultThemes.template.php'': ''2.0'',\n	''DefaultWho.template.php'': ''2.0'',\n	''DefaultWireless.template.php'': ''2.0'',\n	''DefaultXml.template.php'': ''2.0'',\n	''Defaultindex.template.php'': ''2.0'',\n	''TemplatesAdmin.template.php'': ''2.0'',\n	''TemplatesBoardIndex.template.php'': ''2.0'',\n	''TemplatesCalendar.template.php'': ''2.0'',\n	''TemplatesDisplay.template.php'': ''2.0'',\n	''TemplatesErrors.template.php'': ''2.0'',\n	''TemplatesGenericControls.template.php'': ''2.0'',\n	''TemplatesGenericList.template.php'': ''2.0'',\n	''TemplatesGenericMenu.template.php'': ''2.0'',\n	''TemplatesHelp.template.php'': ''2.0'',\n	''TemplatesLogin.template.php'': ''2.0'',\n	''TemplatesManageAttachments.template.php'': ''2.0'',\n	''TemplatesManageBans.template.php'': ''2.0'',\n	''TemplatesManageBoards.template.php'': ''2.0'',\n	''TemplatesManageCalendar.template.php'': ''2.0'',\n	''TemplatesManageMail.template.php'': ''2.0'',\n	''TemplatesManageMaintenance.template.php'': ''2.0'',\n	''TemplatesManageMembergroups.template.php'': ''2.0'',\n	''TemplatesManageMembers.template.php'': ''2.0'',\n	''TemplatesManageNews.template.php'': ''2.0'',\n	''TemplatesManagePaid.template.php'': ''2.0'',\n	''TemplatesManagePermissions.template.php'': ''2.0'',\n	''TemplatesManageSearch.template.php'': ''2.0'',\n	''TemplatesManageSmileys.template.php'': ''2.0'',\n	''TemplatesMemberlist.template.php'': ''2.0'',\n	''TemplatesMessageIndex.template.php'': ''2.0'',\n	''TemplatesModerationCenter.template.php'': ''2.0'',\n	''TemplatesModlog.template.php'': ''2.0'',\n	''TemplatesMoveTopic.template.php'': ''2.0'',\n	''TemplatesNotify.template.php'': ''2.0'',\n	''TemplatesPackages.template.php'': ''2.0'',\n	''TemplatesPersonalMessage.template.php'': ''2.0'',\n	''TemplatesPoll.template.php'': ''2.0'',\n	''TemplatesPost.template.php'': ''2.0'',\n	''TemplatesPrintpage.template.php'': ''2.0'',\n	''TemplatesProfile.template.php'': ''2.0'',\n	''TemplatesRecent.template.php'': ''2.0'',\n	''TemplatesRegister.template.php'': ''2.0'',\n	''TemplatesReminder.template.php'': ''2.0'',\n	''TemplatesReports.template.php'': ''2.0'',\n	''TemplatesSearch.template.php'': ''2.0'',\n	''TemplatesSendTopic.template.php'': ''2.0'',\n	''TemplatesSettings.template.php'': ''2.0'',\n	''TemplatesSplitTopics.template.php'': ''2.0'',\n	''TemplatesStats.template.php'': ''2.0'',\n	''TemplatesThemes.template.php'': ''2.0'',\n	''TemplatesWho.template.php'': ''2.0'',\n	''TemplatesWireless.template.php'': ''2.0'',\n	''TemplatesXml.template.php'': ''2.0'',\n	''Templatesindex.template.php'': ''2.0''\n};\n\nwindow.smfLanguageVersions = {\n	''Admin'': ''2.0'',\n	''EmailTemplates'': ''2.0'',\n	''Errors'': ''2.0'',\n	''Help'': ''2.0'',\n	''index'': ''2.0.4'',\n	''Install'': ''2.0'',\n	''Login'': ''2.0'',\n	''ManageBoards'': ''2.0'',\n	''ManageCalendar'': ''2.0'',\n	''ManageMail'': ''2.0'',\n	''ManageMaintenance'': ''2.0'',\n	''ManageMembers'': ''2.0'',\n	''ManagePaid'': ''2.0'',\n	''ManagePermissions'': ''2.0'',\n	''ManageScheduledTasks'': ''2.0'',\n	''ManageSettings'': ''2.0'',\n	''ManageSmileys'': ''2.0'',\n	''Manual'': ''2.0'',\n	''ModerationCenter'': ''2.0'',\n	''Modifications'': ''2.0'',\n	''Modlog'': ''2.0'',\n	''Packages'': ''2.0'',\n	''PersonalMessage'': ''2.0'',\n	''Post'': ''2.0'',\n	''Profile'': ''2.0'',\n	''Reports'': ''2.0'',\n	''Search'': ''2.0'',\n	''Settings'': ''2.0'',\n	''Stats'': ''2.0'',\n	''Themes'': ''2.0'',\n	''Who'': ''2.0'',\n	''Wireless'': ''2.0''\n};\n', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (3, 'latest-news.js', '/smf/', 'language=%1$s&format=%2$s', '\nwindow.smfAnnouncements = [\n	{\n		subject: ''SMF 2.0.4 and 1.1.18 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=496403.0'',\n		time: ''February 01, 2013, 05:27:00 PM'',\n		author: ''emanuele'',\n		message: ''Critical security patches have been released, addressing few vulnerabilities in SMF 2.0.x and SMF 1.1.x. We urge all administrators to upgrade as soon as possible. Just visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0.3, 1.1.17 and 1.0.23 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=492786.0'',\n		time: ''December 16, 2012, 11:41:05 PM'',\n		author: ''emanuele'',\n		message: ''Security patches have been released, addressing a vulnerability in SMF 2.0.x, SMF 1.1.x and SMF 1.0.x. We urge all administrators to upgrade as soon as possible. Just visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0.2 and 1.1.16 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=463103.0'',\n		time: ''December 23, 2011, 12:41:31 AM'',\n		author: ''Norv'',\n		message: ''Critical security patches have been released, addressing vulnerabilities in SMF 2.0.x and SMF 1.1.x. We urge all administrators to upgrade as soon as possible. Just visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0.1 and 1.1.15 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=452888.0'',\n		time: ''September 18, 2011, 04:48:18 PM'',\n		author: ''Norv'',\n		message: ''Critical security patches have been released, addressing vulnerabilities in SMF 2.0 and SMF 1.1.x. We urge all administrators to upgrade as soon as possible. Just visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0 Gold'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=421547.0'',\n		time: ''June 04, 2011, 05:00:00 PM'',\n		author: ''Norv'',\n		message: ''SMF 2.0 has gone Gold! Please upgrade your forum from older versions, as 2.0 is now the stable version, and mods and themes will be built on it.''\n	},\n	{\n		subject: ''SMF 1.1.13, 2.0 RC4 security patch and SMF 2.0 RC5 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=421547.0'',\n		time: ''February 11, 2011, 03:16:35 PM'',\n		author: ''Norv'',\n		message: ''Simple Machines announces the release of important security patches for SMF 1.1.x and SMF 2.0 RC4, along with the fifth Release Candidate of SMF 2.0. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 2.0 RC4 and SMF 1.1.12 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=407256.0'',\n		time: ''November 01, 2010, 12:14:21 PM'',\n		author: ''Norv'',\n		message: ''Simple Machines is pleased to announce the release of the fourth Release Candidate of SMF 2.0, along with an important security patch for SMF 1.1.x. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 2.0 RC3 Public released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=369616.0'',\n		time: ''March 08, 2010, 06:03:11 PM'',\n		author: ''Aaron'',\n		message: ''Simple Machines is pleased to announce the release of the third Release Candidate of SMF 2.0. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 1.1.11 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=351341.0'',\n		time: ''December 01, 2009, 05:59:19 PM'',\n		author: ''SleePy'',\n		message: ''A patch has been released, addressing multiple vulnerabilites.  We urge all forum administrators to upgrade to 1.1.11. Simply visit the package manager to install the patch. Also for those still using the 1.0 branch, version 1.0.19 has been released.''\n	},\n	{\n		subject: ''SMF 2.0 RC2 Public released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=346813.0'',\n		time: ''November 08, 2009, 07:10:03 PM'',\n		author: ''Aaron'',\n		message: ''Simple Machines is very pleased to announce the release of the second Release Candidate of SMF 2.0. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 1.1.10 and 2.0 RC1.2 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=324169.0'',\n		time: ''July 14, 2009, 07:05:19 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released, addressing a few security vulnerabilites.  We urge all forum administrators to upgrade to either 1.1.10 or 2.0 RC1.2, depending on the current version. Simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1.9 and 2.0 RC1-1 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=311899.0'',\n		time: ''May 20, 2009, 08:40:41 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released, addressing multiple security vulnerabilites.  We urge all forum administrators to upgrade to either 1.1.9 or 2.0 RC1-1, depending on the current version. Simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0 RC1 Public Released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=290609.0'',\n		time: ''February 04, 2009, 11:10:01 PM'',\n		author: ''Compuart'',\n		message: ''Simple Machines are very pleased to announce the release of the first Release Candidate of SMF 2.0. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 1.1.8'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=290608.0'',\n		time: ''February 04, 2009, 11:08:44 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released, addressing multiple security vulnerabilites.  We urge all forum administrators to upgrade to SMF 1.1.8&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1.7'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=272861.0'',\n		time: ''November 07, 2008, 02:15:36 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released, addressing multiple security vulnerabilites.  We urge all forum administrators to upgrade to SMF 1.1.7&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1.6'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=260145.0'',\n		time: ''September 07, 2008, 04:38:05 AM'',\n		author: ''Compuart'',\n		message: ''A patch has been released fixing a few bugs and addressing a security vulnerability.  We urge all forum administrators to upgrade to SMF 1.1.6&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1.5'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=236816.0'',\n		time: ''April 20, 2008, 09:56:14 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released fixing a few bugs and addressing some security vulnerabilities.  We urge all forum administrators to upgrade to SMF 1.1.5&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0 Beta 3 Public Released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=228921.0'',\n		time: ''March 17, 2008, 03:20:21 PM'',\n		author: ''Grudge'',\n		message: ''Simple Machines are very pleased to announce the release of the first public beta of SMF 2.0. Please visit the Simple Machines site for more information on how you can help test this new release.''\n	},\n	{\n		subject: ''SMF 1.1.4'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=196380.0'',\n		time: ''September 24, 2007, 09:07:36 PM'',\n		author: ''Compuart'',\n		message: ''A patch has been released to address some security vulnerabilities discovered in SMF 1.1.3.  We urge all forum administrators to upgrade to SMF 1.1.4&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0 Beta 1 Released to Charter Members'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=190812.0'',\n		time: ''August 25, 2007, 07:29:25 AM'',\n		author: ''Grudge'',\n		message: ''Simple Machines are pleased to announce the first beta of SMF 2.0 has been released to our Charter Members. Visit the Simple Machines site for information on what\\''s new''\n	},\n	{\n		subject: ''SMF 1.1.3'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=178757.0'',\n		time: ''June 24, 2007, 09:52:40 PM'',\n		author: ''Thantos'',\n		message: ''A number of small bugs and a potential security issue have been discovered in SMF 1.1.2.  We urge all forum administrators to upgrade to SMF 1.1.3&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1.2'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=149553.0'',\n		time: ''February 11, 2007, 08:35:45 AM'',\n		author: ''Grudge'',\n		message: ''A patch has been released to address a number of outstanding bugs in SMF 1.1.1, including several around UTF-8 language support. In addition this patch offers improved image verification support and fixes a couple of low risk security related bugs. If you need any help upgrading please visit our forum.''\n	},\n	{\n		subject: ''SMF 1.1.1'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=134971.0'',\n		time: ''December 17, 2006, 09:33:41 AM'',\n		author: ''Grudge'',\n		message: ''A number of small bugs and a potential security issue have been discovered in SMF 1.1. We urge all forum administrators to upgrade to SMF 1.1.1 - simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 1.1'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=131008.0'',\n		time: ''December 02, 2006, 02:53:16 PM'',\n		author: ''Grudge'',\n		message: ''SMF 1.1 has gone gold!  If you are using an older version, please upgrade as soon as possible - many things have been changed and fixed, and mods and packages will expect you to be using 1.1.  If you need any help upgrading custom modifications to the new version, please feel free to ask us at our forum.''\n	},\n	{\n		subject: ''SMF 1.0.9 and patch for SMF 1.1 RC3'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=123285.0'',\n		time: ''October 29, 2006, 05:57:14 AM'',\n		author: ''Compuart'',\n		message: ''A security issue has been discovered in both SMF 1.0 and SMF 1.1. Therefore a patch has been released that will upgrade SMF 1.0.8 to 1.0.9 and update SMF 1.1 RC3. You are encouraged to update immediately, using the package manager or otherwise.''\n	},\n	{\n		subject: ''SMF 1.1 RC3'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=107112.0'',\n		time: ''August 21, 2006, 07:32:19 PM'',\n		author: ''Grudge'',\n		message: ''Release Candidate 3 of SMF 1.1 has been released! This is the final update to SMF 1.1 before it goes final - and includes UTF support as well as numerous bug fixes. Please read the announcement for details - and only upgrade if you are comfortable running software yet to go gold.''\n	},\n	{\n		subject: ''SMF 1.0.8'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=107135.0'',\n		time: ''August 21, 2006, 07:32:19 PM'',\n		author: ''Compuart'',\n		message: ''A security issue has been reported in PHP causing a vulnerability in SMF. A patch has been released to upgrade Simple Machines Forum from 1.0.7 to 1.0.8. You are encouraged to update immediately, using the package manager or otherwise.''\n	},\n	{\n		subject: ''SMF 1.0.7 and patch for SMF 1.1 RC2'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=78841.0'',\n		time: ''March 29, 2006, 05:32:12 PM'',\n		author: ''Compuart'',\n		message: ''A security issue has been discovered in both SMF 1.0 and SMF 1.1. Therefor a patch has been released that will upgrade SMF 1.0.6 to 1.0.7 and update SMF 1.1 RC2. You are encouraged to update immediately, using the package manager or otherwise.''\n	},\n	{\n		subject: ''SMF 1.0.6'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=68110.0'',\n		time: ''January 28, 2006, 06:36:25 AM'',\n		author: ''Grudge'',\n		message: ''SMF 1.0.6 has been released.  This release addresses a potential security issue as well as a few minor bugs found since the 1.0.5 release. You are encouraged to update immediately, using the package manager or otherwise. This update does not apply to the 1.1 line!''\n	},\n	{\n		subject: ''Bug in Firefox 1.5'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=66862.0'',\n		time: ''January 24, 2006, 08:09:45 AM'',\n		author: ''Grudge'',\n		message: ''There is a bug in Firefox 1.5 which can cause server issues for forums running SMF 1.1 (RC1/RC2). There is a simple fix which can be downloaded from the Simple Machines forum.''\n	},\n	{\n		subject: ''SMF 1.1 RC2'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=62731.0'',\n		time: ''December 31, 2005, 02:58:20 PM'',\n		author: ''Grudge'',\n		message: ''The second (and final) Release Candidate of SMF 1.1 has been released! Please read the announcement for details - and please update only if you are certain you are comfortable with software that hasn\\''t gone gold yet. There is no package manager style update for this version.''\n	}\n];\nif (window.smfVersion < "SMF 1.1")\n{\n	window.smfUpdateNotice = ''SMF 1.1 Final has now been released. To take advantage of the improvements available in SMF 1.1 we recommend upgrading as soon as is practical.'';\n	window.smfUpdateCritical = false;\n}\n\nif (document.getElementById("yourVersion"))\n{\n	var yourVersion = getInnerHTML(document.getElementById("yourVersion"));\n	if (yourVersion == "SMF 1.0.4")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_1-0-5_package.tar.gz";\n	else if (yourVersion == "SMF 1.0.5" || yourVersion == "SMF 1.0.6")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.7_1.1-RC2-1.tar.gz";\n		window.smfUpdateCritical = false;\n	}\n	else if (yourVersion == "SMF 1.0.7")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_1-0-8_package.tar.gz";\n	else if (yourVersion == "SMF 1.0.8")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1-0-9_1-1-rc3-1.tar.gz";\n	else if (yourVersion == "SMF 1.0.9")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_1-0-10_patch.tar.gz";\n	else if (yourVersion == "SMF 1.0.10" || yourVersion == "SMF 1.1.2")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.3_1.0.11.tar.gz";\n	else if (yourVersion == "SMF 1.0.11" || yourVersion == "SMF 1.1.3" || yourVersion == "SMF 2.0 beta 1")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.12_1.1.4_2.0.b1.1.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.0.12" || yourVersion == "SMF 1.1.4" || yourVersion == "SMF 2.0 beta 3 Public")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.13_1.1.5_2.0-b3.1.zip";\n	else if (yourVersion == "SMF 1.0.13" || yourVersion == "SMF 1.1.5")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.14_1.1.6.zip";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.0.14" || yourVersion == "SMF 1.1.6")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.15_1.1.7.zip";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.0.15" || yourVersion == "SMF 1.1.7")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.16_1.1.8.zip";\n		window.smfUpdateCritical = false;\n	}\n	else if (yourVersion == "SMF 1.0.16" || yourVersion == "SMF 1.1.8" || yourVersion == "SMF 2.0 RC1")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.17_1.1.9_2.0-RC1-1.zip";\n	else if (yourVersion == "SMF 1.0.17" || yourVersion == "SMF 1.1.9" || yourVersion == "SMF 2.0 RC1-1")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.18_1.1.10-2.0-RC1.2.zip";\n	else if (yourVersion == "SMF 1.0.18" || yourVersion == "SMF 1.1.10")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.19_1.1.11.zip";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.0.19" || yourVersion == "SMF 1.1.11")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.20_1.1.12.tar.gz";\n	}\n	else if (yourVersion == "SMF 1.0.20" || yourVersion == "SMF 1.1.12")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.21_1.1.13.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.14")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.15.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 2.0")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.1.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.15" || yourVersion == "SMF 1.0.21")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.22_1.1.16.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 2.0.1")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.2.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.16" || yourVersion == "SMF 1.0.22")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.23_1.1.17.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.17")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.18.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 2.0.2")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.3.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 2.0.3")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.4.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_1-1-1_patch.tar.gz";\n	else if (yourVersion == "SMF 1.1.1")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_1-1-2_patch.tar.gz";\n}\n\nif (document.getElementById(''credits''))\n	setInnerHTML(document.getElementById(''credits''), getInnerHTML(document.getElementById(''credits'')).replace(/anyone we may have missed/, ''<span title="And you thought you had escaped the credits, hadn\\''t you, Zef Hemel?">anyone we may have missed</span>''));\n', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (4, 'latest-packages.js', '/smf/', 'language=%1$s&version=%3$s', 'var actionurl = ''?action=admin;area=packages;sa=download;get;package='';if (typeof(window.smfForum_sessionvar) == "undefined")\n	window.smfForum_sessionvar = ''sesc'';\n\nif (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0")\n	window.smfLatestPackages = ''As was inevitable, a few small mistakes have been found in 1.0.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-1_update.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.1")\n	window.smfLatestPackages = ''A few problems have been found in the package manager\\''s modification code, among a few other issues.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-2_update.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.2")\n	window.smfLatestPackages = ''A problem has been found in the system that sends critical database messages.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-3_package.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.3")\n	window.smfLatestPackages = ''A few bugs have been fixed since SMF 1.0.3, and a problem with parsing nested BBC tags addressed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-4_package.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled. Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.4")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.4.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-5_package.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.5")\n	window.smfLatestPackages = ''A bbc security issue has been identified in SMF 1.0.5.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.7_1.1-RC2-1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.6")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.6.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.7_1.1-RC2-1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.7")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.7.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-8_package.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\n\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.8")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.8.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1-0-9_1-1-rc3-1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.9")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.9.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-0-10_patch.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.10")\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.0.10.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.3_1.0.11.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.11")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.11 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.12_1.1.4_2.0.b1.1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.12.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.12")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.12 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.13_1.1.5_2.0-b3.1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.12.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.13")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.13 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.14_1.1.6.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.14.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.14")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.14. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.15_1.1.7.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.15.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.15")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.15. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.16_1.1.8.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.16.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.16")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.16. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.17_1.1.9_2.0-RC1-1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.17.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.17")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.17. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.18_1.1.10-2.0-RC1.2;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.18.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.18")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.18. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.19_1.1.11.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.19.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.19")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.19. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.20_1.1.12.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.20.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.20")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.20. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.21_1.1.13.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.21.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.21")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.0.21. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.22_1.1.16.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.22.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.22")\n	window.smfLatestPackages = ''A security vulnerability has been identified in SMF 1.0.22. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.23_1.1.17.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.0.23.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.0.23")\n	window.smfLatestPackages = ''SMF 1.0 was released to the world in December 2004 and has been supported for more than eight years. Starting from the 1st of January 2013 it will not receive security updates any more. Anyone still using a 1.0 release should investigate migrating to the lates SMF version. Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1 Beta 2" && !in_array("smf:smf_1-1-beta2-fix1", window.smfInstalledPackages))\n	window.smfLatestPackages = ''A few bugs have been fixed since SMF 1.1 Beta 2, and a problem with parsing nested BBC tags addressed.  You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-1-beta2-fix1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily fix the problem.<br /><br />Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> or in the helpdesk if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1 RC2" && !in_array("smf:smf-1.0.7", window.smfInstalledPackages))\n	window.smfLatestPackages = ''A security issue has been identified in SMF 1.1 RC2. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.7_1.1-RC2-1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to easily update yourself to the latest version.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1 RC2" && !in_array("smf:smf_1-1-rc2-2", window.smfInstalledPackages))\n	window.smfLatestPackages = ''A bug in PHP causes a vulnerability in SMF 1.1 RC2-1. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-1-rc2-2_package.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to patch your version of 1.1 RC2 to 1.1 RC2-2.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1")\n	window.smfLatestPackages = ''A number of small bugs and a security issue have been identified in SMF 1.1 Final. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-1-1_patch.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.1.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.1")\n	window.smfLatestPackages = ''A number of bugs and a couple of low risk security issues have been identified in SMF 1.1.1 - and some improvements have been made to the visual verification images on registration. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_1-1-2_patch.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.2.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.2")\n	window.smfLatestPackages = ''A number of bugs and a couple of low risk security issues have been identified in SMF 1.1.2 - and some improvements have been made to the package manager. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.3_1.0.11.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.3.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.3")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.3 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.12_1.1.4_2.0.b1.1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.4.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.4")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.4 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.13_1.1.5_2.0-b3.1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.5.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.5")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.5 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.14_1.1.6.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.6.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.6")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.6. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.15_1.1.7.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.7.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.7")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.7. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.16_1.1.8.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.8.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.8")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.8. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.17_1.1.9_2.0-RC1-1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.9.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.9")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.9. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.18_1.1.10-2.0-RC1.2.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.10.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.10")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.10. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.19_1.1.11.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.11.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.11")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.11. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.20_1.1.12.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.12.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.12")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.12. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.21_1.1.13.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.13.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.13")\n	window.smfLatestPackages = ''A security vulnerability have been identified in SMF 1.1.13. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.14.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.14.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled if you use the full package.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.14")\n	window.smfLatestPackages = ''A security vulnerability have been identified in SMF 1.1.14. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.15.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.15.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled if you use the full package.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.15")\n	window.smfLatestPackages = ''A couple of security vulnerabilities have been identified in SMF 1.1.15. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.22_1.1.16.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.16.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled if you use the full package.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.16")\n	window.smfLatestPackages = ''A security vulnerability has been identified in SMF 1.1.16. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.23_1.1.17.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.17.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled if you use the full package.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 1.1.17")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 1.1.17. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.18.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 1.1.18.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled if you use the full package.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0 beta 1")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0 beta 1 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.12_1.1.4_2.0.b1.1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 2.0 beta 1.1.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0 Beta 3 Public")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0 beta 3 as well as a few small bugs. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.13_1.1.5_2.0-b3.1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 2.0 beta 3.1.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0 RC1")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0 RC1. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.17_1.1.9_2.0-RC1-1.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 2.0-RC1-1.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0 RC1-1")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0 RC1-1. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.18_1.1.10-2.0-RC1.2.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your version of SMF to 2.0-RC1.2 .<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0 RC4"  && typeof(window.smfRC4patch) == "undefined")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0 RC4. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0-RC4_security.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to install the security patch for SMF 2.0 RC4.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0")\n	window.smfLatestPackages = ''A few security vulnerabilities have been identified in SMF 2.0. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to update your forum.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0.1")\n	window.smfLatestPackages = ''A few security vulnerabilities and bugs in SMF 2.0.1 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.2.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0.2")\n	window.smfLatestPackages = ''A security vulnerability and few bugs in SMF 2.0.2 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.3.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) != "undefined" && window.smfVersion == "SMF 2.0.3")\n	window.smfLatestPackages = ''A few security vulnerabilities in SMF 2.0.3 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.4.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum.<br /><br />If you have any problems applying it, you can use the version posted on the downloads page - although, any modifications you have installed will need to be uninstalled.  Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\nelse if (typeof(window.smfVersion) == "undefined")\n	window.smfLatestPackages = ''For the package manager to function properly, please upgrade to the latest version of SMF.'';\nelse\n{\nvar smf_modificationInfo = {\n\n	3765: {\n		name: ''Men of Star Trek Avatars by BK-Modding 1.0'',\n		versions: [''72'', ''73''],\n		desc: ''BK Modding Men of Star Trek Avatars<br /><br />Made by: <a href="http://www.simplemachines.org/community/index.php?action=profile;u=194815" class="bbc_link" target="_blank">BK Modding Team</a> - <a href="http://www.bkmodding.com/" class="bbc_link" target="_blank">BK Modding</a><br /><br />These Star Trek Avatars are perfect for any Star Trek fan.<br /><br />Star Trek®, Star Trek: The Next Generation®, Star Trek: Deep Space Nine®, Star Trek: Voyager®, Star Trek: Enterprise®, and related Star Trek marks are registered trademarks and/or copyrights of Paramount Pictures, CBS, and their respective owners.<br /><br /><div align="center"><a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank"><img src="http://i.creativecommons.org/l/by-sa/3.0/88x31.png" alt="" class="bbc_img" /></a><br />This work is licensed under a <a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>.</div>'',\n		file: ''BK-Modding-Star-Trek-Men-Avatars.zip''\n	},\n	3764: {\n		name: ''Women of Star Trek Avatars by BK-Modding 1.0'',\n		versions: [''72'', ''73''],\n		desc: ''BK Modding Women of Star Trek Avatars<br /><br />Made by: <a href="http://www.simplemachines.org/community/index.php?action=profile;u=194815" class="bbc_link" target="_blank">BK Modding Team</a> - <a href="http://www.bkmodding.com/" class="bbc_link" target="_blank">BK Modding</a><br /><br />These Star Trek Avatars are perfect for any Star Trek fan.<br /><br />Star Trek®, Star Trek: The Next Generation®, Star Trek: Deep Space Nine®, Star Trek: Voyager®, Star Trek: Enterprise®, and related Star Trek marks are registered trademarks and/or copyrights of Paramount Pictures, CBS, and their respective owners.<br /><br /><div align="center"><a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank"><img src="http://i.creativecommons.org/l/by-sa/3.0/88x31.png" alt="" class="bbc_img" /></a><br />This work is licensed under a <a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>.</div>'',\n		file: ''BK-Modding-Star-Trek-Women-Avatars.zip''\n	},\n	3760: {\n		name: ''Star Trek Voyager Avatars by BK-Modding 1.0'',\n		versions: [''72'', ''73''],\n		desc: ''BK Modding Star Trek Voyager Avatars<br /><br />Made by: <a href="http://www.simplemachines.org/community/index.php?action=profile;u=194815" class="bbc_link" target="_blank">BK Modding Team</a> - <a href="http://www.bkmodding.com/" class="bbc_link" target="_blank">BK Modding</a><br /><br />These Star Trek Avatars are perfect for any Star Trek fan.<br /><br />Star Trek®, Star Trek: The Next Generation®, Star Trek: Deep Space Nine®, Star Trek: Voyager®, Star Trek: Enterprise®, and related Star Trek marks are registered trademarks and/or copyrights of Paramount Pictures, CBS, and their respective owners.<br /><br /><div align="center"><a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank"><img src="http://i.creativecommons.org/l/by-sa/3.0/88x31.png" alt="" class="bbc_img" /></a><br />This work is licensed under a <a href="http://creativecommons.org/licenses/by-sa/3.0/deed.en_US" class="bbc_link" target="_blank">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>.</div>'',\n		file: ''BK-Modding-Star-Trek-VOY-Avatars.zip''\n	},\n	3315: {\n		name: ''Anti-SID canonical tag - without PHPSESSID param 0.5'',\n		versions: [''67'', ''72'', ''68'', ''73''],\n		desc: ''Add canonical tag for main page, boards and topics pages without SID (PHPSESSID) param.<br />For SMF 2.0.x also lock default canonical tag.<br /><br />Demo <a href="http://sibsp.maestrosite.ru/forum/" class="bbc_link" target="_blank">http://sibsp.MaestroSite.ru/forum/</a><br />Support <a href="http://maestrosite.ru/" class="bbc_link" target="_blank">http://MaestroSite.ru/</a><br />E-mail <a href="mailto:smf@maestrosite.ru" class="bbc_email">smf@maestrosite.ru</a><br /><br />This work is licensed under a <a href="http://creativecommons.org/licenses/by-sa/3.0/" class="bbc_link" target="_blank">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>.<br /><br />Changelog:<br />v0.6<br />+ canonical url for calendar<br />v0.5<br />! bugfix BoardIndex url for SMF 2.0.x with &quot;queryless_url&quot; mode<br /><hr />Вывод тега &quot;canonical&quot; для главной страницы, страниц разделов и тем, строго без сессисоной переменной (даже для первой загрузки страницы)<br /><br />Если вы используете портал, или для индексации разрешены профили пользователей, то установите версию 0.5. В ином случае достаточно будет 0.2<br /><br />Пример работы мода <a href="http://sibsp.maestrosite.ru/forum/" class="bbc_link" target="_blank">http://sibsp.MaestroSite.ru/forum/</a><br />Сопровождение <a href="http://maestrosite.ru/" class="bbc_link" target="_blank">http://MaestroSite.ru/</a><br />E-mail <a href="mailto:smf@maestrosite.ru" class="bbc_email">smf@maestrosite.ru</a><br /><br />Этот мод доступен по <a href="http://creativecommons.org/licenses/by-sa/3.0/" class="bbc_link" target="_blank">лицензии Creative Commons Attribution-ShareAlike (Атрибуция — С сохранением условий) 3.0 Непортированная</a>.<br /><br />Список изменений:<br />v0.6<br />+ канонический адрес для календаря<br />v0.5<br />! ошибка формирования адреса главной страницы для версии SMF 2.0 в режиме ЧПУ. '',\n		file: ''maestrosite-canonical-0.6.tar.gz''\n	}};\nvar smf_latestModifications = [3765, 3764, 3760];\n\nfunction smf_packagesMoreInfo(id)\n{\n	window.smfLatestPackages_temp = document.getElementById("smfLatestPackagesWindow").innerHTML;\n\n	setInnerHTML(document.getElementById("smfLatestPackagesWindow"),\n	''\\\n		<h3 style="margin: 0; padding: 4px;">'' + smf_modificationInfo[id].name + ''</h3>\\\n		<h4 style="padding: 4px; margin: 0;"><a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/'' + id + ''/'' + smf_modificationInfo[id].file + '';'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">Install Now!</a></h4>\\\n		<div style="margin: 4px;">'' + smf_modificationInfo[id].desc.replace(/<a href/g, ''<a href'') + ''</div>\\\n		<div class="titlebg" style="padding: 4px; margin: 0;"><a href="javascript:smf_packagesBack();void(0);">(go back)</a></div>'');\n}\n\nfunction smf_packagesBack()\n{\n	setInnerHTML(document.getElementById("smfLatestPackagesWindow"), window.smfLatestPackages_temp);\n	window.scrollTo(0, findTop(document.getElementById("smfLatestPackagesWindow")) - 10);\n}\n\nwindow.smfLatestPackages = ''\\\n	<div id="smfLatestPackagesWindow"style="overflow: auto;">\\\n		<h3 style="margin: 0; padding: 4px;">New Packages:</h3>\\\n		<img src="http://www.simplemachines.org/smf/images/package.png" width="102" height="98" style="float: right; margin: 4px;" alt="(package)" />\\\n		<ul style="list-style: none; margin-top: 3px; padding: 0 4px;">'';\n\nfor (var i = 0; i < smf_latestModifications.length; i++)\n{\n	var id_mod = smf_latestModifications[i];\n\n	window.smfLatestPackages += ''<li><a href="javascript:smf_packagesMoreInfo('' + id_mod + '');void(0);">'' + smf_modificationInfo[id_mod].name + ''</a></li>'';\n}\n\nwindow.smfLatestPackages += ''\\\n		</ul>'';\n\nif (typeof(window.smfVersion) != "undefined" && (window.smfVersion < "SMF 1.0.6" || (window.smfVersion == "SMF 1.1 RC2" && !in_array(''smf:smf-1.0.7'', window.smfInstalledPackages))))\n	window.smfLatestPackages += ''\\\n		<h3 class="error" style="margin: 0; padding: 4px;">Updates for SMF:</h3>\\\n		<div style="padding: 0 4px;">\\\n			<a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.7_1.1-RC2-1.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">Security update (X-Forwarded-For header vulnerability)</a>\\\n		</div>'';\nelse\n	window.smfLatestPackages += ''\\\n		<h3 style="margin: 0; padding: 4px;">Package of the Moment:</h3>\\\n		<div style="padding: 0 4px;">\\\n			<a href="javascript:smf_packagesMoreInfo(3315);void(0);">Anti-SID canonical tag - without PHPSESSID param 0.5</a>\\\n		</div>'';\n\nwindow.smfLatestPackages += ''\\\n	</div>'';\n}\n\nfunction findTop(el)\n{\n	if (typeof(el.tagName) == "undefined")\n		return 0;\n\n	var skipMe = in_array(el.tagName.toLowerCase(), el.parentNode ? ["tr", "tbody", "form"] : []);\n	var coordsParent = el.parentNode ? "parentNode" : "offsetParent";\n\n	if (el[coordsParent] == null || typeof(el[coordsParent].offsetTop) == "undefined")\n		return skipMe ? 0 : el.offsetTop;\n	else\n		return (skipMe ? 0 : el.offsetTop) + findTop(el[coordsParent]);\n}\n\nfunction in_array(item, array)\n{\n	for (var i in array)\n	{\n		if (array[i] == item)\n			return true;\n	}\n\n	return false;\n}\n', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (5, 'latest-smileys.js', '/smf/', 'language=%1$s&version=%3$s', 'var actionurl = ''?action=admin;area=smileys;sa=install;set_gz='';\nif (typeof(window.smfForum_sessionvar) == "undefined")\n	window.smfForum_sessionvar = ''sesc'';\n\nvar smf_smileysInfo = {\n\n	3628: {\n		name: ''BBPh Smileys 1.0'',\n		versions: [''72'', ''73''],\n		desc: ''Made to easily replace default ones.<br /><br /><img src="http://dl.dropbox.com/u/1684364/arc/bbph.gif" alt="" class="bbc_img" /><br /><br />These are just my favorites since the first forum I ever lived on was based on phpBB. Some are animated. package-info.xml included.<br /><br />Original smileys belong to phpBB. Some minor mods by me.'',\n		file: ''bbph.zip''\n	},\n	3290: {\n		name: ''Blue Smiley Animation 2.0'',\n		versions: [''67'', ''72'', ''68'', ''73''],\n		desc: ''<div align="center"><span style="font-size: 1.45em;" class="bbc_size"><span style="color: green;" class="bbc_color"><strong>Blue Smiley Animation</strong></span></span></div><div align="center"><a href="http://www.simplemachines.org/community/index.php?topic=464629.0" class="bbc_link" target="_blank">English Support</a> | <a href="http://smf-portal.hu" class="bbc_link" target="_blank">Hungarian Support</a> | <a href="http://custom.simplemachines.org/mods/index.php?action=profile;u=221448" class="bbc_link" target="_blank">My Mods</a></div><hr /><br /><strong>Autor:</strong><br /><a href="http://www.simplemachines.org/community/index.php?action=profile;u=221448" class="bbc_link" target="_blank">WasdMan</a> and Cserrobi<br /><br /><strong>Description (Hungarian):</strong> <br />Kék mosolygó arcok<br /><br /><strong>Description (English):</strong><br />Blue Smiley package<br /><br /><img src="http://smf-portal.hu/Download/Egyeb/keksmiley.png" alt="" width="600" height="237" class="bbc_img resized" /><br /><br /><strong>Compatibility: </strong><br /><ul class="bbc_list"><li>1.0 - 1.99.99</li><li>2.0 - 2.99.99</li></ul>'',\n		file: ''BlueSmileyAnimation_2.1_UNI.zip''\n	},\n	3269: {\n		name: ''Christmas Smileys 1.1'',\n		versions: [''64'', ''67'', ''70'', ''72'', ''65'', ''68'', ''71'', ''73''],\n		desc: ''<div align="center"><span style="font-family: times new roman;" class="bbc_font"><span style="font-size: 24pt;" class="bbc_size"><span style="color: #654321;" class="bbc_color">Christmas Smileys</span></span></span><br /><table class="bbc_table"><tr><td><div style="text-align: right;"><strong>Created By:</strong> </div></td><td><a href="http://www.simplemachines.org/community/index.php?action=profile;u=200419" class="bbc_link" target="_blank">-=[Vyorel]=-</a><br />(<a href="http://custom.simplemachines.org/mods/index.php?action=search;author=200419" class="bbc_link" target="_blank">View my other mods here</a>)</td></tr><tr><td><div style="text-align: right;"><strong>Latest Version:</strong> </div></td><td>1.1</td></tr></table></div><br /><span style="font-family: times new roman;" class="bbc_font"><span style="font-size: 14pt;" class="bbc_size"><span style="color: #654321;" class="bbc_color">Summary</span></span></span><br /><br />This package contains 23 Christmas Smileys.<br /><br />You can install it using the package manager and then use the Smileys and message icons menu (Smileys and Message Icons -&gt; smiley sets new smiley set) to import the smiley&#039;s.<br /><br /><br /><span style="font-family: times new roman;" class="bbc_font"><span style="font-size: 14pt;" class="bbc_size"><span style="color: #654321;" class="bbc_color">Disclaimer</span></span></span><br />This Smileys are copyrighted to <a href="http://www.freeemoticonsandsmileys.com" class="bbc_link" target="_blank">www.freeemoticonsandsmileys.com</a> and all right are reserved.<br /><br /><div align="center"><a href="http://www.xerom-zone.com" class="bbc_link" target="_blank"><img src="http://www.xerom-zone.com/Themes/XeromTheme/images/custom/logo.png" alt="" class="bbc_img" /></a></div>'',\n		file: ''ChristmasSmileys.zip''\n	},\n	3230: {\n		name: ''Yellow Emoticons v1'',\n		versions: [''65'', ''68''],\n		desc: ''<div align="center"><img src="http://bit.ly/kZVDB6" alt="" width="443" height="115" class="bbc_img resized" /></div><br /><div align="center"><span style="text-shadow: black 1px 1px 1px"><span style="color: purple;" class="bbc_color"><span style="font-size: 16pt;" class="bbc_size"><strong>Yellow Emoticons</strong></span></span></span><br /><strong>Developed by</strong> <strong><a href="http://www.smfsimple.com/index.php?action=profile;u=1045" class="bbc_link" target="_blank">Cesar</a></strong> <strong>for </strong><strong><a href="http://www.smfsimple.com" class="bbc_link" target="_blank">SMFSimple.com</a></strong><br /><em><strong>SMF 2.0 - 2.0.1</strong></em></div><br /><hr /><br /><div align="center"><span style="text-shadow: black 1px 1px 1px"><span style="color: orange;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size"><strong>El soporte oficial de los desarrolladores de nuestros mods lo encontraras en SMFSimple.com<br />Official Support in <a href="http://www.SmfSimple.com" class="bbc_link" target="_blank">www.SmfSimple.com</a></strong></span></span></span></div><br /><hr /><br /><span style="text-shadow: black 1px 1px 1px"><span style="color: orange;" class="bbc_color"><span style="font-size: 13pt;" class="bbc_size"><span class="bbc_u"><strong>Description:</strong></span></span></span></span><br /><em><strong>Emoticons Pack created by <a href="http://lucasrib.deviantart.com/" class="bbc_link" target="_blank">~LucasRib</a> and packaged by Cesar to SmfSimple.com</strong></em><br /><br /><span style="text-shadow: black 1px 1px 1px"><span style="color: orange;" class="bbc_color"><span style="font-size: 13pt;" class="bbc_size"><span class="bbc_u"><strong>Descripcion:</strong></span></span></span></span><br /><em><strong>Pack de Emoticones creados por <a href="http://lucasrib.deviantart.com/" class="bbc_link" target="_blank">~LucasRib</a> y empaquetados para SmfSimple.com por Cesar</strong></em><br /><br /><hr /><br /><div align="center"><span style="text-shadow: black 1px 1px 1px"><span style="color: red;" class="bbc_color"><span style="font-size: 13pt;" class="bbc_size"><strong>Screenshots | Imagenes</strong></span></span></span></div><br /><div align="center"><img src="http://i.imgur.com/LCvCs.png" alt="" width="457" height="233" class="bbc_img resized" /></div><br /><br /><br /><hr /><span style="color: teal;" class="bbc_color"><span class="bbc_u"><strong>Language Support | Lenguajes Soportados</strong></span></span><br /><span style="color: teal;" class="bbc_color"><strong>- English<br />- Spanish_latin<br />- Spanish_latin-utf8<br />- Spanish_es<br />- Spanish_es-utf8</strong></span><br /><hr /><br /><div align="center"><span style="text-shadow: black 1px 1px 1px"><span style="color: green;" class="bbc_color"><span style="font-size: 15pt;" class="bbc_size"><strong>Yellow Emoticons</strong></span></span></span></div><br /><div align="center"><span style="text-shadow: black 1px 1px 1px"><span style="color: green;" class="bbc_color"><span style="font-size: 13pt;" class="bbc_size"><strong>Copyright 2011 | <a href="http://www.smfsimple.com" class="bbc_link" target="_blank">SMFSimple.com</a></strong></span></span></span></div><br /><div align="center"><a href="http://creativecommons.org/licenses/by-nc-sa/3.0/" class="bbc_link" target="_blank"><img src="http://i.creativecommons.org/l/by-nc-sa/3.0/88x31.png" alt="" width="88" height="31" class="bbc_img resized" /></a></div>'',\n		file: ''yellow.zip''\n	},};\nvar smf_latestSmileys = [3628, 3290, 3269];\n\nfunction smf_packagesMoreInfo(id)\n{\n	window.smfLatestSmileys_temp = document.getElementById("smfLatestSmileysWindow").innerHTML;\n\n	setInnerHTML(document.getElementById("smfLatestSmileysWindow"),\n	''\\\n		<h3 style="margin: 0; padding: 4px;">'' + smf_smileysInfo[id].name + ''</h3>\\\n		<h4 style="padding: 4px; margin: 0;"><a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/'' + id + ''/'' + smf_smileysInfo[id].file + '';'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">Install Now!</a></h4>\\\n		<div style="margin: 4px;">'' + smf_smileysInfo[id].desc.replace(/<a href/g, ''<a href'') + ''</div>\\\n		<div class="titlebg" style="padding: 4px; margin: 0;"><a href="javascript:smf_packagesBack();void(0);">(go back)</a></div>'');\n}\n\nfunction smf_packagesBack()\n{\n	setInnerHTML(document.getElementById("smfLatestSmileysWindow"), window.smfLatestSmileys_temp);\n	window.scrollTo(0, findTop(document.getElementById("smfLatestSmileysWindow")) - 10);\n}\n\nwindow.smfLatestSmileys = ''\\\n	<div id="smfLatestSmileysWindow" style="overflow: auto;">\\\n		<img src="http://www.simplemachines.org/smf/images/smileys.png" width="102" height="98" style="float: right; margin: 4px;" alt="(package)" />\\\n		<h3 style="margin: 0; padding: 4px;">Smiley of the Moment:</h3>\\\n		<div style="padding: 0 4px;">\\\n			<a href="javascript:smf_packagesMoreInfo(3230);void(0);">Yellow Emoticons v1</a>\\\n		</div>'';\n\nwindow.smfLatestSmileys += ''\\\n		<h3 style="margin: 0; padding: 4px;">New Smileys:</h3>\\\n		<ul style="list-style: none; margin-top: 3px; padding: 0 4px;">'';\n\nfor (var i = 0; i < smf_latestSmileys.length; i++)\n{\n	var id_mod = smf_latestSmileys[i];\n\n	window.smfLatestSmileys += ''<li><a href="javascript:smf_packagesMoreInfo('' + id_mod + '');void(0);">'' + smf_smileysInfo[id_mod].name + ''</a></li>'';\n}\n\nwindow.smfLatestSmileys += ''\\\n		</ul>'';\n\nwindow.smfLatestSmileys += ''\\\n	</div>'';\n\nfunction findTop(el)\n{\n	if (typeof(el.tagName) == "undefined")\n		return 0;\n\n	var skipMe = in_array(el.tagName.toLowerCase(), el.parentNode ? ["tr", "tbody", "form"] : []);\n	var coordsParent = el.parentNode ? "parentNode" : "offsetParent";\n\n	if (el[coordsParent] == null || typeof(el[coordsParent].offsetTop) == "undefined")\n		return skipMe ? 0 : el.offsetTop;\n	else\n		return (skipMe ? 0 : el.offsetTop) + findTop(el[coordsParent]);\n}\n\nfunction in_array(item, array)\n{\n	for (var i in array)\n	{\n		if (array[i] == item)\n			return true;\n	}\n\n	return false;\n}', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (6, 'latest-support.js', '/smf/', 'language=%1$s&version=%3$s', 'window.smfLatestSupport = ''<div style="font-size: 0.85em;"><div style="font-weight: bold;">SMF 2.0.4</div>Few vulnerabilities have been fixed in this new release.  Please <a href="http://www.simplemachines.org/download.php">try it</a> before requesting support.</div>'';\n\nif (document.getElementById(''credits''))\n	setInnerHTML(document.getElementById(''credits''), getInnerHTML(document.getElementById(''credits'')).replace(/thank you!/, ''<span onclick="alert(\\''Kupo!\\'');">thank you!</span>''));\n', 'text/javascript');
INSERT INTO `admin_info_files` VALUES (7, 'latest-themes.js', '/smf/', 'language=%1$s&version=%3$s', '\r\nvar smf_themeInfo = {\r\n	2497: {\r\n		name: ''FreshLooks - MultiColor'',\r\n		desc: ''<span style="color: green;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size">FreshLooks - MultiColor</span></span><br /><hr /><strong> By : Ricky. |&nbsp; <a href="http://ifandbut.com/talk/index.php?topic=101.0" class="bbc_link" target="_blank">Theme Support</a>&nbsp; | <a href="http://custom.simplemachines.org/themes/index.php?action=profile;u=34192" class="bbc_link" target="_blank">My More Themes</a> <br />For SMF 2.0 , SMF 2.0.1<br /></strong><br /><br />A minimal theme with various colors variants including <strong>Default Green, Blue Pinch, Black Touch, Orange it and Vibrant Red</strong>.&nbsp; You can change colors from Admin panel or allow user to select their own color from their profile.&nbsp; This is a light theme using minimal images but still giving you&nbsp; nice colorful layout.<br /><br /><br /><span style="color: green;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size">Features</span></span><br /><hr /><ul class="bbc_list"><li>Allows you to change color from Admin Panel</li><li>A Warm theme</li><li>Fluid Width</li><li>Utilizing CSS3 supported by all modern browser</li><li>Allows you to add custom copyright in footer</li></ul><br /><br /><br /><span style="color: green;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size">Changing Colors from Admin Panel</span></span><br /><hr />Goto<br /><strong>Admin --&gt; Configuration --&gt; Current Theme</strong><br />From there in drop down you can select color variation you want. <br /><img src="http://www.simplemachines.org/community/index.php?action=dlattach;topic=454450.0;attach=188135;image" alt="" class="bbc_img" /><br /><br /><span style="color: green;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size">Updates</span></span><br /><hr />Nov,03-2011: Improved theme so that you can use big logo without breaking layout. <br />'',\r\n		file: ''freshlooks.zip'',\r\n		author: ''Ricky.''\r\n	},\r\n	2723: {\r\n		name: ''Sinister'',\r\n		desc: ''Dark styled theme in Gray, Black and Red for SMF 2.0.x<br /><br />Features social icons in user bar that can be activated/deactivated and links edited from within current theme options.<br /><br />License - Read included text file.<br /><br />License in brief, you can make any changes to this theme to fit your needs, however under no circumstance are you allowed to make any changes to the copyright link.<br /><br /><img src="http://i.imgur.com/JBaQ77f.png" alt="" width="600" height="384" class="bbc_img resized" /><br /><br /><span style="color: teal;" class="bbc_color">This theme uses css3, therefor may not work correctly in older type browsers.</span>'',\r\n		file: ''Sinister 2.0.x.zip'',\r\n		author: ''&#039;Trax&#039;''\r\n	},\r\n	2722: {\r\n		name: ''Teknomaxi'',\r\n		desc: ''This theme may not work properly in old and non CSS3 supported browsers.<br /><br />License - Read included text file.<br /><br />License in brief, you can make any changes to this theme to fit your needs, however under no circumstance are you allowed to make any changes to the copyright link.<br /><br /><a href="http://theme.teknoromi.com/index.php?theme=4" class="bbc_link" target="_blank">Demo</a><br /><a href="http://teknoromi.com/index.php" class="bbc_link" target="_blank">Demo2</a>'',\r\n		file: ''Teknomaxi.zip'',\r\n		author: ''snrj''\r\n	},\r\n	2718: {\r\n		name: ''Origami'',\r\n		desc: ''This theme may not work properly in old and non CSS3 supported browsers.<br />Demo is available <a href="http://demo.smf.net.pl/smf/index.php?theme=16" class="bbc_link" target="_blank"><span class="bbc_u"><strong>here</strong></span></a>'',\r\n		file: ''Origami_SMF2.zip'',\r\n		author: ''CrimeS''\r\n	},\r\n	1846: {\r\n		name: ''Nly Grey'',\r\n		desc: ''<span style="color: red;" class="bbc_color"><strong>New:</strong></span> smf 1.1.13 updated.<br /><br />Nly Grey Theme<br /><br /><a href="http://www.simpleturk.com/forum/" class="bbc_link" target="_blank">Simpleturk.com - SMF Turkish Support</a>'',\r\n		file: ''nly-grey(new).zip'',\r\n		author: ''N a t i''\r\n	}\r\n};\r\nvar smf_featured = 2497;\r\nvar smf_random = 1846;\r\nvar smf_latestThemes = [2723, 2722, 2718];\r\nfunction smf_themesMoreInfo(id)\r\n{\r\n	window.smfLatestThemes_temp = document.getElementById("smfLatestThemesWindow").innerHTML;\n\n	// !!! Why not just always auto?\n	document.getElementById("smfLatestThemesWindow").style.overflow = "auto";\n	setInnerHTML(document.getElementById("smfLatestThemesWindow"),\n	''\\\n		<h3 style="margin: 0; padding: 4px;">'' + smf_themeInfo[id].name + ''</h3>\\\r\n		<h4 style="margin: 0;padding: 4px;"><a href="http://custom.simplemachines.org/themes/index.php?lemma='' + id + ''">View Theme Now!</a></h4>\\\r\n		<div style="overflow: auto;">\\\r\n			<img src="http://custom.simplemachines.org/themes/index.php?action=download;lemma=''+id+'';image=thumb" alt="" style="float: right; margin: 10px;" />\\\r\n			<div style="padding:8px;">'' + smf_themeInfo[id].desc.replace(/<a href/g, ''<a href'') + ''</div>\\\r\n		</div>\\\r\n		<div style="padding: 4px;" class="smalltext"><a href="javascript:smf_themesBack();void(0);">(go back)</a></div>'');\n}\r\n\r\nfunction smf_themesBack()\r\n{\r\n	document.getElementById("smfLatestThemesWindow").style.overflow = "";\n	setInnerHTML(document.getElementById("smfLatestThemesWindow"), window.smfLatestThemes_temp);\n	window.scrollTo(0, findTop(document.getElementById("smfLatestThemesWindow")) - 10);\r\n}\r\n\r\nwindow.smfLatestThemes = ''\\\r\n	<div id="smfLatestThemesWindow">\\\r\n		<div>\\\r\n			<img src="http://www.simplemachines.org/smf/images/themes.png" width="102" height="98" style="float: right; margin: 0 0 10px 10px;" alt="(package)" />\\\r\n			<ul style="list-style: none; padding: 0; margin: 0 0 0 5px;">'';\r\nfor(var i=0; i < smf_latestThemes.length; i++)\r\n{\r\n	var id_theme = smf_latestThemes[i];\r\n	window.smfLatestThemes += ''\\\r\n				<li style="list-style: none;"><a href="javascript:smf_themesMoreInfo('' + id_theme + '');void(0);">'' + smf_themeInfo[id_theme].name + '' by '' + smf_themeInfo[id_theme].author + ''</a></li>'';\r\n}\r\n\r\nwindow.smfLatestThemes += ''\\\r\n			</ul>'';\r\nif ( smf_featured !=0 || smf_random != 0 )\r\n{\r\n\r\n	if ( smf_featured != 0 )\r\n		window.smfLatestThemes += ''\\\r\n				<h4 style="padding: 4px 4px 0 4px; margin: 0;">Featured Theme</h4>\\\r\n				<p style="padding: 0 4px; margin: 0;">\\\r\n					<a href="javascript:smf_themesMoreInfo(''+smf_featured+'');void(0);">''+smf_themeInfo[smf_featured].name + '' by '' + smf_themeInfo[smf_featured].author+''</a>\\\r\n				</p>'';\r\n	if ( smf_random != 0 )\r\n		window.smfLatestThemes += ''\\\r\n				<h4 style="padding: 4px 4px 0 4px;margin: 0;">Theme of the Moment</h4>\\\r\n				<p style="padding: 0 4px; margin: 0;">\\\r\n					<a href="javascript:smf_themesMoreInfo(''+smf_random+'');void(0);">''+smf_themeInfo[smf_random].name + '' by '' + smf_themeInfo[smf_random].author+''</a>\\\r\n				</p>'';\r\n}\r\nwindow.smfLatestThemes += ''\\\r\n		</div>\\\r\n	</div>'';\r\n\r\nfunction findTop(el)\r\n{\r\n	if (typeof(el.tagName) == "undefined")\r\n		return 0;\r\n\r\n	var skipMe = in_array(el.tagName.toLowerCase(), el.parentNode ? ["tr", "tbody", "form"] : []);\r\n	var coordsParent = el.parentNode ? "parentNode" : "offsetParent";\r\n\r\n	if (el[coordsParent] == null || typeof(el[coordsParent].offsetTop) == "undefined")\r\n		return skipMe ? 0 : el.offsetTop;\r\n	else\r\n		return (skipMe ? 0 : el.offsetTop) + findTop(el[coordsParent]);\r\n}\r\n\r\nfunction in_array(item, array)\r\n{\r\n	for (var i in array)\r\n	{\r\n		if (array[i] == item)\r\n			return true;\r\n	}\r\n\r\n	return false;\r\n}', 'text/javascript');

-- --------------------------------------------------------

-- 
-- Table structure for table `approval_queue`
-- 

CREATE TABLE `approval_queue` (
  `id_msg` int(10) unsigned NOT NULL default '0',
  `id_attach` int(10) unsigned NOT NULL default '0',
  `id_event` smallint(5) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `approval_queue`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `attachments`
-- 

CREATE TABLE `attachments` (
  `id_attach` int(10) unsigned NOT NULL auto_increment,
  `id_thumb` int(10) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_folder` tinyint(3) NOT NULL default '1',
  `attachment_type` tinyint(3) unsigned NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `file_hash` varchar(40) NOT NULL default '',
  `fileext` varchar(8) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `downloads` mediumint(8) unsigned NOT NULL default '0',
  `width` mediumint(8) unsigned NOT NULL default '0',
  `height` mediumint(8) unsigned NOT NULL default '0',
  `mime_type` varchar(20) NOT NULL default '',
  `approved` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`id_attach`),
  UNIQUE KEY `id_member` (`id_member`,`id_attach`),
  KEY `id_msg` (`id_msg`),
  KEY `attachment_type` (`attachment_type`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `attachments`
-- 

INSERT INTO `attachments` VALUES (4, 0, 0, 1, 1, 0, 'avatar_1_1374756310.png', 'ef744ee4877dc47c24af8652adc57beb144f6094', 'png', 12928, 39, 147, 100, 'image/png', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `ban_groups`
-- 

CREATE TABLE `ban_groups` (
  `id_ban_group` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `ban_time` int(10) unsigned NOT NULL default '0',
  `expire_time` int(10) unsigned default NULL,
  `cannot_access` tinyint(3) unsigned NOT NULL default '0',
  `cannot_register` tinyint(3) unsigned NOT NULL default '0',
  `cannot_post` tinyint(3) unsigned NOT NULL default '0',
  `cannot_login` tinyint(3) unsigned NOT NULL default '0',
  `reason` varchar(255) NOT NULL default '',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id_ban_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ban_groups`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ban_items`
-- 

CREATE TABLE `ban_items` (
  `id_ban` mediumint(8) unsigned NOT NULL auto_increment,
  `id_ban_group` smallint(5) unsigned NOT NULL default '0',
  `ip_low1` tinyint(3) unsigned NOT NULL default '0',
  `ip_high1` tinyint(3) unsigned NOT NULL default '0',
  `ip_low2` tinyint(3) unsigned NOT NULL default '0',
  `ip_high2` tinyint(3) unsigned NOT NULL default '0',
  `ip_low3` tinyint(3) unsigned NOT NULL default '0',
  `ip_high3` tinyint(3) unsigned NOT NULL default '0',
  `ip_low4` tinyint(3) unsigned NOT NULL default '0',
  `ip_high4` tinyint(3) unsigned NOT NULL default '0',
  `hostname` varchar(255) NOT NULL default '',
  `email_address` varchar(255) NOT NULL default '',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `hits` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_ban`),
  KEY `id_ban_group` (`id_ban_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ban_items`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `board_permissions`
-- 

CREATE TABLE `board_permissions` (
  `id_group` smallint(5) NOT NULL default '0',
  `id_profile` smallint(5) unsigned NOT NULL default '0',
  `permission` varchar(30) NOT NULL default '',
  `add_deny` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id_group`,`id_profile`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `board_permissions`
-- 

INSERT INTO `board_permissions` VALUES (-1, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_add_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_edit_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'view_attachments', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `boards`
-- 

CREATE TABLE `boards` (
  `id_board` smallint(5) unsigned NOT NULL auto_increment,
  `id_cat` tinyint(4) unsigned NOT NULL default '0',
  `child_level` tinyint(4) unsigned NOT NULL default '0',
  `id_parent` smallint(5) unsigned NOT NULL default '0',
  `board_order` smallint(5) NOT NULL default '0',
  `id_last_msg` int(10) unsigned NOT NULL default '0',
  `id_msg_updated` int(10) unsigned NOT NULL default '0',
  `member_groups` varchar(255) NOT NULL default '-1,0',
  `id_profile` smallint(5) unsigned NOT NULL default '1',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `count_posts` tinyint(4) NOT NULL default '0',
  `id_theme` tinyint(4) unsigned NOT NULL default '0',
  `override_theme` tinyint(4) unsigned NOT NULL default '0',
  `unapproved_posts` smallint(5) NOT NULL default '0',
  `unapproved_topics` smallint(5) NOT NULL default '0',
  `redirect` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_board`),
  UNIQUE KEY `categories` (`id_cat`,`id_board`),
  KEY `id_parent` (`id_parent`),
  KEY `id_msg_updated` (`id_msg_updated`),
  KEY `member_groups` (`member_groups`(48))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `boards`
-- 

INSERT INTO `boards` VALUES (1, 1, 0, 0, 1, 2, 2, '-1,0,2', 1, 'General Discussion', 'Feel free to talk about anything and everything in this board.', 1, 2, 0, 0, 0, 0, 0, '');

-- --------------------------------------------------------

-- 
-- Table structure for table `calendar`
-- 

CREATE TABLE `calendar` (
  `id_event` smallint(5) unsigned NOT NULL auto_increment,
  `start_date` date NOT NULL default '0001-01-01',
  `end_date` date NOT NULL default '0001-01-01',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_event`),
  KEY `start_date` (`start_date`),
  KEY `end_date` (`end_date`),
  KEY `topic` (`id_topic`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `calendar`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `calendar_holidays`
-- 

CREATE TABLE `calendar_holidays` (
  `id_holiday` smallint(5) unsigned NOT NULL auto_increment,
  `event_date` date NOT NULL default '0001-01-01',
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_holiday`),
  KEY `event_date` (`event_date`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;

-- 
-- Dumping data for table `calendar_holidays`
-- 

INSERT INTO `calendar_holidays` VALUES (1, '0004-01-01', 'New Year''s');
INSERT INTO `calendar_holidays` VALUES (2, '0004-12-25', 'Christmas');
INSERT INTO `calendar_holidays` VALUES (3, '0004-02-14', 'Valentine''s Day');
INSERT INTO `calendar_holidays` VALUES (4, '0004-03-17', 'St. Patrick''s Day');
INSERT INTO `calendar_holidays` VALUES (5, '0004-04-01', 'April Fools');
INSERT INTO `calendar_holidays` VALUES (6, '0004-04-22', 'Earth Day');
INSERT INTO `calendar_holidays` VALUES (7, '0004-10-24', 'United Nations Day');
INSERT INTO `calendar_holidays` VALUES (8, '0004-10-31', 'Halloween');
INSERT INTO `calendar_holidays` VALUES (9, '2010-05-09', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (10, '2011-05-08', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (11, '2012-05-13', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (12, '2013-05-12', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (13, '2014-05-11', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (14, '2015-05-10', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (15, '2016-05-08', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (16, '2017-05-14', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (17, '2018-05-13', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (18, '2019-05-12', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (19, '2020-05-10', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (20, '2008-06-15', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (21, '2009-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (22, '2010-06-20', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (23, '2011-06-19', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (24, '2012-06-17', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (25, '2013-06-16', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (26, '2014-06-15', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (27, '2015-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (28, '2016-06-19', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (29, '2017-06-18', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (30, '2018-06-17', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (31, '2019-06-16', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (32, '2020-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (33, '2010-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (34, '2011-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (35, '2012-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (36, '2013-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (37, '2014-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (38, '2015-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (39, '2016-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (40, '2017-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (41, '2018-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (42, '2019-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (43, '2020-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (44, '2010-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (45, '2011-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (46, '2012-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (47, '2013-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (48, '2014-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (49, '2015-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (50, '2016-03-19', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (51, '2017-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (52, '2018-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (53, '2019-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (54, '2020-03-19', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (55, '2010-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (56, '2011-12-22', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (57, '2012-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (58, '2013-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (59, '2014-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (60, '2015-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (61, '2016-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (62, '2017-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (63, '2018-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (64, '2019-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (65, '2020-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (66, '2010-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (67, '2011-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (68, '2012-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (69, '2013-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (70, '2014-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (71, '2015-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (72, '2016-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (73, '2017-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (74, '2018-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (75, '2019-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (76, '2020-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (77, '0004-07-04', 'Independence Day');
INSERT INTO `calendar_holidays` VALUES (78, '0004-05-05', 'Cinco de Mayo');
INSERT INTO `calendar_holidays` VALUES (79, '0004-06-14', 'Flag Day');
INSERT INTO `calendar_holidays` VALUES (80, '0004-11-11', 'Veterans Day');
INSERT INTO `calendar_holidays` VALUES (81, '0004-02-02', 'Groundhog Day');
INSERT INTO `calendar_holidays` VALUES (82, '2010-11-25', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (83, '2011-11-24', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (84, '2012-11-22', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (85, '2013-11-21', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (86, '2014-11-20', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (87, '2015-11-26', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (88, '2016-11-24', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (89, '2017-11-23', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (90, '2018-11-22', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (91, '2019-11-21', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (92, '2020-11-26', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (93, '2010-05-31', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (94, '2011-05-30', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (95, '2012-05-28', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (96, '2013-05-27', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (97, '2014-05-26', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (98, '2015-05-25', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (99, '2016-05-30', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (100, '2017-05-29', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (101, '2018-05-28', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (102, '2019-05-27', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (103, '2020-05-25', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (104, '2010-09-06', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (105, '2011-09-05', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (106, '2012-09-03', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (107, '2013-09-09', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (108, '2014-09-08', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (109, '2015-09-07', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (110, '2016-09-05', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (111, '2017-09-04', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (112, '2018-09-03', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (113, '2019-09-09', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (114, '2020-09-07', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (115, '0004-06-06', 'D-Day');

-- --------------------------------------------------------

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `id_cat` tinyint(4) unsigned NOT NULL auto_increment,
  `cat_order` tinyint(4) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `can_collapse` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id_cat`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` VALUES (1, 0, 'General Category', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `collapsed_categories`
-- 

CREATE TABLE `collapsed_categories` (
  `id_cat` tinyint(4) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_cat`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `collapsed_categories`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `custom_fields`
-- 

CREATE TABLE `custom_fields` (
  `id_field` smallint(5) NOT NULL auto_increment,
  `col_name` varchar(12) NOT NULL default '',
  `field_name` varchar(40) NOT NULL default '',
  `field_desc` varchar(255) NOT NULL default '',
  `field_type` varchar(8) NOT NULL default 'text',
  `field_length` smallint(5) NOT NULL default '255',
  `field_options` text NOT NULL,
  `mask` varchar(255) NOT NULL default '',
  `show_reg` tinyint(3) NOT NULL default '0',
  `show_display` tinyint(3) NOT NULL default '0',
  `show_profile` varchar(20) NOT NULL default 'forumprofile',
  `private` tinyint(3) NOT NULL default '0',
  `active` tinyint(3) NOT NULL default '1',
  `bbc` tinyint(3) NOT NULL default '0',
  `can_search` tinyint(3) NOT NULL default '0',
  `default_value` varchar(255) NOT NULL default '',
  `enclose` text NOT NULL,
  `placement` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id_field`),
  UNIQUE KEY `col_name` (`col_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `custom_fields`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `group_moderators`
-- 

CREATE TABLE `group_moderators` (
  `id_group` smallint(5) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_group`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `group_moderators`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_actions`
-- 

CREATE TABLE `log_actions` (
  `id_action` int(10) unsigned NOT NULL auto_increment,
  `id_log` tinyint(3) unsigned NOT NULL default '1',
  `log_time` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `ip` char(16) NOT NULL default '',
  `action` varchar(30) NOT NULL default '',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  `extra` text NOT NULL,
  PRIMARY KEY  (`id_action`),
  KEY `id_log` (`id_log`),
  KEY `log_time` (`log_time`),
  KEY `id_member` (`id_member`),
  KEY `id_board` (`id_board`),
  KEY `id_msg` (`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_actions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_activity`
-- 

CREATE TABLE `log_activity` (
  `date` date NOT NULL default '0001-01-01',
  `hits` mediumint(8) unsigned NOT NULL default '0',
  `topics` smallint(5) unsigned NOT NULL default '0',
  `posts` smallint(5) unsigned NOT NULL default '0',
  `registers` smallint(5) unsigned NOT NULL default '0',
  `most_on` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`date`),
  KEY `most_on` (`most_on`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_activity`
-- 

INSERT INTO `log_activity` VALUES ('2013-07-25', 68, 1, 2, 1, 1);
INSERT INTO `log_activity` VALUES ('2013-07-26', 42, 0, 0, 0, 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_banned`
-- 

CREATE TABLE `log_banned` (
  `id_ban_log` mediumint(8) unsigned NOT NULL auto_increment,
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `ip` char(16) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `log_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_ban_log`),
  KEY `log_time` (`log_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_banned`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_boards`
-- 

CREATE TABLE `log_boards` (
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_member`,`id_board`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_boards`
-- 

INSERT INTO `log_boards` VALUES (1, 1, 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_comments`
-- 

CREATE TABLE `log_comments` (
  `id_comment` mediumint(8) unsigned NOT NULL auto_increment,
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `member_name` varchar(80) NOT NULL default '',
  `comment_type` varchar(8) NOT NULL default 'warning',
  `id_recipient` mediumint(8) unsigned NOT NULL default '0',
  `recipient_name` varchar(255) NOT NULL default '',
  `log_time` int(10) NOT NULL default '0',
  `id_notice` mediumint(8) unsigned NOT NULL default '0',
  `counter` tinyint(3) NOT NULL default '0',
  `body` text NOT NULL,
  PRIMARY KEY  (`id_comment`),
  KEY `id_recipient` (`id_recipient`),
  KEY `log_time` (`log_time`),
  KEY `comment_type` (`comment_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_comments`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_digest`
-- 

CREATE TABLE `log_digest` (
  `id_topic` mediumint(8) unsigned NOT NULL,
  `id_msg` int(10) unsigned NOT NULL,
  `note_type` varchar(10) NOT NULL default 'post',
  `daily` tinyint(3) unsigned NOT NULL default '0',
  `exclude` mediumint(8) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_digest`
-- 

INSERT INTO `log_digest` VALUES (1, 2, 'reply', 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_errors`
-- 

CREATE TABLE `log_errors` (
  `id_error` mediumint(8) unsigned NOT NULL auto_increment,
  `log_time` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `ip` char(16) NOT NULL default '',
  `url` text NOT NULL,
  `message` text NOT NULL,
  `session` char(32) NOT NULL default '',
  `error_type` char(15) NOT NULL default 'general',
  `file` varchar(255) NOT NULL default '',
  `line` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_error`),
  KEY `log_time` (`log_time`),
  KEY `id_member` (`id_member`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `log_errors`
-- 

INSERT INTO `log_errors` VALUES (1, 1374749951, 0, '', '?scheduled=task;ts=0', 'Could not retrieve the file http://www.simplemachines.org/smf/latest-smileys.js?language=english&version=SMF+2.0.4.', '', 'general', '', 0);
INSERT INTO `log_errors` VALUES (2, 1374848194, 1, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index:  pages', '3e4af741826d93ee80f4146b81d4f875', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (3, 1374848265, 0, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index:  pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (4, 1374848273, 1, '74.125.60.56', '?', '8: Undefined index:  pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (5, 1374848273, 0, '', '?scheduled=task;ts=1374796800', '', '', 'general', '', 0);
INSERT INTO `log_errors` VALUES (6, 1374848277, 1, '74.125.60.56', '?action=admin;area=theme;sa=settings;th=1;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Kann die ''Settings.german-utf8'' Sprachdatei nicht laden.', '39afd01e5096a2c7c68d84eca165bd75', 'general', '', 0);
INSERT INTO `log_errors` VALUES (7, 1374848339, 1, '74.125.60.56', '?action=admin;area=theme;sa=settings;th=1', 'Kann die ''Settings.german-utf8'' Sprachdatei nicht laden.', '39afd01e5096a2c7c68d84eca165bd75', 'general', '', 0);
INSERT INTO `log_errors` VALUES (8, 1374848508, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (9, 1374848513, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (10, 1374848581, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (11, 1374848677, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (12, 1374848960, 1, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index:  pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_floodcontrol`
-- 

CREATE TABLE `log_floodcontrol` (
  `ip` char(16) NOT NULL default '',
  `log_time` int(10) unsigned NOT NULL default '0',
  `log_type` varchar(8) NOT NULL default 'post',
  PRIMARY KEY  (`ip`,`log_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_floodcontrol`
-- 

INSERT INTO `log_floodcontrol` VALUES ('172.30.250.73', 1374756213, 'post');
INSERT INTO `log_floodcontrol` VALUES ('74.125.60.56', 1374848272, 'login');

-- --------------------------------------------------------

-- 
-- Table structure for table `log_group_requests`
-- 

CREATE TABLE `log_group_requests` (
  `id_request` mediumint(8) unsigned NOT NULL auto_increment,
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_group` smallint(5) unsigned NOT NULL default '0',
  `time_applied` int(10) unsigned NOT NULL default '0',
  `reason` text NOT NULL,
  PRIMARY KEY  (`id_request`),
  UNIQUE KEY `id_member` (`id_member`,`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_group_requests`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_karma`
-- 

CREATE TABLE `log_karma` (
  `id_target` mediumint(8) unsigned NOT NULL default '0',
  `id_executor` mediumint(8) unsigned NOT NULL default '0',
  `log_time` int(10) unsigned NOT NULL default '0',
  `action` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id_target`,`id_executor`),
  KEY `log_time` (`log_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_karma`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_mark_read`
-- 

CREATE TABLE `log_mark_read` (
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_member`,`id_board`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_mark_read`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_member_notices`
-- 

CREATE TABLE `log_member_notices` (
  `id_notice` mediumint(8) unsigned NOT NULL auto_increment,
  `subject` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (`id_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_member_notices`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_notify`
-- 

CREATE TABLE `log_notify` (
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `sent` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_member`,`id_topic`,`id_board`),
  KEY `id_topic` (`id_topic`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_notify`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_online`
-- 

CREATE TABLE `log_online` (
  `session` varchar(32) NOT NULL default '',
  `log_time` int(10) NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_spider` smallint(5) unsigned NOT NULL default '0',
  `ip` int(10) unsigned NOT NULL default '0',
  `url` text NOT NULL,
  PRIMARY KEY  (`session`),
  KEY `log_time` (`log_time`),
  KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_online`
-- 

INSERT INTO `log_online` VALUES ('h06f85tjp81mt2qrphjlomhgc2', 1374848960, 1, 0, 1249721400, 'a:1:{s:10:"USER_AGENT";s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";}');

-- --------------------------------------------------------

-- 
-- Table structure for table `log_packages`
-- 

CREATE TABLE `log_packages` (
  `id_install` int(10) NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `package_id` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `version` varchar(255) NOT NULL default '',
  `id_member_installed` mediumint(8) NOT NULL default '0',
  `member_installed` varchar(255) NOT NULL default '',
  `time_installed` int(10) NOT NULL default '0',
  `id_member_removed` mediumint(8) NOT NULL default '0',
  `member_removed` varchar(255) NOT NULL default '',
  `time_removed` int(10) NOT NULL default '0',
  `install_state` tinyint(3) NOT NULL default '1',
  `failed_steps` text NOT NULL,
  `themes_installed` varchar(255) NOT NULL default '',
  `db_changes` text NOT NULL,
  PRIMARY KEY  (`id_install`),
  KEY `filename` (`filename`(15))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_packages`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_polls`
-- 

CREATE TABLE `log_polls` (
  `id_poll` mediumint(8) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_choice` tinyint(3) unsigned NOT NULL default '0',
  KEY `id_poll` (`id_poll`,`id_member`,`id_choice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_polls`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_reported`
-- 

CREATE TABLE `log_reported` (
  `id_report` mediumint(8) unsigned NOT NULL auto_increment,
  `id_msg` int(10) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `membername` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `time_started` int(10) NOT NULL default '0',
  `time_updated` int(10) NOT NULL default '0',
  `num_reports` mediumint(6) NOT NULL default '0',
  `closed` tinyint(3) NOT NULL default '0',
  `ignore_all` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id_report`),
  KEY `id_member` (`id_member`),
  KEY `id_topic` (`id_topic`),
  KEY `closed` (`closed`),
  KEY `time_started` (`time_started`),
  KEY `id_msg` (`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_reported`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_reported_comments`
-- 

CREATE TABLE `log_reported_comments` (
  `id_comment` mediumint(8) unsigned NOT NULL auto_increment,
  `id_report` mediumint(8) NOT NULL default '0',
  `id_member` mediumint(8) NOT NULL,
  `membername` varchar(255) NOT NULL default '',
  `email_address` varchar(255) NOT NULL default '',
  `member_ip` varchar(255) NOT NULL default '',
  `comment` varchar(255) NOT NULL default '',
  `time_sent` int(10) NOT NULL,
  PRIMARY KEY  (`id_comment`),
  KEY `id_report` (`id_report`),
  KEY `id_member` (`id_member`),
  KEY `time_sent` (`time_sent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_reported_comments`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_scheduled_tasks`
-- 

CREATE TABLE `log_scheduled_tasks` (
  `id_log` mediumint(8) NOT NULL auto_increment,
  `id_task` smallint(5) NOT NULL default '0',
  `time_run` int(10) NOT NULL default '0',
  `time_taken` float NOT NULL default '0',
  PRIMARY KEY  (`id_log`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `log_scheduled_tasks`
-- 

INSERT INTO `log_scheduled_tasks` VALUES (1, 2, 1374749864, 0);
INSERT INTO `log_scheduled_tasks` VALUES (2, 3, 1374749867, 0);
INSERT INTO `log_scheduled_tasks` VALUES (3, 5, 1374749872, 0);
INSERT INTO `log_scheduled_tasks` VALUES (4, 6, 1374749880, 0);
INSERT INTO `log_scheduled_tasks` VALUES (5, 9, 1374749997, 0);
INSERT INTO `log_scheduled_tasks` VALUES (6, 1, 1374754417, 0);
INSERT INTO `log_scheduled_tasks` VALUES (7, 1, 1374848265, 0);
INSERT INTO `log_scheduled_tasks` VALUES (8, 5, 1374848273, 0);
INSERT INTO `log_scheduled_tasks` VALUES (9, 3, 1374848277, 0);
INSERT INTO `log_scheduled_tasks` VALUES (10, 7, 1374848348, 7);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_search_messages`
-- 

CREATE TABLE `log_search_messages` (
  `id_search` tinyint(3) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_search`,`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_search_messages`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_search_results`
-- 

CREATE TABLE `log_search_results` (
  `id_search` tinyint(3) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  `relevance` smallint(5) unsigned NOT NULL default '0',
  `num_matches` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_search`,`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_search_results`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_search_subjects`
-- 

CREATE TABLE `log_search_subjects` (
  `word` varchar(20) NOT NULL default '',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word`,`id_topic`),
  KEY `id_topic` (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_search_subjects`
-- 

INSERT INTO `log_search_subjects` VALUES ('SMF', 1);
INSERT INTO `log_search_subjects` VALUES ('to', 1);
INSERT INTO `log_search_subjects` VALUES ('Welcome', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `log_search_topics`
-- 

CREATE TABLE `log_search_topics` (
  `id_search` tinyint(3) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_search`,`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_search_topics`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_spider_hits`
-- 

CREATE TABLE `log_spider_hits` (
  `id_hit` int(10) unsigned NOT NULL auto_increment,
  `id_spider` smallint(5) unsigned NOT NULL default '0',
  `log_time` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `processed` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id_hit`),
  KEY `id_spider` (`id_spider`),
  KEY `log_time` (`log_time`),
  KEY `processed` (`processed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_spider_hits`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_spider_stats`
-- 

CREATE TABLE `log_spider_stats` (
  `id_spider` smallint(5) unsigned NOT NULL default '0',
  `page_hits` smallint(5) unsigned NOT NULL default '0',
  `last_seen` int(10) unsigned NOT NULL default '0',
  `stat_date` date NOT NULL default '0001-01-01',
  PRIMARY KEY  (`stat_date`,`id_spider`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_spider_stats`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_subscribed`
-- 

CREATE TABLE `log_subscribed` (
  `id_sublog` int(10) unsigned NOT NULL auto_increment,
  `id_subscribe` mediumint(8) unsigned NOT NULL default '0',
  `id_member` int(10) NOT NULL default '0',
  `old_id_group` smallint(5) NOT NULL default '0',
  `start_time` int(10) NOT NULL default '0',
  `end_time` int(10) NOT NULL default '0',
  `status` tinyint(3) NOT NULL default '0',
  `payments_pending` tinyint(3) NOT NULL default '0',
  `pending_details` text NOT NULL,
  `reminder_sent` tinyint(3) NOT NULL default '0',
  `vendor_ref` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_sublog`),
  UNIQUE KEY `id_subscribe` (`id_subscribe`,`id_member`),
  KEY `end_time` (`end_time`),
  KEY `reminder_sent` (`reminder_sent`),
  KEY `payments_pending` (`payments_pending`),
  KEY `status` (`status`),
  KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `log_subscribed`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `log_topics`
-- 

CREATE TABLE `log_topics` (
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_msg` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_member`,`id_topic`),
  KEY `id_topic` (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `log_topics`
-- 

INSERT INTO `log_topics` VALUES (1, 1, 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `mail_queue`
-- 

CREATE TABLE `mail_queue` (
  `id_mail` int(10) unsigned NOT NULL auto_increment,
  `time_sent` int(10) NOT NULL default '0',
  `recipient` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `subject` varchar(255) NOT NULL default '',
  `headers` text NOT NULL,
  `send_html` tinyint(3) NOT NULL default '0',
  `priority` tinyint(3) NOT NULL default '1',
  `private` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_mail`),
  KEY `time_sent` (`time_sent`),
  KEY `mail_priority` (`priority`,`id_mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `mail_queue`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `membergroups`
-- 

CREATE TABLE `membergroups` (
  `id_group` smallint(5) unsigned NOT NULL auto_increment,
  `group_name` varchar(80) NOT NULL default '',
  `description` text NOT NULL,
  `online_color` varchar(20) NOT NULL default '',
  `min_posts` mediumint(9) NOT NULL default '-1',
  `max_messages` smallint(5) unsigned NOT NULL default '0',
  `stars` varchar(255) NOT NULL default '',
  `group_type` tinyint(3) NOT NULL default '0',
  `hidden` tinyint(3) NOT NULL default '0',
  `id_parent` smallint(5) NOT NULL default '-2',
  PRIMARY KEY  (`id_group`),
  KEY `min_posts` (`min_posts`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `membergroups`
-- 

INSERT INTO `membergroups` VALUES (1, 'Administrator', '', '#FF0000', -1, 0, '5#staradmin.gif', 1, 0, -2);
INSERT INTO `membergroups` VALUES (2, 'Global Moderator', '', '#0000FF', -1, 0, '5#stargmod.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (3, 'Moderator', '', '', -1, 0, '5#starmod.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (4, 'Newbie', '', '', 0, 0, '1#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (5, 'Jr. Member', '', '', 50, 0, '2#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (6, 'Full Member', '', '', 100, 0, '3#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (7, 'Sr. Member', '', '', 250, 0, '4#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (8, 'Hero Member', '', '', 500, 0, '5#star.gif', 0, 0, -2);

-- --------------------------------------------------------

-- 
-- Table structure for table `members`
-- 

CREATE TABLE `members` (
  `id_member` mediumint(8) unsigned NOT NULL auto_increment,
  `member_name` varchar(80) NOT NULL default '',
  `date_registered` int(10) unsigned NOT NULL default '0',
  `posts` mediumint(8) unsigned NOT NULL default '0',
  `id_group` smallint(5) unsigned NOT NULL default '0',
  `lngfile` varchar(255) NOT NULL default '',
  `last_login` int(10) unsigned NOT NULL default '0',
  `real_name` varchar(255) NOT NULL default '',
  `instant_messages` smallint(5) NOT NULL default '0',
  `unread_messages` smallint(5) NOT NULL default '0',
  `new_pm` tinyint(3) unsigned NOT NULL default '0',
  `buddy_list` text NOT NULL,
  `pm_ignore_list` varchar(255) NOT NULL default '',
  `pm_prefs` mediumint(8) NOT NULL default '0',
  `mod_prefs` varchar(20) NOT NULL default '',
  `message_labels` text NOT NULL,
  `passwd` varchar(64) NOT NULL default '',
  `openid_uri` text NOT NULL,
  `email_address` varchar(255) NOT NULL default '',
  `personal_text` varchar(255) NOT NULL default '',
  `gender` tinyint(4) unsigned NOT NULL default '0',
  `birthdate` date NOT NULL default '0001-01-01',
  `website_title` varchar(255) NOT NULL default '',
  `website_url` varchar(255) NOT NULL default '',
  `location` varchar(255) NOT NULL default '',
  `icq` varchar(255) NOT NULL default '',
  `aim` varchar(255) NOT NULL default '',
  `yim` varchar(32) NOT NULL default '',
  `msn` varchar(255) NOT NULL default '',
  `hide_email` tinyint(4) NOT NULL default '0',
  `show_online` tinyint(4) NOT NULL default '1',
  `time_format` varchar(80) NOT NULL default '',
  `signature` text NOT NULL,
  `time_offset` float NOT NULL default '0',
  `avatar` varchar(255) NOT NULL default '',
  `pm_email_notify` tinyint(4) NOT NULL default '0',
  `karma_bad` smallint(5) unsigned NOT NULL default '0',
  `karma_good` smallint(5) unsigned NOT NULL default '0',
  `usertitle` varchar(255) NOT NULL default '',
  `notify_announcements` tinyint(4) NOT NULL default '1',
  `notify_regularity` tinyint(4) NOT NULL default '1',
  `notify_send_body` tinyint(4) NOT NULL default '0',
  `notify_types` tinyint(4) NOT NULL default '2',
  `member_ip` varchar(255) NOT NULL default '',
  `member_ip2` varchar(255) NOT NULL default '',
  `secret_question` varchar(255) NOT NULL default '',
  `secret_answer` varchar(64) NOT NULL default '',
  `id_theme` tinyint(4) unsigned NOT NULL default '0',
  `is_activated` tinyint(3) unsigned NOT NULL default '1',
  `validation_code` varchar(10) NOT NULL default '',
  `id_msg_last_visit` int(10) unsigned NOT NULL default '0',
  `additional_groups` varchar(255) NOT NULL default '',
  `smiley_set` varchar(48) NOT NULL default '',
  `id_post_group` smallint(5) unsigned NOT NULL default '0',
  `total_time_logged_in` int(10) unsigned NOT NULL default '0',
  `password_salt` varchar(255) NOT NULL default '',
  `ignore_boards` text NOT NULL,
  `warning` tinyint(4) NOT NULL default '0',
  `passwd_flood` varchar(12) NOT NULL default '',
  `pm_receive_from` tinyint(4) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id_member`),
  KEY `member_name` (`member_name`),
  KEY `real_name` (`real_name`),
  KEY `date_registered` (`date_registered`),
  KEY `id_group` (`id_group`),
  KEY `birthdate` (`birthdate`),
  KEY `posts` (`posts`),
  KEY `last_login` (`last_login`),
  KEY `lngfile` (`lngfile`(30)),
  KEY `id_post_group` (`id_post_group`),
  KEY `warning` (`warning`),
  KEY `total_time_logged_in` (`total_time_logged_in`),
  KEY `id_theme` (`id_theme`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `members`
-- 

INSERT INTO `members` VALUES (1, 'clausmuus', 1374749808, 1, 1, '', 1374848919, 'clausmuus', 0, 0, 0, '', '', 0, '', '', 'f1f2ba3fa1ce041f28efeb95a5c934796c4eccf9', '', 'claus@minidvblinux.de', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, 0, 2, '74.125.60.56', '74.125.60.56', '', '', 0, 1, '', 2, '', '', 4, 4851, 'e361', '', 0, '', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `message_icons`
-- 

CREATE TABLE `message_icons` (
  `id_icon` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(80) NOT NULL default '',
  `filename` varchar(80) NOT NULL default '',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `icon_order` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_icon`),
  KEY `id_board` (`id_board`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `message_icons`
-- 

INSERT INTO `message_icons` VALUES (1, 'Standard', 'xx', 0, 0);
INSERT INTO `message_icons` VALUES (2, 'Thumb Up', 'thumbup', 0, 1);
INSERT INTO `message_icons` VALUES (3, 'Thumb Down', 'thumbdown', 0, 2);
INSERT INTO `message_icons` VALUES (4, 'Exclamation point', 'exclamation', 0, 3);
INSERT INTO `message_icons` VALUES (5, 'Question mark', 'question', 0, 4);
INSERT INTO `message_icons` VALUES (6, 'Lamp', 'lamp', 0, 5);
INSERT INTO `message_icons` VALUES (7, 'Smiley', 'smiley', 0, 6);
INSERT INTO `message_icons` VALUES (8, 'Angry', 'angry', 0, 7);
INSERT INTO `message_icons` VALUES (9, 'Cheesy', 'cheesy', 0, 8);
INSERT INTO `message_icons` VALUES (10, 'Grin', 'grin', 0, 9);
INSERT INTO `message_icons` VALUES (11, 'Sad', 'sad', 0, 10);
INSERT INTO `message_icons` VALUES (12, 'Wink', 'wink', 0, 11);

-- --------------------------------------------------------

-- 
-- Table structure for table `messages`
-- 

CREATE TABLE `messages` (
  `id_msg` int(10) unsigned NOT NULL auto_increment,
  `id_topic` mediumint(8) unsigned NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `poster_time` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `id_msg_modified` int(10) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `poster_name` varchar(255) NOT NULL default '',
  `poster_email` varchar(255) NOT NULL default '',
  `poster_ip` varchar(255) NOT NULL default '',
  `smileys_enabled` tinyint(4) NOT NULL default '1',
  `modified_time` int(10) unsigned NOT NULL default '0',
  `modified_name` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `icon` varchar(16) NOT NULL default 'xx',
  `approved` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`id_msg`),
  UNIQUE KEY `topic` (`id_topic`,`id_msg`),
  UNIQUE KEY `id_board` (`id_board`,`id_msg`),
  UNIQUE KEY `id_member` (`id_member`,`id_msg`),
  KEY `approved` (`approved`),
  KEY `ip_index` (`poster_ip`(15),`id_topic`),
  KEY `participation` (`id_member`,`id_topic`),
  KEY `show_posts` (`id_member`,`id_board`),
  KEY `id_topic` (`id_topic`),
  KEY `id_member_msg` (`id_member`,`approved`,`id_msg`),
  KEY `current_topic` (`id_topic`,`id_msg`,`id_member`,`approved`),
  KEY `related_ip` (`id_member`,`poster_ip`,`id_msg`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `messages`
-- 

INSERT INTO `messages` VALUES (1, 1, 1, 1374749649, 0, 1, 'Welcome to SMF!', 'Simple Machines', 'info@simplemachines.org', '127.0.0.1', 1, 0, '', 'Welcome to Simple Machines Forum!<br /><br />We hope you enjoy using your forum.&nbsp; If you have any problems, please feel free to [url=http://www.simplemachines.org/community/index.php]ask us for assistance[/url].<br /><br />Thanks!<br />Simple Machines', 'xx', 1);
INSERT INTO `messages` VALUES (2, 1, 1, 1374756213, 1, 2, 'Re: Welcome to SMF!', 'clausmuus', 'claus@minidvblinux.de', '172.30.250.73', 1, 0, '', 'Nur ein test', 'xx', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `moderators`
-- 

CREATE TABLE `moderators` (
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_board`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `moderators`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `openid_assoc`
-- 

CREATE TABLE `openid_assoc` (
  `server_url` text NOT NULL,
  `handle` varchar(255) NOT NULL default '',
  `secret` text NOT NULL,
  `issued` int(10) NOT NULL default '0',
  `expires` int(10) NOT NULL default '0',
  `assoc_type` varchar(64) NOT NULL,
  PRIMARY KEY  (`server_url`(125),`handle`(125)),
  KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `openid_assoc`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `package_servers`
-- 

CREATE TABLE `package_servers` (
  `id_server` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_server`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `package_servers`
-- 

INSERT INTO `package_servers` VALUES (1, 'Simple Machines Third-party Mod Site', 'http://custom.simplemachines.org/packages/mods');

-- --------------------------------------------------------

-- 
-- Table structure for table `permission_profiles`
-- 

CREATE TABLE `permission_profiles` (
  `id_profile` smallint(5) NOT NULL auto_increment,
  `profile_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_profile`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `permission_profiles`
-- 

INSERT INTO `permission_profiles` VALUES (1, 'default');
INSERT INTO `permission_profiles` VALUES (2, 'no_polls');
INSERT INTO `permission_profiles` VALUES (3, 'reply_only');
INSERT INTO `permission_profiles` VALUES (4, 'read_only');

-- --------------------------------------------------------

-- 
-- Table structure for table `permissions`
-- 

CREATE TABLE `permissions` (
  `id_group` smallint(5) NOT NULL default '0',
  `permission` varchar(30) NOT NULL default '',
  `add_deny` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id_group`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `permissions`
-- 

INSERT INTO `permissions` VALUES (-1, 'search_posts', 1);
INSERT INTO `permissions` VALUES (-1, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (-1, 'view_stats', 1);
INSERT INTO `permissions` VALUES (-1, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (0, 'view_mlist', 1);
INSERT INTO `permissions` VALUES (0, 'search_posts', 1);
INSERT INTO `permissions` VALUES (0, 'profile_view_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (0, 'pm_read', 1);
INSERT INTO `permissions` VALUES (0, 'pm_send', 1);
INSERT INTO `permissions` VALUES (0, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (0, 'view_stats', 1);
INSERT INTO `permissions` VALUES (0, 'who_view', 1);
INSERT INTO `permissions` VALUES (0, 'profile_identity_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_extra_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_remove_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_upload_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'profile_upload_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'karma_edit', 1);
INSERT INTO `permissions` VALUES (2, 'view_mlist', 1);
INSERT INTO `permissions` VALUES (2, 'search_posts', 1);
INSERT INTO `permissions` VALUES (2, 'profile_view_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (2, 'pm_read', 1);
INSERT INTO `permissions` VALUES (2, 'pm_send', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (2, 'view_stats', 1);
INSERT INTO `permissions` VALUES (2, 'who_view', 1);
INSERT INTO `permissions` VALUES (2, 'profile_identity_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_extra_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_remove_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_remote_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'profile_remote_avatar', 1);
INSERT INTO `permissions` VALUES (2, 'profile_server_avatar', 1);
INSERT INTO `permissions` VALUES (2, 'profile_title_own', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_post', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_edit_any', 1);
INSERT INTO `permissions` VALUES (2, 'karma_edit', 1);
INSERT INTO `permissions` VALUES (2, 'access_mod_center', 1);
INSERT INTO `permissions` VALUES (0, 'profile_server_avatar', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `personal_messages`
-- 

CREATE TABLE `personal_messages` (
  `id_pm` int(10) unsigned NOT NULL auto_increment,
  `id_pm_head` int(10) unsigned NOT NULL default '0',
  `id_member_from` mediumint(8) unsigned NOT NULL default '0',
  `deleted_by_sender` tinyint(3) unsigned NOT NULL default '0',
  `from_name` varchar(255) NOT NULL default '',
  `msgtime` int(10) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (`id_pm`),
  KEY `id_member` (`id_member_from`,`deleted_by_sender`),
  KEY `msgtime` (`msgtime`),
  KEY `id_pm_head` (`id_pm_head`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `personal_messages`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `pm_recipients`
-- 

CREATE TABLE `pm_recipients` (
  `id_pm` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) unsigned NOT NULL default '0',
  `labels` varchar(60) NOT NULL default '-1',
  `bcc` tinyint(3) unsigned NOT NULL default '0',
  `is_read` tinyint(3) unsigned NOT NULL default '0',
  `is_new` tinyint(3) unsigned NOT NULL default '0',
  `deleted` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_pm`,`id_member`),
  UNIQUE KEY `id_member` (`id_member`,`deleted`,`id_pm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `pm_recipients`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `pm_rules`
-- 

CREATE TABLE `pm_rules` (
  `id_rule` int(10) unsigned NOT NULL auto_increment,
  `id_member` int(10) unsigned NOT NULL default '0',
  `rule_name` varchar(60) NOT NULL,
  `criteria` text NOT NULL,
  `actions` text NOT NULL,
  `delete_pm` tinyint(3) unsigned NOT NULL default '0',
  `is_or` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_rule`),
  KEY `id_member` (`id_member`),
  KEY `delete_pm` (`delete_pm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `pm_rules`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `poll_choices`
-- 

CREATE TABLE `poll_choices` (
  `id_poll` mediumint(8) unsigned NOT NULL default '0',
  `id_choice` tinyint(3) unsigned NOT NULL default '0',
  `label` varchar(255) NOT NULL default '',
  `votes` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_poll`,`id_choice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `poll_choices`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `polls`
-- 

CREATE TABLE `polls` (
  `id_poll` mediumint(8) unsigned NOT NULL auto_increment,
  `question` varchar(255) NOT NULL default '',
  `voting_locked` tinyint(1) NOT NULL default '0',
  `max_votes` tinyint(3) unsigned NOT NULL default '1',
  `expire_time` int(10) unsigned NOT NULL default '0',
  `hide_results` tinyint(3) unsigned NOT NULL default '0',
  `change_vote` tinyint(3) unsigned NOT NULL default '0',
  `guest_vote` tinyint(3) unsigned NOT NULL default '0',
  `num_guest_voters` int(10) unsigned NOT NULL default '0',
  `reset_poll` int(10) unsigned NOT NULL default '0',
  `id_member` mediumint(8) NOT NULL default '0',
  `poster_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_poll`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `polls`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `scheduled_tasks`
-- 

CREATE TABLE `scheduled_tasks` (
  `id_task` smallint(5) NOT NULL auto_increment,
  `next_time` int(10) NOT NULL default '0',
  `time_offset` int(10) NOT NULL default '0',
  `time_regularity` smallint(5) NOT NULL default '0',
  `time_unit` varchar(1) NOT NULL default 'h',
  `disabled` tinyint(3) NOT NULL default '0',
  `task` varchar(24) NOT NULL default '',
  PRIMARY KEY  (`id_task`),
  UNIQUE KEY `task` (`task`),
  KEY `next_time` (`next_time`),
  KEY `disabled` (`disabled`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `scheduled_tasks`
-- 

INSERT INTO `scheduled_tasks` VALUES (1, 1374858000, 0, 2, 'h', 0, 'approval_notification');
INSERT INTO `scheduled_tasks` VALUES (2, 1375315200, 0, 7, 'd', 0, 'auto_optimize');
INSERT INTO `scheduled_tasks` VALUES (3, 1374966060, 60, 1, 'd', 0, 'daily_maintenance');
INSERT INTO `scheduled_tasks` VALUES (5, 1374966000, 0, 1, 'd', 0, 'daily_digest');
INSERT INTO `scheduled_tasks` VALUES (6, 1375315200, 0, 1, 'w', 0, 'weekly_digest');
INSERT INTO `scheduled_tasks` VALUES (7, 1374968040, 88451, 1, 'd', 0, 'fetchSMfiles');
INSERT INTO `scheduled_tasks` VALUES (8, 0, 0, 1, 'd', 1, 'birthdayemails');
INSERT INTO `scheduled_tasks` VALUES (9, 1375315200, 0, 1, 'w', 0, 'weekly_maintenance');
INSERT INTO `scheduled_tasks` VALUES (10, 0, 120, 1, 'd', 1, 'paid_subscriptions');

-- --------------------------------------------------------

-- 
-- Table structure for table `sessions`
-- 

CREATE TABLE `sessions` (
  `session_id` char(32) NOT NULL,
  `last_update` int(10) unsigned NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `sessions`
-- 

INSERT INTO `sessions` VALUES ('h2h277366hkjj1avogi2ujgn16', 1374756480, 'USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";admin_time|i:1374754424;session_value|s:32:"5f97f2197707eff5ec4e3083a53c1cf2";session_var|s:9:"e8c478c81";id_msg_last_visit|s:1:"1";mc|a:7:{s:4:"time";i:1374756296;s:2:"id";s:1:"1";s:2:"gq";s:3:"1=1";s:2:"bq";s:3:"1=1";s:2:"ap";a:1:{i:0;i:0;}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374749836;s:7:"reports";s:1:"0";}log_time|i:1374756480;timeOnlineUpdated|i:1374756455;unread_messages|i:0;old_url|s:110:"http://mld.claus.lbc/forum/index.php?action=admin;area=manageboards;e8c478c81=5f97f2197707eff5ec4e3083a53c1cf2";pack_ftp|a:1:{s:14:"original_perms";a:5:{s:79:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/default/languages";i:16895;s:76:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core/languages";i:16895;s:76:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/default/images";i:16895;s:73:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core/images";i:16895;s:54:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum";i:16895;}}visual_verification_code|s:6:"MTPBDE";last_read_topic|i:1;forms|a:1:{i:0;i:1760100;}temp_attachments|a:0:{}');
INSERT INTO `sessions` VALUES ('rjbpj2pgtj4i3t5vqfqest44q7', 1374848194, 'session_value|s:32:"3e4af741826d93ee80f4146b81d4f875";session_var|s:10:"b51b2c0ed8";id_msg_last_visit|s:1:"1";mc|a:7:{s:4:"time";i:1374848194;s:2:"id";s:1:"1";s:2:"gq";s:3:"1=1";s:2:"bq";s:3:"1=1";s:2:"ap";a:1:{i:0;i:0;}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374848194;s:7:"reports";s:1:"0";}log_time|i:1374848194;timeOnlineUpdated|i:1374848194;unread_messages|i:0;old_url|s:33:"http://new.minidvblinux.de/forum/";USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";');
INSERT INTO `sessions` VALUES ('h06f85tjp81mt2qrphjlomhgc2', 1374848961, 'session_value|s:32:"39afd01e5096a2c7c68d84eca165bd75";session_var|s:11:"a4bb6979978";mc|a:7:{s:4:"time";i:1374848676;s:2:"id";s:1:"1";s:2:"gq";s:3:"1=1";s:2:"bq";s:3:"1=1";s:2:"ap";a:1:{i:0;i:0;}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1374848272;s:9:"id_member";i:0;s:2:"ip";s:12:"74.125.60.56";s:3:"ip2";s:12:"74.125.60.56";s:5:"email";s:0:"";}log_time|i:1374848960;timeOnlineUpdated|i:1374848919;old_url|s:33:"http://new.minidvblinux.de/forum/";USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";login_SMFCookie661|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"b904739b3deea3f5139bdb573d48835051ea2afc";i:2;i:1564064272;i:3;i:0;}";admin_time|i:1374848272;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374848272;s:7:"reports";s:1:"0";}unread_messages|i:0;');

-- --------------------------------------------------------

-- 
-- Table structure for table `settings`
-- 

CREATE TABLE `settings` (
  `variable` varchar(255) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`variable`(30))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `settings`
-- 

INSERT INTO `settings` VALUES ('smfVersion', '2.0.4');
INSERT INTO `settings` VALUES ('news', 'SMF - Just Installed!');
INSERT INTO `settings` VALUES ('compactTopicPagesContiguous', '5');
INSERT INTO `settings` VALUES ('compactTopicPagesEnable', '1');
INSERT INTO `settings` VALUES ('enableStickyTopics', '1');
INSERT INTO `settings` VALUES ('todayMod', '1');
INSERT INTO `settings` VALUES ('karmaMode', '0');
INSERT INTO `settings` VALUES ('karmaTimeRestrictAdmins', '1');
INSERT INTO `settings` VALUES ('enablePreviousNext', '1');
INSERT INTO `settings` VALUES ('pollMode', '1');
INSERT INTO `settings` VALUES ('enableVBStyleLogin', '1');
INSERT INTO `settings` VALUES ('enableCompressedOutput', '1');
INSERT INTO `settings` VALUES ('karmaWaitTime', '1');
INSERT INTO `settings` VALUES ('karmaMinPosts', '0');
INSERT INTO `settings` VALUES ('karmaLabel', 'Karma:');
INSERT INTO `settings` VALUES ('karmaSmiteLabel', '[smite]');
INSERT INTO `settings` VALUES ('karmaApplaudLabel', '[applaud]');
INSERT INTO `settings` VALUES ('attachmentSizeLimit', '1000');
INSERT INTO `settings` VALUES ('attachmentPostLimit', '1000');
INSERT INTO `settings` VALUES ('attachmentNumPerPostLimit', '4');
INSERT INTO `settings` VALUES ('attachmentDirSizeLimit', '100000');
INSERT INTO `settings` VALUES ('attachmentUploadDir', '../../data/forum/attachments');
INSERT INTO `settings` VALUES ('attachmentExtensions', 'doc,gif,jpg,mpg,pdf,png,txt,zip');
INSERT INTO `settings` VALUES ('attachmentCheckExtensions', '0');
INSERT INTO `settings` VALUES ('attachmentShowImages', '1');
INSERT INTO `settings` VALUES ('attachmentEnable', '1');
INSERT INTO `settings` VALUES ('attachmentEncryptFilenames', '1');
INSERT INTO `settings` VALUES ('attachmentThumbnails', '1');
INSERT INTO `settings` VALUES ('attachmentThumbWidth', '150');
INSERT INTO `settings` VALUES ('attachmentThumbHeight', '150');
INSERT INTO `settings` VALUES ('censorIgnoreCase', '1');
INSERT INTO `settings` VALUES ('mostOnline', '2');
INSERT INTO `settings` VALUES ('mostOnlineToday', '2');
INSERT INTO `settings` VALUES ('mostDate', '1374848265');
INSERT INTO `settings` VALUES ('allow_disableAnnounce', '1');
INSERT INTO `settings` VALUES ('trackStats', '1');
INSERT INTO `settings` VALUES ('userLanguage', '1');
INSERT INTO `settings` VALUES ('titlesEnable', '1');
INSERT INTO `settings` VALUES ('topicSummaryPosts', '15');
INSERT INTO `settings` VALUES ('enableErrorLogging', '1');
INSERT INTO `settings` VALUES ('max_image_width', '300');
INSERT INTO `settings` VALUES ('max_image_height', '300');
INSERT INTO `settings` VALUES ('onlineEnable', '0');
INSERT INTO `settings` VALUES ('cal_enabled', '0');
INSERT INTO `settings` VALUES ('cal_maxyear', '2020');
INSERT INTO `settings` VALUES ('cal_minyear', '2008');
INSERT INTO `settings` VALUES ('cal_daysaslink', '0');
INSERT INTO `settings` VALUES ('cal_defaultboard', '');
INSERT INTO `settings` VALUES ('cal_showholidays', '1');
INSERT INTO `settings` VALUES ('cal_showbdays', '1');
INSERT INTO `settings` VALUES ('cal_showevents', '1');
INSERT INTO `settings` VALUES ('cal_showweeknum', '0');
INSERT INTO `settings` VALUES ('cal_maxspan', '7');
INSERT INTO `settings` VALUES ('smtp_host', '');
INSERT INTO `settings` VALUES ('smtp_port', '25');
INSERT INTO `settings` VALUES ('smtp_username', '');
INSERT INTO `settings` VALUES ('smtp_password', '');
INSERT INTO `settings` VALUES ('mail_type', '0');
INSERT INTO `settings` VALUES ('timeLoadPageEnable', '0');
INSERT INTO `settings` VALUES ('totalMembers', '1');
INSERT INTO `settings` VALUES ('totalTopics', '1');
INSERT INTO `settings` VALUES ('totalMessages', '2');
INSERT INTO `settings` VALUES ('simpleSearch', '0');
INSERT INTO `settings` VALUES ('censor_vulgar', '');
INSERT INTO `settings` VALUES ('censor_proper', '');
INSERT INTO `settings` VALUES ('enablePostHTML', '0');
INSERT INTO `settings` VALUES ('theme_allow', '0');
INSERT INTO `settings` VALUES ('theme_default', '1');
INSERT INTO `settings` VALUES ('theme_guests', '1');
INSERT INTO `settings` VALUES ('enableEmbeddedFlash', '0');
INSERT INTO `settings` VALUES ('xmlnews_enable', '1');
INSERT INTO `settings` VALUES ('xmlnews_maxlen', '255');
INSERT INTO `settings` VALUES ('hotTopicPosts', '15');
INSERT INTO `settings` VALUES ('hotTopicVeryPosts', '25');
INSERT INTO `settings` VALUES ('registration_method', '2');
INSERT INTO `settings` VALUES ('send_validation_onChange', '0');
INSERT INTO `settings` VALUES ('send_welcomeEmail', '1');
INSERT INTO `settings` VALUES ('allow_editDisplayName', '1');
INSERT INTO `settings` VALUES ('allow_hideOnline', '1');
INSERT INTO `settings` VALUES ('guest_hideContacts', '1');
INSERT INTO `settings` VALUES ('spamWaitTime', '5');
INSERT INTO `settings` VALUES ('pm_spam_settings', '10,5,20');
INSERT INTO `settings` VALUES ('reserveWord', '0');
INSERT INTO `settings` VALUES ('reserveCase', '1');
INSERT INTO `settings` VALUES ('reserveUser', '1');
INSERT INTO `settings` VALUES ('reserveName', '1');
INSERT INTO `settings` VALUES ('reserveNames', 'Admin\nWebmaster\nGuest\nroot');
INSERT INTO `settings` VALUES ('autoLinkUrls', '1');
INSERT INTO `settings` VALUES ('banLastUpdated', '0');
INSERT INTO `settings` VALUES ('smileys_dir', 'Smileys');
INSERT INTO `settings` VALUES ('smileys_url', 'http://new.minidvblinux.de/forum/Smileys');
INSERT INTO `settings` VALUES ('avatar_directory', 'avatars');
INSERT INTO `settings` VALUES ('avatar_url', 'http://new.minidvblinux.de/forum/avatars');
INSERT INTO `settings` VALUES ('avatar_max_height_external', '100');
INSERT INTO `settings` VALUES ('avatar_max_width_external', '150');
INSERT INTO `settings` VALUES ('avatar_action_too_large', 'option_html_resize');
INSERT INTO `settings` VALUES ('avatar_max_height_upload', '100');
INSERT INTO `settings` VALUES ('avatar_max_width_upload', '150');
INSERT INTO `settings` VALUES ('avatar_resize_upload', '1');
INSERT INTO `settings` VALUES ('avatar_download_png', '1');
INSERT INTO `settings` VALUES ('failed_login_threshold', '3');
INSERT INTO `settings` VALUES ('oldTopicDays', '120');
INSERT INTO `settings` VALUES ('edit_wait_time', '90');
INSERT INTO `settings` VALUES ('edit_disable_time', '0');
INSERT INTO `settings` VALUES ('autoFixDatabase', '1');
INSERT INTO `settings` VALUES ('allow_guestAccess', '1');
INSERT INTO `settings` VALUES ('time_format', '%B %d, %Y, %I:%M:%S %p');
INSERT INTO `settings` VALUES ('number_format', '1234.00');
INSERT INTO `settings` VALUES ('enableBBC', '1');
INSERT INTO `settings` VALUES ('max_messageLength', '20000');
INSERT INTO `settings` VALUES ('signature_settings', '1,300,10,0,0,300,30,0:');
INSERT INTO `settings` VALUES ('autoOptMaxOnline', '0');
INSERT INTO `settings` VALUES ('defaultMaxMessages', '15');
INSERT INTO `settings` VALUES ('defaultMaxTopics', '20');
INSERT INTO `settings` VALUES ('defaultMaxMembers', '30');
INSERT INTO `settings` VALUES ('enableParticipation', '1');
INSERT INTO `settings` VALUES ('recycle_enable', '0');
INSERT INTO `settings` VALUES ('recycle_board', '0');
INSERT INTO `settings` VALUES ('maxMsgID', '2');
INSERT INTO `settings` VALUES ('enableAllMessages', '0');
INSERT INTO `settings` VALUES ('fixLongWords', '0');
INSERT INTO `settings` VALUES ('knownThemes', '1,2');
INSERT INTO `settings` VALUES ('who_enabled', '1');
INSERT INTO `settings` VALUES ('time_offset', '0');
INSERT INTO `settings` VALUES ('cookieTime', '60');
INSERT INTO `settings` VALUES ('lastActive', '15');
INSERT INTO `settings` VALUES ('smiley_sets_known', 'default,aaron,akyhne');
INSERT INTO `settings` VALUES ('smiley_sets_names', 'Alienine''s Set\nAaron''s Set\nAkyhne''s Set');
INSERT INTO `settings` VALUES ('smiley_sets_default', 'default');
INSERT INTO `settings` VALUES ('cal_days_for_index', '7');
INSERT INTO `settings` VALUES ('requireAgreement', '1');
INSERT INTO `settings` VALUES ('unapprovedMembers', '0');
INSERT INTO `settings` VALUES ('default_personal_text', '');
INSERT INTO `settings` VALUES ('package_make_backups', '1');
INSERT INTO `settings` VALUES ('databaseSession_enable', '1');
INSERT INTO `settings` VALUES ('databaseSession_loose', '1');
INSERT INTO `settings` VALUES ('databaseSession_lifetime', '2880');
INSERT INTO `settings` VALUES ('search_cache_size', '50');
INSERT INTO `settings` VALUES ('search_results_per_page', '30');
INSERT INTO `settings` VALUES ('search_weight_frequency', '30');
INSERT INTO `settings` VALUES ('search_weight_age', '25');
INSERT INTO `settings` VALUES ('search_weight_length', '20');
INSERT INTO `settings` VALUES ('search_weight_subject', '15');
INSERT INTO `settings` VALUES ('search_weight_first_message', '10');
INSERT INTO `settings` VALUES ('search_max_results', '1200');
INSERT INTO `settings` VALUES ('search_floodcontrol_time', '5');
INSERT INTO `settings` VALUES ('permission_enable_deny', '0');
INSERT INTO `settings` VALUES ('permission_enable_postgroups', '0');
INSERT INTO `settings` VALUES ('mail_next_send', '0');
INSERT INTO `settings` VALUES ('mail_recent', '0000000000|0');
INSERT INTO `settings` VALUES ('settings_updated', '1374848672');
INSERT INTO `settings` VALUES ('next_task_time', '1374858000');
INSERT INTO `settings` VALUES ('warning_settings', '1,20,0');
INSERT INTO `settings` VALUES ('warning_watch', '10');
INSERT INTO `settings` VALUES ('warning_moderate', '35');
INSERT INTO `settings` VALUES ('warning_mute', '60');
INSERT INTO `settings` VALUES ('admin_features', '');
INSERT INTO `settings` VALUES ('last_mod_report_action', '0');
INSERT INTO `settings` VALUES ('pruningOptions', '30,180,180,180,30,0');
INSERT INTO `settings` VALUES ('cache_enable', '1');
INSERT INTO `settings` VALUES ('reg_verification', '1');
INSERT INTO `settings` VALUES ('visual_verification_type', '3');
INSERT INTO `settings` VALUES ('enable_buddylist', '1');
INSERT INTO `settings` VALUES ('birthday_email', 'happy_birthday');
INSERT INTO `settings` VALUES ('dont_repeat_theme_core', '1');
INSERT INTO `settings` VALUES ('dont_repeat_smileys_20', '1');
INSERT INTO `settings` VALUES ('dont_repeat_buddylists', '1');
INSERT INTO `settings` VALUES ('attachment_image_reencode', '1');
INSERT INTO `settings` VALUES ('attachment_image_paranoid', '0');
INSERT INTO `settings` VALUES ('attachment_thumb_png', '1');
INSERT INTO `settings` VALUES ('avatar_reencode', '1');
INSERT INTO `settings` VALUES ('avatar_paranoid', '0');
INSERT INTO `settings` VALUES ('global_character_set', 'UTF-8');
INSERT INTO `settings` VALUES ('default_timezone', 'Europe/Berlin');
INSERT INTO `settings` VALUES ('memberlist_updated', '1374756310');
INSERT INTO `settings` VALUES ('latestMember', '1');
INSERT INTO `settings` VALUES ('latestRealName', 'clausmuus');
INSERT INTO `settings` VALUES ('rand_seed', '1391663873');
INSERT INTO `settings` VALUES ('mostOnlineUpdated', '2013-07-26');
INSERT INTO `settings` VALUES ('queryless_urls', '1');
INSERT INTO `settings` VALUES ('hitStats', '1');
INSERT INTO `settings` VALUES ('enableReportPM', '1');
INSERT INTO `settings` VALUES ('calendar_updated', '1374756310');

-- --------------------------------------------------------

-- 
-- Table structure for table `smileys`
-- 

CREATE TABLE `smileys` (
  `id_smiley` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(30) NOT NULL default '',
  `filename` varchar(48) NOT NULL default '',
  `description` varchar(80) NOT NULL default '',
  `smiley_row` tinyint(4) unsigned NOT NULL default '0',
  `smiley_order` smallint(5) unsigned NOT NULL default '0',
  `hidden` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_smiley`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

-- 
-- Dumping data for table `smileys`
-- 

INSERT INTO `smileys` VALUES (1, ':)', 'smiley.gif', 'Smiley', 0, 0, 0);
INSERT INTO `smileys` VALUES (2, ';)', 'wink.gif', 'Wink', 0, 1, 0);
INSERT INTO `smileys` VALUES (3, ':D', 'cheesy.gif', 'Cheesy', 0, 2, 0);
INSERT INTO `smileys` VALUES (4, ';D', 'grin.gif', 'Grin', 0, 3, 0);
INSERT INTO `smileys` VALUES (5, '>:(', 'angry.gif', 'Angry', 0, 4, 0);
INSERT INTO `smileys` VALUES (6, ':(', 'sad.gif', 'Sad', 0, 5, 0);
INSERT INTO `smileys` VALUES (7, ':o', 'shocked.gif', 'Shocked', 0, 6, 0);
INSERT INTO `smileys` VALUES (8, '8)', 'cool.gif', 'Cool', 0, 7, 0);
INSERT INTO `smileys` VALUES (9, '???', 'huh.gif', 'Huh?', 0, 8, 0);
INSERT INTO `smileys` VALUES (10, '::)', 'rolleyes.gif', 'Roll Eyes', 0, 9, 0);
INSERT INTO `smileys` VALUES (11, ':P', 'tongue.gif', 'Tongue', 0, 10, 0);
INSERT INTO `smileys` VALUES (12, ':-[', 'embarrassed.gif', 'Embarrassed', 0, 11, 0);
INSERT INTO `smileys` VALUES (13, ':-X', 'lipsrsealed.gif', 'Lips Sealed', 0, 12, 0);
INSERT INTO `smileys` VALUES (14, ':-\\', 'undecided.gif', 'Undecided', 0, 13, 0);
INSERT INTO `smileys` VALUES (15, ':-*', 'kiss.gif', 'Kiss', 0, 14, 0);
INSERT INTO `smileys` VALUES (16, ':''(', 'cry.gif', 'Cry', 0, 15, 0);
INSERT INTO `smileys` VALUES (17, '>:D', 'evil.gif', 'Evil', 0, 16, 1);
INSERT INTO `smileys` VALUES (18, '^-^', 'azn.gif', 'Azn', 0, 17, 1);
INSERT INTO `smileys` VALUES (19, 'O0', 'afro.gif', 'Afro', 0, 18, 1);
INSERT INTO `smileys` VALUES (20, ':))', 'laugh.gif', 'Laugh', 0, 19, 1);
INSERT INTO `smileys` VALUES (21, 'C:-)', 'police.gif', 'Police', 0, 20, 1);
INSERT INTO `smileys` VALUES (22, 'O:-)', 'angel.gif', 'Angel', 0, 21, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `spiders`
-- 

CREATE TABLE `spiders` (
  `id_spider` smallint(5) unsigned NOT NULL auto_increment,
  `spider_name` varchar(255) NOT NULL default '',
  `user_agent` varchar(255) NOT NULL default '',
  `ip_info` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id_spider`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `spiders`
-- 

INSERT INTO `spiders` VALUES (1, 'Google', 'googlebot', '');
INSERT INTO `spiders` VALUES (2, 'Yahoo!', 'slurp', '');
INSERT INTO `spiders` VALUES (3, 'MSN', 'msnbot', '');
INSERT INTO `spiders` VALUES (4, 'Google (Mobile)', 'Googlebot-Mobile', '');
INSERT INTO `spiders` VALUES (5, 'Google (Image)', 'Googlebot-Image', '');
INSERT INTO `spiders` VALUES (6, 'Google (AdSense)', 'Mediapartners-Google', '');
INSERT INTO `spiders` VALUES (7, 'Google (Adwords)', 'AdsBot-Google', '');
INSERT INTO `spiders` VALUES (8, 'Yahoo! (Mobile)', 'YahooSeeker/M1A1-R2D2', '');
INSERT INTO `spiders` VALUES (9, 'Yahoo! (Image)', 'Yahoo-MMCrawler', '');
INSERT INTO `spiders` VALUES (10, 'MSN (Mobile)', 'MSNBOT_Mobile', '');
INSERT INTO `spiders` VALUES (11, 'MSN (Media)', 'msnbot-media', '');
INSERT INTO `spiders` VALUES (12, 'Cuil', 'twiceler', '');
INSERT INTO `spiders` VALUES (13, 'Ask', 'Teoma', '');
INSERT INTO `spiders` VALUES (14, 'Baidu', 'Baiduspider', '');
INSERT INTO `spiders` VALUES (15, 'Gigablast', 'Gigabot', '');
INSERT INTO `spiders` VALUES (16, 'InternetArchive', 'ia_archiver-web.archive.org', '');
INSERT INTO `spiders` VALUES (17, 'Alexa', 'ia_archiver', '');
INSERT INTO `spiders` VALUES (18, 'Omgili', 'omgilibot', '');
INSERT INTO `spiders` VALUES (19, 'EntireWeb', 'Speedy Spider', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `subscriptions`
-- 

CREATE TABLE `subscriptions` (
  `id_subscribe` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `cost` text NOT NULL,
  `length` varchar(6) NOT NULL default '',
  `id_group` smallint(5) NOT NULL default '0',
  `add_groups` varchar(40) NOT NULL default '',
  `active` tinyint(3) NOT NULL default '1',
  `repeatable` tinyint(3) NOT NULL default '0',
  `allow_partial` tinyint(3) NOT NULL default '0',
  `reminder` tinyint(3) NOT NULL default '0',
  `email_complete` text NOT NULL,
  PRIMARY KEY  (`id_subscribe`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `subscriptions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `themes`
-- 

CREATE TABLE `themes` (
  `id_member` mediumint(8) NOT NULL default '0',
  `id_theme` tinyint(4) unsigned NOT NULL default '1',
  `variable` varchar(255) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id_theme`,`id_member`,`variable`(30)),
  KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `themes`
-- 

INSERT INTO `themes` VALUES (0, 1, 'name', 'SMF Default Theme - Curve');
INSERT INTO `themes` VALUES (0, 1, 'theme_url', 'http://new.minidvblinux.de/forum/Themes/default');
INSERT INTO `themes` VALUES (0, 1, 'images_url', 'http://new.minidvblinux.de/forum/Themes/default/images');
INSERT INTO `themes` VALUES (0, 1, 'theme_dir', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default');
INSERT INTO `themes` VALUES (0, 1, 'show_bbc', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_latest_member', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_modify', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_user_images', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_blurb', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_gender', '0');
INSERT INTO `themes` VALUES (0, 1, 'show_newsfader', '0');
INSERT INTO `themes` VALUES (0, 1, 'number_recent_posts', '10');
INSERT INTO `themes` VALUES (0, 1, 'show_member_bar', '1');
INSERT INTO `themes` VALUES (0, 1, 'linktree_link', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_profile_buttons', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_mark_read', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_stats_index', '1');
INSERT INTO `themes` VALUES (0, 1, 'linktree_inline', '0');
INSERT INTO `themes` VALUES (0, 1, 'show_board_desc', '1');
INSERT INTO `themes` VALUES (0, 1, 'newsfader_time', '5000');
INSERT INTO `themes` VALUES (0, 1, 'allow_no_censored', '0');
INSERT INTO `themes` VALUES (0, 1, 'additional_options_collapsable', '1');
INSERT INTO `themes` VALUES (0, 1, 'use_image_buttons', '1');
INSERT INTO `themes` VALUES (0, 1, 'enable_news', '1');
INSERT INTO `themes` VALUES (0, 1, 'forum_width', '100%');
INSERT INTO `themes` VALUES (0, 2, 'name', 'Core Theme');
INSERT INTO `themes` VALUES (0, 2, 'theme_url', 'http://mld.claus.lbc/forum/Themes/core');
INSERT INTO `themes` VALUES (0, 2, 'images_url', 'http://mld.claus.lbc/forum/Themes/core/images');
INSERT INTO `themes` VALUES (0, 2, 'theme_dir', '/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core');
INSERT INTO `themes` VALUES (-1, 1, 'display_quick_reply', '1');
INSERT INTO `themes` VALUES (-1, 1, 'posts_apply_ignore_list', '1');
INSERT INTO `themes` VALUES (0, 1, 'header_logo_url', '');
INSERT INTO `themes` VALUES (0, 1, 'site_slogan', '');
INSERT INTO `themes` VALUES (0, 1, 'smiley_sets_default', '');
INSERT INTO `themes` VALUES (0, 1, 'show_group_key', '0');
INSERT INTO `themes` VALUES (0, 1, 'display_who_viewing', '0');
INSERT INTO `themes` VALUES (0, 1, 'hide_post_group', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `topics`
-- 

CREATE TABLE `topics` (
  `id_topic` mediumint(8) unsigned NOT NULL auto_increment,
  `is_sticky` tinyint(4) NOT NULL default '0',
  `id_board` smallint(5) unsigned NOT NULL default '0',
  `id_first_msg` int(10) unsigned NOT NULL default '0',
  `id_last_msg` int(10) unsigned NOT NULL default '0',
  `id_member_started` mediumint(8) unsigned NOT NULL default '0',
  `id_member_updated` mediumint(8) unsigned NOT NULL default '0',
  `id_poll` mediumint(8) unsigned NOT NULL default '0',
  `id_previous_board` smallint(5) NOT NULL default '0',
  `id_previous_topic` mediumint(8) NOT NULL default '0',
  `num_replies` int(10) unsigned NOT NULL default '0',
  `num_views` int(10) unsigned NOT NULL default '0',
  `locked` tinyint(4) NOT NULL default '0',
  `unapproved_posts` smallint(5) NOT NULL default '0',
  `approved` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`id_topic`),
  UNIQUE KEY `last_message` (`id_last_msg`,`id_board`),
  UNIQUE KEY `first_message` (`id_first_msg`,`id_board`),
  UNIQUE KEY `poll` (`id_poll`,`id_topic`),
  KEY `is_sticky` (`is_sticky`),
  KEY `approved` (`approved`),
  KEY `id_board` (`id_board`),
  KEY `member_started` (`id_member_started`,`id_board`),
  KEY `last_message_sticky` (`id_board`,`is_sticky`,`id_last_msg`),
  KEY `board_news` (`id_board`,`id_first_msg`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `topics`
-- 

INSERT INTO `topics` VALUES (1, 0, 1, 1, 2, 0, 1, 0, 0, 0, 1, 2, 0, 0, 1);
