Source for file update_T_CMS_CSSSTYLES.phpinc

Documentation is available at update_T_CMS_CSSSTYLES.phpinc

  1. <?php
  2. /**
  3.   * upgrade T_CMS_CSSSTYLES
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms
  7.   * @category   versioncheck
  8.   *
  9.   * @author     Peter Krebs <pitlinz@users.sourceforge.net>
  10.   *
  11.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  12.   *
  13.   * @version pk-03-12-12
  14.   * @version pk-05-06-22
  15.   * @version $Id: update_T_CMS_CSSSTYLES.phpinc,v 1.3 2008/06/03 15:46:18 pitlinz Exp $
  16.   */
  17.  
  18. $query="SELECT * FROM T_SYS_TABLES WHERE TBL_NAME ='T_CMS_CSSSTYLES' ORDER BY TBL_VERSION DESC";
  19. if (!$tblVer=$GLOBALS['USRDB']->quickQuery($query)) {
  20.     $tblVer['TBL_NAME']="T_CMS_CSSSTYLES";
  21.     $tblVer['TBL_VERSION']=0;
  22.     $tblVer['TBL_SELECT']=0;
  23.     $tblVer['TBL_INSERT']=50;
  24.     $tblVer['TBL_UPDATE']=75;
  25.     $tblVer['TBL_DELETE']=75;
  26.     $tblVer['TBL_LASTCHANGE']=NULL;
  27. }
  28.  
  29. require_once $GLOBALS['PROJECT']['PHPINCPATH']."db/update/functions_mySQL.phpinc";
  30. if (intval($tblVer['TBL_VERSION']) < 10) {
  31.     DB_UPDATE_execCmd("CREATE TABLE IF NOT EXISTS T_CMS_CSSSTYLES (
  32.             STY_ID int(11) NOT NULL auto_increment,
  33.             PROJ_ID int(11) NOT NULL default '0',
  34.             STY_SORTORDER smallint(6) NOT NULL default '99',
  35.             STY_NAME varchar(64) NOT NULL default 'CSSNAME',
  36.             STY_DESC text,
  37.             STY_ALWAYSUSE tinyint(4) NOT NULL default '0',
  38.             STY_GRP int(11) NOT NULL default '0',
  39.             STY_OWNER int(11) NOT NULL default '0',
  40.             STY_LASTCHANGE timestamp(14) NOT NULL,
  41.             PRIMARY KEY  (STY_ID),
  42.             UNIQUE KEY STY_NAME (STY_NAME),
  43.             KEY STY_GRP (STY_GRP),
  44.             KEY STY_OWNER (STY_OWNER),
  45.             KEY STY_ORDERNR (STY_SORTORDER)
  46.         ) TYPE=MyISAM;
  47.     ");
  48. } else {
  49.     DB_UPDATE_backupTable("T_CMS_CSSSTYLES");
  50. }
  51.  
  52. if (intval($tblVer['TBL_VERSION']) < 11) {
  53.     DB_UPDATE_execCmd("ALTER TABLE `T_CMS_CSSSTYLES` CHANGE `STY_GRP` `STY_GRP` INT( 11 ) DEFAULT '0'");
  54.     DB_UPDATE_execCmd("ALTER TABLE `T_CMS_CSSSTYLES` CHANGE `STY_OWNER` `STY_OWNER` INT( 11 ) DEFAULT '-1'");
  55.     $tblVer['TBL_VERSION']=11;
  56. }
  57.  
  58. if (intval($tblVer['TBL_VERSION']) < 12) {
  59.     DB_UPDATE_execCmd("ALTER TABLE T_CMS_CSSSTYLES CHANGE STY_SORTORDER STY_SORTORDER SMALLINT(6) DEFAULT '0' NOT NULL");
  60.     $tblVer['TBL_VERSION']=12;
  61. }
  62.  
  63. if (intval($tblVer['TBL_VERSION']) < 13) {
  64.     DB_UPDATE_execCmd("ALTER TABLE T_CMS_CSSSTYLES ADD STY_TEXT TEXT NULL");
  65.     $tblVer['TBL_VERSION']=13;
  66. }
  67.  
  68. if (intval($tblVer['TBL_VERSION']) < 14) {
  69.     DB_UPDATE_execCmd("ALTER TABLE T_CMS_CSSSTYLES ADD STY_JAVACODE TEXT NULL");
  70.  
  71.     require_once $GLOBALS['OCSP']['PHPFORMPATH']."forms.phpinc";
  72.     DBMS_field_IncludeAllSrc(); // we should now have the class loaded
  73.     if (!class_exists('DBMS_FIELD_TEXTAREA')) {
  74.         if (file_exists($GLOBALS['PROJECT']['PATH']."php/db/frmClasses/DBMS_FIELD_TEXTAREA.phpclass")) {
  75.             require_once $GLOBALS['PROJECT']['PATH']."php/db/frmClasses/DBMS_FIELD_TEXTAREA.phpclass";
  76.         } else {
  77.             echo "CLASS SOURCE FOR DBMS_FIELD_TEXTAREA NOT IN PROJECT";
  78.         }
  79.     }
  80.     if (class_exists('DBMS_FIELD_TEXTAREA')) {
  81.         if ($o_frmNewForm=DBMS_form_loadName('T_CMS_CSSSTYLES')) {
  82.             $o_frmNewFld=new DBMS_FIELD_TEXTAREA();
  83.             $o_frmNewFld->setFieldVar('className',"Textarea");
  84.             $o_frmNewFld->setFieldVar('isSearchable',False);
  85.             $o_frmNewFld->setFieldVar('rows',5);
  86.             $o_frmNewFld->setFieldVar('cols',50);
  87.             $o_frmNewFld->setFieldVar('nlToBr',True);
  88.             $o_frmNewFld->setFieldVar('wrap',"off");
  89.             $o_frmNewFld->setFieldVar('myROShowMode',3);
  90.         // array:
  91.             $o_frmNewFld->setFieldVar('static_Showmodes',unserialize(base64_decode("YTo1OntpOjA7czo4OiJvaG5lIFRhZyI7aToyO3M6MToicCI7aTozO3M6MzoicHJlIjtpOjE7czo4OiJ0ZXh0YXJlYSI7aTo0O3M6MjoibGkiO30=")));
  92.         // array:
  93.             $o_frmNewFld->setFieldVar('static_wrapMode',unserialize(base64_decode("YTozOntpOjA7czo0OiJzb2Z0IjtpOjE7czo0OiJoYXJkIjtpOjI7czozOiJvZmYiO30=")));
  94.             $o_frmNewFld->setFieldVar('myHTMLOutMode',3);
  95.         // bypass classSrcFile
  96.             $o_frmNewFld->setFieldVar('srcVersion',2);
  97.             $o_frmNewFld->setFrmId($o_frmNewForm->getId());
  98.         // bypass myForm
  99.             $o_frmNewFld->setTable("T_CMS_CSSSTYLES");
  100.             $o_frmNewFld->setFieldVar('myTableAlias',"T_CMS_CSSSTYLES");
  101.             $o_frmNewFld->setName("STY_JAVACODE");
  102.             $o_frmNewFld->setFieldVar('myDesc',"");
  103.         // array:
  104.             $o_frmNewFld->setdbDesc(unserialize(base64_decode("YTo3OntzOjQ6IlRZUEUiO3M6NDoidGV4dCI7czoxNDoiQVVUT19JTkNSRU1FTlQiO2I6MDtzOjQ6Ik5VTEwiO2I6MTtzOjExOiJQUklNQVJZX0tFWSI7YjowO3M6NzoiREVGQVVMVCI7TjtzOjM6IktFWSI7czowOiIiO3M6NzoiQ09MTkFNRSI7czoxMjoiU1RZX0pBVkFDT0RFIjt9")));
  105.             $o_frmNewFld->setFieldVar('label',"JavaCode");
  106.             $o_frmNewFld->setFieldVar('lstLabel',"");
  107.             $o_frmNewFld->setFieldVar('defaultValue',"");
  108.             $o_frmNewFld->setFieldVar('isHidden',False);
  109.             $o_frmNewFld->setFieldVar('enableEdit',True);
  110.             $o_frmNewFld->setFieldVar('enableNew',True);
  111.             $o_frmNewFld->setFieldVar('enableCopy',True);
  112.             $o_frmNewFld->setFieldVar('hideEdit',False);
  113.             $o_frmNewFld->setFieldVar('hideNew',False);
  114.             $o_frmNewFld->setFieldVar('hideCopy',False);
  115.             $o_frmNewFld->setFieldVar('showInList',True);
  116.             $o_frmNewFld->setFieldVar('sortOrder',12);
  117.             $o_frmNewFld->setFieldVar('toolTip',"Hier können mittels JavaCode weitere Styles definiert werden.");
  118.             $o_frmNewFld->setFieldVar('size',NULL);
  119.             $o_frmNewFld->setFieldVar('maxlength',NULL);
  120.             $o_frmNewFld->setFieldVar('addTag',"");
  121.             $o_frmNewFld->setFieldVar('hideAddTag_ro',FALSE);
  122.             $o_frmNewFld->setFieldVar('labeltd_add',"");
  123.             $o_frmNewFld->setFieldVar('labelcol_hide',FALSE);
  124.             $o_frmNewFld->setFieldVar('fieldtd_add',"");
  125.             $o_frmNewFld->setFieldVar('allowNull',True);
  126.             $o_frmNewFld->setFieldVar('nullErrMsg',"");
  127.             $o_frmNewFld->setFieldVar('myDataArrName',"DBVAL");
  128.             $o_frmNewFld->setFieldVar('ps_defaultDataArrName',"DBVAL");
  129.             // bypass myGlobalDbObjIdx
  130.             $o_frmNewFld->setFieldVar('myHelpUrl',"");
  131.             $o_frmNewFld->setFieldVar('myGrpKey',"");
  132.             $o_frmNewFld->setFieldVar('fldDebug',False);
  133.             $o_frmNewFld->setFieldVar('fldDbgGetValue',False);
  134.             $o_frmNewFld->setFieldVar('js_check',False);
  135.             $o_frmNewFld->setFieldVar('regexcheck_pattern',"");
  136.             $o_frmNewFld->setFieldVar('regexErrMsg',"");
  137.             $o_frmNewFld->setFieldVar('trimValue',False);
  138.             $o_frmNewFld->setFieldVar('hideReadOnly',False);
  139.             $o_frmNewFld->setFieldVar('tabIndex',0);
  140.             $o_frmNewFld->setFieldVar('myCurrentMode',0);
  141.             $o_frmNewFld->setFieldVar('lstColSpan',1);
  142.             $o_frmNewFld->setFieldVar('lstTDAdd',"");
  143.             $o_frmNewFld->setFieldVar('lstDisableLinks',False);
  144.         // array:
  145.             $o_frmNewFld->setFieldVar('lstLink',unserialize(base64_decode("YTowOnt9")));
  146.             $o_frmNewFld->setFieldVar('toolTipAsTitle',True);
  147.             $o_frmNewFld->setFieldVar('searchGroup_allowAll',True);
  148.             $o_frmNewFld->setFieldVar('showQuery',"");
  149.             $o_frmNewFld->setFieldVar('inputAdd',Null);
  150.             $o_frmNewFld->setFieldVar('allowHTML',False);
  151.             $o_frmNewFld->setFieldVar('allowSQL',False);
  152.             if (!$o_frmNewForm->fieldExists($o_frmNewFld->getName(),$o_frmNewFld->getTable())) {
  153.                 echo "<p>adding field ".$o_frmNewFld->getName()." Table: ".$o_frmNewFld->getTable()."</p>";
  154.                 $o_frmNewForm->addFieldObj($o_frmNewFld,True,$debug,True);
  155.                 $o_frmNewForm->storeToDb();
  156.             }
  157.         }
  158.     }
  159.  
  160.     $tblVer['TBL_VERSION']=14;
  161. }
  162.  
  163. if (intval($tblVer['TBL_VERSION']) < 15) {
  164.     DB_UPDATE_execCmd("ALTER TABLE T_CMS_CSSSTYLES ADD STY_INCLUDEFILE VARCHAR(255) NULL");
  165.     $tblVer['TBL_VERSION']=15;
  166. }
  167.  
  168. DB_UPDATE_setVersion($tblVer);
  169.  
  170. ?>

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