#!/usr/bin/env php
<?php
 try{
       $dir_name = explode('/',realpath(__DIR__));
       array_pop($dir_name);
       $python = join('/',$dir_name);
       $central = $python.'/admin/clases/';
       $youtube = $python.'/moduls/video_gallery/admin/youtube/';
       if(!file_exists($central.'Central.php'))throw new Exception('Central.php not found!');
       if(!file_exists($youtube.'maines.php'))throw new Exception('maines.php not found!');
       require_once $central.'Central.php';
       require_once $youtube.'maines.php';
       
       $_ = new Central;
       
       $obj = new stdClass();
       $obj->c_type = "big";
       $obj->sql = " and unikal_key != '' and logo != '' and attributes != '' order by date desc";
       $select = $_->select("unikal_key,attributes,logo,id","body",$obj);
       if(!$select || !isset($select['body']) || !count($select['body']))throw new Exception('video not found!');
       $select = $select['body'];
       $length = count($select);
       for($i = 0; $i < $length; $i++){
           $url_ = json_decode($select[$i]['attributes'])->url;
           if(!$_->url_exists($url_)){
                $youtube_class = new vv($select[$i]['unikal_key']);
                $youtube_best = $youtube_class->getbest('mp4');
                $_file = $youtube_best->image?$youtube_best->image:$youtube_best->thumb;
                $_attribute = Central::_json_encode($youtube_best); 
                if(!$_->update("body",[["logo","attributes"],[$_file,$_attribute],["id",$select[$i]['id']]]))
                        throw new Exception('update error!\n\n\n');
                else echo date('d-m-Y H:i:s')." \n id:".$select[$i]['id']." \n videoId:".$select[$i]['unikal_key']."\n\n\n";
           }
       }
       
 }catch(Exception $ex){
     die($ex->getMessage()."\n\n\n");
 }