Code: Select all
UPDATE phpbb_users SET user_level = 1 WHERE user_id = 2;
Code: Select all
UPDATE phpbb_users SET user_level = 1 WHERE user_id = 2;
You have posted in a topic dedicated to converting from PHP-Nuke to phpBB.KutuluXul wrote:Hey there!
Looks like some great support and phpBB community smarts here!
I need all the help I can get! Heh - I am very much an amateur website admin, using PHPNUKE 8.0.
Our forum code is : phpbb2 forums port version 2.0.5 (c) 2003.
...
It looks like your conv_nuke_214a.php file may be corrupted.thalador wrote:Dicky,
I have tried using the con_nuke_214a.php I saw you mention in another thread and I get this when I try to run it
./conv_nuke_214a.php
./conv_nuke_214a.php: line 1: ?php: No such file or directory
./conv_nuke_214a.php: line 2: /bin: is a directory
./conv_nuke_214a.php: line 3: phpBB: Is a directory
./conv_nuke_214a.php: line 4: cgi-bin: command not found
./conv_nuke_214a.php: line 6: cgi-bin: command not found
./conv_nuke_214a.php: line 7: cgi-bin: command not found
./conv_nuke_214a.php: line 9: cgi-bin: command not found
./conv_nuke_214a.php: line 10: cgi-bin: command not found
./conv_nuke_214a.php: line 11: cgi-bin/: is a directory
./conv_nuke_214a.php: line 13: syntax error near unexpected token `'IN_PHPBB','
./conv_nuke_214a.php: line 13: `define('IN_PHPBB', true);'
Any ideas what I am doing wrong? I have installed a stock 2.0.23 phpbb board.
Thanks for the help
Code: Select all
print("Exporting data from PHP-Nuke tables: users...");
@mysql_connect($config['nuke_server'],$config['nuke_username'],$config['nuke_password']);
mysql_select_db($config['nuke_db']);
$res = @mysql_query("SELECT * FROM ".$config['nuke_prefix']."users");
@mysql_connect($config['phpbb_server'],$config['phpbb_username'],$config['phpbb_password']);
mysql_select_db($config['phpbb_db']);
// by linuxap: cancella l'user anonimo, assegna all'amministratore un id negativo, carica gli id del nuke,
// legge l'ultimo id e lo aggiorna all'amministratore
@mysql_query_fail("DELETE FROM ".$config['phpbb_prefix']."users WHERE username = 'Anonymous'" );
@mysql_query_fail("UPDATE " . $config['phpbb_prefix'] ."users SET user_id = '-2'");// negativo - il -1 verra' assgnato all'Anonymous
$id=0;
while ( $row = @mysql_fetch_array($res) )
{
// calcola l'ultimo id
$id_nuke=$row['user_id'];
if($id_nuke >$id) $id=$id_nuke;
$time = $row['user_regdate'];
$date = str_replace(",","",$time);
$date = explode(" ",$date);
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;
}
$timestamp = date("U", gmmktime(0,0,0,$m,$date[1],$date[2]));
$user_level = $row['user_level'] - 1;
$user_style = 1;
/* jaymer - had to explicitly use field names for the INSERT, plus
added the "slash" stuff below on a few fields. */
$query = "INSERT INTO ".$config['phpbb_prefix']."users
(user_id,
user_active,
username,
user_password,
user_session_time,
user_session_page,
user_lastvisit,
user_regdate,
user_level,
user_posts,
user_timezone,
user_style,
user_lang,
user_dateformat,
user_new_privmsg,
user_unread_privmsg,
user_last_privmsg,
user_emailtime,
user_viewemail,
user_attachsig,
user_allowhtml,
user_allowbbcode,
user_allowsmile,
user_allowavatar,
user_allow_pm,
user_allow_viewonline,
user_notify,
user_notify_pm,
user_popup_pm,
user_rank,
user_avatar,
user_avatar_type,
user_email,
user_icq,
user_website,
user_from,
user_sig,
user_sig_bbcode_uid,
user_aim,
user_yim,
user_msnm,
user_occ,
user_interests,
user_actkey,
user_newpasswd
) values (
'".$row['user_id']."',
'".$row['user_active']."',
'".sql_addslashes($row['username'])."',
'".$row['user_password']."',
'".$row['user_session_time']."',
'".$row['user_session_page']."',
'".$row['user_lastvisit']."',
'".$timestamp."',
'".$user_level."',
'".$row['user_posts']."',
'".$row['user_timezone']."',
'".$user_style."',
'".$row['user_lang']."',
'".$row['user_dateformat']."',
'".$row['user_new_privmsg']."',
'".$row['user_unread_privmsg']."',
'".$row['user_last_privmsg']."',
'".$row['user_emailtime']."',
'".$row['user_viewemail']."',
'".$row['user_attachsig']."',
'".$row['user_allowhtml']."',
'".$row['user_allowbbcode']."',
'".$row['user_allowsmile']."',
'".$row['user_allowavatar']."',
'".$row['user_allow_pm']."',
'".$row['user_allow_viewonline']."',
'".$row['user_notify']."',
'".$row['user_notify_pm']."',
'".$row['user_popup_pm']."',
'".$row['user_rank']."',
'".sql_addslashes($row['user_avatar'])."',
'".$row['user_avatar_type']."',
'".$row['user_email']."',
'".$row['user_icq']."',
'".$row['user_website']."',
'".sql_addslashes($row['user_from'])."',
'".sql_addslashes($row['user_sig'])."',
'".$row['user_sig_bbcode_uid']."',
'".sql_addslashes($row['user_aim'])."',
'".sql_addslashes($row['user_yim'])."',
'".sql_addslashes($row['user_msnm'])."',
'".sql_addslashes($row['user_occ'])."',
'".sql_addslashes($row['user_interests'])."',
'".$row['user_actkey']."',
'".$row['user_newpasswd']."'
)";
/* echo $query; */
@mysql_query_fail($query);
}
$table = "users";
$sql = "UPDATE " . $config['phpbb_prefix'] . $table . " SET user_id = '-1', user_active = '0' WHERE username = 'Anonymous'";
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not update anonymous user in phpbb users table", "", __LINE__, __FILE__, $sql);
}
$id=$id+1;// aumenta di uno l'ultimo id
@mysql_query_fail("UPDATE " . $config['phpbb_prefix'] ."users SET user_id = '$id' WHERE user_id = '-2'");// assgna l'ultimo id+1
//print("numero: $id<br />");
print("Success<br />");