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; }
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); }
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); }
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"]); }