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/flow-flo.../libs/flowflow/core/src/db/migratio...
• File: LADBMigrationBase.php
<?php namespace la\core\db\migrations;
[0] Fix | Delete
if ( ! defined( 'WPINC' ) ) die;
[1] Fix | Delete
[2] Fix | Delete
use la\core\db\LADBMigrationManager;
[3] Fix | Delete
use la\core\db\LADDLUtils;
[4] Fix | Delete
[5] Fix | Delete
/**
[6] Fix | Delete
* Flow-Flow.
[7] Fix | Delete
*
[8] Fix | Delete
* @package FlowFlow
[9] Fix | Delete
* @author Looks Awesome <email@looks-awesome.com>
[10] Fix | Delete
*
[11] Fix | Delete
* @link http://looks-awesome.com
[12] Fix | Delete
* @copyright Looks Awesome
[13] Fix | Delete
*/
[14] Fix | Delete
abstract class LADBMigrationBase implements ILADBMigration{
[15] Fix | Delete
[16] Fix | Delete
public function version() {
[17] Fix | Delete
return LADBMigrationManager::INIT_MIGRATION;
[18] Fix | Delete
}
[19] Fix | Delete
[20] Fix | Delete
public function execute($conn, $manager){
[21] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->option_table_name)){
[22] Fix | Delete
$this->create_options_table($conn, $manager->option_table_name);
[23] Fix | Delete
}
[24] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->streams_table_name)){
[25] Fix | Delete
$this->create_streams_table($conn, $manager->streams_table_name);
[26] Fix | Delete
}
[27] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->cache_table_name)){
[28] Fix | Delete
$this->create_cache_table($conn, $manager->cache_table_name);
[29] Fix | Delete
}
[30] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->posts_table_name)){
[31] Fix | Delete
$this->create_posts_table($conn, $manager->posts_table_name);
[32] Fix | Delete
}
[33] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->post_media_table_name)){
[34] Fix | Delete
$this->create_post_media_table($conn, $manager->post_media_table_name);
[35] Fix | Delete
}
[36] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->streams_sources_table_name)){
[37] Fix | Delete
$this->create_streams2sources_table($conn, $manager->streams_sources_table_name);
[38] Fix | Delete
}
[39] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->image_cache_table_name)){
[40] Fix | Delete
$this->create_image_size_table($conn, $manager->image_cache_table_name);
[41] Fix | Delete
}
[42] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->snapshot_table_name)){
[43] Fix | Delete
$this->create_snapshot_table($conn, $manager->snapshot_table_name);
[44] Fix | Delete
}
[45] Fix | Delete
if (!LADDLUtils::existTable($conn, $manager->comments_table_name)){
[46] Fix | Delete
$this->create_comments_table($conn, $manager->comments_table_name);
[47] Fix | Delete
}
[48] Fix | Delete
}
[49] Fix | Delete
[50] Fix | Delete
protected function create_options_table ($conn, $table_name){
[51] Fix | Delete
$sql = "CREATE TABLE ?n
[52] Fix | Delete
(
[53] Fix | Delete
`id` VARCHAR(50) NOT NULL,
[54] Fix | Delete
`value` LONGBLOB,
[55] Fix | Delete
PRIMARY KEY (`id`)
[56] Fix | Delete
) ?p";
[57] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[58] Fix | Delete
}
[59] Fix | Delete
[60] Fix | Delete
protected function create_streams_table ($conn, $table_name){
[61] Fix | Delete
$sql = "CREATE TABLE ?n
[62] Fix | Delete
(
[63] Fix | Delete
`id` INT NOT NULL,
[64] Fix | Delete
`name` VARCHAR(250),
[65] Fix | Delete
`value` LONGBLOB,
[66] Fix | Delete
PRIMARY KEY (`id`)
[67] Fix | Delete
) ?p";
[68] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[69] Fix | Delete
}
[70] Fix | Delete
[71] Fix | Delete
protected function create_cache_table ($conn, $table_name) {
[72] Fix | Delete
$sql = "CREATE TABLE ?n
[73] Fix | Delete
(
[74] Fix | Delete
`feed_id` VARCHAR(20) NOT NULL,
[75] Fix | Delete
`last_update` INT NOT NULL,
[76] Fix | Delete
`status` INT NOT NULL DEFAULT 0,
[77] Fix | Delete
`errors` BLOB,
[78] Fix | Delete
`settings` BLOB,
[79] Fix | Delete
`enabled` TINYINT(1) DEFAULT 0,
[80] Fix | Delete
`system_enabled` TINYINT(1) DEFAULT 1,
[81] Fix | Delete
`changed_time` INT DEFAULT 0,
[82] Fix | Delete
`cache_lifetime` INT DEFAULT 60,
[83] Fix | Delete
`boosted` VARCHAR(4) DEFAULT 'nope',
[84] Fix | Delete
`send_email` INT DEFAULT 0 NOT NULL,
[85] Fix | Delete
PRIMARY KEY (`feed_id`)
[86] Fix | Delete
) ?p";
[87] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[88] Fix | Delete
}
[89] Fix | Delete
[90] Fix | Delete
protected function create_streams2sources_table($conn, $table_name){
[91] Fix | Delete
$sql = "CREATE TABLE ?n
[92] Fix | Delete
(
[93] Fix | Delete
`feed_id` VARCHAR(20) NOT NULL,
[94] Fix | Delete
`stream_id` INT NOT NULL,
[95] Fix | Delete
PRIMARY KEY (`feed_id`, `stream_id`)
[96] Fix | Delete
) ?p";
[97] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[98] Fix | Delete
}
[99] Fix | Delete
[100] Fix | Delete
protected function create_posts_table($conn, $table_name){
[101] Fix | Delete
$charset = $this->charset();
[102] Fix | Delete
$collate = $this->collate();
[103] Fix | Delete
$sql = "CREATE TABLE ?n
[104] Fix | Delete
(
[105] Fix | Delete
`feed_id` VARCHAR(20) NOT NULL,
[106] Fix | Delete
`post_id` VARCHAR(50) NOT NULL,
[107] Fix | Delete
`post_type` VARCHAR(10) NOT NULL,
[108] Fix | Delete
`post_text` BLOB,
[109] Fix | Delete
`post_permalink` VARCHAR(300),
[110] Fix | Delete
`post_header` VARCHAR(200){$collate},
[111] Fix | Delete
`user_nickname` VARCHAR(100){$collate},
[112] Fix | Delete
`user_screenname` VARCHAR(200){$collate},
[113] Fix | Delete
`user_pic` VARCHAR(700) NOT NULL,
[114] Fix | Delete
`user_link` VARCHAR(300),
[115] Fix | Delete
`rand_order` REAL,
[116] Fix | Delete
`creation_index` INT NOT NULL DEFAULT 0,
[117] Fix | Delete
`image_url` TEXT,
[118] Fix | Delete
`image_width` INT,
[119] Fix | Delete
`image_height` INT,
[120] Fix | Delete
`media_url` TEXT,
[121] Fix | Delete
`media_width` INT,
[122] Fix | Delete
`media_height` INT,
[123] Fix | Delete
`media_type` VARCHAR(100),
[124] Fix | Delete
`post_timestamp` INT,
[125] Fix | Delete
`smart_order` INT,
[126] Fix | Delete
`post_status` VARCHAR(15),
[127] Fix | Delete
`post_source` VARCHAR(300),
[128] Fix | Delete
`post_additional` VARCHAR(300),
[129] Fix | Delete
`user_bio` TEXT,
[130] Fix | Delete
`user_counts_media` INT,
[131] Fix | Delete
`user_counts_follows` INT,
[132] Fix | Delete
`user_counts_followed_by` INT,
[133] Fix | Delete
`location` TEXT,
[134] Fix | Delete
`carousel_size` INT,
[135] Fix | Delete
`post_content` BLOB DEFAULT NULL,
[136] Fix | Delete
PRIMARY KEY (`post_id`, `post_type`, `feed_id`)
[137] Fix | Delete
) ?p";
[138] Fix | Delete
$conn->query($sql, $table_name, $charset);
[139] Fix | Delete
}
[140] Fix | Delete
[141] Fix | Delete
protected function create_post_media_table($conn, $table_name){
[142] Fix | Delete
$charset = $this->charset();
[143] Fix | Delete
$sql = "CREATE TABLE ?n
[144] Fix | Delete
(
[145] Fix | Delete
`id` INT NOT NULL AUTO_INCREMENT,
[146] Fix | Delete
`feed_id` VARCHAR(20) NOT NULL,
[147] Fix | Delete
`post_id` VARCHAR(50) NOT NULL,
[148] Fix | Delete
`post_type` VARCHAR(10) NOT NULL,
[149] Fix | Delete
`media_url` TEXT,
[150] Fix | Delete
`media_width` INT,
[151] Fix | Delete
`media_height` INT,
[152] Fix | Delete
`media_type` VARCHAR(100),
[153] Fix | Delete
PRIMARY KEY (`id`)
[154] Fix | Delete
) ?p";
[155] Fix | Delete
$conn->query($sql, $table_name, $charset);
[156] Fix | Delete
}
[157] Fix | Delete
[158] Fix | Delete
protected function create_image_size_table($conn, $table_name) {
[159] Fix | Delete
$sql = "CREATE TABLE ?n (
[160] Fix | Delete
`url` VARCHAR(50) NOT NULL,
[161] Fix | Delete
`width` INT,
[162] Fix | Delete
`height` INT,
[163] Fix | Delete
`creation_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
[164] Fix | Delete
`original_url` VARCHAR(300),
[165] Fix | Delete
PRIMARY KEY (`url`)
[166] Fix | Delete
) ?p";
[167] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[168] Fix | Delete
}
[169] Fix | Delete
[170] Fix | Delete
protected function create_snapshot_table($conn, $table_name){
[171] Fix | Delete
$sql = "CREATE TABLE ?n (
[172] Fix | Delete
`id` INT NOT NULL AUTO_INCREMENT,
[173] Fix | Delete
`description` VARCHAR(20),
[174] Fix | Delete
`creation_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
[175] Fix | Delete
`settings` LONGTEXT NOT NULL,
[176] Fix | Delete
`fb_settings` LONGTEXT,
[177] Fix | Delete
`version` VARCHAR(10) DEFAULT '2.0' NOT NULL,
[178] Fix | Delete
`dump` BLOB,
[179] Fix | Delete
PRIMARY KEY (`id`)
[180] Fix | Delete
) ?p";
[181] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[182] Fix | Delete
}
[183] Fix | Delete
[184] Fix | Delete
protected function create_comments_table ($conn, $table_name){
[185] Fix | Delete
$sql = "CREATE TABLE ?n
[186] Fix | Delete
(
[187] Fix | Delete
`id` VARCHAR(50) NOT NULL,
[188] Fix | Delete
`post_id` VARCHAR(50) NOT NULL,
[189] Fix | Delete
`from` BLOB,
[190] Fix | Delete
`text` LONGBLOB,
[191] Fix | Delete
`created_time` INT,
[192] Fix | Delete
`updated_time` INT,
[193] Fix | Delete
PRIMARY KEY (`id`)
[194] Fix | Delete
) ?p";
[195] Fix | Delete
$conn->query($sql, $table_name, $this->charset());
[196] Fix | Delete
}
[197] Fix | Delete
[198] Fix | Delete
protected function charset(){
[199] Fix | Delete
$charset = LADDLUtils::charset();
[200] Fix | Delete
if ( !empty( $charset ) ) {
[201] Fix | Delete
$charset = " CHARACTER SET {$charset}";
[202] Fix | Delete
}
[203] Fix | Delete
return $charset;
[204] Fix | Delete
}
[205] Fix | Delete
[206] Fix | Delete
protected function collate(){
[207] Fix | Delete
$charset_collate = '';
[208] Fix | Delete
$collate = LADDLUtils::collate();
[209] Fix | Delete
if ( !empty( $collate ) ) {
[210] Fix | Delete
$charset_collate = " COLLATE {$collate}";
[211] Fix | Delete
}
[212] Fix | Delete
return $charset_collate;
[213] Fix | Delete
}
[214] Fix | Delete
}
[215] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function