Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Project U-232 (http://www.bvlist.com/forumdisplay.php?f=80)
-   -   Add Categories ?? (http://www.bvlist.com/showthread.php?t=11794)

BamBam0077 19th October 2018 10:24
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);

Ladbexy 19th October 2018 11:45
clear memcache and check again.

BamBam0077 19th October 2018 15:38
I did and didn't work :wallbash: thanks for the help anyway.

DND 19th October 2018 17:23
Be sure to have memcache delete after the insert query

BamBam0077 19th October 2018 17:27
what you mean DND? :friend:

DND 19th October 2018 19:24
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

BamBam0077 19th October 2018 23:42
I am using default u232 v3 from the github man. :ok:
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


All times are GMT +2. The time now is 16:49.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.