/**
* 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='******' WHERE 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();
