скачать русский перевод, моды, скины и стили для phpBB, phpBB3
IGO писал(а):то почему нельзя было войти?
IGO писал(а):(отрезанно 8 символов d8fa5e7f)
sporkit150 писал(а):i converted my database some time ago with my own scripts. basically i dump the 40 char punbb encryption into the 32 char phpbb db. all my function does is sees if a trunckated pass matches the old encryption and then updates the database.
find...under paste...Код: Выделить всё
$username = isset($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : ''; $password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';Код: Выделить всё
//*** start punnbb to phpbb password converter *** //this extra bit of code checks if the pass is from punnbb then //updates the password to something phpbb would understand. there //are other ways to do this but i believe that this requires the least //amount of editing (and understanding) of phpbbs original code. ;') $sql = "SELECT user_id, username, user_password FROM " . USERS_TABLE . " WHERE username = '" . str_replace("\\'", "''", $username) . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql); } //lets just make sure the user exists if ( mysql_num_rows( $result ) == 1 ) { //users exists so lets grab their info if( $row = $db->sql_fetchrow($result) ) { //if a sha1 encryption is equal to the pass in the database then its left over from punbb //also its only 32 chars long since they were trunkated in the dump if ( substr( sha1( $HTTP_POST_VARS['password'] ), 0, 32) == substr( $row['user_password'], 0, 32) ) { //take the subbed pass and put a md5 encryption on it and insert it into the database $sql = "UPDATE phpbb_users SET user_password = '" . md5( $HTTP_POST_VARS['password'] ) . "' WHERE user_id = '" . $row['user_id'] . "'"; if (@mysql_query($sql)) { /*the pass was updated to md5!!!*/ } else { echo("Password Error: " . mysql_error() . "<br>Please contact your board admin immediatly."); } } } } //were updating the database password (if neccessary) before phpbb has a //chance to check it. the rest of the code should just run as if normally. //coded by: sporkit @ www.sporkit.com © 2005 //*** end punnbb to phpbb password converter ***
Я уже почти сделал. мне осталось кодировку поправить. ночью просто не успел.Я сейчас собираюсь из punbb 1.2.20 конвертить форум в phpbb 3.0.2
It does seem easiest to stay with what you are familiar with, but you should give phpBB3 a chance. It is very powerful and has a lot of great features. The Administration Panel does take a little getting used to, but once you get used to it, you will be amazed at the things you can do.
You are correct that the PunBB passwords will not work on phpBB3 as the two boards use different password encryption techniques. You will need to upload a new auth file so that the PunBB passwords will work on phpBB3.
Get this file, PunBB auth. Unzip and upload it to your phpBB3 root directory maintaining the directory structure.
Since you can't log in to the Administration Panel, you will need to modify your database manually. With phpMyAdmin, or similar, browse the phpBB3 config table.
Change the auth_method config_value to punbb and Save
You and your members should now be able to log in to phpBB3.
