root/afridex/plugins/Flutter/canvas-install.php @ 21

<?php

/*

___Canvas Installation Scripts__________________________________

Creates the necessary SQL tables for a clean Canvas install.

________________________________________________________________

*/


function canvas_clean_install() {
    global $wpdb, $canvas;
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->main."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->variables."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->options."");
        canvas_install();
        return true;
}

function canvas_clean_deactivate() {
        global $wpdb, $canvas;
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->main."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->duplicates."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->variables."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->options."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->zone_options."");
        $wpdb->query("DROP TABLE IF EXISTS ".$canvas->ink."");

        return true;
}



function canvas_create_db() {
        global $wpdb, $canvas;

        ${$canvas->main} = "CREATE TABLE ".$canvas->main." (
                block_id INT NOT NULL AUTO_INCREMENT,
                PRIMARY KEY(block_id),
                        module_id INT NOT NULL,
                        type tinytext NOT NULL,
                        zone tinytext NOT NULL,
                        position int(6) NOT NULL,
                        author tinytext NOT NULL,
                        description text NOT NULL,
                        block_group tinytext NOT NULL,
                        uri text NOT NULL,
                        path text NOT NULL,
                        theme tinytext NOT NULL,
                        ubi text NOT NULL,
                        template_name text NOT NULL,
                        template_size text NOT NULL,
                        duplicate_id INT NOT NULL,
                        page text NOT NULL
                        );";

        ${$canvas->duplicates} = "CREATE TABLE ".$canvas->duplicates." (
                duplicate_id INT NOT NULL AUTO_INCREMENT,
                PRIMARY KEY(duplicate_id),
                        module_id INT NOT NULL,
                        duplicate_name text NOT NULL
                        );";


        ${$canvas->variables} = "CREATE TABLE ".$canvas->variables." (
                        variable_id INT NOT NULL AUTO_INCREMENT,
                        PRIMARY KEY(variable_id),
                        variable_name text NOT NULL,
                        parent INT NOT NULL,
                        type text NOT NULL,
                        value text NOT NULL,
                        default_value text NOT NULL,
                        description text NOT NULL
                        );";

        ${$canvas->options} = "CREATE TABLE ".$canvas->options." (
                        option_id INT NOT NULL AUTO_INCREMENT,
                        PRIMARY KEY(option_id),
                        var_id INT NOT NULL,
                        option_text text NOT NULL,
                        option_value text NOT NULL,
                        option_params text NOT NULL
                        );";

        ${$canvas->zone_options} = "CREATE TABLE ".$canvas->zone_options." (
                        option_id INT NOT NULL AUTO_INCREMENT,
                        PRIMARY KEY(option_id),
                        zone text NOT NULL,
                        option_name text NOT NULL,
                        value text NOT NULL,
                        theme text NOT NULL
                        );";

        ${$canvas->ink} = "CREATE TABLE ".$canvas->ink." (
                element_id INT NOT NULL AUTO_INCREMENT,
                PRIMARY KEY(element_id),
                        element text NOT NULL,
                        theme text NOT NULL,
                        color text NOT NULL,
                        background text NOT NULL,
                        border text NOT NULL,
                        font_family text NOT NULL,
                        font_size text NOT NULL,
                        font_style text NOT NULL,
                        other text NOT NULL
                        );";

        // try to get around
        // these includes like http://trac.mu.wordpress.org/ticket/384 
        // and http://www.quirm.net/punbb/viewtopic.php?pid=832#p832

        if (file_exists(ABSPATH . 'wp-includes/pluggable.php')) {
                require_once(ABSPATH . 'wp-includes/pluggable.php');
        } else {
                require_once(ABSPATH . 'wp-includes/pluggable-functions.php');
        }
        require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
        
        foreach($canvas as $table)
                dbDelta(${$table});
        
        return;
}

function canvas_install($DBChanged=false) {
        global $wpdb, $canvas; //, $installed, $canvas_external_plugins;
        
        if(!$wpdb->get_var("SHOW TABLES LIKE '".$canvas->main."'") == $canvas->main ||
                        $DBChanged) {
                canvas_create_db();
                update_option('RC_CWP_BLOG_DB_VERSION', RC_CWP_DB_VERSION);
                ink_clean_install();
                //canvas_check_theme();
                
                
                update_option('canvas_auto_publish','false'); // for future releases

                /*if(file_exists(get_template_directory().'/canvas.php') && !$wpdb->get_results("SELECT block_id FROM ".$canvas->main." WHERE theme = '".get_option('template')."'")) {
                        $position = 1;
                        $canvas_dir = CANVASPATH.'/modules/';
                        list($plugins, $position) = canvas_import_plugins($position, $canvas_dir);
                } elseif(file_exists(get_template_directory().'/canvas.php')) {
                        canvas_reload();
                }*/

                

        }
        
        return true;
}


function canvas_reload() {
        global $wpdb, $canvas, $canvas_external_plugins;
        $current_blocks = $wpdb->get_results("SELECT block_id, path FROM ".$canvas->main." WHERE theme = '".get_option('template')."' AND type = 'block'");
        $current_plugins = $wpdb->get_results("SELECT block_id, path FROM ".$canvas->main." WHERE theme = '".get_option('template')."' AND type = 'plugin'");
        $positions = $wpdb->get_var("SELECT MAX(position) FROM ".$canvas->main." WHERE theme = '".get_option('template')."' AND zone = 'shelf'");
        if($positions) $position = $positions->position;
                else $position = 1;
        $block_count = 0; $plugin_count = 0;
        foreach($current_blocks as $block) {
                $current_block_paths[] = $block->path;
        }
        foreach($current_plugins as $plugin) {
                $current_plugin_paths[] = $plugin->path;
        }

        // Search for modules
        $dir = CANVASPATH.'/modules/';
        canvas_import_plugins($position, $dir);
                

        if($block_count > 0 || $plugin_count > 0) $message = '<p>Installed '.$block_count.' blocks and '.$plugin_count.' plugins.</p>';
                else $message = '<p>No new blocks or plugins found.</p>';

        return $message;
}

?>