Source for file update_T_DBMS_FIELDDESC.phpinc

Documentation is available at update_T_DBMS_FIELDDESC.phpinc

  1. <?php
  2. /**
  3.   * upgrade table T_CMS_TMPL_CHAPTER
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms
  7.   * @category   versioncheck
  8.   *
  9.   * @author     Peter Krebs <p.krebs@wpus.at>
  10.   * @copyright  (c) 2002-2005 by WURM & Parnter Unternehmensservice GmbH
  11.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  12.   *
  13.   * @version pk-05-09-30
  14.   * @version pk-05-11-14
  15.   ***/
  16.  
  17. $query="SELECT * FROM T_SYS_TABLES WHERE TBL_NAME ='T_DBMS_FIELDDESC' ORDER BY TBL_VERSION DESC";
  18. if (!$tblVer=OCSP_OBJ::defaultWriteDBObj()->quickQuery($query)) {
  19.     $tblVer['TBL_NAME']="T_DBMS_FIELDDESC";
  20.     $tblVer['TBL_VERSION']=0;
  21.     $tblVer['TBL_SELECT']=0;
  22.     $tblVer['TBL_INSERT']=100;
  23.     $tblVer['TBL_UPDATE']=100;
  24.     $tblVer['TBL_DELETE']=100;
  25.     $tblVer['TBL_LASTCHANGE']=NULL;
  26. }
  27.  
  28. require_once __OCSP_PHPINCPATH__."db/update/functions_mySQL.phpinc";
  29. DB_UPDATE_backupTable("T_DBMS_FIELDDESC");
  30.  
  31. if (intval($tblVer['TBL_VERSION']) < 12) {
  32.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBMS_FORMSELECT'",0)) {
  33.         $a_fldArr=array(
  34.             'FLD_TYPE'      => 'int',
  35.             'FLD_CLASS'     => 'DBMS_FIELD_DBMS_FORMSELECT',
  36.             'FLD_CLASS_SRC' => 'db/frmClasses/DBMS_FIELD_DBMS_FORMSELECT.phpclass',
  37.             'FLD_SELNAME'   => 'DBMS Formular',
  38.             'FLD_ALWAYSINC'     => 0,
  39.             'FLD_SYSTEM'    => 'OCSP'
  40.         );
  41.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  42.     }
  43.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBMS_FORMFIELDSELECT'",0)) {
  44.         $a_fldArr=array(
  45.             'FLD_TYPE'      => 'varchar',
  46.             'FLD_CLASS'     => 'DBMS_FIELD_DBMS_FORMFIELDSELECT',
  47.             'FLD_CLASS_SRC' => 'db/frmClasses/DBMS_FIELD_DBMS_FORMFIELDSELECT.phpclass',
  48.             'FLD_SELNAME'   => 'DBMS Formular Feld',
  49.             'FLD_ALWAYSINC'     => 0,
  50.             'FLD_SYSTEM'    => 'OCSP'
  51.         );
  52.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  53.     }
  54.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBMS_FORMWHERE'",0)) {
  55.         $a_fldArr=array(
  56.             'FLD_TYPE'      => 'text',
  57.             'FLD_CLASS'     => 'DBMS_FIELD_DBMS_FORMWHERE',
  58.             'FLD_CLASS_SRC' => 'db/frmClasses/DBMS_FIELD_DBMS_FORMWHERE.phpclass',
  59.             'FLD_SELNAME'   => 'DBMS Formular Where',
  60.             'FLD_ALWAYSINC'     => 0,
  61.             'FLD_SYSTEM'    => 'OCSP'
  62.         );
  63.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  64.     }
  65.     $tblVer['TBL_VERSION'] = 12;
  66. }
  67.  
  68. if (intval($tblVer['TBL_VERSION']) < 13) {
  69.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_MEDIAFILE_SELID'",0)) {
  70.         $a_fldArr=array(
  71.             'FLD_TYPE'      => 'int',
  72.             'FLD_CLASS'     => 'DBMS_FIELD_MEDIAFILE_SELID',
  73.             'FLD_CLASS_SRC' => 'db/frmClasses/DBMS_FIELD_MEDIAFILE_SELID.phpclass',
  74.             'FLD_SELNAME'   => 'MEDIA File ID Select',
  75.             'FLD_ALWAYSINC'     => 0,
  76.             'FLD_SYSTEM'    => 'OCSP'
  77.         );
  78.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  79.     }
  80.     $tblVer['TBL_VERSION'] = 13;
  81. }
  82.  
  83. if (intval($tblVer['TBL_VERSION']) < 14) {
  84.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CLI_TYPESELECT'",0)) {
  85.         DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FIELDDESC ADD FLD_DEFAULTCOL INT NOT NULL DEFAULT '';");
  86.         $a_fldArr=array(
  87.             'FLD_TYPE'          => 'int',
  88.             'FLD_CLASS'         => 'DBMS_FIELD_CLI_TYPESELECT',
  89.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CLI_TYPESELECT.phpclass',
  90.             'FLD_SELNAME'       => 'KUNDE - Kundenart Select',
  91.             'FLD_SYSTEM'        => 'OCSP',
  92.             'FLD_ALWAYSINC'     => 0,
  93.             'FLD_DEFAULTCOL'    => 'CTY_ID'
  94.         );
  95.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  96.     }
  97.  
  98.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CST_TYPESELECT'",0)) {
  99.         $a_fldArr=array(
  100.             'FLD_TYPE'          => 'int',
  101.             'FLD_CLASS'         => 'DBMS_FIELD_CST_TYPESELECT',
  102.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CST_TYPESELECT.phpclass',
  103.             'FLD_SELNAME'       => 'KUNDE - Member Type Select',
  104.             'FLD_SYSTEM'        => 'OCSP',
  105.             'FLD_ALWAYSINC'     => 0,
  106.             'FLD_DEFAULTCOL'    => 'CSTTYPE_ID'
  107.         );
  108.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  109.     }
  110.  
  111.     $tblVer['TBL_VERSION'] = 14;
  112. }
  113.  
  114. if (intval($tblVer['TBL_VERSION']) < 15) {
  115.     // <pk-05-11-14>
  116.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CMS_PAGECLASSSELECT'",0)) {
  117.         $a_fldArr=array(
  118.             'FLD_TYPE'          => 'varchar',
  119.             'FLD_CLASS'         => 'DBMS_FIELD_CMS_PAGECLASSSELECT',
  120.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CMS_PAGECLASSSELECT.phpclass',
  121.             'FLD_SELNAME'       => 'CMS - Seitenart (Class)',
  122.             'FLD_SYSTEM'        => 'OCSP',
  123.             'FLD_ALWAYSINC'     => 0,
  124.             'FLD_DEFAULTCOL'    => 'PAG_OBJCLASS'
  125.         );
  126.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  127.     }
  128.     $tblVer['TBL_VERSION'] = 15;
  129.     // </pk-05-11-14>
  130. }
  131. if (intval($tblVer['TBL_VERSION']) < 16) {
  132.     // <pk-05-11-14>
  133.  
  134.     DB_UPDATE_execScript(dirname(__FILE__)."/data/T_DBMS_FIELDDESC.mysql"); // <pk-05-12-02 />
  135.  
  136.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CMS_MENUCLASSSELECT'",0)) {
  137.         $a_fldArr=array(
  138.             'FLD_TYPE'          => 'varchar',
  139.             'FLD_CLASS'         => 'DBMS_FIELD_CMS_MENUCLASSSELECT',
  140.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CMS_MENUCLASSSELECT.phpclass',
  141.             'FLD_SELNAME'       => 'CMS - Menuart (Class)',
  142.             'FLD_SYSTEM'        => 'OCSP',
  143.             'FLD_ALWAYSINC'     => 0,
  144.             'FLD_DEFAULTCOL'    => 'MEN_OBJCLASS'
  145.         );
  146.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  147.     }
  148.     $tblVer['TBL_VERSION'] = 16;
  149.     // </pk-05-11-14>
  150. }
  151.  
  152. if (intval($tblVer['TBL_VERSION']) < 17) {
  153.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CLI_SEXLOOKUP'",0)) {
  154.         $a_fldArr=array(
  155.             'FLD_TYPE'          => 'int',
  156.             'FLD_CLASS'         => 'DBMS_FIELD_CLI_SEXLOOKUP',
  157.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CLI_SEXLOOKUP.phpclass',
  158.             'FLD_SELNAME'       => 'KUNDE - Anrede',
  159.             'FLD_SYSTEM'        => 'OCSP',
  160.             'FLD_ALWAYSINC'     => 0,
  161.             'FLD_DEFAULTCOL'    => 'CLI_SEX'
  162.         );
  163.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  164.     }
  165.     $tblVer['TBL_VERSION'] = 17;
  166. }
  167.  
  168. if (intval($tblVer['TBL_VERSION']) < 18) {
  169.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_LAYOUT_CHKBOXGRP'",0)) {
  170.         $a_fldArr=array(
  171.             'FLD_TYPE'          => 'layout',
  172.             'FLD_CLASS'         => 'DBMS_FIELD_LAYOUT_CHKBOXGRP',
  173.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_LAYOUT_CHKBOXGRP.phpclass',
  174.             'FLD_SELNAME'       => 'Layout Checkbox Gruppe',
  175.             'FLD_ALWAYSINC'     => 0,
  176.             'FLD_SYSTEM'        => 'OCSP'
  177.         );
  178.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  179.     }
  180.     $tblVer['TBL_VERSION'] = 18;
  181. }
  182.  
  183. if (intval($tblVer['TBL_VERSION']) < 19) { // <pk-06-01-17 />
  184.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_ADRSELECT'",0)) {
  185.         $a_fldArr=array(
  186.             'FLD_TYPE'          => 'int',
  187.             'FLD_CLASS'         => 'DBMS_FIELD_ADRSELECT',
  188.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_ADRSELECT.phpclass',
  189.             'FLD_SELNAME'       => 'KUNDE - Adresse',
  190.             'FLD_ALWAYSINC'     => 0,
  191.             'FLD_SYSTEM'        => 'OCSP'
  192.         );
  193.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  194.     }
  195.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_CLISELECT'",0)) {
  196.         $a_fldArr=array(
  197.             'FLD_TYPE'          => 'int',
  198.             'FLD_CLASS'         => 'DBMS_FIELD_CLISELECT',
  199.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_CLISELECT.phpclass',
  200.             'FLD_SELNAME'       => 'KUNDE - Auswahlliste',
  201.             'FLD_ALWAYSINC'     => 0,
  202.             'FLD_SYSTEM'        => 'OCSP'
  203.         );
  204.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  205.     }
  206.  
  207.  
  208.     $tblVer['TBL_VERSION'] = 19;
  209. }
  210.  
  211. if (intval($tblVer['TBL_VERSION']) < 20) { // <pk-06-02-01 />
  212.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_PRO_PGPSELECT'",0)) {
  213.         $a_fldArr=array(
  214.             'FLD_TYPE'          => 'int',
  215.             'FLD_CLASS'         => 'DBMS_FIELD_PRO_PGPSELECT',
  216.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_PRO_PGPSELECT.phpclass',
  217.             'FLD_SELNAME'       => 'PROD. - Gruppe',
  218.             'FLD_ALWAYSINC'     => 0,
  219.             'FLD_SYSTEM'        => 'OCSP'
  220.         );
  221.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  222.     }
  223.  
  224.     $tblVer['TBL_VERSION'] = 20;
  225. }
  226.  
  227. if (intval($tblVer['TBL_VERSION']) < 21) { // <pk-06-02-06 />
  228.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBCOLSELECTLIST'",0)) {
  229.         $a_fldArr=array(
  230.             'FLD_TYPE'          => 'int',
  231.             'FLD_CLASS'         => 'DBMS_FIELD_DBCOLSELECTLIST',
  232.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_DBCOLSELECTLIST.phpclass',
  233.             'FLD_SELNAME'       => 'DB - Columns',
  234.             'FLD_ALWAYSINC'     => 0,
  235.             'FLD_SYSTEM'        => 'OCSP'
  236.         );
  237.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  238.     }
  239.  
  240.     $tblVer['TBL_VERSION'] = 21;
  241. }
  242.  
  243. if (intval($tblVer['TBL_VERSION']) < 22) { // <pk-06-02-10 />
  244.     DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FIELDDESC ADD FLD_DEFAULTFOR VARCHAR(255)");
  245.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_PRO_AUDIENCE'",0)) {
  246.         $a_fldArr=array(
  247.             'FLD_TYPE'          => 'string',
  248.             'FLD_CLASS'         => 'DBMS_FIELD_PRO_AUDIENCE',
  249.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_PRO_AUDIENCE.phpclass',
  250.             'FLD_SELNAME'       => 'Zeilgruppenauswahl',
  251.             'FLD_ALWAYSINC'     => 0,
  252.             'FLD_SYSTEM'        => 'OCSP',
  253.             'FLD_DEFAULTFOR'    => 'PRO_AUDIENCE_LIST CLI_AUDIENCE_LIST'
  254.         );
  255.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  256.     }
  257.  
  258.     $tblVer['TBL_VERSION'] = 22;
  259. }
  260.  
  261. if (intval($tblVer['TBL_VERSION']) < 23) { // <pk-06-02-16 />
  262.     DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FIELDDESC ADD FLD_DEFAULTFOR VARCHAR(255)");
  263.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBLOOKUPMULTISELECTLIST'",0)) {
  264.         $a_fldArr=array(
  265.             'FLD_TYPE'          => 'string',
  266.             'FLD_CLASS'         => 'DBMS_FIELD_DBLOOKUPMULTISELECTLIST',
  267.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_DBLOOKUPMULTISELECTLIST.phpclass',
  268.             'FLD_SELNAME'       => 'DB Multi Selectauswahl',
  269.             'FLD_ALWAYSINC'     => 0,
  270.             'FLD_SYSTEM'        => 'OCSP',
  271.             'FLD_DEFAULTFOR'    => 'CHA_SHOWMODE'
  272.         );
  273.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  274.     }
  275.  
  276.     $tblVer['TBL_VERSION'] = 23;
  277. }
  278.  
  279. if (intval($tblVer['TBL_VERSION']) < 24) { // <pk-06-04-07 />
  280.     DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FIELDDESC ADD FLD_DEFAULTFOR VARCHAR(255)");
  281.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_FLOATFORMAT'",0)) {
  282.         $a_fldArr=array(
  283.             'FLD_TYPE'          => 'real',
  284.             'FLD_CLASS'         => 'DBMS_FIELD_FLOATFORMAT',
  285.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_FLOATFORMAT.phpclass',
  286.             'FLD_SELNAME'       => 'Zahl (1000er)',
  287.             'FLD_ALWAYSINC'     => 0,
  288.             'FLD_SYSTEM'        => 'OCSP',
  289.             'FLD_DEFAULTFOR'    => ''
  290.         );
  291.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  292.     }
  293.  
  294.     $tblVer['TBL_VERSION'] = 24;
  295. }
  296. if (intval($tblVer['TBL_VERSION']) < 25) { // <pk-06-04-27 />
  297.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBLOOKUPPOPUPSELECT'",0)) {
  298.         $a_fldArr=array(
  299.             'FLD_TYPE'          => 'any',
  300.             'FLD_CLASS'         => 'DBMS_FIELD_DBLOOKUPPOPUPSELECT',
  301.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_DBLOOKUPPOPUPSELECT.phpclass',
  302.             'FLD_SELNAME'       => 'DB Lookup mit Popup',
  303.             'FLD_ALWAYSINC'     => 0,
  304.             'FLD_SYSTEM'        => 'OCSP',
  305.             'FLD_DEFAULTFOR'    => ''
  306.         );
  307.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  308.     }
  309.  
  310.     $tblVer['TBL_VERSION'] = 25;
  311. }
  312. if (intval($tblVer['TBL_VERSION']) < 26) { // <pk-06-07-21 />
  313.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DBMS_FORMFIELDOBJECT'",0)) {
  314.         $a_fldArr=array(
  315.             'FLD_TYPE'          => 'text',
  316.             'FLD_CLASS'         => 'DBMS_FIELD_DBMS_FORMFIELDOBJECT',
  317.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_DBMS_FORMFIELDOBJECT.phpclass',
  318.             'FLD_SELNAME'       => 'DBMS Formular Feld',
  319.             'FLD_ALWAYSINC'     => 0,
  320.             'FLD_SYSTEM'        => 'OCSP',
  321.             'FLD_DEFAULTFOR'    => ''
  322.         );
  323.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  324.     }
  325.  
  326.     $tblVer['TBL_VERSION'] = 26;
  327. }
  328. if (intval($tblVer['TBL_VERSION']) < 27) { // <pk-06-09-12 />
  329.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_LAYOUT_LINKBTTN'",0)) {
  330.         $a_fldArr=array(
  331.             'FLD_TYPE'          => 'layout',
  332.             'FLD_CLASS'         => 'DBMS_FIELD_LAYOUT_LINKBTTN',
  333.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_LAYOUT_LINKBTTN.phpclass',
  334.             'FLD_SELNAME'       => 'Layout LinkButton',
  335.             'FLD_ALWAYSINC'     => 0,
  336.             'FLD_SYSTEM'        => 'OCSP',
  337.             'FLD_DEFAULTFOR'    => ''
  338.         );
  339.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  340.     }
  341.     $tblVer['TBL_VERSION'] = 27;
  342. }
  343. if (intval($tblVer['TBL_VERSION']) < 28) { // <pk-07-05-21 />
  344.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_LAYOUT_FIELDSET'",0)) {
  345.         $a_fldArr=array(
  346.             'FLD_TYPE'          => 'layout',
  347.             'FLD_CLASS'         => 'DBMS_FIELD_LAYOUT_FIELDSET',
  348.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_LAYOUT_FIELDSET.phpclass',
  349.             'FLD_SELNAME'       => 'Layout Block (Fieldset)',
  350.             'FLD_ALWAYSINC'     => 0,
  351.             'FLD_SYSTEM'        => 'OCSP',
  352.             'FLD_DEFAULTFOR'    => ''
  353.         );
  354.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  355.     }
  356.     $tblVer['TBL_VERSION'] = 28;
  357. }
  358.  
  359. if (intval($tblVer['TBL_VERSION']) < 29) { // <pk-08-06-12 />
  360.     DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FIELDDESC ADD MOD_ID INT NOT NULL DEFAULT 0 AFTER FLD_SYSTEM");
  361.     $tblVer['TBL_VERSION'] = 29;
  362. }
  363.     
  364. if (intval($tblVer['TBL_VERSION']) < 30) { // <pk-08-06-14 />
  365.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_MODULESELECT'",0)) {
  366.         $a_fldArr=array(
  367.             'FLD_TYPE'          => 'int',
  368.             'FLD_CLASS'         => 'DBMS_FIELD_MODULESELECT',
  369.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_MODULESELECT.phpclass',
  370.             'FLD_SELNAME'       => 'Module Select',
  371.             'FLD_ALWAYSINC'     => 0,
  372.             'FLD_SYSTEM'        => 'OCSP',
  373.             'FLD_DEFAULTFOR'    => '',
  374.             'MOD_ID'            => '0'
  375.         );
  376.         $debug=True;
  377.         echoDebugLine(__FILE__,__LINE__,"debug on");
  378.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  379.         $debug=False;
  380.     }
  381.     $tblVer['TBL_VERSION'] = 30;
  382. }
  383.  
  384. if (intval($tblVer['TBL_VERSION']) < 31) { // <pk-08-10-07 />
  385.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_WYMEDITOR'",0)) {
  386.         $a_fldArr=array(
  387.             'FLD_TYPE'          => 'text',
  388.             'FLD_CLASS'         => 'DBMS_FIELD_WYMEDITOR',
  389.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_WYMEDITOR.phpclass',
  390.             'FLD_SELNAME'       => 'HTML WYMEditor',
  391.             'FLD_ALWAYSINC'     => 0,
  392.             'FLD_SYSTEM'        => 'OCSP',
  393.             'FLD_DEFAULTFOR'    => '',
  394.             'MOD_ID'            => '0'
  395.         );
  396.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  397.     }
  398.     $tblVer['TBL_VERSION'] = 31;
  399. }
  400.  
  401. if (intval($tblVer['TBL_VERSION']) < 32) { // <pk-08-11-03 />
  402.     if (!OCSP_OBJ::defaultWriteDBObj()->quickQuery("SELECT COUNT(*) FROM T_DBMS_FIELDDESC WHERE FLD_CLASS='DBMS_FIELD_DIRSELECTLIST'",0)) {
  403.         $a_fldArr=array(
  404.             'FLD_TYPE'          => 'string',
  405.             'FLD_CLASS'         => 'DBMS_FIELD_DIRSELECTLIST',
  406.             'FLD_CLASS_SRC'     => 'db/frmClasses/DBMS_FIELD_DIRSELECTLIST.phpclass',
  407.             'FLD_SELNAME'       => 'Verzeichnisauswahl',
  408.             'FLD_ALWAYSINC'     => 0,
  409.             'FLD_SYSTEM'        => 'OCSP',
  410.             'FLD_DEFAULTFOR'    => '',
  411.             'MOD_ID'            => '0'
  412.         );
  413.         OCSP_OBJ::defaultWriteDBObj()->replaceArray('T_DBMS_FIELDDESC',$a_fldArr,$debug);
  414.     }
  415.     $tblVer['TBL_VERSION'] = 32;
  416. }
  417.  
  418. // finaly remove the cache file
  419. pcf_require_class('OCSP_FORM',__OCSP_PHPINCPATH__."db/forms/OCSP_FORM.phpclass");
  420. OCSP_FORM::clearFieldClassDescCache();
  421.  
  422. DB_UPDATE_setVersion($tblVer);
  423.  
  424. ?>

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