Edit File by line

Deprecated: str_replace(): Passing null to parameter #2 ($replace) of type array|string is deprecated in /home/sportsfever/public_html/filemanger/function.php on line 93
• /home/sportsfe.../httpdocs/wp-conte.../plugins/sitepres.../classes/upgrade
• File: class-wpml-upgrade-schema.php
<?php
[0] Fix | Delete
[1] Fix | Delete
class WPML_Upgrade_Schema {
[2] Fix | Delete
[3] Fix | Delete
/** @var wpdb $wpdb */
[4] Fix | Delete
private $wpdb;
[5] Fix | Delete
[6] Fix | Delete
public function __construct( wpdb $wpdb ) {
[7] Fix | Delete
$this->wpdb = $wpdb;
[8] Fix | Delete
}
[9] Fix | Delete
[10] Fix | Delete
/**
[11] Fix | Delete
* @param string $table_name
[12] Fix | Delete
*
[13] Fix | Delete
* @return bool
[14] Fix | Delete
*/
[15] Fix | Delete
public function does_table_exist( $table_name ) {
[16] Fix | Delete
return (bool) count( $this->wpdb->get_results( "SHOW TABLES LIKE '{$this->wpdb->prefix}{$table_name}'" ) );
[17] Fix | Delete
}
[18] Fix | Delete
[19] Fix | Delete
/**
[20] Fix | Delete
* @param string $table_name
[21] Fix | Delete
* @param string $column_name
[22] Fix | Delete
*
[23] Fix | Delete
* @return bool
[24] Fix | Delete
*/
[25] Fix | Delete
public function does_column_exist( $table_name, $column_name ) {
[26] Fix | Delete
return (bool) count( $this->wpdb->get_results( "SHOW COLUMNS FROM {$this->wpdb->prefix}{$table_name} LIKE '{$column_name}'" ) );
[27] Fix | Delete
}
[28] Fix | Delete
[29] Fix | Delete
/**
[30] Fix | Delete
* @param string $table_name
[31] Fix | Delete
* @param string $index_name
[32] Fix | Delete
*
[33] Fix | Delete
* @return bool
[34] Fix | Delete
*/
[35] Fix | Delete
public function does_index_exist( $table_name, $index_name ) {
[36] Fix | Delete
return (bool) count( $this->wpdb->get_results( "SHOW INDEXES FROM {$this->wpdb->prefix}{$table_name} WHERE key_name = '{$index_name}'" ) );
[37] Fix | Delete
}
[38] Fix | Delete
[39] Fix | Delete
/**
[40] Fix | Delete
* @param string $table_name
[41] Fix | Delete
* @param string $column_name
[42] Fix | Delete
* @param string $attribute_string
[43] Fix | Delete
*
[44] Fix | Delete
* @return false|int
[45] Fix | Delete
*/
[46] Fix | Delete
public function add_column( $table_name, $column_name, $attribute_string ) {
[47] Fix | Delete
return $this->wpdb->query( "ALTER TABLE {$this->wpdb->prefix}{$table_name} ADD `{$column_name}` {$attribute_string}" );
[48] Fix | Delete
}
[49] Fix | Delete
[50] Fix | Delete
/**
[51] Fix | Delete
* @param string $table_name
[52] Fix | Delete
* @param string $column_name
[53] Fix | Delete
* @param string $attribute_string
[54] Fix | Delete
*
[55] Fix | Delete
* @return false|int
[56] Fix | Delete
*/
[57] Fix | Delete
public function modify_column( $table_name, $column_name, $attribute_string ) {
[58] Fix | Delete
return $this->wpdb->query( "ALTER TABLE {$this->wpdb->prefix}{$table_name} MODIFY COLUMN `{$column_name}` {$attribute_string}" );
[59] Fix | Delete
}
[60] Fix | Delete
[61] Fix | Delete
/**
[62] Fix | Delete
* @param string $table_name
[63] Fix | Delete
* @param string $index_name
[64] Fix | Delete
* @param string $attribute_string
[65] Fix | Delete
*
[66] Fix | Delete
* @return false|int
[67] Fix | Delete
*/
[68] Fix | Delete
public function add_index( $table_name, $index_name, $attribute_string ) {
[69] Fix | Delete
return $this->wpdb->query( "ALTER TABLE {$this->wpdb->prefix}{$table_name} ADD INDEX `{$index_name}` {$attribute_string}" );
[70] Fix | Delete
}
[71] Fix | Delete
[72] Fix | Delete
/**
[73] Fix | Delete
* @param string $table_name
[74] Fix | Delete
* @param string $column_name
[75] Fix | Delete
*
[76] Fix | Delete
* @return null|string
[77] Fix | Delete
*/
[78] Fix | Delete
public function get_column_collation( $table_name, $column_name ) {
[79] Fix | Delete
return $this->wpdb->get_var(
[80] Fix | Delete
"SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS
[81] Fix | Delete
WHERE TABLE_SCHEMA = '{$this->wpdb->dbname}'
[82] Fix | Delete
AND TABLE_NAME = '{$this->wpdb->prefix}{$table_name}'
[83] Fix | Delete
AND COLUMN_NAME = '{$column_name}'"
[84] Fix | Delete
);
[85] Fix | Delete
}
[86] Fix | Delete
[87] Fix | Delete
/**
[88] Fix | Delete
* @param string $table_name
[89] Fix | Delete
*
[90] Fix | Delete
* @return string|null
[91] Fix | Delete
*/
[92] Fix | Delete
public function get_table_collation( $table_name ) {
[93] Fix | Delete
$table_data = $this->wpdb->get_row(
[94] Fix | Delete
$this->wpdb->prepare( 'SHOW TABLE status LIKE %s', $table_name )
[95] Fix | Delete
);
[96] Fix | Delete
[97] Fix | Delete
if ( isset( $table_data->Collation ) ) {
[98] Fix | Delete
return $table_data->Collation;
[99] Fix | Delete
}
[100] Fix | Delete
[101] Fix | Delete
return null;
[102] Fix | Delete
}
[103] Fix | Delete
[104] Fix | Delete
/**
[105] Fix | Delete
* We try to get the collation from the posts table first.
[106] Fix | Delete
*
[107] Fix | Delete
* @return string|null
[108] Fix | Delete
*/
[109] Fix | Delete
public function get_default_collate() {
[110] Fix | Delete
$posts_table_collate = $this->get_table_collation( $this->wpdb->posts );
[111] Fix | Delete
[112] Fix | Delete
if ( $posts_table_collate ) {
[113] Fix | Delete
return $posts_table_collate;
[114] Fix | Delete
} elseif ( ! empty( $this->wpdb->collate ) ) {
[115] Fix | Delete
return $this->wpdb->collate;
[116] Fix | Delete
}
[117] Fix | Delete
[118] Fix | Delete
return null;
[119] Fix | Delete
}
[120] Fix | Delete
[121] Fix | Delete
/**
[122] Fix | Delete
* @param string $table_name
[123] Fix | Delete
*
[124] Fix | Delete
* @return string|null
[125] Fix | Delete
*/
[126] Fix | Delete
public function get_table_charset( $table_name ) {
[127] Fix | Delete
try {
[128] Fix | Delete
$table_charset = $this->wpdb->get_row(
[129] Fix | Delete
$this->wpdb->prepare(
[130] Fix | Delete
'SELECT CCSA.character_set_name
[131] Fix | Delete
FROM information_schema.`TABLES` T,
[132] Fix | Delete
information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
[133] Fix | Delete
WHERE CCSA.collation_name = T.table_collation
[134] Fix | Delete
AND T.table_schema = "%s"
[135] Fix | Delete
AND T.table_name = "%s";',
[136] Fix | Delete
$this->wpdb->dbname,
[137] Fix | Delete
$table_name
[138] Fix | Delete
)
[139] Fix | Delete
);
[140] Fix | Delete
} catch ( Exception $e ) {}
[141] Fix | Delete
[142] Fix | Delete
if ( isset ( $table_charset->character_set_name ) ) {
[143] Fix | Delete
return $table_charset->character_set_name;
[144] Fix | Delete
}
[145] Fix | Delete
[146] Fix | Delete
return null;
[147] Fix | Delete
}
[148] Fix | Delete
[149] Fix | Delete
/**
[150] Fix | Delete
* We try to get the charset from the posts table first.
[151] Fix | Delete
*
[152] Fix | Delete
* @return string|null
[153] Fix | Delete
*/
[154] Fix | Delete
public function get_default_charset() {
[155] Fix | Delete
$post_table_charset = $this->get_table_charset( $this->wpdb->posts );
[156] Fix | Delete
[157] Fix | Delete
if ( $post_table_charset ) {
[158] Fix | Delete
return $post_table_charset;
[159] Fix | Delete
} elseif ( ! empty( $this->wpdb->charset ) ) {
[160] Fix | Delete
return $this->wpdb->charset;
[161] Fix | Delete
}
[162] Fix | Delete
[163] Fix | Delete
return null;
[164] Fix | Delete
}
[165] Fix | Delete
[166] Fix | Delete
/**
[167] Fix | Delete
* @return wpdb
[168] Fix | Delete
*/
[169] Fix | Delete
public function get_wpdb() {
[170] Fix | Delete
return $this->wpdb;
[171] Fix | Delete
}
[172] Fix | Delete
}
[173] Fix | Delete
[174] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function