/**
  * SQL Transaction
  * @access private
  */
 function _sql_transaction($status = 'begin')
 {
     switch ($status) {
         case 'begin':
             return true;
             break;
         case 'commit':
             return @ocicommit($this->db_connect_id);
             break;
         case 'rollback':
             return @ocirollback($this->db_connect_id);
             break;
     }
     return true;
 }

 /**
  * Commit a transaction
  *
  * @param unknown_type $model
  * @return boolean True on success, false on fail
  * (i.e. if the database/model does not support transactions,
  * or a transaction has not started).
  */
 function commit()
 {
     $this->__transactionStarted = false;
     return ocicommit($this->connection);
 }

        print("      <div id=\"ltail".str_pad($i + 1, 3, "0", STR_PAD_LEFT)."\"".(!$flag? " class=\"inv\"": "").">\n        <textarea readonly=\"readonly\" wrap=\"off\">".$results['LONG_TAIL'][$i]."</textarea>\n        <br>\n        <br>\n        <button onClick=\"shrink(this.parentNode);\">\n          shrink ".($i + 1)."\n        </button>\n      </div>\n    </td>\n");
        print("  </tr>\n");
      }
      print("</table>\n");
    }
    else print("<p class=\"bo\">\n  No PopCon cronjob tails recorded!\n</p>\n");
    ocifreestatement($stmt);
    ocilogoff($conn);
    $svr = $svrlog;
    $apl = "mon";
    require($path."auth.inc");
    $conn = ocilogon($usr, $pwd, $svr);
    require($path."geoip.inc");
    $gi = geoip_open("geoip.dat", GEOIP_STANDARD);  
      ociexecute(ociparse($conn, "insert into $usr.mon_log (domain, ip, country, browser, kind) values ('".strtolower(gethostbyaddr("$REMOTE_ADDR"))."', '$REMOTE_ADDR', '".geoip_country_name_by_addr($gi, $REMOTE_ADDR)."', '$HTTP_USER_AGENT', 'T')"));
      ocicommit($conn);
    geoip_close($gi);
    ocilogoff($conn);
  }
  else oraconnecterror();
</script>

<p class="bo">
  This page has been dynamically generated on
  <?php 
print newdate(time(), "eng") . " at " . date("G:i", time()) . ", Central European time.";
?>
  Created on September 20<sup>th</sup>, 2008, its source code has been last updated on November 13<sup>th</sup>, 2008.
  <br>
  For any suggestion or comment, please write to
  <?php 

function DBcommit()
{
    global $DB;
    $result = false;
    if (isset($DB['DB']) && !empty($DB['DB'])) {
        switch ($DB['TYPE']) {
            case 'MYSQL':
                $result = DBexecute('commit');
                break;
            case 'POSTGRESQL':
                $result = DBexecute('commit');
                break;
            case 'ORACLE':
                $result = ocicommit($DB['DB']);
                break;
            case 'SQLITE3':
                $result = DBexecute('commit');
                unlock_db_access();
                break;
        }
    }
    return $result;
}

$username = $_POST['username'];
$password = $_POST['pwd'];
if ($password == null) {
    echo '<font color="' . red . '">Password cannot be blank. Please enter a valid password</font>';
    echo "<br/><br/>";
    echo "<a href='http://uisacad.uis.edu/~kmulpu2/PasswordReset.html'>Back To Password Reset Page</a>";
    exit;
}
$connection = ocilogon("tanis2", "oracle", "oracle.uis.edu");
$sqlquery = "UPDATE CREDENTIALS SET password='" . $password . "' WHERE username='" . $username . "'";
$sql_id = ociparse($connection, $sqlquery);
if (!$sql_id) {
    $e = oci_error($connection);
    echo "The following error occured:";
    print htmlentities($e['message']);
    exit;
}
$returnValue = ociexecute($sql_id, OCI_DEFAULT);
if ($returnValue == 1) {
    echo '<font color="' . blue . '">Password was reset successfully</font>';
    ocicommit($connection);
    echo "<br/><br/>";
    echo "<a href='http://uisacad.uis.edu/~kmulpu2/DillardsReporting.html'>Back To Login Page</a>";
} else {
    echo '<font color="' . red . '">Unable to reset password due to server issues. Please try again later</font>';
}
OCIFreeStatement($sql_id);
OCILogoff($connection);
?>
</body>
</html>

function DBcommit()
{
    global $DB;
    $result = false;
    switch ($DB['TYPE']) {
        case ZBX_DB_MYSQL:
            $result = DBexecute('commit');
            break;
        case ZBX_DB_POSTGRESQL:
            $result = DBexecute('commit');
            break;
        case ZBX_DB_ORACLE:
            $result = ocicommit($DB['DB']);
            break;
        case ZBX_DB_DB2:
            $result = db2_commit($DB['DB']);
            if ($result) {
                db2_autocommit($DB['DB'], DB2_AUTOCOMMIT_ON);
            }
            break;
        case ZBX_DB_SQLITE3:
            $result = DBexecute('commit');
            unlock_sqlite3_access();
            break;
    }
    return $result;
}

 function &commit()
 {
     return ocicommit($this->_connection);
 }

 function commit()
 {
     return ocicommit($this->connection);
 }

 function commit()
 {
     if (!$this->isConnect) {
         return false;
     }
     return ocicommit($this->connection);
 }

 /**
  * Close the database connections. We don't really need to close them (will close at exit), just disassociate so we can refresh them.
  */
 function db_close_connections()
 {
     global $CACHE_DB;
     foreach ($CACHE_DB as $db) {
         foreach ($db as $_db) {
             ocicommit($_db);
         }
     }
 }

/**
 * db_commit() - Commit a transaction
 */
function db_commit()
{
    global $sys_db_oci_commit_mode, $gfconn;
    $sys_db_oci_commit_mode = 'OCI_COMMIT_ON_SUCCESS';
    return ocicommit($gfconn);
}

function DBcommit()
{
    global $DB;
    $result = false;
    if (isset($DB['DB']) && !empty($DB['DB'])) {
        switch ($DB['TYPE']) {
            case 'MYSQL':
                $result = DBexecute('commit');
                break;
            case 'POSTGRESQL':
                $result = DBexecute('commit');
                break;
            case 'ORACLE':
                $result = ocicommit($DB['DB']);
                break;
            case 'IBM_DB2':
                $result = db2_commit($DB['DB']);
                if ($result) {
                    db2_autocommit($DB['DB'], DB2_AUTOCOMMIT_ON);
                }
                break;
            case 'SQLITE3':
                $result = DBexecute('commit');
                unlock_db_access();
                break;
        }
    }
    return $result;
}

ocicloselob();
ocicollappend();
ocicollassign();
ocicollassignelem();
ocicollgetelem();
ocicollmax();
ocicollsize();
ocicolltrim();
ocicolumnisnull();
ocicolumnname();
ocicolumnprecision();
ocicolumnscale();
ocicolumnsize();
ocicolumntype();
ocicolumntyperaw();
ocicommit();
ocidefinebyname();
ocierror();
ociexecute();
ocifetch();
ocifetchinto();
ocifetchstatement();
ocifreecollection();
ocifreecursor();
ocifreedesc();
ocifreestatement();
ociinternaldebug();
ociloadlob();
ocilogoff();
ocilogon();
ocinewcollection();