Installed Freichat v9.3 on my site (running Joomla 2.5.14) last night. After a few initial teething troubles with file permissions and having to clear browser cache/refresh page to get Chat room to show up and for it to recognise that there were users online, I tried posting a test message in a private room I had set up in the backend with a password. It just let me post without asking for the password though. I am logged in as website admin on one browser (Chrome) and as a regular user in another (Firefox). I can understand it allowing me to post as the admin without a password but the regular user should be asked for the password before seeing the option to use the room surely? I have restricted use of the whole chat to 4 Joomla usergroups and wondered if this conflicts with the private room settings?

Can anyone please advise how I can fix this? Also any help as to how I integrate avatars from my Kunena forum would be gratefully received.

Thanks

Hi,

I would like to integrate FreiChat into my system, but have the following problem when adding js file to the page:

TypeError: $ is not a function
$('body').on('click', function(e) {

My page structure is like this:

<script src="js/jquery.min.js"></script> ( version 1.9.0 )
<script>
$( document ).ready( function () {
// my custom code
});
</script><script src="apps/freichat/client/main.php?id=null&amp;xhash=&lt;?php%20echo%20freichatx_get_hash();%20?&gt;"></script>

Thank you for you help!

P. S. I have seen related discussions in other threads, but there were to explanation about cause of that problem.

Hello

I instaled Frei-chat on my site which is Joomla Ja social and and after instalation shows up only Frei-chat but not any more login form.
So i cant login to it.
Can you help me please??

u can have look at asiaadvert.com

THX

Hello,

I have installed Freichat & it is working fine on local machine where the it is installed. however it is not working from on other machines which are in same network. I am able to access the pages where the code is embedded but it does not show the chat. Same page is working with chat fine on local machine.

Thanks in advance.

Hello,

after an installation problem (wrong folder) I reinstallad freichat at
http://www.lena-boehm.de/freichat.
and it seems to be working.

At least I can access administration and configure the module (i.e. changing the title for the chat).
But no other chat elements are visible, although the position-0 seems to be ok.

I would very much appreciate any help.
Best Regards
Oliver

Hi,

First time user of the Freichat. I installed it quickly and successfully.
I would like to notify the admin of a problem I met when i tried to change the name of the pre-configured chat rooms.
Actually when you click on edit, the chat room name changes from the Password field and vice-versa.
I think it should be fixed.

The chat works like a charm and I have already made the Greek language. Where I have to send it to be included in the zip.

Thanks

Dimosthenis

Hi ,

I'm trying to install freichat with phpbb.
Installation went fine, however when loading the site it keep "hanging" on "Getting list of online users .....".
Also there is no "demodata" in the chatrooms, while there is data available within de dbtable.

I mailed u a link to the site and 2 testusers.

I think its a driver problem.

What i tested so far:
- Tested on different versions of php and sql.
- Tested on different versions of phpbb (3.0.4 - 3.0.10)
- tested on remote (hosted) server and tested with a local server (usbwebserver)
- Tested with different browsers.

Could you please help me out?

i installed freichat in wamp server working well.but when i installed on webserver it is not showing,
i changed gzip and ajax setting no to yes
still no change
pls check my website www.mcxwatch.in

i installed freichat in wamp server working well.but when i installed on webserver it is not showing,
i changed gzip and ajax setting no to yes
still no change
pls check my website www.mcxwatch.in

no exit button panel administrator freichat?

Hello,

I successfully installed FreiChat 9.2 for Joomla 3.0.3
What shows up on the assigned pages is the name of the chat, but now dialogs (users, rooms, menu etc.)

I followed the installation instruction and I tried some access options in the FreiChat options (Everyone, disable for guests = No etc.) and also for the modules options in Joomla (now it is Public).

What might be a problem is that I use a special template (av_pinboard) but I also tried the standard ones (protostar or Beez3).

Any ideas would be very much appreciated.

Thanks
Oliver

Hi
I have use FreiChat last week, whenever i have to install this, I got JInstaller: :Install: Cannot find XML setup file message... also it does not installed... So i have to search why this occurred, they told just change the xml file.. but in this did not have xml file... also i have use joomla 2.5.8.. please help me

i keep getting Invalid FreiChat license: This domain is not registered to be used with FreiChat. I put my domain down but the smf is in mywebsite.org/home is there any way to fix this. Help would be greatly appreciated.

I recently installed Freichat on my community's website to provide an easy way for our members to communicate with each other. Since the software is not inexpensive, we decided on using the free version for now.
We wanted Freichat to replace our old PM system and while it does a good job at that when both users are online, problems arise when you need to send a message to an offline user and you haven't opened the chat previously. Is there any way to list or search for offline users as well, either through legitimate means or by altering the code? This would make Freichat a whole lot more useful for our purposes.

Help would be greatly appreciated!

I have a website with a front and back side. ( The backside is for employees, etc., ), I would like to incorporate Frie Chat on the "backside" of the site only. How can I do this? Right now it pops up on the front side of the site only.


Thanks!

I just installed Freichat 9.2, have read past posts to this forum about "no online users" appearing in the the Users screen...it just says Getting List of Online Users...
I have tried all suggested fixes to this problem and it still doesn't work. One post recommended a download of V. 8.7 fixes...I'm using 9.2

No connection to other Joomla registered users is possible - so this chat is worthless unless you talk to yourself.

Give us a fix.

Mike Wheeler

Hy,

just installed Freichat with PhPbb, al went fine.
Could log into adminpage once, after that when i try to log in and fill in the password its keeps getting blank.
Changing password or reinstall doesent change anything.

Any ideas?

Hello, I love Freichat and it works very well, the only issue I have is that no Guests ever appear online even though I know there are some as I sometimes get messages from them and they are still online..

Is there something that I am missing?


PS, not so much a bug, but I think that your own name should show up on the chat list as well, some users may confuse that with not showing up on the chat list as not being logged in.

I'm using Freichat 9.2 on a Joomla 1.5 driven website (www.ziekenhuisgeneeskunde.nl).

I'm logged in on 2 different browsers with 2 different accounts and yet it won't work. In firefox the private chatbox notices the other user, but in chrome I get 'no one online'.

I checked the forum for solutions and tried a lot of them but with no succes. Hope you can help me! Thanks in advance.

Hello and thanks for your wonderfull product, I am interisted in buying the paid version, but want to test before buying. Here is a sample of my database any help with intergration would be nice! My site uses smarty for templating. http://tellyshack.com

-- phpMyAdmin SQL Dump
-- version 3.5.8.1
-- http://www.phpmyadmin.net
--
-- Host: sql206.freehostingking.com
-- Generation Time: Jul 25, 2013 at 12:23 PM
-- Server version: 5.5.30-30.2
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `fking_12676952_php`
--

-- --------------------------------------------------------

--
-- Table structure for table `activity`
--

CREATE TABLE IF NOT EXISTS `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`user_data` text NOT NULL,
`target_data` text NOT NULL,
`target_type` tinyint(4) NOT NULL,
`event_date` datetime NOT NULL,
`event_type` tinyint(4) NOT NULL,
`event_comment` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `activity`
--

INSERT INTO `activity` (`id`, `user_id`, `target_id`, `user_data`, `target_data`, `target_type`, `event_date`, `event_type`, `event_comment`) VALUES
(1, 1, 0, '{"id":1,"username":"Catfish","email":"franselstadt@outlook.com","fb_id":"0","avatar":"nopic.jpg","fb_session":""}', '[]', 0, '2013-07-23 15:52:27', 3, 'Üdv a körünkben!');

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

-- --------------------------------------------------------

--
-- Table structure for table `broken_episodes`
--

CREATE TABLE IF NOT EXISTS `broken_episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `broken_movies`
--

CREATE TABLE IF NOT EXISTS `broken_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`postid` int(10) unsigned NOT NULL DEFAULT '0',
`topid` int(10) unsigned NOT NULL DEFAULT '0',
`user` int(10) NOT NULL,
`body` text COLLATE utf8_unicode_ci NOT NULL,
`dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`like` smallint(6) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=178 ;

-- --------------------------------------------------------

--
-- Table structure for table `embeds`
--

CREATE TABLE IF NOT EXISTS `embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`embed` text NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `episodes`
--

CREATE TABLE IF NOT EXISTS `episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show_id` int(11) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`embed` text NOT NULL,
`date_added` datetime NOT NULL,
`thumbnail` varchar(255) NOT NULL,
`views` bigint(20) NOT NULL,
`checked` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`show_id`),
KEY `season` (`season`),
KEY `episode` (`episode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user1` int(11) NOT NULL,
`user2` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user1` (`user1`),
KEY `user2` (`user2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `likes`
--

CREATE TABLE IF NOT EXISTS `likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`comment` varchar(500) NOT NULL,
`vote` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`),
KEY `date_added` (`date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`perma` varchar(30) NOT NULL,
`title` varchar(30) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `perma`, `title`, `status`) VALUES
(1, 'tv_shows', 'TV shows', 1),
(2, 'movies', 'Movies', 1),
(7, 'submit_links', 'Submit links', 1),
(6, 'requests', 'Requests', 1);

-- --------------------------------------------------------

--
-- Table structure for table `movies`
--

CREATE TABLE IF NOT EXISTS `movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`perma` varchar(50) NOT NULL,
`description` text NOT NULL,
`thumb` varchar(50) NOT NULL,
`embed` text NOT NULL,
`views` bigint(20) NOT NULL,
`imdb_id` varchar(30) NOT NULL,
`imdb_rating` float NOT NULL,
`date_added` datetime NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `imdb_id` (`imdb_id`),
KEY `title` (`title`),
KEY `perma` (`perma`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `movies`
--

INSERT INTO `movies` (`id`, `title`, `perma`, `description`, `thumb`, `embed`, `views`, `imdb_id`, `imdb_rating`, `date_added`, `meta`) VALUES
(1, '{"en":"Turbo"}', 'turbo', '{"en":"A freak accident might just help an everyday garden snail achieve his biggest dream: winning the Indy 500."}', 'movie_6f53bfe04e78da893ba0c4f35ba6847e.jpg', '', 16, 'tt1860353', 6.4, '2013-07-24 19:41:48', '');

-- --------------------------------------------------------

--
-- Table structure for table `movie_embeds`
--

CREATE TABLE IF NOT EXISTS `movie_embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie_id` int(11) NOT NULL,
`embed` varchar(1024) NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie_id` (`movie_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `movie_embeds`
--

INSERT INTO `movie_embeds` (`id`, `movie_id`, `embed`, `link`, `lang`, `weight`) VALUES
(1, 1, '<iframe style="overflow: hidden; border: 0; width: 620px; height: 360px" src="http://embed.novamov.com/embed.php?width=620&amp;height=360&amp;v=&amp;px=1" scrolling="no"></iframe>', 'http://embed.novamov.com/embed.php?width=600&height=480&v=fmz7oogpii5gj&px=1'' scrolling=''no''', 'ENG', 2);

-- --------------------------------------------------------

--
-- Table structure for table `movie_ratings`
--

CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `movieid` (`movieid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `movie_ratings`
--

INSERT INTO `movie_ratings` (`id`, `movieid`, `rating`, `ip`, `ratingdate`) VALUES
(1, 1, 5, '31.100.240.202', '2013-07-24 23:02:17');

-- --------------------------------------------------------

--
-- Table structure for table `movie_tags`
--

CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `movie_tags_join`
--

CREATE TABLE IF NOT EXISTS `movie_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`movie_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `movie_id` (`movie_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`permalink` varchar(255) NOT NULL,
`content` text NOT NULL,
`parent_id` int(11) NOT NULL,
`visible` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `parent_id` (`parent_id`),
KEY `visible` (`visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `plugins`
--

CREATE TABLE IF NOT EXISTS `plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dirname` varchar(30) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`install_url` varchar(100) NOT NULL,
`start_url` varchar(100) NOT NULL,
`author` varchar(255) NOT NULL,
`author_url` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `ratings`
--

CREATE TABLE IF NOT EXISTS `ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episodeid` (`episodeid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
`dt` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

--
-- Table structure for table `requests`
--

CREATE TABLE IF NOT EXISTS `requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`request_date` datetime NOT NULL,
`message` text NOT NULL,
`response` text NOT NULL,
`status` tinyint(4) NOT NULL,
`votes` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `request_votes`
--

CREATE TABLE IF NOT EXISTS `request_votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`vote_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `request_id` (`request_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `value`) VALUES
(1, 'default_language', 'en'),
(2, 'maxtvperpage', '50'),
(3, 'maxmoviesperpage', '50'),
(4, 'countdown_free', '30'),
(5, 'countdown_user', '0'),
(6, 'seo_links', '1'),
(7, 'smart_bar', '0');

-- --------------------------------------------------------

--
-- Table structure for table `shows`
--

CREATE TABLE IF NOT EXISTS `shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`thumbnail` varchar(120) NOT NULL,
`permalink` varchar(255) NOT NULL,
`sidereel_url` varchar(255) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`type` tinyint(4) NOT NULL,
`featured` tinyint(4) NOT NULL DEFAULT '0',
`last_episode` datetime NOT NULL,
`imdb_rating` float NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `title` (`title`),
KEY `featured` (`featured`),
KEY `last_episode` (`last_episode`),
KEY `imdb_id` (`imdb_id`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `similar_movies`
--

CREATE TABLE IF NOT EXISTS `similar_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie1` int(11) NOT NULL,
`movie2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie1` (`movie1`),
KEY `movie2` (`movie2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `similar_shows`
--

CREATE TABLE IF NOT EXISTS `similar_shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show1` int(11) NOT NULL,
`show2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `show1` (`show1`),
KEY `show2` (`show2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `submitted_links`
--

CREATE TABLE IF NOT EXISTS `submitted_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`link` varchar(255) NOT NULL,
`language` varchar(10) NOT NULL,
`date_submitted` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `type` (`type`),
KEY `imdb_id` (`imdb_id`),
KEY `season` (`season`),
KEY `episode` (`episode`),
KEY `language` (`language`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tv_submits`
--

CREATE TABLE IF NOT EXISTS `tv_submits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`link` varchar(255) NOT NULL,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tv_tags`
--

CREATE TABLE IF NOT EXISTS `tv_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tv_tags_join`
--

CREATE TABLE IF NOT EXISTS `tv_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`show_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `show_id` (`show_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL,
`password` varchar(32) NOT NULL,
`email` varchar(150) NOT NULL,
`fb_id` bigint(20) NOT NULL,
`fb_session` varchar(200) NOT NULL,
`avatar` varchar(100) NOT NULL,
`notify_favorite` tinyint(4) NOT NULL DEFAULT '1',
`notify_new` tinyint(4) NOT NULL DEFAULT '1',
`language` varchar(2) NOT NULL DEFAULT 'hu',
`country` varchar(20) NOT NULL,
`dob_day` int(2) NOT NULL,
`dob_month` varchar(18) NOT NULL,
`dob_year` int(4) NOT NULL,
`gender` varchar(7) NOT NULL,
`bio` varchar(500) NOT NULL,
`admin` tinyint(1) DEFAULT '0',
`guest` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `notify_favorite` (`notify_favorite`),
KEY `notify_new` (`notify_new`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `fb_id` (`fb_id`),
KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `fb_id`, `fb_session`, `avatar`, `notify_favorite`, `notify_new`, `language`, `country`, `dob_day`, `dob_month`, `dob_year`, `gender`, `bio`, `admin`, `guest`) VALUES
(1, 'Catfish', '3c7cc88f70aea29d160b141e57997ee1', 'franselstadt@outlook.com', 0, '', '', 1, 1, 'en', 'South Africa', 1, 'September', 1995, 'Male', '', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `votes`
--

CREATE TABLE IF NOT EXISTS `votes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

-- --------------------------------------------------------

--
-- Table structure for table `watches`
--

CREATE TABLE IF NOT EXISTS `watches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!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 */;