function getDirContaints($dir, $results = array(), $backDir = "")
{
    $allfiles = scandir($dir);
    $files = new Files();
    foreach ($allfiles as $key => $value) {
        if (!in_array($value, array(".", ".."))) {
            $timestamp = strtotime($value);
            $path = realpath($dir . DIRECTORY_SEPARATOR . $value);
            $uploadDirInfo = explode("_", basename($path));
            if (is_dir($path)) {
                $dir_files = scandir($path);
                foreach ($dir_files as $k => $v) {
                    if (!in_array($v, array(".", ".."))) {
                        $pth = realpath($path . DIRECTORY_SEPARATOR . $v);
                        if (!is_dir($pth)) {
                            $data['filename'] = basename($pth);
                            $data['filepath'] = $path;
                            $data['user_id'] = $uploadDirInfo['1'];
                            $data['user_name'] = $uploadDirInfo['0'];
                            $files->uploadBulkFiles($data);
                        }
                    }
                }
            }
        }
    }
    return 'Files uploaded successfuly';
}

 /**
  * @remotable
  */
 public function read($id, $cat)
 {
     $out = array();
     if ($cat == "projects") {
         $projects = $this->db->select("SELECT id, name, dir, date FROM projects ORDER BY date DESC");
         foreach ($projects as $item) {
             $children = array();
             $text = "<b>Date</b>: {$item['date']}<br>";
             $text .= "<b>Dir/File</b>: {$item['dir']}<br>";
             if (is_dir($item['dir'])) {
                 array_push($children, array('id' => $item['dir'], 'text' => 'Work Directory', 'cat' => 'dir', 'qtip' => $item['dir'], iconCls => 'work-dir', 'leaf' => false));
             } elseif (is_file($item['dir'])) {
                 array_push($children, array('id' => $item['dir'], 'text' => basename($item['dir']), 'hash' => md5($item['dir']), 'iconCls' => 'php-file', 'leaf' => true));
             }
             array_push($children, array('id' => 'scans' . $item['id'], 'text' => 'Scannings', 'cat' => 'scans', 'iconCls' => 'scannings', 'leaf' => false));
             array_push($children, array('id' => 'vulns' . $item['id'], 'text' => 'Vulnerabilities', 'cat' => 'vulns', 'iconCls' => 'vulns', 'leaf' => false));
             array_push($out, array('id' => $item['id'], 'text' => $item['name'], 'iconCls' => 'project', 'cat' => 'project', 'qtipCfg' => array('shadow' => 'frame', 'text' => $text, 'dismissDelay' => 10000), 'leaf' => false, 'children' => $children));
         }
     } elseif ($cat == "dir") {
         include 'Files.php';
         $f = new Files();
         $out = $f->getList($id);
     } elseif ($cat == "scans") {
         include 'ScanHistory.php';
         $s = new ScanHistory();
         $out = $s->read(substr($id, 5));
     } elseif ($cat == "vulns") {
         include 'Vulnerabilities.php';
         $v = new Vulnerabilities();
         $out = $v->read(substr($id, 5));
     }
     return $out;
 }

 public function testNot()
 {
     $kirby = $this->kirbyInstance();
     $site = $this->siteInstance($kirby);
     $page = new Page($site, 'tests/file-extension-case-test');
     // unset by a single filename
     $files = new Files($page);
     $this->assertEquals(2, $files->count());
     $modified = $files->not('a.json');
     $this->assertEquals(1, $modified->count());
     // unset by multiple filenames
     $files = new Files($page);
     $this->assertEquals(2, $files->count());
     $modified = $files->not('a.json', 'b.json');
     $this->assertEquals(0, $modified->count());
     // unset by array
     $files = new Files($page);
     $this->assertEquals(2, $files->count());
     $modified = $files->not(['a.json', 'b.json']);
     $this->assertEquals(0, $modified->count());
     // unset by a collection
     $files = new Files($page);
     $this->assertEquals(2, $files->count());
     $modified = $files->not($files);
     $this->assertEquals(0, $modified->count());
 }

 public function noavatarAction()
 {
     $files = new Files();
     $file = $this->_properties->getProperty('avatar_image');
     $this->_properties->deleteProperty('avatar_image');
     $files->deleteFile($file);
     $this->_forward('index');
 }

 /**
  * Constructor
  *
  * @param Files The parent files collection
  * @param string The filename
  */
 public function __construct(Files $files, $filename)
 {
     $this->site = $files->site();
     $this->page = $files->page();
     $this->files = $files;
     $this->root = $this->files->page()->root() . DS . $filename;
     parent::__construct($this->root);
 }

 /**
  * Вывод инфы о бане
  * @param integer $id ID бана
  */
 public function actionView($id)
 {
     // Подгружаем комментарии и файлы
     $files = new Files();
     //$this->performAjaxValidation($files);
     $files->unsetAttributes();
     $comments = new Comments();
     $comments->unsetAttributes();
     // Подгружаем баны
     $model = Bans::model()->with('admin')->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     $geo = false;
     // Проверка прав на просмотр IP
     $ipaccess = Webadmins::checkAccess('ip_view');
     if ($ipaccess) {
         $geo = array('city' => 'Н/А', 'region' => 'Не определен', 'country' => 'Не определен', 'lat' => 0, 'lng' => 0);
         $get = @file_get_contents('http://ipgeobase.ru:7020/geo?ip=' . $model->player_ip);
         if ($get) {
             $xml = @simplexml_load_string($get);
             if (!empty($xml->ip)) {
                 $geo['city'] = $xml->ip->city;
                 $geo['region'] = $xml->ip->region;
                 $geo['country'] = $xml->ip->country;
                 $geo['lat'] = $xml->ip->lat;
                 $geo['lng'] = $xml->ip->lng;
             }
         }
     }
     // Добавление файла
     if (isset($_POST['Files'])) {
         // Задаем аттрибуты
         $files->attributes = $_POST['Files'];
         $files->bid = intval($id);
         if ($files->save()) {
             $this->refresh();
         }
     }
     // Добавление комментария
     if (isset($_POST['Comments'])) {
         //exit(print_r($_POST['Comments']));
         $comments->attributes = $_POST['Comments'];
         $comments->bid = $id;
         if ($comments->save()) {
             $this->refresh();
         }
     }
     // Выборка комментариев
     $c = new CActiveDataProvider($comments, array('criteria' => array('condition' => 'bid = :bid', 'params' => array(':bid' => $id))));
     // Выборка файлов
     $f = new CActiveDataProvider(Files::model(), array('criteria' => array('condition' => 'bid = :bid', 'params' => array(':bid' => $id))));
     // История банов
     $history = new CActiveDataProvider('Bans', array('criteria' => array('condition' => '`bid` <> :hbid AND (`player_ip` = :hip OR `player_id` = :hid)', 'params' => array(':hbid' => $id, ':hip' => $model->player_ip, ':hid' => $model->player_id)), 'pagination' => array('pageSize' => 5)));
     // Вывод всего на вьюху
     $this->render('view', array('geo' => $geo, 'ipaccess' => $ipaccess, 'model' => $model, 'files' => $files, 'comments' => $comments, 'f' => $f, 'c' => $c, 'history' => $history));
 }

 public function backupDB()
 {
     $dumper = new dbMaster();
     $sql = $dumper->getDump(false);
     $file = new Files();
     $file->name = "DB Backup " . date("d-m-Y_H_i") . ".sql";
     $file->path = '.';
     $file->save();
     $file->writeFile($sql);
     $this->DBback = $file->id;
 }

 public function action_index()
 {
     $record = new Files();
     $record->parent_id = $_POST['parent_id'];
     $record->text = $_POST['text'];
     $record->extension = $_POST['extension'];
     $record->leaf = $_POST['leaf'];
     $record->save();
     $array = array('success' => 'true', 'msg' => 'Record added successfully');
     $json = json_encode($array);
     return $json;
 }

 /**
  * Helper function to use within theme files for hardcoded links
  * 
  * @param url $file_url URL of file
  * @param boolean $force_download Wheather to force download or not
  * @return url Parsed link
  */
 function sqhrdm_get_download_link($file_url = null, $force_download = true)
 {
     if (!$file_url) {
         return '#';
     }
     require_once SQHR_DM_PLUGIN_PATH . 'system/controllers/class.files.php';
     $files = new Files();
     $file_id = $files->get_file_id($file_url);
     $return .= '?process_download=';
     $return .= $file_id;
     $return .= !$force_download ? '&pd_force=no' : '';
     return $return;
 }

 public function add($data)
 {
     $data['addtime'] = time();
     $File = new Files();
     foreach ($data as $field => $value) {
         $File->{$field} = $value;
     }
     if (!$File->create()) {
         $this->outputErrors($File);
         return false;
     }
     return true;
 }

 public function upload(Request $request)
 {
     $file = $request->file;
     $imageName = md5(time() * rand(1, 100)) . '.' . $file->getClientOriginalExtension();
     $f = new Files();
     $f->name = $imageName;
     $f->mimeType = $file->getMimeType();
     $f->size = $file->getSize();
     $f->user_id = 1;
     $f->produto_id = $request->input('produto_id');
     $file->move(base_path() . '/public/imagens/', $imageName);
     $f->save();
     return 'OK';
 }

 public function renderDefault()
 {
     $files = $this->files->order($this->order . " " . $this->sort);
     // vyhledavani
     if ($this->q) {
         $files->where("file.name LIKE ?", "%" . $this->q . "%");
         $this['search']['q']->setDefaultValue($this->q);
         $this->template->search = TRUE;
     } else {
         $this->template->search = FALSE;
     }
     $this->pagerFiles->itemCount = $files->count();
     $this->template->files = $files->limit($this->pagerFiles->getLimit(), $this->pagerFiles->getOffset());
 }

 public function listFiles()
 {
     Zend_Loader::loadClass('Files');
     $files = new Files();
     $list = $files->listFiles('public/files/uploaded/');
     sort($list);
     $all = array();
     foreach ($list as $filename) {
         $row['name'] = $filename;
         $row['filesize'] = filesize('public/files/uploaded/' . $filename);
         array_push($all, $row);
     }
     return $all;
 }

 public function createMongoAction()
 {
     $file = new Files();
     $file->type = "video";
     $file->name = "Astro Boy";
     $file->year = 1952;
     if ($file->save() == false) {
         echo "Umh, We can't store files right now: \n";
         foreach ($file->getMessages() as $message) {
             echo $message, "\n";
         }
     } else {
         echo "Great, a new file was saved successfully !";
     }
 }

 public function listAction()
 {
     $format = $this->_getParam('format', 'ajax');
     switch ($format) {
         case 'xml':
             $this->_helper->layout->setLayout('xml');
             $this->_helper->viewRenderer('list-xml');
             break;
         default:
             $this->_helper->layout->setLayout('ajax');
     }
     Zend_Loader::loadClass('Files');
     $files = new Files();
     $this->view->list = $files->listFiles('public/files/uploaded/');
 }

 /**
  * @constructor
  */
 public function __construct($data_folder = '')
 {
     // load the config file.
     $this->config = new Config();
     $this->config->load($data_folder);
     // load the templates.
     $this->templates = new Templates();
     $this->templates->load($data_folder);
     // loading data files.
     $this->files = new Files();
     $this->files->load($data_folder, $this->config->get('pages_data'));
     // initialize database.
     $this->db = new Database();
     //
     $this->renders = new Renders();
 }

/**
 * Draw the files in an table.
 */
function drawFiles($list, &$manager)
{
    global $relative;
    foreach ($list as $entry => $file) {
        ?>
		<td><table width="100" cellpadding="0" cellspacing="0"><tr><td class="block">
		<a href="javascript:;" onclick="selectImage('<?php 
        echo $file['relative'];
        ?>
', '<?php 
        echo $entry;
        ?>
', <?php 
        echo $file['image'][0];
        ?>
, <?php 
        echo $file['image'][1];
        ?>
);"title="<?php 
        echo $entry;
        ?>
 - <?php 
        echo Files::formatSize($file['stat']['size']);
        ?>
"><img src="<?php 
        echo $manager->getThumbnail($file['relative']);
        ?>
" alt="<?php 
        echo $entry;
        ?>
 - <?php 
        echo Files::formatSize($file['stat']['size']);
        ?>
"/></a>
		</td></tr><tr><td class="edit">
			<a href="images.php?dir=<?php 
        echo $relative;
        ?>
&amp;delf=<?php 
        echo rawurlencode($file['relative']);
        ?>
" title="Trash" onclick="return confirmDeleteFile('<?php 
        echo $entry;
        ?>
');"><img src="img/edit_trash.gif" height="15" width="15" alt="Trash"/></a><a href="javascript:;" title="Edit" onclick="editImage('<?php 
        echo rawurlencode($file['relative']);
        ?>
');"><img src="img/edit_pencil.gif" height="15" width="15" alt="Edit"/></a>
		<?php 
        if ($file['image']) {
            echo $file['image'][0] . 'x' . $file['image'][1];
        } else {
            echo $entry;
        }
        ?>
		</td></tr></table></td> 
	  <?php 
    }
    //foreach
}

 protected static function personPrepare()
 {
     return PersonModel::join(PersonLangModel::getTableName(), PersonLangModel::getField("person_id"), '=', PersonModel::getField("id"))->join(PersonRelModel::getTableName(), PersonRelModel::getField("person_id"), '=', PersonModel::getField("id"))->leftJoin(Files::getTableName(), function ($join) {
         $join->on(Files::getField("module_id"), '=', PersonModel::getField("id"));
         $join->on(Files::getField("module_name"), '=', DB::raw("'person'"));
     })->where(PersonLangModel::getField("lang_id"), \WebAPL\Language::getId())->orderBy('first_name', 'asc')->orderBy('last_name', 'asc');
 }

 /**
  * Get all folders and files within a folder
  *
  * @param   int     $parent The id of this folder
  * @return  array
  *
  **/
 public static function folder_contents($parent = 0, $type = null)
 {
     // they can also pass a url hash such as #foo/bar/some-other-folder-slug
     if (!is_numeric($parent)) {
         $segment = explode('/', trim($parent, '/#'));
         $result = ci()->file_folders_m->get_by('slug', array_pop($segment));
         $parent = $result ? $result->id : 0;
     }
     $folders = ci()->file_folders_m->where('parent_id', $parent)->where('hidden', 0)->order_by('sort')->get_all();
     // $files = ci()->file_m->where(array('folder_id' => $parent))
     //     ->order_by('sort')
     //     ->get_all();
     $files = ci()->file_m->where(array('folder_id' => $parent, 'type' => $type))->order_by('sort')->get_all();
     // let's be nice and add a date in that's formatted like the rest of the CMS
     if ($folders) {
         foreach ($folders as &$folder) {
             $folder->formatted_date = format_date($folder->date_added);
             $folder->file_count = ci()->file_m->count_by('folder_id', $folder->id);
         }
     }
     if ($files) {
         ci()->load->library('keywords/keywords');
         foreach ($files as &$file) {
             $file->keywords_hash = $file->keywords;
             $file->keywords = ci()->keywords->get_string($file->keywords);
             $file->formatted_date = format_date($file->date_added);
         }
     }
     return Files::result(true, null, null, array('folder' => $folders, 'file' => $files, 'parent_id' => $parent));
 }

 /**
  * Sets up internal variables with the arguments given
  * @param string $label The (human-readable) label for the form element
  * @param string $name The (machine-readable) name of the element
  * @param array $data The url to the image-object
  * @param string $validate Adds a validation class to the element
  * @param string $description Add a description to the form element
  * @param bool $preview Adds a preview of the choosen image
  * @return void
  */
 function __construct($label, $name, $value = '', $validate = false, $description = false, $preview = true, $dir = false, $class = false)
 {
     $this->label = $label;
     $this->value = $value;
     $this->name = $name;
     $this->validate = $validate;
     $this->preview = $preview;
     $this->description = $description;
     $this->class = $class;
     global $Controller;
     if ($dir && (is_a($dir, 'User') || is_a($dir, 'Group'))) {
         $dir = Files::userDir($dir);
     }
     if ($dir) {
         if (!is_object($dir)) {
             $dir = $Controller->{(string) $dir};
         }
         if (!$dir->mayI(READ)) {
             $dir = false;
         }
         $this->dir = $dir->ID;
     } else {
         $this->dir = false;
     }
 }