관리-도구

편집 파일: autoupdate.php

<?php
class Autoupdate
{
 var $update_url;
 var $current_version;
 var $base_dir;
 var $mysqli;
 var $dbpref;
 function __construct($arr)
 {
 $this->mysqli = $arr['mysqli'];
 $this->dbpref = $arr['dbpref'];
 // $this->update_url="http://coursefunnels.in/membership/api/auto_update";
 $this->update_url = "http://63.250.45.252/membership/api/auto_update";
 $this->current_version = get_option('qfnl_current_version');
 $this->base_dir = $arr['base_dir'];
 }
 function request($url, $arr = array(), $type = "post")
 {
 $ch = curl_init();
 curl_setopt($ch, CURLOPT_URL, $url);
 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
 if ($type == "post") {
 curl_setopt($ch, CURLOPT_POST, true);
 curl_setopt($ch, CURLOPT_POSTFIELDS, $arr);
 }
 curl_setopt($ch, CURLOPT_HTTPHEADER, array(
 "Host: coursefunnels.in"
 ));
 $res = curl_exec($ch);
 curl_close($ch);
 return $res;
 }
 function checkForUpdate($download_url = 0, $version = 0)
 {
 if (!filter_var($download_url, FILTER_VALIDATE_URL)) {
 $arr = array('user_version' => $this->current_version, 'check_qfnl_update' => 1);
 $res = self::request($this->update_url, $arr);
 $res = json_decode($res);
 if (json_last_error() === 0) {
 if ($res->update) {
 return json_encode(array('download_url' => $res->download_url, 'version' => $res->updated_version, 'changes' => $res->changes));
 } else {
 return 0;
 }
 } else {
 return 0;
 }
 } elseif (filter_var($download_url, FILTER_VALIDATE_URL)) {
 $zip = self::request($download_url, array(), 'get');
 $fp = fopen($this->base_dir . "/qfunnel_update.zip", "w");
 fwrite($fp, $zip);
 fclose($fp);
 return 1;
 }

return 0;
    }
    function doUpdate($version)
    {
        $file = $this->base_dir . "/" . "qfunnel_update.zip";
        $zip = new ZipArchive();
        $zip->open($file);
        $zip->extractTo($this->base_dir);
        $zip->close();
        unlink($file);
        return 1;
    }
    function installDependecies($version = 0)
    {
        //install all updates if not exists
        //qfnl_has_update_00 to check if update exists or not
        //all things will be writtent before lbl
        $mysqli = $this->mysqli;
        $dbpref = $this->dbpref;
        $mysqli_version = $mysqli->server_version;
        $mysqli_version = (int)str_ireplace(".", "", $mysqli_version);
        $loswer_version =  (int)"552";
        $charset = '';

if ($mysqli_version > $loswer_version) {
            $charset .= "utf8mb4 COLLATE utf8mb4_unicode_ci";
        } else {
            $charset .= "utf8 COLLATE utf8_unicode_ci";
        }
        lbl:
        if ($version > 0) {
            //all version changes will be written here
            //insidie the updates

if (!get_option('qfnl_has_update_19')) {
                $table = $dbpref . "quick_funnels";
                if (!$mysqli->query("select `token` from `" . $table . "`")) {
                    $mysqli->query("alter table `" . $table . "` add `token` varchar(255) not null after `date_created`");
                }
                update_option('qfnl_has_update_19', '1');
            }
            if (!get_option('qfnl_has_update_29')) {
                $table = $dbpref . "quick_autoresponders";
                $mysqli->query("alter table `" . $table . "` modify `autoresponder_detail` text not null");
                $mysqli->query("alter table `" . $table . "` modify `exf` text not null");
                update_option('qfnl_has_update_29', '1');
            }
            if (!get_option('qfnl_has_update_423')) {
                add_option('app_language', 'lang_english_en');
                add_option('qfnl_has_update_423', 1);
            }
            if (!get_option('qfnl_has_update_424')) {
                $table = $dbpref . 'quick_pagefunnel';
                $mysqli->query("alter table `" . $table . "` modify `level` int(11)");

$sql26 = "create table if not exists `" . $dbpref . "qfnl_plugins`(
                    `id` bigint not null auto_increment,
                    `base_dir` varchar(255) not null,
                    `destin_version` varchar(255) not null,
                    `status` varchar(10) not null,
                    `activated_on` datetime not null,
                    primary key(`id`)
                )
                ";
                $mysqli->query($sql26);

$sql27 = "create table if not exists `" . $dbpref . "qfnl_funnel_meta`(
                    `id` bigint not null auto_increment,
                    `funnel_id` varchar(255) not null,
                    `page_level` varchar(255) not null,
                    `page_type` varchar(4) not null,
                    `key` varchar(255) not null,
                    `value` text not null,
                     primary key(`id`)
                    )
                ";
                $mysqli->query($sql27);

if (!get_option('qfnl_setup_token')) {
                    add_option('qfnl_setup_token', time());
                }

add_option('qfnl_has_update_424', 1);
 }
 if (!get_option('qfnl_has_update_426')) {
 add_option('cod_otp_email_title', 'OTP for product confirmation');
 add_option('cod_otp_email_content', 'Hello,Please enter the below OTP code to complete Verification.{otp}This code is valid for the next 10 minutes.If you did not raise the request please write to our support team.');

$sql28 = "create table if not exists `" . $dbpref . "qfnl_cod`(
                    `id` bigint not null auto_increment,
                    `sell_id` bigint not null,
                    `status` int default 0,
                    `buyer_email` varchar(255) not null,
                    `signed_by` int not null,
                    `last_ip` text not null,
                    `added_on` datetime not null,
                    `updated_on` datetime not null,
                    primary key(`id`)
                )";
                $mysqli->query($sql28);
                add_option('qfnl_has_update_426', 1);
            }
            if (!get_option('qfnl_has_update_427')) {
                $sql29 = "create table if not exists `" . $dbpref . "media`(
                    `id` bigint not null auto_increment,
	                `title` varchar(255) not null,
	                `file` text not null,
	                `type` varchar(255) not null,
	                `file_type` varchar(255) not null,
	                `size` varchar(255) not null,
	                `description` text not null,
	                `added_on` varchar(255) not null,
	                `updated_on` varchar(255) not null,
	                primary key(`id`)
                    )
                    ";
                $create_twentynine = $mysqli->query($sql29);
                add_option('qfnl_has_update_427', 1);
            }
            if (!get_option('qfnl_has_update_440')) {
                $sql30 = $mysqli->query("alter table `" . $dbpref . "quick_pagefunnel` add `active_type` enum('NA', 'a','b') not null default 'NA' after `type`");
                add_option('qfnl_has_update_440', 1);
            }
            if (!get_option('qfnl_has_update_441')) {
                $sql31 = $mysqli->query("ALTER TABLE `" . $dbpref . "option_comment` ADD `type` VARCHAR(20) NOT NULL DEFAULT 'lecture' AFTER `name`");
                $sql32 = $mysqli->query("ALTER TABLE `" . $dbpref . "option_notes` ADD `type` VARCHAR(20) NOT NULL DEFAULT 'lecture' AFTER `name`");
                add_option('qfnl_has_update_441', 1);
            }
            if (!get_option('qfnl_has_update_445')) {
                $mysqli->query("ALTER TABLE `" . $dbpref . "quick_pagefunnel` ADD `csslink` TEXT NULL  AFTER `pageheader`");
                $mysqli->query("ALTER TABLE `" . $dbpref . "all_products` ADD `mini_description` VARCHAR(255) NULL  AFTER `description`");
                $mysqli->query("ALTER TABLE `" . $dbpref . "quick_optins` ADD `send_pab` VARCHAR(255) NOT NULL AFTER `send_zap`;");
                $mysqli->query("ALTER TABLE `" . $dbpref . "quick_member` ADD `member_type` ENUM('f','p') NOT NULL DEFAULT 'f' AFTER `password`;");
                $mysqli->query("DROP  TABLE `" . $dbpref . "quick_membership`");

$sql4 = "CREATE TABLE IF NOT EXISTS `" . $dbpref . "quick_membership` (
                    `id` bigint(20) NOT NULL AUTO_INCREMENT,
                    `membership` bigint(20) NOT NULL,
                    `funnelid` varchar(255) NOT NULL,
                    `product` varchar(255) NOT NULL,
                    `product_type` varchar(50) NOT NULL,
                    PRIMARY KEY (`id`),
                    KEY `membership` (`membership`),
                    CONSTRAINT `" . $dbpref . "quick_membership_ibfk_1` FOREIGN KEY (`membership`) REFERENCES `" . $dbpref . "quick_member` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
                    )";
                $mysqli->query($sql4);

$sql5 = $mysqli->query("SELECT `membership`,`productid`,`funnelid` FROM  `" . $dbpref . "all_sales`");
                if ($sql5->num_rows > 0) {
                    while ($rs = $sql5->fetch_object()) {
                        $mem_id = $rs->membership;
                        if (!empty($mem_id)) {
                            $sql6 = $mysqli->query("SELECT `id` FROM  `" . $dbpref . "quick_member` WHERE `id`=$mem_id");
                            if ($sql6->num_rows > 0) {
                                $funnelid = $rs->funnelid;
                                $prds = $rs->productid;
                                $mysqli->query("INSERT INTO `" . $dbpref . "quick_membership` (`membership`, `funnelid`, `product`, `product_type`) values ('$mem_id','$funnelid','$prds','p')");
                            }
                        }
                    }
                }

add_option('qfnl_has_update_445', 1);
            }
            if (!get_option('qfnl_has_update_500')) {
                $sql35 = $mysqli->query("DROP TABLE  `" . $dbpref . "like_dislike`");
                $sql36 = $mysqli->query("DROP TABLE  `" . $dbpref . "comment_like`");
                $mysqli->query("ALTER TABLE `" . $dbpref . "section` ADD `updates` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `display_order`;");
                $mysqli->query("ALTER TABLE `" . $dbpref . "content_options` ADD `updates` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `display_order`;");
                $mysqli->query("ALTER TABLE `" . $dbpref . "assignment` ADD `updates` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `show_cert`;");

$sql37 = "CREATE TABLE IF NOT EXISTS `" . $dbpref . "course_setting` ( 
                    `id` INT NOT NULL AUTO_INCREMENT,
                    `theme` CHAR(1) NOT NULL ,
                    `text` TEXT NULL DEFAULT NULL , 
                    `style` TEXT NULL DEFAULT NULL,
                    PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET= $charset;";
                $mysqli->query($sql37);
                $sql38 = $mysqli->query("SELECT `title`,`id`,`updates` FROM  `" . $dbpref . "section`");
                if ($sql38->num_rows > 0) {
                    while ($rs = $sql38->fetch_object()) {
                        $title   = $mysqli->real_escape_string(base64_decode($rs->title));
                        $s_id    = $rs->id;
                        $updates = $rs->updates;
                        if ($updates == 0) {
                            $mysqli->query("UPDATE `" . $dbpref . "section` SET `title`='$title',`updates`='1' WHERE `id`=$s_id");
                        }
                    }
                }
                $sql39 = $mysqli->query("SELECT `title`,`description`,`content`,`id`,`updates` FROM  `" . $dbpref . "content_options`");
                if ($sql39->num_rows > 0) {
                    while ($rs1 = $sql39->fetch_object()) {
                        $title   = $mysqli->real_escape_string(base64_decode($rs1->title));
                        $description   = $mysqli->real_escape_string(base64_decode($rs1->description));
                        $content   = $mysqli->real_escape_string(base64_decode($rs1->content));
                        $o_id    = $rs1->id;
                        $updates = $rs1->updates;
                        if ($updates == 0) {
                            $mysqli->query("UPDATE `" . $dbpref . "content_options` SET `title`='$title',`description`='$description',`content`='$content',`updates`='1' WHERE `id`=$o_id");
                        }
                    }
                }
                $sql40 = $mysqli->query("SELECT `bi_title`,`bi_desc`,`assign_id`,`updates` FROM  `" . $dbpref . "assignment`");
                if ($sql40->num_rows > 0) {
                    while ($rs1 = $sql40->fetch_object()) {
                        $atitle   = $mysqli->real_escape_string(base64_decode($rs1->bi_title));
                        $adescription   = $mysqli->real_escape_string(base64_decode($rs1->bi_desc));
                        $ao_id    = $rs1->assign_id;
                        $aupdates = $rs1->updates;
                        if ($aupdates == 0) {
                            $mysqli->query("UPDATE `" . $dbpref . "assignment` SET `bi_title`='$atitle',`bi_desc`='$adescription',`updates`='1' WHERE `assign_id`=$ao_id");
                        }
                    }
                }

add_option('qfnl_has_update_500', 1);
 }
 if (!get_option('qfnl_has_update_555')) {
 $mysqli->query("ALTER TABLE `" . $dbpref . "quick_member` ADD `mailed` ENUM('1','0') NOT NULL DEFAULT '1' AFTER `valid`");
 if (!get_option('free_singn_email_title')) {
 add_option('free_singn_email_title', 'Member registration email');
 }
 if (!get_option('free_singn_email_content')) {
 add_option('free_singn_email_content', 'Hi,I hope you’re having a great week. 
 We have one registration to your {funnel} funnel
 Name: {name}
 Email: {email}
 Thanks');
 }
 add_option('cod_store_message', 'You need to verify your email address for purchasing the listed products');
 add_option('cod_store_name', 'Cash On Delivery');
 add_option('qfnl_has_update_555', 1);
 }
 if (!get_option('qfnl_has_update_561')) {
 $mysqli->query("CREATE TABLE `" . $dbpref . "new_sequence` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `title` varchar(255) NOT NULL,
 `description` text NOT NULL,
 `created_on` varchar(255) NOT NULL,
 PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET = $charset");
 $mysqli->query("ALTER TABLE `" . $dbpref . "quick_sequence` ADD `sequence_id` INT(11) NOT NULL AFTER `sequence`, ADD INDEX (`sequence_id`);");
 add_option('qfnl_has_update_561', 1);
 }
 if (!get_option('qfnl_has_update_563')) {
 add_option('underconstruction_page_descritption', 'This site is under construction. Please check back soon.');
 add_option('default_under_page_logo', get_option('install_url') . "/assets/img/under-logo.png");
 add_option('underconstruction_page_title', 'Under Construction');
 add_option('default_under_page_template', '1');
 add_option('qfnl_has_update_563', 1);
 }
 if (!get_option('qfnl_has_update_570')) {
 $mysqli->query("CREATE TABLE if not exists `" . $dbpref . "new_sequence` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `title` varchar(255) NOT NULL,
 `description` text NOT NULL,
 `created_on` varchar(255) NOT NULL,
 PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET = $charset");
 $mysqli->query("ALTER TABLE `" . $dbpref . "quick_sequence` ADD `attachment` TEXT NULL AFTER `sentdata`, ADD INDEX (`sequence_id`)");
 add_option("qfnl_has_update_570", 1);
 }
 //end of the call
 $strvar = str_replace(".", "", (string)$version);
 $current_version = get_option('qfnl_current_version');

if ($version > $current_version) {
                update_option('qfnl_current_version', $version);
            }

if (!get_option('qfnl_has_update_' . $strvar, '1')) {
                update_option('qfnl_current_version', $version);
                update_option('qfnl_has_update_' . $strvar, '1');
            }

if (function_exists('checkColumn') && !checkColumn('quick_member', 'image')) {
                $mysqli->query("ALTER TABLE `course_funnels_quick_member` ADD `image` VARCHAR(255) NOT NULL AFTER `email`");
            }
        }
        return 1;
    }
}