Ignore:
Timestamp:
Feb 19, 2011, 11:13:22 PM (13 years ago)
Author:
patdenice
Message:

Lot of optimization.
Add privacy level management.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/AdditionalPages/maintain.inc.php

    r9272 r9310  
    1717users VARCHAR( 255 ) NULL DEFAULT NULL ,
    1818groups VARCHAR( 255 ) NULL DEFAULT NULL ,
     19level TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT "0" ,
    1920permalink VARCHAR( 64 ) NULL DEFAULT NULL ,
    2021standalone ENUM( "true", "false" ) NOT NULL DEFAULT "false" ,
     
    3132      'languages' => array('default' => 'Additional Pages'),
    3233      'show_home' => true,
     34      'level_perm' => false,
    3335      'group_perm' => false,
    3436      'user_perm' => false,
     
    5658    pwg_query('ALTER TABLE ' . HISTORY_TABLE . ' CHANGE section section ' . $type . ' DEFAULT NULL');
    5759  }
    58  
    59   // Check if upgrade is needed
    60   $query = 'SHOW FULL COLUMNS FROM ' . $prefixeTable . 'additionalpages;';
    61   $result = array_from_query($query, 'Collation');
    62   if (strpos($result[4], 'utf8') === false)
    63   {
    64     upgrade_ap_from_17();
    65   }
    6660}
    6761
     
    7771}
    7872
    79 function upgrade_ap_from_17()
    80 {
    81   global $prefixeTable;
    82 
    83   $query = 'ALTER TABLE ' . $prefixeTable . 'additionalpages
    84 MODIFY COLUMN lang varchar(255) CHARACTER SET utf8 NOT NULL,
    85 MODIFY COLUMN title varchar(255) CHARACTER SET utf8 NOT NULL,
    86 MODIFY COLUMN text longtext CHARACTER SET utf8 NOT NULL,
    87 DEFAULT CHARACTER SET utf8;';
    88 
    89   pwg_query($query);
    90 }
    91 
    9273?>
Note: See TracChangeset for help on using the changeset viewer.