phpMyBitTorrent Project Forums
Forum Search:

Members   Search      Help    Register    Login    Home
Home » Discussion Forums » Off Topic » sql
sql [message #3193] Sat, 14 November 2009 12:05 Go to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
Is it possible to import my members form a tsse sql database into pmbt database.

is there a convert prog out there?

(maybe only usernames-passwords-email addy)

Report message to a moderator

Re: sql [message #3194 is a reply to message #3193] Sat, 14 November 2009 12:25 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
I got a user import for TBdev based trackers how far off is tsse?

http://a.imageshack.us/img831/5562/mybikes.png

Report message to a moderator

Re: sql [message #3195 is a reply to message #3194] Sat, 14 November 2009 13:02 Go to previous messageGo to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
Thanks for the reply ... im not good wirh sql

pmbt is still on test rracker so i can remove some pats if need be .... ie blackjac/savetheworld/gotgift/ ... all these are adons

tsse structure code 


Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL default '',
  `passhash` varchar(32) NOT NULL default '',
  `secret` varchar(20) NOT NULL default '',
  `email` varchar(64) NOT NULL default '',
  `status` enum('pending','confirmed') NOT NULL default 'pending',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_access` datetime NOT NULL default '0000-00-00 00:00:00',
  `stylesheet` varchar(32) default NULL,
  `ip` varchar(15) NOT NULL default '',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '1024',
  `title` varchar(30) NOT NULL default '',
  `country` int(10) unsigned NOT NULL default '0',
  `notifs` mediumtext NOT NULL,
  `modcomment` longtext NOT NULL,
  `enabled` enum('yes','no') NOT NULL default 'yes',
  `donor` enum('yes','no') NOT NULL default 'no',
  `warned` enum('yes','no') NOT NULL default 'no',
  `warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `torrentsperpage` tinyint(2) unsigned NOT NULL default '0',
  `passkey` varchar(32) NOT NULL default '',
  `clientselect` int(10) unsigned default '0',
  `tzoffset` char(4) NOT NULL default '0',
  `invites` int(10) NOT NULL default '0',
  `invited_by` int(10) NOT NULL default '0',
  `seedbonus` decimal(9,1) NOT NULL default '0.0',
  `leechwarn` enum('yes','no') NOT NULL default 'no',
  `leechwarnuntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `timeswarned` int(10) NOT NULL default '0',
  `page` varchar(100) NOT NULL default '',
  `donated` decimal(8,2) NOT NULL default '0.00',
  `donoruntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `total_donated` decimal(8,2) NOT NULL default '0.00',
  `lastinvite` datetime NOT NULL default '0000-00-00 00:00:00',
  `announce_read` enum('yes','no') NOT NULL default 'yes',
  `usergroup` tinyint(3) unsigned NOT NULL default '0',
  `last_forum_visit` int(10) unsigned NOT NULL default '0',
  `last_forum_active` int(10) unsigned NOT NULL default '0',
  `avatar` varchar(200) NOT NULL default '',
  `postsperpage` tinyint(3) unsigned NOT NULL default '0',
  `signature` mediumtext NOT NULL,
  `totalposts` bigint(30) unsigned NOT NULL default '0',
  `birthday` varchar(10) NOT NULL default '',
  `visitorcount` int(10) unsigned NOT NULL default '0',
  `options` char(30) NOT NULL default 'A0B0C0D1E1F0G1H1I2K1L1M1N1O0P1',
  `pmunread` smallint(5) unsigned NOT NULL default '0',
  `speed` char(5) NOT NULL default '0~0',
  `smilieterms` enum('yes','no') NOT NULL default 'no',
  `gotgift` enum('yes','no') NOT NULL default 'no',
  `contact` varchar(255) NOT NULL default '',
  `savetheworld` datetime NOT NULL default '0000-00-00 00:00:00',
  `blackjackwon` int(10) NOT NULL default '0',
  `blackjacklost` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `passkey` (`passkey`),
  KEY `last_access` (`last_access`),
  KEY `uploaded` (`uploaded`),
  KEY `added` (`added`),
  KEY `birthday` (`birthday`),
  KEY `last_forum_active` (`last_forum_active`),
  KEY `status` (`status`,`timeswarned`,`enabled`),
  KEY `donor` (`donor`,`donoruntil`),
  KEY `warned` (`warned`,`leechwarn`,`enabled`),
  KEY `downloaded` (`leechwarn`,`uploaded`,`downloaded`),
  KEY `country` (`country`),
  KEY `invited_by` (`invited_by`),
  KEY `smilieterms` (`smilieterms`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1170 ;

--

[Updated on: Sat, 14 November 2009 13:55]

Report message to a moderator

Re: sql [message #3196 is a reply to message #3195] Sat, 14 November 2009 14:37 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
this should do it just add this as new page in PMBT root and call to it
<?php
include("header.php");
        global $db, $db_prefix, $user;

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

$query = $db->sql_query("SELECT id, level, seedbonus, username, email, uploaded, downloaded, modcomment, 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'];
$seedbonus = $olduser['seedbonus'];
if($olduser['level'] == "1")$newlevel = "user";
if($olduser['level'] == "3")$newlevel = "VIP";
if($olduser['level'] == "4")$newlevel = "uploaders";
if($olduser['level'] == "5")$newlevel = "Moderator";
if($olduser['level'] == "6")$newlevel = "super_mod";
if($olduser['level'] == "7")$newlevel = "admin";
$id = $olduser['id'];
$username = $olduser['username'];
$seedbonus = $olduser['seedbonus'];
$email = $olduser['email'];
$added = $olduser['added'];
$uploaded = $olduser['uploaded'];
$downloaded = $olduser['downloaded'];
$modcomment = stripslashes($olduser['modcomment']);
$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,modcomment,can_do,regdate,password,act_key,uploaded,downloaded,seedbonus,active".$passkeyrow.")
VALUES ('$id', '$username', '".strtolower($username)."', '$email', '".addslashes($modcomment)."', '".$newlevel."', '$added', '$tempass', '$act_key', '$uploaded', '$downloaded', '$seedbonus', '$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 Well Need To Recover their password...";
CloseTable();
include("footer.php");
?>

Make sure you edit this part
if($olduser['level'] == "1")$newlevel = "user";
if($olduser['level'] == "3")$newlevel = "VIP";
if($olduser['level'] == "4")$newlevel = "uploaders";
if($olduser['level'] == "5")$newlevel = "Moderator";
if($olduser['level'] == "6")$newlevel = "super_mod";
if($olduser['level'] == "7")$newlevel = "admin";

http://a.imageshack.us/img831/5562/mybikes.png

[Updated on: Sat, 14 November 2009 14:38]

Report message to a moderator

Re: sql [message #3197 is a reply to message #3196] Sat, 14 November 2009 14:59 Go to previous messageGo to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
so i need to put the old table (tsse) into the same db as pmbt ...
then run it
?

can i then use pmbt inport to fourm ?

[Updated on: Sat, 14 November 2009 15:06]

Report message to a moderator

Re: sql [message #3198 is a reply to message #3197] Sat, 14 November 2009 15:07 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
yes as long as the table name is not the same as PMBT which should be torrent_users
if it is the same you well want to make sure to change it

http://a.imageshack.us/img831/5562/mybikes.png

Report message to a moderator

Re: sql [message #3199 is a reply to message #3198] Sat, 14 November 2009 15:12 Go to previous messageGo to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
ok thanks joe will give it a go

[Updated on: Sat, 14 November 2009 15:13]

Report message to a moderator

Re: sql [message #3200 is a reply to message #3199] Sat, 14 November 2009 15:31 Go to previous messageGo to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
white screen joe?


<?php
include("header.php");
        global $db, $db_prefix, $user;

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

$query = $db->sql_query("SELECT id, level, seedbonus, username, email, uploaded, downloaded, modcomment, 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'];
$seedbonus = $olduser['seedbonus'];
if($olduser['level'] == "1")$newlevel = "user";
if($olduser['level'] == "2")$newlevel = "Power User";
if($olduser['level'] == "3")$newlevel = "VIP";
if($olduser['level'] == "4")$newlevel = "uploaders";
if($olduser['level'] == "5")$newlevel = "Moderator";
if($olduser['level'] == "6")$newlevel = "Admin";
if($olduser['level'] == "7")$newlevel = "Admin";
if($olduser['level'] == "8")$newlevel = "Team Leader";
if($olduser['level'] == "9")$newlevel = "S.F.B";
if($olduser['level'] == "10")$newlevel = "Owner";
if($olduser['level'] == "15")$newlevel = "FoTP";
$id = $olduser['id'];
$username = $olduser['username'];
$seedbonus = $olduser['seedbonus'];
$email = $olduser['email'];
$added = $olduser['added'];
$uploaded = $olduser['uploaded'];
$downloaded = $olduser['downloaded'];
$modcomment = stripslashes($olduser['modcomment']);
$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,modcomment,can_do,regdate,password,act_key,uploaded,downloaded,seedbonus,active".$passkeyrow.")
VALUES ('$id', '$username', '".strtolower($username)."', '$email', '".addslashes($modcomment)."', '".$newlevel."', '$added', '$tempass', '$act_key', '$uploaded', '$downloaded', '$seedbonus', '$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 Well Need To Recover their password...";
CloseTable();
include("footer.php");
?>


edit ... replaced ".$new_tableprefix." with ".$torrent_users." .. still no luck

[Updated on: Sat, 14 November 2009 15:48]

Report message to a moderator

Re: sql [message #3201 is a reply to message #3200] Sat, 14 November 2009 16:35 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
 
<?php
include("header.php");
        global $db, $db_prefix, $user;

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

$query = $db->sql_query("SELECT id, level, seedbonus, username, email, uploaded, downloaded, modcomment, 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'];
$seedbonus = $olduser['seedbonus'];
if($olduser['level'] == "1")$newlevel = "user";
if($olduser['level'] == "3")$newlevel = "VIP";
if($olduser['level'] == "4")$newlevel = "uploaders";
if($olduser['level'] == "5")$newlevel = "Moderator";
if($olduser['level'] == "6")$newlevel = "super_mod";
if($olduser['level'] == "7")$newlevel = "admin";
$id = $olduser['id'];
$username = $olduser['username'];
$seedbonus = $olduser['seedbonus'];
$email = $olduser['email'];
$added = $olduser['added'];
$uploaded = $olduser['uploaded'];
$downloaded = $olduser['downloaded'];
$modcomment = stripslashes($olduser['modcomment']);
$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 ".$db_prefix."_users (id,username,clean_username,email,modcomment,can_do,regdate,password,act_key,uploaded,downloaded,seedbonus,active".$passkeyrow.")
VALUES ('$id', '$username', '".strtolower($username)."', '$email', '".addslashes($modcomment)."', '".$newlevel."', '$added', '$tempass', '$act_key', '$uploaded', '$downloaded', '$seedbonus', '$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 Well Need To Recover their password...";
CloseTable();
include("footer.php");
?>


http://a.imageshack.us/img831/5562/mybikes.png

[Updated on: Sat, 14 November 2009 16:44]

Report message to a moderator

Re: sql [message #3202 is a reply to message #3201] Sat, 14 November 2009 17:17 Go to previous messageGo to next message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
With bit of tweaking that did it Joe ... thanks very much for all your help ..






(can you chk jungle site emil system dont seem to work)

Report message to a moderator

Re: sql [message #3203 is a reply to message #3202] Sat, 14 November 2009 17:46 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
fixed
sorry stell rebuilding system after HD crash
I activated you

http://a.imageshack.us/img831/5562/mybikes.png

[Updated on: Sat, 14 November 2009 18:06]

Report message to a moderator

Re: sql [message #3204 is a reply to message #3202] Sat, 14 November 2009 18:07 Go to previous messageGo to next message
joeroberts is currently offline joeroberts  United States
Messages: 1971
Registered: June 2006
Location: U.S.A
Releaser
Da HacKer
tymawr wrote on Sat, 14 November 2009 12:17
With bit of tweaking that did it Joe ... thanks very much for all your help ..






(can you chk jungle site emil system dont seem to work)

can you tell me what tweaks?

http://a.imageshack.us/img831/5562/mybikes.png

Report message to a moderator

Re: sql [message #3205 is a reply to message #3204] Sat, 14 November 2009 18:10 Go to previous message
tymawr is currently offline tymawr  United Kingdom
Messages: 11
Registered: November 2009
Leecher
Here is the code i used ... worked fine ...

{thank for the confirm)


<?php
include("header.php");
        global $db, $db_prefix, $user;

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

$query = $db->sql_query("SELECT id, usergroup, seedbonus, username, email, uploaded, downloaded, modcomment, 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'];
$seedbonus = $olduser['seedbonus'];

if($olduser['usergroup'] == "1")$newlevel = "user";
if($olduser['usergroup'] == "2")$newlevel = "Power User";
if($olduser['usergroup'] == "3")$newlevel = "VIP";
if($olduser['usergroup'] == "4")$newlevel = "uploaders";
if($olduser['usergroup'] == "5")$newlevel = "Moderator";
if($olduser['usergroup'] == "6")$newlevel = "Admin";
if($olduser['usergroup'] == "7")$newlevel = "Admin";
if($olduser['usergroup'] == "8")$newlevel = "Team Leader";
if($olduser['usergroup'] == "9")$newlevel = "S.F.B";
if($olduser['usergroup'] == "10")$newlevel = "Owner";
if($olduser['usergroup'] == "15")$newlevel = "FoTP";
$id = $olduser['id'];
$username = $olduser['username'];
$seedbonus = $olduser['seedbonus'];
$email = $olduser['email'];
$added = $olduser['added'];
$uploaded = $olduser['uploaded'];
$downloaded = $olduser['downloaded'];
$modcomment = stripslashes($olduser['modcomment']);
$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 ".$db_prefix."_users (id,username,clean_username,email,modcomment,can_do,regdate,password,act_key,uploaded,downloaded,seedbonus,active".$passkeyrow.")
VALUES ('$id', '$username', '".strtolower($username)."', '$email', '".addslashes($modcomment)."', '".$newlevel."', '$added', '$tempass', '$act_key', '$uploaded', '$downloaded', '$seedbonus', '$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 Well Need To Recover their password...";
CloseTable();
include("footer.php");
?>

[Updated on: Sat, 14 November 2009 18:10]

Report message to a moderator

Previous Topic:helpp...
Next Topic:Import-Export User's in phpbb3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Feb 08 05:50:09 GMT 2012

Total time taken to generate the page: 0.02758 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software