Bravo List
Page 2 of 4 1 2 3 4
Show 40 post(s) from this thread on one page

Bravo List (http://www.bvlist.com/index.php)
-   Downloads (http://www.bvlist.com/forumdisplay.php?f=16)
-   -   phpMyBitTorrent v2.0 (http://www.bvlist.com/showthread.php?t=1042)

IDreams 5th October 2008 18:18
hmm
 
oke what is my problem I have follow the thinks whit the instal but I see now this

No database set!!! Check config file

sow I really see not the prob because there is a database

hooply somene can help me

ps soory for my bad english

joeroberts 5th October 2008 18:58
Quote:
Originally Posted by IDreams (Post 4737)
oke what is my problem I have follow the thinks whit the instal but I see now this

No database set!!! Check config file

sow I really see not the prob because there is a database

hooply somene can help me

ps soory for my bad english
did you run setup?

IDreams 5th October 2008 18:59
yes I have run the setup

and everything was oke

joeroberts 5th October 2008 19:18
Quote:
Originally Posted by IDreams (Post 4746)
yes I have run the setup

and everything was oke
check file include/configdata.php and make sure it was filled in write

IDreams 5th October 2008 20:02
oke the install is oke I have olso everything online but now I have a probleem I cant log in

also not in the admin

joeroberts 5th October 2008 20:41
Quote:
Originally Posted by IDreams (Post 4754)
oke the install is oke I have olso everything online but now I have a probleem I cant log in

also not in the admin
go to data base and disable captcha check

sorry for the delay I got trouble with my pc!
I well be working on Beta 4 tonight and hope to have it out tomorrow!

ancraz 9th October 2008 13:32
Quote:
Originally Posted by joeroberts (Post 4873)
sorry for the delay I got trouble with my pc!
I well be working on Beta 4 tonight and hope to have it out tomorrow!
some many changes in a short time :)

wMan 9th October 2008 20:26
nice work there joe

joeroberts 10th October 2008 18:20
Before I release beta4 is there any more bugs that I need to look into?

Dragan3591 10th October 2008 20:20
I got one bug but you can't possibly fix it :tease::whistle::hi::bubble::superman::warrior::so s::cool::relax:

joeroberts 11th October 2008 06:05
Beta 4 is now ready for down load at https://sourceforge.net/project/show...ease_id=632334

piku2008 15th October 2008 13:02
error in sql
 
There is the error on the sql part here is it

Code:
Error executing SQL Query CREATE TABLE `torrent_users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(25) NOT NULL default '', `clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '', `name` varchar(50) default NULL, `email` varchar(255) NOT NULL default '', `regdate` datetime NOT NULL default '0000-00-00 00:00:00', `password` varchar(40) NOT NULL default '', `theme` varchar(255) default NULL, `language` varchar(15) default NULL, `avatar` varchar(255) NOT NULL default 'blank.gif', `accept_mail` enum('yes','no') NOT NULL default 'no', `pm_notify` enum('true','false') NOT NULL default 'true', `aim` varchar(255) default NULL, `icq` varchar(10) default NULL, `jabber` varchar(255) default NULL, `msn` varchar(255) default NULL, `skype` varchar(255) default NULL, `yahoo` varchar(255) default NULL, `level` enum('user','premium','moderator','admin') NOT NULL default 'user', `uploaded` bigint(32) unsigned NOT NULL default '0', `downloaded` bigint(32) unsigned NOT NULL default '0', `active` tinyint(1) default '0', `ban` int(1) unsigned NOT NULL default '0', `act_key` varchar(32) default NULL, `passkey` varchar(32) default NULL, `newpasswd` varchar(40) default NULL, `banreason` varchar(255) default NULL, `lastip` int(10) unsigned NOT NULL default '0', `lasthost` varchar(255) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `rem` enum('yes','no') NOT NULL default 'no', `modcomment` varchar(225) NOT NULL default '', `warned` int(1) unsigned NOT NULL default '0', `warn_kapta` int(11) NOT NULL default '0', `warn_hossz` int(11) NOT NULL default '0', `invited_by` int(10) NOT NULL default '0', `invitees` varchar(100) NOT NULL default '', `invites` smallint(5) NOT NULL default '0', `country` int(10) NOT NULL default '0', `seedbonus` decimal(10,1) NOT NULL default '0.0', `seedbox` int(10) unsigned NOT NULL default '0.0.0.0', `tzoffset` smallint(4) NOT NULL default '0', `can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true', `invitedate` datetime NOT NULL default '0000-00-00 00:00:00', `donated` int(5) unsigned NOT NULL default '0', `dondate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), UNIQUE KEY `passkey` (`passkey`), KEY `lastip` (`lastip`), KEY `lasthost` (`lasthost`), KEY `date` (`regdate`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0;
Error ID: 1067
Error Message: Invalid default value for 'seedbox'
tell me how to solve this :the3:

joeroberts 15th October 2008 14:16
replace steup/sql/install-MySQL with this
Code:

CREATE TABLE `#prefix#_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`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_admin_forum`
--

CREATE TABLE `#prefix#_admin_forum` (
  `prefix` varchar(60) NOT NULL default '',
  `cookie_name` varchar(60) NOT NULL default '',
  `cookie_domain` varchar(60) NOT NULL default '',
  `cookie_path` varchar(60) NOT NULL default '',
  `cookie_time` varchar(60) NOT NULL default '0',
  `base_folder` varchar(60) NOT NULL default '',
  `forum_share` enum('true','false') NOT NULL default 'true',
  `auto_post` enum('true','false') NOT NULL default 'false',
  `auto_post_forum` varchar(60) NOT NULL default '0'
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_avps`
--

CREATE TABLE `#prefix#_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`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_bans`
--

CREATE TABLE `#prefix#_bans` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ipstart` int(10) unsigned NOT NULL default '0',
  `ipend` int(10) unsigned NOT NULL default '0',
  `reason` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip_unique` (`ipstart`,`ipend`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_blackjack`
--

CREATE TABLE `#prefix#_blackjack` (
  `userid` int(11) NOT NULL default '0',
  `points` int(11) NOT NULL default '0',
  `status` enum('playing','waiting') NOT NULL default 'playing',
  `cards` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_bonus`
--

CREATE TABLE `#prefix#_bonus` (
  `id` int(5) NOT NULL auto_increment,
  `bonusname` varchar(50) NOT NULL default '',
  `points` decimal(4,1) NOT NULL default '000.0',
  `description` text NOT NULL,
  `art` varchar(10) NOT NULL default 'traffic',
  `menge` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_cards`
--

CREATE TABLE `#prefix#_cards` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `pic` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_casino`
--

CREATE TABLE `#prefix#_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') NOT NULL default 'yes',
  `deposit` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_casino_bets`
--

CREATE TABLE `#prefix#_casino_bets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) NOT NULL default '0',
  `proposed` varchar(40) NOT NULL default '',
  `challenged` varchar(40) 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`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_casino_config`
--

CREATE TABLE `#prefix#_casino_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_categories`
--

CREATE TABLE `#prefix#_categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `sort_index` int(10) unsigned NOT NULL default '0',
  `image` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `sort_index` (`sort_index`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_comments`
--

CREATE TABLE `#prefix#_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,
  `news` int(10) NOT NULL default '0',
  `nzb` int(10) NOT NULL default '0',
  `offer` int(11) NOT NULL default '0',
  `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `editedby` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `torrent` (`torrent`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_comments_notify`
--

CREATE TABLE `#prefix#_comments_notify` (
  `torrent` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `status` enum('active','stopped') NOT NULL default 'active',
  PRIMARY KEY  (`torrent`,`user`),
  KEY `torrent` (`torrent`,`status`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_complaints`
--

CREATE TABLE `#prefix#_complaints` (
  `torrent` int(15) unsigned NOT NULL default '0',
  `user` int(11) unsigned NOT NULL default '0',
  `host` varchar(60) NOT NULL default '',
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `score` smallint(1) unsigned zerofill NOT NULL default '0',
  PRIMARY KEY  (`torrent`,`user`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_config`
--

CREATE TABLE `#prefix#_config` (
  `sitename` varchar(255) NOT NULL default '',
  `siteurl` varchar(255) NOT NULL default '',
  `cookiedomain` varchar(30) NOT NULL default '',
  `cookiepath` varchar(60) NOT NULL default '',
  `admin_email` varchar(60) NOT NULL default '',
  `language` varchar(15) NOT NULL default '',
  `theme` varchar(255) NOT NULL default '',
  `force_passkey` enum('true','false') NOT NULL default 'false',
  `welcome_message` longtext,
  `announce_text` varchar(255) default NULL,
  `allow_html` enum('true','false') NOT NULL default 'true',
  `rewrite_engine` enum('true','false') NOT NULL default 'true',
  `torrent_prefix` varchar(255) default NULL,
  `torrent_per_page` int(10) unsigned NOT NULL default '10',
  `onlysearch` enum('true','false') NOT NULL default 'true',
  `max_torrent_size` int(11) unsigned NOT NULL default '0',
  `announce_interval_min` int(10) unsigned NOT NULL default '0',
  `announce_interval` int(10) unsigned NOT NULL default '0',
  `dead_torrent_interval` int(10) unsigned NOT NULL default '0',
  `minvotes` smallint(5) unsigned NOT NULL default '0',
  `time_tracker_update` int(10) unsigned NOT NULL default '0',
  `best_limit` smallint(5) unsigned NOT NULL default '0',
  `down_limit` smallint(5) unsigned NOT NULL default '0',
  `torrent_complaints` enum('true','false') NOT NULL default 'false',
  `torrent_global_privacy` enum('true','false') NOT NULL default 'true',
  `disclaimer_check` enum('true','false') NOT NULL default 'false',
  `gfx_check` enum('true','false') NOT NULL default 'true',
  `upload_level` enum('all','user','premium') NOT NULL default 'user',
  `download_level` enum('all','user','premium') NOT NULL default 'all',
  `announce_level` enum('all','user') NOT NULL default 'all',
  `max_num_file` smallint(5) unsigned NOT NULL default '0',
  `max_share_size` bigint(8) unsigned NOT NULL default '0',
  `min_size_seed` mediumint(8) unsigned NOT NULL default '0',
  `min_share_seed` bigint(8) unsigned NOT NULL default '0',
  `global_min_ratio` float unsigned NOT NULL default '0',
  `autoscrape` enum('true','false') NOT NULL default 'true',
  `min_num_seed_e` smallint(5) unsigned NOT NULL default '0',
  `min_size_seed_e` bigint(8) unsigned NOT NULL default '0',
  `minupload_size_file` int(10) unsigned NOT NULL default '0',
  `allow_backup_tracker` enum('true','false') NOT NULL default 'false',
  `stealthmode` enum('true','false') NOT NULL default 'true',
  `version` varchar(5) NOT NULL default '',
  `upload_dead` enum('true','false') NOT NULL default 'false',
  `invites_open` enum('true','false') NOT NULL default 'false',
  `invite_only` enum('true','false') NOT NULL default 'false',
  `max_members` int(10) unsigned NOT NULL default '0',
  `auto_clean` int(10) unsigned NOT NULL default '0',
  `free_dl` enum('true','false') NOT NULL default 'false',
  `GIGSA` int(10) NOT NULL default '0',
  `RATIOA` decimal(10,2) NOT NULL default '0.00',
  `WAITA` int(10) NOT NULL default '0',
  `GIGSB` int(10) NOT NULL default '0',
  `RATIOB` decimal(10,2) NOT NULL default '0.00',
  `WAITB` int(10) NOT NULL default '0',
  `GIGSC` int(10) NOT NULL default '0',
  `RATIOC` decimal(10,2) NOT NULL default '0.00',
  `WAITC` int(10) NOT NULL default '0',
  `GIGSD` int(10) NOT NULL default '0',
  `RATIOD` decimal(10,2) NOT NULL default '0.00',
  `WAITD` int(10) NOT NULL default '0',
  `wait_time` enum('true','false') NOT NULL default 'false',
  `addprivate` enum('true','false') NOT NULL default 'false',
  `search_cloud_block` enum('true','false') NOT NULL default 'true',
  `pivate_mode` enum('true','false') NOT NULL default 'false'
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_countries`
--

CREATE TABLE `#prefix#_countries` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `flagpic` varchar(50) default NULL,
  `domain` char(3) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_download_completed`
--

CREATE TABLE `#prefix#_download_completed` (
  `user` int(11) unsigned NOT NULL default '0',
  `torrent` int(15) unsigned NOT NULL default '0',
  `completed` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user`,`torrent`),
  KEY `torrent` (`torrent`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_faq`
--

CREATE TABLE `#prefix#_faq` (
  `id` int(10) NOT NULL auto_increment,
  `type` set('categ','item') NOT NULL default 'item',
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `flag` set('0','1','2','3') NOT NULL default '1',
  `categ` int(10) NOT NULL default '0',
  `order` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_files`
--

CREATE TABLE `#prefix#_files` (
  `id` int(20) unsigned NOT NULL auto_increment,
  `torrent` int(15) unsigned NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `size` bigint(20) unsigned NOT NULL default '0',
  `md5sum` varchar(32) default NULL,
  `ed2k` varchar(255) default NULL,
  `magnet` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `torrent_2` (`torrent`,`filename`),
  KEY `torrent` (`torrent`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_filter`
--

CREATE TABLE `#prefix#_filter` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyword` varchar(50) NOT NULL default '',
  `reason` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `keyword` (`keyword`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_flashscores`
--

CREATE TABLE `#prefix#_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`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_lottery_config`
--

CREATE TABLE `#prefix#_lottery_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_offers`
--

CREATE TABLE `#prefix#_offers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `name` varchar(225) default NULL,
  `descr` text NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `for` int(10) unsigned NOT NULL default '0',
  `against` int(10) unsigned NOT NULL default '0',
  `category` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
  `votes` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_offervotes`
--

CREATE TABLE `#prefix#_offervotes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `offerid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `vote` enum('for','against') NOT NULL default 'for',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_offres_config`
--

CREATE TABLE `#prefix#_offres_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_online_users`
--

CREATE TABLE `#prefix#_online_users` (
  `id` int(60) unsigned NOT NULL default '0',
  `page` varchar(255) NOT NULL default '',
  `logged_in` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_paypal`
--

CREATE TABLE `#prefix#_paypal` (
  `siteurl` varchar(255) NOT NULL default '',
  `paypal_email` varchar(60) NOT NULL default '',
  `sitecost` varchar(60) NOT NULL default '',
  `reseaved_donations` varchar(60) NOT NULL default '',
  `donatepage` longtext NOT NULL,
  `donation_block` enum('true','false') NOT NULL default 'true',
  `nodonate` enum('EU','UK','US') NOT NULL default 'US'
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_peers`
--

CREATE TABLE `#prefix#_peers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(11) unsigned NOT NULL default '0',
  `torrent` int(10) unsigned NOT NULL default '0',
  `peer_id` varchar(20) binary NOT NULL default '',
  `unique_id` varchar(20) default NULL,
  `ip` int(10) unsigned NOT NULL default '0',
  `port` smallint(5) unsigned NOT NULL default '0',
  `real_ip` int(10) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `download_speed` int(11) unsigned NOT NULL default '0',
  `upload_speed` int(11) 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',
  `client` varchar(60) default NULL,
  `version` varchar(10) NOT NULL default '',
  `user_agent` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
  UNIQUE KEY `torrent_3` (`torrent`,`unique_id`),
  KEY `torrent` (`torrent`),
  KEY `last_action` (`last_action`),
  KEY `torrent_2` (`torrent`,`seeder`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_pollanswers`
--

CREATE TABLE `#prefix#_pollanswers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pollid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `selection` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`),
  KEY `selection` (`selection`),
  KEY `userid` (`userid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_polls`
--

CREATE TABLE `#prefix#_polls` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `question` varchar(255) NOT NULL default '',
  `option0` varchar(40) NOT NULL default '',
  `option1` varchar(40) NOT NULL default '',
  `option2` varchar(40) NOT NULL default '',
  `option3` varchar(40) NOT NULL default '',
  `option4` varchar(40) NOT NULL default '',
  `option5` varchar(40) NOT NULL default '',
  `option6` varchar(40) NOT NULL default '',
  `option7` varchar(40) NOT NULL default '',
  `option8` varchar(40) NOT NULL default '',
  `option9` varchar(40) NOT NULL default '',
  `sort` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_privacy_backup`
--

CREATE TABLE `#prefix#_privacy_backup` (
  `master` int(11) unsigned NOT NULL default '0',
  `slave` int(11) NOT NULL default '0',
  `torrent` int(11) NOT NULL default '0',
  `status` enum('pending','denied','granted') NOT NULL default 'pending',
  PRIMARY KEY  (`slave`,`torrent`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_privacy_file`
--

CREATE TABLE `#prefix#_privacy_file` (
  `master` int(11) unsigned NOT NULL default '0',
  `slave` int(11) unsigned NOT NULL default '0',
  `torrent` int(15) unsigned NOT NULL default '0',
  `status` enum('pending','denied','granted') NOT NULL default 'pending',
  PRIMARY KEY  (`slave`,`torrent`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_privacy_global`
--

CREATE TABLE `#prefix#_privacy_global` (
  `master` int(11) unsigned NOT NULL default '0',
  `torrent` int(11) NOT NULL default '0',
  `slave` int(11) unsigned NOT NULL default '0',
  `status` enum('blacklist','whitelist') NOT NULL default 'whitelist',
  PRIMARY KEY  (`master`,`slave`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_private_messages`
--

CREATE TABLE `#prefix#_private_messages` (
  `id` int(20) unsigned zerofill NOT NULL auto_increment,
  `sender` int(11) unsigned NOT NULL default '0',
  `recipient` int(11) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `text` longtext NOT NULL,
  `is_read` enum('true','false') NOT NULL default 'false',
  `sent` datetime NOT NULL default '0000-00-00 00:00:00',
  `sender_del` enum('true','false') NOT NULL default 'false',
  `recipient_del` enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`id`),
  KEY `from` (`sender`),
  KEY `to` (`recipient`),
  FULLTEXT KEY `text` (`text`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_private_messages_blacklist`
--

CREATE TABLE `#prefix#_private_messages_blacklist` (
  `master` int(11) unsigned NOT NULL default '0',
  `slave` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`master`,`slave`),
  KEY `master` (`master`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_private_messages_bookmarks`
--

CREATE TABLE `#prefix#_private_messages_bookmarks` (
  `master` int(11) unsigned NOT NULL default '0',
  `slave` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`master`,`slave`),
  KEY `master` (`master`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_ratings`
--

CREATE TABLE `#prefix#_ratings` (
  `torrent` int(10) unsigned NOT NULL default '0',
  `user` int(10) unsigned NOT NULL default '0',
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`torrent`,`user`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_ratiowarn`
--

CREATE TABLE `#prefix#_ratiowarn` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `warned` enum('yes','no') NOT NULL default 'no',
  `banned` enum('yes','no') NOT NULL default 'no',
  `ratiodate` datetime NOT NULL default '0000-00-00 00:00:00',
  `warntime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_ratiowarn_config`
--

CREATE TABLE `#prefix#_ratiowarn_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_requests`
--

CREATE TABLE `#prefix#_requests` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `request` varchar(225) default NULL,
  `descr` text NOT NULL,
  `added` 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(75) NOT NULL default '',
  `filledby` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_requist_config`
--

CREATE TABLE `#prefix#_requist_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_rules`
--

CREATE TABLE `#prefix#_rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` tinytext NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_search_text`
--

CREATE TABLE `#prefix#_search_text` (
  `id` int(20) unsigned NOT NULL auto_increment,
  `text` varchar(25) NOT NULL default '',
  `hit` int(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `text` (`text`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_seeder_notify`
--

CREATE TABLE `#prefix#_seeder_notify` (
  `torrent` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `status` enum('active','stopped') NOT NULL default 'active',
  PRIMARY KEY  (`torrent`,`user`),
  KEY `contacts` (`torrent`,`status`)
) TYPE=MyISAM;

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

--
-- Table structure for table `#prefix#_shouts`
--

CREATE TABLE `#prefix#_shouts` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `text` varchar(255) NOT NULL default '',
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `anti_flood` (`user`,`text`),
  KEY `posted` (`posted`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_smiles`
--

CREATE TABLE `#prefix#_smiles` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `code` varchar(15) NOT NULL default '',
  `file` varchar(30) NOT NULL default '',
  `alt` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_snatched`
--

CREATE TABLE `#prefix#_snatched` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent` int(10) unsigned NOT NULL default '0',
  `torrentid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `ip` bigint(20) unsigned NOT NULL default '0',
  `torrent_name` varchar(255) NOT NULL default '',
  `torrent_category` int(10) unsigned NOT NULL default '0',
  `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',
  `speedup` bigint(20) unsigned NOT NULL default '0',
  `speeddown` bigint(20) unsigned NOT NULL default '0',
  `seeder` enum('yes','no') NOT NULL default 'no',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `startdat` datetime NOT NULL default '0000-00-00 00:00:00',
  `completedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `connectable` enum('yes','no') NOT NULL default 'yes',
  `agent` varchar(60) NOT NULL default '',
  `finished` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `torrentid_3` (`torrentid`,`userid`),
  KEY `finished` (`finished`,`torrentid`),
  KEY `torrentid` (`userid`),
  KEY `torrentid_2` (`torrentid`),
  KEY `userid` (`userid`,`torrentid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_thanks`
--

CREATE TABLE `#prefix#_thanks` (
  `tid` bigint(10) NOT NULL auto_increment,
  `uid` bigint(10) NOT NULL default '0',
  `torid` bigint(10) NOT NULL default '0',
  `thank_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tid`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_tickets`
--

CREATE TABLE `#prefix#_tickets` (
  `id` int(4) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;




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

--
-- Table structure for table `#prefix#_torrents`
--

CREATE TABLE `#prefix#_time_offset` (
  `id` smallint(4) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=721 ;

CREATE TABLE `#prefix#_torrents` (
  `id` int(15) unsigned NOT NULL auto_increment,
  `info_hash` varchar(20) character set latin1 collate latin1_bin default NULL,
  `md5sum` varchar(32) default NULL,
  `name` varchar(255) NOT NULL default '',
  `filename` varchar(255) NOT NULL default '',
  `save_as` varchar(255) NOT NULL default '',
  `search_text` text NOT NULL,
  `descr` text NOT NULL,
  `torrent_descr` text NOT NULL,
  `plen` bigint(6) unsigned NOT NULL default '0',
  `size` bigint(20) unsigned NOT NULL default '0',
  `category` int(10) unsigned NOT NULL default '0',
  `type` enum('single','multi','link') NOT NULL default 'single',
  `numfiles` int(10) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `exeem` varchar(250) default NULL,
  `dht` enum('yes','no') NOT NULL default 'no',
  `backup_tracker` enum('true','false') NOT NULL default 'false',
  `views` int(10) unsigned NOT NULL default '0',
  `downloaded` int(10) unsigned NOT NULL default '0',
  `completed` int(10) unsigned NOT NULL default '0',
  `banned` enum('yes','no') NOT NULL default 'no',
  `password` varchar(255) default NULL,
  `private` enum('true','false') NOT NULL default 'false',
  `min_ratio` float unsigned NOT NULL default '0',
  `visible` enum('yes','no') NOT NULL default 'yes',
  `evidence` tinyint(1) NOT NULL default '0',
  `owner` int(10) unsigned NOT NULL default '0',
  `ownertype` tinyint(1) unsigned NOT NULL default '0',
  `uploader_host` varchar(100) NOT NULL default '',
  `numratings` int(10) unsigned NOT NULL default '0',
  `ratingsum` int(10) unsigned NOT NULL default '0',
  `seeders` int(10) unsigned NOT NULL default '0',
  `leechers` int(10) unsigned NOT NULL default '0',
  `tot_peer` int(11) unsigned NOT NULL default '0',
  `speed` int(10) unsigned NOT NULL default '0',
  `comments` int(10) unsigned NOT NULL default '0',
  `complaints` char(3) NOT NULL default '0,0',
  `tracker` varchar(250) default NULL,
  `tracker_list` text,
  `tracker_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `nuked` enum('yes','no','unnuked') NOT NULL default 'no',
  `ratiobuild` enum('yes','no') NOT NULL default 'no',
  `nukereason` varchar(225) NOT NULL default '',
  `thanks` int(10) NOT NULL default '0',
  `imdb` varchar(225) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `info_hash` (`info_hash`),
  KEY `owner` (`owner`),
  KEY `visible` (`visible`),
  KEY `added` (`added`),
  KEY `seeders` (`seeders`),
  KEY `leechers` (`leechers`),
  KEY `tot_peer` (`tot_peer`),
  KEY `banned` (`banned`),
  KEY `password` (`password`),
  KEY `tracker` (`tracker`),
  KEY `evidence` (`evidence`),
  KEY `rating` (`numratings`,`ratingsum`),
  KEY `numfiles` (`numfiles`),
  KEY `downloaded` (`downloaded`),
  KEY `category` (`category`),
  KEY `type` (`type`),
  FULLTEXT KEY `ft_search` (`search_text`),
  FULLTEXT KEY `filename` (`filename`),
  FULLTEXT KEY `torrent_descr` (`torrent_descr`)
) TYPE=MyISAM  PACK_KEYS=1 CHECKSUM=1;

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

--
-- Table structure for table `#prefix#_trackers`
--

CREATE TABLE `#prefix#_trackers` (
  `id` tinyint(5) unsigned NOT NULL auto_increment,
  `url` varchar(120) NOT NULL default '',
  `support` enum('selective','global','single') NOT NULL default 'selective',
  `status` enum('active','dead','blacklisted') NOT NULL default 'active',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  KEY `update` (`updated`)
) TYPE=MyISAM ;

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

--
-- Table structure for table `#prefix#_users`
--

CREATE TABLE `#prefix#_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
  `clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
  `name` varchar(50) default NULL,
  `email` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `password` varchar(40) NOT NULL default '',
  `theme` varchar(255) default NULL,
  `language` varchar(15) default NULL,
  `avatar` varchar(255) NOT NULL default 'blank.gif',
  `accept_mail` enum('yes','no') NOT NULL default 'no',
  `aim` varchar(255) default NULL,
  `icq` varchar(10) default NULL,
  `jabber` varchar(255) default NULL,
  `msn` varchar(255) default NULL,
  `skype` varchar(255) default NULL,
  `yahoo` varchar(255) default NULL,
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  `uploaded` bigint(32) unsigned NOT NULL default '0',
  `downloaded` bigint(32) unsigned NOT NULL default '0',
  `active` tinyint(1) default '0',
  `ban` int(1) unsigned NOT NULL default '0',
  `act_key` varchar(32) default NULL,
  `passkey` varchar(32) default NULL,
  `newpasswd` varchar(40) default NULL,
  `banreason` varchar(255) default NULL,
  `lastip` int(10) unsigned NOT NULL default '0',
  `lasthost` varchar(255) NOT NULL default '',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `rem` enum('yes','no') NOT NULL default 'no',
  `modcomment` varchar(225) NOT NULL default '',
  `warned` int(1) unsigned NOT NULL default '0',
  `warn_kapta` int(11) NOT NULL default '0',
  `warn_hossz` int(11) NOT NULL default '0',
  `invited_by` int(10) NOT NULL default '0',
  `invitees` varchar(100) NOT NULL default '',
  `country` int(10) NOT NULL default '0',
  `seedbox` int(10) unsigned NOT NULL default '0',
  `tzoffset` smallint(4) NOT NULL default '0',
  `can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
  `Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
  `invites` smallint(5) NOT NULL default '0',
  `invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
  `seedbonus` decimal(10,1) NOT NULL default '0.0',
  `donated` int(5) unsigned NOT NULL default '0',
  `dondate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `passkey` (`passkey`),
  KEY `lastip` (`lastip`),
  KEY `lasthost` (`lasthost`),
  KEY `date` (`regdate`)
) TYPE=MyISAM ;

Dragan3591 15th October 2008 14:18
Damn man, do you even sleep?

joeroberts 15th October 2008 14:20
I am asleep

Dragan3591 15th October 2008 14:39
I see... lol :sleep::sleep: Me too, at work, as usual. lmao

movizdb 15th October 2008 19:26
cool i'll test it thx man

joeroberts 16th October 2008 04:11
phpMyBitTorrent going gold
 
do you think That phpMyBitTorrent is ready to go gold
I have made alot of updates and all the bug reports have stoped so I am taking it that there
are no more bug's that can be found in testing mode??

Please let Me know what you think.....

Subzero 16th October 2008 04:12
i think so m8

UnFeeLing 16th October 2008 09:23
my english is very bad... who have russian translate?

joeroberts 16th October 2008 14:39
sorry my Russian very bad so there is not one you well need to make it take the english copy every thing over to a file called rusian and have some fun...

I just updated the demo link for people to get a look at this :)


UPDATE:

I am very happy to announce that we have moved to our RC1 with much thanks going out to
several members of this site and from people all over we have cleared out just about every bug that can be found.
hopping that we do not have to stay in RC for to long and go to gold in the next couple weeks.
Then we can move on to more things.
expanding the shoutbox to show arcives users active and much more.
I want to (with help) add a smaller forum to the tracker so I you dont want to use the heavy phpBB3 forum you can.
I want to add more personnel levels.
and a few other things.
If you have any Idea's please let me know what else would be a good thing to add.

Krypto 24th October 2008 20:26
Just got around to installing the RC1 and noticed a couple of things:-

1. When you click on the Torrents Menu and you click on the NFO Tab next to Torrent Info it shows nothing, even though I've uploaded an NFO file.

2. How are Passkeys assigned? I enabled Force Passkey in the Admin Settings, but when I upload/download I torrent I receive this error in my client "Failure: Only users with Passkey are allowed to use our tracker."

3. On the Index page for Polls the text for "[View Results]" is way too small, it's unreadable.

Which files/s would I need to edit to remove the "backgroundblue.png" from the 'Files, Peers, Ratings/Comments'.

Nice work Joe :D

joeroberts 24th October 2008 22:51
1 Attachment(s)
Quote:
1. When you click on the Torrents Menu and you click on the NFO Tab next to Torrent Info it shows nothing, even though I've uploaded an NFO file.
replace ajax.php with attacched file
Quote:
2. How are Passkeys assigned? I enabled Force Passkey in the Admin Settings, but when I upload/download I torrent I receive this error in my client "Failure: Only users with Passkey are allowed to use our tracker."
create a torrent as normal. Do not add passkye at this time!
Upload the torrent to the site.
and down load the torrent from the site and seed.
Quote:
3. On the Index page for Polls the text for "[View Results]" is way too small, it's unreadable.
O.K. I redid this display to make it a little bigger.
Quote:
Which files/s would I need to edit to remove the "backgroundblue.png" from the 'Files, Peers, Ratings/Comments'.
you well need to edit frame.php

Krypto 25th October 2008 00:16
Thanks Joe.

NFO now viewable and I saw what you mentioned in the shoutbox about the passkey and that solution fixed it.

On memberlist.php the search is case sensative, can we have it case insensative?

Donation page the "Goal: $ 0
Collected: $ 0 " text is too small.

On Profile page the "Page 1" number is also too small.

Still on the Profile Page is there a way to show that if you are the uploader of the torrent that it shows you as completed 'YES' instead of 'NO'?

On index under TORRENTS THAT NEED SEEDING the "Please help them out, if you happen to have the files on your harddisk. Thank you!" text is too small.

As for the use of the background colors that I mentioned for Peers, Filelist and Comments I had to comment out that line of code in the css body as I could not figure out how to remove it from frame.php

Other than the above that is all I can find issues with at the moment :D

joeroberts 25th October 2008 01:19
Quote:
Originally Posted by Krypto (Post 5826)
Thanks Joe.

NFO now viewable and I saw what you mentioned in the shoutbox about the passkey and that solution fixed it.
Your welcome!

Quote:
Originally Posted by Krypto (Post 5826)
On memberlist.php the search is case sensative, can we have it case insensative?
I Thought I set it to look threw username_clean table I well look at that code some more.

Quote:
Originally Posted by Krypto (Post 5826)
Donation page the "Goal: $ 0
Collected: $ 0 " text is too small.

On Profile page the "Page 1" number is also too small.
try to edit your css body{} for font size

Quote:
Originally Posted by Krypto (Post 5826)
Still on the Profile Page is there a way to show that if you are the uploader of the torrent that it shows you as completed 'YES' instead of 'NO'?
you meen in the snatch list?

Quote:
Originally Posted by Krypto (Post 5826)
As for the use of the background colors that I mentioned for Peers, Filelist and Comments I had to comment out that line of code in the css body as I could not figure out how to remove it from frame.php
Open frame.php and comment out
Code:
Quote:
Originally Posted by Krypto (Post 5826)
Other than the above that is all I can find issues with at the moment :D
thanks for the imput the more you find the better the finnal!

Krypto 25th October 2008 03:26
Quote:
Originally Posted by joeroberts
try to edit your css body{} for font size
Tried that it had no effect.

Quote:
Originally Posted by joeroberts
you meen in the snatch list?
Yes.

Quote:
Originally Posted by joeroberts
Open frame.php and comment out
PHP Code:
<body></body> 
Tried that it had no effect.

joeroberts 25th October 2008 06:50
2 Attachment(s)
replace these files[hide]Attachment 489[/hide][hide]Attachment 490[/hide]
now open your theme style sheet and add
Code:
table.peertable{
background-color:#FFFFFF;
}
table.filelist{
background-color:#FFFFFF;
}
p.donation{
font-size:15px;
}
table.table_table{
font-size:14px;
}
and edit them to what you want them to be that well take care of font sizing

Krypto 25th October 2008 13:00
4 Attachment(s)
Much appreciated Joe :)

Just some small things per pics. If they have values then I get the blue bar at the bottom, but if they contain nothing then the entire table is blue.


Attachment 491 Attachment 492

Attachment 493 Attachment 494

joeroberts 25th October 2008 15:16
for the back ground sorry but don't take it wrong but change themes then or you can create a .css for frame.php
and change this to point to it
Code:
if (is_readable("themes/$theme/style.css")) {
        echo "\n\n\n";
}
and the o in donate.php is because you did not fill in the info you should have in the admin panel you can use html there

Krypto 25th October 2008 16:14
Thanks again Joe, forgot all about the other themes:chch:

When selecting themes I receive this error

"phpMyBitTorrent Error

_bterridnotset"

Only seems to happen if I'm browsing anything but the index page and then change themes?

joeroberts 25th October 2008 17:19
1 Attachment(s)
yea I have not perfected that yet sorry

turn off case sensitive for user search in members list use attached.

Quote:
Originally Posted by Krypto (Post 5840)
Thanks again Joe, forgot all about the other themes:chch:

When selecting themes I receive this error

"phpMyBitTorrent Error

_bterridnotset"

Only seems to happen if I'm browsing anything but the index page and then change themes?
here is the fix
open all themes/yourthemes/main.php
find
Code:
        echo "
";
replace with
Code:
        echo "";

Krypto 25th October 2008 18:21
Works Great :hi:

Sorry another issue Joe.

EDIT:
BBCodes are not displaying in rules.

joeroberts 25th October 2008 22:44
2 Attachment(s)
replace these files

Krypto 25th October 2008 22:58
WOW super quick fix :superman:

Just noticed that on the Menu Block we don't have any kind of link for the Rules!

joeroberts 25th October 2008 22:59
it is in you profile or you can add one in the themes

Krypto 25th October 2008 23:01
Thanks again, never thought of looking there!

Another Issue:-

Seed Bonus does not seem to work, I have 110 Points but all the Exchange buttons are deactivated.

joeroberts 26th October 2008 00:31
2 Attachment(s)
replace mybounce.php and mybonus.php

Krypto 26th October 2008 00:56
Fantastic :)

On the Index Page should it not just show one or the other instead of both?

Torrents That Need Seeding

No Torrents Need Seeding

Also the Language Changer will not allow anything other than English.

joeroberts 28th October 2008 06:12
phpMyBitTorrent V2.0.2 Gold
 
ok folks here it is after all our work hope every thing work as you like it phpMyBitTorrentV2.0.2 Gold

Krypto 28th October 2008 11:58
In announce.php

Find
PHP Code:
if (!$check AND $seeder == "yes")mysql_query("INSERT INTO ".$db_prefix."_snatched (torrent, torrentid, userid, ip, port, startdat, last_action, agent, torrent_name, torrent_category, finished, completed) VALUES ($torrentid, $torrentid, $uid, '".$ip."', $port, NOW(), NOW(), '" . $agent . "' , '" . addslashes($torrentname) . "', $torrentcategory, 'yes, NOW())")or err(mysql_error()); 
Replace
PHP Code:
if (!$check AND $seeder == "yes")mysql_query("INSERT INTO ".$db_prefix."_snatched (torrent, torrentid, userid, ip, port, startdat, last_action, agent, torrent_name, torrent_category, finished, completedat) VALUES ($torrentid, $torrentid, $uid, '".$ip."', $port, NOW(), NOW(), '" . $agent . "' , '" . addslashes($torrentname) . "', $torrentcategory, 'yes', NOW())")or err(mysql_error()); 


All times are GMT +2. The time now is 02:04.
Page 2 of 4 1 2 3 4
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.