Changeset 860 for trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/d3forum_comment_synchro.php

Timestamp:

Jun 15, 2016, 9:52:13 AM (8 years ago)

Author:

toemon

Message:

PHP7 対応　Fix #431
thx nao-pon

File:

• trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/d3forum_comment_synchro.php (modified) (4 diffs)

trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/d3forum_comment_synchro.php

@@ -486 +486 @@
                                 $wp_res =       $xoops_db->query($wp_sql);
                                 if ($wp_res === false) die( '...Err. INSERT' . $wp_comments . '(' . $wp_sql . ')');
-                                $comment_ID = mysql_insert_id();
+                                $comment_ID = $xoops_db->insert_id;
                                 $wp_sql  = "UPDATE $wp_posts SET  comment_count = comment_count +1 WHERE ID = $comment_post_ID";
                                 $xoops_db->query($wp_sql);
@@ -696 +696 @@
                         $sql = "INSERT INTO ".$d3f_posts." SET $set4sql,pid=$reply_pid,topic_id=$topic_id,post_time=$post_time,poster_ip=$poster_ip";
                         $xoops_db->query($sql) ;
-                        $post_id = mysql_insert_id();
+                        $post_id = $xoops_db->insert_id;
                         wp_d3forum_sync_topic( $d3forum_dirname , $topic_id ) ;
                         
@@ -729 +729 @@
                         $sql = "INSERT INTO ".$d3f_topic." SET forum_id=$forum_id,topic_invisible=$topic_invisible,topic_external_link_id='".addslashes($topic_external_link_id)."'";
                         $xoops_db->query($sql) ;
-                        $topic_id = mysql_insert_id();
+                        $topic_id = $xoops_db->insert_id;
                         // create post in the topic
                         $sql = "INSERT INTO ".$d3f_posts." SET $set4sql,topic_id=$topic_id,post_time=$post_time,poster_ip=$poster_ip";
                         $xoops_db->query($sql) ;
-                        $post_id = mysql_insert_id();
+                        $post_id = $xoops_db->insert_id;
                         wp_d3forum_sync_topic( $d3forum_dirname , $topic_id , true , true ) ;
                         
@@ -1054 +1054 @@
         }
 
-        $xoops_db->query( "INSERT INTO ".$d3forum_prefix."post_histories SET post_id=$post_id, history_time=UNIX_TIMESTAMP(), data='".mysql_real_escape_string( serialize( $data ) )."'" ) ;
+        $xoops_db->query( $xoops_db->prepare( "INSERT INTO ".$d3forum_prefix."post_histories SET post_id=$post_id, history_time=UNIX_TIMESTAMP(), data=%s", serialize( $data ) ) ) ;
 }