public function query($sql) { LogMaster::log($sql); $res = sasql_query($this->connection, $sql); if ($res === false) { throw new Exception("SaSQL operation failed\n" . sasql_error($this->connection)); } $this->last_result = $res; return $res; }
public function query($sql) { LogMaster::log($sql); if ($this->start_from) { $res = sqlsrv_query($this->connection, $sql, array(), array("Scrollable" => SQLSRV_CURSOR_STATIC)); } else { $res = sqlsrv_query($this->connection, $sql); } if ($res === false) { $errors = sqlsrv_errors(); $message = array(); foreach ($errors as $error) { $message[] = $error["SQLSTATE"] . $error["code"] . $error["message"]; } throw new Exception("SQLSrv operation failed\n" . implode("\n\n", $message)); } if ($this->insert_operation) { sqlsrv_next_result($res); $last = sqlsrv_fetch_array($res); $this->last_id = $last["dhx_id"]; sqlsrv_free_stmt($res); } if ($this->start_from) { $data = sqlsrv_fetch($res, SQLSRV_SCROLL_ABSOLUTE, $this->start_from - 1); } return $res; }
private function getFilesList($path, $relation) { $fileSystemTypes = FileSystemTypes::getInstance(); LogMaster::log("Query filesystem: " . $path); $dir = opendir($path . '/' . $relation); $result = new FileSystemResult(); // forms fields list for ($i = 0; $i < count($this->config->data); $i++) { $fields[] = $this->config->data[$i]['db_name']; } // for every file and directory of folder while ($file = readdir($dir)) { // . and .. should not be in output list if ($file == '.' || $file == '..') { continue; } $newFile = array(); // parse file name as Array('name', 'ext', 'is_dir') $fileNameExt = $this->parseFileName($path . '/' . $relation, $file); // checks if file should be in output array if (!$fileSystemTypes->checkFile($file, $fileNameExt)) { continue; } // takes file stat if it's need if (in_array('size', $fields) || in_array('date', $fields)) { $fileInfo = stat($path . '/' . $file); } // for every field forms list of fields for ($i = 0; $i < count($fields); $i++) { $field = $fields[$i]; switch ($field) { case 'filename': $newFile['filename'] = $file; break; case 'full_filename': $newFile['full_filename'] = $path . "/" . $file; break; case 'size': $newFile['size'] = $fileInfo['size']; break; case 'extention': $newFile['extention'] = $fileNameExt['ext']; break; case 'name': $newFile['name'] = $fileNameExt['name']; break; case 'date': $newFile['date'] = date("Y-m-d H:i:s", $fileInfo['ctime']); break; } $newFile['relation_id'] = $relation . '/' . $file; $newFile['safe_name'] = $this->setFileName($relation . '/' . $file); $newFile['is_folder'] = $fileNameExt['is_dir']; } // add file in output list $result->addFile($newFile); } return $result; }
public function query($sql) { LogMaster::log($sql); $res = pg_query($this->connection, $sql); if ($res === false) { throw new Exception("Postgre - sql execution failed\n" . pg_last_error($this->connection)); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = $this->connection->query($sql); if ($res === false) { throw new Exception("MySQL operation failed\n" . $this->connection->error); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = $this->connection->query($sql); if ($res === false) { throw new Exception("PDO - sql execution failed\n" . $this->connection->errorInfo()); } return new PDOResultSet($res); }
public function query($sql) { LogMaster::log($sql); $res = $this->connection->query($sql); if ($res === false) { throw new Exception("CI - sql execution failed"); } return new PHPCIResultSet($res); }
public function query($query) { LogMaster::log($query); $res = mysql_query($query, $this->connection); if (mysql_errno() != 0) { LogMaster::log($this->error()); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = $this->connection->query($sql); if ($res === false) { throw new Exception("SQLLite - sql execution failed\n" . $this->connection->lastErrorMsg()); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = sqlite_query($this->connection, $sql); if ($res === false) { throw new Exception("SQLLite - sql execution failed\n" . sqlite_error_string(sqlite_last_error($this->connection))); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = $this->connection->query($sql); if ($res === false) { throw new Exception("CI - sql execution failed"); } if (is_object($res)) { return new PHPCIResultSet($res); } return new ArrayQueryWrapper(array()); }
public function query($sql) { if ($this->last_result) { $this->last_result->closeCursor(); } LogMaster::log($sql); $this->last_result = $res = $this->connection->query($sql); if ($res === false) { throw new Exception("PDO - sql execution failed\n" . $this->connection->errorInfo()); } return $res; }
public function query($sql) { LogMaster::log($sql); $res = mssql_query($sql, $this->connection, $this->start_from === false ? 10 : 0); if ($this->insert_operation) { $last = mssql_fetch_assoc($res); $this->last_id = $last["dhx_id"]; mysql_free_result($res); } if ($this->start_from !== false) { mssql_data_seek($res, $this->start_from); } return $res; }
public function query($sql) { LogMaster::log($sql); if (is_array($sql)) { $res = $this->connection->SelectLimit($sql['sql'], $sql['numrows'], $sql['offset']); } else { $res = $this->connection->Execute($sql); } if ($res === false) { throw new Exception("ADODB operation failed\n" . $this->connection->ErrorMsg()); } $this->last_result = $res; return $res; }
function parse_request() { parent::parse_request(); if (isset($_GET["pos"])) { if (!$this->dload) { LogMaster::log("Dyn loading request received, but server side was not configured to process dyn. loading. "); } else { $this->request->set_limit($_GET["pos"], $this->dload); } } if (isset($_GET["mask"])) { $this->request->set_filter($this->config->text[0]["db_name"], $_GET["mask"] . "%", "LIKE"); } LogMaster::log($this->request); }
public function output_as_xml($results) { if (isset($_GET['action'])) { LogMaster::log("Edit operation finished", $results); ob_clean(); $type = $results[0]->get_status(); if ($type == "error" || $type == "invalid") { echo "false"; } else { if ($type == "insert") { echo "true\n" . $results[0]->get_new_id(); } else { echo "true"; } } } else { return parent::output_as_xml($results); } }
public function query($sql) { LogMaster::log($sql); if ($this->start_from) { $res = sqlsrv_query($this->connection, $sql, array(), array("Scrollable" => SQLSRV_CURSOR_STATIC)); } else { $res = sqlsrv_query($this->connection, $sql); } if ($this->insert_operation) { sqlsrv_next_result($res); $last = sqlsrv_fetch_array($res); $this->last_id = $last["dhx_id"]; sqlsrv_free_stmt($res); } if ($this->start_from) { $data = sqlsrv_fetch($res, SQLSRV_SCROLL_ABSOLUTE, $this->start_from - 1); } return $res; }
public function query($sql) { LogMaster::log($sql); $stm = oci_parse($this->connection, $sql); if ($stm === false) { throw new Exception("Oracle - sql parsing failed\n" . oci_error($this->connection)); } $out = array(0 => null); if ($this->insert_operation) { oci_bind_by_name($stm, ":outID", $out[0], 999); $this->insert_operation = false; } $mode = $this->is_record_transaction() || $this->is_global_transaction() ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS; $res = oci_execute($stm, $mode); if ($res === false) { throw new Exception("Oracle - sql execution failed\n" . oci_error($this->connection)); } $this->last_id = $out[0]; return $stm; }
static function CSRF_detected() { LogMaster::log("[SECURITY] Possible CSRF attack detected", array("referer" => $_SERVER["HTTP_REFERER"], "remote" => $_SERVER["REMOTE_ADDR"])); LogMaster::log("Request data", $_POST); die; }
function set_id($id) { $this->id = $id; LogMaster::log("Change id: " . $id); }
protected function end_run() { $time = microtime(true) - $this->exec_time; LogMaster::log("Done in {$time}s"); flush(); die; }
public function render() { $this->event->trigger("onInit", $this); EventMaster::trigger_static("connectorInit", $this); if (!$this->as_string) { $this->parse_request(); } $this->set_relation(); if ($this->live_update !== false && $this->updating !== false) { $this->live_update->get_updates(); } else { if ($this->editing) { if ($this->links_mode && isset($this->options["links"])) { $this->options["links"]->save(); } else { $dp = new $this->names["data_class"]($this, $this->config, $this->request); $dp->process($this->config, $this->request); } } else { if (!$this->access->check("read")) { LogMaster::log("Access control: read operation blocked"); echo "Access denied"; die; } $wrap = new SortInterface($this->request); $this->apply_sorts($wrap); $this->event->trigger("beforeSort", $wrap); $wrap->store(); $wrap = new FilterInterface($this->request); $this->apply_filters($wrap); $this->event->trigger("beforeFilter", $wrap); $wrap->store(); if ($this->model && method_exists($this->model, "get")) { $this->sql = new ArrayDBDataWrapper(); $result = new ArrayQueryWrapper(call_user_func(array($this->model, "get"), $this->request)); $out = $this->output_as_xml($result); } else { $out = $this->output_as_xml($this->get_resource()); if ($out !== null) { return $out; } } } } $this->end_run(); }
function set_value($name, $value) { LogMaster::log("change value of: " . $name . " as: " . $value); $this->data[$name] = $value; }
public static function enable_log($name, $output = false) { LogMaster::$_log = $name; LogMaster::$_output = $output; if ($name) { set_error_handler(array("LogMaster", "error_log"), E_ALL); set_exception_handler(array("LogMaster", "exception_log")); LogMaster::log("\n\n====================================\nLog started, " . date("d/m/Y h:m:s") . "\n===================================="); } }
function set_new_id($id) { $this->nid = $id; LogMaster::log("Change new id: " . $id); }
public function query($sql) { LogMaster::log($sql); $res = mysql_query($sql, $this->connection); if ($res === false) { throw new Exception("MySQL operation failed\n" . mysql_error($this->connection)); } return $res; }
public function set_attribute($name, $value) { if (method_exists($this->child, 'set_attribute')) { LogMaster::log("setting attribute: \nname = {$name}\nvalue = {$value}"); $this->child->set_attribute($name, $value); } else { LogMaster::log("set_attribute method doesn't exists"); } }