<?php
ini_set('display_errors', true);

ini_set('max_execution_time', 0); //0=NOLIMIT
set_time_limit(0);
require 'db.php';
require "parse.php";

$parseData = parse();

$limit = 5;
$offset = 0;
$count = $db->query("SELECT COUNT(*) as total FROM dle_post");
$count = $count->fetch_assoc();
$count = $count['total'];
$dataLinks = [];
while (($offset + $limit) <= $count) {

    $res = $db->query("SELECT id, alt_name xfields FROM dle_post LIMIT {$limit} OFFSET {$offset}");
    while ($row = $res->fetch_assoc()) {
        $insData = [];
        $xfields = explode('|', $row['xfields']);

        foreach ($parseData as $datas) {
            foreach ($datas as $data) {
                $fullUrl = 'http://animerost.org'.$data['href'];
                if (array_search($fullUrl, $xfields)) {
                    $url = $xfields[array_search('url', $xfields) + 1];
                    $path = parse_url($url)['path'];
                    if ($path[0] != '/') continue;

                    /*
                    if(array_search('timer', $xfields)){
                        $timer = array_search('timer', $xfields) + 1;
                        $timer = $data['timer'];
                    }else{
                        $xfields[] = 'timer';
                        $xfields[] = $data['timer'];
                    }
                    if(array_search('fullDate', $xfields)){
                        $fullDate = array_search('fullDate', $xfields) + 1;
                        $fullDate = $data['fullDate'];
                    }else{
                        $xfields[] = 'fullDate';
                        $xfields[] = $data['fullDate'];
                    }
                    */
                    var_dump($row);
                    $insData['name'] = isset($data['name']) ? $data['name'] : null;
                    $insData['timer'] = isset($data['timer']) ? $data['timer'] : null;
                    $insData['fulldate'] = isset($data['fullDate']) ? $data['fullDate'] : null;
                    $insData['href'] = '/tip/tv/'.$row['id'].$row['alt_name'].'html';
                }
            }
        }
        var_dump($insData);
    $columns = implode(", ",array_keys($insData));
    $escaped_values = array_map('mysql_real_escape_string', array_values($insData));
    $values  = implode(", ", $escaped_values);
    $sql = "INSERT INTO `weekend`($columns) VALUES ($values)";
    echo $sql;
    var_dump($db->query($sql));

    }
    $offset += 10;

}