View Single Post
  #1   IP: 92.234.74.60
Old 3rd January 2018, 08:18
l3on's Avatar
l3on l3on is offline
Coder
 
Join Date: Jul 2012
Posts: 137
Default TTCE Public Preview 2.5b3
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.




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.
Attached Thumbnails
1.PNG   2.PNG   3.PNG   4.PNG  

Attached Files
File Type: zip TTCE Public Preview Build 2.5+patched.zip (4.04 MB, 322 views)

Last edited by l3on; 16th January 2018 at 04:03. Reason: Update
Reply With Quote
The Following 9 Users Say Thank You to l3on For This Useful Post:
Botanicar (27th January 2018), BTTFZanotti (17th April 2018), exxtyui (3rd January 2018), Fynnon (5th January 2018), papad (3rd January 2018), Poland07 (24th February 2018), rex (21st December 2018), Windocx (9th September 2018), z3ro (3rd January 2018)