Changeset 481 for trunk/xpressme_integration_kit/include/onupdate.php

Timestamp:

Dec 7, 2009, 9:35:09 AM (14 years ago)

Author:

toemon

Message:

閲覧数表示がリセットされるバグ修正 Fixes #265

File:

• trunk/xpressme_integration_kit/include/onupdate.php (modified) (1 diff)

trunk/xpressme_integration_kit/include/onupdate.php

@@ -221 +221 @@
                         $db->queryF( $queries ) ;
                         $msgs[] = "$views_table  ADD blog_id .";
+                }
+                
+                // The table is repaired.
+                $non_blogid_sql ="SELECT * FROM $views_table WHERE blog_id IS NULL OR blog_id < 1";
+                $non_blogid_res = $db->query($non_blogid_sql, 0, 0);
+                while($row = $db->fetchArray($non_blogid_res)){
+                        $total_view = $row['post_views'];
+                        $post_id = $row['post_id'];
+                        $new_blogid_sql ="SELECT SUM(post_views) as post_views_sum FROM $views_table WHERE post_id = $post_id AND blog_id = 1 GROUP BY post_id";
+                        $new_blogid_res = $db->query($new_blogid_sql, 0, 0);
+                        if ($db->getRowsNum($new_blogid_res)  > 0){
+                                $new_row = $db->fetchArray($new_blogid_res);
+                                $total_view = $total_view + $new_row['post_views_sum'];
+                                $del_sql = "DELETE FROM $views_table WHERE post_id = $post_id AND blog_id = 1";
+                                $db->queryF( $del_sql ) ;
+                        }
+                        $update_sql = "UPDATE $views_table SET post_views = $total_view , blog_id = 1 WHERE post_id = $post_id AND (blog_id IS NULL OR blog_id < 1)";
+                        $db->queryF( $update_sql ) ;
                 }
         }