Jump to content
D3exter

Import baza de date

Recommended Posts

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!

Posted

<?php

// ne conectam la prima bd

// citim datele din tabela si le memoram intr-un array

// inchidem conexiunea la prima bd

// ne conectam la a doua bd

// facem foreach la array-ul de la prma bd

// inseram datele in bd

// inchidem conexiunea

// end

?>

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?

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.



×
×
  • Create New...