TwitteReader self-hosting instructions

TwitteReader works with MySQL and PHP, so be sure to have both installed and access on the host.
  1. Access "/config/db_config.php" and edit the variables' values to later connect to the DB
  2. Using phpMyAdmin or mysql shell, create the following tables:
  3. --
    -- Table structure for table `tr_users`
    --

    CREATE TABLE `tr_users` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `username` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;


    --
    -- Table structure for table `tr_marked`
    --

    CREATE TABLE `tr_marked` (
    `username` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
    `id` bigint(20) unsigned NOT NULL,
    `date` int(10) unsigned NOT NULL,
    UNIQUE KEY `username` (`username`,`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  4. Upload the package contents (extracted) to your web/local host and you're ready to go
  5. Depending on the host you are using TwitteReader, localhost or webshost, you'll have to try the two different .htaccess files (they might show as hidden after extracted)
Any doubts or suggestions feel free to contact me.
These instructions are also inside the package, under INSTALL.txt
Remember me
home
blog
about
help

CC-GNU GPL
This software is licensed under the CC-GNU GPL version 2.0 or later.