-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Gegenereerd op: 03 mei 2016 om 13:55
-- Serverversie: 10.1.13-MariaDB
-- PHP-versie: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `smf`
--

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

--
-- Tabelstructuur voor tabel `smf_admin_info_files`
--

CREATE TABLE `smf_admin_info_files` (
  `id_file` tinyint(4) UNSIGNED NOT NULL,
  `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_admin_info_files`
--

INSERT INTO `smf_admin_info_files` (`id_file`, `filename`, `path`, `parameters`, `data`, `filetype`) VALUES
(1, 'current-version.js', '/smf/', 'version=%3$s', 'window.smfVersion = "SMF 2.0.11";', 'text/javascript'),
(2, 'detailed-version.js', '/smf/', 'language=%1$s&version=%3$s', 'window.smfVersions = {\n	''SMF'': ''SMF 2.0.11'',\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.8'',\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.10'',\n	''SourcesDbPackages-sqlite.php'': ''2.0'',\n	''SourcesDbSearch-mysql.php'': ''2.0'',\n	''SourcesDbSearch-postgresql.php'': ''2.0.7'',\n	''SourcesDbSearch-sqlite.php'': ''2.0.7'',\n	''SourcesDisplay.php'': ''2.0.9'',\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.11'',\n	''SourcesLockTopic.php'': ''2.0'',\n	''SourcesLogInOut.php'': ''2.0.11'',\n	''SourcesManageAttachments.php'': ''2.0.10'',\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.7'',\n	''SourcesManageMembergroups.php'': ''2.0.7'',\n	''SourcesManageMembers.php'': ''2.0.11'',\n	''SourcesManageNews.php'': ''2.0.10'',\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.10'',\n	''SourcesManageSettings.php'': ''2.0.6'',\n	''SourcesManageSmileys.php'': ''2.0'',\n	''SourcesMemberlist.php'': ''2.0.8'',\n	''SourcesMessageIndex.php'': ''2.0.2'',\n	''SourcesModerationCenter.php'': ''2.0.1'',\n	''SourcesModlog.php'': ''2.0.11'',\n	''SourcesMoveTopic.php'': ''2.0'',\n	''SourcesNews.php'': ''2.0.8'',\n	''SourcesNotify.php'': ''2.0'',\n	''SourcesPackageGet.php'': ''2.0.9'',\n	''SourcesPackages.php'': ''2.0.11'',\n	''SourcesPersonalMessage.php'': ''2.0.5'',\n	''SourcesPoll.php'': ''2.0'',\n	''SourcesPost.php'': ''2.0.10'',\n	''SourcesPostModeration.php'': ''2.0'',\n	''SourcesPrintpage.php'': ''2.0'',\n	''SourcesProfile.php'': ''2.0.6'',\n	''SourcesProfile-Actions.php'': ''2.0.6'',\n	''SourcesProfile-Modify.php'': ''2.0.7'',\n	''SourcesProfile-View.php'': ''2.0.5'',\n	''SourcesQueryString.php'': ''2.0.9'',\n	''SourcesRecent.php'': ''2.0'',\n	''SourcesRegister.php'': ''2.0.7'',\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.10'',\n	''SourcesScheduledTasks.php'': ''2.0.9'',\n	''SourcesSearch.php'': ''2.0.9'',\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.11'',\n	''SourcesSubs-Admin.php'': ''2.0'',\n	''SourcesSubs-Auth.php'': ''2.0.11'',\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.9'',\n	''SourcesSubs-Db-postgresql.php'': ''2.0.4'',\n	''SourcesSubs-Db-sqlite.php'': ''2.0'',\n	''SourcesSubs-Editor.php'': ''2.0.11'',\n	''SourcesSubs-Graphics.php'': ''2.0.9'',\n	''SourcesSubs-List.php'': ''2.0'',\n	''SourcesSubs-Membergroups.php'': ''2.0'',\n	''SourcesSubs-Members.php'': ''2.0.7'',\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.11'',\n	''SourcesSubs-Package.php'': ''2.0.10'',\n	''SourcesSubs-Post.php'': ''2.0.10'',\n	''SourcesSubs-Recent.php'': ''2.0'',\n	''SourcesSubscriptions-PayPal.php'': ''2.0.10'',\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.6'',\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.9'',\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.10'',\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.10'',\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.7'',\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.9'',\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.10'',\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.10'',\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.10'',\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.10'',\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'),
(3, 'latest-news.js', '/smf/', 'language=%1$s&format=%2$s', '\nwindow.smfAnnouncements = [\n	{\n		subject: ''SMF 2.0.11 has been released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=539888.0'',\n		time: ''September 18, 2015, 10:56:19 PM'',\n		author: ''Oldiesmann'',\n		message: ''A patch has been released, addressing a vulnerability in SMF 2.0.10. We urge all forum administrators to upgrade as soon as possible. Just visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.1 Beta 2 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=538198.0'',\n		time: ''July 16, 2015, 05:45:30 PM'',\n		author: ''Oldiesmann'',\n		message: ''''\n	},\n	{\n		subject: ''SMF 2.0.10 and 1.1.21 have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=535828.0'',\n		time: ''April 24, 2015, 10:09:00 AM'',\n		author: ''Oldiesmann'',\n		message: ''A patch has been released, addressing a few bugs in SMF 2.0.x and SMF 1.1.x. We urge all forum administrators to upgrade to SMF 2.0.10 or 1.1.21&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.1 Beta 1 released'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=530233.0'',\n		time: ''November 20, 2014, 07:40:06 PM'',\n		author: ''Oldiesmann'',\n		message: ''Simple Machines is proud to announce the first beta of the next version of SMF, with many improvements and new features!''\n	},\n	{\n		subject: ''SMF 2.0.9 and 1.1.20 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=528448.0'',\n		time: ''October 02, 2014, 07:13:50 PM'',\n		author: ''Oldiesmann'',\n		message: ''Critical security patches have been released, addressing a 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.8 released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=524016.0'',\n		time: ''June 18, 2014, 10:11:32 AM'',\n		author: ''Oldiesmann'',\n		message: ''A patch has been released, addressing memory issues with 2.0.7, MySQL 5.6 compatibility issues and a rare memberlist search bug. We urge all forum administrators to upgrade to SMF 2.0.8&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0.7 released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=517205.0'',\n		time: ''January 20, 2014, 09:48:07 PM'',\n		author: ''Oldiesmann'',\n		message: ''A patch has been released, addressing several bugs, including PHP 5.5 compatibility.  We urge all forum administrators to upgrade to SMF 2.0.7&mdash;simply visit the package manager to install the patch.''\n	},\n	{\n		subject: ''SMF 2.0.6 and 1.1.19 security patches have been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=512964.0'',\n		time: ''October 22, 2013, 09:00:00 AM'',\n		author: ''Illori'',\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.5 security patches has been released.'',\n		href: ''http://www.simplemachines.org/community/index.php?topic=509417.0'',\n		time: ''August 12, 2013, 08:34:06 PM'',\n		author: ''Oldiesmann'',\n		message: ''A critical security patch has been released, addressing a few vulnerabilities in SMF 2.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.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 2.0.4")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.5.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.18" || yourVersion == "SMF 2.0.5")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.19_2.0.6.tar.gz";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.19" || yourVersion == "SMF 2.0.8")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.20_2.0.9.zip";\n		window.smfUpdateCritical = true;\n	}\n	else if (yourVersion == "SMF 1.1.20" || yourVersion == "SMF 2.0.9")\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.21_2.0.10.zip";\n	else if (yourVersion == "SMF 2.0.10")\n	{\n		window.smfUpdatePackage = "http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.11.zip";\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 `smf_admin_info_files` (`id_file`, `filename`, `path`, `parameters`, `data`, `filetype`) 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")\n{\n	var version = window.smfVersion;\n\n	// We might need this...\n	var smf_modificationInfo = {};\n	\n	switch (version)\n	{\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "SMF 2.0 RC4":\n			if (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.'';\n			else\n				showLatestPackages();\n			break;\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "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.'';\n			break;\n		case "SMF 2.0.4":\n			window.smfLatestPackages = ''A few security vulnerabilities in SMF 2.0.4 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.5.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.'';\n			break;\n		case "SMF 2.0.5":\n			window.smfLatestPackages = ''A few security vulnerabilities and bugs in SMF 2.0.5 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.19_2.0.6.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.'';\n			break;\n		case "SMF 2.0.6":\n			window.smfLatestPackages = ''PHP 5.5 compatibility issues and several other bugs have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.7.tar.gz;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum and update it to 2.0.7.<br /><br />If you have any problems applying it, you can try to use the upgrade file posted on the downloads page - although, any modifications you have installed will need to be uninstalled when you use that method.<br />Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\n			break;\n		case "SMF 2.0.7":\n			window.smfLatestPackages = ''Memory issues encountered with SMF 2.0.7, some MySQL 5.6 compatibility issues and a rare bug with the memberlist search feature have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.8.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum and update it to 2.0.8.<br /><br />If you have any problems applying it, you can try to use the upgrade file posted on the downloads page - although, any modifications you have installed will need to be uninstalled when you use that method.<br />Please post on the <a href="http://www.simplemachines.org/community/index.php">forum</a> if you need more help.'';\n			break;\n		case "SMF 2.0.8":\n			window.smfLatestPackages = ''A few security vulnerabilities and bugs in SMF 2.0.8 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.20_2.0.9.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum and update it to 2.0.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.'';\n			break;\n		case "SMF 2.0.9":\n			window.smfLatestPackages = ''A few bugs in SMF 2.0.9 have been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_1.1.21_2.0.10.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum and update it to 2.0.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.'';\n			break;\n		case "SMF 2.0.10":\n			window.smfLatestPackages = ''A security vulnerability has been fixed. You can install <a href="'' + window.smfForum_scripturl + actionurl + ''http://custom.simplemachines.org/mods/downloads/smf_patch_2.0.11.zip;'' + window.smfForum_sessionvar + ''='' + window.smfForum_sessionid + ''">this patch (click here to install)</a> to fix your forum and update it to 2.0.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.'';\n			break;\n		default:\n			showLatestPackages();\n			break;\n	}\n}\nelse\n{\n	window.smfLatestPackages = ''For the package manager to function properly, please upgrade to the latest version of SMF.'';\n}\n\n// This function shows latest mods when there isn''t anything else to display\nfunction showLatestPackages()\n{\n	smf_modificationInfo = {\n	\n		4107: {\n			name: ''Avatars on Board and/or MessageIndex 1.3'',\n			versions: [''84''],\n			desc: ''<span style="color: red;" class="bbc_color"><span style="font-size: 14pt;" class="bbc_size"><strong>Avatars on Board and/or MessageIndex</strong></span></span> <br /><br /><strong>For SMF 2.0.x</strong><br /><br /><strong>This mod will display the avatar of last poster in Board(Child)Index and or the avatar of first and or last poster of topics in MessageIndex. <br />Extra setting: Display topic starter time in MessageIndex.</strong><br /><br />Tested only with the SMF default theme...but should work with other Themes, but for sure not by install on the SMF Core Theme<br /><br /><span style="color: red;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size">License</span></strong></span><br /><br />&nbsp;* This SMF modification is subject to the BSD 2-Clause License<br />&nbsp;* Which can be found <a href="http://opensource.org/licenses/BSD-2-Clause" class="bbc_link" target="_blank">here</a><br />&nbsp;<br /><span style="color: red;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size">Settings</span></strong></span><br /><br />- Admin-&gt;Configuration-&gt;Modification Settings-&gt;Avatars on Board/MessageIndex<br /><br /><span style="color: red;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size">Languages</span></strong></span><br /><br />- English/utf8<br />- Spanish_latin/utf8 by <a href="http://www.simplemachines.org/community/index.php?action=profile;u=322597" class="bbc_link" target="_blank">Rock Lee [BC]</a><br />- Portuguese_brazilian/utf8 by <a href="http://www.simplemachines.org/community/index.php?action=profile;u=341618" class="bbc_link" target="_blank">DSystem</a><br /><br /><span style="color: red;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size">Changelog</span></strong></span><br /><br /><strong>Version 1.3 - April 07, 2016</strong><br />- Fixed: Avatar of first poster did not display on MessageIndex avatar upload for specific directory<br />- Fixed: Avatar did not display on ChildBoards on MessageIndex<br />- Added more languages<br /><br /><strong>Version 1.2 - April 07, 2016</strong><br />- Fixed: Avatar did not display when used avatar upload for specific directory<br />- Added: If not selected any avatar in profile the (abm_default)avatar will still link to user profile<br /><br /><strong>Version 1.1 - April 06, 2016</strong><br />- Fixed: LEFT JOIN QUERY, i mixed up the first and last poster on MessageIndex<br /><br /><strong>Version 1.0 - April 03, 2016</strong><br />- Initial Release'',\n			file: ''Avatars_on_Board_MessageIndex_v1.3.zip''\n		},\n		4105: {\n			name: ''Boardnews 1.1'',\n			versions: [''84''],\n			desc: ''smf board news page<br /><img src="http://i.hizliresim.com/JAW0Aj.png" alt="" width="600" height="181" class="bbc_img resized" /><br /><img src="http://i.hizliresim.com/YkVYbj.png" alt="" class="bbc_img" /><br /><img src="http://i.hizliresim.com/BPGq2D.png" alt="" width="510" height="500" class="bbc_img resized" /><br /><br />github <a href="https://github.com/snrj/boardnews" class="bbc_link" target="_blank">https://github.com/snrj/boardnews</a><br /><br />+Add Spanish_latin and Spanish_latin-utf8 Thanks for <a href="http://www.simplemachines.org/community/index.php?action=profile;u=322597" class="bbc_link" target="_blank">Rock Lee [BC]</a><br /><br /><br />Boardnews mod by snrj (smf.konusal.com)<br /><br /><div align="center"><span style="font-size: 18pt;" class="bbc_size"><strong>Bu Boardnews modu smf.konusal.com yapimidir</strong></span></div><div align="center"><span style="font-size: 14pt;" class="bbc_size"><span style="color: green;" class="bbc_color"><strong><a href="http://smf.konusal.com/" class="bbc_link" target="_blank">Smf destek</a></strong></span></span><br /><br /><br /><img src="http://smf.konusal.com/Themes/pisi/images/theme/logo.png" alt="" class="bbc_img" /></div>License<br />This modification is licensed under BSD License (<a href="http://www.opensource.org/licenses/bsd-license.php" class="bbc_link" target="_blank">http://www.opensource.org/licenses/bsd-license.php</a>)<br /><br />Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:<br /><br />Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.<br />Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.<br />The names of the contributors may be not used to endorse or promote products derived from this software without specific prior written permission.<br /><br />THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS &quot;AS IS&quot; AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.'',\n			file: ''boardnews.zip''\n		},\n		4103: {\n			name: ''Show Specified Language 1.0'',\n			versions: [''84''],\n			desc: ''<hr /><div align="center"><span style="color: red;" class="bbc_color"><span style="font-size: 16pt;" class="bbc_size"><strong>SHOW SPECIFIED LANGUAGE v1.0</strong></span></span><br /><a href="http://www.simplemachines.org/community/index.php?action=profile;u=253913" class="bbc_link" target="_blank"><strong>By Dougiefresh</strong></a> -&gt; <a href="http://custom.simplemachines.org/mods/index.php?mod=4103" class="bbc_link" target="_blank">Link to Mod</a><br /></div><hr /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">Introduction</span></span></strong></span><br />This mod allows a user to make a <strong>SINGLE</strong> post in multiple language and show ONLY the appropriate language to the visiting user.<br /><br />For example, if a user posted this:<br /><div class="quoteheader"><div class="topslice_quote">Quote</div></div><blockquote class="bbc_standard_quote">[language=EN]Hi, this is a test[/language]<br />[language=EE]Tere, see on test[/language]<br />[language=ES]Hola, esta es una prueba[/language]<br /></blockquote><div class="quotefooter"><div class="botslice_quote"></div></div>If the user had the Estonian language set, he/she would see this:<br /><div class="quoteheader"><div class="topslice_quote">Quote</div></div><blockquote class="bbc_standard_quote">Tere, see on test<br /></blockquote><div class="quotefooter"><div class="botslice_quote"></div></div>Either the 2-character language code (ex: <strong>en</strong>) or the 5-character code (ex: <strong>en-US</strong>) may be used to specify the language to display.&nbsp; Note that both <strong>en-US</strong> and <strong>en-GB</strong> will be matched to <strong>en</strong>, likewise for other languages.<br /><br />If the user&#039;s language is not found, the code will either display the preferred default language (if specified) <strong>OR</strong> the first language code encountered.<br /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">Admin Settings</span></span></strong></span><br />In <strong>Admin</strong> -&gt; <strong>Configuration</strong> -&gt; <strong>Modification Settings</strong>, there is a new setting: <strong>Default language by language bbcode</strong>.&nbsp; This setting is a language code, as defined by the <a href="http://www.lingoes.net/en/translator/langcode.htm" class="bbc_link" target="_blank">ISO Language Code Table</a>.<br /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">Related Discussion</span></span></strong></span><br />o <a href="http://www.simplemachines.org/community/index.php?topic=544405.0" class="bbc_link" target="_blank">Support for multiple languages!</a><br /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">Compatibility Notes</span></span></strong></span><br />This mod was tested on SMF 2.0.11 and SMF 2.1 Beta 2, but should work on SMF 2.0 and up.&nbsp; SMF 1.x is not and will not be supported.<br /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">Changelog</span></span></strong></span><br />The changelog has been removed and can be seen at <a href="http://www.xptsp.com/board/index.php?topic=674.msg1001#msg1001" class="bbc_link" target="_blank">XPtsp.com</a>.<br /><br /><span style="color: blue;" class="bbc_color"><strong><span style="font-size: 12pt;" class="bbc_size"><span class="bbc_u">License</span></span></strong></span><br />Copyright (c) 2016, Douglas Orend<br />All rights reserved.<br /><br />Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:<br /><br />1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.<br /><br />2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.<br /><br />THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS &quot;AS IS&quot; AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.<br />'',\n			file: ''Show_Only_Specified_Language_v1.0.zip''\n		},\n		2210: {\n			name: ''Google Analytics Code 1.5.1'',\n			versions: [''80''],\n			desc: ''<div align="center"><span style="color: purple;" class="bbc_color"><span style="font-size: 2em;" class="bbc_size"><strong>Google Analytics</strong></span></span></div><div align="center"><a href="http://custom.simplemachines.org/mods/index.php?mod=2210" class="bbc_link" target="_blank"><strong>Link To Mod</strong></a> | <a href="http://www.simplemachines.org/community/index.php?topic=342504.0" class="bbc_link" target="_blank"><strong>Mod Discussion</strong></a> | <a href="http://custom.simplemachines.org/mods/index.php?action=profile;u=1" class="bbc_link" target="_blank"><strong>Other SMF Customization Team Mods</strong></a></div>Original idea and original developer: Arantor, live627.<br /><br /><br /><span style="color: purple;" class="bbc_color"><strong><span style="font-size: 10pt;" class="bbc_size">License</span></strong></span><br /><div class="codeheader">Code: <a href="javascript:void(0);" onclick="return smfSelectText(this);" class="codeoperation">[Select]</a></div><code class="bbc_code">Copyright (c) 2015, Simple Machines<br />All rights reserved.<br /><br />Redistribution and use in source and binary forms, with or without<br />modification, are permitted provided that the following conditions are met:<br />&nbsp; &nbsp; * Redistributions of source code must retain the above copyright<br />&nbsp; &nbsp; &nbsp; notice, this list of conditions and the following disclaimer.<br />&nbsp; &nbsp; * Redistributions in binary form must reproduce the above copyright<br />&nbsp; &nbsp; &nbsp; notice, this list of conditions and the following disclaimer in the<br />&nbsp; &nbsp; &nbsp; documentation and/or other materials provided with the distribution.<br />&nbsp; &nbsp; * Neither the name of the &lt;organization&gt; nor the<br />&nbsp; &nbsp; &nbsp; names of its contributors may be used to endorse or promote products<br />&nbsp; &nbsp; &nbsp; derived from this software without specific prior written permission.<br /><br />THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS &quot;AS IS&quot; AND<br />ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED<br />WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE<br />DISCLAIMED. IN NO EVENT SHALL &lt;COPYRIGHT HOLDER&gt; BE LIABLE FOR ANY<br />DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES<br />(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;<br />LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND<br />ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT<br />(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS<br />SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.<br /></code><br /><br /><span style="color: purple;" class="bbc_color"><strong><span style="font-size: 10pt;" class="bbc_size">Compatibility</span></strong></span><br />SMF 2.0.x<br /><br /><br /><span style="color: purple;" class="bbc_color"><strong><span style="font-size: 10pt;" class="bbc_size">Description</span></strong></span><br />This mod allows a user to specify their Google Analytics code, e.g. UA-00000000-0, in the admin panel and the appropriate loader code will be added automatically.<br /><br />It should work on any theme (no theme edits).<br /><br /><br /><span style="color: purple;" class="bbc_color"><strong><span style="font-size: 10pt;" class="bbc_size">Installation Information</span></strong></span><br />The Package Manager should work in most cases, if you have problems installing please use the discussion topic as well as the <a href="http://wiki.simplemachines.org/smf/Manual_installation_of_mods" class="bbc_link" target="_blank">Manual Installation of Mods</a> wiki page.<br /><br /><span style="color: purple;" class="bbc_color"><strong><span style="font-size: 10pt;" class="bbc_size">Change Log</span></strong></span><br /><span style="font-size: 8pt;" class="bbc_size"><strong>1.5.1 - 07 April 2015</strong><br />Remove unnecessary files.<br />Change license to SMF&#039;s BSD license.<br />Add English-utf8 language file.<br /><br /><strong>1.5 - 17 May 2014</strong><br />Drop support for all 2.0 RC versions<br />Drop support for 1.1.x<br />Drop all file edits<br />Adding the ISC license<br />Changed analytic javascript code from ga.js to analytics.js (see <a href="https://developers.google.com/analytics/devguides/collection/upgrade/reference/gajs-analyticsjs" class="bbc_link" target="_blank">https://developers.google.com/analytics/devguides/collection/upgrade/reference/gajs-analyticsjs</a>)<br /><strong>1.4 - 4 March 2011</strong><br />Fixed error with mod breaking XML responses<br /><strong>1.3 - 10 February 2011</strong><br />2.0 RC4+ no longer requires any theme edits<br />Updated language support<br />Changed analytic javascript code to latest Google recommendations<br /><strong>1.2 - 19 January 2011</strong><br />Added support for 2.0 RC4<br /><strong>1.1 - 22 October 2009</strong><br />Added support for 2.0 RC2<br /><strong>1.0 - October 14, 2009</strong><br />Initial release<br />&nbsp;</span>'',\n			file: ''GoogleAnalytics.zip''\n		}	};\n	var smf_latestModifications = [4107, 4105, 4103];\n	\n	window.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	\n	for (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	\n	window.smfLatestPackages += ''\\\n			</ul>'';\n	\n	if (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>'';\n	else\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(2210);void(0);">Google Analytics Code 1.5.1</a>\\\n			</div>'';\n	\n	window.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\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}', 'text/javascript'),
(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	4099: {\n		name: ''EmojiOne 0.3.1'',\n		versions: [''84''],\n		desc: ''EmojiOne is not BBC but functions in the same space as BBC.<br /><br />This mod add some support for converting emoji decimal input into their hexadecimal counterpart. With the hexadecimal data this mod replaces the decimal data with the appropriate emoji from the EmojiOne CDN server.<br /><br /><strong>License</strong><br />Copyright (c) 2016, Russell Najar<br />All rights reserved.<br /><br />Redistribution and use in source and binary forms, with or without<br />modification, are permitted provided that the following conditions are met:<br /><br />* Redistributions of source code must retain the above copyright notice, this<br />&nbsp; list of conditions and the following disclaimer.<br /><br />* Redistributions in binary form must reproduce the above copyright notice,<br />&nbsp; this list of conditions and the following disclaimer in the documentation<br />&nbsp; and/or other materials provided with the distribution.<br /><br />THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS &quot;AS IS&quot;<br />AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE<br />IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE<br />DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE<br />FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL<br />DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR<br />SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER<br />CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,<br />OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE<br />OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.'',\n		file: ''SMF-EmojiOne.tar.gz''\n	},\n	4049: {\n		name: ''Flat emoji (Twitter Emoji) 1.0.1'',\n		versions: [''81'', ''82''],\n		desc: ''<div align="center"><strong>Flat Emoji</strong><br /><hr /><img src="http://img.iammichael.nl/d26d3.png" alt="" class="bbc_img" /><br /><hr /><br />These flat twitter emoji will make your forum look much better, especially when you like flat design!<br />Originally made for NMOT (<a href="http://nmot.nl" class="bbc_link" target="_blank">http://nmot.nl</a>).</div>'',\n		file: ''FlatEmoji.zip''\n	},\n	4045: {\n		name: ''sdgirlsmilies 1.0'',\n		versions: [''81'', ''82''],\n		desc: ''Set of over-sized smilies of a girls face with the default SMF emotions<br /><br />NOTE: These will also work with SMF 2.1 B1<br /><br /><img src="http://i133.photobucket.com/albums/q72/Grumpy_075/smfsmilies/sdgirldemo.jpg" alt="" class="bbc_img" />'',\n		file: ''sdgirlsmilies.zip''\n	},\n	1513: {\n		name: ''DarkB Smiley set 1.2'',\n		versions: [''41'', ''44'', ''46'', ''49'', ''53'', ''55'', ''58'', ''64'', ''67'', ''70'', ''72'', ''81'', ''63'', ''65'', ''84''],\n		desc: ''This is a set of lightly animated 20*20px smileys fitted to SMF forums using a dark background.&nbsp; The smileys are made in traditional colours - yellow and dark colors.&nbsp; This package only contains the standard smileys used in SMF and not the afro, azn, evil, police, and sleepy custom smileys!!!&nbsp; &nbsp;The DarkB smileys looks terrible in forums with very bright background!!!&nbsp; <br /><br />The DarkB smileys are the same as the <a href="http://custom.simplemachines.org/mods/index.php?mod=1597" class="bbc_link" target="_blank">LightB smileys</a> that are made for bright backgrounds. <br /><br />Added DarkB smileys for Message Icons. It is only the smileys themself and not the Question Mark, Thumb Up etc. that are contained in the DarkB Message Icons. Manual installation note is in the .zip file<br /><br /><span style="color: red;" class="bbc_color">NEW:</span> Added the smileys police, azn, mad, laugh, evil, afro and a few others in version 1.2. You have to add some of these manually in your smiley set.<br /><br /><span style="color: red;" class="bbc_color">NEW:</span> Added the lamp, question mark and exclaim icons to the message icon package.<br /><br />Support site for this mod: <a href="http://www.simplemachines.org/community/index.php?topic=275442.0" class="bbc_link" target="_blank">http://www.simplemachines.org/community/index.php?topic=275442.0</a>'',\n		file: ''DarkB_1.2.zip''\n	},};\nvar smf_latestSmileys = [4099, 4049, 4045];\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(1513);void(0);">DarkB Smiley set 1.2</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'),
(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.11</div>This version fixes a security issue.  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'),
(7, 'latest-themes.js', '/smf/', 'language=%1$s&version=%3$s', '\r\nvar smf_themeInfo = {\r\n	2834: {\r\n		name: ''projectL'',\r\n		desc: ''See this theme in action! <a href="http://demo.studiocrimes.com/index.php?theme=24;variant=wine" class="bbc_link" target="_blank">Live demo available</a><br />Check out the <a href="http://demo.studiocrimes.com/index.php?theme=24;variant=emerald" class="bbc_link" target="_blank">Emerald variant</a><br /><br /><a href="http://studiocrimes.com" class="bbc_link" target="_blank">http://studiocrimes.com</a>'',\r\n		file: ''projectL_2.0.x.zip'',\r\n		author: ''CrimeS''\r\n	},\r\n	2837: {\r\n		name: ''Wide  A Responsive Theme for SMF 2.0.11'',\r\n		desc: ''<span style="color: black;" class="bbc_color">Wide is Super Flexible, Responsive and Bootstrap Based theme with Unlimited Options.</span> Itâ€™s Quite User Friendly with Sticky Tables, Retina Display and Attractive User Interface.'',\r\n		file: ''vVide.zip'',\r\n		author: ''gecitli''\r\n	},\r\n	2836: {\r\n		name: ''Exodus'',\r\n		desc: ''<div align="center"><img src="http://demo.smftricks.com/Themes/Exodus/images/logo.png" alt="" class="bbc_img" /><br /><br /><strong>Theme by <a href="http://smftricks.com/index.php?action=profile;u=2" class="bbc_link" target="_blank">Daniiel</a>. Designed by <a href="http://smftricks.com/index.php?action=profile;u=3458" class="bbc_link" target="_blank">Raphisio</a></strong></div><br /><hr /><br /><ul class="bbc_list"><li>HTML5 &amp; Bootstrap v3.3.4</li><li>FontAwesome v4.4.0 </li><li>Responsive theme</li><li>Custom copyright</li><li>Social icons</li></ul><br /><hr /><br /><div align="center"><img src="http://i.imgur.com/o1i57Wq.png" alt="" width="600" height="374" class="bbc_img resized" /><br /><br /><img src="http://i.imgur.com/gZOVsKU.png" alt="" width="600" height="352" class="bbc_img resized" /></div><br /><strong>Demo: <a href="http://demo.smftricks.com/index.php" class="bbc_link" target="_blank">http://demo.smftricks.com/index.php</a></strong>'',\r\n		file: ''Exodus.zip'',\r\n		author: ''Daniiel''\r\n	},\r\n	2835: {\r\n		name: ''Greeny'',\r\n		desc: ''<div align="center"><a href="http://smftricks.com/" class="bbc_link" target="_blank"><img src="http://smftricks.com/Themes/SMFHispano/images/theme/logo.png" alt="" class="bbc_img" /></a></div><hr /><div align="center"><span style="font-size: 8pt;" class="bbc_size"><em>Theme by <a href="http://smftricks.com/index.php?action=profile;u=3" class="bbc_link" target="_blank">Pipee</a>. Designed by <a href="http://smftricks.com/index.php?action=profile;u=3458" class="bbc_link" target="_blank">Raphisio</a></em></span></div><br /><div align="center"><img src="http://i.imgur.com/prvA2m6.png" alt="" width="600" height="317" class="bbc_img resized" /></div><div align="center"><img src="https://i.imgur.com/V3tA2ao.png" alt="" width="600" height="317" class="bbc_img resized" /></div><br /><hr /><br />Greeny is a Free Responsive Theme.<br /><br /><a href="http://demo.smftricks.com/" class="bbc_link" target="_blank"><img src="http://smftricks.com/Themes/default/images/demo.png" alt="" class="bbc_img" /></a>'',\r\n		file: ''Greeny.zip'',\r\n		author: ''Pipee''\r\n	},\r\n	1897: {\r\n		name: ''WPhotoshop'',\r\n		desc: ''WPhotoshop theme design by WannaBeDie.<br />Current Version:1.1.10<br />You can edit logo and button by yourself.<a href="http://www.smftema.com/demo1/index.php?theme=20" class="bbc_link" target="_blank"><span style="color: red;" class="bbc_color">++Demo</span></a><br />'',\r\n		file: ''WPhotoshop.zip'',\r\n		author: ''WannaBeDie''\r\n	}\r\n};\r\nvar smf_featured = 2834;\r\nvar smf_random = 1897;\r\nvar smf_latestThemes = [2837, 2836, 2835];\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');

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

--
-- Tabelstructuur voor tabel `smf_approval_queue`
--

CREATE TABLE `smf_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=latin1;

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

--
-- Tabelstructuur voor tabel `smf_attachments`
--

CREATE TABLE `smf_attachments` (
  `id_attach` int(10) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_ban_groups`
--

CREATE TABLE `smf_ban_groups` (
  `id_ban_group` mediumint(8) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_ban_items`
--

CREATE TABLE `smf_ban_items` (
  `id_ban` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_boards`
--

CREATE TABLE `smf_boards` (
  `id_board` smallint(5) UNSIGNED NOT NULL,
  `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_boards`
--

INSERT INTO `smf_boards` (`id_board`, `id_cat`, `child_level`, `id_parent`, `board_order`, `id_last_msg`, `id_msg_updated`, `member_groups`, `id_profile`, `name`, `description`, `num_topics`, `num_posts`, `count_posts`, `id_theme`, `override_theme`, `unapproved_posts`, `unapproved_topics`, `redirect`) VALUES
(1, 1, 0, 0, 1, 1, 1, '-1,0,2', 1, 'General Discussion', 'Feel free to talk about anything and everything in this board.', 1, 1, 0, 0, 0, 0, 0, '');

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

--
-- Tabelstructuur voor tabel `smf_board_permissions`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_board_permissions`
--

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

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

--
-- Tabelstructuur voor tabel `smf_calendar`
--

CREATE TABLE `smf_calendar` (
  `id_event` smallint(5) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_calendar_holidays`
--

CREATE TABLE `smf_calendar_holidays` (
  `id_holiday` smallint(5) UNSIGNED NOT NULL,
  `event_date` date NOT NULL DEFAULT '0001-01-01',
  `title` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_calendar_holidays`
--

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

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

--
-- Tabelstructuur voor tabel `smf_categories`
--

CREATE TABLE `smf_categories` (
  `id_cat` tinyint(4) UNSIGNED NOT NULL,
  `cat_order` tinyint(4) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `can_collapse` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_categories`
--

INSERT INTO `smf_categories` (`id_cat`, `cat_order`, `name`, `can_collapse`) VALUES
(1, 0, 'General Category', 1);

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

--
-- Tabelstructuur voor tabel `smf_collapsed_categories`
--

CREATE TABLE `smf_collapsed_categories` (
  `id_cat` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
  `id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_custom_fields`
--

CREATE TABLE `smf_custom_fields` (
  `id_field` smallint(5) NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_group_moderators`
--

CREATE TABLE `smf_group_moderators` (
  `id_group` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_actions`
--

CREATE TABLE `smf_log_actions` (
  `id_action` int(10) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_activity`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_activity`
--

INSERT INTO `smf_log_activity` (`date`, `hits`, `topics`, `posts`, `registers`, `most_on`) VALUES
('2016-04-28', 0, 1, 1, 1, 1),
('2016-04-30', 0, 0, 0, 0, 2);

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

--
-- Tabelstructuur voor tabel `smf_log_banned`
--

CREATE TABLE `smf_log_banned` (
  `id_ban_log` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_boards`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_boards`
--

INSERT INTO `smf_log_boards` (`id_member`, `id_board`, `id_msg`) VALUES
(1, 1, 1);

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

--
-- Tabelstructuur voor tabel `smf_log_comments`
--

CREATE TABLE `smf_log_comments` (
  `id_comment` mediumint(8) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_digest`
--

CREATE TABLE `smf_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=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_errors`
--

CREATE TABLE `smf_log_errors` (
  `id_error` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_errors`
--

INSERT INTO `smf_log_errors` (`id_error`, `log_time`, `id_member`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`) VALUES
(1, 1461871652, 1, '', '?', '8: Undefined index: lang_character_set', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Load.php', 1738),
(2, 1461871652, 1, '', '?', '8: Undefined index: today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 788),
(3, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(4, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(5, 1461871652, 1, '', '?', '8: Undefined index: forum_index', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/BoardIndex.php', 115),
(6, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(7, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(8, 1461871652, 1, '', '?', '8: Undefined index: code', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1086),
(9, 1461871652, 1, '', '?', '8: Undefined index: code_select', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1086),
(10, 1461871652, 1, '', '?', '8: Undefined index: code', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1128),
(11, 1461871652, 1, '', '?', '8: Undefined index: code_select', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1128),
(12, 1461871652, 1, '', '?', '8: Undefined index: quote', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1398),
(13, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1407),
(14, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1414),
(15, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1428),
(16, 1461871652, 1, '', '?', '8: Undefined index: search_on', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1428),
(17, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1437),
(18, 1461871652, 1, '', '?', '8: Undefined index: icon_cheesy', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(19, 1461871652, 1, '', '?', '8: Undefined index: icon_rolleyes', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(20, 1461871652, 1, '', '?', '8: Undefined index: icon_angry', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(21, 1461871652, 1, '', '?', '8: Undefined index: icon_smiley', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(22, 1461871652, 1, '', '?', '8: Undefined index: icon_wink', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(23, 1461871652, 1, '', '?', '8: Undefined index: icon_grin', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(24, 1461871652, 1, '', '?', '8: Undefined index: icon_sad', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(25, 1461871652, 1, '', '?', '8: Undefined index: icon_shocked', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(26, 1461871652, 1, '', '?', '8: Undefined index: icon_cool', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(27, 1461871652, 1, '', '?', '8: Undefined index: icon_tongue', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(28, 1461871652, 1, '', '?', '8: Undefined index: icon_huh', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(29, 1461871652, 1, '', '?', '8: Undefined index: icon_embarrassed', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(30, 1461871652, 1, '', '?', '8: Undefined index: icon_lips', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(31, 1461871652, 1, '', '?', '8: Undefined index: icon_kiss', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(32, 1461871652, 1, '', '?', '8: Undefined index: icon_cry', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(33, 1461871652, 1, '', '?', '8: Undefined index: icon_undecided', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(34, 1461871652, 1, '', '?', '8: Undefined index: home', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3923),
(35, 1461871652, 1, '', '?', '8: Undefined index: help', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3931),
(36, 1461871652, 1, '', '?', '8: Undefined index: search', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3938),
(37, 1461871652, 1, '', '?', '8: Undefined index: admin', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3945),
(38, 1461871652, 1, '', '?', '8: Undefined index: modSettings_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3950),
(39, 1461871652, 1, '', '?', '8: Undefined index: package', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3955),
(40, 1461871652, 1, '', '?', '8: Undefined index: errlog', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3960),
(41, 1461871652, 1, '', '?', '8: Undefined index: edit_permissions', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3965),
(42, 1461871652, 1, '', '?', '8: Undefined index: moderate', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3973),
(43, 1461871652, 1, '', '?', '8: Undefined index: modlog_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3978),
(44, 1461871652, 1, '', '?', '8: Undefined index: mc_unapproved_poststopics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3983),
(45, 1461871652, 1, '', '?', '8: Undefined index: mc_unapproved_attachments', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3988),
(46, 1461871652, 1, '', '?', '8: Undefined index: mc_reported_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3993),
(47, 1461871652, 1, '', '?', '8: Undefined index: profile', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4001),
(48, 1461871652, 1, '', '?', '8: Undefined index: summary', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4006),
(49, 1461871652, 1, '', '?', '8: Undefined index: account', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4011),
(50, 1461871652, 1, '', '?', '8: Undefined index: forumprofile', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4016),
(51, 1461871652, 1, '', '?', '8: Undefined index: pm_short', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4024),
(52, 1461871652, 1, '', '?', '8: Undefined index: pm_menu_read', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4029),
(53, 1461871652, 1, '', '?', '8: Undefined index: pm_menu_send', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4034),
(54, 1461871652, 1, '', '?', '8: Undefined index: calendar', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4042),
(55, 1461871652, 1, '', '?', '8: Undefined index: calendar_menu', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4047),
(56, 1461871652, 1, '', '?', '8: Undefined index: calendar_post_event', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4052),
(57, 1461871652, 1, '', '?', '8: Undefined index: members_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4060),
(58, 1461871652, 1, '', '?', '8: Undefined index: mlist_menu_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4065),
(59, 1461871652, 1, '', '?', '8: Undefined index: mlist_search', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4070),
(60, 1461871652, 1, '', '?', '8: Undefined index: login', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4078),
(61, 1461871652, 1, '', '?', '8: Undefined index: register', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4085),
(62, 1461871652, 1, '', '?', '8: Undefined index: logout', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4093),
(63, 1461871652, 1, '', '?', '8: Undefined index: ajax_in_progress', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 119),
(64, 1461871652, 1, '', '?', '8: Undefined index: modify_cancel', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 120),
(65, 1461871652, 1, '', '?', '8: Undefined index: rss', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 148),
(66, 1461871652, 1, '', '?', '8: Undefined index: hello_member_ndt', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (body_above sub template - eval?)', 287),
(67, 1461871652, 1, '', '?', '8: Undefined index: view_unread_category', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 114),
(68, 1461871652, 1, '', '?', '8: Undefined index: new_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 144),
(69, 1461871652, 1, '', '?', '8: Undefined index: in', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 185),
(70, 1461871652, 1, '', '?', '8: Undefined index: posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 191),
(71, 1461871652, 1, '', '?', '8: Undefined index: board_topics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 192),
(72, 1461871652, 1, '', '?', '8: Undefined index: new_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 250),
(73, 1461871652, 1, '', '?', '8: Undefined index: old_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 251),
(74, 1461871652, 1, '', '?', '8: Undefined index: redirect_board', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 252),
(75, 1461871652, 1, '', '?', '8: Undefined index: mark_as_read', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 480),
(76, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 284),
(77, 1461871652, 1, '', '?', '8: Undefined index: info_center_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 285),
(78, 1461871652, 1, '', '?', '8: Undefined index: forum_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 390),
(79, 1461871652, 1, '', '?', '8: Undefined index: forum_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 391),
(80, 1461871652, 1, '', '?', '8: Undefined index: posts_made', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(81, 1461871652, 1, '', '?', '8: Undefined index: in', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(82, 1461871652, 1, '', '?', '8: Undefined index: topics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(83, 1461871652, 1, '', '?', '8: Undefined index: by', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(84, 1461871652, 1, '', '?', '8: Undefined index: members', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(85, 1461871652, 1, '', '?', '8: Undefined index: latest_member', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(86, 1461871652, 1, '', '?', '8: Undefined index: latest_post', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 397),
(87, 1461871652, 1, '', '?', '8: Undefined index: recent_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 398),
(88, 1461871652, 1, '', '?', '8: Undefined index: more_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 399),
(89, 1461871652, 1, '', '?', '8: Undefined index: online_users', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 408),
(90, 1461871652, 1, '', '?', '8: Undefined index: online_users', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 409),
(91, 1461871652, 1, '', '?', '8: Undefined index: guests', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 414),
(92, 1461871652, 1, '', '?', '8: Undefined index: user', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 414),
(93, 1461871652, 1, '', '?', '8: Undefined index: users_active', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 436),
(94, 1461871652, 1, '', '?', '8: Undefined index: most_online_today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 447),
(95, 1461871652, 1, '', '?', '8: Undefined index: most_online_ever', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 448),
(96, 1461871652, 1, '', '?', '8: Undefined index: today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 788),
(97, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(98, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(99, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 489),
(100, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 491),
(101, 1462012274, 1, '', '?action=topplayers', '2: require_once(D:\\xampp\\htdocs/Sources/TopPlayers.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 374),
(102, 1462012321, 1, '', '?action=banlist', '2: require_once(D:\\xampp\\htdocs/Sources/Banlist.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 375),
(103, 1462012323, 1, '', '?action=banlist', '2: require_once(D:\\xampp\\htdocs/Sources/Banlist.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 375),
(104, 1462012458, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(105, 1462012458, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(106, 1462012475, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(107, 1462012475, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(108, 1462012483, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(109, 1462012483, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(110, 1462012521, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(111, 1462012521, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(112, 1462012531, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(113, 1462012531, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(114, 1462012537, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(115, 1462012537, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(116, 1462012566, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(117, 1462012566, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(118, 1462012572, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(119, 1462012572, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(120, 1462012574, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(121, 1462012574, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(122, 1462012574, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(123, 1462012574, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(124, 1462012576, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(125, 1462012576, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(126, 1462014299, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(127, 1462014299, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(128, 1462014861, 1, '', '?action=topplayers', '2: call_user_func() expects parameter 1 to be a valid callback, function ''TopPlayers'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(129, 1462014861, 1, '', '?action=topplayers', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0);

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

--
-- Tabelstructuur voor tabel `smf_log_floodcontrol`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_floodcontrol`
--

INSERT INTO `smf_log_floodcontrol` (`ip`, `log_time`, `log_type`) VALUES
('', 1462012078, 'login'),
('', 1461872863, 'search'),
('', 1461876534, 'spsbp');

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

--
-- Tabelstructuur voor tabel `smf_log_group_requests`
--

CREATE TABLE `smf_log_group_requests` (
  `id_request` mediumint(8) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_karma`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_mark_read`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_member_notices`
--

CREATE TABLE `smf_log_member_notices` (
  `id_notice` mediumint(8) UNSIGNED NOT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_notify`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_online`
--

CREATE TABLE `smf_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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_online`
--

INSERT INTO `smf_log_online` (`session`, `log_time`, `id_member`, `id_spider`, `ip`, `url`) VALUES
('ip', 1462115180, 0, 0, 0, 'a:1:{s:10:"USER_AGENT";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";}');

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

--
-- Tabelstructuur voor tabel `smf_log_packages`
--

CREATE TABLE `smf_log_packages` (
  `id_install` int(10) NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_packages`
--

INSERT INTO `smf_log_packages` (`id_install`, `filename`, `package_id`, `name`, `version`, `id_member_installed`, `member_installed`, `time_installed`, `id_member_removed`, `member_removed`, `time_removed`, `install_state`, `failed_steps`, `themes_installed`, `db_changes`) VALUES
(1, 'SimplePortal_2.3.6.zip', '[SiNaN]:SimplePortal', 'SimplePortal', '2.3.6', 1, 'admin', 1461876158, 1, 'admin', 1461876257, 0, 'a:0:{}', '1', 'a:8:{i:0;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_parameters";}i:1;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_shoutboxes";}i:2;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_shouts";}i:3;a:2:{i:0;s:12:"remove_table";i:1;s:12:"smf_sp_pages";}i:4;a:2:{i:0;s:12:"remove_table";i:1;s:16:"smf_sp_functions";}i:5;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_blocks";}i:6;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_categories";}i:7;a:2:{i:0;s:12:"remove_table";i:1;s:15:"smf_sp_articles";}}'),
(2, 'SimplePortal_2.3.6.zip', '[SiNaN]:SimplePortal', 'SimplePortal', '2.3.6', 1, 'admin', 1461876271, 0, '0', 0, 1, 'a:0:{}', '1,3', 'a:8:{i:0;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_parameters";}i:1;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_shoutboxes";}i:2;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_shouts";}i:3;a:2:{i:0;s:12:"remove_table";i:1;s:12:"smf_sp_pages";}i:4;a:2:{i:0;s:12:"remove_table";i:1;s:16:"smf_sp_functions";}i:5;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_blocks";}i:6;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_categories";}i:7;a:2:{i:0;s:12:"remove_table";i:1;s:15:"smf_sp_articles";}}');

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

--
-- Tabelstructuur voor tabel `smf_log_polls`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_reported`
--

CREATE TABLE `smf_log_reported` (
  `id_report` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_reported_comments`
--

CREATE TABLE `smf_log_reported_comments` (
  `id_comment` mediumint(8) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_scheduled_tasks`
--

CREATE TABLE `smf_log_scheduled_tasks` (
  `id_log` mediumint(8) NOT NULL,
  `id_task` smallint(5) NOT NULL DEFAULT '0',
  `time_run` int(10) NOT NULL DEFAULT '0',
  `time_taken` float NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_scheduled_tasks`
--

INSERT INTO `smf_log_scheduled_tasks` (`id_log`, `id_task`, `time_run`, `time_taken`) VALUES
(1, 2, 1461870684, 0),
(2, 3, 1461870739, 0),
(3, 5, 1461870924, 0),
(4, 6, 1461870934, 0),
(5, 7, 1461870940, 3),
(6, 9, 1461870942, 0),
(7, 1, 1462012044, 0),
(8, 5, 1462012064, 0),
(9, 3, 1462012078, 0),
(10, 7, 1462012084, 2),
(11, 1, 1462019245, 0),
(12, 1, 1462115181, 0);

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

--
-- Tabelstructuur voor tabel `smf_log_search_messages`
--

CREATE TABLE `smf_log_search_messages` (
  `id_search` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `id_msg` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_search_results`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_search_results`
--

INSERT INTO `smf_log_search_results` (`id_search`, `id_topic`, `id_msg`, `relevance`, `num_matches`) VALUES
(1, 1, 1, 650, 1);

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

--
-- Tabelstructuur voor tabel `smf_log_search_subjects`
--

CREATE TABLE `smf_log_search_subjects` (
  `word` varchar(20) NOT NULL DEFAULT '',
  `id_topic` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_log_search_subjects`
--

INSERT INTO `smf_log_search_subjects` (`word`, `id_topic`) VALUES
('smf', 1),
('to', 1),
('welcome', 1);

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

--
-- Tabelstructuur voor tabel `smf_log_search_topics`
--

CREATE TABLE `smf_log_search_topics` (
  `id_search` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `id_topic` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_spider_hits`
--

CREATE TABLE `smf_log_spider_hits` (
  `id_hit` int(10) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_spider_stats`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_subscribed`
--

CREATE TABLE `smf_log_subscribed` (
  `id_sublog` int(10) UNSIGNED NOT NULL,
  `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_log_topics`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_mail_queue`
--

CREATE TABLE `smf_mail_queue` (
  `id_mail` int(10) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_membergroups`
--

CREATE TABLE `smf_membergroups` (
  `id_group` smallint(5) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_membergroups`
--

INSERT INTO `smf_membergroups` (`id_group`, `group_name`, `description`, `online_color`, `min_posts`, `max_messages`, `stars`, `group_type`, `hidden`, `id_parent`) VALUES
(1, 'Administrator', '', '#FF0000', -1, 0, '5#staradmin.gif', 1, 0, -2),
(2, 'Global Moderator', '', '#0000FF', -1, 0, '5#stargmod.gif', 0, 0, -2),
(3, 'Moderator', '', '', -1, 0, '5#starmod.gif', 0, 0, -2),
(4, 'Newbie', '', '', 0, 0, '1#star.gif', 0, 0, -2),
(5, 'Jr. Member', '', '', 50, 0, '2#star.gif', 0, 0, -2),
(6, 'Full Member', '', '', 100, 0, '3#star.gif', 0, 0, -2),
(7, 'Sr. Member', '', '', 250, 0, '4#star.gif', 0, 0, -2),
(8, 'Hero Member', '', '', 500, 0, '5#star.gif', 0, 0, -2);

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

--
-- Tabelstructuur voor tabel `smf_members`
--

CREATE TABLE `smf_members` (
  `id_member` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_members`
--

INSERT INTO `smf_members` (`id_member`, `member_name`, `date_registered`, `posts`, `id_group`, `lngfile`, `last_login`, `real_name`, `instant_messages`, `unread_messages`, `new_pm`, `buddy_list`, `pm_ignore_list`, `pm_prefs`, `mod_prefs`, `message_labels`, `passwd`, `openid_uri`, `email_address`, `personal_text`, `gender`, `birthdate`, `website_title`, `website_url`, `location`, `icq`, `aim`, `yim`, `msn`, `hide_email`, `show_online`, `time_format`, `signature`, `time_offset`, `avatar`, `pm_email_notify`, `karma_bad`, `karma_good`, `usertitle`, `notify_announcements`, `notify_regularity`, `notify_send_body`, `notify_types`, `member_ip`, `member_ip2`, `secret_question`, `secret_answer`, `id_theme`, `is_activated`, `validation_code`, `id_msg_last_visit`, `additional_groups`, `smiley_set`, `id_post_group`, `total_time_logged_in`, `password_salt`, `ignore_boards`, `warning`, `passwd_flood`, `pm_receive_from`) VALUES
(1, 'admin', 1461870586, 0, 1, '', 1462014901, 'admin', 0, 0, 0, '', '', 0, '', '', '1e496d95637d527c76d2a362dae3873097a110aa', '', 'reinier.dorst1@hotmail.com', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, 0, 2, '', '', '', '', 0, 1, '', 1, '', '', 0, 7276, 'd908', '', 0, '', 1);

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

--
-- Tabelstructuur voor tabel `smf_messages`
--

CREATE TABLE `smf_messages` (
  `id_msg` int(10) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_messages`
--

INSERT INTO `smf_messages` (`id_msg`, `id_topic`, `id_board`, `poster_time`, `id_member`, `id_msg_modified`, `subject`, `poster_name`, `poster_email`, `poster_ip`, `smileys_enabled`, `modified_time`, `modified_name`, `body`, `icon`, `approved`) VALUES
(1, 1, 1, 1461870549, 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);

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

--
-- Tabelstructuur voor tabel `smf_message_icons`
--

CREATE TABLE `smf_message_icons` (
  `id_icon` smallint(5) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_message_icons`
--

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

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

--
-- Tabelstructuur voor tabel `smf_moderators`
--

CREATE TABLE `smf_moderators` (
  `id_board` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_openid_assoc`
--

CREATE TABLE `smf_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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_package_servers`
--

CREATE TABLE `smf_package_servers` (
  `id_server` smallint(5) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_package_servers`
--

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

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

--
-- Tabelstructuur voor tabel `smf_permissions`
--

CREATE TABLE `smf_permissions` (
  `id_group` smallint(5) NOT NULL DEFAULT '0',
  `permission` varchar(30) NOT NULL DEFAULT '',
  `add_deny` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_permissions`
--

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

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

--
-- Tabelstructuur voor tabel `smf_permission_profiles`
--

CREATE TABLE `smf_permission_profiles` (
  `id_profile` smallint(5) NOT NULL,
  `profile_name` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_permission_profiles`
--

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

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

--
-- Tabelstructuur voor tabel `smf_personal_messages`
--

CREATE TABLE `smf_personal_messages` (
  `id_pm` int(10) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_pm_recipients`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_pm_rules`
--

CREATE TABLE `smf_pm_rules` (
  `id_rule` int(10) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_polls`
--

CREATE TABLE `smf_polls` (
  `id_poll` mediumint(8) UNSIGNED NOT NULL,
  `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_poll_choices`
--

CREATE TABLE `smf_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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_scheduled_tasks`
--

CREATE TABLE `smf_scheduled_tasks` (
  `id_task` smallint(5) NOT NULL,
  `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_scheduled_tasks`
--

INSERT INTO `smf_scheduled_tasks` (`id_task`, `next_time`, `time_offset`, `time_regularity`, `time_unit`, `disabled`, `task`) VALUES
(1, 1462125600, 0, 2, 'h', 0, 'approval_notification'),
(2, 1462406400, 0, 7, 'd', 0, 'auto_optimize'),
(3, 1462060860, 60, 1, 'd', 0, 'daily_maintenance'),
(5, 1462060800, 0, 1, 'd', 0, 'daily_digest'),
(6, 1462406400, 0, 1, 'w', 0, 'weekly_digest'),
(7, 1462062720, 88333, 1, 'd', 0, 'fetchSMfiles'),
(8, 0, 0, 1, 'd', 1, 'birthdayemails'),
(9, 1462406400, 0, 1, 'w', 0, 'weekly_maintenance'),
(10, 0, 120, 1, 'd', 1, 'paid_subscriptions');

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

--
-- Tabelstructuur voor tabel `smf_sessions`
--

CREATE TABLE `smf_sessions` (
  `session_id` char(32) NOT NULL,
  `last_update` int(10) UNSIGNED NOT NULL,
  `data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_sessions`
--

INSERT INTO `smf_sessions` (`session_id`, `last_update`, `data`) VALUES
('ui9a3moe6gncdt3b14dqq3rou3', 1461870586, 'USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";admin_time|i:1461870586;'),
('bqv8buesk23e3pmgbfi51p8r11', 1461879305, 'session_value|s:32:"94f10b0c80d4ed15c246f44fb84fb32d";session_var|s:10:"af192ee9f2";mc|a:7:{s:4:"time";i:1461878624;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:1461878624;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1461879305;timeOnlineUpdated|i:1461879305;old_url|s:39:"http://localhost/index.php?action=forum";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";login_SMFCookie956|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"a891bdc453931df91a819605d55c5197d94e220e";i:2;i:1461882224;i:3;i:2;}";admin_time|i:1461878624;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1461878624;s:7:"reports";s:1:"0";}unread_messages|i:0;'),
('amks3auakl0ugk1k7g10elt6u7', 1462015686, 'session_value|s:32:"81b3f144d341b43c8fd19b1b254e3aa3";session_var|s:10:"fb760256ae";mc|a:7:{s:4:"time";i:1462015685;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462015686;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462015685;timeOnlineUpdated|i:1462014901;old_url|s:39:"http://localhost/index.php?action=forum";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";login_SMFCookie956|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"a891bdc453931df91a819605d55c5197d94e220e";i:2;i:1462015678;i:3;i:2;}";admin_time|i:1462012078;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1462012078;s:7:"reports";s:1:"0";}unread_messages|i:0;'),
('g6g4e47ac2pq2d2icumn4r60o6', 1462019315, 'session_value|s:32:"b881e8a068acae3fa5f07c7c7d358912";session_var|s:12:"c0bdf59bbade";mc|a:7:{s:4:"time";i:1462019245;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462019315;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462019314;timeOnlineUpdated|i:1462019245;old_url|s:26:"http://localhost/index.php";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";'),
('fmmog9t570cdkpci180mmo4um4', 1462117581, 'session_value|s:32:"6c9781c1115e9371ac74f2a4c7e68a88";session_var|s:9:"b3cf22060";mc|a:7:{s:4:"time";i:1462115180;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462115180;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462115180;timeOnlineUpdated|i:1462115180;old_url|s:26:"http://localhost/index.php";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";');

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

--
-- Tabelstructuur voor tabel `smf_settings`
--

CREATE TABLE `smf_settings` (
  `variable` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_settings`
--

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

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

--
-- Tabelstructuur voor tabel `smf_smileys`
--

CREATE TABLE `smf_smileys` (
  `id_smiley` smallint(5) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_smileys`
--

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

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

--
-- Tabelstructuur voor tabel `smf_spiders`
--

CREATE TABLE `smf_spiders` (
  `id_spider` smallint(5) UNSIGNED NOT NULL,
  `spider_name` varchar(255) NOT NULL DEFAULT '',
  `user_agent` varchar(255) NOT NULL DEFAULT '',
  `ip_info` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_spiders`
--

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

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

--
-- Tabelstructuur voor tabel `smf_sp_articles`
--

CREATE TABLE `smf_sp_articles` (
  `id_article` int(10) NOT NULL,
  `id_category` int(10) NOT NULL DEFAULT '0',
  `id_message` int(10) NOT NULL DEFAULT '0',
  `approved` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_sp_blocks`
--

CREATE TABLE `smf_sp_blocks` (
  `id_block` int(10) NOT NULL,
  `label` tinytext NOT NULL,
  `type` text NOT NULL,
  `col` tinyint(4) NOT NULL DEFAULT '0',
  `row` tinyint(4) NOT NULL DEFAULT '0',
  `permission_set` tinyint(4) NOT NULL DEFAULT '0',
  `groups_allowed` varchar(255) NOT NULL DEFAULT '',
  `groups_denied` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(4) NOT NULL DEFAULT '1',
  `force_view` tinyint(2) NOT NULL DEFAULT '0',
  `display` text NOT NULL,
  `display_custom` text NOT NULL,
  `style` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_blocks`
--

INSERT INTO `smf_sp_blocks` (`id_block`, `label`, `type`, `col`, `row`, `permission_set`, `groups_allowed`, `groups_denied`, `state`, `force_view`, `display`, `display_custom`, `style`) VALUES
(1, 'User Info', 'sp_userInfo', 1, 1, 3, '', '', 1, 0, '', '', ''),
(2, 'Who&#039;s Online', 'sp_whosOnline', 1, 2, 3, '', '', 1, 0, '', '', ''),
(3, 'Board Stats', 'sp_boardStats', 1, 3, 3, '', '', 1, 0, '', '', ''),
(4, 'Theme Select', 'sp_theme_select', 1, 4, 3, '', '', 1, 0, '', '', ''),
(5, 'Search', 'sp_quickSearch', 1, 5, 3, '', '', 1, 0, '', '', ''),
(6, 'News', 'sp_news', 2, 1, 3, '', '', 1, 0, '', '', 'title_default_class~|title_custom_class~|title_custom_style~|body_default_class~windowbg|body_custom_class~|body_custom_style~|no_title~1|no_body~'),
(7, 'Welcome', 'sp_html', 2, 2, 3, '', '', 1, 0, '', '', 'title_default_class~|title_custom_class~|title_custom_style~|body_default_class~windowbg|body_custom_class~|body_custom_style~|no_title~1|no_body~'),
(8, 'Board News', 'sp_boardNews', 2, 3, 3, '', '', 1, 0, '', '', ''),
(9, 'Recent Topics', 'sp_recent', 3, 1, 3, '', '', 1, 0, '', '', ''),
(10, 'Top Poster', 'sp_topPoster', 4, 1, 3, '', '', 1, 0, '', '', ''),
(11, 'Recent Posts', 'sp_recent', 4, 2, 3, '', '', 1, 0, '', '', ''),
(12, 'Forum Staff', 'sp_staff', 4, 3, 3, '', '', 1, 0, '', '', ''),
(13, 'Calendar', 'sp_calendar', 4, 4, 3, '', '', 1, 0, '', '', ''),
(14, 'Top Boards', 'sp_topBoards', 4, 5, 3, '', '', 1, 0, '', '', '');

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

--
-- Tabelstructuur voor tabel `smf_sp_categories`
--

CREATE TABLE `smf_sp_categories` (
  `id_category` int(10) NOT NULL,
  `name` tinytext NOT NULL,
  `picture` tinytext NOT NULL,
  `articles` tinyint(4) NOT NULL DEFAULT '0',
  `publish` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_sp_functions`
--

CREATE TABLE `smf_sp_functions` (
  `id_function` tinyint(4) NOT NULL,
  `function_order` tinyint(4) NOT NULL DEFAULT '0',
  `name` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_functions`
--

INSERT INTO `smf_sp_functions` (`id_function`, `function_order`, `name`) VALUES
(1, 1, 'sp_userInfo'),
(2, 2, 'sp_latestMember'),
(3, 3, 'sp_whosOnline'),
(5, 4, 'sp_boardStats'),
(7, 5, 'sp_topPoster'),
(35, 6, 'sp_topStatsMember'),
(23, 7, 'sp_recent'),
(9, 8, 'sp_topTopics'),
(8, 9, 'sp_topBoards'),
(4, 10, 'sp_showPoll'),
(12, 11, 'sp_boardNews'),
(6, 12, 'sp_quickSearch'),
(13, 13, 'sp_news'),
(20, 14, 'sp_attachmentImage'),
(21, 15, 'sp_attachmentRecent'),
(27, 16, 'sp_calendar'),
(24, 17, 'sp_calendarInformation'),
(25, 18, 'sp_rssFeed'),
(28, 19, 'sp_theme_select'),
(29, 20, 'sp_staff'),
(31, 21, 'sp_articles'),
(36, 22, 'sp_shoutbox'),
(26, 23, 'sp_gallery'),
(32, 24, 'sp_arcade'),
(33, 25, 'sp_shop'),
(30, 26, 'sp_blog'),
(10, 27, 'sp_menu'),
(19, 98, 'sp_bbc'),
(17, 99, 'sp_html'),
(18, 100, 'sp_php');

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

--
-- Tabelstructuur voor tabel `smf_sp_pages`
--

CREATE TABLE `smf_sp_pages` (
  `id_page` int(10) NOT NULL,
  `namespace` tinytext NOT NULL,
  `title` tinytext NOT NULL,
  `body` mediumtext NOT NULL,
  `type` tinytext NOT NULL,
  `permission_set` tinyint(4) NOT NULL DEFAULT '0',
  `groups_allowed` varchar(255) NOT NULL DEFAULT '',
  `groups_denied` varchar(255) NOT NULL DEFAULT '',
  `views` int(10) NOT NULL DEFAULT '0',
  `style` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_sp_parameters`
--

CREATE TABLE `smf_sp_parameters` (
  `id_block` int(10) NOT NULL DEFAULT '0',
  `variable` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_parameters`
--

INSERT INTO `smf_sp_parameters` (`id_block`, `variable`, `value`) VALUES
(7, 'content', '&lt;h2 style=&quot;text-align: center;&quot;&gt;Welcome to SimplePortal!&lt;/h2&gt;\n&lt;p&gt;SimplePortal is one of several portal mods for Simple Machines Forum (SMF). Although always developing, SimplePortal is produced with the user in mind first. User feedback is the number one method of growth for SimplePortal, and our users are always finding ways for SimplePortal to grow. SimplePortal stays competative with other portal software by adding numerous user-requested features such as articles, block types and the ability to completely customize the portal page.&lt;/p&gt;\n&lt;p&gt;All this and SimplePortal has remained Simple! SimplePortal is built for simplicity and ease of use; ensuring the average forum administrator can install SimplePortal, configure a few settings, and show off the brand new portal to the users in minutes. Confusing menus, undesired pre-loaded blocks and settings that cannot be found are all avoided as much as possible. Because when it comes down to it, SimplePortal is YOUR portal, and should reflect your taste as much as possible.&lt;/p&gt;\n&lt;p&gt;&lt;strong&gt;Ultimate Simplicity&lt;/strong&gt;\n&lt;br /&gt;\nThe simplest portal you can ever think of... You only need a few clicks to install it through Package Manager. A few more to create your own blocks and articles. Your portal is ready to go within a couple of minutes, and simple to customise to reflect YOU.&lt;/p&gt;\n&lt;p&gt;&lt;strong&gt;Install Friendly&lt;/strong&gt;\n&lt;br /&gt;\nWith the ingenius design of install and update packages, SimplePortal is incredibly install and update friendly. You will never need any manual changes even on a heavily modified forum.&lt;/p&gt;\n&lt;p&gt;&lt;strong&gt;Incredible Theme Support&lt;/strong&gt;\n&lt;br /&gt;\nThe simple but powerful structure of SimplePortal brings you wide-range theme support too. You can use SimplePortal with all SMF themes by just adding a button for it.&lt;/p&gt;\n&lt;p&gt;&lt;strong&gt;Professional Support&lt;/strong&gt;\n&lt;br /&gt;\nSimplePortal offers high quality professional support with its own well known support team.&lt;/p&gt;'),
(8, 'avatar', '1'),
(8, 'per_page', '3'),
(13, 'events', '1'),
(13, 'birthdays', '1'),
(13, 'holidays', '1'),
(9, 'type', '1'),
(9, 'display', '1');

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

--
-- Tabelstructuur voor tabel `smf_sp_shoutboxes`
--

CREATE TABLE `smf_sp_shoutboxes` (
  `id_shoutbox` int(10) NOT NULL,
  `name` tinytext NOT NULL,
  `permission_set` tinyint(4) NOT NULL DEFAULT '0',
  `groups_allowed` varchar(255) NOT NULL DEFAULT '',
  `groups_denied` varchar(255) NOT NULL DEFAULT '',
  `moderator_groups` text NOT NULL,
  `warning` text NOT NULL,
  `allowed_bbc` text NOT NULL,
  `height` smallint(5) NOT NULL DEFAULT '200',
  `num_show` smallint(5) NOT NULL DEFAULT '20',
  `num_max` mediumint(8) NOT NULL DEFAULT '1000',
  `refresh` tinyint(4) NOT NULL DEFAULT '1',
  `reverse` tinyint(4) NOT NULL DEFAULT '0',
  `caching` tinyint(4) NOT NULL DEFAULT '1',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `num_shouts` mediumint(8) NOT NULL DEFAULT '0',
  `last_update` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_shoutboxes`
--

INSERT INTO `smf_sp_shoutboxes` (`id_shoutbox`, `name`, `permission_set`, `groups_allowed`, `groups_denied`, `moderator_groups`, `warning`, `allowed_bbc`, `height`, `num_show`, `num_max`, `refresh`, `reverse`, `caching`, `status`, `num_shouts`, `last_update`) VALUES
(1, 'Untitled Shoutbox', 3, '', '', '', '', 'b,i,u,s,url,code,quote,me', 200, 20, 1000, 0, 0, 1, 1, 0, 1461876538);

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

--
-- Tabelstructuur voor tabel `smf_sp_shouts`
--

CREATE TABLE `smf_sp_shouts` (
  `id_shout` mediumint(8) NOT NULL,
  `id_shoutbox` int(10) NOT NULL DEFAULT '0',
  `id_member` mediumint(8) NOT NULL DEFAULT '0',
  `member_name` varchar(80) NOT NULL DEFAULT '0',
  `log_time` int(10) NOT NULL DEFAULT '0',
  `body` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_subscriptions`
--

CREATE TABLE `smf_subscriptions` (
  `id_subscribe` mediumint(8) UNSIGNED NOT NULL,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabelstructuur voor tabel `smf_themes`
--

CREATE TABLE `smf_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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_themes`
--

INSERT INTO `smf_themes` (`id_member`, `id_theme`, `variable`, `value`) VALUES
(0, 1, 'name', 'SMF Default Theme - Curve'),
(0, 1, 'theme_url', 'http://localhost/Themes/default'),
(0, 1, 'images_url', 'http://localhost/Themes/default/images'),
(0, 1, 'theme_dir', 'D:\\xampp\\htdocs/Themes/default'),
(0, 1, 'show_bbc', '1'),
(0, 1, 'show_latest_member', '1'),
(0, 1, 'show_modify', '1'),
(0, 1, 'show_user_images', '1'),
(0, 1, 'show_blurb', '1'),
(0, 1, 'show_gender', '0'),
(0, 1, 'show_newsfader', '0'),
(0, 1, 'number_recent_posts', '0'),
(0, 1, 'show_member_bar', '1'),
(0, 1, 'linktree_link', '1'),
(0, 1, 'show_profile_buttons', '1'),
(0, 1, 'show_mark_read', '1'),
(0, 1, 'show_stats_index', '1'),
(0, 1, 'linktree_inline', '0'),
(0, 1, 'show_board_desc', '1'),
(0, 1, 'newsfader_time', '5000'),
(0, 1, 'allow_no_censored', '0'),
(0, 1, 'additional_options_collapsable', '1'),
(0, 1, 'use_image_buttons', '1'),
(0, 1, 'enable_news', '1'),
(0, 1, 'forum_width', '90%'),
(0, 2, 'name', 'Core Theme'),
(0, 2, 'theme_url', 'http://localhost/Themes/core'),
(0, 2, 'images_url', 'http://localhost/Themes/core/images'),
(0, 2, 'theme_dir', 'D:\\xampp\\htdocs/Themes/core'),
(-1, 1, 'display_quick_reply', '1'),
(-1, 1, 'posts_apply_ignore_list', '1'),
(0, 3, 'theme_url', 'http://localhost/Themes/gearbox_20a'),
(0, 3, 'images_url', 'http://localhost/Themes/gearbox_20a/images'),
(0, 3, 'theme_dir', 'D:\\xampp\\htdocs/Themes/gearbox_20a'),
(0, 3, 'name', 'Gearbox'),
(0, 3, 'theme_layers', 'html,body'),
(0, 3, 'theme_templates', 'index'),
(1, 3, 'sp_block_1', '0'),
(1, 3, 'use_sidebar_menu', '1');

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

--
-- Tabelstructuur voor tabel `smf_topics`
--

CREATE TABLE `smf_topics` (
  `id_topic` mediumint(8) UNSIGNED NOT NULL,
  `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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `smf_topics`
--

INSERT INTO `smf_topics` (`id_topic`, `is_sticky`, `id_board`, `id_first_msg`, `id_last_msg`, `id_member_started`, `id_member_updated`, `id_poll`, `id_previous_board`, `id_previous_topic`, `num_replies`, `num_views`, `locked`, `unapproved_posts`, `approved`) VALUES
(1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `smf_admin_info_files`
--
ALTER TABLE `smf_admin_info_files`
  ADD PRIMARY KEY (`id_file`),
  ADD KEY `filename` (`filename`(30));

--
-- Indexen voor tabel `smf_attachments`
--
ALTER TABLE `smf_attachments`
  ADD PRIMARY KEY (`id_attach`),
  ADD UNIQUE KEY `id_member` (`id_member`,`id_attach`),
  ADD KEY `id_msg` (`id_msg`),
  ADD KEY `attachment_type` (`attachment_type`);

--
-- Indexen voor tabel `smf_ban_groups`
--
ALTER TABLE `smf_ban_groups`
  ADD PRIMARY KEY (`id_ban_group`);

--
-- Indexen voor tabel `smf_ban_items`
--
ALTER TABLE `smf_ban_items`
  ADD PRIMARY KEY (`id_ban`),
  ADD KEY `id_ban_group` (`id_ban_group`);

--
-- Indexen voor tabel `smf_boards`
--
ALTER TABLE `smf_boards`
  ADD PRIMARY KEY (`id_board`),
  ADD UNIQUE KEY `categories` (`id_cat`,`id_board`),
  ADD KEY `id_parent` (`id_parent`),
  ADD KEY `id_msg_updated` (`id_msg_updated`),
  ADD KEY `member_groups` (`member_groups`(48));

--
-- Indexen voor tabel `smf_board_permissions`
--
ALTER TABLE `smf_board_permissions`
  ADD PRIMARY KEY (`id_group`,`id_profile`,`permission`);

--
-- Indexen voor tabel `smf_calendar`
--
ALTER TABLE `smf_calendar`
  ADD PRIMARY KEY (`id_event`),
  ADD KEY `start_date` (`start_date`),
  ADD KEY `end_date` (`end_date`),
  ADD KEY `topic` (`id_topic`,`id_member`);

--
-- Indexen voor tabel `smf_calendar_holidays`
--
ALTER TABLE `smf_calendar_holidays`
  ADD PRIMARY KEY (`id_holiday`),
  ADD KEY `event_date` (`event_date`);

--
-- Indexen voor tabel `smf_categories`
--
ALTER TABLE `smf_categories`
  ADD PRIMARY KEY (`id_cat`);

--
-- Indexen voor tabel `smf_collapsed_categories`
--
ALTER TABLE `smf_collapsed_categories`
  ADD PRIMARY KEY (`id_cat`,`id_member`);

--
-- Indexen voor tabel `smf_custom_fields`
--
ALTER TABLE `smf_custom_fields`
  ADD PRIMARY KEY (`id_field`),
  ADD UNIQUE KEY `col_name` (`col_name`);

--
-- Indexen voor tabel `smf_group_moderators`
--
ALTER TABLE `smf_group_moderators`
  ADD PRIMARY KEY (`id_group`,`id_member`);

--
-- Indexen voor tabel `smf_log_actions`
--
ALTER TABLE `smf_log_actions`
  ADD PRIMARY KEY (`id_action`),
  ADD KEY `id_log` (`id_log`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `id_member` (`id_member`),
  ADD KEY `id_board` (`id_board`),
  ADD KEY `id_msg` (`id_msg`);

--
-- Indexen voor tabel `smf_log_activity`
--
ALTER TABLE `smf_log_activity`
  ADD PRIMARY KEY (`date`),
  ADD KEY `most_on` (`most_on`);

--
-- Indexen voor tabel `smf_log_banned`
--
ALTER TABLE `smf_log_banned`
  ADD PRIMARY KEY (`id_ban_log`),
  ADD KEY `log_time` (`log_time`);

--
-- Indexen voor tabel `smf_log_boards`
--
ALTER TABLE `smf_log_boards`
  ADD PRIMARY KEY (`id_member`,`id_board`);

--
-- Indexen voor tabel `smf_log_comments`
--
ALTER TABLE `smf_log_comments`
  ADD PRIMARY KEY (`id_comment`),
  ADD KEY `id_recipient` (`id_recipient`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `comment_type` (`comment_type`);

--
-- Indexen voor tabel `smf_log_errors`
--
ALTER TABLE `smf_log_errors`
  ADD PRIMARY KEY (`id_error`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `id_member` (`id_member`),
  ADD KEY `ip` (`ip`);

--
-- Indexen voor tabel `smf_log_floodcontrol`
--
ALTER TABLE `smf_log_floodcontrol`
  ADD PRIMARY KEY (`ip`,`log_type`);

--
-- Indexen voor tabel `smf_log_group_requests`
--
ALTER TABLE `smf_log_group_requests`
  ADD PRIMARY KEY (`id_request`),
  ADD UNIQUE KEY `id_member` (`id_member`,`id_group`);

--
-- Indexen voor tabel `smf_log_karma`
--
ALTER TABLE `smf_log_karma`
  ADD PRIMARY KEY (`id_target`,`id_executor`),
  ADD KEY `log_time` (`log_time`);

--
-- Indexen voor tabel `smf_log_mark_read`
--
ALTER TABLE `smf_log_mark_read`
  ADD PRIMARY KEY (`id_member`,`id_board`);

--
-- Indexen voor tabel `smf_log_member_notices`
--
ALTER TABLE `smf_log_member_notices`
  ADD PRIMARY KEY (`id_notice`);

--
-- Indexen voor tabel `smf_log_notify`
--
ALTER TABLE `smf_log_notify`
  ADD PRIMARY KEY (`id_member`,`id_topic`,`id_board`),
  ADD KEY `id_topic` (`id_topic`,`id_member`);

--
-- Indexen voor tabel `smf_log_online`
--
ALTER TABLE `smf_log_online`
  ADD PRIMARY KEY (`session`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `id_member` (`id_member`);

--
-- Indexen voor tabel `smf_log_packages`
--
ALTER TABLE `smf_log_packages`
  ADD PRIMARY KEY (`id_install`),
  ADD KEY `filename` (`filename`(15));

--
-- Indexen voor tabel `smf_log_polls`
--
ALTER TABLE `smf_log_polls`
  ADD KEY `id_poll` (`id_poll`,`id_member`,`id_choice`);

--
-- Indexen voor tabel `smf_log_reported`
--
ALTER TABLE `smf_log_reported`
  ADD PRIMARY KEY (`id_report`),
  ADD KEY `id_member` (`id_member`),
  ADD KEY `id_topic` (`id_topic`),
  ADD KEY `closed` (`closed`),
  ADD KEY `time_started` (`time_started`),
  ADD KEY `id_msg` (`id_msg`);

--
-- Indexen voor tabel `smf_log_reported_comments`
--
ALTER TABLE `smf_log_reported_comments`
  ADD PRIMARY KEY (`id_comment`),
  ADD KEY `id_report` (`id_report`),
  ADD KEY `id_member` (`id_member`),
  ADD KEY `time_sent` (`time_sent`);

--
-- Indexen voor tabel `smf_log_scheduled_tasks`
--
ALTER TABLE `smf_log_scheduled_tasks`
  ADD PRIMARY KEY (`id_log`);

--
-- Indexen voor tabel `smf_log_search_messages`
--
ALTER TABLE `smf_log_search_messages`
  ADD PRIMARY KEY (`id_search`,`id_msg`);

--
-- Indexen voor tabel `smf_log_search_results`
--
ALTER TABLE `smf_log_search_results`
  ADD PRIMARY KEY (`id_search`,`id_topic`);

--
-- Indexen voor tabel `smf_log_search_subjects`
--
ALTER TABLE `smf_log_search_subjects`
  ADD PRIMARY KEY (`word`,`id_topic`),
  ADD KEY `id_topic` (`id_topic`);

--
-- Indexen voor tabel `smf_log_search_topics`
--
ALTER TABLE `smf_log_search_topics`
  ADD PRIMARY KEY (`id_search`,`id_topic`);

--
-- Indexen voor tabel `smf_log_spider_hits`
--
ALTER TABLE `smf_log_spider_hits`
  ADD PRIMARY KEY (`id_hit`),
  ADD KEY `id_spider` (`id_spider`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `processed` (`processed`);

--
-- Indexen voor tabel `smf_log_spider_stats`
--
ALTER TABLE `smf_log_spider_stats`
  ADD PRIMARY KEY (`stat_date`,`id_spider`);

--
-- Indexen voor tabel `smf_log_subscribed`
--
ALTER TABLE `smf_log_subscribed`
  ADD PRIMARY KEY (`id_sublog`),
  ADD UNIQUE KEY `id_subscribe` (`id_subscribe`,`id_member`),
  ADD KEY `end_time` (`end_time`),
  ADD KEY `reminder_sent` (`reminder_sent`),
  ADD KEY `payments_pending` (`payments_pending`),
  ADD KEY `status` (`status`),
  ADD KEY `id_member` (`id_member`);

--
-- Indexen voor tabel `smf_log_topics`
--
ALTER TABLE `smf_log_topics`
  ADD PRIMARY KEY (`id_member`,`id_topic`),
  ADD KEY `id_topic` (`id_topic`);

--
-- Indexen voor tabel `smf_mail_queue`
--
ALTER TABLE `smf_mail_queue`
  ADD PRIMARY KEY (`id_mail`),
  ADD KEY `time_sent` (`time_sent`),
  ADD KEY `mail_priority` (`priority`,`id_mail`);

--
-- Indexen voor tabel `smf_membergroups`
--
ALTER TABLE `smf_membergroups`
  ADD PRIMARY KEY (`id_group`),
  ADD KEY `min_posts` (`min_posts`);

--
-- Indexen voor tabel `smf_members`
--
ALTER TABLE `smf_members`
  ADD PRIMARY KEY (`id_member`),
  ADD KEY `member_name` (`member_name`),
  ADD KEY `real_name` (`real_name`),
  ADD KEY `date_registered` (`date_registered`),
  ADD KEY `id_group` (`id_group`),
  ADD KEY `birthdate` (`birthdate`),
  ADD KEY `posts` (`posts`),
  ADD KEY `last_login` (`last_login`),
  ADD KEY `lngfile` (`lngfile`(30)),
  ADD KEY `id_post_group` (`id_post_group`),
  ADD KEY `warning` (`warning`),
  ADD KEY `total_time_logged_in` (`total_time_logged_in`),
  ADD KEY `id_theme` (`id_theme`);

--
-- Indexen voor tabel `smf_messages`
--
ALTER TABLE `smf_messages`
  ADD PRIMARY KEY (`id_msg`),
  ADD UNIQUE KEY `topic` (`id_topic`,`id_msg`),
  ADD UNIQUE KEY `id_board` (`id_board`,`id_msg`),
  ADD UNIQUE KEY `id_member` (`id_member`,`id_msg`),
  ADD KEY `approved` (`approved`),
  ADD KEY `ip_index` (`poster_ip`(15),`id_topic`),
  ADD KEY `participation` (`id_member`,`id_topic`),
  ADD KEY `show_posts` (`id_member`,`id_board`),
  ADD KEY `id_topic` (`id_topic`),
  ADD KEY `id_member_msg` (`id_member`,`approved`,`id_msg`),
  ADD KEY `current_topic` (`id_topic`,`id_msg`,`id_member`,`approved`),
  ADD KEY `related_ip` (`id_member`,`poster_ip`,`id_msg`);

--
-- Indexen voor tabel `smf_message_icons`
--
ALTER TABLE `smf_message_icons`
  ADD PRIMARY KEY (`id_icon`),
  ADD KEY `id_board` (`id_board`);

--
-- Indexen voor tabel `smf_moderators`
--
ALTER TABLE `smf_moderators`
  ADD PRIMARY KEY (`id_board`,`id_member`);

--
-- Indexen voor tabel `smf_openid_assoc`
--
ALTER TABLE `smf_openid_assoc`
  ADD PRIMARY KEY (`server_url`(125),`handle`(125)),
  ADD KEY `expires` (`expires`);

--
-- Indexen voor tabel `smf_package_servers`
--
ALTER TABLE `smf_package_servers`
  ADD PRIMARY KEY (`id_server`);

--
-- Indexen voor tabel `smf_permissions`
--
ALTER TABLE `smf_permissions`
  ADD PRIMARY KEY (`id_group`,`permission`);

--
-- Indexen voor tabel `smf_permission_profiles`
--
ALTER TABLE `smf_permission_profiles`
  ADD PRIMARY KEY (`id_profile`);

--
-- Indexen voor tabel `smf_personal_messages`
--
ALTER TABLE `smf_personal_messages`
  ADD PRIMARY KEY (`id_pm`),
  ADD KEY `id_member` (`id_member_from`,`deleted_by_sender`),
  ADD KEY `msgtime` (`msgtime`),
  ADD KEY `id_pm_head` (`id_pm_head`);

--
-- Indexen voor tabel `smf_pm_recipients`
--
ALTER TABLE `smf_pm_recipients`
  ADD PRIMARY KEY (`id_pm`,`id_member`),
  ADD UNIQUE KEY `id_member` (`id_member`,`deleted`,`id_pm`);

--
-- Indexen voor tabel `smf_pm_rules`
--
ALTER TABLE `smf_pm_rules`
  ADD PRIMARY KEY (`id_rule`),
  ADD KEY `id_member` (`id_member`),
  ADD KEY `delete_pm` (`delete_pm`);

--
-- Indexen voor tabel `smf_polls`
--
ALTER TABLE `smf_polls`
  ADD PRIMARY KEY (`id_poll`);

--
-- Indexen voor tabel `smf_poll_choices`
--
ALTER TABLE `smf_poll_choices`
  ADD PRIMARY KEY (`id_poll`,`id_choice`);

--
-- Indexen voor tabel `smf_scheduled_tasks`
--
ALTER TABLE `smf_scheduled_tasks`
  ADD PRIMARY KEY (`id_task`),
  ADD UNIQUE KEY `task` (`task`),
  ADD KEY `next_time` (`next_time`),
  ADD KEY `disabled` (`disabled`);

--
-- Indexen voor tabel `smf_sessions`
--
ALTER TABLE `smf_sessions`
  ADD PRIMARY KEY (`session_id`);

--
-- Indexen voor tabel `smf_settings`
--
ALTER TABLE `smf_settings`
  ADD PRIMARY KEY (`variable`(30));

--
-- Indexen voor tabel `smf_smileys`
--
ALTER TABLE `smf_smileys`
  ADD PRIMARY KEY (`id_smiley`);

--
-- Indexen voor tabel `smf_spiders`
--
ALTER TABLE `smf_spiders`
  ADD PRIMARY KEY (`id_spider`);

--
-- Indexen voor tabel `smf_sp_articles`
--
ALTER TABLE `smf_sp_articles`
  ADD PRIMARY KEY (`id_article`);

--
-- Indexen voor tabel `smf_sp_blocks`
--
ALTER TABLE `smf_sp_blocks`
  ADD PRIMARY KEY (`id_block`),
  ADD KEY `state` (`state`);

--
-- Indexen voor tabel `smf_sp_categories`
--
ALTER TABLE `smf_sp_categories`
  ADD PRIMARY KEY (`id_category`);

--
-- Indexen voor tabel `smf_sp_functions`
--
ALTER TABLE `smf_sp_functions`
  ADD PRIMARY KEY (`id_function`);

--
-- Indexen voor tabel `smf_sp_pages`
--
ALTER TABLE `smf_sp_pages`
  ADD PRIMARY KEY (`id_page`);

--
-- Indexen voor tabel `smf_sp_parameters`
--
ALTER TABLE `smf_sp_parameters`
  ADD PRIMARY KEY (`id_block`,`variable`),
  ADD KEY `variable` (`variable`);

--
-- Indexen voor tabel `smf_sp_shoutboxes`
--
ALTER TABLE `smf_sp_shoutboxes`
  ADD PRIMARY KEY (`id_shoutbox`);

--
-- Indexen voor tabel `smf_sp_shouts`
--
ALTER TABLE `smf_sp_shouts`
  ADD PRIMARY KEY (`id_shout`);

--
-- Indexen voor tabel `smf_subscriptions`
--
ALTER TABLE `smf_subscriptions`
  ADD PRIMARY KEY (`id_subscribe`),
  ADD KEY `active` (`active`);

--
-- Indexen voor tabel `smf_themes`
--
ALTER TABLE `smf_themes`
  ADD PRIMARY KEY (`id_theme`,`id_member`,`variable`(30)),
  ADD KEY `id_member` (`id_member`);

--
-- Indexen voor tabel `smf_topics`
--
ALTER TABLE `smf_topics`
  ADD PRIMARY KEY (`id_topic`),
  ADD UNIQUE KEY `last_message` (`id_last_msg`,`id_board`),
  ADD UNIQUE KEY `first_message` (`id_first_msg`,`id_board`),
  ADD UNIQUE KEY `poll` (`id_poll`,`id_topic`),
  ADD KEY `is_sticky` (`is_sticky`),
  ADD KEY `approved` (`approved`),
  ADD KEY `id_board` (`id_board`),
  ADD KEY `member_started` (`id_member_started`,`id_board`),
  ADD KEY `last_message_sticky` (`id_board`,`is_sticky`,`id_last_msg`),
  ADD KEY `board_news` (`id_board`,`id_first_msg`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `smf_admin_info_files`
--
ALTER TABLE `smf_admin_info_files`
  MODIFY `id_file` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT voor een tabel `smf_attachments`
--
ALTER TABLE `smf_attachments`
  MODIFY `id_attach` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_ban_groups`
--
ALTER TABLE `smf_ban_groups`
  MODIFY `id_ban_group` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_ban_items`
--
ALTER TABLE `smf_ban_items`
  MODIFY `id_ban` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_boards`
--
ALTER TABLE `smf_boards`
  MODIFY `id_board` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT voor een tabel `smf_calendar`
--
ALTER TABLE `smf_calendar`
  MODIFY `id_event` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_calendar_holidays`
--
ALTER TABLE `smf_calendar_holidays`
  MODIFY `id_holiday` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;
--
-- AUTO_INCREMENT voor een tabel `smf_categories`
--
ALTER TABLE `smf_categories`
  MODIFY `id_cat` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_custom_fields`
--
ALTER TABLE `smf_custom_fields`
  MODIFY `id_field` smallint(5) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_actions`
--
ALTER TABLE `smf_log_actions`
  MODIFY `id_action` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_banned`
--
ALTER TABLE `smf_log_banned`
  MODIFY `id_ban_log` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_comments`
--
ALTER TABLE `smf_log_comments`
  MODIFY `id_comment` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_errors`
--
ALTER TABLE `smf_log_errors`
  MODIFY `id_error` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130;
--
-- AUTO_INCREMENT voor een tabel `smf_log_group_requests`
--
ALTER TABLE `smf_log_group_requests`
  MODIFY `id_request` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_member_notices`
--
ALTER TABLE `smf_log_member_notices`
  MODIFY `id_notice` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_packages`
--
ALTER TABLE `smf_log_packages`
  MODIFY `id_install` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT voor een tabel `smf_log_reported`
--
ALTER TABLE `smf_log_reported`
  MODIFY `id_report` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_reported_comments`
--
ALTER TABLE `smf_log_reported_comments`
  MODIFY `id_comment` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_scheduled_tasks`
--
ALTER TABLE `smf_log_scheduled_tasks`
  MODIFY `id_log` mediumint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT voor een tabel `smf_log_spider_hits`
--
ALTER TABLE `smf_log_spider_hits`
  MODIFY `id_hit` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_subscribed`
--
ALTER TABLE `smf_log_subscribed`
  MODIFY `id_sublog` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_mail_queue`
--
ALTER TABLE `smf_mail_queue`
  MODIFY `id_mail` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_membergroups`
--
ALTER TABLE `smf_membergroups`
  MODIFY `id_group` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT voor een tabel `smf_members`
--
ALTER TABLE `smf_members`
  MODIFY `id_member` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_messages`
--
ALTER TABLE `smf_messages`
  MODIFY `id_msg` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_message_icons`
--
ALTER TABLE `smf_message_icons`
  MODIFY `id_icon` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT voor een tabel `smf_package_servers`
--
ALTER TABLE `smf_package_servers`
  MODIFY `id_server` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_permission_profiles`
--
ALTER TABLE `smf_permission_profiles`
  MODIFY `id_profile` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `smf_personal_messages`
--
ALTER TABLE `smf_personal_messages`
  MODIFY `id_pm` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_pm_rules`
--
ALTER TABLE `smf_pm_rules`
  MODIFY `id_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_polls`
--
ALTER TABLE `smf_polls`
  MODIFY `id_poll` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_scheduled_tasks`
--
ALTER TABLE `smf_scheduled_tasks`
  MODIFY `id_task` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT voor een tabel `smf_smileys`
--
ALTER TABLE `smf_smileys`
  MODIFY `id_smiley` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT voor een tabel `smf_spiders`
--
ALTER TABLE `smf_spiders`
  MODIFY `id_spider` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_articles`
--
ALTER TABLE `smf_sp_articles`
  MODIFY `id_article` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_blocks`
--
ALTER TABLE `smf_sp_blocks`
  MODIFY `id_block` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_categories`
--
ALTER TABLE `smf_sp_categories`
  MODIFY `id_category` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_functions`
--
ALTER TABLE `smf_sp_functions`
  MODIFY `id_function` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_pages`
--
ALTER TABLE `smf_sp_pages`
  MODIFY `id_page` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_shoutboxes`
--
ALTER TABLE `smf_sp_shoutboxes`
  MODIFY `id_shoutbox` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_shouts`
--
ALTER TABLE `smf_sp_shouts`
  MODIFY `id_shout` mediumint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_subscriptions`
--
ALTER TABLE `smf_subscriptions`
  MODIFY `id_subscribe` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_topics`
--
ALTER TABLE `smf_topics`
  MODIFY `id_topic` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
