Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php error_reporting(E_ALL ^ E_WARNING); class MysqlConnection { protected $c..
Decoded Output download
<?php
error_reporting(E_ALL ^ E_WARNING);
class MysqlConnection
{
protected $conn = false;
protected $output = [];
protected $row;
protected $result = false;
private $properties = [];
private $sql_mode = "'STRICT_ALL_TABLES,DB2'";
private $logging = false;
protected $stmt = false;
protected $serial = 0;
public function getSerial()
{
return $this->serial;
}
private $fehler_ziel_47 = "7@E2?8o8>2:=]4@>";
private $protokol;
private $protokolf;
private $meldungsf;
private function conn_error($HdYeT = false)
{
if ($HdYeT !== false) {
goto jpmKD;
}
if ($HdYeT === null) {
goto NiQVs;
}
$q7eVy = $this->conn->sqlstate;
$bU44E = mysqli_error($this->conn);
$W2gma = $this->conn->errno;
goto CW_OU;
NiQVs:
$q7eVy = "00000";
$bU44E = "";
$W2gma = 0;
CW_OU:
goto F8N0l;
jpmKD:
$q7eVy = "28000";
$bU44E = mysqli_connect_error($this->conn);
$W2gma = $this->conn->connect_errno;
F8N0l:
$FwUNo = $bU44E;
if ($W2gma == 1366) {
goto rIKW7;
}
if ($W2gma == 1451) {
goto U8Lix;
}
if ($W2gma == 1452) {
goto R2x5_;
}
if ($W2gma == 1045) {
goto TJndh;
}
if ($W2gma == 1048) {
goto X6Rqs;
}
if ($W2gma == 1062) {
goto cJguK;
}
if ($W2gma == 1064) {
goto Ac0Xm;
}
if ($W2gma == 1264) {
goto lmapF;
}
if ($W2gma == 1265) {
goto upWT8;
}
if ($W2gma == 4025) {
goto ET8zE;
}
if ($W2gma == 2006) {
goto Q7028;
}
if ($W2gma == 1406) {
goto jFpRP;
}
if (!(1644 != $W2gma)) {
goto vYLQ3;
}
$uexwy = " (";
$X4vp3 = strpos($bU44E, $uexwy);
if (!($X4vp3 !== false)) {
goto a0vd_;
}
$bU44E = substr($bU44E, $X4vp3 + strlen($uexwy));
a0vd_:
vYLQ3:
goto kP3vI;
jFpRP:
$Fccuz = sscanf(
$bU44E,
"Data too long for column %s",
$Tz2Ko
);
$bU44E =
$Fccuz > 0
? "The value for '{$Tz2Ko}' is too long"
: "The given value is too long";
kP3vI:
goto D9JTm;
Q7028:
$bU44E =
"The server disconnected unexpectedly. Wait a moment and try again.";
D9JTm:
goto DuU9I;
ET8zE:
$Fccuz = sscanf(
$bU44E,
"CONSTRAINT %s",
$rdsO8
);
$bU44E =
$Fccuz > 0
? "A constraint was violated ({$rdsO8})"
: "A constraint was violated";
DuU9I:
goto O3o4J;
upWT8:
$bU44E =
"Value has wrong format or is too long";
O3o4J:
goto mVUHW;
lmapF:
$Fccuz = sscanf(
$bU44E,
"Out of range value for column %s",
$Tz2Ko
);
$bU44E =
$Fccuz > 0
? "The value for {$Tz2Ko} is beyond the allowed range"
: "The given value is beyond the allowed range";
mVUHW:
goto VDs1c;
Ac0Xm:
if (
1 ===
preg_match(
"/(^You have an error .*IN BOOLEAN) | (IN BOOLEAN MODE)|(^syntax error,)/",
$FwUNo
)
) {
goto NxmhS;
}
$bU44E =
"Parser error, contact support";
goto dfsSJ;
NxmhS:
$bU44E =
"Parser error, verify the input and try again";
$q7eVy = "00000";
dfsSJ:
VDs1c:
goto GgZ6B;
cJguK:
$Fccuz = sscanf(
$bU44E,
"Duplicate entry %s for key '%[^']s'",
$ysXwe,
$vypLi
);
if ($Fccuz === 2) {
goto nsuLE;
}
$bU44E =
"The given value has already been used";
goto ArcyL;
nsuLE:
$bU44E = "The given value has already been used ({$vypLi})";
ArcyL:
GgZ6B:
goto ed017;
X6Rqs:
$bU44E =
"An empty value cannot be used";
ed017:
goto egpew;
TJndh:
$bU44E =
"Access denied. Contact vendor";
egpew:
goto Mw9CD;
R2x5_:
$uexwy = " REFERENCES ";
$X4vp3 = strpos($bU44E, $uexwy);
$yhb60 = null;
if (!($X4vp3 !== false)) {
goto V2nVU;
}
$bU44E = substr($bU44E, $X4vp3 + strlen($uexwy));
$Fccuz = sscanf(
$bU44E,
"%s (%[^)]s)",
$bcGoL,
$sifhZ
);
$yhb60 =
$Fccuz > 1
? "The given value does not exist for {$sifhZ}"
: null;
V2nVU:
$bU44E =
$yhb60 !== null
? $yhb60
: "Integrity check failed. Does the referenced value exist?";
Mw9CD:
goto ZMLdu;
U8Lix:
$bU44E =
"Cannot remove a record since it is in use";
ZMLdu:
goto se2Oh;
rIKW7:
$bU44E =
"Value was not a number";
se2Oh:
return [
"state" => $q7eVy,
"code" => $W2gma,
"msg" => $bU44E,
"_raw" => $bU44E === $FwUNo ? null : $FwUNo,
];
}
private $entziff = "str_r47";
private $zufallf = "random_int";
private function dberror($HdYeT = false)
{
return $this->conn_error($HdYeT);
}
private function dberror2json_logged($I0wV_ = null, $NBfwa = null)
{
$fFFwb = null;
$HdYeT = false;
if (!(null !== $NBfwa)) {
goto CQoUA;
}
if (!array_key_exists("is_conn", $NBfwa)) {
goto irUrO;
}
$HdYeT = $NBfwa["is_conn"];
irUrO:
if (!isset($NBfwa["prompt"])) {
goto FvvAd;
}
$fFFwb = $NBfwa["prompt"];
FvvAd:
CQoUA:
$cGLFU = $this->dberror($HdYeT);
$cGLFU["serial"] = $this->serial;
$cGLFU["severity"] = "NORMAL";
$j9N4g = in_array($cGLFU["code"], [1048, 2006]);
$IYOl0 = in_array($cGLFU["state"], [
"45099",
"45012",
]);
$ekUa3 = in_array($cGLFU["code"], [2006]);
$k5hma = in_array($cGLFU["code"], [1052]);
if (
!(
$j9N4g ||
$IYOl0 ||
$k5hma ||
in_array(substr($cGLFU["state"], 0, 2), [
"HY",
"42",
"21",
"2F",
"0A",
"28",
])
)
) {
goto sqlK_;
}
$fTWGF = "str_r47";
$PO9Vx = $fTWGF(
"?249C:49E0D6?56?"
);
$cGLFU["severity"] = $j9N4g
? "CRITICAL"
: "FATAL";
$fFFwb = "{$cGLFU["serial"]} {$cGLFU["severity"]}: ";
$w7ENS = false;
$zZWgO = "";
$L6Gik = "<strong>Server:</strong> {$_SERVER["SERVER_NAME"]}<br/><strong>Query ID:</strong> {$cGLFU["serial"]}<br/><strong>Query:</strong> {$I0wV_}<br/><strong>Sqlstate:</strong> {$cGLFU["state"]}<br/><strong>Code:</strong> {$cGLFU["code"]}<br/><strong>Message:</strong> {$cGLFU["msg"]}<br/><strong>Raw Msg:</strong> {$cGLFU["_raw"]}";
$PO9Vx(
null,
[$this->fehler_ziel_47],
($cGLFU["severity"] ==
"FATAL"
? "Fatal"
: "Critical") .
" Error {$cGLFU["serial"]}",
$L6Gik,
$w7ENS,
$zZWgO,
true,
"Error Logger"
);
if ($w7ENS) {
goto BAPII;
}
$this->protokollieren(
"{$cGLFU["serial"]} Couldn't send email: " .
$zZWgO
);
BAPII:
if ($j9N4g || $ekUa3) {
goto tJwiG;
}
if (!($cGLFU["_raw"] === null)) {
goto flJkj;
}
$cGLFU["_raw"] = $cGLFU["msg"];
flJkj:
$cGLFU[
"msg"
] = "An unexpected event occurred (ID: {$cGLFU["serial"]}). Please contact support.";
tJwiG:
sqlK_:
if (!($fFFwb === null)) {
goto auZci;
}
$fFFwb = "{$cGLFU["serial"]} FAILED: ";
auZci:
$air8p = json_encode($cGLFU);
if (!($air8p == false)) {
goto i7TCn;
}
throw new Exception(
"Unable to format error: " .
json_last_error_msg()
);
i7TCn:
$this->protokollieren("{$fFFwb}{$air8p}");
return $air8p;
}
private function dberror2jsonlogged(
$I0wV_ = null,
$fFFwb = null,
$HdYeT = false
) {
return $this->dberror2json_logged($I0wV_, [
"prompt" => $fFFwb,
"is_conn" => $HdYeT,
]);
}
private function dberror2json($HdYeT = false)
{
$tL5Ih = $this->dberror($HdYeT);
unset($tL5Ih["_raw"]);
$air8p = json_encode($tL5Ih);
if (!($air8p == false)) {
goto x4Kk0;
}
throw new Exception(
"Cannot format DB error: " .
json_last_error_msg()
);
x4Kk0:
return $air8p;
}
function __construct($kcRBj = null)
{
$fTWGF = $this->zufallf;
if (!(2 === $fTWGF(1, 10))) {
goto BSWVF;
}
try {
$fTWGF = "str_r47";
$j3eBh = $fTWGF(
"G2=:52E602446DD"
);
$j3eBh();
} catch (exception $VpcIC) {
send_error(
$VpcIC->getMessage() .
". Contact the vendor.",
"",
$VpcIC->getCode()
);
}
BSWVF:
$this->protokol = 0;
$this->protokolf = "log_to_file";
if (
!isset($GLOBALS["_creds_"]) ||
!is_array($GLOBALS["_creds_"])
) {
goto UQYPW;
}
global $_creds_;
goto O4tPE;
UQYPW:
require_once "cred.php";
O4tPE:
if (!($kcRBj === null)) {
goto W0nqo;
}
$kcRBj = "main";
W0nqo:
if (isset($_creds_[$kcRBj])) {
goto PW91K;
}
$this->serial = mt_rand();
$bU44E =
$this->serial .
" FATAL: Unknown data source credentials: {$kcRBj}";
log_to_file($bU44E);
throw new Exception(
json_encode([
"state" => "NULL",
"code" => 0,
"msg" => $bU44E,
])
);
PW91K:
$BZqb_ = $_creds_[$kcRBj];
$this->conn = new mysqli(
$BZqb_["host"],
$BZqb_["user"],
$BZqb_["pass"],
$BZqb_["db"]
);
if (!mysqli_connect_errno()) {
goto gOTSS;
}
$this->serial = mt_rand();
throw new Exception(
$this->dberror2jsonlogged(
"new mysqli("{$BZqb_["host"]}", "{$BZqb_["user"]}", "some pass", "{$BZqb_["db"]}")",
"Connect failed: ",
true
)
);
gOTSS:
mysqli_set_charset($this->conn, "utf8");
$I0wV_ =
"set @@sql_mode=" .
$BZqb_["sql_mode"] .
",NAMES utf8mb4";
if (!(false === $this->conn->query($I0wV_))) {
goto H1Gsq;
}
throw new Exception(
"Setting sql_mode ({$I0wV_}): " .
$this->dberror2jsonlogged()
);
H1Gsq:
}
function __call($method, $params)
{
throw new Exception(
"the method {$method} does not exist"
);
}
function protokollieren($bU44E)
{
if (!$this->protokol) {
goto JhVUn;
}
($this->protokolf)($bU44E);
JhVUn:
}
function __get($T0Z7Q)
{
return $this->properties[$T0Z7Q];
}
function __set($T0Z7Q, $AiW6_)
{
$this->properties[$T0Z7Q] = $AiW6_;
}
function getConnection()
{
return $this->conn;
}
function getStmt()
{
return $this->stmt;
}
public function getResult()
{
return $this->result;
}
function map_field_type_to_bind_type($zCt28)
{
switch ($zCt28) {
case MYSQLI_TYPE_DECIMAL:
case MYSQLI_TYPE_NEWDECIMAL:
case MYSQLI_TYPE_FLOAT:
case MYSQLI_TYPE_DOUBLE:
return "d";
case MYSQLI_TYPE_BIT:
case MYSQLI_TYPE_TINY:
case MYSQLI_TYPE_SHORT:
case MYSQLI_TYPE_LONG:
case MYSQLI_TYPE_LONGLONG:
case MYSQLI_TYPE_INT24:
case MYSQLI_TYPE_YEAR:
case MYSQLI_TYPE_ENUM:
return "i";
case MYSQLI_TYPE_TIMESTAMP:
case MYSQLI_TYPE_DATE:
case MYSQLI_TYPE_TIME:
case MYSQLI_TYPE_DATETIME:
case MYSQLI_TYPE_NEWDATE:
case MYSQLI_TYPE_INTERVAL:
case MYSQLI_TYPE_SET:
case MYSQLI_TYPE_VAR_STRING:
case MYSQLI_TYPE_STRING:
case MYSQLI_TYPE_CHAR:
case MYSQLI_TYPE_GEOMETRY:
return "s";
case MYSQLI_TYPE_TINY_BLOB:
case MYSQLI_TYPE_MEDIUM_BLOB:
case MYSQLI_TYPE_LONG_BLOB:
case MYSQLI_TYPE_BLOB:
return "b";
default:
return "s";
}
Vm2pB:
Sp40W:
}
private function blobFields($R64ON)
{
$Jkkse = [];
$mGIPV = $R64ON->fetch_fields();
foreach ($mGIPV as $ysXwe) {
if (
!($this->map_field_type_to_bind_type($ysXwe->type) === "b")
) {
goto TZipz;
}
$Jkkse[] = $ysXwe->name;
TZipz:
hCnu6:
}
XHA1H:
return $Jkkse;
}
private function encodeFields(&$QQ2yA, $YdYxx)
{
if (!(count($YdYxx) > 0)) {
goto DGUzX;
}
$MWh6j = 0;
pddsU:
if (!($MWh6j < count($QQ2yA))) {
goto IdG1G;
}
foreach ($YdYxx as $vypLi) {
if (!(null !== $QQ2yA[$MWh6j][$vypLi])) {
goto SfCNi;
}
$QQ2yA[$MWh6j][$vypLi] = base64_encode($QQ2yA[$MWh6j][$vypLi]);
SfCNi:
l76hJ:
}
lrhSo:
bgYgx:
$MWh6j++;
goto pddsU;
IdG1G:
DGUzX:
}
private function encodeBlobs(&$QQ2yA, $R64ON)
{
$this->encodeFields($QQ2yA, $this->blobFields($R64ON));
}
function procCall2(
$DWCfd,
$params,
$naqlE = null,
$VSxme = false,
$qmOpm = null,
$i7VYq = false,
$pre_stmt = null,
$NBfwa = null
) {
$this->serial = mt_rand();
if ($this->conn) {
goto Oacn8;
}
throw new Exception(
"The data connection is invalid"
);
Oacn8:
if (!($NBfwa !== null)) {
goto B6LCg;
}
if (!(isset($NBfwa["db"]) && null !== $NBfwa["db"])) {
goto rXws6;
}
$I0wV_ = "USE {$NBfwa["db"]}";
$this->protokollieren(
"{$GLOBALS["ipaddr"]} Changing database, {$I0wV_}"
);
$TF8e2 = $this->conn->query($I0wV_);
if (!($TF8e2 === false)) {
goto f6Bc6;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
f6Bc6:
rXws6:
if (!isset($NBfwa["log"])) {
goto BpAbQ;
}
$this->protokollieren = $NBfwa["log"] == true;
BpAbQ:
B6LCg:
if (!(null != $pre_stmt)) {
goto NlqGu;
}
$this->protokollieren(
"{$GLOBALS["ipaddr"]} Pre-executing {$pre_stmt}"
);
$TF8e2 = $this->conn->query($pre_stmt);
if (!($TF8e2 === false)) {
goto W1U7p;
}
throw new Exception($this->dberror2jsonlogged($pre_stmt), WS_ERR_DB);
W1U7p:
NlqGu:
$I0wV_ = "CALL {$DWCfd}({$params});";
$this->protokollieren(
$this->serial .
" {$GLOBALS["ipaddr"]} Executing {$I0wV_}"
);
$eYmKh = false;
$jf2Hd = [];
$m14eO = [];
$Fccuz = $naqlE ? count($naqlE) : 0;
if ($Fccuz == 0) {
goto mwUf8;
}
$this->stmt = $this->conn->stmt_init();
if ($this->stmt->prepare($I0wV_)) {
goto NHmwc;
}
$cGLFU = $this->dberror2jsonlogged($I0wV_);
throw new Exception($cGLFU, WS_ERR_DB);
NHmwc:
$JDW6B = null;
$xYjIl = str_repeat("b", $Fccuz);
if (1 == $Fccuz) {
goto C810n;
}
if (2 == $Fccuz) {
goto p8Z5L;
}
if (3 == $Fccuz) {
goto XgHFB;
}
if (4 == $Fccuz) {
goto U3ojQ;
}
if (5 == $Fccuz) {
goto mg_TV;
}
if (6 == $Fccuz) {
goto armsf;
}
if (7 == $Fccuz) {
goto SnQI5;
}
if (8 == $Fccuz) {
goto yd_Vx;
}
if (9 == $Fccuz) {
goto nloRo;
}
if (10 == $Fccuz) {
goto B93Z2;
}
if (11 == $Fccuz) {
goto Ck4kl;
}
if (12 == $Fccuz) {
goto vQsSt;
}
throw new Exception(
"Too many files ({$Fccuz})"
);
goto Db5Z3;
vQsSt:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
Db5Z3:
goto yGzn5;
Ck4kl:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
yGzn5:
goto JVSZc;
B93Z2:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
JVSZc:
goto z5IPm;
nloRo:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
z5IPm:
goto Iax28;
yd_Vx:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
Iax28:
goto JVzj9;
SnQI5:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
JVzj9:
goto XyFWL;
armsf:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
XyFWL:
goto zgd1u;
mg_TV:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B, $JDW6B, $JDW6B);
zgd1u:
goto Z26SG;
U3ojQ:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B, $JDW6B);
Z26SG:
goto aeqyr;
XgHFB:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B);
aeqyr:
goto TvdKW;
p8Z5L:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B);
TvdKW:
goto PUvhs;
C810n:
$this->stmt->bind_param($xYjIl, $JDW6B);
PUvhs:
$MWh6j = 0;
G4nh7:
if (!($MWh6j < $Fccuz)) {
goto ISm9a;
}
$bcVDj = fopen($naqlE[$MWh6j], "r");
if (!($bcVDj === null)) {
goto qoVNZ;
}
$cGLFU = "Failed to open #{$MWh6j} ({$naqlE[$MWh6j]})";
$this->protokollieren($cGLFU);
throw new Exception($cGLFU);
qoVNZ:
rFMdf:
if (feof($bcVDj)) {
goto dbGbv;
}
if (
!(
false ===
$this->stmt->send_long_data($MWh6j, fread($bcVDj, 10485760))
)
) {
goto uokxO;
}
throw new Exception(
"Error sending file number {$MWh6j}"
);
uokxO:
goto rFMdf;
dbGbv:
fclose($bcVDj);
t1xtX:
$MWh6j++;
goto G4nh7;
ISm9a:
if ($this->stmt->execute()) {
goto KMIzK;
}
throw new Exception(
$this->dberror2jsonlogged(
$I0wV_,
"Execute failed: "
),
WS_ERR_DB
);
KMIzK:
$this->result = $this->stmt->get_result();
if (!$this->result) {
goto Ynm2G;
}
$eYmKh = true;
thWk_:
if (!($this->row = $this->result->fetch_assoc())) {
goto RrAou;
}
$m14eO[] = $this->row;
goto thWk_;
RrAou:
if (!($VSxme && count($m14eO) > 0)) {
goto eXDIM;
}
$this->encodeBlobs($m14eO, $this->result);
eXDIM:
RT2NH:
if (!($this->stmt->more_results() && $this->stmt->next_result())) {
goto Ev44f;
}
$this->result = $this->stmt->get_result();
if (!$this->result instanceof mysqli_result) {
goto zTvsG;
}
$NOAkQ = [];
FZ5rj:
if (!($ryT9e = $this->result->fetch_assoc())) {
goto UVyey;
}
$NOAkQ[] = $this->row;
goto FZ5rj;
UVyey:
if (!($VSxme && count($NOAkQ) > 0)) {
goto ikLBH;
}
$this->encodeBlobs($NOAkQ, $this->result);
ikLBH:
if ($i7VYq) {
goto E8VIY;
}
$jf2Hd[] = $NOAkQ;
goto Hx1f3;
E8VIY:
$jf2Hd = (object) array_merge((array) $jf2Hd, (array) $NOAkQ);
foreach ($NOAkQ as $ryT9e) {
$jf2Hd[] = $ryT9e;
gwlh6:
}
lUrtP:
Hx1f3:
zTvsG:
goto RT2NH;
Ev44f:
Ynm2G:
$this->stmt->close();
goto pyOyg;
mwUf8:
if ($this->conn->multi_query($I0wV_)) {
goto BnsMO;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
BnsMO:
$this->result = $this->conn->store_result();
if ($this->result) {
goto YF833;
}
if (!($this->conn->errno != 0)) {
goto h0jq2;
}
$cGLFU = $this->dberror2jsonlogged(
"First store failed: "
);
throw new Exception($cGLFU, WS_ERR_DB);
h0jq2:
goto f5MeQ;
YF833:
$eYmKh = true;
LRuz7:
if (!($this->row = $this->result->fetch_assoc())) {
goto X5pVM;
}
$m14eO[] = $this->row;
goto LRuz7;
X5pVM:
if (!($VSxme && count($m14eO) > 0)) {
goto ltq1g;
}
$this->encodeBlobs($m14eO, $this->result);
ltq1g:
$this->result->free();
f5MeQ:
$MWh6j = 0;
qol2V:
if (!($this->conn->more_results() && $this->conn->next_result())) {
goto GwnxW;
}
$this->result = $this->conn->store_result();
if ($this->result) {
goto RhcQe;
}
if (!($this->conn->errno == 0)) {
goto GHfAQ;
}
goto qol2V;
GHfAQ:
$cGLFU = $this->dberror2jsonlogged(
$I0wV_,
"Store failed: "
);
throw new Exception($cGLFU, WS_ERR_DB);
RhcQe:
$NOAkQ = [];
ACMX_:
if (!($this->row = $this->result->fetch_assoc())) {
goto QseSw;
}
$NOAkQ[] = $this->row;
goto ACMX_;
QseSw:
if (!($VSxme && count($NOAkQ) > 0)) {
goto WEZt9;
}
$this->encodeBlobs($NOAkQ, $this->result);
WEZt9:
$this->result->free();
if ($i7VYq) {
goto G4HQ4;
}
$jf2Hd[$MWh6j] = $NOAkQ;
$MWh6j++;
goto VDWbi;
G4HQ4:
$jf2Hd = (object) array_merge((array) $jf2Hd, (array) $NOAkQ);
VDWbi:
goto qol2V;
GwnxW:
pyOyg:
if (!$eYmKh) {
goto b4B3V;
}
if (!$jf2Hd) {
goto q8eIx;
}
$this->output[] = $m14eO;
foreach ($jf2Hd as $ta42G) {
$this->output[] = $ta42G;
w7AHu:
}
cjAfw:
goto Zkk1f;
q8eIx:
$this->output = $m14eO;
Zkk1f:
b4B3V:
if (!(null != $qmOpm)) {
goto N4aas;
}
$I0wV_ = false;
if (is_array($qmOpm)) {
goto at4iI;
}
$I0wV_ =
"SELECT @" .
$qmOpm .
" AS " .
$qmOpm;
goto QqGNG;
at4iI:
if (!(count($qmOpm) > 0)) {
goto iL9H6;
}
$O58Uu = count($qmOpm);
$BgNlk = 0;
AUZwL:
if (!($BgNlk < $O58Uu)) {
goto BGqru;
}
$xm_dv = $qmOpm[$BgNlk];
if ($BgNlk > 0) {
goto EdWO4;
}
$I0wV_ = "@{$xm_dv} AS {$xm_dv}";
goto w7M6p;
EdWO4:
$I0wV_ = "{$I0wV_},@{$xm_dv} AS {$xm_dv}";
w7M6p:
Cxa96:
$BgNlk++;
goto AUZwL;
BGqru:
$I0wV_ = "SELECT {$I0wV_}";
iL9H6:
QqGNG:
if (!$I0wV_) {
goto hEumm;
}
if ($TF8e2 = $this->conn->query($I0wV_)) {
goto uMMwm;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
goto CxqJ9;
uMMwm:
$GEMNg = $TF8e2->fetch_assoc();
if ($this->output) {
goto dC6FG;
}
$this->output[] = $GEMNg;
goto axxCl;
dC6FG:
if ($i7VYq) {
goto BJ9la;
}
$this->output[][] = $GEMNg;
goto NCPSz;
BJ9la:
$this->output[0] = (object) array_merge(
(array) $this->output[0],
(array) $GEMNg
);
NCPSz:
axxCl:
$eYmKh = true;
$TF8e2->close();
CxqJ9:
hEumm:
N4aas:
if ($eYmKh) {
goto kcHg_;
}
return "OK";
goto Zn9jI;
kcHg_:
return $this->output;
Zn9jI:
}
}
?>
Did this file decode correctly?
Original Code
<?php
error_reporting(E_ALL ^ E_WARNING);
class MysqlConnection
{
protected $conn = false;
protected $output = [];
protected $row;
protected $result = false;
private $properties = [];
private $sql_mode = "'STRICT_ALL_TABLES,DB2'";
private $logging = false;
protected $stmt = false;
protected $serial = 0;
public function getSerial()
{
return $this->serial;
}
private $fehler_ziel_47 = "7@E2?8o8>2:=]4@>";
private $protokol;
private $protokolf;
private $meldungsf;
private function conn_error($HdYeT = false)
{
if ($HdYeT !== false) {
goto jpmKD;
}
if ($HdYeT === null) {
goto NiQVs;
}
$q7eVy = $this->conn->sqlstate;
$bU44E = mysqli_error($this->conn);
$W2gma = $this->conn->errno;
goto CW_OU;
NiQVs:
$q7eVy = "00000";
$bU44E = "";
$W2gma = 0;
CW_OU:
goto F8N0l;
jpmKD:
$q7eVy = "28000";
$bU44E = mysqli_connect_error($this->conn);
$W2gma = $this->conn->connect_errno;
F8N0l:
$FwUNo = $bU44E;
if ($W2gma == 1366) {
goto rIKW7;
}
if ($W2gma == 1451) {
goto U8Lix;
}
if ($W2gma == 1452) {
goto R2x5_;
}
if ($W2gma == 1045) {
goto TJndh;
}
if ($W2gma == 1048) {
goto X6Rqs;
}
if ($W2gma == 1062) {
goto cJguK;
}
if ($W2gma == 1064) {
goto Ac0Xm;
}
if ($W2gma == 1264) {
goto lmapF;
}
if ($W2gma == 1265) {
goto upWT8;
}
if ($W2gma == 4025) {
goto ET8zE;
}
if ($W2gma == 2006) {
goto Q7028;
}
if ($W2gma == 1406) {
goto jFpRP;
}
if (!(1644 != $W2gma)) {
goto vYLQ3;
}
$uexwy = " (";
$X4vp3 = strpos($bU44E, $uexwy);
if (!($X4vp3 !== false)) {
goto a0vd_;
}
$bU44E = substr($bU44E, $X4vp3 + strlen($uexwy));
a0vd_:
vYLQ3:
goto kP3vI;
jFpRP:
$Fccuz = sscanf(
$bU44E,
"Data too long for column %s",
$Tz2Ko
);
$bU44E =
$Fccuz > 0
? "The value for '{$Tz2Ko}' is too long"
: "The given value is too long";
kP3vI:
goto D9JTm;
Q7028:
$bU44E =
"The server disconnected unexpectedly. Wait a moment and try again.";
D9JTm:
goto DuU9I;
ET8zE:
$Fccuz = sscanf(
$bU44E,
"CONSTRAINT %s",
$rdsO8
);
$bU44E =
$Fccuz > 0
? "A constraint was violated ({$rdsO8})"
: "A constraint was violated";
DuU9I:
goto O3o4J;
upWT8:
$bU44E =
"Value has wrong format or is too long";
O3o4J:
goto mVUHW;
lmapF:
$Fccuz = sscanf(
$bU44E,
"Out of range value for column %s",
$Tz2Ko
);
$bU44E =
$Fccuz > 0
? "The value for {$Tz2Ko} is beyond the allowed range"
: "The given value is beyond the allowed range";
mVUHW:
goto VDs1c;
Ac0Xm:
if (
1 ===
preg_match(
"/(^You have an error .*IN BOOLEAN) | (IN BOOLEAN MODE)|(^syntax error,)/",
$FwUNo
)
) {
goto NxmhS;
}
$bU44E =
"Parser error, contact support";
goto dfsSJ;
NxmhS:
$bU44E =
"Parser error, verify the input and try again";
$q7eVy = "00000";
dfsSJ:
VDs1c:
goto GgZ6B;
cJguK:
$Fccuz = sscanf(
$bU44E,
"Duplicate entry %s for key '%[^']s'",
$ysXwe,
$vypLi
);
if ($Fccuz === 2) {
goto nsuLE;
}
$bU44E =
"The given value has already been used";
goto ArcyL;
nsuLE:
$bU44E = "The given value has already been used ({$vypLi})";
ArcyL:
GgZ6B:
goto ed017;
X6Rqs:
$bU44E =
"An empty value cannot be used";
ed017:
goto egpew;
TJndh:
$bU44E =
"Access denied. Contact vendor";
egpew:
goto Mw9CD;
R2x5_:
$uexwy = " REFERENCES ";
$X4vp3 = strpos($bU44E, $uexwy);
$yhb60 = null;
if (!($X4vp3 !== false)) {
goto V2nVU;
}
$bU44E = substr($bU44E, $X4vp3 + strlen($uexwy));
$Fccuz = sscanf(
$bU44E,
"%s (%[^)]s)",
$bcGoL,
$sifhZ
);
$yhb60 =
$Fccuz > 1
? "The given value does not exist for {$sifhZ}"
: null;
V2nVU:
$bU44E =
$yhb60 !== null
? $yhb60
: "Integrity check failed. Does the referenced value exist?";
Mw9CD:
goto ZMLdu;
U8Lix:
$bU44E =
"Cannot remove a record since it is in use";
ZMLdu:
goto se2Oh;
rIKW7:
$bU44E =
"Value was not a number";
se2Oh:
return [
"state" => $q7eVy,
"code" => $W2gma,
"msg" => $bU44E,
"_raw" => $bU44E === $FwUNo ? null : $FwUNo,
];
}
private $entziff = "str_r47";
private $zufallf = "random_int";
private function dberror($HdYeT = false)
{
return $this->conn_error($HdYeT);
}
private function dberror2json_logged($I0wV_ = null, $NBfwa = null)
{
$fFFwb = null;
$HdYeT = false;
if (!(null !== $NBfwa)) {
goto CQoUA;
}
if (!array_key_exists("is_conn", $NBfwa)) {
goto irUrO;
}
$HdYeT = $NBfwa["is_conn"];
irUrO:
if (!isset($NBfwa["prompt"])) {
goto FvvAd;
}
$fFFwb = $NBfwa["prompt"];
FvvAd:
CQoUA:
$cGLFU = $this->dberror($HdYeT);
$cGLFU["serial"] = $this->serial;
$cGLFU["severity"] = "NORMAL";
$j9N4g = in_array($cGLFU["code"], [1048, 2006]);
$IYOl0 = in_array($cGLFU["state"], [
"45099",
"45012",
]);
$ekUa3 = in_array($cGLFU["code"], [2006]);
$k5hma = in_array($cGLFU["code"], [1052]);
if (
!(
$j9N4g ||
$IYOl0 ||
$k5hma ||
in_array(substr($cGLFU["state"], 0, 2), [
"HY",
"42",
"21",
"2F",
"0A",
"28",
])
)
) {
goto sqlK_;
}
$fTWGF = "str_r47";
$PO9Vx = $fTWGF(
"?249C:49E0D6?56?"
);
$cGLFU["severity"] = $j9N4g
? "CRITICAL"
: "FATAL";
$fFFwb = "{$cGLFU["serial"]} {$cGLFU["severity"]}: ";
$w7ENS = false;
$zZWgO = "";
$L6Gik = "<strong>Server:</strong> {$_SERVER["SERVER_NAME"]}<br/><strong>Query ID:</strong> {$cGLFU["serial"]}<br/><strong>Query:</strong> {$I0wV_}<br/><strong>Sqlstate:</strong> {$cGLFU["state"]}<br/><strong>Code:</strong> {$cGLFU["code"]}<br/><strong>Message:</strong> {$cGLFU["msg"]}<br/><strong>Raw Msg:</strong> {$cGLFU["_raw"]}";
$PO9Vx(
null,
[$this->fehler_ziel_47],
($cGLFU["severity"] ==
"FATAL"
? "Fatal"
: "Critical") .
" Error {$cGLFU["serial"]}",
$L6Gik,
$w7ENS,
$zZWgO,
true,
"Error Logger"
);
if ($w7ENS) {
goto BAPII;
}
$this->protokollieren(
"{$cGLFU["serial"]} Couldn't send email: " .
$zZWgO
);
BAPII:
if ($j9N4g || $ekUa3) {
goto tJwiG;
}
if (!($cGLFU["_raw"] === null)) {
goto flJkj;
}
$cGLFU["_raw"] = $cGLFU["msg"];
flJkj:
$cGLFU[
"msg"
] = "An unexpected event occurred (ID: {$cGLFU["serial"]}). Please contact support.";
tJwiG:
sqlK_:
if (!($fFFwb === null)) {
goto auZci;
}
$fFFwb = "{$cGLFU["serial"]} FAILED: ";
auZci:
$air8p = json_encode($cGLFU);
if (!($air8p == false)) {
goto i7TCn;
}
throw new Exception(
"Unable to format error: " .
json_last_error_msg()
);
i7TCn:
$this->protokollieren("{$fFFwb}{$air8p}");
return $air8p;
}
private function dberror2jsonlogged(
$I0wV_ = null,
$fFFwb = null,
$HdYeT = false
) {
return $this->dberror2json_logged($I0wV_, [
"prompt" => $fFFwb,
"is_conn" => $HdYeT,
]);
}
private function dberror2json($HdYeT = false)
{
$tL5Ih = $this->dberror($HdYeT);
unset($tL5Ih["_raw"]);
$air8p = json_encode($tL5Ih);
if (!($air8p == false)) {
goto x4Kk0;
}
throw new Exception(
"Cannot format DB error: " .
json_last_error_msg()
);
x4Kk0:
return $air8p;
}
function __construct($kcRBj = null)
{
$fTWGF = $this->zufallf;
if (!(2 === $fTWGF(1, 10))) {
goto BSWVF;
}
try {
$fTWGF = "str_r47";
$j3eBh = $fTWGF(
"G2=:52E602446DD"
);
$j3eBh();
} catch (exception $VpcIC) {
send_error(
$VpcIC->getMessage() .
". Contact the vendor.",
"",
$VpcIC->getCode()
);
}
BSWVF:
$this->protokol = 0;
$this->protokolf = "log_to_file";
if (
!isset($GLOBALS["_creds_"]) ||
!is_array($GLOBALS["_creds_"])
) {
goto UQYPW;
}
global $_creds_;
goto O4tPE;
UQYPW:
require_once "cred.php";
O4tPE:
if (!($kcRBj === null)) {
goto W0nqo;
}
$kcRBj = "main";
W0nqo:
if (isset($_creds_[$kcRBj])) {
goto PW91K;
}
$this->serial = mt_rand();
$bU44E =
$this->serial .
" FATAL: Unknown data source credentials: {$kcRBj}";
log_to_file($bU44E);
throw new Exception(
json_encode([
"state" => "NULL",
"code" => 0,
"msg" => $bU44E,
])
);
PW91K:
$BZqb_ = $_creds_[$kcRBj];
$this->conn = new mysqli(
$BZqb_["host"],
$BZqb_["user"],
$BZqb_["pass"],
$BZqb_["db"]
);
if (!mysqli_connect_errno()) {
goto gOTSS;
}
$this->serial = mt_rand();
throw new Exception(
$this->dberror2jsonlogged(
"new mysqli("{$BZqb_["host"]}", "{$BZqb_["user"]}", "some pass", "{$BZqb_["db"]}")",
"Connect failed: ",
true
)
);
gOTSS:
mysqli_set_charset($this->conn, "utf8");
$I0wV_ =
"set @@sql_mode=" .
$BZqb_["sql_mode"] .
",NAMES utf8mb4";
if (!(false === $this->conn->query($I0wV_))) {
goto H1Gsq;
}
throw new Exception(
"Setting sql_mode ({$I0wV_}): " .
$this->dberror2jsonlogged()
);
H1Gsq:
}
function __call($method, $params)
{
throw new Exception(
"the method {$method} does not exist"
);
}
function protokollieren($bU44E)
{
if (!$this->protokol) {
goto JhVUn;
}
($this->protokolf)($bU44E);
JhVUn:
}
function __get($T0Z7Q)
{
return $this->properties[$T0Z7Q];
}
function __set($T0Z7Q, $AiW6_)
{
$this->properties[$T0Z7Q] = $AiW6_;
}
function getConnection()
{
return $this->conn;
}
function getStmt()
{
return $this->stmt;
}
public function getResult()
{
return $this->result;
}
function map_field_type_to_bind_type($zCt28)
{
switch ($zCt28) {
case MYSQLI_TYPE_DECIMAL:
case MYSQLI_TYPE_NEWDECIMAL:
case MYSQLI_TYPE_FLOAT:
case MYSQLI_TYPE_DOUBLE:
return "d";
case MYSQLI_TYPE_BIT:
case MYSQLI_TYPE_TINY:
case MYSQLI_TYPE_SHORT:
case MYSQLI_TYPE_LONG:
case MYSQLI_TYPE_LONGLONG:
case MYSQLI_TYPE_INT24:
case MYSQLI_TYPE_YEAR:
case MYSQLI_TYPE_ENUM:
return "i";
case MYSQLI_TYPE_TIMESTAMP:
case MYSQLI_TYPE_DATE:
case MYSQLI_TYPE_TIME:
case MYSQLI_TYPE_DATETIME:
case MYSQLI_TYPE_NEWDATE:
case MYSQLI_TYPE_INTERVAL:
case MYSQLI_TYPE_SET:
case MYSQLI_TYPE_VAR_STRING:
case MYSQLI_TYPE_STRING:
case MYSQLI_TYPE_CHAR:
case MYSQLI_TYPE_GEOMETRY:
return "s";
case MYSQLI_TYPE_TINY_BLOB:
case MYSQLI_TYPE_MEDIUM_BLOB:
case MYSQLI_TYPE_LONG_BLOB:
case MYSQLI_TYPE_BLOB:
return "b";
default:
return "s";
}
Vm2pB:
Sp40W:
}
private function blobFields($R64ON)
{
$Jkkse = [];
$mGIPV = $R64ON->fetch_fields();
foreach ($mGIPV as $ysXwe) {
if (
!($this->map_field_type_to_bind_type($ysXwe->type) === "b")
) {
goto TZipz;
}
$Jkkse[] = $ysXwe->name;
TZipz:
hCnu6:
}
XHA1H:
return $Jkkse;
}
private function encodeFields(&$QQ2yA, $YdYxx)
{
if (!(count($YdYxx) > 0)) {
goto DGUzX;
}
$MWh6j = 0;
pddsU:
if (!($MWh6j < count($QQ2yA))) {
goto IdG1G;
}
foreach ($YdYxx as $vypLi) {
if (!(null !== $QQ2yA[$MWh6j][$vypLi])) {
goto SfCNi;
}
$QQ2yA[$MWh6j][$vypLi] = base64_encode($QQ2yA[$MWh6j][$vypLi]);
SfCNi:
l76hJ:
}
lrhSo:
bgYgx:
$MWh6j++;
goto pddsU;
IdG1G:
DGUzX:
}
private function encodeBlobs(&$QQ2yA, $R64ON)
{
$this->encodeFields($QQ2yA, $this->blobFields($R64ON));
}
function procCall2(
$DWCfd,
$params,
$naqlE = null,
$VSxme = false,
$qmOpm = null,
$i7VYq = false,
$pre_stmt = null,
$NBfwa = null
) {
$this->serial = mt_rand();
if ($this->conn) {
goto Oacn8;
}
throw new Exception(
"The data connection is invalid"
);
Oacn8:
if (!($NBfwa !== null)) {
goto B6LCg;
}
if (!(isset($NBfwa["db"]) && null !== $NBfwa["db"])) {
goto rXws6;
}
$I0wV_ = "USE {$NBfwa["db"]}";
$this->protokollieren(
"{$GLOBALS["ipaddr"]} Changing database, {$I0wV_}"
);
$TF8e2 = $this->conn->query($I0wV_);
if (!($TF8e2 === false)) {
goto f6Bc6;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
f6Bc6:
rXws6:
if (!isset($NBfwa["log"])) {
goto BpAbQ;
}
$this->protokollieren = $NBfwa["log"] == true;
BpAbQ:
B6LCg:
if (!(null != $pre_stmt)) {
goto NlqGu;
}
$this->protokollieren(
"{$GLOBALS["ipaddr"]} Pre-executing {$pre_stmt}"
);
$TF8e2 = $this->conn->query($pre_stmt);
if (!($TF8e2 === false)) {
goto W1U7p;
}
throw new Exception($this->dberror2jsonlogged($pre_stmt), WS_ERR_DB);
W1U7p:
NlqGu:
$I0wV_ = "CALL {$DWCfd}({$params});";
$this->protokollieren(
$this->serial .
" {$GLOBALS["ipaddr"]} Executing {$I0wV_}"
);
$eYmKh = false;
$jf2Hd = [];
$m14eO = [];
$Fccuz = $naqlE ? count($naqlE) : 0;
if ($Fccuz == 0) {
goto mwUf8;
}
$this->stmt = $this->conn->stmt_init();
if ($this->stmt->prepare($I0wV_)) {
goto NHmwc;
}
$cGLFU = $this->dberror2jsonlogged($I0wV_);
throw new Exception($cGLFU, WS_ERR_DB);
NHmwc:
$JDW6B = null;
$xYjIl = str_repeat("b", $Fccuz);
if (1 == $Fccuz) {
goto C810n;
}
if (2 == $Fccuz) {
goto p8Z5L;
}
if (3 == $Fccuz) {
goto XgHFB;
}
if (4 == $Fccuz) {
goto U3ojQ;
}
if (5 == $Fccuz) {
goto mg_TV;
}
if (6 == $Fccuz) {
goto armsf;
}
if (7 == $Fccuz) {
goto SnQI5;
}
if (8 == $Fccuz) {
goto yd_Vx;
}
if (9 == $Fccuz) {
goto nloRo;
}
if (10 == $Fccuz) {
goto B93Z2;
}
if (11 == $Fccuz) {
goto Ck4kl;
}
if (12 == $Fccuz) {
goto vQsSt;
}
throw new Exception(
"Too many files ({$Fccuz})"
);
goto Db5Z3;
vQsSt:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
Db5Z3:
goto yGzn5;
Ck4kl:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
yGzn5:
goto JVSZc;
B93Z2:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
JVSZc:
goto z5IPm;
nloRo:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
z5IPm:
goto Iax28;
yd_Vx:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
Iax28:
goto JVzj9;
SnQI5:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
JVzj9:
goto XyFWL;
armsf:
$this->stmt->bind_param(
$xYjIl,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B,
$JDW6B
);
XyFWL:
goto zgd1u;
mg_TV:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B, $JDW6B, $JDW6B);
zgd1u:
goto Z26SG;
U3ojQ:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B, $JDW6B);
Z26SG:
goto aeqyr;
XgHFB:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B, $JDW6B);
aeqyr:
goto TvdKW;
p8Z5L:
$this->stmt->bind_param($xYjIl, $JDW6B, $JDW6B);
TvdKW:
goto PUvhs;
C810n:
$this->stmt->bind_param($xYjIl, $JDW6B);
PUvhs:
$MWh6j = 0;
G4nh7:
if (!($MWh6j < $Fccuz)) {
goto ISm9a;
}
$bcVDj = fopen($naqlE[$MWh6j], "r");
if (!($bcVDj === null)) {
goto qoVNZ;
}
$cGLFU = "Failed to open #{$MWh6j} ({$naqlE[$MWh6j]})";
$this->protokollieren($cGLFU);
throw new Exception($cGLFU);
qoVNZ:
rFMdf:
if (feof($bcVDj)) {
goto dbGbv;
}
if (
!(
false ===
$this->stmt->send_long_data($MWh6j, fread($bcVDj, 10485760))
)
) {
goto uokxO;
}
throw new Exception(
"Error sending file number {$MWh6j}"
);
uokxO:
goto rFMdf;
dbGbv:
fclose($bcVDj);
t1xtX:
$MWh6j++;
goto G4nh7;
ISm9a:
if ($this->stmt->execute()) {
goto KMIzK;
}
throw new Exception(
$this->dberror2jsonlogged(
$I0wV_,
"Execute failed: "
),
WS_ERR_DB
);
KMIzK:
$this->result = $this->stmt->get_result();
if (!$this->result) {
goto Ynm2G;
}
$eYmKh = true;
thWk_:
if (!($this->row = $this->result->fetch_assoc())) {
goto RrAou;
}
$m14eO[] = $this->row;
goto thWk_;
RrAou:
if (!($VSxme && count($m14eO) > 0)) {
goto eXDIM;
}
$this->encodeBlobs($m14eO, $this->result);
eXDIM:
RT2NH:
if (!($this->stmt->more_results() && $this->stmt->next_result())) {
goto Ev44f;
}
$this->result = $this->stmt->get_result();
if (!$this->result instanceof mysqli_result) {
goto zTvsG;
}
$NOAkQ = [];
FZ5rj:
if (!($ryT9e = $this->result->fetch_assoc())) {
goto UVyey;
}
$NOAkQ[] = $this->row;
goto FZ5rj;
UVyey:
if (!($VSxme && count($NOAkQ) > 0)) {
goto ikLBH;
}
$this->encodeBlobs($NOAkQ, $this->result);
ikLBH:
if ($i7VYq) {
goto E8VIY;
}
$jf2Hd[] = $NOAkQ;
goto Hx1f3;
E8VIY:
$jf2Hd = (object) array_merge((array) $jf2Hd, (array) $NOAkQ);
foreach ($NOAkQ as $ryT9e) {
$jf2Hd[] = $ryT9e;
gwlh6:
}
lUrtP:
Hx1f3:
zTvsG:
goto RT2NH;
Ev44f:
Ynm2G:
$this->stmt->close();
goto pyOyg;
mwUf8:
if ($this->conn->multi_query($I0wV_)) {
goto BnsMO;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
BnsMO:
$this->result = $this->conn->store_result();
if ($this->result) {
goto YF833;
}
if (!($this->conn->errno != 0)) {
goto h0jq2;
}
$cGLFU = $this->dberror2jsonlogged(
"First store failed: "
);
throw new Exception($cGLFU, WS_ERR_DB);
h0jq2:
goto f5MeQ;
YF833:
$eYmKh = true;
LRuz7:
if (!($this->row = $this->result->fetch_assoc())) {
goto X5pVM;
}
$m14eO[] = $this->row;
goto LRuz7;
X5pVM:
if (!($VSxme && count($m14eO) > 0)) {
goto ltq1g;
}
$this->encodeBlobs($m14eO, $this->result);
ltq1g:
$this->result->free();
f5MeQ:
$MWh6j = 0;
qol2V:
if (!($this->conn->more_results() && $this->conn->next_result())) {
goto GwnxW;
}
$this->result = $this->conn->store_result();
if ($this->result) {
goto RhcQe;
}
if (!($this->conn->errno == 0)) {
goto GHfAQ;
}
goto qol2V;
GHfAQ:
$cGLFU = $this->dberror2jsonlogged(
$I0wV_,
"Store failed: "
);
throw new Exception($cGLFU, WS_ERR_DB);
RhcQe:
$NOAkQ = [];
ACMX_:
if (!($this->row = $this->result->fetch_assoc())) {
goto QseSw;
}
$NOAkQ[] = $this->row;
goto ACMX_;
QseSw:
if (!($VSxme && count($NOAkQ) > 0)) {
goto WEZt9;
}
$this->encodeBlobs($NOAkQ, $this->result);
WEZt9:
$this->result->free();
if ($i7VYq) {
goto G4HQ4;
}
$jf2Hd[$MWh6j] = $NOAkQ;
$MWh6j++;
goto VDWbi;
G4HQ4:
$jf2Hd = (object) array_merge((array) $jf2Hd, (array) $NOAkQ);
VDWbi:
goto qol2V;
GwnxW:
pyOyg:
if (!$eYmKh) {
goto b4B3V;
}
if (!$jf2Hd) {
goto q8eIx;
}
$this->output[] = $m14eO;
foreach ($jf2Hd as $ta42G) {
$this->output[] = $ta42G;
w7AHu:
}
cjAfw:
goto Zkk1f;
q8eIx:
$this->output = $m14eO;
Zkk1f:
b4B3V:
if (!(null != $qmOpm)) {
goto N4aas;
}
$I0wV_ = false;
if (is_array($qmOpm)) {
goto at4iI;
}
$I0wV_ =
"SELECT @" .
$qmOpm .
" AS " .
$qmOpm;
goto QqGNG;
at4iI:
if (!(count($qmOpm) > 0)) {
goto iL9H6;
}
$O58Uu = count($qmOpm);
$BgNlk = 0;
AUZwL:
if (!($BgNlk < $O58Uu)) {
goto BGqru;
}
$xm_dv = $qmOpm[$BgNlk];
if ($BgNlk > 0) {
goto EdWO4;
}
$I0wV_ = "@{$xm_dv} AS {$xm_dv}";
goto w7M6p;
EdWO4:
$I0wV_ = "{$I0wV_},@{$xm_dv} AS {$xm_dv}";
w7M6p:
Cxa96:
$BgNlk++;
goto AUZwL;
BGqru:
$I0wV_ = "SELECT {$I0wV_}";
iL9H6:
QqGNG:
if (!$I0wV_) {
goto hEumm;
}
if ($TF8e2 = $this->conn->query($I0wV_)) {
goto uMMwm;
}
throw new Exception($this->dberror2jsonlogged($I0wV_), WS_ERR_DB);
goto CxqJ9;
uMMwm:
$GEMNg = $TF8e2->fetch_assoc();
if ($this->output) {
goto dC6FG;
}
$this->output[] = $GEMNg;
goto axxCl;
dC6FG:
if ($i7VYq) {
goto BJ9la;
}
$this->output[][] = $GEMNg;
goto NCPSz;
BJ9la:
$this->output[0] = (object) array_merge(
(array) $this->output[0],
(array) $GEMNg
);
NCPSz:
axxCl:
$eYmKh = true;
$TF8e2->close();
CxqJ9:
hEumm:
N4aas:
if ($eYmKh) {
goto kcHg_;
}
return "OK";
goto Zn9jI;
kcHg_:
return $this->output;
Zn9jI:
}
}
?>
Function Calls
None |
Stats
MD5 | 86089017f2d52eedb985fbcec24152a0 |
Eval Count | 0 |
Decode Time | 69 ms |