<?php
//Importer script
session_start();
if($_SESSION['imported']) { die("Multiple importation ruins it."); }
//old database containing securebux/bux3/yourownbux data
$ndb_host = 'sql210.zybex.co.cc';
$ndb_user = 'zybex_2570191';
$ndb_pass = '*****';
$ndb_base = 'zybex_2570191_centbux';
$p3 = mysql_connect($ndb_host,$ndb_user,$ndb_pass) or die("Couldn't connect to old database.");
mysql_select_db($ndb_base,$p3) or die("Couldn't connect to old database.");
include "lib/lib_database.php";
$cfg = mysql_connect(DB_HOST,DB_USER,DB_PASS);
mysql_select_db(DB_NAME,$cfg);
$runp1 = mysql_query("SELECT * FROM tb_users ORDER BY id",$p3);
while($rp1 = mysql_fetch_array($runp1))
{
mysql_query("INSERT INTO `users` (
`userid` ,
`username` ,
`password` ,
`email` ,
`paypal_email` ,
`alertpay_email` ,
`signupdate` ,
`signupip` ,
`upgraded` ,
`country` ,
`balance` ,
`withdrew` ,
`ads_clicked` ,
`upline` ,
`referrals` ,
`posts` ,
`lastaction` ,
`lastip` ,
`advertiser_balance` ,
`suspended`,
`refclicks`
)
VALUES (
'{$rp1['id']}' , '{$rp1['username']}', '{$rp1['password']}', '{$rp1['email']}', '{$rp1['email']}', '{$rp1['email']}', unix_timestamp(), '{$rp1['ip']}', '0', '{$rp1['country']}', '{$rp1['money']}', '{$rp1['paid']}', '', '{$rp1['referer']}', '{$rp1['referals']}', '0', '{$rp1['lastlogdate']}', '{$_SERVER['REMOTE_ADDR']}', '0.00', '0', '{$rp1['referalvisits']}'
);",$cfg);
$transferred++;
}
if($transferred > 0)
{
$contents .= "We successfully transfered {$transferred} users to your SCRIPT!<br />";
$_SESSION['imported']=1;
}
?>
