Hey guys been ages since I used v3 and I am trying to add categories but it seems to not of worked.
Code:
--
-- Database: `u232`
--
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cat_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No Description',
`parent_id` mediumint(5) NOT NULL DEFAULT '-1',
`tabletype` tinyint(2) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=25 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) VALUES
(17, 'TV/x264', '', 'No Description', 2, 1),
(16, 'TV/Packs', '', 'No Description', 2, 1),
(15, 'TV/480p', '', 'No Description', 2, 1),
(11, 'Movies/Web-DL', '', 'No Description', 3, 2),
(12, 'Movies/x265', '', 'No Description', 3, 2),
(13, 'Movies/Xvid', '', 'No Description', 3, 2),
(14, 'TV', '', 'No Description', -1, 1),
(10, 'Movies/Packs', '', 'No Description', 3, 2),
(9, 'Movies/Bluray', '', 'No Description', 3, 2),
(5, 'Movies/Cam', '', 'No Description', 3, 2),
(1, 'Movies', '', 'No Description', -1, 2),
(2, 'Movies/3D', '', 'No Description', 3, 2),
(3, 'Movies/480p', '', 'No Description', 3, 2),
(4, 'Movies/4k', '', 'No Description', 3, 2),
(18, 'TV/Web-DL', '', 'No Description', 2, 1),
(19, 'Music', '', 'No Description', -1, 4),
(20, 'Music/FLAC', '', 'No Description', 4, 4),
(21, 'Music/MP3', 'cat_music.png', 'No Description', 4, 4),
(22, 'Music/Packs', 'cat_music.png', 'No Description', 4, 4),
(23, 'eBooks', '', 'No Description', -1, 3),
(24, 'Comics', '', 'No Description', 13, 3);