Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

namespace NetworkPosts\Components\db;

[3] Fix | Delete

[4] Fix | Delete

[5] Fix | Delete

class NetsPostsReviewQuery {

[6] Fix | Delete

[7] Fix | Delete

static $blogs_installed = array();

[8] Fix | Delete

/**

[9] Fix | Delete

* @var \wpdb

[10] Fix | Delete

[11] Fix | Delete

private $db;

[12] Fix | Delete

[13] Fix | Delete

public function __construct( \wpdb $db ) {

[14] Fix | Delete

$this->db = $db;

[15] Fix | Delete

}

[16] Fix | Delete

[17] Fix | Delete

public function get_post_avg_rating( $blog_id, $id ) {

[18] Fix | Delete

$table_name = self::get_table_name( $blog_id, $this->db->base_prefix );

[19] Fix | Delete

$query = 'SELECT ROUND(AVG(rating),1) AS rating FROM ' . $table_name . ' WHERE post_id=' . intval( $id );

[20] Fix | Delete

$record = $this->db->get_results( $query, ARRAY_A );

[21] Fix | Delete

return intval( $record[0]['rating'] );

[22] Fix | Delete

}

[23] Fix | Delete

[24] Fix | Delete

private static function get_table_name( $blog_id, $base_prefix ) {

[25] Fix | Delete

$table_prefix = $base_prefix;

[26] Fix | Delete

if( $blog_id > 1 ){

[27] Fix | Delete

$table_prefix .= $blog_id . '_';

[28] Fix | Delete

}

[29] Fix | Delete

return $table_prefix . 'reviews';

[30] Fix | Delete

}

[31] Fix | Delete

[32] Fix | Delete

public function is_installed( $blog_id ) {

[33] Fix | Delete

if( isset( self::$blogs_installed[ $blog_id ] ) ) {

[34] Fix | Delete

return self::$blogs_installed[ $blog_id ];

[35] Fix | Delete

}

[36] Fix | Delete

[37] Fix | Delete

$table = self::get_table_name( $blog_id, $this->db->base_prefix );

[38] Fix | Delete

$rows = $this->db->get_results( 'SHOW TABLES LIKE "' . $table . '";' );

[39] Fix | Delete

self::$blogs_installed[ $blog_id ] = ! empty( $rows );

[40] Fix | Delete

[41] Fix | Delete

return self::$blogs_installed[ $blog_id ];

[42] Fix | Delete

}

[43] Fix | Delete

}

[44] Fix | Delete