odpal takie coś:
[php]<?
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, 0, $session_length);
init_userprefs($userdata);
if($userdata['user_level'] != ADMIN)
{
message_die(GENERAL_ERROR, 'Musi byc admin');
}
$email =
'test@test.com';
$czas = time();
$sql = "SELECT max(user_id) as total FROM " . USERS_TABLE;
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'dupa', "", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$user_id = $row['total'];
$uchwyt = @fopen ('lista.txt', "r");
if ($uchwyt) {
while (!feof($uchwyt)) {
$buffer = fgets($uchwyt, 4096);
$buffer = explode(';', $buffer);
$username = $buffer[0];
$haslo = $buffer[1];
++$user_id;
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ($user_id, '$username', 0, $czas, '$haslo', '$mail', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 1, 1, 0, 1, 1, NULL, '', 'polish', 0, '', '', '', 0, 1);";
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'dupa', "", __LINE__, __FILE__, $sql);
}
}
}
echo('<br />KONIEC');
?>[/php]
lista.txt
Kod:
nazwa_uzytkownika;haslo
nazwa_uzytkownika2;haslo2
Lista.txt musi być w tym samym kat. co plik ze skryptem w takiej postaci jak napisałem. Da się to osiągnąć eksportując arkusz excela do pliku.
Powinno działać...
Jak nie to nie, łaski bez...