Edit File by line

<?php namespace flow\db\migrations;

[0] Fix | Delete

use Exception;

[1] Fix | Delete

use la\core\db\LADDLUtils;

[2] Fix | Delete

use la\core\db\migrations\ILADBMigration;

[3] Fix | Delete

[4] Fix | Delete

if ( ! defined( 'WPINC' ) ) die;

[5] Fix | Delete

/**

[6] Fix | Delete

* FlowFlow.

[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

class FFMigration_3_0 implements ILADBMigration{

[15] Fix | Delete

[16] Fix | Delete

public function version() {

[17] Fix | Delete

return '3.0';

[18] Fix | Delete

}

[19] Fix | Delete

[20] Fix | Delete

public function execute($conn, $manager) {

[21] Fix | Delete

if (LADDLUtils::existColumn($conn, $manager->streams_table_name, 'layout')){

[22] Fix | Delete

LADDLUtils::dropColumn($conn, $manager->streams_table_name, 'layout');

[23] Fix | Delete

}

[24] Fix | Delete

[25] Fix | Delete

$streams = $this->streams($conn, $manager->streams_table_name);

[26] Fix | Delete

foreach ( $streams as $stream ) {

[27] Fix | Delete

$options = unserialize($stream['value']);

[28] Fix | Delete

[29] Fix | Delete

$options->{"layout"} = "masonry";

[30] Fix | Delete

$options->{"upic-pos"} = "timestamp";

[31] Fix | Delete

$options->{"upic-style"} = "round";

[32] Fix | Delete

$options->{"icon-style"} = "label1";

[33] Fix | Delete

$options->{"icons-style"} = "outline";

[34] Fix | Delete

$options->{"c-desktop"} = "5";

[35] Fix | Delete

$options->{"c-laptop"} = "4";

[36] Fix | Delete

$options->{"c-tablet-l"} = "3";

[37] Fix | Delete

$options->{"c-tablet-p"} = "2";

[38] Fix | Delete

$options->{"c-smart-l"} = "2";

[39] Fix | Delete

$options->{"c-smart-p"} = "1";

[40] Fix | Delete

$options->{"s-desktop"} = "15";

[41] Fix | Delete

$options->{"s-laptop"} = "15";

[42] Fix | Delete

$options->{"s-tablet-l"} = "10";

[43] Fix | Delete

$options->{"s-tablet-p"} = "10";

[44] Fix | Delete

$options->{"s-smart-l"} = "5";

[45] Fix | Delete

$options->{"s-smart-p"} = "5";

[46] Fix | Delete

$options->{"m-c-desktop"} = "5";

[47] Fix | Delete

$options->{"m-c-laptop"} = "4";

[48] Fix | Delete

$options->{"m-c-tablet-l"} = "3";

[49] Fix | Delete

$options->{"m-c-tablet-p"} = "2";

[50] Fix | Delete

$options->{"m-c-smart-l"} = "2";

[51] Fix | Delete

$options->{"m-c-smart-p"} = "1";

[52] Fix | Delete

$options->{"m-s-desktop"} = "15";

[53] Fix | Delete

$options->{"m-s-laptop"} = "15";

[54] Fix | Delete

$options->{"m-s-tablet-l"} = "10";

[55] Fix | Delete

$options->{"m-s-tablet-p"} = "10";

[56] Fix | Delete

$options->{"m-s-smart-l"} = "5";

[57] Fix | Delete

$options->{"m-s-smart-p"} = "5";

[58] Fix | Delete

$options->{"j-h-desktop"} = "260";

[59] Fix | Delete

$options->{"j-h-laptop"} = "240";

[60] Fix | Delete

$options->{"j-h-tablet-l"} = "220";

[61] Fix | Delete

$options->{"j-h-tablet-p"} = "200";

[62] Fix | Delete

$options->{"j-h-smart-l"} = "180";

[63] Fix | Delete

$options->{"j-h-smart-p"} = "160";

[64] Fix | Delete

$options->{"j-s-desktop"} = "0";

[65] Fix | Delete

$options->{"j-s-laptop"} = "0";

[66] Fix | Delete

$options->{"j-s-tablet-l"} = "0";

[67] Fix | Delete

$options->{"j-s-tablet-p"} = "0";

[68] Fix | Delete

$options->{"j-s-smart-l"} = "0";

[69] Fix | Delete

$options->{"j-s-smart-p"} = "0";

[70] Fix | Delete

$options->{"g-ratio-w"} = "1";

[71] Fix | Delete

$options->{"g-ratio-h"} = "2";

[72] Fix | Delete

$options->{"g-ratio-img"} = "1/2";

[73] Fix | Delete

$options->{"g-overlay"} = "nope";

[74] Fix | Delete

$options->{"m-overlay"} = "nope";

[75] Fix | Delete

$options->{"template"} = [ 'header', 'text', 'image', 'meta' ];

[76] Fix | Delete

$value = serialize($options);

[77] Fix | Delete

[78] Fix | Delete

if ( false === $conn->query( 'UPDATE ?n SET `value` = ?s WHERE `id` = ?s',

[79] Fix | Delete

$manager->streams_table_name, $value, $stream['id'] ) ) {

[80] Fix | Delete

throw new Exception();

[81] Fix | Delete

}

[82] Fix | Delete

[83] Fix | Delete

$options->id = $stream['id'];

[84] Fix | Delete

$manager->generateCss($options);

[85] Fix | Delete

}

[86] Fix | Delete

}

[87] Fix | Delete

[88] Fix | Delete

private function streams($conn, $table_name){

[89] Fix | Delete

if (false !== ($result = $conn->getAll('SELECT `id`, `name`, `value` FROM ?n ORDER BY `id`',

[90] Fix | Delete

$table_name))){

[91] Fix | Delete

return $result;

[92] Fix | Delete

}

[93] Fix | Delete

return [];

[94] Fix | Delete

}

[95] Fix | Delete

}

[96] Fix | Delete