AuthPDO: allow in-SQL pasword checking

This is a feature that was present in the old authmysql plugin. It
allows administrators to specify an SQL string that is used for explicit
password checking instead of letting DokuWiki compare the hashes. This
is useful where application implement their own salt/hashing thing.

This comes with a test case for the MyBB forum software. Dump kindly
provided by William Kitchen

2 files changed, 450 insertions, 0 deletions

diff --git a/lib/plugins/authpdo/_test/mysql/mybb.php b/lib/plugins/authpdo/_test/mysql/mybb.php
new file mode 100644
index 000000000..3a427b445
--- /dev/null
+++ b/lib/plugins/authpdo/_test/mysql/mybb.php
@@ -0,0 +1,144 @@
+<?php
+/**
+ * Configuration for mybb. Password checking is done in SQL
+ *
+ * mybb stores additional group ids in a commaseparated list of mybb_users.addtionalgroups This
+ * is currently not supported in the setup below. If someone can come up with a clever config for
+ * that PRs would be welcome.
+ */
+/** @noinspection SqlResolve */
+$data = array(
+    'passcrypt' => 'sha1',
+    'conf' => array(
+        'select-user' => '
+            SELECT uid,
+                   username AS user,
+                   username AS name,
+                   email AS mail
+              FROM mybb_users
+             WHERE username = :user
+        ',
+        'check-pass' => '
+            SELECT uid
+              FROM mybb_users
+             WHERE username = :user
+               AND password = MD5(CONCAT(MD5(salt), MD5(:clear)))
+        ',
+        'select-user-groups' => '
+            SELECT UG.title AS `group`,
+                   UG.gid
+              FROM mybb_usergroups UG,
+                   mybb_users U
+             WHERE U.usergroup = UG.gid
+               AND U.uid = :uid
+        ',
+        'select-groups' => '
+            SELECT gid, title AS `group`
+              FROM mybb_usergroups
+        ',
+        'insert-user' => '
+            SET @salt = LEFT(UUID(), 10);
+            INSERT INTO mybb_users
+                   (username, email, salt, password, regdate)
+            VALUES (:user, :mail, @salt, MD5(CONCAT(MD5(@salt), MD5(:clear))), UNIX_TIMESTAMP() )                  
+        ',
+        'delete-user' => '
+            DELETE FROM mybb_users
+             WHERE uid = :uid 
+        ',
+        'list-users' => '
+            SELECT U.username AS user
+             FROM mybb_usergroups UG,
+                   mybb_users U
+             WHERE U.usergroup = UG.gid
+               AND UG.title LIKE :group
+               AND U.username LIKE :user
+               AND U.username LIKE :name
+               AND U.email LIKE :mail
+          ORDER BY U.username
+             LIMIT :limit
+            OFFSET :start
+        ',
+        'count-users' => '
+            SELECT COUNT(U.username) AS `count`
+                 FROM mybb_usergroups UG,
+                       mybb_users U
+                 WHERE U.usergroup = UG.gid
+                   AND UG.title LIKE :group
+                   AND U.username LIKE :user
+                   AND U.username LIKE :name
+                   AND U.email LIKE :mail
+        ',
+        'update-user-info' => '
+            UPDATE mybb_users
+               SET email = :mail
+             WHERE uid = :uid            
+        ', // we do not support changing the full name as that is the same as the login
+        'update-user-login' => '
+            UPDATE mybb_users
+               SET username = :newlogin
+             WHERE uid = :uid
+        ',
+        'update-user-pass' => '
+            SET @salt = LEFT(UUID(), 10);
+            UPDATE mybb_users
+               SET salt = @salt,
+                   password = MD5(CONCAT(MD5(@salt), MD5(:clear)))
+             WHERE uid = :uid
+        ',
+        'insert-group' => '
+            INSERT INTO mybb_usergroups (title)
+             VALUES (:group)
+        ',
+        'join-group' => '
+            UPDATE mybb_users
+               SET usergroup = :gid
+             WHERE uid = :uid
+        ',
+        'leave-group' => '', // makes probably no sense to implement
+    ),
+    'users' => array(
+        array(
+            'user' => 'Test One',
+            'pass' => 'fakepass',
+            'name' => 'Test One',
+            'mail' => 'no_one@nowhere.com',
+            'grps' =>
+                array(
+                    0 => 'Registered',
+                ),
+        ),
+        array(
+            'user' => 'Test Two',
+            'pass' => 'fakepass',
+            'name' => 'Test Two',
+            'mail' => 'no_one@nowhere.com',
+            'grps' =>
+                array(
+                    0 => 'Super Moderators',
+                ),
+        ),
+        array(
+            'user' => 'Test Three',
+            'pass' => 'fakepass',
+            'name' => 'Test Three',
+            'mail' => 'no_one@nowhere.com',
+            'grps' =>
+                array(
+                    0 => 'Administrators',
+                ),
+        ),
+        array(
+            'user' => 'Test Four',
+            'pass' => 'fakepass',
+            'name' => 'Test Four',
+            'mail' => 'no_one@nowhere.com',
+            'grps' =>
+                array(
+                    0 => 'Moderators',
+                ),
+        ),
+
+
+    ),
+);
diff --git a/lib/plugins/authpdo/_test/mysql/mybb.sql b/lib/plugins/authpdo/_test/mysql/mybb.sql
new file mode 100644
index 000000000..fdd1a9974
--- /dev/null
+++ b/lib/plugins/authpdo/_test/mysql/mybb.sql
@@ -0,0 +1,306 @@
+-- phpMyAdmin SQL Dump
+-- version 4.4.14
+-- http://www.phpmyadmin.net
+--
+-- Host: 127.0.0.1
+-- Generation Time: Aug 19, 2016 at 04:02 PM
+-- Server version: 5.5.45
+-- PHP Version: 5.4.45
+
+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: `mybb`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `mybb_usergroups`
+--
+
+CREATE TABLE `mybb_usergroups` (
+  `gid` smallint(5) unsigned NOT NULL,
+  `type` tinyint(1) unsigned NOT NULL DEFAULT '2',
+  `title` varchar(120) NOT NULL DEFAULT '',
+  `description` text NOT NULL,
+  `namestyle` varchar(200) NOT NULL DEFAULT '{username}',
+  `usertitle` varchar(120) NOT NULL DEFAULT '',
+  `stars` smallint(4) unsigned NOT NULL DEFAULT '0',
+  `starimage` varchar(120) NOT NULL DEFAULT '',
+  `image` varchar(120) NOT NULL DEFAULT '',
+  `disporder` smallint(6) unsigned NOT NULL,
+  `isbannedgroup` tinyint(1) NOT NULL DEFAULT '0',
+  `canview` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewthreads` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewprofiles` tinyint(1) NOT NULL DEFAULT '0',
+  `candlattachments` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewboardclosed` tinyint(1) NOT NULL DEFAULT '0',
+  `canpostthreads` tinyint(1) NOT NULL DEFAULT '0',
+  `canpostreplys` tinyint(1) NOT NULL DEFAULT '0',
+  `canpostattachments` tinyint(1) NOT NULL DEFAULT '0',
+  `canratethreads` tinyint(1) NOT NULL DEFAULT '0',
+  `modposts` tinyint(1) NOT NULL DEFAULT '0',
+  `modthreads` tinyint(1) NOT NULL DEFAULT '0',
+  `mod_edit_posts` tinyint(1) NOT NULL DEFAULT '0',
+  `modattachments` tinyint(1) NOT NULL DEFAULT '0',
+  `caneditposts` tinyint(1) NOT NULL DEFAULT '0',
+  `candeleteposts` tinyint(1) NOT NULL DEFAULT '0',
+  `candeletethreads` tinyint(1) NOT NULL DEFAULT '0',
+  `caneditattachments` tinyint(1) NOT NULL DEFAULT '0',
+  `canpostpolls` tinyint(1) NOT NULL DEFAULT '0',
+  `canvotepolls` tinyint(1) NOT NULL DEFAULT '0',
+  `canundovotes` tinyint(1) NOT NULL DEFAULT '0',
+  `canusepms` tinyint(1) NOT NULL DEFAULT '0',
+  `cansendpms` tinyint(1) NOT NULL DEFAULT '0',
+  `cantrackpms` tinyint(1) NOT NULL DEFAULT '0',
+  `candenypmreceipts` tinyint(1) NOT NULL DEFAULT '0',
+  `pmquota` int(3) unsigned NOT NULL DEFAULT '0',
+  `maxpmrecipients` int(4) unsigned NOT NULL DEFAULT '5',
+  `cansendemail` tinyint(1) NOT NULL DEFAULT '0',
+  `cansendemailoverride` tinyint(1) NOT NULL DEFAULT '0',
+  `maxemails` int(3) unsigned NOT NULL DEFAULT '5',
+  `emailfloodtime` int(3) unsigned NOT NULL DEFAULT '5',
+  `canviewmemberlist` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewcalendar` tinyint(1) NOT NULL DEFAULT '0',
+  `canaddevents` tinyint(1) NOT NULL DEFAULT '0',
+  `canbypasseventmod` tinyint(1) NOT NULL DEFAULT '0',
+  `canmoderateevents` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewonline` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewwolinvis` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewonlineips` tinyint(1) NOT NULL DEFAULT '0',
+  `cancp` tinyint(1) NOT NULL DEFAULT '0',
+  `issupermod` tinyint(1) NOT NULL DEFAULT '0',
+  `cansearch` tinyint(1) NOT NULL DEFAULT '0',
+  `canusercp` tinyint(1) NOT NULL DEFAULT '0',
+  `canuploadavatars` tinyint(1) NOT NULL DEFAULT '0',
+  `canratemembers` tinyint(1) NOT NULL DEFAULT '0',
+  `canchangename` tinyint(1) NOT NULL DEFAULT '0',
+  `canbereported` tinyint(1) NOT NULL DEFAULT '0',
+  `canchangewebsite` tinyint(1) NOT NULL DEFAULT '1',
+  `showforumteam` tinyint(1) NOT NULL DEFAULT '0',
+  `usereputationsystem` tinyint(1) NOT NULL DEFAULT '0',
+  `cangivereputations` tinyint(1) NOT NULL DEFAULT '0',
+  `candeletereputations` tinyint(1) NOT NULL DEFAULT '0',
+  `reputationpower` int(10) unsigned NOT NULL DEFAULT '0',
+  `maxreputationsday` int(10) unsigned NOT NULL DEFAULT '0',
+  `maxreputationsperuser` int(10) unsigned NOT NULL DEFAULT '0',
+  `maxreputationsperthread` int(10) unsigned NOT NULL DEFAULT '0',
+  `candisplaygroup` tinyint(1) NOT NULL DEFAULT '0',
+  `attachquota` int(10) unsigned NOT NULL DEFAULT '0',
+  `cancustomtitle` tinyint(1) NOT NULL DEFAULT '0',
+  `canwarnusers` tinyint(1) NOT NULL DEFAULT '0',
+  `canreceivewarnings` tinyint(1) NOT NULL DEFAULT '0',
+  `maxwarningsday` int(3) unsigned NOT NULL DEFAULT '3',
+  `canmodcp` tinyint(1) NOT NULL DEFAULT '0',
+  `showinbirthdaylist` tinyint(1) NOT NULL DEFAULT '0',
+  `canoverridepm` tinyint(1) NOT NULL DEFAULT '0',
+  `canusesig` tinyint(1) NOT NULL DEFAULT '0',
+  `canusesigxposts` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `signofollow` tinyint(1) NOT NULL DEFAULT '0',
+  `edittimelimit` int(4) unsigned NOT NULL DEFAULT '0',
+  `maxposts` int(4) unsigned NOT NULL DEFAULT '0',
+  `showmemberlist` tinyint(1) NOT NULL DEFAULT '1',
+  `canmanageannounce` tinyint(1) NOT NULL DEFAULT '0',
+  `canmanagemodqueue` tinyint(1) NOT NULL DEFAULT '0',
+  `canmanagereportedcontent` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewmodlogs` tinyint(1) NOT NULL DEFAULT '0',
+  `caneditprofiles` tinyint(1) NOT NULL DEFAULT '0',
+  `canbanusers` tinyint(1) NOT NULL DEFAULT '0',
+  `canviewwarnlogs` tinyint(1) NOT NULL DEFAULT '0',
+  `canuseipsearch` tinyint(1) NOT NULL DEFAULT '0'
+) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `mybb_usergroups`
+--
+
+INSERT INTO `mybb_usergroups` (`gid`, `type`, `title`, `description`, `namestyle`, `usertitle`, `stars`, `starimage`, `image`, `disporder`, `isbannedgroup`, `canview`, `canviewthreads`, `canviewprofiles`, `candlattachments`, `canviewboardclosed`, `canpostthreads`, `canpostreplys`, `canpostattachments`, `canratethreads`, `modposts`, `modthreads`, `mod_edit_posts`, `modattachments`, `caneditposts`, `candeleteposts`, `candeletethreads`, `caneditattachments`, `canpostpolls`, `canvotepolls`, `canundovotes`, `canusepms`, `cansendpms`, `cantrackpms`, `candenypmreceipts`, `pmquota`, `maxpmrecipients`, `cansendemail`, `cansendemailoverride`, `maxemails`, `emailfloodtime`, `canviewmemberlist`, `canviewcalendar`, `canaddevents`, `canbypasseventmod`, `canmoderateevents`, `canviewonline`, `canviewwolinvis`, `canviewonlineips`, `cancp`, `issupermod`, `cansearch`, `canusercp`, `canuploadavatars`, `canratemembers`, `canchangename`, `canbereported`, `canchangewebsite`, `showforumteam`, `usereputationsystem`, `cangivereputations`, `candeletereputations`, `reputationpower`, `maxreputationsday`, `maxreputationsperuser`, `maxreputationsperthread`, `candisplaygroup`, `attachquota`, `cancustomtitle`, `canwarnusers`, `canreceivewarnings`, `maxwarningsday`, `canmodcp`, `showinbirthdaylist`, `canoverridepm`, `canusesig`, `canusesigxposts`, `signofollow`, `edittimelimit`, `maxposts`, `showmemberlist`, `canmanageannounce`, `canmanagemodqueue`, `canmanagereportedcontent`, `canviewmodlogs`, `caneditprofiles`, `canbanusers`, `canviewwarnlogs`, `canuseipsearch`) VALUES
+(1, 1, 'Guests', 'The default group that all visitors are assigned to unless they''re logged in.', '{username}', 'Unregistered', 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(2, 1, 'Registered', 'After registration, all users are placed in this group by default.', '{username}', '', 0, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 200, 5, 1, 0, 5, 5, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 5, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
+(3, 1, 'Super Moderators', 'These users can moderate any forum.', '<span style="color: #CC00CC;"><strong>{username}</strong></span>', 'Super Moderator', 6, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 250, 5, 1, 0, 10, 5, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 10, 0, 0, 1, 0, 1, 1, 1, 3, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
+(4, 1, 'Administrators', 'The group all administrators belong to.', '<span style="color: green;"><strong><em>{username}</em></strong></span>', 'Administrator', 7, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 2, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
+(5, 1, 'Awaiting Activation', 'Users that have not activated their account by email or manually been activated yet.', '{username}', 'Account not Activated', 0, 'images/star.png', '', 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 5, 0, 0, 5, 5, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
+(6, 1, 'Moderators', 'These users moderate specific forums.', '<span style="color: #CC00CC;"><strong>{username}</strong></span>', 'Moderator', 5, 'images/star.png', '', 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 250, 5, 1, 0, 5, 5, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 10, 0, 0, 1, 0, 1, 1, 1, 3, 1, 1, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
+(7, 1, 'Banned', 'The default user group to which members that are banned are moved to.', '<s>{username}</s>', 'Banned', 0, 'images/star.png', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
+
+--
+-- Indexes for dumped tables
+--
+
+--
+-- Indexes for table `mybb_usergroups`
+--
+ALTER TABLE `mybb_usergroups`
+  ADD PRIMARY KEY (`gid`);
+
+--
+-- AUTO_INCREMENT for dumped tables
+--
+
+--
+-- AUTO_INCREMENT for table `mybb_usergroups`
+--
+ALTER TABLE `mybb_usergroups`
+  MODIFY `gid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
+/*!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 */;
+-- phpMyAdmin SQL Dump
+-- version 4.4.14
+-- http://www.phpmyadmin.net
+--
+-- Host: 127.0.0.1
+-- Generation Time: Aug 19, 2016 at 03:47 PM
+-- Server version: 5.5.45
+-- PHP Version: 5.4.45
+
+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: `mybb`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `mybb_users`
+--
+
+CREATE TABLE `mybb_users` (
+  `uid` int(10) unsigned NOT NULL,
+  `username` varchar(120) NOT NULL DEFAULT '',
+  `password` varchar(120) NOT NULL DEFAULT '',
+  `salt` varchar(10) NOT NULL DEFAULT '',
+  `loginkey` varchar(50) NOT NULL DEFAULT '',
+  `email` varchar(220) NOT NULL DEFAULT '',
+  `postnum` int(10) unsigned NOT NULL DEFAULT '0',
+  `threadnum` int(10) unsigned NOT NULL DEFAULT '0',
+  `avatar` varchar(200) NOT NULL DEFAULT '',
+  `avatardimensions` varchar(10) NOT NULL DEFAULT '',
+  `avatartype` varchar(10) NOT NULL DEFAULT '0',
+  `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `additionalgroups` varchar(200) NOT NULL DEFAULT '',
+  `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `usertitle` varchar(250) NOT NULL DEFAULT '',
+  `regdate` int(10) unsigned NOT NULL DEFAULT '0',
+  `lastactive` int(10) unsigned NOT NULL DEFAULT '0',
+  `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
+  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
+  `website` varchar(200) NOT NULL DEFAULT '',
+  `icq` varchar(10) NOT NULL DEFAULT '',
+  `aim` varchar(50) NOT NULL DEFAULT '',
+  `yahoo` varchar(50) NOT NULL DEFAULT '',
+  `skype` varchar(75) NOT NULL DEFAULT '',
+  `google` varchar(75) NOT NULL DEFAULT '',
+  `birthday` varchar(15) NOT NULL DEFAULT '',
+  `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
+  `signature` text NOT NULL,
+  `allownotices` tinyint(1) NOT NULL DEFAULT '0',
+  `hideemail` tinyint(1) NOT NULL DEFAULT '0',
+  `subscriptionmethod` tinyint(1) NOT NULL DEFAULT '0',
+  `invisible` tinyint(1) NOT NULL DEFAULT '0',
+  `receivepms` tinyint(1) NOT NULL DEFAULT '0',
+  `receivefrombuddy` tinyint(1) NOT NULL DEFAULT '0',
+  `pmnotice` tinyint(1) NOT NULL DEFAULT '0',
+  `pmnotify` tinyint(1) NOT NULL DEFAULT '0',
+  `buddyrequestspm` tinyint(1) NOT NULL DEFAULT '1',
+  `buddyrequestsauto` tinyint(1) NOT NULL DEFAULT '0',
+  `threadmode` varchar(8) NOT NULL DEFAULT '',
+  `showimages` tinyint(1) NOT NULL DEFAULT '0',
+  `showvideos` tinyint(1) NOT NULL DEFAULT '0',
+  `showsigs` tinyint(1) NOT NULL DEFAULT '0',
+  `showavatars` tinyint(1) NOT NULL DEFAULT '0',
+  `showquickreply` tinyint(1) NOT NULL DEFAULT '0',
+  `showredirect` tinyint(1) NOT NULL DEFAULT '0',
+  `ppp` smallint(6) unsigned NOT NULL DEFAULT '0',
+  `tpp` smallint(6) unsigned NOT NULL DEFAULT '0',
+  `daysprune` smallint(6) unsigned NOT NULL DEFAULT '0',
+  `dateformat` varchar(4) NOT NULL DEFAULT '',
+  `timeformat` varchar(4) NOT NULL DEFAULT '',
+  `timezone` varchar(5) NOT NULL DEFAULT '',
+  `dst` tinyint(1) NOT NULL DEFAULT '0',
+  `dstcorrection` tinyint(1) NOT NULL DEFAULT '0',
+  `buddylist` text NOT NULL,
+  `ignorelist` text NOT NULL,
+  `style` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `away` tinyint(1) NOT NULL DEFAULT '0',
+  `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
+  `returndate` varchar(15) NOT NULL DEFAULT '',
+  `awayreason` varchar(200) NOT NULL DEFAULT '',
+  `pmfolders` text NOT NULL,
+  `notepad` text NOT NULL,
+  `referrer` int(10) unsigned NOT NULL DEFAULT '0',
+  `referrals` int(10) unsigned NOT NULL DEFAULT '0',
+  `reputation` int(11) NOT NULL DEFAULT '0',
+  `regip` varbinary(16) NOT NULL DEFAULT '',
+  `lastip` varbinary(16) NOT NULL DEFAULT '',
+  `language` varchar(50) NOT NULL DEFAULT '',
+  `timeonline` int(10) unsigned NOT NULL DEFAULT '0',
+  `showcodebuttons` tinyint(1) NOT NULL DEFAULT '1',
+  `totalpms` int(10) unsigned NOT NULL DEFAULT '0',
+  `unreadpms` int(10) unsigned NOT NULL DEFAULT '0',
+  `warningpoints` int(3) unsigned NOT NULL DEFAULT '0',
+  `moderateposts` tinyint(1) NOT NULL DEFAULT '0',
+  `moderationtime` int(10) unsigned NOT NULL DEFAULT '0',
+  `suspendposting` tinyint(1) NOT NULL DEFAULT '0',
+  `suspensiontime` int(10) unsigned NOT NULL DEFAULT '0',
+  `suspendsignature` tinyint(1) NOT NULL DEFAULT '0',
+  `suspendsigtime` int(10) unsigned NOT NULL DEFAULT '0',
+  `coppauser` tinyint(1) NOT NULL DEFAULT '0',
+  `classicpostbit` tinyint(1) NOT NULL DEFAULT '0',
+  `loginattempts` smallint(2) unsigned NOT NULL DEFAULT '1',
+  `usernotes` text NOT NULL,
+  `sourceeditor` tinyint(1) NOT NULL DEFAULT '0'
+) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `mybb_users`
+--
+
+INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `threadnum`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `skype`, `google`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `receivefrombuddy`, `pmnotice`, `pmnotify`, `buddyrequestspm`, `buddyrequestsauto`, `threadmode`, `showimages`, `showvideos`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `referrals`, `reputation`, `regip`, `lastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `suspendsignature`, `suspendsigtime`, `coppauser`, `classicpostbit`, `loginattempts`, `usernotes`, `sourceeditor`) VALUES
+(84, 'Test One', '6e90cf918ebce3a577fd72cea919dc64', '0pBnrIIv', 'xALZxWcfw18AhO6M7YxptBrxZqyrJB04CWlyaIniO3ZyMn6P1f', 'no_one@nowhere.com', 0, 0, '', '', '', 2, '', 0, '', 1471614765, 1471614765, 1471614765, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0),
+(85, 'Test Two', 'e85f6b7e5804b42d7c7d99329dc1a43f', 'NSX3xNT1', 'VucYxl7EGnsoqVW75COGNAdB0YgtWHc9RFqo4LxIhhtpEFxdIE', 'no_one@nowhere.com', 0, 0, '', '', '', 3, '', 0, '', 1471614850, 1471614850, 1471614850, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0),
+(86, 'Test Three', '3669c9583702ca6e32c7817f4bc34f5f', 'CVEbGFXH', 'GivwOlOKuvpfTs8Dc263fNnPdSQW1k1C1fHt7gukTJdRvTZGca', 'no_one@nowhere.com', 0, 0, '', '', '', 4, '', 0, '', 1471615021, 1471615021, 1471615021, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0),
+(87, 'Test Four', '693a0cd028c9adb4cb28d8a8be3dc7af', 'x6q7QFmU', 'S4oU92jET3yjvbiganAKCYde9ksoacJeb4sC247qvYftgwsYmu', 'no_one@nowhere.com', 0, 0, '', '', '', 6, '', 0, '', 1471615064, 1471615064, 1471615064, 0, '', '0', '', '', '', '', '', 'all', '', 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 'linear', 1, 1, 1, 1, 1, 1, 0, 0, 0, '0', '0', '0', 0, 2, '', '', 0, 0, 0, '0', '', '', '', 0, 0, 0, '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0);
+
+--
+-- Indexes for dumped tables
+--
+
+--
+-- Indexes for table `mybb_users`
+--
+ALTER TABLE `mybb_users`
+  ADD PRIMARY KEY (`uid`),
+  ADD UNIQUE KEY `username` (`username`),
+  ADD KEY `usergroup` (`usergroup`),
+  ADD KEY `regip` (`regip`),
+  ADD KEY `lastip` (`lastip`);
+
+--
+-- AUTO_INCREMENT for dumped tables
+--
+
+--
+-- AUTO_INCREMENT for table `mybb_users`
+--
+ALTER TABLE `mybb_users`
+  MODIFY `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=88;
+/*!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 */;