phpBB.de

Code: Alles auswählen

<?php
include('config.php');
$resource = mysql_connect($dbhost, $dbuser, $dbpasswd);
if ( $resource === FALSE )
{
	die('Keine MySQL-Verbindung');
}
if ( !mysql_select_db($dbname, $resource) )
{
	die('Keine Verbindung zur Datenbank');
}
// Get last user_id
$sql = 'SELECT Max(user_id) as max_id FROM ' . $table_prefix . 'users';
$result = mysql_query($sql) or die('SQL-Error 1');
$row = mysql_fetch_array($result) or die('EOF 1');
$last_id = (int) $row['max_id'];
$time = time();

// define query for getting old records
$sql = 'SELECT nic, reg_mail FROM fa_pass0_login ORDER BY user_id';
$result = mysql_query($sql) or die('SQL-Error 1');
while ( $row = mysql_fetch_array($result) )
{
	$sql = 'INSERT INTO ' . $table_prefix . 'users (user_id, username, user_password, user_regdate, user_level, user_timezone, user_lang, user_dateformat, user_viewemail, user_attachsig, user_popup_pm, user_email) ' .
		'VALUES (' . ++$last_id . ", '{$row['nic']}', '0123456789abcdef0123456789abcdef', $time, 0, '1.00', 'german', 'D d.m.Y H:i', 0, 1, 1, '{$row['reg_mail']}')";
	mysql_query($sql) or die('SQL-Error 2: ' . $sql);
	echo ("{$row['nic']}<br>");
}
echo ("<br>Done!");
?>