do you know which versions? I looked for the info on snitz forum but could not find it...Endeavour2 wrote: However later versions of Snitz use md5 hashes to store the passwords, which is the same as phpbb IIRC. .
do you know which versions? I looked for the info on snitz forum but could not find it...Endeavour2 wrote: However later versions of Snitz use md5 hashes to store the passwords, which is the same as phpbb IIRC. .
Can you tell us which line to look?Endeavour2 wrote:. So if you wanted you could add the bit of code to copy the passwords from Snitz to phpbb (very easy, just add 1 line of code to get the password from the Snitz database where the code extracts the username etc, then add the var to the insert statement that puts it into the phpbb database - it's all well commented).
No, sorry. I only found out because I spent some time analyzing the Snitz source code to make this converter. The best way to do this is try to dump the Snitz passwords directly into the PHPBB users table then log in. If you can log in, the Snitz passwords were using MD5 so you're in luck. If you can't, sorry.vincentR wrote:do you know which versions? I looked for the info on snitz forum but could not find it...
Code: Select all
$pass = md5($snitzuser["M_PASSWORD"]);
Code: Select all
$pass = $snitzuser["M_PASSWORD"];
Code: Select all
// Now sort the user out
if($maptoexisting == False)
{
// This isn't being mapped to an existing user, so insert a new account to
// the phpbb table
$query = "INSERT INTO ".$phpbb_users."
( `user_id`, `user_active`, `username`, `user_email`, `user_website`, `user_regdate`, `user_password`, `user_attachsig`, `user_from`, `user_occ`, `user_interests`, `user_sig`, `user_sig_bbcode_uid`, `user_posts`) VALUES
( '$thisuser_phpbbid', '1', '$username', '$email', '$web', '$joindate', '$pass', '1', '$country', '$occupation', '$hobbies', '$sig', '$bbcodeuid', '$postcount')";
Code: Select all
Query was: INSERT INTO phpbb_users ( `user_id`, `user_active`, `username`, `user_email`, `user_website`, `user_regdate`, `user_password`, `user_interests`) values ( '3', '1', 'Snitz User', '[email protected]', 'http://www.amazingbrass.co.uk', 'Aug 22, 2007', 'c8a4c21d8773f1c0f87215f6ebf5d28f', 'This is a catch-all user for posts from deleted/invalid user accounts. It was created during the Snitz forum migration. This is not a real person!')
mysql_errno = 1264
mysql_error = Out of range value adjusted for column 'user_regdate' at row 1
extra info = Couldn't add the catch-all Snitz user into the phpbb user table
It is out of range because MySQL is expecting the date to be an integer, not a string. What needs to be done is convert the date to Unix time format which is a 10 digit integer.philwhite wrote:I can't see how the date can be out of range.
Clever ideas would be appreciated. I'm running MySQL 5.0.27 locally on a Windows machine with an Abyss Web server.
Code: Select all
$today = date("M")." ".date("d").", ".date("Y");
Code: Select all
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
Code: Select all
Snitz: [URL="www.xxx.com"]some text[/url].
phpBB: [URL=www.xxx.com]some text[/url].
Yes, there are some curiosities with different versions of Snitz. I noticed that the versions of Snitz I've converted so far don't use the [ url="blah" ] syntax, they all use [ url ]blah [ /url]. That may possibly be because nobody has posted in the forum using that syntax, but never mind.There's only one minor issue that I've come across, namely that the URL BB code in Snitz requires quotation marks and phpBB doesn't.
Code: Select all
Notice: Use of undefined constant END_TRANSACTION - assumed 'END_TRANSACTION' in C:\Sites\MySite\Myhost\webroot\sz2phpbb\mysql.php on line 128
Code: Select all
MySQL query error!
Query was: INSERT INTO tphpbbh_users ( `user_id`, `user_active`, `username`, `user_email`, `user_website`, `user_regdate`, `user_password`, `user_interests`) values ( '3', '1', 'Snitz User', '[email protected]', 'http://www.amazingbrass.co.uk', 'Oct 02, 2007', 'c73ad2d41ced1e08da5170a124c418a6', 'This is a catch-all user for posts from deleted/invalid user accounts. It was created during the Snitz forum migration. This is not a real person!')
mysql_errno = 1364
mysql_error = Field 'user_session_time' doesn't have a default value
extra info = Couldn't add the catch-all Snitz user into the phpbb user table
Code: Select all
MySQL query error!
Query was: INSERT INTO tphpbbh_users ( `user_id`, `user_active`, `username`, `user_email`, `user_website`, `user_regdate`, `user_password`, `user_interests`) values ( '3', '1', 'Snitz User', '[email protected]', 'http://www.amazingbrass.co.uk', 'Oct 02, 2007', 'c73ad2d41ced1e08da5170a124c418a6', 'This is a catch-all user for posts from deleted/invalid user accounts. It was created during the Snitz forum migration. This is not a real person!')
mysql_errno = 1364
mysql_error = Field 'user_session_time' doesn't have a default value
extra info = Couldn't add the catch-all Snitz user into the phpbb user table
Code: Select all
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
It start's fine and u can see it converting members but it always stops around memberID 460-500.. And when I try again I get this message:Snitz info:
Snitz 2000 3.4.06
1370 members
11 forums
97161 posts
12558 topics
Code: Select all
Confirmed the anonymous group was where it should be.
Confirmed the anonymous user was where it should be.
Found the last current phpbb userid (466), Snitz users will begin at 467.
Set the auto-increment to match the actual Nuke user id values.
Catch-all Snitz user already exists, guess you ran this script before :)
Deleting all phpbb users with a UserID higher than the Snitz catchall user.
MySQL query error!
Query was: SELECT `username` FROM phpbb_users WHERE `user_id`=466 LIMIT 1
mysql_errno = 0
mysql_error =
extra info = Safety-check for the catch-all Snitz user failed - it didn't have the expected phpbb userid