Changeset 2585949

Timestamp:

08/20/2021 10:52:44 AM (4 years ago)

Author:

platformlycom

Message:

fixed notice: update field ply_page_html, fixed status for platform page.

Location:

platformly/trunk

Files:

• css/ply_styles.css (modified) (1 diff)
• inc/pages/ply.pages.php (modified) (2 diffs)
• inc/ply.functions.php (modified) (7 diffs)
• js/pages.js (modified) (3 diffs)
• platformly.php (modified) (6 diffs)
• readme.txt (modified) (2 diffs)

platformly/trunk/css/ply_styles.css

@@ -182 +182 @@
     margin-bottom: 0px;
 }
+#plyCheckboxPingUpdateServices{
+    width: 16px;
+    height: 16px;
+    margin-left: 0 !important;
+}
+#plyCheckboxPingUpdateServices::before{
+    width: 21px;
+    height: 21px;
+    margin-top: -3px;
+    margin-left: -4px;
+}
+#plyLabelPingUpdateServices{
+    font-size: 14px;
+    font-weight: normal;
+    margin-bottom: 0;
+}

platformly/trunk/inc/pages/ply.pages.php

@@ -147 +147 @@
                     <input type="hidden" id="edit_ply_page_id" value="<?= $editPage->ply_page_id ?>" />
                     <input type="hidden" id="edit_ply_page_pid" value="<?= $editPage->ply_page_pid ?>" />
+                    <input type="hidden" id="edit_ply_ping_update_services" value="<?= !empty($options['ping_update_services']) ? 1 : 0 ?>" />
                     <button onclick="updatePage(true)" class="btn btn-primary">Update</button>
                     <button onclick="location.reload();" class="button button-secondary">Cancel</button>
@@ -240 +241 @@
     <input type="text" name="formPageType" id="formPageType" value=""/>
     <input type="text" name="formPageSlug" id="formPageSlug" value=""/>
+    <input type="text" name="formPagePingUpdateServices" id="formPagePingUpdateServices" value=""/>
     <input type="hidden" name="savePage" value="1" />
 </form>

platformly/trunk/inc/ply.functions.php

@@ -211 +211 @@
             "pageSlug" => $pageSlug
         );
+        $pingUpdateServices = 0;
+        if($pageType === 'normal'){
+            $plyPageInfo['ping_update_services'] = !empty($_POST['formPagePingUpdateServices']) ? 1 : 0;
+            $pingUpdateServices = $plyPageInfo['ping_update_services'];
+        }
         $plyPageInfo = json_encode($plyPageInfo);
 
@@ -224 +229 @@
                 if($resultUnsub){
                     $wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->prefix . "ply_pages WHERE id=%d LIMIT 1", array($result->id)));
+                    platformly_delete_wp_page($result->ply_page_slug);
                 }
             }
@@ -235 +241 @@
             //if it's an update don't register the page for updates, it's already been done
             $wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}ply_pages SET `ply_page_options` = %s, `ply_page_type` = %s, `ply_page_slug` = %s WHERE ply_page_id = %d AND ply_cid = %d", array($plyPageInfo, $pageType, $pageSlug, $pageId, $ply_plugin_cid)));
+            // update page in wp_post table
+            if($results[0]->ply_page_type == $pageType){
+                $wpdb->query($wpdb->prepare("UPDATE {$wpdb->posts} SET `post_name` = %s, `guid` = %s WHERE post_type = %d AND post_name = %s", array($pageSlug, get_site_url().'/'.$pageSlug, 'ply_page', $results[0]->ply_page_slug)));
+            }elseif($results[0]->ply_page_type === 'normal'){
+                platformly_delete_wp_page($results[0]->ply_page_slug);
+            }elseif($pageType === 'normal'){
+                platformly_create_wp_page($pageSlug, $results[0]->ply_page_name);
+            }
+            if($pingUpdateServices){
+                generic_ping();
+            }
             return 1;
         } else{
@@ -244 +261 @@
                 $pageHTML = $get_pages->html;
                 if($wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->prefix . "ply_pages(`ply_page_name`, `ply_page_pid`, `ply_page_id`, `ply_page_options`, `ply_page_html`, `ply_cid`, ply_page_type, ply_page_slug, ply_page_status) VALUES (%s, %d, %d, %s, %s, %d, %s, %s, %s)", array($pageName, $projectId, $pageId, $plyPageInfo, $pageHTML, $ply_plugin_cid, $pageType, $pageSlug, 'active')))){
+                    if($pingUpdateServices){
+                        generic_ping();
+                    }
+                    if($pageType === 'normal'){
+                        platformly_create_wp_page($pageSlug, $pageName);
+                    }
                     return 1;
                 } else{
@@ -263 +286 @@
     if(isset($_POST['removePage']) && !empty($_POST['removePage'])){
         $sql = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "ply_pages WHERE ply_page_id=%d AND ply_cid=%d LIMIT 1", array((int)$_POST['removePage'], $ply_plugin_cid));
-        $results = $wpdb->get_results($sql);
-
-        if(count($results)){
-            $result = $results[0];
-            $pageId = $result->ply_page_id;
+        $ply_pages = $wpdb->get_results($sql);
+
+        if(count($ply_pages)){
+            $ply_page = $ply_pages[0];
+            $pageId = $ply_page->ply_page_id;
 
             $result = ply_unsubscribe_page_html($pageId);
@@ -273 +296 @@
             if($result){
                 if($wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->prefix . "ply_pages WHERE ply_page_id=%d AND ply_cid=%d LIMIT 1", array((int)$_POST['removePage'], $ply_plugin_cid)))){
+                    platformly_delete_wp_page($ply_page->ply_page_slug);
                     return 1;
                 } else{
@@ -481 +505 @@
     return true;
 }
+
+function platformly_create_wp_page($pageSlug, $pageName){
+    wp_insert_post(array(
+        'post_status'    => 'publish',
+        'post_type'      => 'ply_page',
+        'post_author'    => 1,
+        'post_name'      => $pageSlug,
+        'post_title'     => $pageName,
+        'post_content'   => '',
+        'comment_status' => 'closed',
+        'guid' => get_site_url().'/'.$pageSlug
+    ));
+}
+
+function platformly_delete_wp_page($pageSlug){
+    global $wpdb;
+    $plyPage = $wpdb->get_row($wpdb->prepare("SELECT id FROM {$wpdb->posts} WHERE post_type = %s AND post_name = %s", array('ply_page', $pageSlug)));
+    wp_delete_post($plyPage->id, true);
+}

platformly/trunk/js/pages.js

@@ -74 +74 @@
         $("#formPageType").val(pageType);
         $("#formPageSlug").val(pageSlug);
+        $("#formPagePingUpdateServices").val($('#plyCheckboxPingUpdateServices').prop('checked') ? '1' : '0');
 
         $("#pageSaveForm").submit();
@@ -94 +95 @@
             $(elem).addClass('selected');
         }
-
+        var PingUpdateServices = '';
+        if(typeof $('#edit_ply_ping_update_services') !== 'undefined'){
+            PingUpdateServices = $('#edit_ply_ping_update_services').val() == 1 ? 'checked' : '';
+        }
+        
         if ($(elem).attr('id') == 'normal' || $(elem).attr('id') == 'welcome' || text != false) {
             $("#pageSlugContainer").html("<h4>Choose a slug name: <input type='text' name='pageSlug' id='pageSlug' value='" + plyPageSlug + "' /><br><small>* Only allowed: A-Z, a-z, 0-9, - and _</small> <br> <small>** Blank spaces will be automatically converted to hyphens (-)</small> </h4> ");
@@ -101 +106 @@
             } else {
                 $("#pageSlugContainer").append("* If you already have a page of this slug name it will be overwritten as only one at a time can exist.");
+                $("#pageSlugContainer").append('<div style="margin-top: 8px;font-size: 13px;">\n' +
+                        '                <input id="plyCheckboxPingUpdateServices" value="1" type="checkbox" ' + PingUpdateServices + ' />\n' +
+                        '                <label id="plyLabelPingUpdateServices" for="plyCheckboxPingUpdateServices">Submit page to Update Services</label>\n' +
+                        '            </div>');
             }
         } else {

platformly/trunk/platformly.php

@@ -4 +4 @@
 Plugin Name: Platform.ly Official
 Description: Platform.ly plugin is the easiest way to setup your optins and pages that your created with Platform.ly. After building your optin or page with our interactive WYSIWYG builders, you can set them up to show on your site with just a couple of clicks.
-Version: 1.9
+Version: 1.10
 Author: Platform.ly
 Author URI: https://www.platform.ly/
@@ -16 +16 @@
 define("PLATFORMLY_URL", "https://pageserver.platform.ly");
 
-define('PLATFORMLY_PLUGIN_VERSION', '1.9');
-
-//update
-$plyVersion = get_option('ply_plugin_version');
-
-updatePlugin($plyVersion);
+define('PLATFORMLY_PLUGIN_VERSION', '1.10');
 
 include plugin_dir_path(__FILE__) . '/inc/ply.functions.php';
+
+add_action('init', 'ply_update_plugin', 5);
+add_action('init', 'ply_register_post_types', 10);
+
+function ply_register_post_types(){
+//global $wp_taxonomies;
+
+    register_post_type('ply_page', array(
+        'labels' => array(
+            'name' => 'PLY pages'
+        ),
+        'public'             => true,
+        'publicly_queryable' => true,
+        'show_ui'            => false,
+        'show_in_menu'       => false,
+        'query_var'          => false,
+        'rewrite'            => array('slug'=>'/', 'with_front' => false),
+        'capability_type'    => 'page',
+        'has_archive'        => false,
+        'hierarchical'       => false,
+        'menu_position'      => null,
+        'supports'           => false,
+        'taxonomies'         => array('category')
+    ));
+}
 
 function ply_create_menus(){
@@ -100 +120 @@
     $sql = "DROP TABLE ".$table_name;
     $wpdb->query($sql);
+    //remove ply page from wp_posts table
+    $plyPages = $wpdb->get_results($wpdb->prepare("SELECT id FROM {$wpdb->posts} WHERE post_type = %s", array('ply_page')));
+    foreach($plyPages as $plyPage){
+        wp_delete_post($plyPage->id, true);
+    }
 }
 
@@ -327 +352 @@
 
 function ply_manage_pages(){
+    $path = \sanitize_text_field( \wp_unslash( $_SERVER['REQUEST_URI'] ) );
+    // If it's not a wp-sitemap request, nothing to do.
+    if ( \substr( $path, 0, 11 ) === '/wp-sitemap' ) {
+        return;
+    }
+
     $welcomePage = ply_get_page_by_options('welcome');
     if(!empty($welcomePage) && !isset($_COOKIE[$welcomePage['ply_page_slug']])){
@@ -480 +511 @@
 }
 
-function updatePlugin($version){
+function ply_update_plugin(){
     global $wpdb;
+    $version = get_option('ply_plugin_version');
     if(empty($version)){
         $sql = 'ALTER TABLE `wp_ply_pages` CHANGE `ply_page_html` `ply_page_html` LONGTEXT';
@@ -487 +519 @@
         update_option('ply_plugin_version', PLATFORMLY_PLUGIN_VERSION);
     }
-}
+    $versionData = explode('.',$version);
+    $major = empty($versionData[0]) ? 0 : $versionData[0];
+    $minor = empty($versionData[1]) ? 0 : $versionData[1];
+    // update for 1.10 version
+    if($major < 1 || ($major == 1 && $minor < 10)){
+        $pages = $wpdb->get_results($wpdb->prepare('SELECT ply_page_slug, ply_page_name FROM '.$wpdb->prefix.'ply_pages WHERE ply_page_type = %s', array('normal')));
+        foreach($pages as $page){
+            $plyPage = $wpdb->get_row($wpdb->prepare("SELECT id FROM {$wpdb->posts} WHERE post_type = %s AND post_name = %s", array('ply_page', $page->ply_page_slug)));
+            if(!$plyPage){
+                platformly_create_wp_page($page->ply_page_slug, $page->ply_page_name);
+            }
+        }
+        update_option('ply_plugin_version', PLATFORMLY_PLUGIN_VERSION);
+    }
+}

platformly/trunk/readme.txt

@@ -3 +3 @@
 Tags: CRM, ecommerce, custom pages, landing pages, optin forms, events, tracking links, platform.ly, platform, platformly
 Requires at least: 4.6
-Tested up to: 5.7
+Tested up to: 5.8
 Requires PHP: 5.5.9
 Stable tag: trunk
@@ -78 +78 @@
 == Upgrade Notice ==
 
+= 1.10 =
+- Pages are displayed in the sitemap
+- Added possibility to Submit page to Update Services
+
 = 1.9 =
 - Minor fixes