Changeset 294 for trunk/wp-admin/b2edit.php

Timestamp:

08/05/2003 10:44:38 PM (23 years ago)

Author:

mikelittle

Message:

Changes for new geourl functionality.
Example added to index.php.
Install and update done.

File:

• trunk/wp-admin/b2edit.php (modified) (12 diffs)

trunk/wp-admin/b2edit.php

@@ -12 +12 @@
     }
     return $array;
-} 
+}
 
 if (!get_magic_quotes_gpc()) {
@@ -41 +41 @@
 
             $standalone = 1;
-            require_once('b2header.php');   
+            require_once('b2header.php');
 
             $post_pingback = intval($HTTP_POST_VARS['post_pingback']);
@@ -50 +50 @@
             $post_title = addslashes($HTTP_POST_VARS['post_title']);
             $post_category = intval($HTTP_POST_VARS['post_category']);
+            if(get_settings('use_geo_positions')) {
+                $latstr = $HTTP_POST_VARS['post_latf'];
+                $lonstr = $HTTP_POST_VARS['post_lonf'];
+                if((strlen($latstr) > 2) && (strlen($lonstr) > 2 ) ) {
+                    $post_latf = floatval($HTTP_POST_VARS['post_latf']);
+                    $post_lonf = floatval($HTTP_POST_VARS['post_lonf']);
+                }
+            }
             $post_status = $HTTP_POST_VARS['post_status'];
             $comment_status = $HTTP_POST_VARS['comment_status'];
@@ -74 +82 @@
         }
 
-        $result = $wpdb->query("
-          INSERT INTO $tableposts 
-            (ID, post_author, post_date, post_content, post_title, post_category, post_excerpt,  post_status, comment_status, ping_status, post_password)
-          VALUES
-            ('0','$user_ID','$now','$content','$post_title','$post_category','$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password')
-          ");
+        if((get_settings('use_geo_positions')) && (strlen($latstr) > 2) && (strlen($lonstr) > 2) ) {
+        $postquery ="INSERT INTO $tableposts
+                (ID, post_author, post_date, post_content, post_title, post_category, post_lat, post_lon, post_excerpt,  post_status, comment_status, ping_status, post_password)
+                VALUES
+                ('0','$user_ID','$now','$content','$post_title','$post_category',$post_latf,$post_lonf,'$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password')
+                ";
+        } else {
+        $postquery ="INSERT INTO $tableposts
+                (ID, post_author, post_date, post_content, post_title, post_category,  post_excerpt,  post_status, comment_status, ping_status, post_password)
+                VALUES
+                ('0','$user_ID','$now','$content','$post_title','$post_category','$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password')
+                ";
+        }
+        $postquery =
+        $result = $wpdb->query($postquery);
 
         $post_ID = $wpdb->get_var("SELECT ID FROM $tableposts ORDER BY ID DESC LIMIT 1");
@@ -86 +103 @@
                 sleep($sleep_after_edit);
         }
-        
+
         if ($post_status == 'publish') {
+            if((get_settings('use_geo_positions')) && ($post_latf != null) && ($post_lonf != null)) {
+                pingGeoUrl($post_ID);
+            }
             pingWeblogs($blog_ID);
             pingCafelog($cafelogID, $post_title, $post_ID);
             pingBlogs($blog_ID);
-        
+
             if ($post_pingback) {
                 pingback($content, $post_ID);
@@ -137 +157 @@
             if ($user_level < $authordata->user_level)
                 die ('You don&#8217;t have the right to edit <strong>'.$authordata[1].'</strong>&#8217;s posts.');
-            
+
             $content = $postdata['Content'];
             $content = format_to_edit($content);
+            $edited_lat = $postdata["Lat"];
+            $edited_lon = $postdata["Lon"];
             $excerpt = $postdata['Excerpt'];
             $excerpt = format_to_edit($excerpt);
@@ -165 +187 @@
         $standalone = 1;
         require_once('./b2header.php');
-        
+
         if ($user_level == 0)
             die ('Cheatin&#8217; uh?');
@@ -180 +202 @@
             $excerpt = format_to_post($excerpt);
             $post_title = addslashes($HTTP_POST_VARS['post_title']);
+            if(get_settings('use_geo_positions')) {
+                $latf = floatval($HTTP_POST_VARS["post_latf"]);
+                    $lonf = floatval($HTTP_POST_VARS["post_lonf"]);
+                    $latlonaddition = "";
+                    if( ($latf != null) && ($latf <= 90 ) && ($latf >= -90) && ($lonf != null) && ($lonf <= 360) && ($lonf >= -360) ) {
+                            pingGeoUrl($post_ID);
+                    $latlonaddition = " post_lat=".$latf.", post_lon =".$lonf.", ";
+                    } else {
+                    $latlonaddition = " post_lat=null, post_lon=null, ";
+                }
+            }
             $post_status = $HTTP_POST_VARS['post_status'];
             $prev_status = $HTTP_POST_VARS['prev_status'];
@@ -203 +236 @@
 
         $result = $wpdb->query("
-            UPDATE $tableposts SET 
-                post_content = '$content', 
-                post_excerpt = '$excerpt', 
-                post_title = '$post_title', 
-                post_category = '$post_category'".$datemodif.", 
-                post_status = '$post_status', 
-                comment_status = '$comment_status', 
-                ping_status = '$ping_status', 
-                post_password = '$post_password' 
-            WHERE ID = $post_ID
-");
+            UPDATE $tableposts SET
+                post_content = '$content',
+                post_excerpt = '$excerpt',
+                post_title = '$post_title',
+                post_category = '$post_category'".$datemodif.",
+                ".$latlonaddition."
+                post_status = '$post_status',
+                comment_status = '$comment_status',
+                ping_status = '$ping_status',
+                post_password = '$post_password'
+            WHERE ID = $post_ID ");
 
         if (isset($sleep_after_edit) && $sleep_after_edit > 0) {
@@ -224 +257 @@
             pingCafelog($cafelogID, $post_title, $post_ID);
             pingBlogs($blog_ID);
-        
+
             if ($post_pingback) {
                 pingback($content, $post_ID);
@@ -258 +291 @@
         if ($user_level < $authordata->user_level)
             die ('You don&#8217;t have the right to delete <strong>'.$authordata[1].'</strong>&#8217;s posts.');
+
+        // send geoURL ping to "erase" from their DB
+        $query = "SELECT post_lat from $tableposts WHERE ID=$post";
+        $rows = $wpdb->query($query); 
+        $myrow = $rows[0];
+        $latf = $myrow->post_lat;
+        if($latf != null ) {
+            pingGeoUrl($post);
+        }
 
         $result = $wpdb->query("DELETE FROM $tableposts WHERE ID=$post");
@@ -349 +391 @@
 
         $result = $wpdb->query("
-            UPDATE $tablecomments SET 
-                comment_content = '$content', 
-                comment_author = '$newcomment_author', 
-                comment_author_email = '$newcomment_author_email', 
-                comment_author_url = '$newcomment_author_url'".$datemodif." 
+            UPDATE $tablecomments SET
+                comment_content = '$content',
+                comment_author = '$newcomment_author',
+                comment_author_email = '$newcomment_author_email',
+                comment_author_url = '$newcomment_author_url'".$datemodif."
             WHERE comment_ID = $comment_ID"
             );