| brysf150 |
5th March 2009 10:42 |
I'm not sure who originally wrote this code but here is an import user import script I edited to import users from TorrentTrader -> TBDev
You can use this to import users/forum posts with a little modifying.
PHP Code:
<?php
require_once("include/bittorrent.php");
dbconn();
# Table Names
$old_tableprefix = "users2"; // Old table name
$new_tableprefix = "users"; //New Table Name
$query = mysql_query("SELECT id, username, password, secret, email, status, added, last_login, last_access, class, ip, avatar, uploaded, downloaded, title, enabled, invited_by, donated, invitees, warned FROM {$old_tableprefix}") or sqlerr(__FILE__,__LINE__);
stdhead();
begin_frame("Import Users");
echo "I will try to update user table --> ";
$count=0;
while ($olduser = mysql_fetch_assoc($query)){
$id = sqlesc($olduser['id']);
$username = sqlesc($olduser['username']);
$password = sqlesc($olduser['password']);
$secret = sqlesc($olduser['secret']);
$email = sqlesc($olduser['email']);
$status = sqlesc($olduser['status']);
$added = sqlesc($olduser['added']);
$last_login = sqlesc($olduser['last_login']);
$last_access = sqlesc($olduser['last_access']);
$ip = sqlesc($olduser['ip']);
$class = sqlesc($olduser['class']-1);
$avatar = sqlesc($olduser['avatar']);
$uploaded = sqlesc($olduser['uploaded']);
$downloaded = sqlesc($olduser['downloaded']);
$title = sqlesc($olduser['title']);
$enabled = sqlesc($olduser['enabled']);
$warned = sqlesc($olduser['warned']);
$donated = sqlesc($olduser['donated']);
$status = sqlesc($olduser['status']);
$invited_by = sqlesc($olduser['invited_by']);
$invitees = sqlesc($olduser['invitees']');
$bohp = yes
mysql_query("INSERT INTO {$new_tableprefix} (id,username,passhash,secret,email,status,added,last_login,last_access,ip,avatar,uploaded,downloaded,title,enabled,warned,invitedby,invitees,class,donated,total_donated,bohp)
VALUES ($id, $username, $password, $secret, $email, $status, $added, $last_login, $last_access, $ip, $avatar, $uploaded, $downloaded, $title, $enabled, $warned, $invited_by, $invitees, $class, $donated, $donated, $bohp)");
$count++;
}
echo "Done..Total {$count} users has been updaded...Note: All users may have to recover their password...";
end_frame();
stdfoot();
?>
|
