phpwebsite-comm-cvs-commits

[Verdon V. <ve...@us...>]

Update of /cvsroot/phpwebsite-comm/modules/podcaster/boost
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14691/boost

Modified Files:
	uninstall.php update.php 
Added Files:
	sql_update_105.sql 
Log Message:
getting ready for 1.0.5 itunes cats changes

Index: uninstall.php
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/podcaster/boost/uninstall.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** uninstall.php	2 Jan 2008 04:24:01 -0000	1.2
--- uninstall.php	10 Jan 2008 00:37:37 -0000	1.3
***************
*** 38,41 ****
--- 38,42 ----
                  PHPWS_DB::dropTable('podcaster_channel');
                  PHPWS_DB::dropTable('podcaster_episode');
+                 PHPWS_DB::dropTable('podcaster_category');
                  $content[] = dgettext('podcaster', 'Podcaster tables dropped, no media to delete.');
                  return true;
***************
*** 55,58 ****
--- 56,60 ----
              PHPWS_DB::dropTable('podcaster_channel');
              PHPWS_DB::dropTable('podcaster_episode');
+             PHPWS_DB::dropTable('podcaster_category');
              $content[] = sprintf(dgettext('podcaster', 'Podcaster tables dropped, %s media file(s) deleted.'), $num);
              return true;
***************
*** 61,64 ****
--- 63,67 ----
              PHPWS_DB::dropTable('podcaster_channel');
              PHPWS_DB::dropTable('podcaster_episode');
+             PHPWS_DB::dropTable('podcaster_category');
              $content[] = dgettext('podcaster', 'Podcaster tables dropped.');
              return true;

--- NEW FILE: sql_update_105.sql ---
-- podcaster - phpwebsite module
-- @version $Id $
-- @author Verdon Vaillancourt <verdonv at users dot sourceforge dot net>

CREATE TABLE podcaster_category (
    id int NOT NULL default 0,
    title varchar(255) NOT NULL,
    parent_id int NOT NULL default 0,
    PRIMARY KEY  (id)
);

INSERT INTO podcaster_category (id, title, parent_id) VALUES 
(10, 'Arts', 0),
(11, 'Design', 10),
(12, 'Fashion & Beauty', 10),
(13, 'Food', 10),
(14, 'Literature', 10),
(15, 'Performing Arts', 10),
(16, 'Visual Arts', 10),
(20, 'Business', 0),
(21, 'Business News', 20),
(22, 'Careers', 20),
(23, 'Investing', 20),
(24, 'Management & Marketing', 20),
(25, 'Shopping', 20),
(30, 'Comedy', 0),
(40, 'Education', 0),
(41, 'Education Technology', 40),
(42, 'Higher Education', 40),
(43, 'K-12', 40),
(44, 'Language Courses', 40),
(45, 'Training', 40),
(50, 'Games & Hobbies', 0),
(51, 'Automotive', 50),
(52, 'Aviation', 50),
(53, 'Hobbies', 50),
(54, 'Other Games', 50),
(55, 'Video Games', 50),
(60, 'Government & Organizations', 0),
(61, 'Local', 60),
(62, 'National', 60),
(63, 'Non-Profit', 60),
(64, 'Regional', 60),
(70, 'Health', 0),
(71, 'Alternative Health', 70),
(72, 'Fitness & Nutrition', 70),
(73, 'Self-Help', 70),
(74, 'Sexuality', 70),
(80, 'Kids & Family', 0),
(90, 'Music', 0),
(100, 'News & Politics', 0),
(110, 'Religion & Spirituality', 0),
(111, 'Buddhism', 110),
(112, 'Christianity', 110),
(113, 'Hinduism', 110),
(114, 'Islam', 110),
(115, 'Judaism', 110),
(116, 'Other', 110),
(117, 'Spirituality', 110),
(120, 'Science & Medicine', 0),
(121, 'Medicine', 120),
(122, 'Natural Sciences', 120),
(123, 'Social Sciences', 120),
(130, 'Society & Culture', 0),
(131, 'History', 130),
(132, 'Personal Journals', 130),
(133, 'Philosophy', 130),
(134, 'Places & Travel', 130),
(140, 'Sports & Recreation', 0),
(141, 'Amateur', 140),
(142, 'College & High School', 140),
(143, 'Outdoor', 140),
(144, 'Professional', 140),
(150, 'Technology', 0),
(151, 'Gadgets', 150),
(152, 'Tech News', 150),
(153, 'Podcasting', 150),
(154, 'Software How-To', 150),
(160, 'TV & Film', 0);

Index: update.php
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/podcaster/boost/update.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** update.php	9 Jan 2008 21:41:10 -0000	1.9
--- update.php	10 Jan 2008 00:37:37 -0000	1.10
***************
*** 106,112 ****
  
      case version_compare($currentVersion, '1.0.5', '<'):
!         $content[] = '<pre>';
! 
!         $content[] = '1.0.5 changes
  ----------------
  + Added db and class for iTunes categories
--- 106,118 ----
  
      case version_compare($currentVersion, '1.0.5', '<'):
!         $result = PHPWS_DB::importFile(PHPWS_SOURCE_DIR . 'mod/podcaster/boost/sql_update_105.sql');
!         if (PEAR::isError($result)) {
!             PHPWS_Error::log($result);
!             $content[] = '+ Unable to import new iTunes categories table.';
!             return false;
!         } else {
!             $content[] = '<pre>';
!     
!             $content[] = '1.0.5 changes
  ----------------
  + Added db and class for iTunes categories
***************
*** 114,117 ****
--- 120,124 ----
  
  </pre>';
+         }