<?php // get a user's authorised projects require_once $_SERVER['DOCUMENT_ROOT'] . '/include/main_func.php'; auth(); $user = $_SESSION['user_id']; $q = new myQuery("SELECT id, project.user_id, name, notes, perm FROM project\n LEFT JOIN project_user ON project.id=project_id \n WHERE project_user.user_id='{$user}'"); $return['projects'] = $q->get_assoc(); $_SESSION['projects'] = $q->get_one_col('id'); foreach ($return['projects'] as $i => $proj) { $q = new myQuery("SELECT user.id, firstname, lastname, email, project_user.perm\n FROM project_user \n LEFT JOIN user ON user.id=user_id \n LEFT JOIN project ON project.id=project_id\n WHERE project_id={$proj['id']}\n ORDER BY project.user_id!=user.id, lastname, firstname"); $return['projects'][$i]['owners'] = $q->get_assoc(); } $q = new myQuery("SELECT id, firstname, lastname, email FROM user"); $return['users'] = $q->get_by_id('id'); function countFilesOO($dir) { if (!is_dir($dir)) { return false; } /* $Directory=new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS); $Iterator = new RecursiveIteratorIterator($Directory); $TrashRegex = new RegexIterator($Iterator, '/\/\.trash\//', RecursiveRegexIterator::GET_MATCH); $trash = iterator_count($TrashRegex); $TmpRegex = new RegexIterator($Iterator, '/\/\.tmp\//', RecursiveRegexIterator::GET_MATCH); $tmp = iterator_count($TmpRegex); $files = iterator_count($Iterator); //foreach ($Iterator as $filename=>$cur) { // $size += $cur->getSize(); //}
function userAllocation($user_id) { $q = new myQuery("SELECT project.id as id, allocation \n FROM project \n LEFT JOIN user ON user.id=user_id \n WHERE user_id='{$user_id}'"); $projects = $q->get_one_col('id'); $allocation = $q->get_one(0, 'allocation'); $size = 0; foreach ($projects as $id) { $size += exec('du -sm ' . IMAGEBASEDIR . $id); } return array('size' => $size, 'allocation' => $allocation); }