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

Variables

None

Stats

MD5 86089017f2d52eedb985fbcec24152a0
Eval Count 0
Decode Time 69 ms