Source for file update_T_CMS_PAGESTATE.phpinc

Documentation is available at update_T_CMS_PAGESTATE.phpinc

  1. <?php
  2. /**
  3.   * upgrade T_CMS_PAGESTATE
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms
  7.   * @category   versioncheck
  8.   *
  9.   * @author     Peter Krebs <pitlinz@users.sourceforge.net>
  10.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  11.   *
  12.   * @version pk-08-06-15
  13.   *
  14.   ***/
  15.  
  16. if (!class_exists('OCSP_GROUPTREE'))
  17. {
  18.     require_once __OCSP_PHPINCPATH__ . "user" . _OCSP_DIRSEP_ . "OCSP_GROUPTREE.phpclass"; 
  19. }
  20.  
  21. $query="SELECT * FROM T_SYS_TABLES WHERE TBL_NAME ='T_CMS_PAGESTATE' ORDER BY TBL_VERSION DESC";
  22. if (!$tblVer=$GLOBALS['USRDB']->quickQuery($query)) {
  23.     $tblVer['TBL_NAME']="T_CMS_PAGESTATE";
  24.     $tblVer['TBL_VERSION']=0;
  25.     $tblVer['TBL_SELECT']=0;
  26.     $tblVer['TBL_INSERT']=50;
  27.     $tblVer['TBL_UPDATE']=75;
  28.     $tblVer['TBL_DELETE']=100;
  29.     $tblVer['TBL_LASTCHANGE']=NULL;
  30. }
  31.  
  32. if (!function_exists('DB_UPDATE_execCmd'))
  33. {
  34.     require __OCSP_PHPINCPATH__ ."db/update/functions_mySQL.phpinc";
  35. }
  36.  
  37. if (intval($tblVer['TBL_VERSION']) < 10) {
  38.     DB_UPDATE_execCmd("CREATE TABLE IF NOT EXISTS T_CMS_PAGESTATE (
  39.             PAS_ID             int(11) NOT NULL,
  40.             PAS_NAME        varchar(64)  collate utf8_general_ci NOT NULL,
  41.             PAS_ICON        varchar(128) NULL,
  42.             
  43.             PAS_SHOW        tinyint(1) NOT NULL default '0',
  44.             PAS_DIRECTSHOW    tinyint(1) NOT NULL default '0', 
  45.                        
  46.             PAS_GROUP        int(11) NOT NULL default '1',            
  47.             PAS_DELETEGRP    int(11) NOT NULL default '1',
  48.                         
  49.             PRIMARY KEY (PAS_ID)
  50.             
  51.         ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
  52.     ");
  53.  
  54.     $arr_values[1]=array(
  55.         'NAME'=>'in Bearbeitung',
  56.         'SHOW'=>0,
  57.         'DIRECTSHOW'=>0,        /* <pk-04-12-21/> */
  58.         'DELETEGRP' => _OCSP_GROUP_CMSAUTHOR_, /* <pk-05-12-22/> */
  59.         'ICON'=>"part-killustrator.gif",
  60.         'GROUP'=>_OCSP_GROUP_CMSAUTHOR_
  61.     );
  62.  
  63.     $arr_values[2]=array(
  64.         'NAME'=>'abgelehnt',
  65.         'SHOW'=>0,
  66.         'DIRECTSHOW'=>0,        /* <pk-04-12-21/> */
  67.         'DELETEGRP' =>_OCSP_GROUP_CMSAUTHOR_,  /* <pk-05-12-22/> */
  68.         'ICON'=>"stop_hand.gif",
  69.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  70.     );
  71.  
  72.     $arr_values[3]=array(
  73.         'NAME'=>'freigeschalten',
  74.         'SHOW'=>1,
  75.         'DIRECTSHOW'=>1,             /* <pk-04-12-21/> */
  76.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_,     /* <pk-05-12-22/> */
  77.         'ICON'=>"online.gif",
  78.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  79.     );
  80.  
  81.     $arr_values[4]=array(
  82.         'NAME'=>'no auto show',
  83.         'SHOW'=>0,
  84.         'DIRECTSHOW'=>1,         /* <pk-04-12-21/> */
  85.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_, /* <pk-05-12-22/> */
  86.         'ICON'=>'compfile.gif',
  87.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  88.     );
  89.  
  90.     $arr_values[5]=array(
  91.         'NAME'=>'nach Datensatz Einfgen',
  92.         'SHOW'=>0,
  93.         'DIRECTSHOW'=>1,         /* <pk-04-12-21/> */
  94.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_, /* <pk-05-12-22/> */
  95.         'ICON'=>'rebuild.gif',
  96.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  97.     );
  98.  
  99.     $arr_values[6]=array(
  100.         'NAME'=>'nach Datensatz &Auml;nderung',
  101.         'SHOW'=>0,
  102.         'DIRECTSHOW'=>1,         /* <pk-04-12-21/> */
  103.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_, /* <pk-05-12-22/> */
  104.         'ICON'=>'rebuild.gif',
  105.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  106.     );
  107.  
  108.     /* <pk-05-03-16> */
  109.     $arr_values[7]=array(
  110.         'NAME'=>'Datensatz Einf&uuml;gen',
  111.         'SHOW'=>0,
  112.         'DIRECTSHOW'=>1,
  113.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_, /* <pk-05-12-22/> */
  114.         'ICON'=>'filenew.gif',
  115.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  116.     );
  117.     
  118.     $arr_values[8]=array(
  119.         'NAME'=>'Datensatz &auml;ndern',
  120.         'SHOW'=>0,
  121.         'DIRECTSHOW'=>1,
  122.         'DELETEGRP' => _OCSP_GROUP_CMSEDITOR_, /* <pk-05-12-22/> */
  123.         'ICON'=>'edit.gif',
  124.         'GROUP'=>_OCSP_GROUP_CMSEDITOR_
  125.     );
  126.  
  127.     foreach($arr_values as $int_id => $arr_data)
  128.     {
  129.         $str_cmd = "INSERT INTO T_CMS_PAGESTATE VALUES(";
  130.         $str_cmd.= $int_id . ",'{$arr_data['NAME']}','{$arr_data['ICON']}',";
  131.         $str_cmd.= intval($arr_data['SHOW']) . "," . intval($arr_data['DIRECTSHOW']) .",";
  132.         $str_cmd.= intval($arr_data['GROUP']) . "," . intval($arr_data['DELETEGRP']) . ")";
  133.         
  134.         DB_UPDATE_execCmd($str_cmd);
  135.     }
  136.     
  137.     
  138.     $tblVer['TBL_VERSION']=10;
  139. } else {
  140.     DB_UPDATE_backupTable("T_CMS_PAGESTATE");
  141. }
  142.  
  143.  
  144. DB_UPDATE_setVersion($tblVer);
  145.  
  146. ?>

Documentation generated on Thu, 08 Jan 2009 17:49:04 +0100 by phpDocumentor 1.4.0a2