/libs/lib-setup.php

  1. <?php 
  2.  
  3. if ( ! function_exists('gde_activate') ) { 
  4.   // no access if parent plugin is disabled or when accessed directly 
  5.   wp_die('<p>'.__('You do not have sufficient permissions to access this page.').'</p>'); 
  6. } 
  7.  
  8. /** 
  9.  * Define system defaults (settings/profiles) 
  10.  * 
  11.  * @since    2.5.5.1 
  12.  * @return  mixed 
  13.  */ 
  14. function gde_defaults( $type ) { 
  15.   global $env; 
  16.    
  17.   // gather/set environment info 
  18.   if ( ! $env ) { 
  19.       $pdata = gde_get_plugin_data(); 
  20.       $baseurl = gde_base_url(); 
  21.       $default_lang = gde_get_locale(); 
  22.       $apikey = ''; 
  23.       $env = array( 
  24.           'pdata' =>    $pdata,  
  25.           'baseurl' =>    $baseurl,  
  26.           'default_lang' =>    $default_lang 
  27.  ); 
  28.   } 
  29.    
  30.   // define "global" options (multisite only) 
  31.   $globalopts = array( 
  32.       'file_maxsize' =>    '12',  
  33.       'beta_check' =>    'no' 
  34.  ); 
  35.    
  36.   // define default options 
  37.   $defopts = array( 
  38.       'ed_disable' =>    'no',  
  39.       'ed_extend_upload' =>    'yes',  
  40.       'ed_embed_sc' =>    'yes',  
  41.       'file_maxsize' =>    '12',  
  42.       'error_check' =>    'yes',  
  43.       'error_display' =>    'yes',  
  44.       'error_log' =>    'no',  
  45.       'beta_check' =>    'no',  
  46.       'ga_enable' =>    'no',  
  47.       'ga_category' =>    $env['pdata']['Name'],  
  48.       'ga_label' =>    'url' 
  49.  ); 
  50.    
  51.   // define default profile(s) 
  52.   $defpros = array( 
  53.       "default" => array( 
  54.           "desc" =>    __('This is the default profile, used when no profile is specified.', 'google-document-embedder'),  
  55.           "viewer" =>    'standard',  
  56.           "default_width" =>    '100%',  
  57.           "default_height" =>    '500px',  
  58.           "tb_mobile" =>    'default',  
  59.           "tb_flags" =>    '',  
  60.           "tb_fullscr" =>    'default',  
  61.           "tb_fullwin" =>    'new',  
  62.           "tb_fulluser" =>    'no',  
  63.           "tb_print" =>    'no',  
  64.           "vw_bgcolor" =>    '#EBEBEB',  
  65.           "vw_pbcolor" =>    '#DADADA',  
  66.           "vw_css" =>    '',  
  67.           "vw_flags" =>    '',  
  68.           "language" =>    $env['default_lang'],  
  69.           "base_url" =>    $env['baseurl'],  
  70.           "link_show" =>    'all',  
  71.           "link_mask" =>    'no',  
  72.           "link_block" =>    'no',  
  73.           "link_text" =>    __('Download', 'google-document-embedder') . ' (%TYPE, %SIZE)',  
  74.           "link_pos" =>    'below',  
  75.           "link_force" =>    'no',  
  76.           "cache" =>    'on' 
  77.  ),  
  78.       "max-doc-security" => array( 
  79.           "desc" =>    __('Hide document location and text selection, prevent downloads', 'google-document-embedder'),  
  80.           "viewer" =>    'enhanced',  
  81.           "default_width" =>    '100%',  
  82.           "default_height" =>    '500px',  
  83.           "tb_mobile" =>    'default',  
  84.           "tb_flags" =>    '',  
  85.           "tb_fullscr" =>    'viewer',  
  86.           "tb_fullwin" =>    'new',  
  87.           "tb_fulluser" =>    'no',  
  88.           "tb_print" =>    'no',  
  89.           "vw_bgcolor" =>    '#EBEBEB',  
  90.           "vw_pbcolor" =>    '#DADADA',  
  91.           "vw_css" =>    '',  
  92.           "vw_flags" =>    '',  
  93.           "language" =>    $env['default_lang'],  
  94.           "base_url" =>    $env['baseurl'],  
  95.           "link_show" =>    'none',  
  96.           "link_mask" =>    'no',  
  97.           "link_block" =>    'yes',  
  98.           "link_text" =>    '',  
  99.           "link_pos" =>    'below',  
  100.           "link_force" =>    'no',  
  101.           "cache" =>    'on' 
  102.  ),  
  103.       "dark" => array( 
  104.           "desc" =>    __('Dark-colored theme, example of custom CSS option', 'google-document-embedder'),  
  105.           "viewer" =>    'enhanced',  
  106.           "default_width" =>    '100%',  
  107.           "default_height" =>    '500px',  
  108.           "tb_mobile" =>    'default',  
  109.           "tb_flags" =>    '',  
  110.           "tb_fullscr" =>    'viewer',  
  111.           "tb_fullwin" =>    'new',  
  112.           "tb_fulluser" =>    'no',  
  113.           "tb_print" =>    'no',  
  114.           "vw_bgcolor" =>    '',  
  115.           "vw_pbcolor" =>    '',  
  116.           "vw_css" =>    GDE_PLUGIN_URL . 'css/gde-dark.css',  
  117.           "vw_flags" =>    '',  
  118.           "language" =>    $env['default_lang'],  
  119.           "base_url" =>    $env['baseurl'],  
  120.           "link_show" =>    'all',  
  121.           "link_mask" =>    'no',  
  122.           "link_block" =>    'no',  
  123.           "link_text" =>    __('Download', 'google-document-embedder') . ' (%TYPE, %SIZE)',  
  124.           "link_pos" =>    'below',  
  125.           "link_force" =>    'no',  
  126.           "cache" =>    'on' 
  127.  ) 
  128.  ); 
  129.    
  130.   switch ( $type ) { 
  131.       case "globals": 
  132.           return $globalopts; 
  133.           break; 
  134.       case "options": 
  135.           return $defopts; 
  136.           break; 
  137.       case "profiles": 
  138.           return $defpros; 
  139.           break; 
  140.       default: 
  141.           gde_dx_log('Defaults requested but type not specified'); 
  142.           return false; 
  143.           break; 
  144.   } 
  145. } 
  146.  
  147. /** 
  148.  * Perform activation 
  149.  * 
  150.  * @since    2.5.0.1 
  151.  * @return  void 
  152.  */ 
  153. function gde_setup() { 
  154.   if ( GDE_DX_LOGGING > 0 ) { 
  155.       gde_dx_log("Dx log manually enabled in functions.php"); 
  156.   } 
  157.    
  158.   // clear any beta transient 
  159.   gde_dx_log("Clearing beta cache"); 
  160.   delete_site_transient( 'gde_beta_version' ); 
  161.   delete_transient( 'gde_beta_version' ); 
  162.   delete_option( 'external_updates-google-document-embedder' ); 
  163.    
  164.   gde_dx_log("Activating..."); 
  165.    
  166.   if ( is_multisite() ) { 
  167.       if ( ! $gdeglobals = get_site_option( 'gde_globals' ) ) { 
  168.           gde_dx_log("Writing multisite global options"); 
  169.           $globalopts = gde_defaults('global'); 
  170.           update_site_option( 'gde_globals', $globalopts ); 
  171.       } 
  172.   } 
  173.    
  174.   // check for existing or updated options 
  175.   $gdeoptions = gde_get_options(); 
  176.    
  177.   // check for existence of default profile (re-activation?) 
  178.   if ( ! gde_get_profiles( 1 ) ) { 
  179.       // new activation - write profile(s) 
  180.       $defpros = gde_defaults('profiles'); 
  181.       foreach ( $defpros as $key => $prodata ) { 
  182.           if ( $key == "default" ) { 
  183.               $id = 1; // default profile is always ID 1 
  184.           } else { 
  185.               $id = null;    // assign next id 
  186.           } 
  187.            
  188.           // prepare profile 
  189.           $desc = $prodata['desc']; 
  190.           unset( $prodata['desc'] ); 
  191.            
  192.           // write profile 
  193.           $data = serialize( $prodata ); 
  194.           $profile = array( $key, $desc, $data ); 
  195.           if ( gde_write_profile( $profile, $id ) < 1 ) { 
  196.               gde_dx_log("Failed to write profile '$key'"); 
  197.           } 
  198.       } 
  199.   } else { 
  200.       gde_dx_log("Profiles already exist"); 
  201.       update_profiles(); 
  202.   } 
  203.    
  204.   gde_dx_log("Activation complete."); 
  205. } 
  206.  
  207. /** 
  208.  * Upgrade profiles if changes have been made 
  209.  * 
  210.  * @since    2.5.5.1 
  211.  * @return  void 
  212.  */ 
  213. function update_profiles() { 
  214.   $prodata = gde_get_profiles(); 
  215.   $defpros = gde_defaults('profiles'); 
  216.   $default = $defpros['default']; 
  217.    
  218.   foreach ( $prodata as $profile ) { 
  219.       $updated = false; 
  220.        
  221.       $id = $profile['profile_id']; 
  222.       if ( $data = @unserialize( $profile['profile_data'] ) ) { 
  223.           foreach ( $default as $k => $v ) { 
  224.               if ( $k !== "desc" && ! array_key_exists( $k, $data ) ) { 
  225.                   $data[$k] = $default[$k]; 
  226.                    
  227.                   $updated = true; 
  228.               } 
  229.           } 
  230.            
  231.           if ( $updated ) { 
  232.               // write updated profile 
  233.               $data = serialize( $data ); 
  234.               $newpro = array( $profile['profile_name'], $profile['profile_desc'], $data ); 
  235.               if ( gde_write_profile( $newpro, $id, true ) < 1 ) { 
  236.                   gde_dx_log("Failed to update profile '" . $profile['profile_name'] . "'"); 
  237.               } 
  238.           } 
  239.       } 
  240.   } 
  241. } 
  242.  
  243. /** 
  244.  * Get the current options, upgrading or resetting them as needed 
  245.  * 
  246.  * @since    2.5.5.1 
  247.  * @return  array Current value of gde_options 
  248.  */ 
  249. function gde_get_options() { 
  250.   $defopts = gde_defaults('options'); 
  251.    
  252.   if ( ! $gdeoptions = get_option('gde_options') ) { 
  253.       // options don't exist 
  254.       gde_dx_log("Writing default options"); 
  255.       update_option('gde_options', $defopts); 
  256.   } else { 
  257.       // check if upgrading from < 2.5 
  258.       if ( isset( $gdeoptions['default_width'] ) ) { 
  259.           gde_dx_log("Old options found - resetting"); 
  260.           $defopts['upgraded'] = "yes"; 
  261.           update_option('gde_options', $defopts); 
  262.       } else { 
  263.           gde_dx_log("Options already exist"); 
  264.            
  265.           // check or upgrade options 
  266.           $updated = false; 
  267.           foreach ( $defopts as $k => $v ) { 
  268.               if ( ! array_key_exists( $k, $gdeoptions ) ) { 
  269.                   $gdeoptions[$k] = $v; 
  270.                   //gde_dx_log("New option $k added"); 
  271.                   $updated = true; 
  272.               } 
  273.           } 
  274.            
  275.           if ( $updated ) { 
  276.               gde_dx_log('Options were updated'); 
  277.               update_option('gde_options', $defopts); 
  278.           } 
  279.       } 
  280.   } 
  281.    
  282.   return $gdeoptions; 
  283. } 
  284.  
  285. /** 
  286.  * Create/update database table to store profile data 
  287.  * 
  288.  * @since   2.5.0.1 
  289.  * @return  bool Whether or not table creation/update was successful 
  290.  */ 
  291. function gde_db_tables( $gde_db_ver ) { 
  292.   global $wpdb; 
  293.    
  294.   // attempt to trap table creation failures 
  295.   $fails = 0; 
  296.    
  297.   // check for missing required tables (clear db version) 
  298.   $table = $wpdb->prefix . 'gde_profiles'; 
  299.   if ($wpdb->get_var( "SHOW TABLES LIKE '$table'" ) !== $table) { 
  300.       //gde_dx_log("profiles db failed health check"); 
  301.       delete_site_option( 'gde_db_version' ); 
  302.   } 
  303.    
  304.   $table = $wpdb->prefix . 'gde_secure'; 
  305.   if ($wpdb->get_var( "SHOW TABLES LIKE '$table'" ) !== $table) { 
  306.       //gde_dx_log("securedoc db failed health check"); 
  307.       delete_site_option( 'gde_db_version' ); 
  308.   } 
  309.    
  310.   if ( is_multisite() ) { 
  311.       $db_ver_installed = get_site_option( 'gde_db_version', 0 ); 
  312.   } else { 
  313.       $db_ver_installed = get_option( 'gde_db_version', 0 ); 
  314.   } 
  315.    
  316.   gde_dx_log("Installed DB ver: $db_ver_installed; This DB ver: " . $gde_db_ver ); 
  317.   if ( version_compare( $gde_db_ver, $db_ver_installed, ">" ) ) { 
  318.       // install or upgrade profile table 
  319.       $table = $wpdb->prefix . 'gde_profiles'; 
  320.    
  321.       $sql = "CREATE TABLE " . $table . " ( 
  322.         profile_id mediumint(9) UNSIGNED NOT NULL AUTO_INCREMENT,  
  323.         profile_name varchar(64) NOT NULL,  
  324.         profile_desc varchar(255) NULL,  
  325.         profile_data longtext NOT NULL,  
  326.         UNIQUE KEY (profile_id) 
  327.  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; "; 
  328.  
  329.       if ( isset( $sql ) ) { 
  330.           // write table or update to database 
  331.           require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); 
  332.           dbDelta($sql); 
  333.            
  334.           if ($wpdb->get_var( "SHOW TABLES LIKE '$table'" ) == $table ) { 
  335.               gde_dx_log("Profile table create/update successful"); 
  336.           } else { 
  337.               gde_dx_log("Profile table create/update failed"); 
  338.               $fails++; 
  339.           } 
  340.       } 
  341.        
  342.       // install or upgrade securedoc table 
  343.       $table = $wpdb->prefix . 'gde_secure'; 
  344.       $sql = "CREATE TABLE " . $table . " ( 
  345.         code varchar(10) NOT NULL,  
  346.         url varchar(255) NOT NULL,  
  347.         murl varchar(100) NOT NULL,  
  348.         stamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  
  349.         autoexpire enum('Y', 'N') NOT NULL DEFAULT 'N',  
  350.         UNIQUE KEY code (code) 
  351.  ) ENGINE=MyISAM DEFAULT CHARSET=utf8; "; 
  352.        
  353.       if ( isset( $sql ) ) { 
  354.           // write table or update to database 
  355.           require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); 
  356.           dbDelta( $sql ); 
  357.            
  358.           if ( $wpdb->get_var( "SHOW TABLES LIKE '$table'" ) == $table ) { 
  359.               gde_dx_log("Secure doc table create/update successful"); 
  360.           } else { 
  361.               gde_dx_log("Secure doc table create/update failed"); 
  362.               $fails++; 
  363.           } 
  364.       } 
  365.   } else { 
  366.       gde_dx_log("Tables OK, nothing to do"); 
  367.   } 
  368.    
  369.   if ( $fails > 0 ) { 
  370.       delete_site_option( 'gde_db_version' ); 
  371.       return false; 
  372.   } else { 
  373.       update_site_option( 'gde_db_version', $gde_db_ver ); 
  374.       return true; 
  375.   } 
  376. } 
  377.  
  378. ?> 
.