Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > Project U-232
Reply
  #1  
Old 19th October 2018, 10:24
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Banned
 
Join Date: Jul 2013
P2P
Posts: 410
Default 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);
Reply With Quote
  #2  
Old 19th October 2018, 11:45
Ladbexy's Avatar
Ladbexy Ladbexy is offline
Senior Member
 
Join Date: Oct 2010
P2P
Posts: 24
Default
clear memcache and check again.
Reply With Quote
  #3  
Old 19th October 2018, 15:38
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Banned
 
Join Date: Jul 2013
P2P
Posts: 410
Default
I did and didn't work thanks for the help anyway.
Reply With Quote
  #4  
Old 19th October 2018, 17:23
DND's Avatar
DND DND is offline
VIP
 
Join Date: Dec 2008
Posts: 1,237
Default
Be sure to have memcache delete after the insert query
__________________
Need HELP!? I can install:

  1. Server/VPS (Debian,CentOS,Ubuntu,Fedora, FreeBSD) Optimization and ... + Modules
  2. Webserver Windows/Linux (Apache/Lighttpd/Nginx/Mysql/PhpMyAdmin/SSL) Optimization and ... + Modules
  3. Seedbox Windows/Linux (uTorrent,rTorrent,libTorrent,ruTorrent) + Modules
  4. Multiple source code engines
  5. Linux Server Administration (security, cryptography/encryption, proxy, load balancer, custom ddos firewall)
Reply With Quote
  #5  
Old 19th October 2018, 17:27
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Banned
 
Join Date: Jul 2013
P2P
Posts: 410
Default
what you mean DND?
Reply With Quote
  #6  
Old 19th October 2018, 19:24
DND's Avatar
DND DND is offline
VIP
 
Join Date: Dec 2008
Posts: 1,237
Default
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:

  1. Server/VPS (Debian,CentOS,Ubuntu,Fedora, FreeBSD) Optimization and ... + Modules
  2. Webserver Windows/Linux (Apache/Lighttpd/Nginx/Mysql/PhpMyAdmin/SSL) Optimization and ... + Modules
  3. Seedbox Windows/Linux (uTorrent,rTorrent,libTorrent,ruTorrent) + Modules
  4. Multiple source code engines
  5. Linux Server Administration (security, cryptography/encryption, proxy, load balancer, custom ddos firewall)
Reply With Quote
  #7  
Old 19th October 2018, 23:42
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Banned
 
Join Date: Jul 2013
P2P
Posts: 410
Default
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
Reply With Quote
Reply

Tags
add , categories

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 12:48. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.