View Single Post
  #1  
Old 03-01-18, 08:18
l3on's Avatar
l3on l3on is offline
Coder
 
Join Date: Jul 2012
Posts: 136
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, 315 views)

Last edited by l3on; 16-01-18 at 04:03. Reason: Update
Reply With Quote
The Following 9 Users Say Thank You to l3on For This Useful Post:
Botanicar (27-01-18), BTTFZanotti (17-04-18), exxtyui (03-01-18), Fynnon (05-01-18), papad (03-01-18), Poland07 (24-02-18), rex (21-12-18), Windocx (09-09-18), z3ro (03-01-18)