Plugin Directory

Changeset 1995629


Ignore:
Timestamp:
12/15/2018 09:52:27 PM (7 years ago)
Author:
lcwakeman
Message:

3.0

  • upload larger files, tested to 5.5 minute video
  • upload parameters modifiable with custimization
Location:
dmc-media
Files:
25 added
6 edited

Legend:

Unmodified
Added
Removed
  • dmc-media/trunk/common/lcw_common.php

    r1955446 r1995629  
    22/**
    33MU Plugin Name: LCW Common Toola
    4 Version: 1.1
     4Version: 1.2
    55Description: Common Tools Repository
    66Author: Larry Wakeman
  • dmc-media/trunk/common/lcw_common/Lcw_common_dbMaintenence_plus.php

    r1955446 r1995629  
    2020  }
    2121   
     22/**
     23 ** convert array file to json
     24 */
     25    public function convert_to_json($file) {
     26        include ($file);
     27        $temp = json_encode($database, JSON_PRETTY_PRINT);
     28        file_put_contents (str_replace('.php', '.json', $file), $temp);
     29    }
     30   
     31/**
     32 ** convert json file to array
     33 */
     34    public function convert_to_array($file, $dest = '') {
     35        if ($dest == '') $dest = str_replace('.json', '.php', $file);
     36        $json = file_get_contents($file);
     37        $temp = json_decode($json, true);
     38        $this->result = '';
     39        $array_contents = $this->parse_array($temp, '$database');
     40        file_put_contents ($dest, $array_contents);
     41    }
     42       
     43/**
     44 ** convert arraya to php
     45 */
     46    private $result;
     47    private function parse_array($array, $initial) {
     48        foreach ($array as $key => $item) {
     49            if (is_array($item)) {
     50                $temp = $this->parse_array($item, $initial."['".$key."']");
     51            } else {
     52                $this->result .= $initial."['".$key."'] = '".$item."';"."\n";
     53            }
     54        }
     55        return $this->result;
     56    }
    2257/**
    2358 ** Create a table from the description
     
    72107      $query .= " DEFAULT ".$quote.$column['Default'].$quote;
    73108    }
    74       if ($column['Update'] != '') {
     109      if ($column['4'] != '') {
    75110      $quote ="";
    76111      if ($column['Update'] != 'CURRENT_TIMESTAMP') $quote ="'";
     
    93128    $filename = basename($file);
    94129    $dir = dirname($file).'/';
    95     include($dir.$filename);
     130    if (strpos($filename, 'php')) {
     131        include($dir.$filename);
     132      } else if (strpos($filename, 'json')) {
     133          $json = file_get_contents($dir.$filename);
     134          $database = json_decode($json, true);
     135      }
    96136    if ($custom != '') {
    97         if (file_exists($custom)) include($custom);
     137        if (file_exists($custom)) {
     138            if (strpos($custom, 'php')) {
     139                include($custom);
     140            } else {
     141                  $json = file_get_contents($custom);
     142                  $temp = json_decode($json, true);
     143                    $temp = explode("\n", $this->parse_array($temp, '$database'));
     144                    foreach ($temp as $entry) {
     145                        if ($entry != '') {
     146                            eval ($entry);
     147                        }
     148                    }
     149            }
     150        }
    98151      }
    99152    // extract the schema version from the include files
     
    260313        // Write the mtadata if it exists
    261314        foreach ($table['columns'] as $column) {
     315                if (!isset($column['label'])) $column['label'] = '';
     316                if (!isset($column['control'])) $column['control'] = '';
     317                if (!isset($column['values'])) $column['values'] = '';
     318                if (!isset($column['watermark'])) $column['watermark'] = '';
     319                if (!isset($column['gridDisplay'])) $column['gridDisplay'] = '';
     320                if (!isset($column['keyField'])) $column['keyField'] = '';
     321                if (!isset($column['classes'])) $column['classes'] = '';
     322                if (!isset($column['other_attributes'])) $column['other_attributes'] = '';
     323                if (!isset($column['message'])) $column['message'] = '';
    262324          $query = "INSERT INTO ".$this->prefix."form_metadata VALUES ( ";
    263325          $query .= "null, 'Table', '".$key."', '".$column['Field']."', '".$column['label']."', ";
     
    282344                                    case 'columns':
    283345                                    foreach ($entities as $column) {
     346                                            if (!isset($column['label'])) $column['label'] = '';
     347                                            if (!isset($column['control'])) $column['control'] = '';
     348                                            if (!isset($column['values'])) $column['values'] = '';
     349                                            if (!isset($column['watermark'])) $column['watermark'] = '';
     350                                            if (!isset($column['gridDisplay'])) $column['gridDisplay'] = '';
     351                                            if (!isset($column['keyField'])) $column['keyField'] = '';
     352                                            if (!isset($column['classes'])) $column['classes'] = '';
    284353                                    if (isset($column['table'])) $query .= $column['table'].'.';
    285354                                    if (strpos('(', $column['field'])) {
  • dmc-media/trunk/db/database.php

    r1955446 r1995629  
    1 <?php
    2 /*
    3  * Schema Version, sets the schema version for this database file
    4  */
    5 $database['schema_version'] = array('major_version' => '1',
    6                                                                         'minor_version' => '0',
    7                                                                         'version_edit' => '2',
    8                                                                       'custom_major' => '0',
    9                                                                       'custom_minor' => '0',
    10                                                                       'custom_edit' => '0',
    11                                                                         );
    12 /*
    13  * Minimum Update Verson, Minimum version ot the schema to allow theupdate.
    14  */
    15 $database['minimum_version'] = array('major_version' => '0', 'minor_version' => '0', 'version_edit' => '0', );
    16 
    17 /*
    18  * Table schema_version
    19  */
    20 $database['tables']['#schema_version']['columns']['major_version'] = array('Field' => 'major_version', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    21 $database['tables']['#schema_version']['columns']['minor_version'] = array('Field' => 'minor_version', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    22 $database['tables']['#schema_version']['columns']['version_edit'] = array('Field' => 'version_edit', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    23 $database['tables']['#schema_version']['columns']['custom_major'] = array('Field' => 'custom_major', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    24 $database['tables']['#schema_version']['columns']['custom_minor'] = array('Field' => 'custom_minor', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    25 $database['tables']['#schema_version']['columns']['custom_edit'] = array('Field' => 'custom_edit', 'Type' => 'int(11)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '0', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    26 $database['tables']['#schema_version']['Engine'] = 'MyISAM';
    27 $database['tables']['#schema_version']['Collation'] = 'utf8_general_ci';
    28 
    29 
    30 /*
    31  * Table #form_metadata
    32  */
    33 $database['tables']['#form_metadata']['columns']['id'] = array('Field' => 'id', 'Type' => 'bigint(20)', 'Collation' => '', 'Null' => 'NO', 'Key' => 'PRI', 'Default' => '', 'Update' => '', 'Extra' => 'auto_increment', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    34 $database['tables']['#form_metadata']['columns']['object_type'] = array('Field' => 'object_type', 'Type' => 'enum(\'Table\',\'View\')', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => 'MUL', 'Default' => 'Table', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    35 $database['tables']['#form_metadata']['columns']['table'] = array('Field' => 'table', 'Type' => 'varchar(100)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    36 $database['tables']['#form_metadata']['columns']['field'] = array('Field' => 'field', 'Type' => 'varchar(100)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    37 $database['tables']['#form_metadata']['columns']['label'] = array('Field' => 'label', 'Type' => 'varchar(100)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    38 $database['tables']['#form_metadata']['columns']['control'] = array('Field' => 'control', 'Type' => 'varchar(25)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    39 $database['tables']['#form_metadata']['columns']['values'] = array('Field' => 'values', 'Type' => 'varchar(255)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    40 $database['tables']['#form_metadata']['columns']['watermark'] = array('Field' => 'watermark', 'Type' => 'varchar(255)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    41 $database['tables']['#form_metadata']['columns']['gridDisplay'] = array('Field' => 'gridDisplay', 'Type' => 'tinyint(1)', 'Collation' => '', 'Null' => 'YES', 'Key' => '', 'Default' => '1', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    42 $database['tables']['#form_metadata']['columns']['keyField'] = array('Field' => 'keyField', 'Type' => 'tinyint(1)', 'Collation' => '', 'Null' => 'YES', 'Key' => '', 'Default' => '0', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    43 $database['tables']['#form_metadata']['columns']['classes'] = array('Field' => 'classes', 'Type' => 'varchar(100)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    44 $database['tables']['#form_metadata']['columns']['other_attributes'] = array('Field' => 'other_attributes', 'Type' => 'varchar(255)', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    45 $database['tables']['#form_metadata']['columns']['message'] = array('Field' => 'message', 'Type' => 'tinyint(1)', 'Collation' => '', 'Null' => 'YES', 'Key' => '', 'Default' => '1', 'Update' => '', 'Extra' => '', 'Comment' => '', 'label' => '', 'control' => 'checkbox', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    46 $database['tables']['#form_metadata']['indexes']['locater'] = array('key_name' => 'locater', 'Non_unique' => '0', 'Column_name' => '`object_type`, `table`, `field`', );
    47 $database['tables']['#form_metadata']['Engine'] = 'MyISAM';
    48 $database['tables']['#form_metadata']['Collation'] = 'utf8_general_ci';
    49 
    50 /*
    51  * Table categories
    52  */
    53 $database['tables']['#categories']['columns']['categoryid'] = array('Field' => 'categoryid', 'Type' => 'bigint(20)', 'Collation' => '', 'Null' => 'NO', 'Key' => 'PRI', 'Default' => '', 'Extra' => 'auto_increment', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    54 $database['tables']['#categories']['columns']['category'] = array('Field' => 'category', 'Type' => 'varchar(50)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    55 $database['tables']['#categories']['columns']['description'] = array('Field' => 'description', 'Type' => 'text', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    56 $database['tables']['#categories']['Engine'] = 'MyISAM';
    57 $database['tables']['#categories']['Collation'] = 'utf8_general_ci';
    58 
    59 /*
    60  * Table media
    61  */
    62 $database['tables']['#media']['columns']['id'] = array('Field' => 'id', 'Type' => 'bigint(20)', 'Collation' => '', 'Null' => 'NO', 'Key' => 'PRI', 'Default' => '', 'Extra' => 'auto_increment', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    63 $database['tables']['#media']['columns']['title'] = array('Field' => 'title', 'Type' => 'varchar(55)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    64 $database['tables']['#media']['columns']['url'] = array('Field' => 'url', 'Type' => 'varchar(255)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    65 $database['tables']['#media']['columns']['file'] = array('Field' => 'file', 'Type' => 'varchar(255)', 'Collation' => 'utf8_general_ci', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    66 $database['tables']['#media']['columns']['description'] = array('Field' => 'description', 'Type' => 'text', 'Collation' => 'utf8_general_ci', 'Null' => 'YES', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    67 $database['tables']['#media']['columns']['order'] = array('Field' => 'order', 'Type' => 'bigint(20)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    68 $database['tables']['#media']['columns']['categoryid'] = array('Field' => 'categoryid', 'Type' => 'bigint(20)', 'Collation' => '', 'Null' => 'NO', 'Key' => '', 'Default' => '', 'Extra' => '', 'Privileges' => 'select,insert,update,references', 'Comment' => '', 'label' => '', 'control' => 'text', 'values' => '', 'watermark' => '', 'gridDisplay' => '0', 'keyField' => '0', 'classes' => '', 'other_attributes' => '', 'message'=> '',);
    69 $database['tables']['#media']['Engine'] = 'MyISAM';
    70 $database['tables']['#media']['Collation'] = 'utf8_general_ci';
    71 
     1$database['schema_version']['major_version'] = '1';
     2$database['schema_version']['minor_version'] = '0';
     3$database['schema_version']['version_edit'] = '2';
     4$database['schema_version']['custom_major'] = '0';
     5$database['schema_version']['custom_minor'] = '0';
     6$database['schema_version']['custom_edit'] = '0';
     7$database['minimum_version']['major_version'] = '0';
     8$database['minimum_version']['minor_version'] = '0';
     9$database['minimum_version']['version_edit'] = '0';
     10$database['tables']['#schema_version']['columns']['major_version']['Field'] = 'major_version';
     11$database['tables']['#schema_version']['columns']['major_version']['Type'] = 'int(11)';
     12$database['tables']['#schema_version']['columns']['major_version']['Collation'] = '';
     13$database['tables']['#schema_version']['columns']['major_version']['Null'] = 'NO';
     14$database['tables']['#schema_version']['columns']['major_version']['Key'] = '';
     15$database['tables']['#schema_version']['columns']['major_version']['Default'] = '0';
     16$database['tables']['#schema_version']['columns']['major_version']['Extra'] = '';
     17$database['tables']['#schema_version']['columns']['major_version']['Privileges'] = 'select,insert,update,references';
     18$database['tables']['#schema_version']['columns']['major_version']['Comment'] = '';
     19$database['tables']['#schema_version']['columns']['major_version']['label'] = '';
     20$database['tables']['#schema_version']['columns']['major_version']['control'] = 'text';
     21$database['tables']['#schema_version']['columns']['major_version']['values'] = '';
     22$database['tables']['#schema_version']['columns']['major_version']['watermark'] = '';
     23$database['tables']['#schema_version']['columns']['major_version']['gridDisplay'] = '0';
     24$database['tables']['#schema_version']['columns']['major_version']['keyField'] = '0';
     25$database['tables']['#schema_version']['columns']['major_version']['classes'] = '';
     26$database['tables']['#schema_version']['columns']['major_version']['other_attributes'] = '';
     27$database['tables']['#schema_version']['columns']['major_version']['message'] = '';
     28$database['tables']['#schema_version']['columns']['minor_version']['Field'] = 'minor_version';
     29$database['tables']['#schema_version']['columns']['minor_version']['Type'] = 'int(11)';
     30$database['tables']['#schema_version']['columns']['minor_version']['Collation'] = '';
     31$database['tables']['#schema_version']['columns']['minor_version']['Null'] = 'NO';
     32$database['tables']['#schema_version']['columns']['minor_version']['Key'] = '';
     33$database['tables']['#schema_version']['columns']['minor_version']['Default'] = '0';
     34$database['tables']['#schema_version']['columns']['minor_version']['Extra'] = '';
     35$database['tables']['#schema_version']['columns']['minor_version']['Privileges'] = 'select,insert,update,references';
     36$database['tables']['#schema_version']['columns']['minor_version']['Comment'] = '';
     37$database['tables']['#schema_version']['columns']['minor_version']['label'] = '';
     38$database['tables']['#schema_version']['columns']['minor_version']['control'] = 'text';
     39$database['tables']['#schema_version']['columns']['minor_version']['values'] = '';
     40$database['tables']['#schema_version']['columns']['minor_version']['watermark'] = '';
     41$database['tables']['#schema_version']['columns']['minor_version']['gridDisplay'] = '0';
     42$database['tables']['#schema_version']['columns']['minor_version']['keyField'] = '0';
     43$database['tables']['#schema_version']['columns']['minor_version']['classes'] = '';
     44$database['tables']['#schema_version']['columns']['minor_version']['other_attributes'] = '';
     45$database['tables']['#schema_version']['columns']['minor_version']['message'] = '';
     46$database['tables']['#schema_version']['columns']['version_edit']['Field'] = 'version_edit';
     47$database['tables']['#schema_version']['columns']['version_edit']['Type'] = 'int(11)';
     48$database['tables']['#schema_version']['columns']['version_edit']['Collation'] = '';
     49$database['tables']['#schema_version']['columns']['version_edit']['Null'] = 'NO';
     50$database['tables']['#schema_version']['columns']['version_edit']['Key'] = '';
     51$database['tables']['#schema_version']['columns']['version_edit']['Default'] = '0';
     52$database['tables']['#schema_version']['columns']['version_edit']['Extra'] = '';
     53$database['tables']['#schema_version']['columns']['version_edit']['Privileges'] = 'select,insert,update,references';
     54$database['tables']['#schema_version']['columns']['version_edit']['Comment'] = '';
     55$database['tables']['#schema_version']['columns']['version_edit']['label'] = '';
     56$database['tables']['#schema_version']['columns']['version_edit']['control'] = 'text';
     57$database['tables']['#schema_version']['columns']['version_edit']['values'] = '';
     58$database['tables']['#schema_version']['columns']['version_edit']['watermark'] = '';
     59$database['tables']['#schema_version']['columns']['version_edit']['gridDisplay'] = '0';
     60$database['tables']['#schema_version']['columns']['version_edit']['keyField'] = '0';
     61$database['tables']['#schema_version']['columns']['version_edit']['classes'] = '';
     62$database['tables']['#schema_version']['columns']['version_edit']['other_attributes'] = '';
     63$database['tables']['#schema_version']['columns']['version_edit']['message'] = '';
     64$database['tables']['#schema_version']['columns']['custom_major']['Field'] = 'custom_major';
     65$database['tables']['#schema_version']['columns']['custom_major']['Type'] = 'int(11)';
     66$database['tables']['#schema_version']['columns']['custom_major']['Collation'] = '';
     67$database['tables']['#schema_version']['columns']['custom_major']['Null'] = 'NO';
     68$database['tables']['#schema_version']['columns']['custom_major']['Key'] = '';
     69$database['tables']['#schema_version']['columns']['custom_major']['Default'] = '0';
     70$database['tables']['#schema_version']['columns']['custom_major']['Update'] = '';
     71$database['tables']['#schema_version']['columns']['custom_major']['Extra'] = '';
     72$database['tables']['#schema_version']['columns']['custom_major']['Comment'] = '';
     73$database['tables']['#schema_version']['columns']['custom_major']['label'] = '';
     74$database['tables']['#schema_version']['columns']['custom_major']['control'] = 'text';
     75$database['tables']['#schema_version']['columns']['custom_major']['values'] = '';
     76$database['tables']['#schema_version']['columns']['custom_major']['watermark'] = '';
     77$database['tables']['#schema_version']['columns']['custom_major']['gridDisplay'] = '0';
     78$database['tables']['#schema_version']['columns']['custom_major']['keyField'] = '0';
     79$database['tables']['#schema_version']['columns']['custom_major']['classes'] = '';
     80$database['tables']['#schema_version']['columns']['custom_major']['other_attributes'] = '';
     81$database['tables']['#schema_version']['columns']['custom_major']['message'] = '';
     82$database['tables']['#schema_version']['columns']['custom_minor']['Field'] = 'custom_minor';
     83$database['tables']['#schema_version']['columns']['custom_minor']['Type'] = 'int(11)';
     84$database['tables']['#schema_version']['columns']['custom_minor']['Collation'] = '';
     85$database['tables']['#schema_version']['columns']['custom_minor']['Null'] = 'NO';
     86$database['tables']['#schema_version']['columns']['custom_minor']['Key'] = '';
     87$database['tables']['#schema_version']['columns']['custom_minor']['Default'] = '0';
     88$database['tables']['#schema_version']['columns']['custom_minor']['Update'] = '';
     89$database['tables']['#schema_version']['columns']['custom_minor']['Extra'] = '';
     90$database['tables']['#schema_version']['columns']['custom_minor']['Comment'] = '';
     91$database['tables']['#schema_version']['columns']['custom_minor']['label'] = '';
     92$database['tables']['#schema_version']['columns']['custom_minor']['control'] = 'text';
     93$database['tables']['#schema_version']['columns']['custom_minor']['values'] = '';
     94$database['tables']['#schema_version']['columns']['custom_minor']['watermark'] = '';
     95$database['tables']['#schema_version']['columns']['custom_minor']['gridDisplay'] = '0';
     96$database['tables']['#schema_version']['columns']['custom_minor']['keyField'] = '0';
     97$database['tables']['#schema_version']['columns']['custom_minor']['classes'] = '';
     98$database['tables']['#schema_version']['columns']['custom_minor']['other_attributes'] = '';
     99$database['tables']['#schema_version']['columns']['custom_minor']['message'] = '';
     100$database['tables']['#schema_version']['columns']['custom_edit']['Field'] = 'custom_edit';
     101$database['tables']['#schema_version']['columns']['custom_edit']['Type'] = 'int(11)';
     102$database['tables']['#schema_version']['columns']['custom_edit']['Collation'] = '';
     103$database['tables']['#schema_version']['columns']['custom_edit']['Null'] = 'NO';
     104$database['tables']['#schema_version']['columns']['custom_edit']['Key'] = '';
     105$database['tables']['#schema_version']['columns']['custom_edit']['Default'] = '0';
     106$database['tables']['#schema_version']['columns']['custom_edit']['Update'] = '';
     107$database['tables']['#schema_version']['columns']['custom_edit']['Extra'] = '';
     108$database['tables']['#schema_version']['columns']['custom_edit']['Comment'] = '';
     109$database['tables']['#schema_version']['columns']['custom_edit']['label'] = '';
     110$database['tables']['#schema_version']['columns']['custom_edit']['control'] = 'text';
     111$database['tables']['#schema_version']['columns']['custom_edit']['values'] = '';
     112$database['tables']['#schema_version']['columns']['custom_edit']['watermark'] = '';
     113$database['tables']['#schema_version']['columns']['custom_edit']['gridDisplay'] = '0';
     114$database['tables']['#schema_version']['columns']['custom_edit']['keyField'] = '0';
     115$database['tables']['#schema_version']['columns']['custom_edit']['classes'] = '';
     116$database['tables']['#schema_version']['columns']['custom_edit']['other_attributes'] = '';
     117$database['tables']['#schema_version']['columns']['custom_edit']['message'] = '';
     118$database['tables']['#schema_version']['Engine'] = 'MyISAM';
     119$database['tables']['#schema_version']['Collation'] = 'utf8_general_ci';
     120$database['tables']['#form_metadata']['columns']['id']['Field'] = 'id';
     121$database['tables']['#form_metadata']['columns']['id']['Type'] = 'bigint(20)';
     122$database['tables']['#form_metadata']['columns']['id']['Collation'] = '';
     123$database['tables']['#form_metadata']['columns']['id']['Null'] = 'NO';
     124$database['tables']['#form_metadata']['columns']['id']['Key'] = 'PRI';
     125$database['tables']['#form_metadata']['columns']['id']['Default'] = '';
     126$database['tables']['#form_metadata']['columns']['id']['Update'] = '';
     127$database['tables']['#form_metadata']['columns']['id']['Extra'] = 'auto_increment';
     128$database['tables']['#form_metadata']['columns']['id']['Comment'] = '';
     129$database['tables']['#form_metadata']['columns']['id']['label'] = '';
     130$database['tables']['#form_metadata']['columns']['id']['control'] = 'text';
     131$database['tables']['#form_metadata']['columns']['id']['values'] = '';
     132$database['tables']['#form_metadata']['columns']['id']['watermark'] = '';
     133$database['tables']['#form_metadata']['columns']['id']['gridDisplay'] = '0';
     134$database['tables']['#form_metadata']['columns']['id']['keyField'] = '0';
     135$database['tables']['#form_metadata']['columns']['id']['classes'] = '';
     136$database['tables']['#form_metadata']['columns']['id']['other_attributes'] = '';
     137$database['tables']['#form_metadata']['columns']['id']['message'] = '';
     138$database['tables']['#form_metadata']['columns']['object_type']['Field'] = 'object_type';
     139$database['tables']['#form_metadata']['columns']['object_type']['Type'] = 'enum('Table','View')';
     140$database['tables']['#form_metadata']['columns']['object_type']['Collation'] = 'utf8_general_ci';
     141$database['tables']['#form_metadata']['columns']['object_type']['Null'] = 'NO';
     142$database['tables']['#form_metadata']['columns']['object_type']['Key'] = 'MUL';
     143$database['tables']['#form_metadata']['columns']['object_type']['Default'] = 'Table';
     144$database['tables']['#form_metadata']['columns']['object_type']['Update'] = '';
     145$database['tables']['#form_metadata']['columns']['object_type']['Extra'] = '';
     146$database['tables']['#form_metadata']['columns']['object_type']['Comment'] = '';
     147$database['tables']['#form_metadata']['columns']['object_type']['label'] = '';
     148$database['tables']['#form_metadata']['columns']['object_type']['control'] = 'text';
     149$database['tables']['#form_metadata']['columns']['object_type']['values'] = '';
     150$database['tables']['#form_metadata']['columns']['object_type']['watermark'] = '';
     151$database['tables']['#form_metadata']['columns']['object_type']['gridDisplay'] = '0';
     152$database['tables']['#form_metadata']['columns']['object_type']['keyField'] = '0';
     153$database['tables']['#form_metadata']['columns']['object_type']['classes'] = '';
     154$database['tables']['#form_metadata']['columns']['object_type']['other_attributes'] = '';
     155$database['tables']['#form_metadata']['columns']['object_type']['message'] = '';
     156$database['tables']['#form_metadata']['columns']['table']['Field'] = 'table';
     157$database['tables']['#form_metadata']['columns']['table']['Type'] = 'varchar(100)';
     158$database['tables']['#form_metadata']['columns']['table']['Collation'] = 'utf8_general_ci';
     159$database['tables']['#form_metadata']['columns']['table']['Null'] = 'NO';
     160$database['tables']['#form_metadata']['columns']['table']['Key'] = '';
     161$database['tables']['#form_metadata']['columns']['table']['Default'] = '';
     162$database['tables']['#form_metadata']['columns']['table']['Update'] = '';
     163$database['tables']['#form_metadata']['columns']['table']['Extra'] = '';
     164$database['tables']['#form_metadata']['columns']['table']['Comment'] = '';
     165$database['tables']['#form_metadata']['columns']['table']['label'] = '';
     166$database['tables']['#form_metadata']['columns']['table']['control'] = 'text';
     167$database['tables']['#form_metadata']['columns']['table']['values'] = '';
     168$database['tables']['#form_metadata']['columns']['table']['watermark'] = '';
     169$database['tables']['#form_metadata']['columns']['table']['gridDisplay'] = '0';
     170$database['tables']['#form_metadata']['columns']['table']['keyField'] = '0';
     171$database['tables']['#form_metadata']['columns']['table']['classes'] = '';
     172$database['tables']['#form_metadata']['columns']['table']['other_attributes'] = '';
     173$database['tables']['#form_metadata']['columns']['table']['message'] = '';
     174$database['tables']['#form_metadata']['columns']['field']['Field'] = 'field';
     175$database['tables']['#form_metadata']['columns']['field']['Type'] = 'varchar(100)';
     176$database['tables']['#form_metadata']['columns']['field']['Collation'] = 'utf8_general_ci';
     177$database['tables']['#form_metadata']['columns']['field']['Null'] = 'NO';
     178$database['tables']['#form_metadata']['columns']['field']['Key'] = '';
     179$database['tables']['#form_metadata']['columns']['field']['Default'] = '';
     180$database['tables']['#form_metadata']['columns']['field']['Update'] = '';
     181$database['tables']['#form_metadata']['columns']['field']['Extra'] = '';
     182$database['tables']['#form_metadata']['columns']['field']['Comment'] = '';
     183$database['tables']['#form_metadata']['columns']['field']['label'] = '';
     184$database['tables']['#form_metadata']['columns']['field']['control'] = 'text';
     185$database['tables']['#form_metadata']['columns']['field']['values'] = '';
     186$database['tables']['#form_metadata']['columns']['field']['watermark'] = '';
     187$database['tables']['#form_metadata']['columns']['field']['gridDisplay'] = '0';
     188$database['tables']['#form_metadata']['columns']['field']['keyField'] = '0';
     189$database['tables']['#form_metadata']['columns']['field']['classes'] = '';
     190$database['tables']['#form_metadata']['columns']['field']['other_attributes'] = '';
     191$database['tables']['#form_metadata']['columns']['field']['message'] = '';
     192$database['tables']['#form_metadata']['columns']['label']['Field'] = 'label';
     193$database['tables']['#form_metadata']['columns']['label']['Type'] = 'varchar(100)';
     194$database['tables']['#form_metadata']['columns']['label']['Collation'] = 'utf8_general_ci';
     195$database['tables']['#form_metadata']['columns']['label']['Null'] = 'YES';
     196$database['tables']['#form_metadata']['columns']['label']['Key'] = '';
     197$database['tables']['#form_metadata']['columns']['label']['Default'] = '';
     198$database['tables']['#form_metadata']['columns']['label']['Update'] = '';
     199$database['tables']['#form_metadata']['columns']['label']['Extra'] = '';
     200$database['tables']['#form_metadata']['columns']['label']['Comment'] = '';
     201$database['tables']['#form_metadata']['columns']['label']['label'] = '';
     202$database['tables']['#form_metadata']['columns']['label']['control'] = 'text';
     203$database['tables']['#form_metadata']['columns']['label']['values'] = '';
     204$database['tables']['#form_metadata']['columns']['label']['watermark'] = '';
     205$database['tables']['#form_metadata']['columns']['label']['gridDisplay'] = '0';
     206$database['tables']['#form_metadata']['columns']['label']['keyField'] = '0';
     207$database['tables']['#form_metadata']['columns']['label']['classes'] = '';
     208$database['tables']['#form_metadata']['columns']['label']['other_attributes'] = '';
     209$database['tables']['#form_metadata']['columns']['label']['message'] = '';
     210$database['tables']['#form_metadata']['columns']['control']['Field'] = 'control';
     211$database['tables']['#form_metadata']['columns']['control']['Type'] = 'varchar(25)';
     212$database['tables']['#form_metadata']['columns']['control']['Collation'] = 'utf8_general_ci';
     213$database['tables']['#form_metadata']['columns']['control']['Null'] = 'YES';
     214$database['tables']['#form_metadata']['columns']['control']['Key'] = '';
     215$database['tables']['#form_metadata']['columns']['control']['Default'] = '';
     216$database['tables']['#form_metadata']['columns']['control']['Update'] = '';
     217$database['tables']['#form_metadata']['columns']['control']['Extra'] = '';
     218$database['tables']['#form_metadata']['columns']['control']['Comment'] = '';
     219$database['tables']['#form_metadata']['columns']['control']['label'] = '';
     220$database['tables']['#form_metadata']['columns']['control']['control'] = 'text';
     221$database['tables']['#form_metadata']['columns']['control']['values'] = '';
     222$database['tables']['#form_metadata']['columns']['control']['watermark'] = '';
     223$database['tables']['#form_metadata']['columns']['control']['gridDisplay'] = '0';
     224$database['tables']['#form_metadata']['columns']['control']['keyField'] = '0';
     225$database['tables']['#form_metadata']['columns']['control']['classes'] = '';
     226$database['tables']['#form_metadata']['columns']['control']['other_attributes'] = '';
     227$database['tables']['#form_metadata']['columns']['control']['message'] = '';
     228$database['tables']['#form_metadata']['columns']['values']['Field'] = 'values';
     229$database['tables']['#form_metadata']['columns']['values']['Type'] = 'varchar(255)';
     230$database['tables']['#form_metadata']['columns']['values']['Collation'] = 'utf8_general_ci';
     231$database['tables']['#form_metadata']['columns']['values']['Null'] = 'YES';
     232$database['tables']['#form_metadata']['columns']['values']['Key'] = '';
     233$database['tables']['#form_metadata']['columns']['values']['Default'] = '';
     234$database['tables']['#form_metadata']['columns']['values']['Update'] = '';
     235$database['tables']['#form_metadata']['columns']['values']['Extra'] = '';
     236$database['tables']['#form_metadata']['columns']['values']['Comment'] = '';
     237$database['tables']['#form_metadata']['columns']['values']['label'] = '';
     238$database['tables']['#form_metadata']['columns']['values']['control'] = 'text';
     239$database['tables']['#form_metadata']['columns']['values']['values'] = '';
     240$database['tables']['#form_metadata']['columns']['values']['watermark'] = '';
     241$database['tables']['#form_metadata']['columns']['values']['gridDisplay'] = '0';
     242$database['tables']['#form_metadata']['columns']['values']['keyField'] = '0';
     243$database['tables']['#form_metadata']['columns']['values']['classes'] = '';
     244$database['tables']['#form_metadata']['columns']['values']['other_attributes'] = '';
     245$database['tables']['#form_metadata']['columns']['values']['message'] = '';
     246$database['tables']['#form_metadata']['columns']['watermark']['Field'] = 'watermark';
     247$database['tables']['#form_metadata']['columns']['watermark']['Type'] = 'varchar(255)';
     248$database['tables']['#form_metadata']['columns']['watermark']['Collation'] = 'utf8_general_ci';
     249$database['tables']['#form_metadata']['columns']['watermark']['Null'] = 'YES';
     250$database['tables']['#form_metadata']['columns']['watermark']['Key'] = '';
     251$database['tables']['#form_metadata']['columns']['watermark']['Default'] = '';
     252$database['tables']['#form_metadata']['columns']['watermark']['Update'] = '';
     253$database['tables']['#form_metadata']['columns']['watermark']['Extra'] = '';
     254$database['tables']['#form_metadata']['columns']['watermark']['Comment'] = '';
     255$database['tables']['#form_metadata']['columns']['watermark']['label'] = '';
     256$database['tables']['#form_metadata']['columns']['watermark']['control'] = 'text';
     257$database['tables']['#form_metadata']['columns']['watermark']['values'] = '';
     258$database['tables']['#form_metadata']['columns']['watermark']['watermark'] = '';
     259$database['tables']['#form_metadata']['columns']['watermark']['gridDisplay'] = '0';
     260$database['tables']['#form_metadata']['columns']['watermark']['keyField'] = '0';
     261$database['tables']['#form_metadata']['columns']['watermark']['classes'] = '';
     262$database['tables']['#form_metadata']['columns']['watermark']['other_attributes'] = '';
     263$database['tables']['#form_metadata']['columns']['watermark']['message'] = '';
     264$database['tables']['#form_metadata']['columns']['gridDisplay']['Field'] = 'gridDisplay';
     265$database['tables']['#form_metadata']['columns']['gridDisplay']['Type'] = 'tinyint(1)';
     266$database['tables']['#form_metadata']['columns']['gridDisplay']['Collation'] = '';
     267$database['tables']['#form_metadata']['columns']['gridDisplay']['Null'] = 'YES';
     268$database['tables']['#form_metadata']['columns']['gridDisplay']['Key'] = '';
     269$database['tables']['#form_metadata']['columns']['gridDisplay']['Default'] = '1';
     270$database['tables']['#form_metadata']['columns']['gridDisplay']['Update'] = '';
     271$database['tables']['#form_metadata']['columns']['gridDisplay']['Extra'] = '';
     272$database['tables']['#form_metadata']['columns']['gridDisplay']['Comment'] = '';
     273$database['tables']['#form_metadata']['columns']['gridDisplay']['label'] = '';
     274$database['tables']['#form_metadata']['columns']['gridDisplay']['control'] = 'text';
     275$database['tables']['#form_metadata']['columns']['gridDisplay']['values'] = '';
     276$database['tables']['#form_metadata']['columns']['gridDisplay']['watermark'] = '';
     277$database['tables']['#form_metadata']['columns']['gridDisplay']['gridDisplay'] = '0';
     278$database['tables']['#form_metadata']['columns']['gridDisplay']['keyField'] = '0';
     279$database['tables']['#form_metadata']['columns']['gridDisplay']['classes'] = '';
     280$database['tables']['#form_metadata']['columns']['gridDisplay']['other_attributes'] = '';
     281$database['tables']['#form_metadata']['columns']['gridDisplay']['message'] = '';
     282$database['tables']['#form_metadata']['columns']['keyField']['Field'] = 'keyField';
     283$database['tables']['#form_metadata']['columns']['keyField']['Type'] = 'tinyint(1)';
     284$database['tables']['#form_metadata']['columns']['keyField']['Collation'] = '';
     285$database['tables']['#form_metadata']['columns']['keyField']['Null'] = 'YES';
     286$database['tables']['#form_metadata']['columns']['keyField']['Key'] = '';
     287$database['tables']['#form_metadata']['columns']['keyField']['Default'] = '0';
     288$database['tables']['#form_metadata']['columns']['keyField']['Update'] = '';
     289$database['tables']['#form_metadata']['columns']['keyField']['Extra'] = '';
     290$database['tables']['#form_metadata']['columns']['keyField']['Comment'] = '';
     291$database['tables']['#form_metadata']['columns']['keyField']['label'] = '';
     292$database['tables']['#form_metadata']['columns']['keyField']['control'] = 'text';
     293$database['tables']['#form_metadata']['columns']['keyField']['values'] = '';
     294$database['tables']['#form_metadata']['columns']['keyField']['watermark'] = '';
     295$database['tables']['#form_metadata']['columns']['keyField']['gridDisplay'] = '0';
     296$database['tables']['#form_metadata']['columns']['keyField']['keyField'] = '0';
     297$database['tables']['#form_metadata']['columns']['keyField']['classes'] = '';
     298$database['tables']['#form_metadata']['columns']['keyField']['other_attributes'] = '';
     299$database['tables']['#form_metadata']['columns']['keyField']['message'] = '';
     300$database['tables']['#form_metadata']['columns']['classes']['Field'] = 'classes';
     301$database['tables']['#form_metadata']['columns']['classes']['Type'] = 'varchar(100)';
     302$database['tables']['#form_metadata']['columns']['classes']['Collation'] = 'utf8_general_ci';
     303$database['tables']['#form_metadata']['columns']['classes']['Null'] = 'YES';
     304$database['tables']['#form_metadata']['columns']['classes']['Key'] = '';
     305$database['tables']['#form_metadata']['columns']['classes']['Default'] = '';
     306$database['tables']['#form_metadata']['columns']['classes']['Update'] = '';
     307$database['tables']['#form_metadata']['columns']['classes']['Extra'] = '';
     308$database['tables']['#form_metadata']['columns']['classes']['Comment'] = '';
     309$database['tables']['#form_metadata']['columns']['classes']['label'] = '';
     310$database['tables']['#form_metadata']['columns']['classes']['control'] = 'text';
     311$database['tables']['#form_metadata']['columns']['classes']['values'] = '';
     312$database['tables']['#form_metadata']['columns']['classes']['watermark'] = '';
     313$database['tables']['#form_metadata']['columns']['classes']['gridDisplay'] = '0';
     314$database['tables']['#form_metadata']['columns']['classes']['keyField'] = '0';
     315$database['tables']['#form_metadata']['columns']['classes']['classes'] = '';
     316$database['tables']['#form_metadata']['columns']['classes']['other_attributes'] = '';
     317$database['tables']['#form_metadata']['columns']['classes']['message'] = '';
     318$database['tables']['#form_metadata']['columns']['other_attributes']['Field'] = 'other_attributes';
     319$database['tables']['#form_metadata']['columns']['other_attributes']['Type'] = 'varchar(255)';
     320$database['tables']['#form_metadata']['columns']['other_attributes']['Collation'] = 'utf8_general_ci';
     321$database['tables']['#form_metadata']['columns']['other_attributes']['Null'] = 'YES';
     322$database['tables']['#form_metadata']['columns']['other_attributes']['Key'] = '';
     323$database['tables']['#form_metadata']['columns']['other_attributes']['Default'] = '';
     324$database['tables']['#form_metadata']['columns']['other_attributes']['Update'] = '';
     325$database['tables']['#form_metadata']['columns']['other_attributes']['Extra'] = '';
     326$database['tables']['#form_metadata']['columns']['other_attributes']['Comment'] = '';
     327$database['tables']['#form_metadata']['columns']['other_attributes']['label'] = '';
     328$database['tables']['#form_metadata']['columns']['other_attributes']['control'] = 'text';
     329$database['tables']['#form_metadata']['columns']['other_attributes']['values'] = '';
     330$database['tables']['#form_metadata']['columns']['other_attributes']['watermark'] = '';
     331$database['tables']['#form_metadata']['columns']['other_attributes']['gridDisplay'] = '0';
     332$database['tables']['#form_metadata']['columns']['other_attributes']['keyField'] = '0';
     333$database['tables']['#form_metadata']['columns']['other_attributes']['classes'] = '';
     334$database['tables']['#form_metadata']['columns']['other_attributes']['other_attributes'] = '';
     335$database['tables']['#form_metadata']['columns']['other_attributes']['message'] = '';
     336$database['tables']['#form_metadata']['columns']['message']['Field'] = 'message';
     337$database['tables']['#form_metadata']['columns']['message']['Type'] = 'tinyint(1)';
     338$database['tables']['#form_metadata']['columns']['message']['Collation'] = '';
     339$database['tables']['#form_metadata']['columns']['message']['Null'] = 'YES';
     340$database['tables']['#form_metadata']['columns']['message']['Key'] = '';
     341$database['tables']['#form_metadata']['columns']['message']['Default'] = '1';
     342$database['tables']['#form_metadata']['columns']['message']['Update'] = '';
     343$database['tables']['#form_metadata']['columns']['message']['Extra'] = '';
     344$database['tables']['#form_metadata']['columns']['message']['Comment'] = '';
     345$database['tables']['#form_metadata']['columns']['message']['label'] = '';
     346$database['tables']['#form_metadata']['columns']['message']['control'] = 'checkbox';
     347$database['tables']['#form_metadata']['columns']['message']['values'] = '';
     348$database['tables']['#form_metadata']['columns']['message']['watermark'] = '';
     349$database['tables']['#form_metadata']['columns']['message']['gridDisplay'] = '0';
     350$database['tables']['#form_metadata']['columns']['message']['keyField'] = '0';
     351$database['tables']['#form_metadata']['columns']['message']['classes'] = '';
     352$database['tables']['#form_metadata']['columns']['message']['other_attributes'] = '';
     353$database['tables']['#form_metadata']['columns']['message']['message'] = '';
     354$database['tables']['#form_metadata']['indexes']['locater']['key_name'] = 'locater';
     355$database['tables']['#form_metadata']['indexes']['locater']['Non_unique'] = '0';
     356$database['tables']['#form_metadata']['indexes']['locater']['Column_name'] = '`object_type`, `table`, `field`';
     357$database['tables']['#form_metadata']['Engine'] = 'MyISAM';
     358$database['tables']['#form_metadata']['Collation'] = 'utf8_general_ci';
     359$database['tables']['#categories']['columns']['categoryid']['Field'] = 'categoryid';
     360$database['tables']['#categories']['columns']['categoryid']['Type'] = 'bigint(20)';
     361$database['tables']['#categories']['columns']['categoryid']['Collation'] = '';
     362$database['tables']['#categories']['columns']['categoryid']['Null'] = 'NO';
     363$database['tables']['#categories']['columns']['categoryid']['Key'] = 'PRI';
     364$database['tables']['#categories']['columns']['categoryid']['Default'] = '';
     365$database['tables']['#categories']['columns']['categoryid']['Extra'] = 'auto_increment';
     366$database['tables']['#categories']['columns']['categoryid']['Privileges'] = 'select,insert,update,references';
     367$database['tables']['#categories']['columns']['categoryid']['Comment'] = '';
     368$database['tables']['#categories']['columns']['categoryid']['label'] = '';
     369$database['tables']['#categories']['columns']['categoryid']['control'] = 'text';
     370$database['tables']['#categories']['columns']['categoryid']['values'] = '';
     371$database['tables']['#categories']['columns']['categoryid']['watermark'] = '';
     372$database['tables']['#categories']['columns']['categoryid']['gridDisplay'] = '0';
     373$database['tables']['#categories']['columns']['categoryid']['keyField'] = '0';
     374$database['tables']['#categories']['columns']['categoryid']['classes'] = '';
     375$database['tables']['#categories']['columns']['categoryid']['other_attributes'] = '';
     376$database['tables']['#categories']['columns']['categoryid']['message'] = '';
     377$database['tables']['#categories']['columns']['category']['Field'] = 'category';
     378$database['tables']['#categories']['columns']['category']['Type'] = 'varchar(50)';
     379$database['tables']['#categories']['columns']['category']['Collation'] = 'utf8_general_ci';
     380$database['tables']['#categories']['columns']['category']['Null'] = 'NO';
     381$database['tables']['#categories']['columns']['category']['Key'] = '';
     382$database['tables']['#categories']['columns']['category']['Default'] = '';
     383$database['tables']['#categories']['columns']['category']['Extra'] = '';
     384$database['tables']['#categories']['columns']['category']['Privileges'] = 'select,insert,update,references';
     385$database['tables']['#categories']['columns']['category']['Comment'] = '';
     386$database['tables']['#categories']['columns']['category']['label'] = '';
     387$database['tables']['#categories']['columns']['category']['control'] = 'text';
     388$database['tables']['#categories']['columns']['category']['values'] = '';
     389$database['tables']['#categories']['columns']['category']['watermark'] = '';
     390$database['tables']['#categories']['columns']['category']['gridDisplay'] = '0';
     391$database['tables']['#categories']['columns']['category']['keyField'] = '0';
     392$database['tables']['#categories']['columns']['category']['classes'] = '';
     393$database['tables']['#categories']['columns']['category']['other_attributes'] = '';
     394$database['tables']['#categories']['columns']['category']['message'] = '';
     395$database['tables']['#categories']['columns']['description']['Field'] = 'description';
     396$database['tables']['#categories']['columns']['description']['Type'] = 'text';
     397$database['tables']['#categories']['columns']['description']['Collation'] = 'utf8_general_ci';
     398$database['tables']['#categories']['columns']['description']['Null'] = 'YES';
     399$database['tables']['#categories']['columns']['description']['Key'] = '';
     400$database['tables']['#categories']['columns']['description']['Default'] = '';
     401$database['tables']['#categories']['columns']['description']['Extra'] = '';
     402$database['tables']['#categories']['columns']['description']['Privileges'] = 'select,insert,update,references';
     403$database['tables']['#categories']['columns']['description']['Comment'] = '';
     404$database['tables']['#categories']['columns']['description']['label'] = '';
     405$database['tables']['#categories']['columns']['description']['control'] = 'text';
     406$database['tables']['#categories']['columns']['description']['values'] = '';
     407$database['tables']['#categories']['columns']['description']['watermark'] = '';
     408$database['tables']['#categories']['columns']['description']['gridDisplay'] = '0';
     409$database['tables']['#categories']['columns']['description']['keyField'] = '0';
     410$database['tables']['#categories']['columns']['description']['classes'] = '';
     411$database['tables']['#categories']['columns']['description']['other_attributes'] = '';
     412$database['tables']['#categories']['columns']['description']['message'] = '';
     413$database['tables']['#categories']['Engine'] = 'MyISAM';
     414$database['tables']['#categories']['Collation'] = 'utf8_general_ci';
     415$database['tables']['#media']['columns']['id']['Field'] = 'id';
     416$database['tables']['#media']['columns']['id']['Type'] = 'bigint(20)';
     417$database['tables']['#media']['columns']['id']['Collation'] = '';
     418$database['tables']['#media']['columns']['id']['Null'] = 'NO';
     419$database['tables']['#media']['columns']['id']['Key'] = 'PRI';
     420$database['tables']['#media']['columns']['id']['Default'] = '';
     421$database['tables']['#media']['columns']['id']['Extra'] = 'auto_increment';
     422$database['tables']['#media']['columns']['id']['Privileges'] = 'select,insert,update,references';
     423$database['tables']['#media']['columns']['id']['Comment'] = '';
     424$database['tables']['#media']['columns']['id']['label'] = '';
     425$database['tables']['#media']['columns']['id']['control'] = 'text';
     426$database['tables']['#media']['columns']['id']['values'] = '';
     427$database['tables']['#media']['columns']['id']['watermark'] = '';
     428$database['tables']['#media']['columns']['id']['gridDisplay'] = '0';
     429$database['tables']['#media']['columns']['id']['keyField'] = '0';
     430$database['tables']['#media']['columns']['id']['classes'] = '';
     431$database['tables']['#media']['columns']['id']['other_attributes'] = '';
     432$database['tables']['#media']['columns']['id']['message'] = '';
     433$database['tables']['#media']['columns']['title']['Field'] = 'title';
     434$database['tables']['#media']['columns']['title']['Type'] = 'varchar(55)';
     435$database['tables']['#media']['columns']['title']['Collation'] = 'utf8_general_ci';
     436$database['tables']['#media']['columns']['title']['Null'] = 'NO';
     437$database['tables']['#media']['columns']['title']['Key'] = '';
     438$database['tables']['#media']['columns']['title']['Default'] = '';
     439$database['tables']['#media']['columns']['title']['Extra'] = '';
     440$database['tables']['#media']['columns']['title']['Privileges'] = 'select,insert,update,references';
     441$database['tables']['#media']['columns']['title']['Comment'] = '';
     442$database['tables']['#media']['columns']['title']['label'] = '';
     443$database['tables']['#media']['columns']['title']['control'] = 'text';
     444$database['tables']['#media']['columns']['title']['values'] = '';
     445$database['tables']['#media']['columns']['title']['watermark'] = '';
     446$database['tables']['#media']['columns']['title']['gridDisplay'] = '0';
     447$database['tables']['#media']['columns']['title']['keyField'] = '0';
     448$database['tables']['#media']['columns']['title']['classes'] = '';
     449$database['tables']['#media']['columns']['title']['other_attributes'] = '';
     450$database['tables']['#media']['columns']['title']['message'] = '';
     451$database['tables']['#media']['columns']['url']['Field'] = 'url';
     452$database['tables']['#media']['columns']['url']['Type'] = 'varchar(255)';
     453$database['tables']['#media']['columns']['url']['Collation'] = 'utf8_general_ci';
     454$database['tables']['#media']['columns']['url']['Null'] = 'NO';
     455$database['tables']['#media']['columns']['url']['Key'] = '';
     456$database['tables']['#media']['columns']['url']['Default'] = '';
     457$database['tables']['#media']['columns']['url']['Extra'] = '';
     458$database['tables']['#media']['columns']['url']['Privileges'] = 'select,insert,update,references';
     459$database['tables']['#media']['columns']['url']['Comment'] = '';
     460$database['tables']['#media']['columns']['url']['label'] = '';
     461$database['tables']['#media']['columns']['url']['control'] = 'text';
     462$database['tables']['#media']['columns']['url']['values'] = '';
     463$database['tables']['#media']['columns']['url']['watermark'] = '';
     464$database['tables']['#media']['columns']['url']['gridDisplay'] = '0';
     465$database['tables']['#media']['columns']['url']['keyField'] = '0';
     466$database['tables']['#media']['columns']['url']['classes'] = '';
     467$database['tables']['#media']['columns']['url']['other_attributes'] = '';
     468$database['tables']['#media']['columns']['url']['message'] = '';
     469$database['tables']['#media']['columns']['file']['Field'] = 'file';
     470$database['tables']['#media']['columns']['file']['Type'] = 'varchar(255)';
     471$database['tables']['#media']['columns']['file']['Collation'] = 'utf8_general_ci';
     472$database['tables']['#media']['columns']['file']['Null'] = 'NO';
     473$database['tables']['#media']['columns']['file']['Key'] = '';
     474$database['tables']['#media']['columns']['file']['Default'] = '';
     475$database['tables']['#media']['columns']['file']['Extra'] = '';
     476$database['tables']['#media']['columns']['file']['Privileges'] = 'select,insert,update,references';
     477$database['tables']['#media']['columns']['file']['Comment'] = '';
     478$database['tables']['#media']['columns']['file']['label'] = '';
     479$database['tables']['#media']['columns']['file']['control'] = 'text';
     480$database['tables']['#media']['columns']['file']['values'] = '';
     481$database['tables']['#media']['columns']['file']['watermark'] = '';
     482$database['tables']['#media']['columns']['file']['gridDisplay'] = '0';
     483$database['tables']['#media']['columns']['file']['keyField'] = '0';
     484$database['tables']['#media']['columns']['file']['classes'] = '';
     485$database['tables']['#media']['columns']['file']['other_attributes'] = '';
     486$database['tables']['#media']['columns']['file']['message'] = '';
     487$database['tables']['#media']['columns']['description']['Field'] = 'description';
     488$database['tables']['#media']['columns']['description']['Type'] = 'text';
     489$database['tables']['#media']['columns']['description']['Collation'] = 'utf8_general_ci';
     490$database['tables']['#media']['columns']['description']['Null'] = 'YES';
     491$database['tables']['#media']['columns']['description']['Key'] = '';
     492$database['tables']['#media']['columns']['description']['Default'] = '';
     493$database['tables']['#media']['columns']['description']['Extra'] = '';
     494$database['tables']['#media']['columns']['description']['Privileges'] = 'select,insert,update,references';
     495$database['tables']['#media']['columns']['description']['Comment'] = '';
     496$database['tables']['#media']['columns']['description']['label'] = '';
     497$database['tables']['#media']['columns']['description']['control'] = 'text';
     498$database['tables']['#media']['columns']['description']['values'] = '';
     499$database['tables']['#media']['columns']['description']['watermark'] = '';
     500$database['tables']['#media']['columns']['description']['gridDisplay'] = '0';
     501$database['tables']['#media']['columns']['description']['keyField'] = '0';
     502$database['tables']['#media']['columns']['description']['classes'] = '';
     503$database['tables']['#media']['columns']['description']['other_attributes'] = '';
     504$database['tables']['#media']['columns']['description']['message'] = '';
     505$database['tables']['#media']['columns']['order']['Field'] = 'order';
     506$database['tables']['#media']['columns']['order']['Type'] = 'bigint(20)';
     507$database['tables']['#media']['columns']['order']['Collation'] = '';
     508$database['tables']['#media']['columns']['order']['Null'] = 'NO';
     509$database['tables']['#media']['columns']['order']['Key'] = '';
     510$database['tables']['#media']['columns']['order']['Default'] = '';
     511$database['tables']['#media']['columns']['order']['Extra'] = '';
     512$database['tables']['#media']['columns']['order']['Privileges'] = 'select,insert,update,references';
     513$database['tables']['#media']['columns']['order']['Comment'] = '';
     514$database['tables']['#media']['columns']['order']['label'] = '';
     515$database['tables']['#media']['columns']['order']['control'] = 'text';
     516$database['tables']['#media']['columns']['order']['values'] = '';
     517$database['tables']['#media']['columns']['order']['watermark'] = '';
     518$database['tables']['#media']['columns']['order']['gridDisplay'] = '0';
     519$database['tables']['#media']['columns']['order']['keyField'] = '0';
     520$database['tables']['#media']['columns']['order']['classes'] = '';
     521$database['tables']['#media']['columns']['order']['other_attributes'] = '';
     522$database['tables']['#media']['columns']['order']['message'] = '';
     523$database['tables']['#media']['columns']['categoryid']['Field'] = 'categoryid';
     524$database['tables']['#media']['columns']['categoryid']['Type'] = 'bigint(20)';
     525$database['tables']['#media']['columns']['categoryid']['Collation'] = '';
     526$database['tables']['#media']['columns']['categoryid']['Null'] = 'NO';
     527$database['tables']['#media']['columns']['categoryid']['Key'] = '';
     528$database['tables']['#media']['columns']['categoryid']['Default'] = '';
     529$database['tables']['#media']['columns']['categoryid']['Extra'] = '';
     530$database['tables']['#media']['columns']['categoryid']['Privileges'] = 'select,insert,update,references';
     531$database['tables']['#media']['columns']['categoryid']['Comment'] = '';
     532$database['tables']['#media']['columns']['categoryid']['label'] = '';
     533$database['tables']['#media']['columns']['categoryid']['control'] = 'text';
     534$database['tables']['#media']['columns']['categoryid']['values'] = '';
     535$database['tables']['#media']['columns']['categoryid']['watermark'] = '';
     536$database['tables']['#media']['columns']['categoryid']['gridDisplay'] = '0';
     537$database['tables']['#media']['columns']['categoryid']['keyField'] = '0';
     538$database['tables']['#media']['columns']['categoryid']['classes'] = '';
     539$database['tables']['#media']['columns']['categoryid']['other_attributes'] = '';
     540$database['tables']['#media']['columns']['categoryid']['message'] = '';
     541$database['tables']['#media']['Engine'] = 'MyISAM';
     542$database['tables']['#media']['Collation'] = 'utf8_general_ci';
  • dmc-media/trunk/dmcmedia.php

    r1955446 r1995629  
    22/**
    33Plugin Name: DMC Media Play and Download
    4 Version: 2.6
     4Version: 3.0
    55Plugin URI: http://larrywakeman.com/download/dmc-media/
    66Donate URI: http://larrywakeman.com/download/dmc-media/
     
    1010*/
    1111/**
    12 ** Copyright © Larry Wakeman - 2016
     12** Copyright © Larry Wakeman - 2018
    1313**
    1414** All rights reserved. No part of this publication may be reproduced, stored in a retrieval system,
  • dmc-media/trunk/objects/dmc_admin.php

    r1681534 r1995629  
    409409   
    410410/**
     411* set ini values
     412*/
     413    protected function set_ini_values() {
     414        // over load this function in ...plugin/dmc-media_custom/dmc_admin_custom.php. See readme.
     415        // also see ini_set PHP docmentation, values here are for a 5 to 6 minute video
     416        @ini_set( 'upload_max_size' , '640M' ); // at least as large as largest file size to upload
     417        @ini_set( 'post_max_size', '640M'); // at least as large as upload_max_size
     418        @ini_set( 'max_execution_time', '800' ); // increase if upload timing out
     419    }
     420/**
    411421* Add/edit Page
    412422*/
    413423    function  DMC_edit ($id=0) {
    414424        global $wpdb;
     425        $this->set_ini_values();
     426        if ($id == 0) $action = "New"; else $action = "Edit";
    415427    if (($id == 0 || isset($_POST['upload'])) && !isset($_FILES['importfile']) && !isset($_POST['submit'])) {
    416428?>
    417429<div id="wpbody-content" tabindex="0" aria-label="Main content">
    418430    <div class="wrap">
    419         <h3>Edit Media Entry</h3>
     431        <h3><?php echo $action; ?> Media Entry</h3>
    420432        <form enctype="multipart/form-data" novalidate="novalidate" action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
    421433            <table class="form-table">
     
    478490    $categories = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."dmc_media_categories` ORDER BY category", ARRAY_A);
    479491    $result['title'] = str_replace(chr(0), '', $result['title']);
    480 ?>
     492        if ($id == 0) $action = "New"; else $action = "Edit";
     493?>
     494<script>
     495function do_validation() {
     496  if (jQuery('#title').val().length == 0 || jQuery('#title').val() == "") {
     497      alert ('Title is required');
     498      return false;
     499  }
     500  return true;
     501}
     502</script>
    481503<div id="wpbody-content" tabindex="0" aria-label="Main content">
    482504    <div class="wrap">
    483     <h3>Edit Media Entry</h3>
    484         <form novalidate="novalidate" action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
     505        <h3><?php echo $action; ?> Media Entry</h3>
     506        <form novalidate="novalidate" action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post" onsubmit="do_validation();">
    485507            <input type="hidden" name="id" value="<?php echo $result['id']; ?>">
    486508            <table class="form-table">
     
    905927    if (isset($_POST['update'])) {
    906928            $dbm = new lcw_common_dbMaintenence_plus('DMC_');
    907         $custom = substr($this->plugin_dir, 0, strlen($this->plugin_dir) - 1).'_custom/database_custom.php';
    908             $message= $dbm->update($this->plugin_dir.'db/database.php', $custom);
     929        $custom = substr($this->plugin_dir, 0, strlen($this->plugin_dir) - 1).'_custom/database_custom.';
     930        if (file_exists($custom.'json')) {
     931            $custom = $custom.'json';
     932        }
     933        else if (file_exists($custom.'php')) {
     934            $custom = $custom.'php';
     935        } else {
     936            $custom = '';
     937        }
     938        if (file_exists($this->plugin_dir.'db/database.json')) {
     939                $message = $dbm->update($this->plugin_dir.'db/database.json', $custom);
     940        } else if (file_exists($this->plugin_dir.'db/database.php')) {
     941                $message = $dbm->update($this->plugin_dir.'db/database.php', $custom);
     942        } else {
     943        ?>
     944        <div class="notice notice-success">
     945           <p>Schema deifinition not found</p>
     946        <?php
     947            return;
     948        }
    909949        ?>
    910950        <div class="notice notice-success">
    911951           <p>Schema Update Complete<br><?php echo $message; ?></p>
     952        </div>
     953        <?php
     954    }
     955    if (isset($_POST['JSON'])) {
     956            $dbm = new lcw_common_dbMaintenence_plus('DMC_');
     957        ?>
     958        <div class="notice notice-success">
     959<?php
     960                $dbm->convert_to_json($this->plugin_dir.'db/database.php');
     961            $custom = substr($this->plugin_dir, 0, strlen($this->plugin_dir) - 1).'_custom/database_custom.php';
     962                if (file_exists($custom)) $dbm->convert_to_json($custom);
     963?>
     964           <p>Conversion to JSON Complete</p>
     965        </div>
     966        <?php
     967    }
     968    if (isset($_POST['array'])) {
     969            $dbm = new lcw_common_dbMaintenence_plus('DMC_');
     970        ?>
     971<?php
     972                $dbm->convert_to_array($this->plugin_dir.'db/database.json');
     973            $custom = substr($this->plugin_dir, 0, strlen($this->plugin_dir) - 1).'_custom/database_custom.json';
     974                if (file_exists($custom)) $dbm->convert_to_array($custom);
     975?>
     976        <div class="notice notice-success">
     977           <p>Conversion to Array Complete</p>
    912978        </div>
    913979        <?php
     
    9391005                <input id="update" class="button button-primary" type="submit" value="Update Schema" name="update">
    9401006            </p>
     1007            <p class="submit">
     1008                <input id="JSON" class="button button-primary" type="submit" value="Convert to JSON" name="JSON">
     1009            </p>
     1010            <p class="submit">
     1011                <input id="array" class="button button-primary" type="submit" value="Convert to Array" name="array">
     1012            </p>
    9411013        </form>
    9421014    </div>
  • dmc-media/trunk/readme.txt

    r1959385 r1995629  
    66Tags: User Listing
    77Requires at least: 4.2.
    8 Tested up to: 5.0
    9 Stable tag: 2.6
     8Tested up to: 5.1
     9Stable tag: 3.0
    1010License: GPLv2 or later
    1111License URI: http://www.gnu.org/licenses/gpl-2.0.html
     
    8484* PHP 7.1
    8585
     86= 3.0 =
     87* upload larger files, tested to 5.5 minute video
     88* upload parameters modifiable with custimization
     89
    8690== Upgrade Notice ==
    8791
     
    124128* PHP 7.1
    125129
     130= 3.0 =
     131* upload larger files, tested to 5.5 minute video
     132* upload parameters modifiable with custimization
     133
    126134== Customization ==
    127135
Note: See TracChangeset for help on using the changeset viewer.