this well import user's from most TBDev based sources!!!
was also tested on TSSE 5.1 and imported 2498 users successfully.
First you need to make sure that the PMBT user table only has one user (id # 1 wich is you the admin) and you need to remove user id# 1 from TBDev wich should also be you if you are anouther id # you well want to remove that one and id#1.
this well stop cross ID's.
Remeber all users well need to recover there user password!!
AND there passkey well be replaced with a new one
PHP Code:
<?php
include("header.php");
# Table Names
$old_tableprefix = "users"; // Old table name
$new_tableprefix = "div_users"; //New Table Name
$query = $db->sql_query("SELECT id, username, email, added, secret, passhash, uploaded, downloaded, gender, status FROM {$old_tableprefix}") or sqlerr(__FILE__,__LINE__);
OpenTable("User Import");
echo "I will try to update user table --> ";
$count=0;
while ($olduser = $db->sql_fetchrow($query))
{
$id = $olduser['id'];
$username = $olduser['username'];
$email = $olduser['email'];
$added = $olduser['added'];
$uploaded = $olduser['uploaded'];
$downloaded = $olduser['downloaded'];
$tempass = RandomAlpha(8)
$act_key = RandomAlpha(32);
$status = ($olduser['status']=="confirmed")? 1 :0;
if($force_passkey){
do {
$passkey = ", '".RandomAlpha(32)."'";
//Check whether passkey already exists
$sqll = "SELECT passkey FROM ".$new_tableprefix." WHERE passkey = '".$passkey."';";
$resl = mysql_query($sqll)OR print("error");
$cnt = @mysql_num_rows($sqll);
@mysql_free_result($resl);
} while ($cnt > 0);
$passkeyrow = ', passkey';
}else{
$passkeyrow = NULL;
$passkey = NULL;
}
$sqlnew = "INSERT INTO ".$new_tableprefix." (id,username,clean_username,email,regdate,password,act_key,uploaded,downloaded,active".$passkeyrow.")
VALUES ('$id', '$username', '".strtolower($username)."', '$email', '$added', '$tempass', '$act_key', '$uploaded', '$downloaded', '$status' $passkey)";
$gonew = $db->sql_query($sqlnew);
if(!$gonew)echo "<br>Error:<br>Not able to creat ".$username." Maybe a duplicate Intry<br>";
$count++;
}
echo "Done..<br><br>Total {$count} users has been updaded...<br>Note: All users should recover their password...";
CloseTable();
include("footer.php");
?>
Now edit
PHP Code:
$old_tableprefix = "users"; // Old table name
$new_tableprefix = "div_users"; //New Table Name
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in
BT.Manager™ forum
My Current Demo is here
http://demo.btmanager.org/