function doquery($query, $table, $fetch = false) { global $link, $debug, $ugamela_root_path; @(include $ugamela_root_path . 'config.php'); if (!$link) { $link = odbc_connect($dbsettings["server"], $dbsettings["user"], $dbsettings["pass"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); //message(mysql_error()."<br />$query","SQL Error"); odbc_select_db($dbsettings["name"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); } // por el momento $query se mostrara // pero luego solo se vera en modo debug $sqlquery = odbc_exec($query, str_replace("{{table}}", $dbsettings["prefix"] . $table)) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); //message(mysql_error()."<br />$query","SQL Error"); unset($dbsettings); //se borra la array para liberar algo de memoria global $numqueries, $debug; //,$depurerwrote003; $numqueries++; //$depurerwrote003 .= ; $debug->add("<tr><th>Query {$numqueries}: </th><th>{$query}</th><th>{$table}</th><th>{$fetch}</th></tr>"); if ($fetch) { //hace el fetch y regresa $sqlrow $sqlrow = odbc_fetch_array($sqlquery); return $sqlrow; } else { //devuelve el $sqlquery ("sin fetch") return $sqlquery; } }
function doquery($query, $table, $fetch = false) { global $link, $debug, $xnova_root_path; @(include $xnova_root_path . 'config.php'); if (!$link) { $link = odbc_connect($dbsettings["server"], $dbsettings["user"], $dbsettings["pass"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); odbc_select_db($dbsettings["name"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); } $sqlquery = odbc_exec($query, str_replace("{{table}}", $dbsettings["prefix"] . $table)) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error"); unset($dbsettings); global $numqueries, $debug; $numqueries++; $debug->add("<tr><th>Query {$numqueries}: </th><th>{$query}</th><th>{$table}</th><th>{$fetch}</th></tr>"); if ($fetch) { $sqlrow = odbc_fetch_array($sqlquery); return $sqlrow; } else { return $sqlquery; } }
function doquery($query, $table, $fetch = false) { global $numqueries, $link, $debug, $rocketnova_root_path; require $rocketnova_root_path . 'config.php'; if (!$link) { $link = mysql_connect($dbsettings["server"], $dbsettings["user"], $dbsettings["pass"]) or $debug->error(mysql_error() . "<br />{$query}", "SQL Error"); odbc_select_db($dbsettings["name"]) or $debug->error(mysql_error() . "<br />{$query}", "SQL Error"); } $sql = str_replace("{{table}}", $dbsettings["prefix"] . $table, $query); $sqlquery = mysql_query($sql) or $debug->error(mysql_error() . "<br />{$sql}<br />", "SQL Error"); unset($dbsettings); $numqueries++; $arr = debug_backtrace(); $file = end(explode('/', $arr[1]['file'])); $line = $arr[1]['line']; $debug->add("<tr><th>Query {$numqueries}: </th><th>{$query}</th><th>{$file}({$line})</th><th>{$table}</th><th>{$fetch}</th></tr>"); if ($fetch) { $sqlrow = mysql_fetch_array($sqlquery); return $sqlrow; } else { return $sqlquery; } }
/** * check if given database name is exists? * * @param string $name name of the database that should be checked * * @return mixed true/false on success, a MDB2 error on failure * @access public */ function databaseExists($name) { $connection = $this->_doConnect($this->dsn['username'], $this->dsn['password'], $this->options['persistent']); if (PEAR::isError($connection)) { return $connection; } $result = odbc_select_db($name, $connection); $errorInfo = $this->errorInfo(null, $connection); odbc_close($connection); if (!$result) { if ($errorInfo[0] != MDB2_ERROR_NOT_FOUND) { exit; $result = $this->raiseError($errorInfo[0], null, null, $errorInfo[2], __FUNCTION__); return $result; } $result = false; } return $result; }