Jump to content
D3exter

Import baza de date

By D3exter, in Programare

Recommended Posts

D3exter Newbie

D3exter

Posted
Posted

Salut! Vreau sa fac importul din prima baza de date, in a doua baza de date:

1. NexusPHP

CREATE TABLE IF NOT EXISTS `torrents` (

`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

`info_hash` binary(20) NOT NULL,

`name` varchar(255) NOT NULL DEFAULT '',

`filename` varchar(255) NOT NULL DEFAULT '',

`save_as` varchar(255) NOT NULL DEFAULT '',

`descr` text,

`small_descr` varchar(255) NOT NULL DEFAULT '',

`ori_descr` text,

`category` smallint(5) unsigned NOT NULL DEFAULT '0',

`source` tinyint(3) unsigned NOT NULL DEFAULT '0',

`medium` tinyint(3) unsigned NOT NULL DEFAULT '0',

`codec` tinyint(3) unsigned NOT NULL DEFAULT '0',

`standard` tinyint(3) unsigned NOT NULL DEFAULT '0',

`processing` tinyint(3) unsigned NOT NULL DEFAULT '0',

`team` tinyint(3) unsigned NOT NULL DEFAULT '0',

`audiocodec` tinyint(3) unsigned NOT NULL DEFAULT '0',

`size` bigint(20) unsigned NOT NULL DEFAULT '0',

`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`type` enum('single','multi') NOT NULL DEFAULT 'single',

`numfiles` smallint(5) unsigned NOT NULL DEFAULT '0',

`comments` mediumint(8) unsigned NOT NULL DEFAULT '0',

`views` int(10) unsigned NOT NULL DEFAULT '0',

`hits` int(10) unsigned NOT NULL DEFAULT '0',

`times_completed` mediumint(8) unsigned NOT NULL DEFAULT '0',

`leechers` mediumint(8) unsigned NOT NULL DEFAULT '0',

`seeders` mediumint(8) unsigned NOT NULL DEFAULT '0',

`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`visible` enum('yes','no') NOT NULL DEFAULT 'yes',

`banned` enum('yes','no') NOT NULL DEFAULT 'no',

`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',

`nfo` blob,

`sp_state` tinyint(3) unsigned NOT NULL DEFAULT '1',

`anonymous` enum('yes','no') NOT NULL DEFAULT 'no',

`url` int(10) unsigned DEFAULT NULL,

`pos_state` enum('normal','sticky') NOT NULL DEFAULT 'normal',

`cache_stamp` tinyint(3) unsigned NOT NULL DEFAULT '0',

`picktype` enum('hot','classic','recommended','normal') NOT NULL DEFAULT 'normal',

`picktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`sp_state_temp` enum('2up_free','2up','free','half_down','normal') NOT NULL DEFAULT 'normal',

`last_reseed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

PRIMARY KEY (`id`),

UNIQUE KEY `info_hash` (`info_hash`),

KEY `owner` (`owner`),

KEY `visible_pos_id` (`visible`,`pos_state`,`id`),

KEY `url` (`url`),

KEY `category_visible_banned` (`category`,`visible`,`banned`),

KEY `visible_banned_pos_id` (`visible`,`banned`,`pos_state`,`id`),

FULLTEXT KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `users` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`username` varchar(40) NOT NULL DEFAULT '',

`passhash` varchar(32) NOT NULL DEFAULT '',

`secret` varbinary(20) NOT NULL,

`email` varchar(80) 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',

`last_home` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_offer` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`last_browse` int(10) unsigned NOT NULL DEFAULT '0',

`last_music` int(10) unsigned NOT NULL DEFAULT '0',

`last_catchup` int(10) unsigned NOT NULL DEFAULT '0',

`editsecret` varbinary(20) NOT NULL,

`privacy` enum('strong','normal','low') NOT NULL DEFAULT 'normal',

`stylesheet` tinyint(3) unsigned NOT NULL DEFAULT '1',

`caticon` tinyint(3) unsigned NOT NULL DEFAULT '1',

`fontsize` enum('small','medium','large') NOT NULL DEFAULT 'medium',

`info` text,

`acceptpms` enum('yes','friends','no') NOT NULL DEFAULT 'yes',

`commentpm` enum('yes','no') NOT NULL DEFAULT 'yes',

`ip` varchar(64) NOT NULL DEFAULT '',

`class` tinyint(3) unsigned NOT NULL DEFAULT '1',

`max_class_once` tinyint(3) NOT NULL DEFAULT '1',

`avatar` varchar(255) NOT NULL DEFAULT '',

`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',

`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',

`seedtime` bigint(20) unsigned NOT NULL DEFAULT '0',

`leechtime` bigint(20) unsigned NOT NULL DEFAULT '0',

`title` varchar(30) NOT NULL DEFAULT '',

`country` smallint(5) unsigned NOT NULL DEFAULT '107',

`notifs` varchar(500) DEFAULT NULL,

`modcomment` text,

`enabled` enum('yes','no') NOT NULL DEFAULT 'yes',

`avatars` enum('yes','no') NOT NULL DEFAULT 'yes',

`donor` enum('yes','no') NOT NULL DEFAULT 'no',

`donated` decimal(8,2) NOT NULL DEFAULT '0.00',

`donated_cny` decimal(8,2) NOT NULL DEFAULT '0.00',

`donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`warned` enum('yes','no') NOT NULL DEFAULT 'no',

`warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`noad` enum('yes','no') NOT NULL DEFAULT 'no',

`noaduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`torrentsperpage` tinyint(3) unsigned NOT NULL DEFAULT '0',

`topicsperpage` tinyint(3) unsigned NOT NULL DEFAULT '0',

`postsperpage` tinyint(3) unsigned NOT NULL DEFAULT '0',

`clicktopic` enum('firstpage','lastpage') NOT NULL DEFAULT 'firstpage',

`deletepms` enum('yes','no') NOT NULL DEFAULT 'yes',

`savepms` enum('yes','no') NOT NULL DEFAULT 'no',

`showhot` enum('yes','no') NOT NULL DEFAULT 'yes',

`showclassic` enum('yes','no') NOT NULL DEFAULT 'yes',

`support` enum('yes','no') NOT NULL DEFAULT 'no',

`picker` enum('yes','no') NOT NULL DEFAULT 'no',

`stafffor` varchar(255) NOT NULL,

`supportfor` varchar(255) NOT NULL,

`pickfor` varchar(255) NOT NULL,

`supportlang` varchar(50) NOT NULL,

`passkey` varchar(32) NOT NULL DEFAULT '',

`promotion_link` varchar(32) DEFAULT NULL,

`uploadpos` enum('yes','no') NOT NULL DEFAULT 'yes',

`forumpost` enum('yes','no') NOT NULL DEFAULT 'yes',

`downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes',

`clientselect` tinyint(3) unsigned NOT NULL DEFAULT '0',

`signatures` enum('yes','no') NOT NULL DEFAULT 'yes',

`signature` varchar(800) NOT NULL DEFAULT '',

`lang` smallint(5) unsigned NOT NULL DEFAULT '6',

`cheat` smallint(6) NOT NULL DEFAULT '0',

`download` int(10) unsigned NOT NULL DEFAULT '0',

`upload` int(10) unsigned NOT NULL DEFAULT '0',

`isp` tinyint(3) unsigned NOT NULL DEFAULT '0',

`invites` smallint(5) unsigned NOT NULL DEFAULT '0',

`invited_by` mediumint(8) unsigned NOT NULL DEFAULT '0',

`gender` enum('Male','Female','N/A') NOT NULL DEFAULT 'N/A',

`vip_added` enum('yes','no') NOT NULL DEFAULT 'no',

`vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`seedbonus` decimal(10,1) NOT NULL DEFAULT '0.0',

`charity` decimal(10,1) NOT NULL DEFAULT '0.0',

`bonuscomment` text,

`parked` enum('yes','no') NOT NULL DEFAULT 'no',

`leechwarn` enum('yes','no') NOT NULL DEFAULT 'no',

`leechwarnuntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`lastwarned` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`timeswarned` tinyint(3) unsigned NOT NULL DEFAULT '0',

`warnedby` mediumint(8) unsigned NOT NULL DEFAULT '0',

`sbnum` tinyint(3) unsigned NOT NULL DEFAULT '70',

`sbrefresh` smallint(5) unsigned NOT NULL DEFAULT '120',

`hidehb` enum('yes','no') DEFAULT 'no',

`showimdb` enum('yes','no') DEFAULT 'yes',

`showdescription` enum('yes','no') DEFAULT 'yes',

`showcomment` enum('yes','no') DEFAULT 'yes',

`showclienterror` enum('yes','no') NOT NULL DEFAULT 'no',

`showdlnotice` tinyint(1) NOT NULL DEFAULT '1',

`tooltip` enum('minorimdb','medianimdb','off') NOT NULL DEFAULT 'off',

`shownfo` enum('yes','no') DEFAULT 'yes',

`timetype` enum('timeadded','timealive') DEFAULT 'timealive',

`appendsticky` enum('yes','no') DEFAULT 'yes',

`appendnew` enum('yes','no') DEFAULT 'yes',

`appendpromotion` enum('highlight','word','icon','off') DEFAULT 'icon',

`appendpicked` enum('yes','no') DEFAULT 'yes',

`dlicon` enum('yes','no') DEFAULT 'yes',

`bmicon` enum('yes','no') DEFAULT 'yes',

`showsmalldescr` enum('yes','no') NOT NULL DEFAULT 'yes',

`showcomnum` enum('yes','no') DEFAULT 'yes',

`showlastcom` enum('yes','no') DEFAULT 'no',

`showlastpost` enum('yes','no') NOT NULL DEFAULT 'no',

`pmnum` tinyint(3) unsigned NOT NULL DEFAULT '10',

`school` smallint(5) unsigned NOT NULL DEFAULT '35',

`showfb` enum('yes','no') NOT NULL DEFAULT 'yes',

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`),

KEY `status_added` (`status`,`added`),

KEY `ip` (`ip`),

KEY `uploaded` (`uploaded`),

KEY `downloaded` (`downloaded`),

KEY `country` (`country`),

KEY `last_access` (`last_access`),

KEY `enabled` (`enabled`),

KEY `warned` (`warned`),

KEY `cheat` (`cheat`),

KEY `class` (`class`),

KEY `passkey` (`passkey`(8))

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

2. U-232

CREATE TABLE `torrents` (

`id` int(10) unsigned NOT NULL auto_increment,

`info_hash` varchar(40) collate utf8_unicode_ci NOT NULL,

`name` varchar(255) collate utf8_unicode_ci NOT NULL,

`filename` varchar(255) collate utf8_unicode_ci NOT NULL,

`save_as` varchar(255) collate utf8_unicode_ci NOT NULL,

`search_text` text collate utf8_unicode_ci NOT NULL,

`descr` text collate utf8_unicode_ci NOT NULL,

`ori_descr` text collate utf8_unicode_ci NOT NULL,

`category` int(10) unsigned NOT NULL default '0',

`size` bigint(20) unsigned NOT NULL default '0',

`added` int(11) NOT NULL,

`type` enum('single','multi') collate utf8_unicode_ci NOT NULL default 'single',

`numfiles` int(10) unsigned NOT NULL default '0',

`comments` int(10) unsigned NOT NULL default '0',

`views` int(10) unsigned NOT NULL default '0',

`hits` int(10) unsigned NOT NULL default '0',

`times_completed` int(10) unsigned NOT NULL default '0',

`leechers` int(10) unsigned NOT NULL default '0',

`seeders` int(10) unsigned NOT NULL default '0',

`last_action` int(11) NOT NULL,

`visible` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`banned` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`owner` int(10) unsigned NOT NULL default '0',

`numratings` int(10) unsigned NOT NULL default '0',

`ratingsum` int(10) unsigned NOT NULL default '0',

`nfo` text collate utf8_unicode_ci NOT NULL,

`client_created_by` char(50) collate utf8_unicode_ci NOT NULL default 'unknown',

`free` int(11) unsigned NOT NULL default '0',

`sticky` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`anonymous` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`url` varchar(80) collate utf8_unicode_ci default NULL,

`checked_by` varchar(40) collate utf8_unicode_ci NOT NULL default '',

`points` int(10) NOT NULL default '0',

`allow_comments` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`poster` varchar(255) character set utf8 collate utf8_bin NOT NULL default 'pic/noposter.png',

`nuked` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`nukereason` varchar(100) collate utf8_unicode_ci NOT NULL default '',

`last_reseed` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `info_hash` (`info_hash`),

KEY `owner` (`owner`),

KEY `visible` (`visible`),

KEY `category_visible` (`category`,`visible`),

FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `users` (

`id` int(10) unsigned NOT NULL auto_increment,

`username` varchar(40) collate utf8_unicode_ci NOT NULL,

`passhash` varchar(32) collate utf8_unicode_ci NOT NULL,

`secret` varchar(20) collate utf8_unicode_ci NOT NULL,

`passkey` varchar(32) collate utf8_unicode_ci NOT NULL default '',

`email` varchar(80) collate utf8_unicode_ci NOT NULL,

`status` enum('pending','confirmed') collate utf8_unicode_ci NOT NULL default 'pending',

`added` int(11) NOT NULL,

`last_login` int(11) NOT NULL,

`last_access` int(11) NOT NULL,

`curr_ann_last_check` int(10) unsigned NOT NULL default '0',

`curr_ann_id` int(10) unsigned NOT NULL default '0',

`editsecret` varchar(32) collate utf8_unicode_ci NOT NULL,

`privacy` enum('strong','normal','low') collate utf8_unicode_ci NOT NULL default 'normal',

`stylesheet` int(10) default '1',

`info` text collate utf8_unicode_ci,

`acceptpms` enum('yes','friends','no') collate utf8_unicode_ci NOT NULL default 'yes',

`ip` varchar(15) collate utf8_unicode_ci NOT NULL,

`class` tinyint(3) unsigned NOT NULL default '0',

`override_class` tinyint(3) unsigned NOT NULL default '255',

`language` varchar(32) collate utf8_unicode_ci NOT NULL default 'en',

`avatar` varchar(100) collate utf8_unicode_ci NOT NULL,

`av_w` smallint(3) unsigned NOT NULL default '0',

`av_h` smallint(3) unsigned NOT NULL default '0',

`uploaded` bigint(20) unsigned NOT NULL default '0',

`downloaded` bigint(20) unsigned NOT NULL default '0',

`title` varchar(30) collate utf8_unicode_ci NOT NULL,

`country` int(10) unsigned NOT NULL default '0',

`notifs` varchar(100) collate utf8_unicode_ci NOT NULL,

`modcomment` text collate utf8_unicode_ci NOT NULL,

`enabled` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`donor` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`warned` int(11) NOT NULL default '0',

`torrentsperpage` int(3) unsigned NOT NULL default '0',

`topicsperpage` int(3) unsigned NOT NULL default '0',

`postsperpage` int(3) unsigned NOT NULL default '0',

`deletepms` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`savepms` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`reputation` int(10) NOT NULL default '10',

`time_offset` varchar(5) collate utf8_unicode_ci NOT NULL default '0',

`dst_in_use` tinyint(1) NOT NULL default '0',

`auto_correct_dst` tinyint(1) NOT NULL default '1',

`show_shout` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'yes',

`shoutboxbg` enum('1','2','3') character set utf8 collate utf8_bin NOT NULL default '1',

`chatpost` int(11) NOT NULL default '1',

`smile_until` int(10) NOT NULL default '0',

`seedbonus` decimal(10,1) NOT NULL default '200.0',

`bonuscomment` text collate utf8_unicode_ci,

`vip_added` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`vip_until` int(10) NOT NULL default '0',

`freeslots` int(11) unsigned NOT NULL default '5',

`free_switch` int(11) unsigned NOT NULL default '0',

`invites` int(10) unsigned NOT NULL default '1',

`invitedby` int(10) unsigned NOT NULL default '0',

`invite_rights` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`anonymous` enum('yes','no') collate utf8_unicode_ci default NULL,

`uploadpos` int(11) NOT NULL default '1',

`forumpost` int(11) NOT NULL default '1',

`downloadpos` int(11) NOT NULL default '1',

`immunity` int(11) NOT NULL default '0',

`leechwarn` int(11) NOT NULL default '0',

`disable_reason` text character set utf8 collate utf8_bin NOT NULL,

`clear_new_tag_manually` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`last_browse` int(11) NOT NULL default '0',

`sig_w` smallint(3) unsigned NOT NULL default '0',

`sig_h` smallint(3) unsigned NOT NULL default '0',

`signatures` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'yes',

`signature` varchar(225) collate utf8_unicode_ci NOT NULL default '',

`forum_access` int(11) NOT NULL default '0',

`mood` int(10) NOT NULL default '1',

`highspeed` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`hnrwarn` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`hit_and_run_total` int(9) default '0',

`donoruntil` int(11) unsigned NOT NULL default '0',

`donated` decimal(8,2) NOT NULL default '0.00',

`total_donated` decimal(8,2) NOT NULL default '0.00',

`vipclass_before` int(10) NOT NULL default '0',

`parked` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`passhint` int(10) unsigned NOT NULL,

`hintanswer` varchar(40) collate utf8_unicode_ci NOT NULL default '',

`avatarpos` int(11) NOT NULL default '1',

`support` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`supportfor` text collate utf8_unicode_ci NOT NULL,

`sendpmpos` int(11) NOT NULL default '1',

`invitedate` int(11) NOT NULL default '0',

`invitees` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',

`invite_on` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'yes',

`coins` decimal(10,1) unsigned NOT NULL default '100.0',

`forum_mod` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'no',

`forums_mod` varchar(320) character set utf8 collate utf8_bin NOT NULL default '',

`subscription_pm` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'no',

`gender` enum('Male','Female','N/A') collate utf8_unicode_ci NOT NULL default 'N/A',

`anonymous_until` int(10) NOT NULL default '0',

`viewscloud` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'yes',

`tenpercent` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`forcessl` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'no',

`avatars` enum('all','some','none') collate utf8_unicode_ci NOT NULL default 'all',

`offavatar` enum('yes','no') collate utf8_unicode_ci NOT NULL default 'no',

`pirate` int(11) unsigned NOT NULL default '0',

`king` int(11) unsigned NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`),

KEY `ip` (`ip`),

KEY `uploaded` (`uploaded`),

KEY `downloaded` (`downloaded`),

KEY `country` (`country`),

KEY `last_access` (`last_access`),

KEY `enabled` (`enabled`),

KEY `warned` (`warned`),

KEY `pkey` (`passkey`),

KEY `free_switch` (`free_switch`),

KEY `iphistory` (`ip`,`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Ma poate ajuta cineva? Multumesc!

Link to comment
Share on other sites
D3exter Newbie

D3exter

Posted
  • Author
Posted 

<?php
require_once("include/bittorrent.php");
dbconn();

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

#$query = do_mysql_query("SELECT id, username, email, added, secret, passhash, uploaded, downloaded, donor, gender, country, vip_until FROM {$old_tableprefix}") or sqlerr(__FILE__,__LINE__);
$query = do_mysql_query("SELECT id, username, email, added, secret, passhash, uploaded, downloaded, gender, status FROM {$old_tableprefix}") or sqlerr(__FILE__,__LINE__);

stdhead();
echo "I will try to update user table --> ";
$count=0;
while ($olduser = mysql_fetch_assoc($query))
{
  //  $id = intval($olduser['id']);
  //  if ($id == 1)
   //     $class = UC_SYSOP;
  //  else
      //  $class = UC_USER;

    $id = sqlesc($olduser['id']);
    $username = sqlesc($olduser['username']);
    $passhash = sqlesc($olduser['passhash']);
    $secret = sqlesc($olduser['secret']);
    $email = sqlesc($olduser['email']);
    $added = sqlesc($olduser['added']);
    $uploaded = sqlesc($olduser['uploaded']);
    $downloaded = sqlesc($olduser['downloaded']);
   // $donor = sqlesc($olduser['donor']);
    $gender = sqlesc($olduser['gender']);
    $status = sqlesc($olduser['status']);
  //  $country = sqlesc($olduser['country']);
  //  $donoruntil = sqlesc($olduser['vip_until']);



  /*  do_mysql_query("INSERT INTO {$new_tableprefix} (id,username,email,passhash,secret,added,uploaded,downloaded,donor,gender,countr
y,donoruntil) 
    VALUES ($id, $username, $email, $passhash, $secret, $added, $uploaded, $downloaded, $donor, $gender, $country, $donoruntil)");
    $count++;
}   */

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

echo "Done..

Total {$count} users has been updaded...
Note: All users should recover their password...";
stdfoot();
?>

Tu zici ceva in genu', nu? Dar cum fac cu acele campuri care nu au acelasi format?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing
×
×
  • Create New...