<?php require_once __DIR__ . "/../FMA/autoload.php"; $_pdo = new \FMA\PDO\MySQL_PDO(); $in_string = file_get_contents(__DIR__ . "/../config/query_log.sql"); preg_match_all('/-- START\\s-- DATE:\\s([^\\s]*)\\s([\\S\\s]*?)\\s-- END/i', $in_string, $m, PREG_SET_ORDER); $matches = []; foreach ($m as $key => $match) { if (isset($matches[$match[1]])) { $matches[$match[1]] = $match[2] . "\n\n" . $matches[$match[1]]; } else { $matches[$match[1]] = $match[2]; } } unset($m, $match, $key); $matches = array_reverse($matches); foreach ($matches as $key => $value) { $matches[$key] = preg_split('/;(\\s*)/', $value); } $last_update = \FMA\Utility::getDateTimeFromMySQLDate(\FMA\Config::getLastUpdate()); foreach ($matches as $date => $queries) { $date = \FMA\Utility::getDateTimeFromMySQLDate($date); if ($date <= $last_update) { continue; } foreach ($queries as $query) { $_pdo->perform($query); } } end($matches); \FMA\Config::setLastUpdate(key($matches));