Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

namespace NetworkPosts\db;

[3] Fix | Delete

[4] Fix | Delete

[5] Fix | Delete

class NetsPostsDbHelper {

[6] Fix | Delete

public static function make_table_name( string $prefix, string $table, int $blog_id ): string {

[7] Fix | Delete

if( $blog_id === 1 ){

[8] Fix | Delete

$full_table_name = $prefix . $table;

[9] Fix | Delete

} else {

[10] Fix | Delete

$full_table_name = $prefix . $blog_id . '_' . $table;

[11] Fix | Delete

}

[12] Fix | Delete

return $full_table_name;

[13] Fix | Delete

}

[14] Fix | Delete

[15] Fix | Delete

public static function build_select_query( string $table_name, string $columns, int $blog_id ): string {

[16] Fix | Delete

return "SELECT $columns, '$blog_id' as blog_id FROM $table_name";

[17] Fix | Delete

}

[18] Fix | Delete

[19] Fix | Delete

public static function union_queries( array $queries ): string {

[20] Fix | Delete

return join( ' UNION ', $queries );

[21] Fix | Delete

}

[22] Fix | Delete

[23] Fix | Delete

public static function build_temporary_table_query( string $table_name, string $query ): string {

[24] Fix | Delete

return "CREATE TEMPORARY TABLE $table_name AS $query";

[25] Fix | Delete

}

[26] Fix | Delete

}

[27] Fix | Delete