import users and torrent

[Njep]

Hello!
Is there any one who know any good way to import users and torrents from ts_4.3 -->tbdev tracker?

[Subzero]

it would be a pain m8 but not impossible you install the ts database then copy your users into sql query and you might get errors sayin this dont exist ect you just gonna have to add them things but like i said will be a pain so i suggest staying with xmas code

[Izacic]

i need from yuna scatari to tbdev netmaniack 1.6 ????

[brysf150]

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..<br><br>Total {$count} users has been updaded...<br>Note: All users may have to recover their password...";
end_frame();
stdfoot();
?>