| @@ -1,7 +1,7 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | global $ays_poll_db_version; |
| 3 | -$ays_poll_db_version = '1.8.7'; | |
| 3 | +$ays_poll_db_version = '1.9.1'; | |
| 4 | 4 | /** |
| 5 | 5 | * Fired during plugin activation |
| 6 | 6 | * |
| 7 | 7 | * @link https://ays-pro.com/ |
| @@ -30,17 +30,36 @@ | ||
| 30 | 30 | * |
| 31 | 31 | * @since 1.0.0 |
| 32 | 32 | */ |
| 33 | 33 | public static function activate() { |
| 34 | + if (function_exists('is_multisite') && is_multisite()) { | |
| 35 | + if (isset($_GET['networkwide']) && (int)$_GET['networkwide'] === 1) { | |
| 36 | + global $wpdb; | |
| 37 | + $blog_ids = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs"); | |
| 38 | + | |
| 39 | + foreach ($blog_ids as $blog_id) { | |
| 40 | + switch_to_blog($blog_id); | |
| 41 | + self::create_tables(); | |
| 42 | + restore_current_blog(); | |
| 43 | + } | |
| 44 | + return; | |
| 45 | + } | |
| 46 | + } | |
| 47 | + | |
| 48 | + self::create_tables(); | |
| 49 | + } | |
| 50 | + | |
| 51 | + private static function create_tables() { | |
| 34 | 52 | require_once ABSPATH . 'wp-admin/includes/upgrade.php'; |
| 35 | 53 | global $wpdb; |
| 36 | - $polls_table = $wpdb->prefix . 'ayspoll_polls'; | |
| 37 | - $cats_table = $wpdb->prefix . 'ayspoll_categories'; | |
| 38 | - $answers_table = $wpdb->prefix . 'ayspoll_answers'; | |
| 39 | - $reports_table = $wpdb->prefix . 'ayspoll_reports'; | |
| 40 | - $settings_table = $wpdb->prefix . 'ayspoll_settings'; | |
| 41 | - $charset_collate = $wpdb->get_charset_collate(); | |
| 42 | - | |
| 54 | + $polls_table = $wpdb->prefix . 'ayspoll_polls'; | |
| 55 | + $cats_table = $wpdb->prefix . 'ayspoll_categories'; | |
| 56 | + $answers_table = $wpdb->prefix . 'ayspoll_answers'; | |
| 57 | + $reports_table = $wpdb->prefix . 'ayspoll_reports'; | |
| 58 | + $settings_table = $wpdb->prefix . 'ayspoll_settings'; | |
| 59 | + $charset_collate = $wpdb->get_charset_collate(); | |
| 60 | + $is_multisite = function_exists('is_multisite') && is_multisite(); | |
| 61 | + | |
| 43 | 62 | $sql = "CREATE TABLE $polls_table ( |
| 44 | 63 | id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 45 | 64 | post_id INT(16) UNSIGNED DEFAULT NULL, |
| 46 | 65 | title VARCHAR(255) NOT NULL, |
| @@ -48,12 +67,13 @@ | ||
| 48 | 67 | question TEXT NOT NULL, |
| 49 | 68 | type VARCHAR(32) NOT NULL, |
| 50 | 69 | view_type VARCHAR(64) NOT NULL, |
| 51 | 70 | categories VARCHAR(255) NOT NULL, |
| 52 | - image TEXT DEFAULT '', | |
| 71 | + image TEXT NULL, | |
| 53 | 72 | show_title INT(1) DEFAULT 1, |
| 54 | - styles TEXT DEFAULT '', | |
| 55 | - custom_css TEXT DEFAULT '', | |
| 73 | + styles TEXT NULL, | |
| 74 | + custom_post_id INT(16) UNSIGNED DEFAULT NULL, | |
| 75 | + custom_css TEXT NULL, | |
| 56 | 76 | theme_id INT(5) DEFAULT 1, |
| 57 | 77 | PRIMARY KEY (id) |
| 58 | 78 | )$charset_collate;"; |
| 59 | 79 | dbDelta($sql); |
| @@ -60,9 +80,9 @@ | ||
| 60 | 80 | $sql = "CREATE TABLE $cats_table ( |
| 61 | 81 | id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 62 | 82 | title VARCHAR(255) NOT NULL, |
| 63 | 83 | description TEXT NOT NULL, |
| 64 | - options TEXT DEFAULT '', | |
| 84 | + options TEXT NULL, | |
| 65 | 85 | PRIMARY KEY (`id`) |
| 66 | 86 | )$charset_collate;"; |
| 67 | 87 | dbDelta($sql); |
| 68 | 88 | $sql = "CREATE TABLE $answers_table ( |
| @@ -67,15 +87,15 @@ | ||
| 67 | 87 | dbDelta($sql); |
| 68 | 88 | $sql = "CREATE TABLE $answers_table ( |
| 69 | 89 | id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 70 | 90 | poll_id INT(11) UNSIGNED NOT NULL, |
| 71 | - answer TEXT DEFAULT '', | |
| 91 | + answer TEXT NULL, | |
| 72 | 92 | votes INT(11) NOT NULL, |
| 73 | 93 | ordering INT(11) NOT NULL DEFAULT 1, |
| 74 | - redirect TEXT DEFAULT '', | |
| 94 | + redirect TEXT NULL, | |
| 75 | 95 | user_added INT(1) DEFAULT 0, |
| 76 | 96 | show_user_added INT(1) DEFAULT 1, |
| 77 | - answer_img TEXT DEFAULT '', | |
| 97 | + answer_img TEXT NULL, | |
| 78 | 98 | PRIMARY KEY (`id`) |
| 79 | 99 | )$charset_collate;"; |
| 80 | 100 | dbDelta($sql); |
| 81 | 101 | $sql = "CREATE TABLE $reports_table ( |
| @@ -85,25 +105,24 @@ | ||
| 85 | 105 | user_id INT(11) DEFAULT 0, |
| 86 | 106 | vote_date DATETIME NOT NULL, |
| 87 | 107 | user_email VARCHAR(255) NOT NULL, |
| 88 | 108 | unread INT(1) DEFAULT 1, |
| 89 | - other_info TEXT DEFAULT '', | |
| 109 | + other_info TEXT NULL, | |
| 90 | 110 | poll_id INT(11) UNSIGNED NOT NULL, |
| 91 | - multi_answer_ids TEXT DEFAULT '', | |
| 111 | + multi_answer_ids TEXT NULL, | |
| 92 | 112 | PRIMARY KEY (`id`) |
| 93 | 113 | )$charset_collate;"; |
| 94 | 114 | dbDelta($sql); |
| 95 | 115 | $sql = "CREATE TABLE $settings_table ( |
| 96 | 116 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
| 97 | - `meta_key` TEXT NULL DEFAULT NULL, | |
| 98 | - `meta_value` TEXT NULL DEFAULT NULL, | |
| 99 | - `note` TEXT NULL DEFAULT NULL, | |
| 100 | - `options` TEXT NULL DEFAULT NULL, | |
| 117 | + `meta_key` TEXT NULL, | |
| 118 | + `meta_value` TEXT NULL, | |
| 119 | + `note` TEXT NULL, | |
| 120 | + `options` TEXT NULL, | |
| 101 | 121 | PRIMARY KEY (`id`) |
| 102 | 122 | )$charset_collate;"; |
| 103 | 123 | dbDelta($sql); |
| 104 | 124 | |
| 105 | - // AV added Poll id for report table | |
| 106 | 125 | $answers_table = $wpdb->prefix . 'ayspoll_answers'; |
| 107 | 126 | $report_table = $wpdb->prefix . 'ayspoll_reports'; |
| 108 | 127 | |
| 109 | 128 | $answ_id = $wpdb->get_results("SELECT DISTINCT answer_id FROM $report_table", 'ARRAY_A'); |
| @@ -137,13 +156,13 @@ | ||
| 137 | 156 | } |
| 138 | 157 | |
| 139 | 158 | private static function insert_default_values() { |
| 140 | 159 | global $wpdb; |
| 141 | - $answers_table = $wpdb->prefix . 'ayspoll_answers'; | |
| 142 | - $polls_table = esc_sql($wpdb->prefix . 'ayspoll_polls'); | |
| 143 | - $cats_table = esc_sql($wpdb->prefix . 'ayspoll_categories'); | |
| 144 | - $settings_table = esc_sql($wpdb->prefix . "ayspoll_settings"); | |
| 145 | - $cat_count = $wpdb->get_var("SELECT COUNT(*) FROM ".$cats_table); | |
| 160 | + $answers_table = $wpdb->prefix . 'ayspoll_answers'; | |
| 161 | + $polls_table = $wpdb->prefix . 'ayspoll_polls'; | |
| 162 | + $cats_table = $wpdb->prefix . 'ayspoll_categories'; | |
| 163 | + $settings_table = $wpdb->prefix . "ayspoll_settings"; | |
| 164 | + $cat_count = $wpdb->get_var("SELECT COUNT(*) FROM ".$cats_table); | |
| 146 | 165 | |
| 147 | 166 | if ($cat_count == 0) { |
| 148 | 167 | $wpdb->insert($cats_table, |
| 149 | 168 | array( |
| @@ -158,10 +177,10 @@ | ||
| 158 | 177 | $user = get_userdata($poll_create_author); |
| 159 | 178 | $poll_author = array(); |
| 160 | 179 | if ( ! is_null( $user ) && $user ) { |
| 161 | 180 | $poll_author = array( |
| 162 | - 'id' => $user->ID."", | |
| 163 | - 'name' => $user->data->display_name | |
| 181 | + 'id' => $user->ID."", | |
| 182 | + 'name' => $user->data->display_name | |
| 164 | 183 | ); |
| 165 | 184 | } |
| 166 | 185 | |
| 167 | 186 | $author = json_encode($poll_author, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE | JSON_HEX_QUOT); |
| @@ -176,9 +195,9 @@ | ||
| 176 | 195 | 'description' => 'Default choosing type ', |
| 177 | 196 | 'question' => 'Did you like our plugin?', |
| 178 | 197 | 'type' => 'choosing', |
| 179 | 198 | 'categories' => ',1,', |
| 180 | - 'styles' => '{"randomize_answers":"off","main_color":"#0C6291","text_color":"#0C6291","button_text_color":"#FBFEF9","button_bg_color":"#0C6291","icon_color":"#0C6291","icon_size":24,"width":0,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"2","box_shadow_color":"#000000","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","enable_box_shadow":"off","bg_color":"#FBFEF9","answer_bg_color":"#FBFEF9","answer_hover_color":"#0C6291","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":0,"show_social":0,"load_effect":"load_gif","load_gif":"plg_default","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"none","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":0,"enable_vote_btn":1,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"64","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","poll_create_author":' . $poll_create_author . ',"enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":""},"show_chart_type":"default_bar_chart","show_chart_type_google_height":"400","border_color":"#0C6291"}' | |
| 199 | + 'styles' => '{"randomize_answers":"off","main_color":"#0C6291","text_color":"#0C6291","button_text_color":"#FBFEF9","button_bg_color":"#0C6291","icon_color":"#0C6291","icon_size":24,"width":600,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"2","box_shadow_color":"#000000","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","poll_buttons_mobile_width":"","enable_box_shadow":"off","bg_color":"#FBFEF9","answer_bg_color":"#FBFEF9","answer_hover_color":"#0C6291","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":0,"show_social":0,"load_effect":"load_gif","load_gif":"plg_default","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"none","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":0,"enable_vote_btn":1,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"64","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","poll_create_author":' . $poll_create_author . ',"enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":"","tiktok_link":"","instagram_link":""},"show_chart_type":"default_bar_chart","show_chart_type_google_height":"400","border_color":"#0C6291"}' | |
| 181 | 200 | ), |
| 182 | 201 | array( '%s', '%s', '%s', '%s', '%s', '%s' ) |
| 183 | 202 | ); |
| 184 | 203 | $last_insert = $wpdb->insert_id; |
| @@ -189,15 +208,15 @@ | ||
| 189 | 208 | $wpdb->insert($answers_table, array('poll_id' => $last_insert, 'answer' => 'It\'s amazing'),array( '%d', '%s' )); |
| 190 | 209 | |
| 191 | 210 | // $wpdb->insert($polls_table, |
| 192 | 211 | // array( |
| 193 | - // 'title' => 'Default rating', | |
| 194 | - // 'description' => 'Default rating type ', | |
| 195 | - // 'question' => 'Did you like our plugin?', | |
| 196 | - // 'type' => 'rating', | |
| 197 | - // 'view_type' => 'star', | |
| 198 | - // 'categories' => ',1,', | |
| 199 | - // 'styles' => '{"randomize_answers":"off","main_color":"#0C6291","text_color":"#0C6291","button_text_color":"#FBFEF9","button_bg_color":"#0C6291","icon_color":"#0C6291","icon_size":24,"width":0,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"2","box_shadow_color":"#000000","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","enable_box_shadow":"off","bg_color":"#FBFEF9","answer_bg_color":"#FBFEF9","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":0,"show_social":0,"load_effect":"load_gif","load_gif":"plg_default","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"none","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":0,"enable_vote_btn":1,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":""},"show_chart_type":"default_bar_chart","border_color":"#0C6291"}' | |
| 212 | + // 'title' => 'Default rating', | |
| 213 | + // 'description' => 'Default rating type ', | |
| 214 | + // 'question' => 'Did you like our plugin?', | |
| 215 | + // 'type' => 'rating', | |
| 216 | + // 'view_type' => 'star', | |
| 217 | + // 'categories' => ',1,', | |
| 218 | + // 'styles' => '{"randomize_answers":"off","main_color":"#0C6291","text_color":"#0C6291","button_text_color":"#FBFEF9","button_bg_color":"#0C6291","icon_color":"#0C6291","icon_size":24,"width":0,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"2","box_shadow_color":"#000000","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","enable_box_shadow":"off","bg_color":"#FBFEF9","answer_bg_color":"#FBFEF9","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":0,"show_social":0,"load_effect":"load_gif","load_gif":"plg_default","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"none","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":0,"enable_vote_btn":1,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":""},"show_chart_type":"default_bar_chart","border_color":"#0C6291"}' | |
| 200 | 219 | // ), |
| 201 | 220 | // array( '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) |
| 202 | 221 | // ); |
| 203 | 222 | // $last_insert = $wpdb->insert_id; |
| @@ -208,16 +227,16 @@ | ||
| 208 | 227 | // $wpdb->insert($answers_table, array('poll_id' => $last_insert, 'answer' => '5'),array( '%d', '%s' )); |
| 209 | 228 | |
| 210 | 229 | // $wpdb->insert($polls_table, |
| 211 | 230 | // array( |
| 212 | - // 'title' => 'Demographic poll', | |
| 213 | - // 'description' => 'Demographic poll', | |
| 214 | - // 'question' => 'Where are You from?', | |
| 215 | - // 'type' => 'choosing', | |
| 216 | - // 'categories' => ',1,', | |
| 217 | - // 'show_title' => 1, | |
| 218 | - // 'styles' => '{"randomize_answers":"off","main_color":"#FBFEF9","text_color":"#FBFEF9","button_text_color":"#222222","button_bg_color":"#FBFEF9","icon_color":"#FBFEF9","icon_size":24,"width":0,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"","box_shadow_color":"","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","enable_box_shadow":"","bg_color":"#222222","answer_bg_color":"#222222","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":1,"show_social":1,"active_tab":"General","load_effect":"load_gif","load_gif":"plg_2","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"DESC","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":1,"enable_vote_btn":0,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":""},"show_chart_type":"default_bar_chart","border_color":"#FBFEF9"}', | |
| 219 | - // 'theme_id' => 2 | |
| 231 | + // 'title' => 'Demographic poll', | |
| 232 | + // 'description' => 'Demographic poll', | |
| 233 | + // 'question' => 'Where are You from?', | |
| 234 | + // 'type' => 'choosing', | |
| 235 | + // 'categories' => ',1,', | |
| 236 | + // 'show_title' => 1, | |
| 237 | + // 'styles' => '{"randomize_answers":"off","main_color":"#FBFEF9","text_color":"#FBFEF9","button_text_color":"#222222","button_bg_color":"#FBFEF9","icon_color":"#FBFEF9","icon_size":24,"width":0,"width_for_mobile":0,"poll_min_height":"","btn_text":"Vote","border_style":"ridge","border_radius":"0","border_width":"","box_shadow_color":"","poll_box_shadow_x_offset":0,"poll_box_shadow_y_offset":0,"poll_box_shadow_z_offset":15,"enable_background_gradient":"off","background_gradient_color_1":"#103251","background_gradient_color_2":"#607593","poll_gradient_direction":"vertical","poll_question_size_pc":"16","poll_question_size_mobile":"16","poll_question_image_height":"","poll_question_image_object_fit":"cover","poll_mobile_max_width":"","poll_buttons_size":"medium","poll_buttons_font_size":"17","poll_buttons_mobile_font_size":"17","poll_buttons_left_right_padding":"20","poll_buttons_top_bottom_padding":"10","poll_buttons_border_radius":"3","poll_buttons_width":"","enable_box_shadow":"","bg_color":"#222222","answer_bg_color":"#222222","answer_border_side":"all_sides","answer_font_size":"16","poll_answer_font_size_mobile":"16","poll_answer_object_fit":"cover","poll_answer_padding":"10","poll_answer_margin":"10","poll_answer_border_radius":0,"poll_answer_icon_check":"off","poll_answer_icon":"radio","poll_answer_view_type":"list","poll_answer_enable_box_shadow":"off","poll_answer_box_shadow_color":"#000000","poll_answer_box_shadow_x_offset":0,"poll_answer_box_shadow_y_offset":0,"poll_answer_box_shadow_z_offset":10,"title_bg_color":"rgba(255,255,255,0)","poll_title_font_size":"20","poll_title_font_size_mobile":"20","bg_image":false,"enable_answer_style":"on","hide_results":0,"hide_result_message":0,"hide_results_text":"Thanks for your answer!","allow_not_vote":1,"show_social":1,"active_tab":"General","load_effect":"load_gif","load_gif":"plg_2","limit_users":0,"limitation_message":"","redirect_url":"","redirection_delay":0,"user_role":"","enable_restriction_pass":0,"restriction_pass_message":"","enable_logged_users":0,"enable_logged_users_message":"","notify_email_on":0,"notify_email":"","result_sort_type":"DESC","create_date":"' . current_time('mysql') . '","author":"' . $author . '","redirect_users":0,"redirect_after_vote_url":"","redirect_after_vote_delay":0,"published":1,"enable_pass_count":"on","activeInterval":"2019-05-30","activeIntervalSec":"","deactiveInterval":"2019-05-30","deactiveIntervalSec":"","active_date_message":"","active_date_check":"","enable_restart_button":1,"enable_vote_btn":0,"disable_answer_hover": 0,"logo_image":"","poll_enable_logo_url":"off","poll_logo_title":"","poll_logo_url":"","custom_class":"","enable_poll_title_text_shadow":"off","poll_title_text_shadow":"rgba(255,255,255,0)","poll_title_text_shadow_x_offset":2,"poll_title_text_shadow_y_offset":2,"poll_title_text_shadow_z_offset":0,"poll_allow_multivote":"off","multivote_answer_min_count":"1","poll_allow_multivote_count":"1","poll_direction":"ltr","show_create_date":0,"show_author":0,"ays_poll_show_timer":0,"ays_show_timer_type":"countdown","show_result_btn_see_schedule":"with_see","active_date_message_soon":"","show_result_btn_schedule":0,"dont_show_poll_cont":"off","see_res_btn_text":"See Results","enable_asnwers_sound":"off","poll_vote_reason":"off","enable_view_more_button":"off","poll_view_more_button_count":0,"answer_sort_type":"default","show_answers_numbering":"none","result_message":"","poll_social_buttons_heading":"","poll_show_social_ln":"on","poll_show_social_fb":"on","poll_show_social_tr":"on","poll_show_social_vk":"off","limit_users_method":"ip","show_votes_count":1,"show_res_percent":1,"show_login_form":"off","info_form":0,"fields":"apm_name,apm_email,apm_phone","required_fields":"apm_email","info_form_title":"","enable_mailchimp":"off","redirect_after_submit":0,"mailchimp_list":"","users_role":"[]","poll_bg_image_position":"center center","poll_bg_img_in_finish_page":"off","ays_add_post_for_poll":"off","result_in_rgba":"off","show_passed_users":"off","see_result_button":"on","see_result_radio":"ays_see_result_button","loader_font_size":"","effect_message":"","poll_allow_collecting_users_data":"off","poll_every_answer_redirect_delay":"","poll_enable_answer_image_after_voting":"off","poll_enable_answer_redirect_delay":"off","poll_show_passed_users_count":3,"poll_allow_answer":"off","poll_allow_answer_require":"off","poll_answer_image_height":"150","poll_answer_image_height_for_mobile":"150","poll_answer_image_border_radius":"0","poll_title_alignment":"center","poll_title_alignment_mobile":"center","poll_text_type_length_enable":"off","poll_text_type_limit_type":"characters","poll_text_type_limit_length":"","poll_text_type_limit_message":"off","poll_text_type_placeholder":"Your answer","poll_text_type_width":"","poll_text_type_width_type":"percent","poll_enable_password":"off","poll_password":"","poll_enable_password_visibility":"off","poll_password_message":"","display_fields_labels":"off","autofill_user_data":"off","poll_logo_url_new_tab":"off","enable_social_links":"off","poll_social_links_heading":"","social_links":{"linkedin_link":"","facebook_link":"","twitter_link":"","vkontakte_link":"","youtube_link":""},"show_chart_type":"default_bar_chart","border_color":"#FBFEF9"}', | |
| 238 | + // 'theme_id' => 2 | |
| 220 | 239 | // ), |
| 221 | 240 | // array( '%s', '%s', '%s', '%s', '%s', '%d', '%s', '%d' ) |
| 222 | 241 | // ); |
| 223 | 242 | // $last_insert = $wpdb->insert_id; |
| @@ -255,8 +274,17 @@ | ||
| 255 | 274 | ); |
| 256 | 275 | } |
| 257 | 276 | |
| 258 | 277 | } |
| 278 | + | |
| 279 | + $terms_activation = get_option('ays_poll_show_agree_terms'); | |
| 280 | + $first_activation = get_option('ays_poll_maker_first_time_activation_page', false); | |
| 281 | + | |
| 282 | + if ( !$terms_activation && $first_activation ) { | |
| 283 | + self::ays_poll_activator_request( 'activator' ); | |
| 284 | + update_option('ays_poll_agree_terms', 'true'); | |
| 285 | + update_option('ays_poll_show_agree_terms', 'hide'); | |
| 286 | + } | |
| 259 | 287 | } |
| 260 | 288 | |
| 261 | 289 | public static function ays_poll_update_db_check() { |
| 262 | 290 | global $ays_poll_db_version; |
| @@ -266,11 +294,61 @@ | ||
| 266 | 294 | update_option('ays_poll_maker_first_time_activation_page', true); |
| 267 | 295 | update_option('ays_poll_maker_poll_creation_challange', true); |
| 268 | 296 | } |
| 269 | 297 | |
| 270 | - if (get_site_option('ays_poll_db_version') != $ays_poll_db_version) { | |
| 271 | - self::activate(); | |
| 272 | - update_option('ays_poll_db_version', $ays_poll_db_version); | |
| 273 | - self::insert_default_values(); | |
| 298 | + if(is_multisite()){ | |
| 299 | + global $wpdb; | |
| 300 | + $polls_table = $wpdb->prefix . 'ayspoll_polls'; | |
| 301 | + $cats_table = $wpdb->prefix . 'ayspoll_categories'; | |
| 302 | + $answers_table = $wpdb->prefix . 'ayspoll_answers'; | |
| 303 | + $reports_table = $wpdb->prefix . 'ayspoll_reports'; | |
| 304 | + $settings_table = $wpdb->prefix . 'ayspoll_settings'; | |
| 305 | + $network_id = get_current_network_id(); | |
| 306 | + | |
| 307 | + if($wpdb->get_var("SHOW TABLES LIKE '$polls_table'") != $polls_table) { | |
| 308 | + delete_network_option($network_id, 'ays_poll_db_version'); | |
| 309 | + } | |
| 310 | + | |
| 311 | + if($wpdb->get_var("SHOW TABLES LIKE '$cats_table'") != $cats_table) { | |
| 312 | + delete_network_option($network_id, 'ays_poll_db_version'); | |
| 313 | + } | |
| 314 | + | |
| 315 | + if($wpdb->get_var("SHOW TABLES LIKE '$answers_table'") != $answers_table) { | |
| 316 | + delete_network_option($network_id, 'ays_poll_db_version'); | |
| 317 | + } | |
| 318 | + | |
| 319 | + if($wpdb->get_var("SHOW TABLES LIKE '$reports_table'") != $reports_table) { | |
| 320 | + delete_network_option($network_id, 'ays_poll_db_version'); | |
| 321 | + } | |
| 322 | + | |
| 323 | + if($wpdb->get_var("SHOW TABLES LIKE '$settings_table'") != $settings_table) { | |
| 324 | + delete_network_option($network_id, 'ays_poll_db_version'); | |
| 325 | + } | |
| 326 | + | |
| 327 | + if ( get_network_option( $network_id, 'ays_poll_db_version' ) != $ays_poll_db_version ) { | |
| 328 | + self::activate(); | |
| 329 | + self::insert_default_values(); | |
| 330 | + update_network_option($network_id, 'ays_poll_db_version', $ays_poll_db_version); | |
| 331 | + } | |
| 332 | + } else { | |
| 333 | + if ( get_site_option( 'ays_poll_db_version' ) != $ays_poll_db_version ) { | |
| 334 | + self::activate(); | |
| 335 | + self::insert_default_values(); | |
| 336 | + update_option('ays_poll_db_version', $ays_poll_db_version); | |
| 337 | + } | |
| 274 | 338 | } |
| 275 | 339 | } |
| 340 | + | |
| 341 | + public static function ays_poll_activator_request($cta){ | |
| 342 | + $curl = curl_init(); | |
| 343 | + | |
| 344 | + $api_url = "https://poll-plugin.com/poll-maker/"; | |
| 345 | + | |
| 346 | + wp_remote_post( $api_url, array( | |
| 347 | + 'timeout' => 30, | |
| 348 | + 'body' => wp_json_encode(array( | |
| 349 | + 'type' => 'poll-maker', | |
| 350 | + 'cta' => $cta, | |
| 351 | + )), | |
| 352 | + ) ); | |
| 353 | + } | |
| 276 | 354 | } |
