Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   TTCE Public Preview 2.5 (http://www.bvlist.com/showthread.php?t=11420)

l3on 3rd January 2018 08:18

TTCE Public Preview 2.5b3
 
5 Attachment(s)
Merry Christmas & An Happy New Year love TTCE & thanks to Lee Howarth for helping with ajax chat



Notice install is same as before edit the following files.

Edit backend/config.php
Edit backend/mysql.php
edit chat/lib/config.php
Finally import dump.sql and create user enjoy :D

You may need to do the following if facing the following error (MySQL Incorrect datetime value: '0000-00-00 00:00:00')

  • Drop the users table.
  • And run the following code

Code:

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(40) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `email` varchar(80) NOT NULL DEFAULT '',
  `status` enum('pending','confirmed') NOT NULL DEFAULT 'pending',
  `added` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_access` datetime DEFAULT NULL,
  `editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `privacy` enum('strong','normal','low') NOT NULL DEFAULT 'normal',
  `stylesheet` int(10) DEFAULT '1',
  `language` varchar(20) NOT NULL DEFAULT '1',
  `info` text,
  `acceptpms` enum('yes','no') NOT NULL DEFAULT 'yes',
  `ip` varchar(39) NOT NULL DEFAULT '',
  `class` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `avatar` varchar(100) NOT NULL DEFAULT '',
  `uploaded` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `downloaded` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(30) NOT NULL DEFAULT '',
  `donated` int(5) UNSIGNED NOT NULL DEFAULT '0',
  `country` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `notifs` varchar(100) NOT NULL DEFAULT '',
  `enabled` varchar(10) NOT NULL DEFAULT 'yes',
  `modcomment` text,
  `gender` varchar(6) NOT NULL DEFAULT '',
  `client` varchar(25) NOT NULL DEFAULT '',
  `age` int(3) NOT NULL DEFAULT '0',
  `warned` char(3) NOT NULL DEFAULT 'no',
  `signature` varchar(200) NOT NULL DEFAULT '',
  `last_browse` int(11) NOT NULL DEFAULT '0',
  `forumbanned` char(3) NOT NULL DEFAULT 'no',
  `invited_by` int(10) NOT NULL DEFAULT '0',
  `invitees` varchar(100) NOT NULL DEFAULT '',
  `invites` smallint(5) NOT NULL DEFAULT '0',
  `invitedate` datetime DEFAULT NULL,
  `commentpm` enum('yes','no') NOT NULL DEFAULT 'yes',
  `passkey` varchar(32) NOT NULL DEFAULT '',
  `page` text,
  `team` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tzoffset` int(4) DEFAULT '0',
  `hideshoutbox` enum('yes','no') NOT NULL DEFAULT 'no'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD KEY `status_added` (`status`,`added`),
  ADD KEY `ip` (`ip`),
  ADD KEY `uploaded` (`uploaded`),
  ADD KEY `downloaded` (`downloaded`),
  ADD KEY `country` (`country`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
/*!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 */;


Welcome to TTCE Public Preview Build 2.5
  • Lite weight theme: We have manage to bring the script from an whopping 12MB to only 4MB.
  • No more sql errors: The beta release was pretty messy and had many sql errors lurking around witch was causing many features to break making the platform unstable.
  • UDP Support: Yes udp is support providing {fsock} is enabled other wise udp will not work.
  • PHP 7 and newer



Change log.
  • Fixed klappe.js
  • Bootstrap 4
  • font-awsome & font-awsome-animation
  • Some minor bugs fix
  • New Ajax chatbox.

:drink:


Disclaimer This project is open source if you need support vist torrenttradermods.pw i will post updates on this topic No this isn't new source code it based of pure 2.0.8 and is completely community based I'm no pro coder by any mean i just do this for fun and to burn time you i'ver like me or hate me i don't care i'm just doing my part.


Notice it to update it rather simple backup config.php & mysql.php uplaod new content and then reupload config.php & mysql.php

Changelog
  1. update to bootstrap 4 beta 3
  2. Remove update check since updates are release here.

DND 3rd January 2018 09:41

why is the ip varchar 39 ?
how could ipv6 fit into that? it seems you didnt take into consideration this

l3on 3rd January 2018 10:15

I'm not even sure if script support IPV6 and the SQL is the default layout of torrenttrader 2.08 so yeah but I'll look into it.

DND 3rd January 2018 10:20

from what i saw in torrenttrader it does support for ipv6 (or maybe i saw a modified one... hmm)
at least i saw some inet_pton and inet_ntop functions
varbinary would be the best approach

l3on 3rd January 2018 10:26

Thanks for the input realistically the code need an rebuild but not got that kind of time to commit however I will attempt to improve it were I can also I'll release an patch shortly that will update bootstrap 4 to beta 3 and see if I can work the SQL better :)

Napon 5th January 2018 18:45

Tt v3 im not going into stealing it for a start ... the ipv6 easy to fix also the timestamp too...but hell too many fixs to do in this im not going to dl it ..as i know what it be like for bugs lol

l3on 6th January 2018 07:41

1 Attachment(s)
This is actually bug free to your record but hello troll.

Bump: Update coming soon will provide bootstrap 4 beta 3 and some table work and some ui improvement.

Bump: Here update :3

nilim 10th March 2018 11:59

Any stable update ETA?

l3on 10th March 2018 12:22

The file above is stable to use but you may need to have some php skill's and understand how to theme or work the ui as i got a little lazy and never finished the user profile bit but other than that yes indeed it stable.

nilim 10th March 2018 13:36

Quote:

Originally Posted by l3on (Post 51639)
The file above is stable to use but you may need to have some php skill's and understand how to theme or work the ui as i got a little lazy and never finished the user profile bit but other than that yes indeed it stable.

Which one should i use? the one above or the one in the first post? :sad:


All times are GMT +2. The time now is 01:24.

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