Помощ за инсталиране на тракер?

14 май 200719 г.

Добър ден ето фаиловете http://images17.snimka.bg/002857854.jpg и http://images17.snimka.bg/002857855.jpg как да го инстална с XAMPP :? :? :? ето това пише в database.sql

# SQL Manager 2005 for MySQL 3.7.0.1

# ---------------------------------------

# Host	 : localhost

# Port	 : 3306

# Database : torrents



SET FOREIGN_KEY_CHECKS=0;


#

# Structure for the `avps` table : 

#


DROP TABLE IF EXISTS `avps`;


CREATE TABLE `avps` (

  `arg` varchar(20) NOT NULL default '',

  `value_s` text NOT NULL,

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

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

  PRIMARY KEY  (`arg`)

) ENGINE=MyISAM;


#

# Structure for the `bans` table : 

#


DROP TABLE IF EXISTS `bans`;


CREATE TABLE `bans` (

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

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

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

  `comment` varchar(255) NOT NULL default '',

  `first` int(11) default NULL,

  `last` int(11) default NULL,

  PRIMARY KEY  (`id`),

  KEY `first_last` (`first`,`last`)

) ENGINE=MyISAM;


#

# Structure for the `blocks` table : 

#


DROP TABLE IF EXISTS `blocks`;


CREATE TABLE `blocks` (

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

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

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

  PRIMARY KEY  (`id`),

  UNIQUE KEY `userfriend` (`userid`,`blockid`)

) ENGINE=MyISAM;


#

# Structure for the `bookmarks` table : 

#


DROP TABLE IF EXISTS `bookmarks`;


CREATE TABLE `bookmarks` (

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

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

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

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `categories` table : 

#


DROP TABLE IF EXISTS `categories`;

CREATE TABLE `categories` (

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

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

  `name` varchar(30) NOT NULL default '',

  `image` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `comments` table : 

#


DROP TABLE IF EXISTS `comments`;


CREATE TABLE `comments` (

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

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

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

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

  `text` text NOT NULL,

  `ori_text` text NOT NULL,

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

  `editedat` datetime NOT NULL default '0000-00-00 00:00:00',

  PRIMARY KEY  (`id`),

  KEY `user` (`user`),

  KEY `torrent` (`torrent`)

) ENGINE=MyISAM;


#

# Structure for the `countries` table : 

#


DROP TABLE IF EXISTS `countries`;


CREATE TABLE `countries` (

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

  `name` varchar(50) default NULL,

  `flagpic` varchar(50) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `files` table : 

#


DROP TABLE IF EXISTS `files`;


CREATE TABLE `files` (

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

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

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

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

  PRIMARY KEY  (`id`),

  KEY `torrent` (`torrent`)

) ENGINE=MyISAM;


#

# Structure for the `dox` table

#


DROP TABLE IF EXISTS `dox`;


CREATE TABLE `dox` (

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

  `added` datetime default NULL,

  `title` varchar(255) NOT NULL default '',

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

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

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

  `url` varchar(255) NOT NULL default '',

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

  PRIMARY KEY  (`id`)

) TYPE=MyISAM;


#

# Structure for the `forums` table : 

#


DROP TABLE IF EXISTS `forums`;


CREATE TABLE `forums` (

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

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

  `name` varchar(60) NOT NULL default '',

  `description` varchar(200) default NULL,

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

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

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

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

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

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `friends` table : 

#


DROP TABLE IF EXISTS `friends`;


CREATE TABLE `friends` (

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

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

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

  PRIMARY KEY  (`id`),

  UNIQUE KEY `userfriend` (`userid`,`friendid`)

) ENGINE=MyISAM;


#

# Structure for the `guests` table : 

#


DROP TABLE IF EXISTS `guests`;


CREATE TABLE `guests` (

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

  `ip` varchar(15) NOT NULL default '',

  `time_accessed` datetime NOT NULL default '0000-00-00 00:00:00',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `messages` table : 

#


DROP TABLE IF EXISTS `messages`;


CREATE TABLE `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` datetime default NULL,

  `subject` varchar(60) NOT NULL default 'Без темы',

  `msg` text,

  `unread` enum('yes','no') NOT NULL default 'yes',

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

  `location` enum('in','out','both') NOT NULL default 'in',

  PRIMARY KEY  (`id`),

  KEY `receiver` (`receiver`)

) ENGINE=MyISAM;


#

# Structure for the `news` table : 

#


DROP TABLE IF EXISTS `news`;


CREATE TABLE `news` (

  `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 NOT NULL,

  `subject` text NOT NULL,

  PRIMARY KEY  (`id`),

  KEY `added` (`added`)

) ENGINE=MyISAM;


#

# Structure for the `notconnectablepmlog` table : 

#


DROP TABLE IF EXISTS `notconnectablepmlog`;


CREATE TABLE `notconnectablepmlog` (

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

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

  `date` datetime default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM;


#

# Structure for the `peers` table : 

#


DROP TABLE IF EXISTS `peers`;


CREATE TABLE `peers` (

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

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

  `peer_id` varchar(20) NOT NULL default '',

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

  `port` smallint(5) unsigned NOT NULL default '0',

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

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

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

  `seeder` enum('yes','no') NOT NULL default 'no',

  `started` datetime NOT NULL default '0000-00-00 00:00:00',

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

  `connectable` enum('yes','no') NOT NULL default 'yes',

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

  `agent` varchar(60) NOT NULL default '',

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

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

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

  `passkey` varchar(32) NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),

  KEY `torrent` (`torrent`),

  KEY `torrent_seeder` %2

Редактирано 14 май 200719 г. от bestlap (преглед на промените)

Цитирай

14 май 200719 г.

database.sql се импортва през http://localhost/phpmyadmin После четеш README и го инсталираш о_О

Цитирай

Добавете отговор

Можете да публикувате отговор сега и да се регистрирате по-късно. Ако имате регистрация, влезте в профила си за да публикувате от него.

Публикацията ви съдържа термини, които не допускаме! Моля, редактирайте съдържанието си и премахнете подчертаните думи по-долу. Ако замените букви от думата със звездички или друго, за да заобиколите това предупреждение, профилът ви ще бъде блокиран и наказан!

Напишете отговор в тази тема...

Последователи

Добре дошли!

Помощ за инсталиране на тракер?

Featured Replies

Добавете отговор

Разглеждащи това в момента 0

Дарение

Бюлетин

Профил

Навигация

Търсене

Конфигуриране на push известия в браузъра

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)