phpBB.de

riderr hat geschrieben:2. Use PHPMyAdmin to drop the following tables in the fresh copy: Auth-access, Topics, Categories, Forums, Posts, Posts_text.

Hui, was ist damit gemeint? PHPmyAdmin aufrufen ist klar. Was soll ich da genau tun?

3. Then use PHPMyAdmin to export the above tables from the PHPNuke copy (nuke_bb*) then change the nuke_bb values to phpbb_ or whatever your prefix is and import them into the fresh copy. Be sure to choose data AND structure when exporting the original tables.

Okay, alle nuke_bb tabellen exportieren. Wie kann ich die dann in phpbb umbennen?

4. Then export data AND structure of the nuke_users table. Again change all the nuke_ values to phpbb_ and import it. Now some tricky modding, you'll have to convert the regdate to unixtime, so in phpmyadmin edit all the user_regdate fields. See http://www.onlineconversion.com/unix_time.htm for a online unixtime converter.

Hilfe!! Kann jemand verständlich erklären?!

5. When that is done, alter the user table by deleting all fields that NOT start with user_ (except username).

?

6. Then export DATA only of the following nuke fields: nuke_bbgroups and nuke_bbuser_groups. Again change the nuke_bb values to phpbb_ and then import them.

Wieder umbennenen. Wie?

Das ist hart (ich hoffe, es gibt noch eine automatische Lösung dafür). Die Beuntzertabelle muß importiert und umdenannt werden. Aber da das Feld user_regdate ein anderes Format hat, müßte das für alle 2000 Benutzer manuell umgewandelt werden... das ist natürlich Wahnsinn

I have a script that will correct the user regdate from nuke to phpbb if anyone is interested so when you convert your forums the correct registration date will appear and place the unix date back into the table!

<?
/*******************************************************************/
/* Place this file in the same folder as config.php */
/*******************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$sql = "SELECT user_id, user_regdate FROM phpbb_users";
$result = $db->sql_query($sql);
while($record = $db->sql_fetchrow($result)) {
extract($record);
$user_regdate = str_replace(',',' ',$user_regdate);
$date = explode(' ',$user_regdate,3);
switch($date[0]) {
case('Jan'): $m=1; break;
case('Feb'): $m=2; break;
case('Mar'): $m=3; break;
case('Apr'): $m=4; break;
case('May'): $m=5; break;
case('Jun'): $m=6; break;
case('Jul'): $m=7; break;
case('Aug'): $m=8; break;
case('Sep'): $m=9; break;
case('Oct'): $m=10; break;
case('Nov'): $m=11; break;
case('Dec'): $m=12; break;
}
$newDate = mktime(0, 0, 0, $m, $date[1], $date[2]);
echo $user_id.' -- '.$user_regdate.' = '.$newDate.' = '.date('m d Y',$newDate).'<br />';
/*******************************************************************/
/* When you are satisfied that the code is working correctly, */
/* uncomment the following 2 lines and resubmit the script. */
/*******************************************************************/
//$sql = "UPDATE phpbb_users set user_regdate = $newDate where user_id = $user_id";
//$result1 = $db->sql_query($sql);
}
?>

$sql = "SELECT user_id, user_regdate FROM phpbb_users";

Heißen dann Deine Tabellen phpbb_1users und so weiter?