Example #1
0
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;
    }
}
Example #2
0
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;
    }
}
Example #3
0
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;
 }