Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

class WPML_Comment_Duplication{

[2] Fix | Delete

[3] Fix | Delete

public function move_to_original($duplicate_of, $post_duplicates, $comment){

[4] Fix | Delete

global $wpml_post_translations, $wpdb;

[5] Fix | Delete

[6] Fix | Delete

$_orig_lang = $wpml_post_translations->get_element_lang_code ( $duplicate_of );

[7] Fix | Delete

$post_duplicates[ $_orig_lang ] = $duplicate_of;

[8] Fix | Delete

$original_parent = get_comment_meta ( $comment[ 'comment_parent' ], '_icl_duplicate_of', true );

[9] Fix | Delete

$wpdb->update (

[10] Fix | Delete

$wpdb->comments,

[11] Fix | Delete

array(

[12] Fix | Delete

'comment_post_ID' => $duplicate_of,

[13] Fix | Delete

'comment_parent' => $original_parent

[14] Fix | Delete

), array( 'comment_ID' => $comment['comment_ID'] ), array( '%d', '%d' ), array( '%d' )

[15] Fix | Delete

);

[16] Fix | Delete

wp_update_comment_count_now($duplicate_of);

[17] Fix | Delete

}

[18] Fix | Delete

[19] Fix | Delete

public function get_correct_parent($comment, $dup_id){

[20] Fix | Delete

global $wpdb;

[21] Fix | Delete

[22] Fix | Delete

$translated_parent = $wpdb->get_var (

[23] Fix | Delete

$wpdb->prepare (

[24] Fix | Delete

" SELECT cmb.comment_id

[25] Fix | Delete

FROM {$wpdb->commentmeta} cm

[26] Fix | Delete

JOIN {$wpdb->commentmeta} cmb

[27] Fix | Delete

ON ( cmb.meta_value = cm.meta_value

[28] Fix | Delete

AND cmb.meta_key = cm.meta_key)

[29] Fix | Delete

OR cm.comment_id = cmb.meta_value

[30] Fix | Delete

JOIN {$wpdb->comments} c

[31] Fix | Delete

ON c.comment_ID = cmb.comment_id

[32] Fix | Delete

WHERE cm.meta_key = '_icl_duplicate_of'

[33] Fix | Delete

AND ( cm.comment_id = %d OR cm.meta_value = %d )

[34] Fix | Delete

AND c.comment_post_ID = %d",

[35] Fix | Delete

$comment[ 'comment_parent' ],

[36] Fix | Delete

$comment[ 'comment_parent' ],

[37] Fix | Delete

$dup_id

[38] Fix | Delete

)

[39] Fix | Delete

);

[40] Fix | Delete

[41] Fix | Delete

return $translated_parent;

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete

public function insert_duplicated_comment( $comment, $dup_id, $original_cid ) {

[45] Fix | Delete

global $wpdb, $iclTranslationManagement;

[46] Fix | Delete

$dup_comment_id = $this->duplicate_exists ( $dup_id, $original_cid );

[47] Fix | Delete

remove_action ( 'wp_insert_comment', array( $iclTranslationManagement, 'duplication_insert_comment' ), 100 );

[48] Fix | Delete

[49] Fix | Delete

if ( $dup_comment_id ) {

[50] Fix | Delete

$comment[ 'comment_ID' ] = $dup_comment_id;

[51] Fix | Delete

wp_update_comment ( $comment );

[52] Fix | Delete

} else {

[53] Fix | Delete

$wpdb->insert ( $wpdb->comments, $comment );

[54] Fix | Delete

$dup_comment_id = $wpdb->insert_id;

[55] Fix | Delete

[56] Fix | Delete

add_action ( 'wp_insert_comment', array( $iclTranslationManagement, 'duplication_insert_comment' ), 100 );

[57] Fix | Delete

update_comment_meta ( $dup_comment_id, '_icl_duplicate_of', $original_cid );

[58] Fix | Delete

// comment meta

[59] Fix | Delete

$meta = $wpdb->get_results (

[60] Fix | Delete

$wpdb->prepare (

[61] Fix | Delete

"SELECT meta_key, meta_value FROM {$wpdb->commentmeta} WHERE comment_id=%d",

[62] Fix | Delete

$original_cid

[63] Fix | Delete

)

[64] Fix | Delete

);

[65] Fix | Delete

foreach ( $meta as $meta_row ) {

[66] Fix | Delete

$wpdb->insert (

[67] Fix | Delete

$wpdb->commentmeta,

[68] Fix | Delete

array(

[69] Fix | Delete

'comment_id' => $dup_comment_id,

[70] Fix | Delete

'meta_key' => $meta_row->meta_key,

[71] Fix | Delete

'meta_value' => $meta_row->meta_value

[72] Fix | Delete

), array( '%d', '%s', '%s' )

[73] Fix | Delete

);

[74] Fix | Delete

}

[75] Fix | Delete

}

[76] Fix | Delete

[77] Fix | Delete

wp_update_comment_count_now ( $dup_id );

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

private function duplicate_exists( $dup_id, $original_cid ) {

[81] Fix | Delete

global $wpdb;

[82] Fix | Delete

[83] Fix | Delete

$duplicate = $wpdb->get_var (

[84] Fix | Delete

$wpdb->prepare (

[85] Fix | Delete

" SELECT comm.comment_ID

[86] Fix | Delete

FROM {$wpdb->comments} comm

[87] Fix | Delete

JOIN {$wpdb->commentmeta} cm

[88] Fix | Delete

ON comm.comment_ID = cm.comment_id

[89] Fix | Delete

WHERE comm.comment_post_ID = %d

[90] Fix | Delete

AND cm.meta_key = '_icl_duplicate_of'

[91] Fix | Delete

AND cm.meta_value = %d

[92] Fix | Delete

LIMIT 1",

[93] Fix | Delete

$dup_id,

[94] Fix | Delete

$original_cid

[95] Fix | Delete

)

[96] Fix | Delete

);

[97] Fix | Delete

[98] Fix | Delete

return $duplicate;

[99] Fix | Delete

}

[100] Fix | Delete

[101] Fix | Delete

}

[102] Fix | Delete