Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > BT.Manager (phpMyBitTorrent) > Mods & Themes
Reply
  #1  
Old 29th June 2021, 09:15
wdq's Avatar
wdq wdq is offline
Senior Member
 
Join Date: Mar 2010
P2P
Posts: 45
Default An update for Transfer users to BTMANAGER?
Is there an update to this code too?
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")? :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");
?>
And do we really need to transfer the ID aswell ?
Being AUTO INCREMENT can't this get a new ID automatically?
Reply With Quote
  #2  
Old 4th July 2021, 12:26
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
I had started one but its not completed.
the reason ID was copied was to match uploads comments and forum posts
__________________
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/
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 18:57. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.