[daffy]

maybe good to mention on first post.

create directory import and chmod 777 for torrent-import

trying to add script to import my users from TT table to H20

so far i have below but get white page.

<?php

require_once("backend/functions.php");
dbconn(false);
loggedinonly();

# Table Names
$old_tableprefix = "users2";
// Old table name
$new_tableprefix = "users";

//New Table Name
$query = do_mysql_query("SELECT id, username, email, added, secret, password, uploaded, downloaded, gender, status FROM {$old_tableprefix}") or sqlerr(__FILE__,__LINE__);


stdhead("userimport");

begin_frame("userimport");

echo "I will try to update user table --> ";

$count=0;
while ($olduser = mysql_fetch_array($query))

{

$id = sqlesc($olduser['id']);
$username = sqlesc($olduser['username']);
$password = sqlesc($olduser['password']);
$secret = sqlesc($olduser['secret']);
$email = sqlesc($olduser['email']);
$added = sqlesc($olduser['added']);
$uploaded = sqlesc($olduser['uploaded']);
$downloaded = sqlesc($olduser['downloaded']);
$gender = sqlesc($olduser['gender']);
$status = sqlesc($olduser['status']);

do_mysql_query("INSERT INTO {$new_tableprefix} (id,username,email,password,secret,added,uploaded,downloaded,gender,status)
VALUES ($id, $username, $email, $password, $secret, $added, $uploaded, $downloaded, $gender, $status)");
$count++;
}

echo "Done..Total {$count} users has been updaded...Note: All users should recover their password...";

end_frame();

stdfoot();

?>