|
#1
|
|||
|
|||
Add Categories ??
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); |
#2
|
|||
|
|||
clear memcache and check again.
|
#3
|
|||
|
|||
I did and didn't work thanks for the help anyway.
|
#4
|
|||
|
|||
Be sure to have memcache delete after the insert query
__________________
Need HELP!? I can install:
|
#5
|
|||
|
|||
what you mean DND?
|
#6
|
|||
|
|||
in the function add_cat after the INSERT INTO query make sure to have
$mc1->delete_value('genrelist'); this is the delete memcache function after you insert something into the table and it will auto delete the cache so that the new categories it will appear this is the default version..i don't know how your code looks like
__________________
Need HELP!? I can install:
|
#7
|
|||
|
|||
I am using default u232 v3 from the github man.
sorter worked it out got the movies,tv,music to work just trying to get ebook cat to work plus add in games cat but it doesn't show but shows the cat example: movies -> blah tv -> blah music -> blah games -> nothing ( cats don't show ) even though they are in db ebooks -> nothing ( cats don't show ) even though they are in db |
Tags |
add , categories |
|
|