Exemplo n.º 1
0
function getBalanceForUser($link, $user_id, $givenuser)
{
    global $psqlschema, $serverid;
    $return = array();
    $balanacesjsondec = getAllBalances();
    $mybal = $balanacesjsondec[$givenuser];
    if ($mybal) {
        $return['bal'] = isset($mybal["balance"]) ? $mybal["balance"] : 0;
        $return['ec'] = isset($mybal["credit"]) ? $mybal["credit"] : 0;
        $return['everpaid'] = isset($mybal["everpaid"]) ? $mybal["everpaid"] : 0;
        $return['lbal'] = isset($mybal["included_balance_estimate"]) ? $return['bal'] - $mybal["included_balance_estimate"] : $return['bal'];
        $return['lec'] = isset($mybal["included_credit_estimate"]) ? $return['ec'] - $mybal["included_credit_estimate"] : $return['ec'];
        $return['datadate'] = $mybal["newest"];
        $return['balupdate'] = $mybal["last_balance_update"];
    } else {
        # fall back to sql
        $sql = "select * from {$psqlschema}.stats_balances where server={$serverid} and user_id={$user_id} order by time desc limit 1";
        $result = pg_exec($link, $sql);
        $numrows = pg_numrows($result);
        if (!$numrows) {
            $return['bal'] = "N/A";
            $return['ec'] = "N/A";
            $return['lbal'] = "N/A";
            $return['datadate'] = "N/A";
        } else {
            $row = pg_fetch_array($result, 0);
            $return['bal'] = $row["balance"];
            $return['ec'] = $row["credit"];
            $return['lbal'] = "N/A";
            $return['datadate'] = $row["time"];
            $return['everpaid'] = $row["everpaid"];
        }
    }
    return $return;
}
Exemplo n.º 2
0
 function open($database, $host, $user, $password)
 {
     $connect_string = "";
     if (!$database) {
         return 0;
     }
     $host = split(":", $host);
     if ($host[0]) {
         $connect_string .= "host={$host['0']}";
     }
     if (isset($host[1])) {
         $connect_string .= " port={$host['1']}";
     }
     if ($user) {
         $connect_string .= " user={$user} ";
     }
     if ($password) {
         $connect_string .= " password={$password} ";
     }
     $connect_string .= " dbname={$database}";
     $this->connect_id = @pg_Connect($connect_string);
     if ($this->connect_id) {
         @pg_exec($this->connect_id, "SET DateStyle TO 'ISO'");
     }
     return $this->connect_id;
 }
Exemplo n.º 3
0
function my_handler($sql_insert)
{
    global $table, $link, $new_name;
    $sql_insert = ereg_replace($table, $new_name, $sql_insert);
    $result = pg_exec($link, pre_query($sql_insert)) or pg_die(pg_errormessage($link), $sql_insert, __FILE__, __LINE__);
    $sql_query = $sql_insert;
}
Exemplo n.º 4
0
function db_query($req)
{
    // Fonction "surcouche" e mysql_query () qui ajoute la gestion d'erreur
    global $type;
    global $conn;
    switch ($type) {
        case "POSTGRESQL":
            if ($sth = pg_exec($conn, $req)) {
                return $sth;
            } else {
                echo pg_errormessage($conn);
                error_req($req);
            }
            break;
        case "MYSQL":
            if ($sth = mysql_query("{$req}")) {
                // la requete s'est bien passé
                // affichage de la requete si le verbose est activé
                return $sth;
            } else {
                // Erreur dans la requete, donc génération du mail.
                echo mysql_error();
                error_req($req);
            }
    }
}
 function Fetch()
 {
     $sql = "\n\t\tSELECT DISTINCT\n\t\t\tcommit_log.commit_date - SystemTimeAdjust()        AS commit_date_raw,\n\t\t\tcommit_log.id                                      AS commit_log_id,\n\t\t\tcommit_log.encoding_losses                         AS encoding_losses,\n\t\t\tcommit_log.message_id                              AS message_id,\n\t\t\tcommit_log.committer                               AS committer,\n\t\t\tcommit_log.description                             AS commit_description,\n\t\t\tto_char(commit_log.commit_date - SystemTimeAdjust(), 'DD Mon YYYY')  AS commit_date,\n\t\t\tto_char(commit_log.commit_date - SystemTimeAdjust(), 'HH24:MI')      AS commit_time,\n\t\t\tNULL                                               AS port_id,\n\t\t\tNULL                                               AS category,\n\t\t\tNULL                                               AS category_id,\n\t\t\tNULL                                               AS port,\n\t\t\telement_pathname(element.id)                       AS pathname,\n\t\t\tNULL AS version,\n\t\t\tcommit_log_elements.revision_name AS revision,\n\t\t\tNULL AS epoch,\n\t\t\telement.status                                     AS status,\n\t\t\tNULL AS needs_refresh,\n\t\t\tNULL                                               AS forbidden,\n\t\t\tNULL                                               AS broken,\n\t\t\tNULL                                               AS deprecated,\n\t\t\tNULL                                               AS ignore,\n\t\t\tNULL                                               AS expiration_date,\n\t\t\tNULL                                               AS date_added,\n\t\t\tNULL                                               AS element_id,\n\t\t\tNULL                                               AS short_description,\n\t\t\tNULL                                               AS stf_message";
     if ($this->UserID) {
         $sql .= ",\n\t        onwatchlist ";
     }
     $sql .= "\n    FROM commit_log, commit_log_elements, element ";
     if ($this->UserID) {
         $sql .= "\n\t      LEFT OUTER JOIN\n\t (SELECT element_id as wle_element_id, COUNT(watch_list_id) as onwatchlist\n\t    FROM watch_list JOIN watch_list_element \n\t        ON watch_list.id      = watch_list_element.watch_list_id\n\t       AND watch_list.user_id = " . $this->UserID . "\n\t       AND watch_list.in_service\t\t\n\t  GROUP BY wle_element_id) AS TEMP\n\t       ON TEMP.wle_element_id = element.id";
     }
     $sql .= "\n\t  WHERE commit_log.id IN (SELECT tmp.id FROM (SELECT DISTINCT CL.id, CL.commit_date\n  FROM commit_log CL\n WHERE CL.committer  = '" . pg_escape_string($this->Committer) . "'\nORDER BY CL.commit_date DESC ";
     if ($this->Limit) {
         $sql .= " LIMIT " . $this->Limit;
     }
     if ($this->Offset) {
         $sql .= " OFFSET " . $this->Offset;
     }
     $sql .= ")as tmp)\n\t    AND commit_log_elements.commit_log_id = commit_log.id\n\t    AND commit_log_elements.element_id    = element.id\n   ORDER BY 1 desc,\n\t\t\tcommit_log_id";
     if ($this->Debug) {
         echo '<pre>' . $sql . '</pre>';
     }
     $this->LocalResult = pg_exec($this->dbh, $sql);
     if ($this->LocalResult) {
         $numrows = pg_numrows($this->LocalResult);
         if ($this->Debug) {
             echo "That would give us {$numrows} rows";
         }
     } else {
         $numrows = -1;
         echo 'pg_exec failed: ' . "<pre>{$sql}</pre>";
     }
     return $numrows;
 }
 function CreateDatabase()
 {
     global $dcl_domain_info, $dcl_domain;
     $conn = @pg_connect(sprintf('dbname=template1 port=%s host=%s user=%s password=%s', $dcl_domain_info[$dcl_domain]['dbPort'], $dcl_domain_info[$dcl_domain]['dbHost'], $dcl_domain_info[$dcl_domain]['dbUser'], $dcl_domain_info[$dcl_domain]['dbPassword']));
     $query = sprintf('CREATE DATABASE %s', $dcl_domain_info[$dcl_domain]['dbName']);
     return pg_exec($conn, $query) > 0;
 }
 function CreateHTML()
 {
     global $freshports_CommitMsgMaxNumOfLinesToShow;
     if (isset($this->Filter)) {
         $sql = "select * from SanityTestFailures({$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
     } else {
         $sql = "set client_encoding = 'ISO-8859-15';\nSELECT S.*, STF.message as stf_message\n  FROM SanityTestFailures({$this->UserID}) S LEFT OUTER JOIN sanity_test_failures STF\n    ON S.commit_log_id = STF.commit_log_id";
     }
     if ($this->MessageID != '') {
         $sql .= " WHERE message_id = '" . pg_escape_string($this->MessageID) . "'";
     }
     $sql .= " ORDER BY S.commit_date_raw DESC, S.category, S.port";
     if ($this->Debug) {
         echo "\n<p>sql={$sql}</p>\n";
     }
     $result = pg_exec($this->dbh, $sql);
     if (!$result) {
         die("read from database failed");
         exit;
     }
     $DisplayCommit = new DisplayCommit($this->dbh, $result);
     $DisplayCommit->Debug = $this->Debug;
     $DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
     $DisplayCommit->SetUserID($this->UserID);
     $DisplayCommit->SetWatchListAsk($this->WatchListAsk);
     $DisplayCommit->SanityTestFailure = true;
     $RetVal = $DisplayCommit->CreateHTML();
     $this->HTML = $DisplayCommit->HTML;
     return $RetVal;
 }
function start_maint()
{
    custom_db("cubit");
    pg_exec("VACUUM");
    pg_exec("VACUUM FULL");
    pg_exec("VACUUM ANALYZE");
    pg_exec("REINDEX DATABASE cubit");
    $get_comps = "SELECT * FROM companies WHERE status = 'active'";
    $run_comps = pg_exec($get_comps) or errDie("Unable to get active companies");
    if (pg_numrows($run_comps) < 1) {
        return "<li class='err'>No Active Companies Found To Process.</li>";
    } else {
        #process the blk1 db
        custom_db("cubit_blk1");
        pg_exec("VACUUM");
        pg_exec("VACUUM FULL");
        pg_exec("VACUUM ANALYZE");
        pg_exec("REINDEX DATABASE cubit_blk1");
        #process the active companies
        while ($carr = pg_fetch_array($run_comps)) {
            $company = "cubit_" . $carr['code'];
            custom_db("{$company}");
            pg_exec("VACUUM");
            pg_exec("VACUUM FULL");
            pg_exec("VACUUM ANALYZE");
            pg_exec("REINDEX DATABASE {$company}");
        }
    }
    $display = "\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t<tr>\r\n\t\t\t\t<td><li class='err'>Process Has Been Completed.</li></td>\r\n\t\t\t</tr>\r\n\t\t</table>";
    return $display;
}
Exemplo n.º 9
0
 /**
  * @throws SQLException
  * @return void
  */
 protected function initTables()
 {
     include_once 'creole/drivers/pgsql/metadata/PgSQLTableInfo.php';
     // Get Database Version
     $result = pg_exec($this->dblink, "SELECT version() as ver");
     if (!$result) {
         throw new SQLException("Failed to select database version");
     }
     // if (!$result)
     $row = pg_fetch_assoc($result, 0);
     $arrVersion = sscanf($row['ver'], '%*s %d.%d');
     $version = sprintf("%d.%d", $arrVersion[0], $arrVersion[1]);
     // Clean up
     $arrVersion = null;
     $row = null;
     pg_free_result($result);
     $result = null;
     $result = pg_exec($this->dblink, "SELECT oid, relname FROM pg_class\n\t\t\t\t\t\t\t\t\t\tWHERE relkind = 'r' AND relnamespace = (SELECT oid\n\t\t\t\t\t\t\t\t\t\tFROM pg_namespace\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t     nspname NOT IN ('information_schema','pg_catalog')\n\t\t\t\t\t\t\t\t\t\t     AND nspname NOT LIKE 'pg_temp%'\n\t\t\t\t\t\t\t\t\t\t     AND nspname NOT LIKE 'pg_toast%'\n\t\t\t\t\t\t\t\t\t\tLIMIT 1)\n\t\t\t\t\t\t\t\t\t\tORDER BY relname");
     if (!$result) {
         throw new SQLException("Could not list tables", pg_last_error($this->dblink));
     }
     while ($row = pg_fetch_assoc($result)) {
         $this->tables[strtoupper($row['relname'])] = new PgSQLTableInfo($this, $row['relname'], $version, $row['oid']);
     }
 }
Exemplo n.º 10
0
 public function query($string = '')
 {
     if ($string != '') {
         $this->query = $this->escape($string);
     } else {
         $this->query = $this->select . $this->insert . $this->update . $this->delete . $this->create . $this->from . $this->join . $this->where . $this->group . $this->order . $this->limit;
     }
     $this->insert = " RETURNING id";
     $this->result = pg_exec($this->connection, $this->query);
     $this->inserted_id = $this->result;
     $this->error = pg_errormessage($this->connection);
     $this->affected_rows = pg_affected_rows($this->result);
     $this->select = '';
     $this->insert = '';
     $this->update = '';
     $this->delete = '';
     $this->create = '';
     $this->from = '';
     $this->join = '';
     $this->where = '';
     $this->group = '';
     $this->order = '';
     $this->limit = '';
     return $this;
 }
function write_details($_POST)
{
    extract($_POST);
    # validate input
    require_lib("validate");
    $v = new validate();
    $v->isOk($branch_ip, "url", 1, 50, "Invalid Branch IP.");
    $v->isOk($branch_company, "url", 4, 4, "Invalid Branch Company Code.");
    $v->isOk($branch_username, "string", 1, 50, "Invalid Branch Username.");
    //	$v->isOk ($branch_password, "url", 1, 50, "Invalid Branch Password.");
    //	$v->isOk ($branch_passwordconfirm, "url", 1, 50, "Invalid Branch Password.");
    //	$v->isOk ($branch_ip, "url", 1, 50, "Invalid Branch IP.");
    if ($branch_password != $branch_passwordconfirm) {
        $v->addError($branch_password, "Passwords do not match.");
    }
    # display errors, if any
    if ($v->isError()) {
        $confirmCust = "";
        $errors = $v->getErrors();
        foreach ($errors as $e) {
            $confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
        }
        return get_details($_POST, $confirmCust);
    }
    db_connect();
    $add_sql = "\n\t\tINSERT INTO branches_data (\n\t\t\tbranch_name, branch_desc, branch_contact, branch_ip, \n\t\t\tdate_added, last_online, branch_username, branch_password, \n\t\t\tlast_login_from, branch_localuser, branch_company\n\t\t) VALUES (\n\t\t\t'{$branch_name}', '{$branch_desc}', '{$branch_contact}', '{$branch_ip}', \n\t\t\t'now', '1990-01-01', '{$branch_username}', md5('{$branch_password}'), \n\t\t\t'1990-01-01', '{$branch_localuser}', '{$branch_company}'\n\t\t)";
    $run_add = pg_exec($add_sql) or errDie("Unable to add branch information.");
    $display = "\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Branch Added</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch Has Been Added.</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t";
    return $display;
}
 function Fetch()
 {
     $sql = "set client_encoding = 'ISO-8859-15';\n\t\tSELECT DISTINCT\n\t\t\tCL.commit_date - SystemTimeAdjust()                                            AS commit_date_raw,\n\t\t\tCL.id                                                                          AS commit_log_id,\n\t\t\tCL.encoding_losses                                                             AS encoding_losses,\n\t\t\tCL.message_id                                                                  AS message_id,\n\t\t\tCL.committer                                                                   AS committer,\n\t\t\tCL.description                                                                 AS commit_description,\n\t\t\tto_char(CL.commit_date - SystemTimeAdjust(), 'DD Mon YYYY')                    AS commit_date,\n\t\t\tto_char(CL.commit_date - SystemTimeAdjust(), 'HH24:MI')                        AS commit_time,\n\t\t\tCLP.port_id                                                                    AS port_id,\n\t\t\tC.name                                                                         AS category,\n\t\t\tC.id                                                                           AS category_id,\n\t\t\tE.name                                                                         AS port,\n\t\t\telement_pathname(E.id)                                                         AS pathname,\n\t\t\tCASE when CLP.port_version IS NULL then P.version   else CLP.port_version  END AS version,\n\t\t\tCASE when CLP.port_version is NULL then P.revision  else CLP.port_revision END AS revision,\n\t\t\tCASE when CLP.port_epoch   is NULL then P.portepoch else CLP.port_epoch    END AS epoch,\n\t\t\tE.status                                                                       AS status,\n\t\t\tCLP.needs_refresh                                                              AS needs_refresh,\n\t\t\tP.forbidden                                                                    AS forbidden,\n\t\t\tP.broken                                                                       AS broken,\n\t\t\tP.deprecated                                                                   AS deprecated,\n\t\t\tP.ignore                                                                       AS ignore,\n\t\t\tP.expiration_date                                                              AS expiration_date,\n\t\t\tdate_part('epoch', P.date_added)                                               AS date_added,\n\t\t\tP.element_id                                                                   AS element_id,\n\t\t\tP.short_description                                                            AS short_description,\n\t\t\tSTF.message                                                                    AS stf_message";
     if ($this->UserID) {
         $sql .= ",\n\t        onwatchlist ";
     }
     $sql .= "\n    FROM commit_log_ports CLP JOIN (SELECT * FROM commit_log WHERE commit_log.committer = '" . pg_escape_string($this->Committer) . "' ORDER BY commit_date DESC ";
     if ($this->Limit) {
         $sql .= " LIMIT " . $this->Limit;
     }
     if ($this->Offset) {
         $sql .= " OFFSET " . $this->Offset;
     }
     $sql .= ") CL on (CLP.commit_log_id = CL.id) \n          LEFT OUTER JOIN sanity_test_failures STF ON STF.commit_log_id = CLP.commit_log_id, categories C, ports P, element E ";
     if ($this->UserID) {
         $sql .= "\n\t      LEFT OUTER JOIN\n\t (SELECT element_id as wle_element_id, COUNT(watch_list_id) as onwatchlist\n\t    FROM watch_list JOIN watch_list_element \n\t        ON watch_list.id      = watch_list_element.watch_list_id\n\t       AND watch_list.user_id = " . $this->UserID . "\n\t       AND watch_list.in_service\t\t\n\t  GROUP BY wle_element_id) AS TEMP\n\t       ON TEMP.wle_element_id = E.id";
     }
     $sql .= "\n\t  WHERE CLP.port_id = P.id\n\t    AND C.id        = P.category_id\n\t    AND E.id        = P.element_id\n   ORDER BY 1 desc,\n\t\t\tcommit_log_id,\n\t\t\tcategory,\n\t\t\tport";
     if ($this->Debug) {
         echo '<pre>' . $sql . '</pre>';
     }
     $this->LocalResult = pg_exec($this->dbh, $sql);
     if ($this->LocalResult) {
         $numrows = pg_numrows($this->LocalResult);
         if ($this->Debug) {
             echo "That would give us {$numrows} rows";
         }
     } else {
         $numrows = -1;
         echo 'pg_exec failed: ' . "<pre>{$sql}</pre>";
     }
     return $numrows;
 }
Exemplo n.º 13
0
 function CreateHTML()
 {
     global $freshports_CommitMsgMaxNumOfLinesToShow;
     if (isset($this->Filter)) {
         $sql = "select * from LatestCommitsFiltered({$this->MaxNumberOfPorts}, {$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
     } else {
         #			$sql = "select * from LatestCommits($this->MaxNumberOfPorts, $this->UserID)";
         $sql = "\n  SELECT LC.*, STF.message AS stf_message\n    FROM LatestCommits({$this->MaxNumberOfPorts}, 0, '" . pg_escape_string($this->BranchName) . "') LC LEFT OUTER JOIN sanity_test_failures STF\n      ON LC.commit_log_id = STF.commit_log_id\nORDER BY LC.commit_date_raw DESC, LC.category, LC.port, element_pathname";
     }
     if ($this->Debug) {
         echo "\n<p>sql={$sql}</p>\n";
     }
     $result = pg_exec($this->dbh, $sql);
     if (!$result) {
         die("read from database failed");
         exit;
     }
     $DisplayCommit = new DisplayCommit($this->dbh, $result);
     $DisplayCommit->Debug = $this->Debug;
     $DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
     $DisplayCommit->SetUserID($this->UserID);
     $DisplayCommit->SetWatchListAsk($this->WatchListAsk);
     $RetVal = $DisplayCommit->CreateHTML();
     $this->HTML = $DisplayCommit->HTML;
     return $RetVal;
 }
Exemplo n.º 14
0
 public function excecute($sql)
 {
     if ($sql instanceof Query) {
         $sql = $sql->getQuery($this->config->getType());
     }
     $this->last_query = $sql;
     return pg_exec($this->connection, $sql);
 }
Exemplo n.º 15
0
function debitos_tipos_numcgm($numcgm)
{
    $instit = db_getsession("DB_instit");
    $sql = "select distinct t.k00_tipo,t.k00_descr,t.k00_marcado,b.k00_numcgm,t.k00_emrec,t.k00_agnum,t.k00_agpar\n          from arrenumcgm b\n                inner join arrecad a    on b.k00_numpre = a.k00_numpre\n                inner join arretipo t   on t.k00_tipo   = a.k00_tipo\n                inner join arreinstit n on n.k00_numpre = a.k00_numpre\n                  where b.k00_numcgm = {$numcgm} and n.k00_instit = {$instit}";
    // echo "<br> cgm = $sql <br> ";
    $result = pg_exec($sql) or die("Sql : " . pg_ErrorMessage());
    return pg_numrows($result) == 0 ? false : $result;
}
Exemplo n.º 16
0
 function pgquery($query)
 {
     $result = pg_exec($this->pgcon(), $query);
     if (!$result) {
         $this->mydie("Could not successfully run query ({$query}) from DB: " . pg_ErrorMessage());
     }
     return $result;
 }
Exemplo n.º 17
0
function set_privilege($sql_set_privilege)
{
    global $link;
    if (!($res = @pg_exec($link, $sql_set_privilege))) {
        pg_die(pg_errormessage($link), $sql_set_privilege, __FILE__, __LINE__);
    } else {
        echo "<p>{$sql_set_privilege}</p>\n";
    }
}
Exemplo n.º 18
0
function larutaes($cod)
{
    require "../conectar.php";
    $sqleve = "SELECT origen, destino FROM ruta WHERE cod_ruta = {$cod}";
    $stateve = pg_exec($dbh, $sqleve);
    $datoeve = pg_fetch_assoc($stateve);
    $tv = $datoeve[origen] . " - " . $datoeve[destino];
    return $tv;
}
 function query($query_strg)
 {
     $query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2, \\1", $query_strg);
     $this->result = pg_exec($this->conn_id, $query_strg);
     if (!$this->result) {
         $this->sql_error("Query Error");
     }
     return $this->result;
 }
Exemplo n.º 20
0
function elvehiculoes($num)
{
    require "../conectar.php";
    $sqleve = "SELECT tipo_vehiculo FROM tipo_vehiculo WHERE cod_tipo_vehiculo = {$num}";
    $stateve = pg_exec($dbh, $sqleve);
    $datoeve = pg_fetch_assoc($stateve);
    $tv = $datoeve[tipo_vehiculo];
    return $tv;
}
Exemplo n.º 21
0
 function Header()
 {
     global $conn;
     global $result;
     global $url;
     //Dados da instituição
     $dados = @pg_exec("select nomeinst,ender,munic,uf,telef,email,url,logo from db_config where codigo = " . @$GLOBALS["DB_instit"]);
     $url = @pg_result($dados, 0, "url");
     $this->SetXY(1, 1);
     $this->Image('../imagens/files/' . pg_result($dados, 0, "logo"), 7, 3, 20);
     //$this->Cell(100,32,"",1);
     $nome = pg_result($dados, 0, "nomeinst");
     global $nomeinst;
     $nomeinst = pg_result($dados, 0, "nomeinst");
     if (strlen($nome) > 42) {
         $TamFonteNome = 8;
     } else {
         $TamFonteNome = 9;
     }
     $this->SetFont('Arial', 'BI', $TamFonteNome);
     $this->Text(33, 9, $nome);
     $this->SetFont('Arial', 'I', 8);
     $this->Text(33, 14, trim(pg_result($dados, 0, "ender")));
     $this->Text(33, 18, trim(pg_result($dados, 0, "munic")) . " - " . pg_result($dados, 0, "uf"));
     $this->Text(33, 22, trim(pg_result($dados, 0, "telef")));
     $this->Text(33, 26, trim(pg_result($dados, 0, "email")));
     $this->Text(33, 30, $url);
     //parametros
     //	$this->SetXY(108,3);
     //	$this->SetFillColor(235);
     //	$this->Cell(98,29,"",1,0,0,1);
     //    $this->Line(178,3,178,32);
     //    $this->Line(178,13,206,13);
     //    $this->Line(178,22,206,22);
     //    $this->Text(180,10,date("d-m-Y"));
     //    $this->Text(180,20,date("H:i:s"));
     //    $this->Text(180,30,@$GLOBALS["DB_login"]);
     //    $this->SetFont('Arial','',6);
     //    $this->Text(179,5,"Data:");
     //    $this->Text(179,15,"Hora:");
     //    $this->Text(179,24,"Login:");
     $Espaco = $this->w - 70;
     $this->SetFont('Arial', '', 8);
     //	$this->Text(140,6,@$GLOBALS["head1"]);
     $this->Text($Espaco, 6, @$GLOBALS["head1"]);
     $this->Text($Espaco, 9, @$GLOBALS["head2"]);
     $this->Text($Espaco, 12, @$GLOBALS["head3"]);
     $this->Text($Espaco, 15, @$GLOBALS["head4"]);
     $this->Text($Espaco, 18, @$GLOBALS["head5"]);
     $this->Text($Espaco, 21, @$GLOBALS["head6"]);
     $this->Text($Espaco, 24, @$GLOBALS["head7"]);
     $this->Text($Espaco, 27, @$GLOBALS["head8"]);
     $this->Text($Espaco, 30, @$GLOBALS["head9"]);
     //$this->Ln(25);
     $this->SetY(35);
 }
Exemplo n.º 22
0
function elclientees($rut)
{
    require "../conectar.php";
    $sqleve = "SELECT nombre_cliente FROM cliente WHERE rut_cliente = '{$rut}'";
    $stateve = pg_exec($dbh, $sqleve);
    pg_close($dbh);
    $datoeve = pg_fetch_assoc($stateve);
    $tv = $datoeve[nombre_cliente];
    return $tv;
}
Exemplo n.º 23
0
function elresponsablees($cod)
{
    require "../conectar.php";
    $sqleve = "SELECT nombres, apellido1, apellido2 FROM personal WHERE rut_personal = '{$cod}'";
    $stateve = pg_exec($dbh, $sqleve);
    $datoeve = pg_fetch_assoc($stateve);
    pg_close($dbh);
    $tv = $datoeve[nombres] . " " . $datoeve[apellido1] . " " . $datoeve[apellido2];
    return $tv;
}
Exemplo n.º 24
0
function deleteJob($jobNo)
{
    $dir = "/var/www/townguide/www/output/" . $jobNo;
    echo "<p>deleteJob({$jobNo}) - directory {$dir}</p>";
    $dbconn = pg_connect("host=localhost dbname=townguide user=www password=1234") or die('Could not connect: ' . pg_last_error());
    $query = 'delete FROM queue where jobno=' . $jobNo;
    $result = pg_exec($query) or die('Query failed: ' . pg_last_error());
    deleteDirectory($dir);
    echo "<p><a href='admin.php'>Return to Admin Page</a></p>\n";
}
Exemplo n.º 25
0
 public function execSimpleQuery($sql)
 {
     $this->connect();
     if ($this->connection != null) {
         $result = pg_exec($this->connection, $sql);
         $this->disconnect();
         return $result;
     } else {
         die("not connected to database!");
     }
 }
 function pgexec($sql)
 {
     if ($res = pg_exec($this->conn, $sql)) {
         pg_close($this->conn);
         return $res;
     } else {
         //echo "No es posible ejecutar esta consulta: <br>";
         //echo "$sql";
         return false;
     }
 }
Exemplo n.º 27
0
 function FetchByMaster($MasterName)
 {
     $sql = "\nSELECT id          AS slave_port_id,\n       name        AS slave_port_name,\n       category_id AS slave_category_id,\n       category    AS slave_category_name\n  FROM ports_active\n WHERE master_port = '" . pg_escape_string($MasterName) . "'\nORDER BY slave_category_name, slave_port_name";
     #echo "sql = <pre>$sql</pre>";
     $this->LocalResult = pg_exec($this->dbh, $sql);
     if (!$this->LocalResult) {
         echo pg_errormessage() . " {$sql}";
     }
     $numrows = pg_numrows($this->LocalResult);
     return $numrows;
 }
 /**
  * @throws SQLException
  * @return void
  */
 protected function initTables()
 {
     include_once 'creole/drivers/pgsql/metadata/PgSQLTableInfo.php';
     $result = pg_exec($this->dblink, "SELECT tablename FROM pg_tables WHERE schemaname NOT IN ('information_schema','pg_catalog') ORDER BY 1");
     if (!$result) {
         throw new SQLException("Could not list tables", pg_last_error($this->dblink));
     }
     while ($row = pg_fetch_row($result)) {
         $this->tables[strtoupper($row[0])] = new PgSQLTableInfo($this, $row[0]);
     }
 }
 function Insert()
 {
     # delete the ignore entry for this commit/port combination
     $sql = "\nINSERT INTO commit_log_ports_ignore (commit_log_id, port_id, reason)\n   values ({$this->commit_log_id}, {$this->port_id}, '" . pg_escape_string($this->reason) . "')";
     echo "\$sql='<pre>{$sql}</pre><br>\n";
     $this->result = pg_exec($this->dbh, $sql);
     if (!$this->result) {
         echo pg_errormessage() . " {$sql}";
     }
     $numrows = pg_affected_rows($this->result);
     return $numrows;
 }
Exemplo n.º 30
0
 function pg_insert_id($tablename, $fieldname)
 {
     $result = pg_exec($this->_connectionID, "SELECT last_value FROM {$tablename}_{$fieldname}_seq");
     if ($result) {
         $arr = @pg_fetch_row($result, 0);
         pg_freeresult($result);
         if (isset($arr[0])) {
             return $arr[0];
         }
     }
     return false;
 }