Форум Donate Engine

HOST

Пользователь

burning board (woltlab) support

is there support for woltlab burning board?
i want users use the same login from the burning board into cms shop

ps i lost my other site so i cannot remember the problems i had before my server broke
and i was on holiday but im back!

Online

Administrator

Re: burning board (woltlab) support

Give a link to download. Will try to add.

HOST

Пользователь

Re: burning board (woltlab) support

thanks

Online

Administrator

Re: burning board (woltlab) support

Give a link to download.

HOST

Пользователь

Re: burning board (woltlab) support

there is a link to the woltlab where a demo can be downloaded for installation
or do you mean something else?

Online

Administrator

Re: burning board (woltlab) support

Give me a MySQL dump for the table of user data.

HOST

Пользователь

Re: burning board (woltlab) support

here bro sorry for the delay

its in a rar

Online

Administrator

Re: burning board (woltlab) support

Please give me dump with user data.
Or give a link to the manual for the integration of users.

HOST

Пользователь

Re: burning board (woltlab) support

this is what i got

CREATE TABLE IF NOT EXISTS `wcf1_user` (
  `userID` int(10) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `accessToken` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `languageID` int(10) NOT NULL DEFAULT '0',
  `registrationDate` int(10) NOT NULL DEFAULT '0',
  `styleID` int(10) NOT NULL DEFAULT '0',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `banReason` mediumtext COLLATE utf8_unicode_ci,
  `banExpires` int(10) NOT NULL DEFAULT '0',
  `activationCode` int(10) NOT NULL DEFAULT '0',
  `lastLostPasswordRequestTime` int(10) NOT NULL DEFAULT '0',
  `lostPasswordKey` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lastUsernameChange` int(10) NOT NULL DEFAULT '0',
  `newEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `oldUsername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `quitStarted` int(10) NOT NULL DEFAULT '0',
  `reactivationCode` int(10) NOT NULL DEFAULT '0',
  `registrationIpAddress` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `avatarID` int(10) DEFAULT NULL,
  `disableAvatar` tinyint(1) NOT NULL DEFAULT '0',
  `disableAvatarReason` text COLLATE utf8_unicode_ci,
  `disableAvatarExpires` int(10) NOT NULL DEFAULT '0',
  `enableGravatar` tinyint(1) NOT NULL DEFAULT '0',
  `gravatarFileExtension` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `signature` text COLLATE utf8_unicode_ci,
  `signatureEnableBBCodes` tinyint(1) NOT NULL DEFAULT '1',
  `signatureEnableHtml` tinyint(1) NOT NULL DEFAULT '0',
  `signatureEnableSmilies` tinyint(1) NOT NULL DEFAULT '1',
  `disableSignature` tinyint(1) NOT NULL DEFAULT '0',
  `disableSignatureReason` text COLLATE utf8_unicode_ci,
  `disableSignatureExpires` int(10) NOT NULL DEFAULT '0',
  `lastActivityTime` int(10) NOT NULL DEFAULT '0',
  `profileHits` int(10) NOT NULL DEFAULT '0',
  `rankID` int(10) DEFAULT NULL,
  `userTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `userOnlineGroupID` int(10) DEFAULT NULL,
  `activityPoints` int(10) NOT NULL DEFAULT '0',
  `notificationMailToken` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `authData` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `likesReceived` mediumint(7) NOT NULL DEFAULT '0',
  `socialNetworkPrivacySettings` text COLLATE utf8_unicode_ci,
  `wbbPosts` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `wcf1_user` (`userID`, `username`, `email`, `password`, `accessToken`, `languageID`, `registrationDate`, `styleID`, `banned`, `banReason`, `banExpires`, `activationCode`, `lastLostPasswordRequestTime`, `lostPasswordKey`, `lastUsernameChange`, `newEmail`, `oldUsername`, `quitStarted`, `reactivationCode`, `registrationIpAddress`, `avatarID`, `disableAvatar`, `disableAvatarReason`, `disableAvatarExpires`, `enableGravatar`, `gravatarFileExtension`, `signature`, `signatureEnableBBCodes`, `signatureEnableHtml`, `signatureEnableSmilies`, `disableSignature`, `disableSignatureReason`, `disableSignatureExpires`, `lastActivityTime`, `profileHits`, `rankID`, `userTitle`, `userOnlineGroupID`, `activityPoints`, `notificationMailToken`, `authData`, `likesReceived`, `socialNetworkPrivacySettings`, `wbbPosts`) VALUES
(4, 'TEST', 'test@test.nl', '$2a$08$8UEGvASrPOu4DP6iikqoBux5lN4Vtg2xCFBRNL8YAMPOIwezNpxri', 'fa3648a5ceac1cc3930ae73fb30df85ba6496511', 1, 1444206243, 0, 0, NULL, 0, 0, 0, '', 0, '', '', 0, 0, '::ffff:55d6:fd8d', NULL, 0, NULL, 0, 0, '', NULL, 1, 0, 1, 0, NULL, 0, 0, 0, 3, '', 3, 0, '', '', 0, '', 0);

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

--
-- Indexen voor tabel `wcf1_user`
--
ALTER TABLE `wcf1_user`
  ADD PRIMARY KEY (`userID`),
  ADD KEY `username` (`username`),
  ADD KEY `registrationDate` (`registrationDate`),
  ADD KEY `styleID` (`styleID`),
  ADD KEY `activationCode` (`activationCode`),
  ADD KEY `registrationData` (`registrationIpAddress`,`registrationDate`),
  ADD KEY `activityPoints` (`activityPoints`),
  ADD KEY `likesReceived` (`likesReceived`),
  ADD KEY `9b09180ae281646112d44b9aa2fc5048_fk` (`avatarID`),
  ADD KEY `b9271ea6487420ab6ca3153da2379a0f_fk` (`rankID`),
  ADD KEY `9fe2b1b2816319e14e168cdaa92175e7_fk` (`userOnlineGroupID`),
  ADD KEY `wbbPosts` (`wbbPosts`);

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

--
-- AUTO_INCREMENT voor een tabel `wcf1_user`
--
ALTER TABLE `wcf1_user`
  MODIFY `userID` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- Beperkingen voor geëxporteerde tabellen
--

--
-- Beperkingen voor tabel `wcf1_user`
--
ALTER TABLE `wcf1_user`
  ADD CONSTRAINT `9b09180ae281646112d44b9aa2fc5048_fk` FOREIGN KEY (`avatarID`) REFERENCES `wcf1_user_avatar` (`avatarID`) ON DELETE SET NULL,
  ADD CONSTRAINT `9fe2b1b2816319e14e168cdaa92175e7_fk` FOREIGN KEY (`userOnlineGroupID`) REFERENCES `wcf1_user_group` (`groupID`) ON DELETE SET NULL,
  ADD CONSTRAINT `b9271ea6487420ab6ca3153da2379a0f_fk` FOREIGN KEY (`rankID`) REFERENCES `wcf1_user_rank` (`rankID`) ON DELETE SET NULL;

/*!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 */;

Добавлено спустя 1 час 1 минуту 20 секунд:
and some extra info for burning board (woltlab)

Online

Administrator

Re: burning board (woltlab) support

Password hash:

SHA1(salt . SHA1(salt . SHA1(pass)))

Where is the salt?

Give me link for:

HOST

Пользователь

Re: burning board (woltlab) support

i have sended you the full woltlab database (private message so u can view what you need its the full extract
i cannot find the info myself (db noob)

Добавлено спустя 35 минут 38 секунд:
i asked the woltlab community for the salt i have no clue where to find it.

i found only this.

Passwords are hashed using a double-hashed Blowfish algorithm:

github.com/WoltLab/WCF/blob/ma…il/PasswordUtil.class.php

Online

Administrator

Re: burning board (woltlab) support

Give me password TEST user for hash '$2a$08$8UEGvASrPOu4DP6iikqoBux5lN4Vtg2xCFBRNL8YAMPOIwezNpxri'.

HOST

Пользователь

Re: burning board (woltlab) support

118118 is the pw for that user

Добавлено спустя 1 час 36 минут 15 секунд:
i still have not found it yet...

Online

Administrator

Re: burning board (woltlab) support

Not found the formula of the password hashing for Woltlab Burning Board.

HOST

Пользователь

Re: burning board (woltlab) support

same its hard i have no clue how to add the service to the shop..

Добавлено спустя 10 минут 16 секунд:
thanks for your time trying  i hope i have not wasted to much time from you

Online

Administrator

Re: burning board (woltlab) support

WoltLab Community Framework 2.x hash:

crypt(crypt($password, $salt), $salt);

HOST

Пользователь

Re: burning board (woltlab) support

that i know that its using 2x hashed but finding out the salt is still hard

Online

Administrator

Re: burning board (woltlab) support

Please test the installer in

HOST

Пользователь

Re: burning board (woltlab) support

going to test now

Добавлено спустя 43 минуты 10 секунд:
i used a clean install but cannot seem to find the Configure switchable authorization for woltlab

Online

Administrator

Re: burning board (woltlab) support

On step database connection click on WCF2 (WoltLab Community Framework 2.x).

HOST

Пользователь

Re: burning board (woltlab) support

aaaah yeah i see it woltlab is using WCF thats why i could not see it but i checked and it says wcf1_user

Online

Administrator

Re: burning board (woltlab) support

I tested with your password hash. The testing was successful for WCF2.

HOST

Пользователь

Re: burning board (woltlab) support

you sir are the best person ever :happy:  you make this work while others cannot even give information.
respect for your knowledge and your stress free trying you made it work.

Добавлено спустя 9 минут 24 секунды:

I tested with your password hash. The testing was successful for WCF2.

yeah correct but i changed the WCF2 to WCF in the config and it worked