/** * Executes SQL statement, returns a mysqli_result object or Array if fetched * * @author Basilio Briceno <*****@*****.**> * @param string $sql SQL statement * @param boolean $fetch Flag to returns result as a fetched array * @param boolean $one_row Flag to return only one fetched row array * @return mixed mysqli_result object, fetched array, or FALSE on failure */ public function query($sql, $fetch = false, $one_row = false) { if (request('debug')) { $start_time = microtime(true); } $result = parent::query($sql); if (request('debug')) { tf_log('SQL [' . round($start_time - microtime(true), 4) . 's] ' . $sql); unset($start_time); } if ($one_row) { $rows = $result->fetch_all(MYSQLI_ASSOC); $result->free(); return $rows[0]; } if ($fetch) { $rows = $result->fetch_all(MYSQLI_ASSOC); $result->free(); return $rows; } return $result; }
/** * Saves upload files from their temporal path to the configured one * * @author Basilio Briceno <*****@*****.**> * @license http://www.gnu.org/licenses/lgpl.html GNU LGPL * @param string $input_name If not set it will try to save everything in _FILES * @param array $filter_rule Example: type => pdf, size => 1024 * @return boolean Returns TRUE if file saved, FALSE if error */ function tf_fileup_save($input_name = 'all', $filter_rule = false) { $path = realpath('.') . '/' . conf_get('default', 'uploads'); // check if _FILES contains an element if (count($_FILES) < 1) { tf_error('[Upload] No files to save'); return false; } else { // save everything in _FILES if ($input_name == 'all') { foreach ($_FILES as $key => $file) { // check file size if ($file['size'] > 1) { $save_flag = true; if ($filter_rule) { $save_flag = tf_fileup_filter($key, $filter_rule); } if ($save_flag) { // try to copy file to destination if (!@copy($file['tmp_name'], $path . $file['name'])) { tf_error('[Upload] Cannot write (' . $input_name . ') into ' . $path); } tf_log('Upload: File (' . $file['name'] . ') written into ' . $path); } unset($save_flag); } } } // check file existance if (!isset($_FILES[$input_name])) { tf_error('[Upload] Required input (' . $input_name . ') not found'); return false; } else { // check file size if ($_FILES[$input_name]['size'] > 1) { $save_flag = true; if ($filter_rule) { $save_flag = tf_fileup_filter($input_name, $filter_rule); } if ($save_flag) { // try to copy file to destination if (!@copy($_FILES[$input_name]['tmp_name'], $path . $_FILES[$input_name]['name'])) { tf_error('[Upload] Cannot write (' . $input_name . ') into ' . $path); return false; } tf_log('Upload: File (' . $_FILES[$input_name]['name'] . ') written into ' . $path); return true; } else { return false; } unset($save_flag); } } } }