<?php
/**
 * @package embed-sharepoint-onedrive-documents
 * @author miniOrange
 * @link https://plugins.miniorange.com
 */


namespace MoSharePointObjectSync\Wrappers;

class dbWrapper
{
    private static $sps;
    public static function getSPSWrapper()
    {
        if (isset(self::$sps)) {
            goto y9;
        }
        self::$sps = new dbWrapper();
        y9:
        return self::$sps;
    }
    public static function mo_sps_create_shortcode_table()
    {
        global $wpdb;
        $ar = $wpdb->get_charset_collate();
        $dq = $wpdb->prefix . "\155\x6f\137\x73\160\x73\137\163\150\x6f\162\164\x63\x6f\144\x65";
        if (!dbWrapper::mo_sps_table_exists($dq)) {
            goto Pn;
        }
        return;
        Pn:
        $eW = "\x43\122\x45\101\x54\105\x20\x54\101\x42\x4c\x45\x20{$dq}\x20\50\15\xa\40\x20\40\40\40\40\40\x20\40\x20\x20\40\x69\144\x20\155\x65\144\151\165\x6d\151\156\x74\50\71\51\x20\x4e\117\x54\x20\116\125\x4c\114\x20\101\x55\124\x4f\x5f\x49\x4e\x43\x52\x45\x4d\x45\x4e\124\54\15\12\40\x20\x20\40\x20\40\40\40\x20\40\x20\40\163\x63\137\141\164\x74\162\x73\x20\154\157\x6e\147\164\x65\x78\x74\x20\116\117\124\40\116\x55\x4c\114\x2c\xd\xa\x20\x20\40\40\40\40\x20\40\40\40\40\x20\163\x63\x5f\143\x75\x72\162\145\x6e\164\x5f\x73\164\x61\164\145\x20\164\145\x78\x74\40\116\117\124\x20\116\x55\114\x4c\54\xd\xa\40\x20\x20\x20\x20\40\x20\40\40\40\40\40\163\143\137\x70\x61\x74\150\x20\x6c\x6f\156\147\164\x65\x78\164\40\x4e\117\x54\40\x4e\x55\x4c\x4c\x2c\xd\12\40\40\x20\40\40\40\40\x20\x20\x20\x20\x20\x50\x52\111\115\x41\x52\131\x20\x4b\105\x59\40\151\144\40\50\151\x64\x29\xd\xa\40\40\40\40\x20\x20\40\40\x29\x20{$ar}\73";
        require_once ABSPATH . "\x77\x70\55\x61\x64\x6d\151\x6e\57\151\x6e\143\x6c\x75\144\x65\x73\x2f\x75\x70\147\x72\x61\x64\145\x2e\160\150\160";
        dbDelta($eW);
    }
    public static function mo_sps_update_shortcode_table_row($KY, $Uw = 0)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x6d\157\x5f\x73\160\x73\x5f\163\x68\157\x72\x74\143\157\144\145";
        $Ya = array("\45\x73");
        $RV = dbWrapper::mo_sps_get_shortcode_table_row_id($Uw);
        if ($RV) {
            goto B3;
        }
        $wpdb->insert($ei, $KY, $Ya);
        goto yu;
        B3:
        $wpdb->update($ei, $KY, array("\151\144" => $RV), $Ya);
        yu:
    }
    public static function mo_sps_delete_row($Uw)
    {
        global $wpdb;
        $wpdb->delete($wpdb->prefix . "\x6d\x6f\x5f\163\x70\x73\x5f\163\150\x6f\162\164\143\157\x64\x65", array("\x69\x64" => $Uw));
        return;
    }
    public static function mo_sps_get_shortcode_table_row_id($Uw)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x6d\x6f\x5f\x73\x70\163\x5f\163\150\157\162\x74\143\x6f\x64\145";
        $wK = $wpdb->get_results($wpdb->prepare("\123\105\x4c\x45\x43\x54\x20\x69\144\40\106\x52\x4f\115\x20\x25\65\x73\40\x77\x68\x65\162\145\x20\x69\144\40\75\x20\x25\x73", $ei, $Uw));
        if (!empty($wK)) {
            goto fS;
        }
        return false;
        fS:
        return $wK[0]->id;
    }
    public static function mo_sps_get_shortcode_table_row($Uw)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x6d\x6f\137\x73\160\163\137\x73\150\x6f\162\x74\143\x6f\144\145";
        $wK = $wpdb->get_results($wpdb->prepare("\x53\105\x4c\x45\103\124\40\52\x20\106\x52\117\x4d\x20\x25\x35\x73\x20\167\x68\x65\162\x65\x20\151\x64\40\75\40\x25\x73", $ei, $Uw), ARRAY_A);
        if (!empty($wK)) {
            goto BL;
        }
        return [];
        BL:
        return $wK[0];
    }
    public static function mo_sps_get_shortcode_table_rows_by_key($cD, $Uw, $Cg = "\52")
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\155\157\137\x73\x70\163\137\163\x68\157\162\x74\x63\x6f\144\145";
        $wK = $wpdb->get_results($wpdb->prepare("\123\x45\114\105\103\124\x20\x20\x25\x35\x73\40\x46\x52\x4f\x4d\x20\45\65\x73\40\x77\150\145\x72\145\40\45\65\163\x20\75\40\45\163", $Cg, $ei, $cD, $Uw), ARRAY_A);
        if (!empty($wK)) {
            goto fa;
        }
        return [];
        fa:
        return $wK;
    }
    public static function mo_sps_get_all_shortcode_config()
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\155\157\137\163\160\x73\x5f\163\150\x6f\162\164\143\157\144\x65";
        if (dbWrapper::mo_sps_table_exists($ei)) {
            goto MO;
        }
        return [];
        MO:
        $wK = $wpdb->get_results($wpdb->prepare("\x53\x45\x4c\x45\x43\x54\40\x69\144\x2c\x20\163\x63\137\141\x74\x74\x72\x73\54\40\163\143\x5f\143\165\162\x72\x65\156\x74\137\163\x74\141\x74\145\x2c\40\163\143\137\160\x61\164\x68\40\x66\x72\157\x6d\x20\x25\65\163", $ei), ARRAY_A);
        return $wK;
    }
    public static function mo_sps_get_folder_map_array()
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\160\x73\137\146\x6f\154\x64\145\x72\x5f\155\x61\x70";
        $wK = $wpdb->get_results("\123\105\114\x45\103\124\x20\52\40\106\122\117\x4d\40{$ei}");
        if (!empty($wK)) {
            goto eC;
        }
        return [];
        eC:
        $g7 = [];
        foreach ($wK as $a_) {
            $g7[$a_->sps_id] = $a_->folder_id;
            jj:
        }
        Py:
        return $g7;
    }
    public static function mo_sps_create_folder_map_table()
    {
        global $wpdb;
        $ar = $wpdb->get_charset_collate();
        $dq = $wpdb->prefix . "\x73\x70\163\x5f\146\157\154\144\145\x72\x5f\x6d\141\x70";
        $eW = "\103\x52\x45\101\x54\x45\40\x54\x41\102\114\x45\40{$dq}\x20\x28\xd\12\x20\40\40\x20\x20\40\40\40\40\40\40\40\151\x64\x20\x6d\x65\x64\151\x75\x6d\151\x6e\x74\50\x39\x29\x20\116\117\x54\40\116\x55\114\x4c\x20\x41\x55\x54\117\x5f\111\116\x43\x52\x45\115\105\116\124\54\15\xa\40\x20\x20\x20\x20\x20\x20\x20\x20\40\40\40\x73\x70\163\137\151\x64\40\164\x65\170\x74\x20\116\x4f\x54\x20\116\x55\x4c\114\x2c\xd\12\40\40\40\40\40\x20\40\40\40\x20\x20\x20\146\x6f\x6c\144\145\x72\x5f\x69\x64\x20\164\145\170\164\x20\x4e\x4f\x54\x20\x4e\125\x4c\x4c\x2c\xd\12\40\40\40\40\40\40\40\40\x20\x20\40\40\x50\122\x49\x4d\101\x52\131\40\113\105\131\x20\x69\144\x20\50\x69\144\x29\xd\12\40\40\40\x20\40\40\x20\40\x29\40{$ar}\73";
        require_once ABSPATH . "\167\x70\x2d\x61\x64\155\151\x6e\57\151\x6e\x63\154\165\x64\x65\163\57\x75\x70\147\162\x61\x64\x65\x2e\160\x68\160";
        dbDelta($eW);
    }
    public static function mo_sps_create_media_table()
    {
        global $wpdb;
        $ar = $wpdb->get_charset_collate();
        $dq = $wpdb->prefix . "\x73\x70\163\137\155\x65\144\151\141";
        $eW = "\x43\122\x45\101\x54\x45\40\124\101\x42\x4c\105\40{$dq}\40\50\xd\12\40\40\x20\x20\40\40\x20\x20\40\x20\40\40\151\144\40\155\145\144\151\x75\155\x69\156\164\x28\x39\51\40\116\117\x54\x20\x4e\125\114\114\40\101\x55\x54\x4f\137\111\x4e\103\x52\105\115\105\x4e\124\x2c\xd\xa\x20\x20\x20\40\40\x20\x20\40\x20\x20\x20\40\163\150\x61\x72\x65\x70\x6f\151\x6e\x74\x5f\x73\151\164\x65\40\164\145\x78\x74\40\x4e\x4f\x54\x20\x4e\125\x4c\114\54\xd\12\40\40\40\40\40\x20\x20\x20\x20\x20\40\40\163\x68\x61\162\145\x70\157\151\156\164\x5f\144\162\x69\166\x65\x20\164\145\x78\x74\40\x4e\117\x54\40\116\125\114\x4c\54\15\xa\40\40\40\40\x20\x20\x20\x20\x20\40\x20\x20\163\171\x6e\143\137\x69\156\164\x65\162\x76\141\x6c\40\x49\116\x54\x20\x4e\x4f\124\40\116\125\x4c\114\54\15\12\40\40\40\x20\x20\x20\40\40\40\40\x20\x20\x73\x79\x6e\x63\137\163\x74\141\x74\x75\163\x20\164\x65\x78\x74\x20\116\x4f\x54\40\116\125\114\x4c\54\xd\xa\40\x20\x20\x20\40\40\40\40\40\40\40\x20\120\x52\111\115\101\122\131\x20\x4b\105\x59\40\x69\144\x20\x28\151\x64\x29\15\12\x20\x20\x20\40\40\x20\x20\40\x29\40{$ar}\73";
        require_once ABSPATH . "\167\160\x2d\141\144\x6d\151\x6e\x2f\x69\156\x63\x6c\165\144\x65\163\57\165\160\147\x72\x61\x64\x65\x2e\x70\x68\160";
        dbDelta($eW);
    }
    public static function mo_sps_update_media_table($ki, $Bs, $km, $b3)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\160\x73\137\155\145\144\x69\x61";
        $KY = array("\x73\150\141\x72\145\160\157\x69\x6e\x74\x5f\163\x69\164\x65" => $ki, "\x73\150\x61\162\145\160\x6f\151\x6e\164\x5f\x64\x72\151\x76\x65" => $Bs, "\x73\x79\x6e\143\x5f\x69\x6e\x74\145\162\166\141\x6c" => $km, "\163\171\x6e\143\137\x73\x74\141\164\165\163" => $b3);
        $Ya = array("\45\163", "\45\x73", "\x25\x64", "\x25\x73");
        $wK = self::mo_sps_get_id_media_table($ki, $Bs);
        if (empty($wK)) {
            goto Fa;
        }
        $KY = array("\151\x64" => $wK[0]->id, "\163\150\141\x72\x65\160\x6f\151\x6e\164\137\163\x69\164\x65" => $ki, "\x73\x68\141\x72\145\160\157\151\x6e\x74\x5f\x64\162\x69\166\x65" => $Bs, "\x73\171\156\143\x5f\151\x6e\164\x65\162\x76\x61\154" => $km, "\163\x79\156\x63\x5f\163\x74\x61\x74\165\x73" => $b3);
        $Ya = array("\x25\144", "\x25\163", "\x25\x73", "\x25\x64", "\45\x73");
        $wpdb->replace($ei, $KY, $Ya);
        goto fr;
        Fa:
        $wpdb->insert($ei, $KY, $Ya);
        fr:
    }
    public static function mo_sps_get_id_media_table($ki, $Bs)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\160\163\x5f\155\145\x64\151\x61";
        $wK = $wpdb->get_results("\x53\105\x4c\105\x43\x54\x20\151\144\40\x46\x52\x4f\115\x20{$ei}\x20\167\x68\145\x72\x65\x20\50\x73\150\x61\x72\145\x70\157\151\156\x74\x5f\163\x69\164\145\40\75\40\x27" . $ki . "\x27\x20\x41\x4e\104\x20\163\150\141\x72\x65\x70\x6f\151\x6e\164\x5f\x64\x72\151\x76\145\x20\75\40\x27" . $Bs . "\47\51\40");
        return $wK;
    }
    public static function mo_bring_data_from_media_table()
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\x70\163\137\155\x65\144\151\x61";
        $KY = $wpdb->get_results("\123\105\x4c\105\103\124\x20\x2a\40\106\x52\x4f\115\x20{$ei}\x20\117\122\104\105\x52\x20\x42\131\40\x69\x64\x20\104\x45\123\103");
        return $KY;
    }
    public static function mo_sps_update_folder_map($cD, $V7)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\x70\x73\137\146\x6f\x6c\144\145\162\x5f\155\x61\x70";
        $KY = array("\x73\160\x73\x5f\151\144" => $cD, "\146\157\x6c\x64\145\x72\x5f\151\144" => $V7);
        $Ya = array("\45\163", "\45\x73");
        $RV = dbWrapper::mo_sps_get_folder_id($cD, true);
        if ($RV) {
            goto Si;
        }
        $wpdb->insert($ei, $KY, $Ya);
        goto k4;
        Si:
        $wpdb->update($ei, $KY, array("\151\144" => $RV), $Ya);
        k4:
    }
    public static function mo_sps_get_folder_id($cD, $k5 = false)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\160\163\137\x66\157\x6c\x64\x65\x72\137\155\x61\x70";
        if (!$k5) {
            goto jg;
        }
        $wK = $wpdb->get_results("\x53\105\x4c\105\103\124\40\151\x64\x20\x46\122\x4f\x4d\x20{$ei}\x20\x77\x68\x65\x72\145\x20\163\x70\x73\137\151\x64\40\x3d\x20\47" . $cD . "\x27");
        if (!empty($wK)) {
            goto jO;
        }
        return false;
        jO:
        return $wK[0]->id;
        jg:
        $wK = $wpdb->get_results("\123\105\x4c\x45\x43\x54\40\x66\x6f\x6c\144\x65\x72\137\x69\144\x20\x46\x52\x4f\115\40{$ei}\x20\167\x68\x65\x72\x65\40\x73\x70\x73\x5f\151\144\40\x3d\x20\x27" . $cD . "\x27");
        if (!empty($wK)) {
            goto U_;
        }
        return false;
        U_:
        return $wK[0]->folder_id;
    }
    public static function mo_sps_delete_folder_id($cD)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\x70\163\137\x66\157\154\144\x65\x72\137\155\x61\160";
        $RV = dbWrapper::mo_sps_get_folder_id($cD, true);
        if ($RV) {
            goto CA;
        }
        return false;
        CA:
        $wpdb->delete($ei, array("\x69\144" => $RV));
        return true;
    }
    public static function mo_sps_get_new_id()
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\x70\163\x5f\155\145\x64\151\x61";
        if (dbWrapper::mo_sps_table_exists($ei)) {
            goto PU;
        }
        return 0;
        PU:
        $S0 = $wpdb->dbname;
        $wK = $wpdb->get_results($wpdb->prepare("\x53\x45\114\x45\x43\124\x20\x60\101\125\x54\117\x5f\111\x4e\x43\122\x45\115\x45\x4e\x54\140\x20\106\122\117\x4d\40\40\111\116\x46\117\122\x4d\101\124\x49\x4f\116\137\123\103\110\x45\x4d\x41\x2e\124\x41\x42\x4c\x45\x53\x20\127\110\105\x52\105\40\124\101\102\x4c\x45\137\x53\103\x48\x45\x4d\x41\40\75\x20\x25\x73\x20\101\116\104\40\124\101\102\x4c\105\x5f\x4e\x41\115\x45\40\75\x20\x25\x73", $S0, $ei), ARRAY_A);
        $Ec = $wK[0]["\101\x55\124\x4f\137\111\116\103\x52\105\115\105\116\124"];
        return $Ec;
    }
    public static function mo_sps_table_exists($ei)
    {
        global $wpdb;
        $wK = $wpdb->get_results($wpdb->prepare("\x53\x48\x4f\127\40\124\101\102\114\105\x53\x20\x4c\111\x4b\105\x20\x25\x73", $ei), ARRAY_A);
        return !empty($wK);
    }
    public static function mo_sps_truncate_folder_map()
    {
        global $wpdb;
        $wpdb->query("\124\x52\125\x4e\103\101\124\x45\x20\x54\101\102\114\x45\40" . $wpdb->prefix . "\x73\160\x73\x5f\146\157\x6c\144\145\x72\137\x6d\x61\x70");
    }
    public static function mo_sps_get_file_map_array()
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\x70\x73\x5f\146\x69\x6c\x65\x5f\x6d\141\160";
        $wK = $wpdb->get_results("\123\x45\x4c\105\103\124\x20\52\x20\x46\122\x4f\115\40{$ei}");
        if (!empty($wK)) {
            goto EI;
        }
        return [];
        EI:
        $g7 = [];
        foreach ($wK as $a_) {
            $g7[$a_->sps_id] = $a_->file_id;
            ej:
        }
        dC:
        return $g7;
    }
    public static function mo_sps_create_file_map_table()
    {
        global $wpdb;
        $ar = $wpdb->get_charset_collate();
        $dq = $wpdb->prefix . "\163\x70\x73\137\x66\151\154\145\137\155\x61\x70";
        $eW = "\103\x52\x45\x41\124\105\x20\124\x41\x42\x4c\x45\40{$dq}\x20\50\xd\xa\40\40\x20\40\x20\40\x20\40\40\x20\40\x20\151\144\40\155\145\x64\151\x75\x6d\x69\156\164\50\71\51\40\x4e\117\x54\40\x4e\125\x4c\114\40\101\125\x54\x4f\x5f\x49\x4e\x43\x52\105\x4d\x45\116\x54\54\xd\12\40\40\x20\x20\40\40\40\x20\x20\x20\40\40\163\x70\x73\137\151\144\40\164\x65\x78\164\x20\x4e\x4f\x54\x20\x4e\x55\114\x4c\54\15\12\40\x20\40\40\40\x20\x20\x20\40\40\40\x20\146\151\x6c\x65\x5f\151\144\x20\164\145\170\164\40\116\x4f\124\x20\116\125\x4c\114\54\15\12\40\x20\40\x20\x20\40\40\40\x20\x20\x20\x20\120\122\x49\115\x41\122\131\x20\113\x45\131\x20\x69\144\x20\x28\151\x64\x29\xd\12\40\40\x20\40\40\x20\x20\40\x29\40{$ar}\73";
        require_once ABSPATH . "\x77\x70\x2d\141\x64\155\151\x6e\57\x69\x6e\143\154\x75\x64\x65\163\57\x75\x70\147\162\141\144\x65\x2e\160\150\x70";
        dbDelta($eW);
    }
    public static function mo_sps_update_file_map($cD, $V7)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\x70\x73\x5f\x66\x69\154\145\137\x6d\x61\x70";
        $KY = array("\x73\x70\163\137\x69\x64" => $cD, "\146\x69\x6c\145\137\151\x64" => $V7);
        $Ya = array("\x25\163", "\x25\x73");
        $RV = dbWrapper::mo_sps_get_file_id($cD, true);
        if ($RV) {
            goto rC;
        }
        $wpdb->insert($ei, $KY, $Ya);
        goto J8;
        rC:
        $wpdb->update($ei, $KY, array("\151\144" => $RV), $Ya);
        J8:
    }
    public static function mo_sps_get_file_id($cD, $k5 = false)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\163\x70\x73\x5f\146\151\x6c\x65\x5f\155\141\160";
        if (!$k5) {
            goto SC;
        }
        $wK = $wpdb->get_results("\x53\x45\x4c\x45\103\x54\x20\151\x64\x20\x46\x52\x4f\115\40{$ei}\40\167\x68\145\x72\x65\x20\x73\x70\x73\137\x69\x64\x20\75\40\47" . $cD . "\x27");
        if (!empty($wK)) {
            goto Vw;
        }
        return false;
        Vw:
        return $wK[0]->id;
        SC:
        $wK = $wpdb->get_results("\x53\105\x4c\x45\103\x54\40\146\151\154\x65\137\151\x64\40\x46\x52\x4f\115\x20{$ei}\x20\x77\150\x65\x72\145\40\163\160\163\x5f\151\144\40\75\x20\x27" . $cD . "\47");
        if (!empty($wK)) {
            goto pa;
        }
        return false;
        pa:
        return $wK[0]->file_id;
    }
    public static function mo_sps_delete_file_id($cD)
    {
        global $wpdb;
        $ei = $wpdb->prefix . "\x73\x70\163\x5f\146\151\154\x65\137\155\x61\x70";
        $RV = dbWrapper::mo_sps_get_file_id($cD, true);
        if ($RV) {
            goto PW;
        }
        return false;
        PW:
        $wpdb->delete($ei, array("\x69\144" => $RV));
        return true;
    }
    public static function mo_sps_truncate_file_map()
    {
        global $wpdb;
        $wpdb->query("\x54\122\125\116\x43\x41\124\x45\40\x54\101\x42\114\x45\x20" . $wpdb->prefix . "\x73\160\163\x5f\146\x69\154\145\x5f\x6d\x61\x70");
    }
}