[Phpgroupware-cvs] tts/setup/default_records.inc.php, 1.3

[nomail]

Update of /tts/setup
Modified Files:
        Branch: 
          default_records.inc.php

date: 2004/12/14 20:03:03;  author: fipsfuchs;  state: Exp;  lines: +45 -19

Log Message:
code review
=====================================================================
Index: tts/setup/default_records.inc.php
diff -u tts/setup/default_records.inc.php:1.2 
tts/setup/default_records.inc.php:1.3
--- tts/setup/default_records.inc.php:1.2       Mon Oct 11 09:43:14 2004
+++ tts/setup/default_records.inc.php   Tue Dec 14 20:03:03 2004
@@ -10,8 +10,17 @@
        
\**************************************************************************/
        /* $Id$ */
 
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. " values(0,0,0,-1,'public','tts','Platform','Global category for 
tts','platform')",__LINE__,__FILE__);
+       $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_name from 
phpgw_categories where cat_appname='tts'",__LINE__,__FILE__);
+       while($GLOBALS['phpgw_setup']->oProc->next_record())
+       {
+               $exist_cat_names[] = 
$GLOBALS['phpgw_setup']->oProc->f('cat_name');
+       }
+
+       if(!in_array('Platform', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . " values(0,0,0,-1,'public','tts','Platform','Global category for 
tts','platform')",__LINE__,__FILE__);
+       }
 
        $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_id from 
phpgw_categories where cat_name='Platform' and cat_owner=-1 and 
cat_appname='tts'",__LINE__,__FILE__);
        if($GLOBALS['phpgw_setup']->oProc->next_record())
@@ -22,18 +31,29 @@
 
        $GLOBALS['phpgw_setup']->oProc->query('UPDATE phpgw_categories set 
cat_main=' . $main . ' where cat_id=' . $main,__LINE__,__FILE__);
 
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Linux','Global 
category for tts','platform')",__LINE__,__FILE__);
-
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Windows','Global 
category for tts','platform')",__LINE__,__FILE__);
-
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','MacOS','Global 
category for tts','platform')",__LINE__,__FILE__);
-
+       if(!in_array('Linux', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . ' values('. $main . ',' . $main . 
",1,-1,'public','tts','Linux','Global category for 
tts','platform')",__LINE__,__FILE__);
+       }
+       
+       if(!in_array('Windows', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . ' values('. $main . ',' . $main . 
",1,-1,'public','tts','Windows','Global category for 
tts','platform')",__LINE__,__FILE__);
+       }
+       
+       if(!in_array('MacOS', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . ' values('. $main . ',' . $main . 
",1,-1,'public','tts','MacOS','Global category for 
tts','platform')",__LINE__,__FILE__);
+       }
 
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. " values(0,0,0,-1,'public','tts','Type','Global category for 
tts','type')",__LINE__,__FILE__);
+       if(!in_array('Type', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . " values(0,0,0,-1,'public','tts','Type','Global category for 
tts','type')",__LINE__,__FILE__);
+       }
 
        $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_id from 
phpgw_categories where cat_name='Type' and cat_owner=-1 and 
cat_appname='tts'",__LINE__,__FILE__);
        if($GLOBALS['phpgw_setup']->oProc->next_record())
@@ -44,8 +64,14 @@
 
        $GLOBALS['phpgw_setup']->oProc->query('UPDATE phpgw_categories set 
cat_main=' . $main . ' where cat_id=' . $main,__LINE__,__FILE__);
 
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Bug','Global 
category for tts','type')",__LINE__,__FILE__);
-
-       $GLOBALS['phpgw_setup']->oProc->query('INSERT into phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-                                                                               
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Feature 
Request','Global category for tts','type')",__LINE__,__FILE__);
+       if(!in_array('Bug', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . ' values('. $main . ',' . $main . ",1,-1,'public','tts','Bug','Global 
category for tts','type')",__LINE__,__FILE__);
+       }
+       
+       if(!in_array('Feature Request', $exist_cat_names))
+       {
+               $GLOBALS['phpgw_setup']->oProc->query('INSERT into 
phpgw_categories 
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
+                                                                               
        . ' values('. $main . ',' . $main . ",1,-1,'public','tts','Feature 
Request','Global category for tts','type')",__LINE__,__FILE__);
+       }