PHP testremote Examples

Example #1

File: end.php Project: blynch-newpi/IS4C

function cleartemptrans()
{
    $db = tDataConnect();
    if ($_SESSION["msg"] == 2) {
        $_SESSION["msg"] = 99;
        sql_query("update localtemptrans set trans_status = 'X'", $db);
    }
    if ($_SESSION["DBMS"] == "mssql") {
        sql_query("exec clearTempTables", $db);
    } else {
        moveTempData();
        truncateTempTables();
    }
    sql_close($db);
    testremote();
    loadglobalvalues();
    $_SESSION["transno"] = $_SESSION["transno"] + 1;
    setglobalvalue("TransNo", $_SESSION["transno"]);
    if ($_SESSION["TaxExempt"] != 0) {
        $_SESSION["TaxExempt"] = 0;
        setglobalvalue("TaxExempt", 0);
    }
    memberReset();
    transReset();
    printReset();
    getsubtotals();
    delete_file(remote_oux());
    delete_file(local_inx());
    return 1;
}

Example #2

File: special.php Project: jdpurdyvi/IS4C

function checksuspended()
{
    testremote();
    $db_a = tDataConnect();
    $m_conn = mDataConnect();
    $query_local = "select * from suspendedtoday";
    $query_remote = "select * from " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.suspendedtoday";
    $query = "select * from suspendedlist";
    if ($_SESSION["standalone"] == 1) {
        if ($_SESSION["remoteDBMS"] == "mssql") {
            $result = mssql_query($query_local, $db_a);
        } else {
            $result = mysql_query($query, $db_a);
        }
    } else {
        if ($_SESSION["remoteDBMS"] == "mssql") {
            $result = sql_query($query_remote, $db_a);
        } else {
            $result = mysql_query($query, $m_conn);
        }
    }
    $num_rows = sql_fetch_array($result);
    if ($num_rows == 0) {
        return 0;
    } else {
        return 1;
    }
    sql_close($db_a);
}

Example #3

File: special.php Project: WedgeCoop/IS4C

function checksuspended()
{
    testremote();
    $db_a = tDataConnect();
    $m_conn = mDataConnect();
    $query_local = "select * from suspendedtoday";
    $query_remote = "select * from suspendedtoday";
    $query = "select * from suspendedlist";
    if ($_SESSION["standalone"] == 1) {
        if ($_SESSION["remoteDBMS"] == "mssql") {
            $result = mssql_query($query_local, $db_a);
        } else {
            $result = mysql_query($query, $db_a);
        }
    } else {
        if ($_SESSION["remoteDBMS"] == "mssql") {
            $result = sql_query($query_remote, $db_a);
        } else {
            $result = mysql_query($query_remote, $m_conn);
        }
    }
    # That's just not right, fix it later?
    #    $num_rows = sql_fetch_array($result);
    $num_rows = mysql_num_rows($result);
    if ($num_rows == 0) {
        return 0;
    } else {
        return 1;
    }
    sql_close($db_a);
}

Example #4

File: authenticate.php Project: WedgeCoop/IS4C

        setglobalvalue("LoggedIn", 1);
        loadglobalvalues();
        $_SESSION["training"] = 1;
        loginscreen();
    } else {
        $_SESSION["auth_fail"] = 1;
        header("Location:/login.php");
    }
} else {
    if (get_user_info(user_pass($password)) == $global_values["CashierNo"]) {
        loadglobalvalues();
        testremote();
        loginscreen();
    } else {
        if (user_pass_priv($password)) {
            loadglobalvalues();
            testremote();
            loginscreen();
        } else {
            $_SESSION["auth_fail"] = 1;
            header("Location:/login.php");
        }
        sql_close($db_a);
    }
}
getsubtotals();
$_SESSION["datetimestamp"] = strftime("%Y-%m-%m/%d/%y %T", time());
if ($_SESSION["LastID"] != 0 && $_SESSION["memberID"] != "0" and $_SESSION["memberID"]) {
    $_SESSION["unlock"] = 1;
    memberID($_SESSION["memberID"]);
}