How I Move Xbtit DT FM to U232

Started by skmdrony, August 11, 2014, 02:05:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1 2
User actions

skmdrony

#20
August 12, 2014, 03:55:44 PM Last Edit: August 14, 2014, 07:12:56 PM by skmdrony
Ok Mindless Bro I Am Waiting Some Good Result Thanks For Helping

Mindless

#19
August 12, 2014, 03:37:33 PM
A response will come when folk have time, I work for a living and this is my hobby therefore I only work on code when I get spare time, what your asking for is a lot of work and I would need to do the first one with a populated DB to verify all data, this is not an easy task to carry out. Set me up SSH, FTP, PHPMYADMIN, get the tables for export into a db that I can add u-232 tables into for the export, for me to provide a tutorial I'd be here all day, this job is one that relays on a very high level of expertise with MySQL.

skmdrony

#18
August 12, 2014, 02:47:59 PM
Waiting For responds  :(

Tundracanine

#17
August 11, 2014, 09:21:51 PM
ty, i guess this dont look as bad as the crap tsse was...
If wanting support help please put bare min info like
Os:
U-232 Version:
Php Version:
Tracker type: like xbt or php
Saves on asking more questions just so people can help someone.

livingoff

#16
August 11, 2014, 08:18:56 PM
Mindless i need this too.Please help us so that i can move to u-232 asap.I am sick and tired of the Errors at xbtit dtfm :(

skmdrony

#15
August 11, 2014, 08:08:17 PM Last Edit: August 11, 2014, 08:11:10 PM by skmdrony
Here Is My Current Database structure

Code Select
-- phpMyAdmin SQL Dump
-- version 4.1.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 12, 2014 at 01:02 AM
-- Server version: 5.5.35-0ubuntu0.12.04.2
-- PHP Version: 5.3.10-1ubuntu3.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
--

-- --------------------------------------------------------

--
-- Table structure for table `casino`
--

CREATE TABLE IF NOT EXISTS `casino` (
  `userid` int(10) NOT NULL DEFAULT '0',
  `win` bigint(20) DEFAULT NULL,
  `lost` bigint(20) DEFAULT NULL,
  `trys` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `enableplay` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
  `deposit` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `casino_bets`
--

CREATE TABLE IF NOT EXISTS `casino_bets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) NOT NULL DEFAULT '0',
  `proposed` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `challenged` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `amount` bigint(20) NOT NULL DEFAULT '0',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`,`proposed`,`challenged`,`amount`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_addedexpected`
--

CREATE TABLE IF NOT EXISTS `xbtit_addedexpected` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `expectid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_addedexpectedmin`
--

CREATE TABLE IF NOT EXISTS `xbtit_addedexpectedmin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `expectid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_addedrequests`
--

CREATE TABLE IF NOT EXISTS `xbtit_addedrequests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `requestid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=46 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_adminpanel`
--

CREATE TABLE IF NOT EXISTS `xbtit_adminpanel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) CHARACTER SET latin1 NOT NULL,
  `description` varchar(250) CHARACTER SET latin1 NOT NULL,
  `link` varchar(200) CHARACTER SET latin1 NOT NULL,
  `id_level` int(11) NOT NULL,
  `access` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_ajax_ratings`
--

CREATE TABLE IF NOT EXISTS `xbtit_ajax_ratings` (
  `id` varchar(40) CHARACTER SET latin1 NOT NULL,
  `total_votes` int(11) NOT NULL,
  `total_value` int(11) NOT NULL,
  `used_ips` longtext CHARACTER SET latin1
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_announcement`
--

CREATE TABLE IF NOT EXISTS `xbtit_announcement` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_anti_hit_run`
--

CREATE TABLE IF NOT EXISTS `xbtit_anti_hit_run` (
  `id_level` int(11) NOT NULL DEFAULT '0',
  `min_download_size` bigint(20) NOT NULL DEFAULT '0',
  `min_ratio` float NOT NULL DEFAULT '0',
  `min_seed_hours` int(11) NOT NULL DEFAULT '0',
  `tolerance_days_before_punishment` int(11) NOT NULL DEFAULT '0',
  `upload_punishment` int(11) NOT NULL DEFAULT '0',
  `reward` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `warn` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `boot` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `warnboot` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `days1` int(11) NOT NULL DEFAULT '2',
  `days2` int(11) NOT NULL DEFAULT '2',
  `days3` int(11) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id_level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_anti_hit_run_tasks`
--

CREATE TABLE IF NOT EXISTS `xbtit_anti_hit_run_tasks` (
  `task` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `last_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`last_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_avps`
--

CREATE TABLE IF NOT EXISTS `xbtit_avps` (
  `arg` varchar(32) CHARACTER SET latin1 NOT NULL,
  `value_s` varchar(32) CHARACTER SET latin1 NOT NULL,
  `value_i` varchar(32) CHARACTER SET latin1 NOT NULL,
  `value_u` varchar(32) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bannedclient`
--

CREATE TABLE IF NOT EXISTS `xbtit_bannedclient` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `peer_id` varchar(16) CHARACTER SET latin1 NOT NULL,
  `peer_id_ascii` varchar(8) CHARACTER SET latin1 NOT NULL,
  `user_agent` varchar(255) CHARACTER SET latin1 NOT NULL,
  `client_name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `reason` varchar(255) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`),
  KEY `peer_id` (`peer_id`),
  KEY `peer_id_ascii` (`peer_id_ascii`),
  KEY `user_agent` (`user_agent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bannedip`
--

CREATE TABLE IF NOT EXISTS `xbtit_bannedip` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` int(11) NOT NULL DEFAULT '0',
  `addedby` int(10) unsigned NOT NULL DEFAULT '0',
  `comment` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `first` bigint(11) unsigned DEFAULT NULL,
  `last` bigint(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=106 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_betgames`
--

CREATE TABLE IF NOT EXISTS `xbtit_betgames` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `undertext` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `endtime` int(11) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '0',
  `sort` int(1) NOT NULL DEFAULT '0',
  `creator` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `fix` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_betlog`
--

CREATE TABLE IF NOT EXISTS `xbtit_betlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL,
  `bonus` int(11) NOT NULL DEFAULT '0',
  `msg` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `userid_2` (`userid`,`bonus`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_betoptions`
--

CREATE TABLE IF NOT EXISTS `xbtit_betoptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gameid` int(11) NOT NULL DEFAULT '0',
  `text` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `odds` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `gameid` (`gameid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bets`
--

CREATE TABLE IF NOT EXISTS `xbtit_bets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gameid` int(11) NOT NULL DEFAULT '0',
  `bonus` int(11) NOT NULL DEFAULT '0',
  `optionid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `gameid` (`gameid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bettop`
--

CREATE TABLE IF NOT EXISTS `xbtit_bettop` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `bonus` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_blackjack`
--

CREATE TABLE IF NOT EXISTS `xbtit_blackjack` (
  `gameid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) NOT NULL,
  `dealerhand` varchar(100) CHARACTER SET latin1 NOT NULL,
  `playerhand` varchar(100) CHARACTER SET latin1 NOT NULL,
  `remaining_cards` text CHARACTER SET latin1 NOT NULL,
  `playerbust` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  PRIMARY KEY (`gameid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=52 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_blacklist`
--

CREATE TABLE IF NOT EXISTS `xbtit_blacklist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tip` int(11) unsigned DEFAULT NULL,
  `added` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=47 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_blocks`
--

CREATE TABLE IF NOT EXISTS `xbtit_blocks` (
  `blockid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `position` char(1) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `sortid` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `cache` enum('yes','no') CHARACTER SET latin1 NOT NULL,
  `minclassview` int(11) NOT NULL DEFAULT '0',
  `maxclassview` int(11) NOT NULL DEFAULT '8',
  PRIMARY KEY (`blockid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=325 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bonus`
--

CREATE TABLE IF NOT EXISTS `xbtit_bonus` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `points` decimal(4,1) NOT NULL DEFAULT '0.0',
  `traffic` bigint(20) unsigned NOT NULL DEFAULT '0',
  `gb` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bots`
--

CREATE TABLE IF NOT EXISTS `xbtit_bots` (
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `visit` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bt_clients`
--

CREATE TABLE IF NOT EXISTS `xbtit_bt_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `link` text CHARACTER SET latin1 NOT NULL,
  `sort` tinyint(10) NOT NULL DEFAULT '0',
  `image` varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_bugs`
--

CREATE TABLE IF NOT EXISTS `xbtit_bugs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sender` int(10) NOT NULL DEFAULT '0',
  `added` int(12) NOT NULL DEFAULT '0',
  `priority` enum('low','high','veryhigh') CHARACTER SET latin1 NOT NULL DEFAULT 'low',
  `problem` text CHARACTER SET latin1 NOT NULL,
  `status` enum('fixed','ignored','na') CHARACTER SET latin1 NOT NULL DEFAULT 'na',
  `staff` int(10) NOT NULL DEFAULT '0',
  `title` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_categories`
--

CREATE TABLE IF NOT EXISTS `xbtit_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `sub` int(10) NOT NULL DEFAULT '0',
  `sort_index` int(10) unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `forumid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=67 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_categories_perm`
--

CREATE TABLE IF NOT EXISTS `xbtit_categories_perm` (
  `catid` int(10) NOT NULL,
  `levelid` int(11) NOT NULL,
  `viewcat` enum('yes','no') NOT NULL,
  `viewtorrlist` enum('yes','no') NOT NULL,
  `viewtorrdet` enum('yes','no') NOT NULL,
  `downtorr` enum('yes','no') NOT NULL,
  `ratio` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_chat`
--

CREATE TABLE IF NOT EXISTS `xbtit_chat` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `uid` mediumint(9) NOT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  `private` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `toid` mediumint(9) NOT NULL,
  `fromid` mediumint(9) NOT NULL,
  `pchat` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=30324 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_chatfun`
--

CREATE TABLE IF NOT EXISTS `xbtit_chatfun` (
  `msgid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `message` text COLLATE utf8_unicode_ci,
  `userid` int(8) unsigned NOT NULL DEFAULT '0',
  `time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`msgid`),
  KEY `msgid` (`msgid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=42 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_cheapmail`
--

CREATE TABLE IF NOT EXISTS `xbtit_cheapmail` (
  `domain` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `added` int(10) NOT NULL DEFAULT '0',
  `added_by` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT 'Unknown',
  KEY `domain` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_coins`
--

CREATE TABLE IF NOT EXISTS `xbtit_coins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `info_hash` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `torrentid` int(10) unsigned NOT NULL DEFAULT '0',
  `points` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=523 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_comments`
--

CREATE TABLE IF NOT EXISTS `xbtit_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `ori_text` text COLLATE utf8_unicode_ci NOT NULL,
  `user` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `points` int(11) NOT NULL DEFAULT '0',
  `cid` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `info_hash` (`info_hash`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=393 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_countries`
--

CREATE TABLE IF NOT EXISTS `xbtit_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `flagpic` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `domain` char(3) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=245 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_donors`
--

CREATE TABLE IF NOT EXISTS `xbtit_donors` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(20) CHARACTER SET latin1 NOT NULL,
  `first_name` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `last_name` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `payers_email` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `mc_gross` decimal(5,2) NOT NULL,
  `date` datetime DEFAULT '0000-00-00 00:00:00',
  `country` varchar(255) CHARACTER SET latin1 NOT NULL,
  `item` varchar(20) CHARACTER SET latin1 NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_don_historie`
--

CREATE TABLE IF NOT EXISTS `xbtit_don_historie` (
  `don_id` int(11) NOT NULL DEFAULT '0',
  `donate_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation` int(11) NOT NULL,
  `donate_date_1` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_1` int(11) NOT NULL,
  `donate_date_2` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_2` int(11) NOT NULL,
  `donate_date_3` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_3` int(11) NOT NULL,
  `donate_date_4` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_4` int(11) NOT NULL,
  `donate_date_5` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_5` int(11) NOT NULL,
  `donate_date_6` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_6` int(11) NOT NULL,
  `donate_date_7` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_7` int(11) NOT NULL,
  `donate_date_8` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_8` int(11) NOT NULL,
  `donate_date_9` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_9` int(11) NOT NULL,
  `donate_date_10` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `don_ation_10` int(11) NOT NULL,
  PRIMARY KEY (`don_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_downloads`
--

CREATE TABLE IF NOT EXISTS `xbtit_downloads` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `info_hash` varchar(40) CHARACTER SET latin1 NOT NULL,
  `date` datetime NOT NULL,
  `updown` varchar(10) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55848 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_down_load`
--

CREATE TABLE IF NOT EXISTS `xbtit_down_load` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `hash` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55988 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_expected`
--

CREATE TABLE IF NOT EXISTS `xbtit_expected` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `expect` varchar(225) CHARACTER SET latin1 DEFAULT NULL,
  `descr` text CHARACTER SET latin1 NOT NULL,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `cat` int(10) unsigned NOT NULL DEFAULT '0',
  `torrenturl` varchar(255) CHARACTER SET latin1 NOT NULL,
  `uploaded` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `expect_offer` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `hitsmin` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_faq`
--

CREATE TABLE IF NOT EXISTS `xbtit_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL,
  `description` text CHARACTER SET latin1 NOT NULL,
  `cat_id` int(11) NOT NULL,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_faq_group`
--

CREATE TABLE IF NOT EXISTS `xbtit_faq_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL,
  `description` text CHARACTER SET latin1 NOT NULL,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `sort_index` int(11) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_featured`
--

CREATE TABLE IF NOT EXISTS `xbtit_featured` (
  `fid` int(5) NOT NULL AUTO_INCREMENT,
  `torrent_id` varchar(40) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=618 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_files`
--

CREATE TABLE IF NOT EXISTS `xbtit_files` (
  `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filename` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `info` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `data` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `size` bigint(20) NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  `category` int(10) unsigned NOT NULL DEFAULT '6',
  `external` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `announce_url` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `uploader` int(10) NOT NULL DEFAULT '1',
  `lastupdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `anonymous` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `lastsuccess` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dlbytes` bigint(20) unsigned NOT NULL DEFAULT '0',
  `seeds` int(10) unsigned NOT NULL DEFAULT '0',
  `leechers` int(10) unsigned NOT NULL DEFAULT '0',
  `finished` int(10) unsigned NOT NULL DEFAULT '0',
  `lastcycle` int(10) unsigned NOT NULL DEFAULT '0',
  `lastSpeedCycle` int(10) unsigned NOT NULL DEFAULT '0',
  `speed` bigint(20) unsigned NOT NULL DEFAULT '0',
  `bin_hash` blob NOT NULL,
  `sticky` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `vip_torrent` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `free_expire_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `free` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `screen1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `screen2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `screen3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `reseed` int(9) NOT NULL DEFAULT '0',
  `lock_comment` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `gold` enum('0','1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `happy` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `happy_hour` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `points` int(10) NOT NULL DEFAULT '0',
  `moder` enum('um','bad','ok') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'um',
  `staff_comment` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `topicid` int(10) DEFAULT NULL,
  `announces` text COLLATE utf8_unicode_ci NOT NULL,
  `imdb` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `multiplier` enum('1','2','3','4','5','6','7','8','9','10') CHARACTER SET latin1 DEFAULT '1',
  `youtube_video` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seedbox` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `tag` text COLLATE utf8_unicode_ci NOT NULL,
  `language` int(9) NOT NULL DEFAULT '0',
  `team` varchar(10) COLLATE utf8_unicode_ci DEFAULT '0',
  `dead_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`info_hash`),
  KEY `filename` (`filename`),
  KEY `category` (`category`),
  KEY `uploader` (`uploader`),
  KEY `bin_hash` (`bin_hash`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_files_thanks`
--

CREATE TABLE IF NOT EXISTS `xbtit_files_thanks` (
  `infohash` char(40) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  KEY `infohash` (`infohash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_flashscores`
--

CREATE TABLE IF NOT EXISTS `xbtit_flashscores` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `game` int(11) NOT NULL DEFAULT '0',
  `user` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `score` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1328 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_forums`
--

CREATE TABLE IF NOT EXISTS `xbtit_forums` (
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `minclassread` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `minclasswrite` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `postcount` int(10) unsigned NOT NULL DEFAULT '0',
  `topiccount` int(10) unsigned NOT NULL DEFAULT '0',
  `minclasscreate` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `id_parent` int(10) NOT NULL DEFAULT '0',
  `category` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`),
  KEY `id_parent` (`id_parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_free_leech_req`
--

CREATE TABLE IF NOT EXISTS `xbtit_free_leech_req` (
  `info_hash` varchar(40) CHARACTER SET latin1 NOT NULL,
  `count` int(10) NOT NULL DEFAULT '1',
  `approved` enum('yes','no','undecided') CHARACTER SET latin1 NOT NULL DEFAULT 'undecided',
  `requester_ids` text CHARACTER SET latin1 NOT NULL,
  UNIQUE KEY `info_hash` (`info_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_friendlist`
--

CREATE TABLE IF NOT EXISTS `xbtit_friendlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `friend_id` int(10) unsigned NOT NULL DEFAULT '0',
  `friend_name` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `friend_date` varchar(20) CHARACTER SET latin1 NOT NULL,
  `confirmed` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `rejected` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `username` varchar(30) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=66 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_gold`
--

CREATE TABLE IF NOT EXISTS `xbtit_gold` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL DEFAULT '4',
  `gold_picture` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'gold.gif',
  `silver_picture` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'silver.gif',
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `gold_description` text CHARACTER SET latin1 NOT NULL,
  `silver_description` text CHARACTER SET latin1 NOT NULL,
  `classic_description` text CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_hacks`
--

CREATE TABLE IF NOT EXISTS `xbtit_hacks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) CHARACTER SET latin1 NOT NULL,
  `version` varchar(10) CHARACTER SET latin1 NOT NULL,
  `author` varchar(100) CHARACTER SET latin1 NOT NULL,
  `added` int(11) NOT NULL,
  `folder` varchar(100) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_helpdesk`
--

CREATE TABLE IF NOT EXISTS `xbtit_helpdesk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msg_problem` text COLLATE utf8_unicode_ci,
  `added` int(11) NOT NULL DEFAULT '0',
  `solved_date` int(11) NOT NULL DEFAULT '0',
  `solved` enum('no','yes','ignored') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `added_by` int(10) NOT NULL DEFAULT '0',
  `solved_by` int(10) NOT NULL DEFAULT '0',
  `msg_answer` text COLLATE utf8_unicode_ci,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_history`
--

CREATE TABLE IF NOT EXISTS `xbtit_history` (
  `uid` int(10) DEFAULT NULL,
  `infohash` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `date` int(10) DEFAULT NULL,
  `uploaded` bigint(20) NOT NULL DEFAULT '0',
  `downloaded` bigint(20) NOT NULL DEFAULT '0',
  `active` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `agent` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `completed` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `hit` enum('no','yes') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `hitchecked` int(11) NOT NULL DEFAULT '0',
  `punishment_amount` int(11) NOT NULL DEFAULT '0',
  `seed` bigint(99) NOT NULL DEFAULT '0',
  UNIQUE KEY `uid` (`uid`,`infohash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_ignore`
--

CREATE TABLE IF NOT EXISTS `xbtit_ignore` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `ignore_id` int(10) unsigned NOT NULL DEFAULT '0',
  `ignore_name` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_invalid_logins`
--

CREATE TABLE IF NOT EXISTS `xbtit_invalid_logins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` bigint(11) DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `failed` int(3) unsigned NOT NULL DEFAULT '0',
  `remaining` int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3054 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_invitations`
--

CREATE TABLE IF NOT EXISTS `xbtit_invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `inviter` int(10) unsigned NOT NULL DEFAULT '0',
  `invitee` varchar(80) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `hash` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `time_invited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `confirmed` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  KEY `inviter` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_iplog`
--

CREATE TABLE IF NOT EXISTS `xbtit_iplog` (
  `ipid` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `uid` varchar(5) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `uipid` char(1) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`ipid`),
  UNIQUE KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17985 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_khez_configs`
--

CREATE TABLE IF NOT EXISTS `xbtit_khez_configs` (
  `key` varchar(30) NOT NULL,
  `value` varchar(200) NOT NULL,
  UNIQUE KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_language`
--

CREATE TABLE IF NOT EXISTS `xbtit_language` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `language` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `language_url` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_logs`
--

CREATE TABLE IF NOT EXISTS `xbtit_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` int(10) DEFAULT NULL,
  `txt` text CHARACTER SET latin1,
  `type` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'add',
  `user` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=147225 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_lottery_config`
--

CREATE TABLE IF NOT EXISTS `xbtit_lottery_config` (
  `id` int(11) NOT NULL DEFAULT '0',
  `lot_expire_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lot_number_winners` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `lot_number_to_win` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `lot_amount` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `lot_status` enum('yes','no','closed') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `limit_buy` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `sender_id` char(8) CHARACTER SET latin1 NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_lottery_tickets`
--

CREATE TABLE IF NOT EXISTS `xbtit_lottery_tickets` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_lottery_winners`
--

CREATE TABLE IF NOT EXISTS `xbtit_lottery_winners` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `win_user` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `windate` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `price` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_low_ratio_ban`
--

CREATE TABLE IF NOT EXISTS `xbtit_low_ratio_ban` (
  `wb_down` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_rank` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_warn` enum('true','false') CHARACTER SET latin1 NOT NULL,
  `wb_one` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_days_one` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_two` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_days_two` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_three` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_days_fin` varchar(10) CHARACTER SET latin1 NOT NULL,
  `wb_fin` varchar(10) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_low_ratio_ban_settings`
--

CREATE TABLE IF NOT EXISTS `xbtit_low_ratio_ban_settings` (
  `id` varchar(4) CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `wb_sys` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'false',
  `wb_text_one` varchar(255) CHARACTER SET latin1 NOT NULL,
  `wb_text_two` varchar(255) CHARACTER SET latin1 NOT NULL,
  `wb_text_fin` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_messages`
--

CREATE TABLE IF NOT EXISTS `xbtit_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender` int(10) unsigned NOT NULL DEFAULT '0',
  `receiver` int(10) unsigned NOT NULL DEFAULT '0',
  `added` int(10) DEFAULT NULL,
  `subject` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msg` text COLLATE utf8_unicode_ci,
  `readed` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `deletedBySender` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `receiver` (`receiver`),
  KEY `sender` (`sender`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=73841 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_moderate_reasons`
--

CREATE TABLE IF NOT EXISTS `xbtit_moderate_reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `description` text CHARACTER SET latin1 NOT NULL,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `ordering` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_modules`
--

CREATE TABLE IF NOT EXISTS `xbtit_modules` (
  `id` mediumint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `activated` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `type` enum('staff','misc','torrent','style') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'misc',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_mostonline`
--

CREATE TABLE IF NOT EXISTS `xbtit_mostonline` (
  `amount` int(4) NOT NULL DEFAULT '1',
  `date` datetime NOT NULL DEFAULT '2008-11-24 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_news`
--

CREATE TABLE IF NOT EXISTS `xbtit_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news` blob NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_notes`
--

CREATE TABLE IF NOT EXISTS `xbtit_notes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userid` int(10) NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_offer_comments`
--

CREATE TABLE IF NOT EXISTS `xbtit_offer_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `ori_text` text COLLATE utf8_unicode_ci NOT NULL,
  `user` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `offer_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `offer_id` (`offer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_online`
--

CREATE TABLE IF NOT EXISTS `xbtit_online` (
  `session_id` varchar(40) CHARACTER SET latin1 NOT NULL,
  `user_id` int(10) NOT NULL,
  `user_ip` varchar(15) CHARACTER SET latin1 NOT NULL,
  `location` varchar(20) CHARACTER SET latin1 NOT NULL,
  `lastaction` int(10) NOT NULL,
  `user_name` varchar(40) CHARACTER SET latin1 NOT NULL,
  `user_group` varchar(50) CHARACTER SET latin1 NOT NULL,
  `prefixcolor` varchar(200) CHARACTER SET latin1 NOT NULL,
  `suffixcolor` varchar(200) CHARACTER SET latin1 NOT NULL,
  `picture` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `donor` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `warn` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `immunity` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `invisible` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `booted` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `dona` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `donb` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `birt` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `mal` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `fem` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `bann` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `war` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `par` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `bot` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `trmu` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `trmo` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `vimu` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `vimo` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `friend` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `junkie` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `staff` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `sysop` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  PRIMARY KEY (`session_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_partner`
--

CREATE TABLE IF NOT EXISTS `xbtit_partner` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `addedby` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_paypal_settings`
--

CREATE TABLE IF NOT EXISTS `xbtit_paypal_settings` (
  `id` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `test` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `paypal_email` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `sandbox_email` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `vip_days` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `vip_rank` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `needed` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `due_date` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `num_block` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `received` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `donation_block` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `scrol_tekst` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `units` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `historie` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `don_star` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `gb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `smf` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `IPN` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `identity_token` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `ppinvon` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `ppinv` varchar(60) CHARACTER SET latin1 NOT NULL,
  `vip_daysb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `vip_daysc` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `gbb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `gbc` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `togb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `togbb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `togbc` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `today` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `todayb` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `todayc` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_peers`
--

CREATE TABLE IF NOT EXISTS `xbtit_peers` (
  `infohash` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `peer_id` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `bytes` bigint(20) NOT NULL DEFAULT '0',
  `ip` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'error.x',
  `port` smallint(5) unsigned NOT NULL DEFAULT '0',
  `status` enum('leecher','seeder') CHARACTER SET latin1 NOT NULL DEFAULT 'leecher',
  `lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
  `sequence` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `natuser` enum('N','Y') CHARACTER SET latin1 NOT NULL DEFAULT 'N',
  `client` varchar(60) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `dns` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  `pid` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `with_peerid` varchar(101) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `without_peerid` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `compact` varchar(6) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `announce_interval` int(10) NOT NULL,
  `upload_difference` bigint(20) NOT NULL,
  `download_difference` bigint(20) NOT NULL,
  PRIMARY KEY (`infohash`,`peer_id`),
  UNIQUE KEY `sequence` (`sequence`),
  KEY `pid` (`pid`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=896905 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_poller`
--

CREATE TABLE IF NOT EXISTS `xbtit_poller` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `startDate` int(10) NOT NULL DEFAULT '0',
  `endDate` int(10) NOT NULL DEFAULT '0',
  `pollerTitle` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `starterID` mediumint(8) NOT NULL DEFAULT '0',
  `active` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_poller_option`
--

CREATE TABLE IF NOT EXISTS `xbtit_poller_option` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `pollerID` int(11) DEFAULT NULL,
  `optionText` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `pollerOrder` int(11) DEFAULT NULL,
  `defaultChecked` char(1) CHARACTER SET latin1 DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_poller_vote`
--

CREATE TABLE IF NOT EXISTS `xbtit_poller_vote` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `pollerID` int(11) NOT NULL DEFAULT '0',
  `optionID` int(11) DEFAULT NULL,
  `ipAddress` bigint(11) DEFAULT '0',
  `voteDate` int(10) NOT NULL DEFAULT '0',
  `memberID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=193 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_polls`
--

CREATE TABLE IF NOT EXISTS `xbtit_polls` (
  `pid` mediumint(8) NOT NULL AUTO_INCREMENT,
  `startdate` int(10) DEFAULT NULL,
  `choices` text CHARACTER SET latin1,
  `starter_id` mediumint(8) NOT NULL DEFAULT '0',
  `votes` smallint(5) NOT NULL DEFAULT '0',
  `poll_question` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `status` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'false',
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_poll_voters`
--

CREATE TABLE IF NOT EXISTS `xbtit_poll_voters` (
  `vid` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `votedate` int(10) NOT NULL DEFAULT '0',
  `pid` mediumint(8) NOT NULL DEFAULT '0',
  `memberid` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`vid`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_posts`
--

CREATE TABLE IF NOT EXISTS `xbtit_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topicid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `added` int(10) DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `editedby` int(10) unsigned NOT NULL DEFAULT '0',
  `editedat` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `topicid` (`topicid`),
  KEY `userid` (`userid`),
  FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=439 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_ratings`
--

CREATE TABLE IF NOT EXISTS `xbtit_ratings` (
  `infohash` char(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `userid` int(10) unsigned NOT NULL DEFAULT '1',
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `added` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `infohash` (`infohash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_readposts`
--

CREATE TABLE IF NOT EXISTS `xbtit_readposts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `topicid` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpostread` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `topicid` (`topicid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1098 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_recommended`
--

CREATE TABLE IF NOT EXISTS `xbtit_recommended` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `info_hash` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `user_name` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT 'anonymous',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=39 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_reports`
--

CREATE TABLE IF NOT EXISTS `xbtit_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `addedby` int(10) unsigned NOT NULL DEFAULT '0',
  `votedfor` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `type` enum('torrent','user') CHARACTER SET latin1 NOT NULL DEFAULT 'torrent',
  `reason` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `dealtby` int(10) unsigned NOT NULL DEFAULT '0',
  `dealtwith` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=33 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_reputation`
--

CREATE TABLE IF NOT EXISTS `xbtit_reputation` (
  `reputationid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `whoadded` int(10) NOT NULL DEFAULT '0',
  `dateadd` int(10) NOT NULL DEFAULT '0',
  `userid` mediumint(8) NOT NULL DEFAULT '0',
  `updown` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`reputationid`),
  KEY `userid` (`userid`),
  KEY `whoadded` (`whoadded`),
  KEY `multi` (`userid`),
  KEY `dateadd` (`dateadd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=72 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_reputation_settings`
--

CREATE TABLE IF NOT EXISTS `xbtit_reputation_settings` (
  `id` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `rep_is_online` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `rep_adminpower` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_minpost` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_default` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_userrates` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_rdpower` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_pcpower` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_kppower` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_minrep` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_hit` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_maxperday` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_repeat` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rep_undefined` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `best_level` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Best Level',
  `good_level` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Good Level',
  `no_level` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No Level',
  `bad_level` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bad Level',
  `worse_level` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Worse Level',
  `rep_upload` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `rep_en_sys` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `rep_pr_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '20',
  `rep_dm_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '20',
  `rep_pr` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1000',
  `rep_dm` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-1000',
  `rep_pm_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'tekst',
  `rep_dm_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'tekst'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_requests`
--

CREATE TABLE IF NOT EXISTS `xbtit_requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `request` varchar(225) CHARACTER SET latin1 DEFAULT NULL,
  `descr` text CHARACTER SET latin1 NOT NULL,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fulfilled` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `cat` int(10) unsigned NOT NULL DEFAULT '0',
  `filled` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `filledby` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_retracker`
--

CREATE TABLE IF NOT EXISTS `xbtit_retracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_from` bigint(11) NOT NULL,
  `ip_to` bigint(11) NOT NULL,
  `retracker` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_rules`
--

CREATE TABLE IF NOT EXISTS `xbtit_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 NOT NULL,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `sort_index` int(11) NOT NULL DEFAULT '0',
  `cat_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_rules_group`
--

CREATE TABLE IF NOT EXISTS `xbtit_rules_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `title` varchar(255) CHARACTER SET latin1 NOT NULL,
  `sort_index` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_sb`
--

CREATE TABLE IF NOT EXISTS `xbtit_sb` (
  `id` int(5) NOT NULL,
  `what` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `gb` varchar(20) CHARACTER SET latin1 NOT NULL,
  `points` int(20) NOT NULL,
  `date` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_searchcloud`
--

CREATE TABLE IF NOT EXISTS `xbtit_searchcloud` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `searchedfor` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `howmuch` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=138 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_settings`
--

CREATE TABLE IF NOT EXISTS `xbtit_settings` (
  `key` varchar(30) CHARACTER SET latin1 NOT NULL,
  `value` varchar(200) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_shitlist`
--

CREATE TABLE IF NOT EXISTS `xbtit_shitlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `shit_id` int(10) unsigned NOT NULL DEFAULT '0',
  `shit_name` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_signup_ip_block`
--

CREATE TABLE IF NOT EXISTS `xbtit_signup_ip_block` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `first_ip` double NOT NULL DEFAULT '0',
  `last_ip` double NOT NULL DEFAULT '0',
  `added` int(10) unsigned NOT NULL DEFAULT '0',
  `addedby` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `comment` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_statistiques`
--

CREATE TABLE IF NOT EXISTS `xbtit_statistiques` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `page` varchar(250) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `host` varchar(60) NOT NULL DEFAULT '',
  `navigateur` varchar(100) NOT NULL DEFAULT '',
  `referer` varchar(250) NOT NULL DEFAULT '',
  `id_level` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=331061 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_stats_setting`
--

CREATE TABLE IF NOT EXISTS `xbtit_stats_setting` (
  `id` int(1) NOT NULL,
  `active` enum('true','false') NOT NULL DEFAULT 'false',
  `act_referer` enum('true','false') NOT NULL,
  `act_browsers` enum('true','false') NOT NULL,
  `act_page` enum('true','false') NOT NULL,
  `act_host` enum('true','false') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_sticky`
--

CREATE TABLE IF NOT EXISTS `xbtit_sticky` (
  `id` int(11) NOT NULL,
  `color` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '#bce1ac;',
  `level` int(11) NOT NULL DEFAULT '3',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_style`
--

CREATE TABLE IF NOT EXISTS `xbtit_style` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `style` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `style_url` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `style_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=60 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_subtitles`
--

CREATE TABLE IF NOT EXISTS `xbtit_subtitles` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(99) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `file` varchar(99) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `imdb` varchar(200) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `pic` varchar(200) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `Framerate` varchar(99) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `cds` int(9) NOT NULL DEFAULT '0',
  `uploader` int(9) NOT NULL DEFAULT '0',
  `downloaded` int(9) NOT NULL DEFAULT '0',
  `author` varchar(99) CHARACTER SET latin1 DEFAULT NULL,
  `hash` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_tasks`
--

CREATE TABLE IF NOT EXISTS `xbtit_tasks` (
  `task` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `last_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`task`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_teams`
--

CREATE TABLE IF NOT EXISTS `xbtit_teams` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `owner` int(10) NOT NULL DEFAULT '0',
  `info` text CHARACTER SET latin1,
  `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `image` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_timestamps`
--

CREATE TABLE IF NOT EXISTS `xbtit_timestamps` (
  `info_hash` char(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `sequence` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bytes` bigint(20) unsigned NOT NULL DEFAULT '0',
  `delta` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sequence`),
  KEY `sorting` (`info_hash`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15988107 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_timezone`
--

CREATE TABLE IF NOT EXISTS `xbtit_timezone` (
  `difference` varchar(4) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `timezone` text CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`difference`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_topics`
--

CREATE TABLE IF NOT EXISTS `xbtit_topics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locked` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `forumid` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `subject` (`subject`),
  KEY `lastpost` (`lastpost`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=73 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_t_rank`
--

CREATE TABLE IF NOT EXISTS `xbtit_t_rank` (
  `userid` int(11) NOT NULL,
  `old_rank` int(11) NOT NULL,
  `new_rank` int(11) NOT NULL,
  `byt` int(11) NOT NULL,
  `date` varchar(20) CHARACTER SET latin1 NOT NULL,
  `undone` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `enddate` varchar(20) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_userbars`
--

CREATE TABLE IF NOT EXISTS `xbtit_userbars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(50) CHARACTER SET latin1 NOT NULL,
  `img` varchar(64) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_username`
--

CREATE TABLE IF NOT EXISTS `xbtit_username` (
  `uid` int(10) NOT NULL,
  `username` varchar(30) NOT NULL,
  `org` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_users`
--

CREATE TABLE IF NOT EXISTS `xbtit_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `password` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `salt` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `pass_type` enum('1','2','3','4','5','6','7') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `dupe_hash` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `id_level` int(10) NOT NULL DEFAULT '1',
  `random` int(10) DEFAULT '0',
  `email` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `language` tinyint(4) NOT NULL DEFAULT '1',
  `style` tinyint(4) NOT NULL DEFAULT '1',
  `joined` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastconnect` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lip` bigint(11) DEFAULT '0',
  `downloaded` bigint(20) DEFAULT '0',
  `uploaded` bigint(20) DEFAULT '0',
  `avatar` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `avatar_upload` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `avatar_upload_name` varchar(60) CHARACTER SET latin1 NOT NULL,
  `pid` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `topicsperpage` tinyint(3) unsigned NOT NULL DEFAULT '15',
  `postsperpage` tinyint(3) unsigned NOT NULL DEFAULT '15',
  `torrentsperpage` tinyint(3) unsigned NOT NULL DEFAULT '60',
  `profileview` int(9) NOT NULL DEFAULT '0',
  `cip` varchar(15) CHARACTER SET latin1 DEFAULT NULL,
  `time_offset` varchar(4) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `temp_email` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `smf_fid` int(10) NOT NULL DEFAULT '0',
  `ipb_fid` int(10) NOT NULL DEFAULT '0',
  `seedbonus` decimal(12,6) NOT NULL DEFAULT '0.000000',
  `tot_on` int(10) NOT NULL DEFAULT '0',
  `rank_switch` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `old_rank` varchar(12) CHARACTER SET latin1 NOT NULL DEFAULT '3',
  `timed_rank` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `donor` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `up_med` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `connectable` enum('yes','no','unknown') CHARACTER SET latin1 NOT NULL DEFAULT 'unknown',
  `custom_title` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `sb` decimal(12,6) NOT NULL DEFAULT '0.000000',
  `whereheard` varchar(255) CHARACTER SET latin1 NOT NULL,
  `rat_warn_level` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `rat_warn_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bandt` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `warn` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `warnreason` varchar(255) CHARACTER SET latin1 NOT NULL,
  `warnadded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `warns` bigint(20) DEFAULT '0',
  `warnaddedby` varchar(255) CHARACTER SET latin1 NOT NULL,
  `dob` date NOT NULL,
  `birthday_bonus` tinyint(1) NOT NULL DEFAULT '0',
  `immunity` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `invitations` int(10) NOT NULL DEFAULT '0',
  `invited_by` int(10) NOT NULL DEFAULT '0',
  `invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reputation` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `block_comment` enum('yes','no') CHARACTER SET latin1 DEFAULT 'no',
  `showporn` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `clientinfo` text CHARACTER SET latin1 NOT NULL,
  `modcomment` text CHARACTER SET latin1 NOT NULL,
  `supcomment` text CHARACTER SET latin1 NOT NULL,
  `blackjack_stats` text CHARACTER SET latin1 NOT NULL,
  `invisible` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `browser` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'unknown',
  `userbar` int(11) NOT NULL DEFAULT '1',
  `usercounter` bigint(20) DEFAULT '0',
  `ban` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `ban_added` varchar(50) CHARACTER SET latin1 NOT NULL,
  `ban_added_by` varchar(50) CHARACTER SET latin1 NOT NULL,
  `ban_comment` varchar(255) CHARACTER SET latin1 NOT NULL,
  `allowdownload` enum('yes','no') CHARACTER SET latin1 DEFAULT 'yes',
  `allowupload` enum('yes','no') CHARACTER SET latin1 DEFAULT 'yes',
  `proxy` enum('yes','no') CHARACTER SET latin1 DEFAULT 'no',
  `announce` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `booted` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `whybooted` varchar(255) CHARACTER SET latin1 NOT NULL,
  `addbooted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `whobooted` varchar(255) CHARACTER SET latin1 NOT NULL,
  `left_l` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `emailnot` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `subscription` text CHARACTER SET latin1,
  `dona` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `donb` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `birt` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `mal` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `fem` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `bann` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `war` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `par` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `bot` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `trmu` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `trmo` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `vimu` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `vimo` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `friend` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `junkie` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `staff` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `sysop` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `parked` int(9) NOT NULL DEFAULT '0',
  `gotgift` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `referral` varchar(40) CHARACTER SET latin1 NOT NULL,
  `sbox` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `signature` text CHARACTER SET latin1 NOT NULL,
  `gender` int(9) NOT NULL DEFAULT '2',
  `tor` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'last',
  `pchat` varchar(40) CHARACTER SET latin1 NOT NULL,
  `forumbanned` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `commentpm` enum('true','false') CHARACTER SET latin1 NOT NULL DEFAULT 'true',
  `trophy` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `team` int(10) unsigned NOT NULL DEFAULT '0',
  `on_topic` int(11) NOT NULL DEFAULT '0',
  `on_forum` int(11) NOT NULL DEFAULT '0',
  `helpdesk` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
  `helped` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `helplang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `id_level` (`id_level`),
  KEY `pid` (`pid`),
  KEY `cip` (`cip`),
  KEY `smf_fid` (`smf_fid`),
  KEY `ipb_fid` (`ipb_fid`),
  KEY `avatar_upload` (`avatar_upload`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4597 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_users_level`
--

CREATE TABLE IF NOT EXISTS `xbtit_users_level` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `id_level` int(11) NOT NULL DEFAULT '0',
  `level` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `view_torrents` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `edit_torrents` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `delete_torrents` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `view_users` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `edit_users` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `delete_users` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `view_news` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `edit_news` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `delete_news` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `can_upload` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `can_download` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `view_forum` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `edit_forum` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `delete_forum` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `predef_level` enum('guest','validating','member','uploader','vip','moderator','admin','owner') CHARACTER SET latin1 NOT NULL DEFAULT 'guest',
  `can_be_deleted` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `admin_access` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `prefixcolor` varchar(200) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `suffixcolor` varchar(200) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `WT` int(11) NOT NULL DEFAULT '0',
  `smf_group_mirror` int(11) NOT NULL DEFAULT '0',
  `ipb_group_mirror` int(11) NOT NULL DEFAULT '0',
  `picture` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `maxtorrents` int(3) NOT NULL DEFAULT '0',
  `delete_comments` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `edit_comments` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `view_comments` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `delete_shout` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `edit_shout` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `view_shout` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  `auto_prune` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `sfdownload` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `trusted` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `moderate_trusted` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `autorank_state` enum('Enabled','Disabled') CHARACTER SET latin1 NOT NULL DEFAULT 'Disabled',
  `autorank_position` smallint(3) NOT NULL DEFAULT '0',
  `autorank_min_upload` bigint(20) NOT NULL DEFAULT '0',
  `autorank_minratio` decimal(5,2) NOT NULL DEFAULT '0.00',
  `autorank_smf_group_mirror` int(10) NOT NULL DEFAULT '0',
  `show_ad` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `fstyle` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `speers` enum('yes','no') CHARACTER SET latin1 NOT NULL DEFAULT 'yes',
  UNIQUE KEY `base` (`id`),
  KEY `id_level` (`id_level`),
  KEY `smf_group_mirror` (`smf_group_mirror`),
  KEY `ipb_group_mirror` (`ipb_group_mirror`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_videos`
--

CREATE TABLE IF NOT EXISTS `xbtit_videos` (
  `title` text CHARACTER SET latin1,
  `category` text CHARACTER SET latin1,
  `id` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
  `number` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`number`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=53 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_warn_reasons`
--

CREATE TABLE IF NOT EXISTS `xbtit_warn_reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` enum('-1','0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `title` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `text` text CHARACTER SET latin1 NOT NULL,
  `level` int(11) NOT NULL DEFAULT '12',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbtit_wishlist`
--

CREATE TABLE IF NOT EXISTS `xbtit_wishlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `torrent_id` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `torrent_name` varchar(250) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=520 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_announce_log`
--

CREATE TABLE IF NOT EXISTS `xbt_announce_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipa` int(10) unsigned NOT NULL,
  `port` int(11) NOT NULL,
  `event` int(11) NOT NULL,
  `info_hash` binary(20) NOT NULL,
  `peer_id` binary(20) NOT NULL,
  `downloaded` bigint(20) unsigned NOT NULL,
  `left0` bigint(20) unsigned NOT NULL,
  `uploaded` bigint(20) unsigned NOT NULL,
  `uid` int(11) NOT NULL,
  `mtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_config`
--

CREATE TABLE IF NOT EXISTS `xbt_config` (
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `value` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_deny_from_clients`
--

CREATE TABLE IF NOT EXISTS `xbt_deny_from_clients` (
  `peer_id` char(20) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_deny_from_hosts`
--

CREATE TABLE IF NOT EXISTS `xbt_deny_from_hosts` (
  `begin` int(10) unsigned NOT NULL,
  `end` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_files`
--

CREATE TABLE IF NOT EXISTS `xbt_files` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `info_hash` binary(20) NOT NULL,
  `down_multi` int(11) NOT NULL DEFAULT '100',
  `up_multi` int(11) NOT NULL DEFAULT '100',
  `leechers` int(11) NOT NULL DEFAULT '0',
  `seeders` int(11) NOT NULL DEFAULT '0',
  `completed` int(11) NOT NULL DEFAULT '0',
  `flags` int(11) NOT NULL DEFAULT '0',
  `mtime` int(11) NOT NULL,
  `ctime` int(11) NOT NULL,
  PRIMARY KEY (`fid`),
  UNIQUE KEY `info_hash` (`info_hash`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=276 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_files_users`
--

CREATE TABLE IF NOT EXISTS `xbt_files_users` (
  `fid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `announced` int(11) NOT NULL,
  `completed` int(11) NOT NULL,
  `downloaded` bigint(20) unsigned NOT NULL,
  `left` bigint(20) unsigned NOT NULL,
  `uploaded` bigint(20) unsigned NOT NULL,
  `down_rate` int(11) NOT NULL,
  `up_rate` int(11) NOT NULL,
  `peer_id` binary(8) NOT NULL,
  `completed_time` int(11) NOT NULL,
  `mtime` int(11) NOT NULL,
  UNIQUE KEY `fid` (`fid`,`uid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_scrape_log`
--

CREATE TABLE IF NOT EXISTS `xbt_scrape_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipa` int(10) unsigned NOT NULL,
  `info_hash` binary(20) DEFAULT NULL,
  `uid` int(11) NOT NULL,
  `mtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xbt_users`
--

CREATE TABLE IF NOT EXISTS `xbt_users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `can_announce` tinyint(4) NOT NULL DEFAULT '1',
  `torrent_pass_version` int(11) NOT NULL DEFAULT '0',
  `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  `torrent_pass` char(32) COLLATE utf8_unicode_ci NOT NULL,
  `torrent_pass_secret` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=391 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Mindless

#14
August 11, 2014, 07:36:02 PM
Post what i asked for then, I Need to see every table for export, cant build query's to export data without knowing source database table structures. Just export simple from phpmyadmin, structure no data

skmdrony

#13
August 11, 2014, 06:46:04 PM
Mindless Bro Can Give Me A tutorial Only User ,Torrent And Forum Topic i Need To Move U232 I Follow This Tutorial https://u-232-forum.duckdns.org/index.php?topic=2525.msg12451.html#msg12451 I Do What He Doing But I get Some Mysql Error i Think Its Not Full Tutorial Can You Give Me A Best Tutorial Not only Me @livingoff This User Can Also Move His Site To U232 And As I See In u232 Some User Also Move DTFM to u232 But Failed to Do That Resons Only Not Have Tutorial Or Guide line If is Possible Pls Only User,Torrent And Forum This 3 thing Moved Tutorialto provide Us

i And We Still Belive That U232 Is Much Batter Torrent Tracker System In The World And 10000 time Batter XBTIT DT FM

Mindless

#12
August 11, 2014, 06:19:30 PM
Fair few tables, obviously would be looking at comments, files, forums, topics, posts, torrents, users, xbt_files_users few others but just the essential to allow an export into u-232, again would need each table structure visible to give a proper accurate response but judging from what I can see its pretty much the same shit but different pile in terms of tables, fieldnames within and type are the only things that will cause trouble;

skmdrony

#11
August 11, 2014, 06:01:14 PM Last Edit: August 11, 2014, 06:57:06 PM by skmdrony
Here is It

[attachment deleted by admin]

Mindless

#10
August 11, 2014, 05:56:17 PM
I want to see the databse structures, the fields in each table, an empty db will allow me to quickly assess the differences

skmdrony

#9
August 11, 2014, 05:55:17 PM
Which Screenshot In My Current Site User Database Screenshot??

Mindless

#8
August 11, 2014, 05:34:11 PM
Quote from: skmdrony on August 11, 2014, 02:39:18 PM
Is There any way to Do This...
Bcoz My Site Have 4500+ Users But Maximum User provide fake Email So If I Do This They Cant recover Their Password Bcoz they Provide Fake Mail

See thats what happens when folk use fake addys, i get thousands of failed emails a day because assholes do the same here. you have one option, that is get everyone active to set an active email address in their profile before the export is done, then use recover.php, there is no other way

Mindless

#7
August 11, 2014, 05:31:16 PM
Nobody needs to lose data or start over, I've exported most flavours out there into Tbdev/u-232 at some point. What you need is someone with a very high skill level with MySql. But i have not seen your codes database structure so cant say for fact, maybe post me a screen shot and let me see how it differs ?

skmdrony

#6
August 11, 2014, 02:40:24 PM
I Belive U232 Much Much Much Batter Then XBTIT DT FM Thats Why Its Very Important To Me So please guyz help Me
Print
Go Up Pages1 2
User actions