@@ 1368-1388 (lines=21) @@ | ||
1365 | // Check it doesn't already exist |
|
1366 | $sql = $wpdb->prepare( $check_existing_sql, $lesson_id, $user_id ); |
|
1367 | $comment_ID = $wpdb->get_var( $sql ); |
|
1368 | if ( !$comment_ID ) { |
|
1369 | // Bypassing WP wp_insert_comment( $data ), so no actions/filters are run |
|
1370 | $wpdb->insert($wpdb->comments, $data); |
|
1371 | $comment_ID = (int) $wpdb->insert_id; |
|
1372 | ||
1373 | if ( $comment_ID && !empty($meta_data) ) { |
|
1374 | foreach ( $meta_data as $key => $value ) { |
|
1375 | // Bypassing WP add_comment_meta(() so no actions/filters are run |
|
1376 | if ( $wpdb->get_var( $wpdb->prepare( |
|
1377 | "SELECT COUNT(*) FROM $wpdb->commentmeta WHERE comment_id = %d AND meta_key = %s ", |
|
1378 | $comment_ID, $key ) ) ) { |
|
1379 | continue; // Found the meta data already |
|
1380 | } |
|
1381 | $result = $wpdb->insert( $wpdb->commentmeta, array( |
|
1382 | 'comment_id' => $comment_ID, |
|
1383 | 'meta_key' => $key, |
|
1384 | 'meta_value' => $value |
|
1385 | ) ); |
|
1386 | } |
|
1387 | } |
|
1388 | } |
|
1389 | } |
|
1390 | } |
|
1391 | $wpdb->flush(); |
|
@@ 1507-1527 (lines=21) @@ | ||
1504 | // Check it doesn't already exist |
|
1505 | $sql = $wpdb->prepare( $check_existing_sql, $course_id, $user_id ); |
|
1506 | $comment_ID = $wpdb->get_var( $sql ); |
|
1507 | if ( !$comment_ID ) { |
|
1508 | // Bypassing WP wp_insert_comment( $data ), so no actions/filters are run |
|
1509 | $wpdb->insert($wpdb->comments, $data); |
|
1510 | $comment_ID = (int) $wpdb->insert_id; |
|
1511 | ||
1512 | if ( $comment_ID && !empty($meta_data) ) { |
|
1513 | foreach ( $meta_data as $key => $value ) { |
|
1514 | // Bypassing WP wp_insert_comment( $data ), so no actions/filters are run |
|
1515 | if ( $wpdb->get_var( $wpdb->prepare( |
|
1516 | "SELECT COUNT(*) FROM $wpdb->commentmeta WHERE comment_id = %d AND meta_key = %s ", |
|
1517 | $comment_ID, $key ) ) ) { |
|
1518 | continue; // Found the meta data already |
|
1519 | } |
|
1520 | $result = $wpdb->insert( $wpdb->commentmeta, array( |
|
1521 | 'comment_id' => $comment_ID, |
|
1522 | 'meta_key' => $key, |
|
1523 | 'meta_value' => $value |
|
1524 | ) ); |
|
1525 | } |
|
1526 | } |
|
1527 | } |
|
1528 | } |
|
1529 | } |
|
1530 | $wpdb->flush(); |