Jump to content

D3exter

Active Members
  • Posts

    141
  • Joined

  • Last visited

Posts posted by D3exter

  1. <?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?

  2. 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!

  3. TmJz9QK.jpg

    Creatorii site-ului au luat o masura radicala prin care doreste sa fie mai aproape de legalitate

    BitTorrent a anuntat BitTorrent Bundle, un nou timp de format de torrent care are continut gratuit insa functioneaza si ca legatura cu producatorii de opere, oferindu-le sansa de a-si distribui munca si de a beneficia de bani de pe urma ei.

    Pe de o parte, BitTorrent face un pas spre legalitate, spalandu-si intr-o oarecare masura imaginea. Pe de alta parte, cei care produc continut au ocazia sa se adreseze unei audiente numeroase careia sa ii ofere ceva gratis si sa-i propuna ceva mai interesant, eventual in schimbul unor bani.

    BitTorrent are peste 2 milioane de fisiere licentiate si legale in ecosistem (Matt Mason, vicepresedinte marketing BitTorrent, intr-o declaratie pentru Wired)

    Bundle (cuvant ce se traduce in romana prin pachet) este descris de companie drept o evolutie a conceptului de torrent. Utilizatorul descarca un fisier cu un format special care cuprinde nu doar continut gratuit, ci si altceva.

    La conferinta de presa a fost prezentat si un exemplu. Artistul DJ Kaskade le-a oferit fanilor piese in schimbul adreselor lor de email. Dupa ce utilizatorii dau click pe mailul de verificare, au acces la un trailer de 10 minute la rezolutie mare ce cuprinde imagini din spectacole, un remix la piesa Dada Life si altele.

    Artistii care doresc sa foloseasca serviciul trebuie sa negocieze direct cu BitTorrent, scrie theverge.

×
×
  • Create New...