|
View Poll Results: What do you think? | |||
Love it | 24 | 60.00% | |
Perfect | 4 | 10.00% | |
needs work. | 6 | 15.00% | |
meh | 6 | 15.00% | |
Voters: 40. You may not vote on this poll |
#1
|
|||
|
|||
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')
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
Change log.
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
Last edited by l3on; 16th January 2018 at 04:03. Reason: Update |
The Following 15 Users Say Thank You to l3on For This Useful Post: | ||
almonkz (27th December 2020),
artist (3rd May 2021),
Botanicar (27th January 2018),
BTTFZanotti (17th April 2018),
exxtyui (3rd January 2018),
Fynnon (5th January 2018),
HannibalRoG (5th December 2020),
MainFrameX (29th September 2019),
papad (3rd January 2018),
pggwka (12th February 2023),
Poland07 (24th February 2018),
rex (21st December 2018),
Windocx (9th September 2018),
yanom (5th November 2021),
z3ro (3rd January 2018)
|
#2
|
|||
|
|||
why is the ip varchar 39 ?
how could ipv6 fit into that? it seems you didnt take into consideration this
__________________
Need HELP!? I can install:
|
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
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
__________________
Need HELP!? I can install:
|
#5
|
|||
|
|||
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 :)
|
#6
|
|||
|
|||
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
|
#7
|
|||
|
|||
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 |
#8
|
||||
|
||||
Any stable update ETA?
|
#9
|
|||
|
|||
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.
|
The Following User Says Thank You to l3on For This Useful Post: | ||
nilim (10th March 2018)
|
#10
|
||||
|
||||
Which one should i use? the one above or the one in the first post?
|
The Following User Says Thank You to nilim For This Useful Post: | ||
linkin2007 (5th January 2021)
|
Tags |
25 , preview , public , ttce |
Thread Tools | |
|
|