61.gif

Search (advanced search)
Use this Search form before posting, asking or make a new thread.
Tips: Use Quotation mark to search words (eg. "How To Make Money Online")

04-05-2014, 05:57 PM
Post: #11
RE:
CREATE TABLE IF NOT EXISTS `movies` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`year` varchar(255) DEFAULT NULL,
`length` varchar(255) DEFAULT NULL,
`views` bigint(10) DEFAULT '0',
`ratingp` bigint(10) DEFAULT '0',
`votes` bigint(10) DEFAULT '0',
`status` int(1) DEFAULT '1',
`keywords` text,
`stamp` bigint(10) DEFAULT '0',
`uid` bigint(10) DEFAULT '0',
`cat` bigint(10) DEFAULT '0',
`ratingm` bigint(10) DEFAULT '0',
`featured` int(1) DEFAULT '0',
`startwith` varchar(1) DEFAULT NULL,
`imdb` varchar(255) DEFAULT NULL,
`released` int(1) DEFAULT '1',
`releasingon` bigint(10) DEFAULT NULL,
`genre_str` text,
`slug` varchar(255) DEFAULT NULL,
`meta_title` varchar(255) DEFAULT NULL,
`meta_description` varchar(255) DEFAULT NULL,
`extra` text,
`release_date` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `NewIndex3` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11617 ;


CREATE TABLE IF NOT EXISTS `movie_genre` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`genre` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`movie`,`genre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55061 ;


CREATE TABLE IF NOT EXISTS `movie_group` (
`mgid` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`group` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`status` int(1) DEFAULT '1',
`uid` bigint(10) DEFAULT '0',
`votesp` bigint(10) DEFAULT '0',
`votesm` bigint(10) DEFAULT '0',
`ip` varchar(12) DEFAULT NULL,
PRIMARY KEY (`mgid`),
KEY `NewIndex1` (`movie`,`group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=112626 ;


CREATE TABLE IF NOT EXISTS `movie_group_links` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mgid` bigint(10) DEFAULT NULL,
`link` text,
`type` int(1) DEFAULT '1',
`status` int(10) DEFAULT '1',
`votesp` bigint(10) DEFAULT '0',
`stamp` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`ip` varchar(12) DEFAULT NULL,
`votesm` bigint(10) DEFAULT '0',
`downloads` bigint(10) DEFAULT '0',
`views` bigint(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=183112 ;


CREATE TABLE IF NOT EXISTS `movie_hits` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`uid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`hits` bigint(10) DEFAULT NULL,
`refrer` varchar(255) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;


CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mid`,`uid`),
KEY `NewIndex2` (`mid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `movie_sources` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`plug` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`tid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`tid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
04-07-2014, 04:35 PM
Post: #12
RE:
Everything with this script seems to be working great now that you found the table fixes, only thing I see not working is fetching movie information from IMDb. Other than that, all looks well!
04-08-2014, 09:04 AM
Post: #13
RE:
the instalion was done successfully , but i'm unable to add movie and the imdb grabber is not working , plus there's an empty space on the header
04-08-2014, 10:49 AM (This post was last modified: 04-08-2014 10:49 AM by _Evil_Minds_.)
Post: #14
RE:
I was able to add a movie fine but had to put everything manually because it wouldn't grab from IMDb, the empty header is there because that is where featured movies show up if you mark them featured from the admin panel.
04-08-2014, 06:29 PM
Post: #15
RE:
thanks for the share
53.gif
06-05-2014, 04:27 PM
Post: #16
RE:
If anyone can fix the IMDb grabber or has a working IMDb grabber file for this script, please share it.
07-30-2014, 03:55 PM
Post: #17
RE:
Hi any one can please help me with .htaccess for main site, i am unable to access the search
/search/genre
/search/playlists

urls are not working.
01-27-2015, 02:38 PM
Post: #18
RE:
Can anyone provide a fully working version of this script or at least help fix the admin panel IMDb Grabber?
01-27-2015, 03:49 PM
Post: #19
RE:
Cant Extract zip file please upload again
01-27-2015, 08:48 PM (This post was last modified: 01-27-2015 08:52 PM by _Evil_Minds_.)
Post: #20
RE:
Nothing appears to be wrong with the ZIP file.

Here is a new link for you anyway: http://www18.zippyshare.com/v/MzU0cFHx/file.html
72.gif




54.gif