PHP Decode

<?php  
/*   __________________________________________________  
    |  Obfuscated by YAK Pro - Php Obfuscator  2.0.14  |  
    |              on 2024-05-15 09:25:48              |  
    |    GitHub: https://github.com/pk-fr/yakpro-po    |  
    |__________________________________________________|  
*/  
 namespace GDPlayer; class Model extends \GDPlayer\ModelHelper { public function __construct() { session_write_close(); parent::__construct(); } protected function open() { goto J1RSGC2RJ_oM1Z0u; J1RSGC2RJ_oM1Z0u: session_write_close(); goto ab7QX3w2rsPnAOug; lpAGexgsRc71zHFr: $this->detectError(); goto pFzK9OJSZn_ZcnsF; ab7QX3w2rsPnAOug: $this->connect(); goto lpAGexgsRc71zHFr; pFzK9OJSZn_ZcnsF: } public function rawFetch(string $sql = '', ?array $params = null) { goto uqWg3fg0UvlOWSri; NNx4ZPV1_NheXDw5: try { goto Db4MeWoGi83OsbD0; bwIIzKTFMdXLCQY5: $result = $cache; goto syB13Jo2XqlopgtG; mwVlUGUVFPKSphlV: session_write_close(); goto xmdAPPrYQGXSGJC6; Db4MeWoGi83OsbD0: session_write_close(); goto RtSExoT0RgPrIZq4; ycWfOIctQfwtgFxL: $this->saveCache($result, "db_rawFetch"); goto ogR_7tHvzV2fDV_m; IuJHgGemSdTbts18: session_write_close(); goto DYpRlCScsrMsrY9n; lVpFUhE8XUXlITyl: if (is_array($cache)) { goto xkN6iXv31pEU1ORB; } goto IuJHgGemSdTbts18; syB13Jo2XqlopgtG: RWdb2ANv_HbYSM24: goto Me7S8AmpTsU9rDym; xmdAPPrYQGXSGJC6: $this->resetVar(); goto bwIIzKTFMdXLCQY5; sJ_cXMBUjxOnhoUQ: $qry = $this->conn->prepare($this->sqlQuery); goto GE3ZMeOChw1Q45n0; DqPfKZT47gtQtlIM: $cache = $this->getCache("db_rawFetch"); goto lVpFUhE8XUXlITyl; qAFW6xLUMYPVsD5a: $this->params = $params; goto DqPfKZT47gtQtlIM; RtSExoT0RgPrIZq4: $this->sqlQuery = $sql; goto qAFW6xLUMYPVsD5a; ogR_7tHvzV2fDV_m: $this->resetVar(); goto p3Qw7XQCT4qQZ_wL; GE3ZMeOChw1Q45n0: $qry->execute($this->params); goto iOWlwOhcikS6qHsB; uJsOYM5DkxxcexRq: xkN6iXv31pEU1ORB: goto mwVlUGUVFPKSphlV; DYpRlCScsrMsrY9n: $this->open(); goto sJ_cXMBUjxOnhoUQ; p3Qw7XQCT4qQZ_wL: goto RWdb2ANv_HbYSM24; goto uJsOYM5DkxxcexRq; u9Yq9AGD2VG6IoqD: $this->disconnect(); goto ycWfOIctQfwtgFxL; iOWlwOhcikS6qHsB: $result = $qry->fetch(\PDO::FETCH_ASSOC); goto u9Yq9AGD2VG6IoqD; Me7S8AmpTsU9rDym: } catch (\PDOException|\Exception $e) { goto iRDWPspm3qlVxqEF; SAKkCE5Kh1rSbqnm: $this->errors[] = $e->getMessage(); goto pjevaR66A3uooK_8; pjevaR66A3uooK_8: createErrorLog([__FILE__, __FUNCTION__, $sql, $e->getMessage()]); goto ZdL9lGO6tvkR4zKm; iRDWPspm3qlVxqEF: session_write_close(); goto SAKkCE5Kh1rSbqnm; ZdL9lGO6tvkR4zKm: } goto A9OQ1r9GClg56913; uqWg3fg0UvlOWSri: session_write_close(); goto KmwguzqKENbZhbIB; KmwguzqKENbZhbIB: $result = []; goto NNx4ZPV1_NheXDw5; A9OQ1r9GClg56913: return $result; goto jqqYqzN5CkRxNGxo; jqqYqzN5CkRxNGxo: } public function rawFetchAll(string $sql = '', ?array $params = null) { goto VygEQ2WboHouv91L; nur1o6MpkEOPFUm2: return $result; goto VbcDOaH1dA1BlE6e; ncyHb6HE38K_2uZf: try { goto PDs4h6mIJEVlD8QI; AIojixPa8YrV8L47: goto X0HccIMBitGFQGA6; goto nVv5oD2WUX1CB0Ns; gS7WCROvSqPWC0mO: $cache = $this->getCache("db_rawFetchAll"); goto Rzr11bUNboU0bRfp; nVv5oD2WUX1CB0Ns: u0yt1XZEFBtsTzeC: goto nXNNIpeVGonUwlrr; vo1hebV9gGvAv14_: $this->sqlQuery = $sql; goto MucQL2UfNR1DP41K; jFzcy0ICL1Jo2cBY: $result = $qry->fetchAll(\PDO::FETCH_ASSOC); goto v1UAvR4xmajIzst8; MucQL2UfNR1DP41K: $this->params = $params; goto gS7WCROvSqPWC0mO; kgzUOq5CGsoFXQZt: X0HccIMBitGFQGA6: goto DhMTsVBdeZ7JhF8K; Rzr11bUNboU0bRfp: if (is_array($cache)) { goto u0yt1XZEFBtsTzeC; } goto IPoXlYrMHNAGIYOr; RzL2d2ghasWEP9L9: $this->open(); goto UoL9Y_vdPZdqW4TH; UoL9Y_vdPZdqW4TH: $qry = $this->conn->prepare($sql); goto DVA6AxLooh8jxclj; nXNNIpeVGonUwlrr: session_write_close(); goto yfNU7wUlzDhBE5ks; yfNU7wUlzDhBE5ks: $this->resetVar(); goto Mg_nmuxwYvocRCO5; v1UAvR4xmajIzst8: $this->disconnect(); goto qgJTsJs2TphxT5jX; IPoXlYrMHNAGIYOr: session_write_close(); goto RzL2d2ghasWEP9L9; qgJTsJs2TphxT5jX: $this->saveCache($result, "db_rawFetchAll"); goto zchPjE0xuPMA8DCN; DVA6AxLooh8jxclj: $qry->execute($params); goto jFzcy0ICL1Jo2cBY; zchPjE0xuPMA8DCN: $this->resetVar(); goto AIojixPa8YrV8L47; Mg_nmuxwYvocRCO5: $result = $cache; goto kgzUOq5CGsoFXQZt; PDs4h6mIJEVlD8QI: session_write_close(); goto vo1hebV9gGvAv14_; DhMTsVBdeZ7JhF8K: } catch (\PDOException|\Exception $e) { goto dtNy0zTOXal54dyz; wBu_WiC_7IzBVvd2: createErrorLog([__FILE__, __FUNCTION__, $sql, $e->getMessage()]); goto fAB5kUhfszRNG4mC; KU5XCJQW_pODmgHJ: $this->errors[] = $e->getMessage(); goto wBu_WiC_7IzBVvd2; dtNy0zTOXal54dyz: session_write_close(); goto KU5XCJQW_pODmgHJ; fAB5kUhfszRNG4mC: } goto nur1o6MpkEOPFUm2; hUtgMaGlY1CrpPbE: $result = []; goto ncyHb6HE38K_2uZf; VygEQ2WboHouv91L: session_write_close(); goto hUtgMaGlY1CrpPbE; VbcDOaH1dA1BlE6e: } public function rawQuery(string $sql = '') { goto B0K_LN0x24B6_GWJ; oQhbeRSfycEqXVuX: try { goto O30jDkRLFOZ2WOD4; yC0jf0WaejUYOL3z: $qry = $this->conn->query($sql); goto DBwxv7_kpFJS46Au; O30jDkRLFOZ2WOD4: session_write_close(); goto u6EkYEP5pKvIfsOL; pIpP6x5R8QEUy7uB: $this->open(); goto yC0jf0WaejUYOL3z; DBwxv7_kpFJS46Au: $this->disconnect(); goto s0BYyZ6d9B0BpAG7; NcgVHOTUqnH2J5Hf: return $qry; goto oakpel1BeYjhIVfh; s0BYyZ6d9B0BpAG7: $this->resetVar(); goto NcgVHOTUqnH2J5Hf; u6EkYEP5pKvIfsOL: $this->sqlQuery = $sql; goto pIpP6x5R8QEUy7uB; oakpel1BeYjhIVfh: } catch (\PDOException|\Exception $e) { goto zMLB_m3SmGCXhx0k; GCxgoOtqHCdFcKZj: createErrorLog([__FILE__, __FUNCTION__, $sql, $e->getMessage()]); goto ZDPRNHRhkrpGVifc; AvV547u83wDTZJjI: $this->errors[] = $e->getMessage(); goto GCxgoOtqHCdFcKZj; zMLB_m3SmGCXhx0k: session_write_close(); goto AvV547u83wDTZJjI; ZDPRNHRhkrpGVifc: } goto masGl2x2saDa5Ps4; masGl2x2saDa5Ps4: return false; goto BYQyZnzyzB3yUPDO; B0K_LN0x24B6_GWJ: session_write_close(); goto oQhbeRSfycEqXVuX; BYQyZnzyzB3yUPDO: } public function get(array $fields = []) { goto XGsi0QyGvK6L7ZlY; p0Nm7V8prn7fi39N: $result = false; goto IBf7y1NFxMUML4Qf; IBf7y1NFxMUML4Qf: try { goto s5A4gx0QtyQRo03n; mz3ML9yjyNpYVfvm: goto jc4Zr42lD4ViUAQ6; goto si1Wkeglzb2d7Eey; DA9LGKZCEKKgZkGp: $result = $cache; goto jht84juA_9NVzzWn; aI2DwLOWWRgZDiEK: $this->params = $this->serializeData(); goto HNe1HYHd8KtLFh8x; Wcs2Gvfwyd4DqkFC: fuK7rqjp5yIUvzMG: goto b4fk1DVIPL9q3hlA; PhknsUd4accgNRvP: session_write_close(); goto TKtCPPsJ9D_uw8kv; HNe1HYHd8KtLFh8x: $getWhereQuery = ''; goto gRW2HEjdivSec6Lh; s5A4gx0QtyQRo03n: session_write_close(); goto rbA3rULS3OVSLP26; TkSF8tXpwsYAfs9d: $cache = $this->getCache("db_get"); goto DC5A1S1M8q1hzNdt; ZoPu6hogpu19RfpD: $this->resetVar(); goto DA9LGKZCEKKgZkGp; si1Wkeglzb2d7Eey: Lk7VCk4fJN3FGylB: goto nhgPPvjFV3rjCYTX; b4fk1DVIPL9q3hlA: $this->sqlQuery = "SELECT {$fieldsQuery} " . "FROM `{$this->table}` {$this->joinQuery} {$getWhereQuery} " . "{$this->groupByQuery} {$this->orderByQuery} {$this->limitQuery}"; goto TkSF8tXpwsYAfs9d; TKtCPPsJ9D_uw8kv: $getWhereQuery = "WHERE" . $this->whereQuery; goto Wcs2Gvfwyd4DqkFC; fr1ZqNVWMyKsW5xU: $this->saveCache($result, "db_get"); goto G9yR950B0LovFTau; p5VHDGNS284wThBv: session_write_close(); goto SJGkJwWMwlmqr6uY; DC5A1S1M8q1hzNdt: if ($cache) { goto Lk7VCk4fJN3FGylB; } goto p5VHDGNS284wThBv; ZpZ2Q8T0x2Dvr1G7: $qry = $this->conn->prepare($this->sqlQuery); goto VxdIbqLoiTGUn0EV; jht84juA_9NVzzWn: jc4Zr42lD4ViUAQ6: goto f0FaCbM5rOAu389F; rbA3rULS3OVSLP26: $fieldsQuery = $this->createQueryFields($fields); goto aI2DwLOWWRgZDiEK; JguiWuTbGqCw0IFE: $result = $qry->fetchAll(\PDO::FETCH_ASSOC); goto sNfTfgWYfuEOkdmX; SJGkJwWMwlmqr6uY: $this->open(); goto ZpZ2Q8T0x2Dvr1G7; sNfTfgWYfuEOkdmX: $this->disconnect(); goto fr1ZqNVWMyKsW5xU; VxdIbqLoiTGUn0EV: $qry->execute($this->params); goto JguiWuTbGqCw0IFE; nhgPPvjFV3rjCYTX: session_write_close(); goto ZoPu6hogpu19RfpD; G9yR950B0LovFTau: $this->resetVar(); goto mz3ML9yjyNpYVfvm; gRW2HEjdivSec6Lh: if (empty($this->whereQuery)) { goto fuK7rqjp5yIUvzMG; } goto PhknsUd4accgNRvP; f0FaCbM5rOAu389F: } catch (\PDOException|\Exception $e) { goto gUtkTv5F4tVapoQf; QJ7E1dCyDohFzlvU: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto YaXhatOXwBZxDWkA; gUtkTv5F4tVapoQf: session_write_close(); goto Lt3D984vMi29cw1A; Lt3D984vMi29cw1A: $this->errors[] = $e->getMessage(); goto QJ7E1dCyDohFzlvU; YaXhatOXwBZxDWkA: } goto BsgZ4D0ybTnNBY9d; BsgZ4D0ybTnNBY9d: return $result; goto xZup1G_Q81ywKdik; XGsi0QyGvK6L7ZlY: session_write_close(); goto p0Nm7V8prn7fi39N; xZup1G_Q81ywKdik: } public function getOne(array $fields = []) { goto sH0XmDWB5ofclQ3K; H8li3t2mPUKHWhG0: try { goto p7wNx4GlIAyw9VHk; p60dAYKjjuM8Dz0W: return $cache; goto m_Ph9ZXvG51bdiCa; xb3LqLjhKyB5e3zi: goto K_zZgN4Elu3vz2K8; goto BlXptjqwJRK_Vy9f; m_Ph9ZXvG51bdiCa: K_zZgN4Elu3vz2K8: goto snHhpFnuKpqhp5WC; oKkmyTzSnTYX5ZQ6: $this->resetVar(); goto xb3LqLjhKyB5e3zi; fTZdtjm0_JFUZNUv: $this->open(); goto mEN_P8PcFEC4OX9l; LrrtAfNTMxhNDjeY: if ($cache) { goto CFvF7pH7OYAaDC8G; } goto O5DdUSWhjL74Ugkt; ODiRaRrrv5tQXEei: $getOneWhereQuery = ''; goto WdRLOD7KDPlk6RMQ; cj270a7r7ZVhDGby: $getOneWhereQuery = "WHERE" . $this->whereQuery; goto KQE1jze4tDETkwot; bGYC8rn33XstFjqq: $this->saveCache($result, "db_getOne"); goto oKkmyTzSnTYX5ZQ6; BlXptjqwJRK_Vy9f: CFvF7pH7OYAaDC8G: goto btbBjjZf7OU7PkfM; lhmOBXIvylPVWt07: $this->disconnect(); goto bGYC8rn33XstFjqq; i5kE9W4qnpv2P7yd: $this->params = $this->serializeData(); goto ODiRaRrrv5tQXEei; O5DdUSWhjL74Ugkt: session_write_close(); goto fTZdtjm0_JFUZNUv; mEN_P8PcFEC4OX9l: $qry = $this->conn->prepare($this->sqlQuery); goto BczAsNZUQa11Q3un; KQE1jze4tDETkwot: TO48JftYeynbFKL7: goto tk3of0hh6_DsKLoC; BczAsNZUQa11Q3un: $qry->execute($this->params); goto H_xiuhkksvmf6kWB; mUY6QfavmGFvv9Iy: $fieldsQuery = $this->createQueryFields($fields); goto i5kE9W4qnpv2P7yd; HGFz1U1J1m_E63at: $cache = $this->getCache("db_getOne"); goto LrrtAfNTMxhNDjeY; p7wNx4GlIAyw9VHk: session_write_close(); goto mUY6QfavmGFvv9Iy; WdRLOD7KDPlk6RMQ: if (empty($this->whereQuery)) { goto TO48JftYeynbFKL7; } goto Ma11UqPBZIBHG4u7; Ma11UqPBZIBHG4u7: session_write_close(); goto cj270a7r7ZVhDGby; tk3of0hh6_DsKLoC: $this->sqlQuery = "SELECT {$fieldsQuery} " . "FROM `{$this->table}` {$this->joinQuery} {$getOneWhereQuery} " . "LIMIT 1"; goto HGFz1U1J1m_E63at; uy82AwMUK0HW3ntM: $this->resetVar(); goto p60dAYKjjuM8Dz0W; H_xiuhkksvmf6kWB: $result = $qry->fetch(\PDO::FETCH_ASSOC); goto lhmOBXIvylPVWt07; btbBjjZf7OU7PkfM: session_write_close(); goto uy82AwMUK0HW3ntM; snHhpFnuKpqhp5WC: } catch (\PDOException|\Exception $e) { goto mdi3YTHiOI0YK2gk; z95VCZmV4VGaGWag: $this->errors[] = $e->getMessage(); goto Cv9HNiCeFk32cfAZ; Cv9HNiCeFk32cfAZ: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto waq2D4McFjfmiZtL; mdi3YTHiOI0YK2gk: session_write_close(); goto z95VCZmV4VGaGWag; waq2D4McFjfmiZtL: } goto whEVEA8vfgJByZ_R; NGwKwObbinOA5g6q: $result = false; goto H8li3t2mPUKHWhG0; whEVEA8vfgJByZ_R: return $result; goto QvVjCO_LCzst1B2Z; sH0XmDWB5ofclQ3K: session_write_close(); goto NGwKwObbinOA5g6q; QvVjCO_LCzst1B2Z: } public function getTotalRows() { goto Dhy58d9EVtfStMdD; T9_uzxcow_4yywrs: try { goto CJoGohVKWCfZCC_Q; ZdzGLmtoAFpxckyR: $qry->execute(); goto GbSsrn0N3AN3gZO3; aic8Ojf0ioh61GTq: $this->open(); goto ucO7k6xjlFSu0n77; OsAseYaPiiooQrk5: $this->resetVar(); goto kiQntUKRefMR1RI9; GbSsrn0N3AN3gZO3: $fetchColumn = $qry->fetchColumn(); goto dEriKaVDtcvrDpVI; dEriKaVDtcvrDpVI: $this->disconnect(); goto OsAseYaPiiooQrk5; ucO7k6xjlFSu0n77: $qry = $this->conn->prepare($this->sqlQuery); goto ZdzGLmtoAFpxckyR; CJoGohVKWCfZCC_Q: session_write_close(); goto dFr9hZrowm5YnzCi; dFr9hZrowm5YnzCi: $this->sqlQuery = "SELECT COUNT(*) FROM `{$this->table}` {$this->joinQuery} {$this->groupByQuery}"; goto aic8Ojf0ioh61GTq; kiQntUKRefMR1RI9: $result = intval($fetchColumn); goto bciRynlp0V3SZAf3; bciRynlp0V3SZAf3: } catch (\PDOException|\Exception $e) { goto O3hfaBhYKM_4xv0v; O3hfaBhYKM_4xv0v: session_write_close(); goto c5RJ1lhEM75kXKkT; c5RJ1lhEM75kXKkT: $this->errors[] = $e->getMessage(); goto yt2v37dvvo68iVui; yt2v37dvvo68iVui: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto GzMARXlrgIMjANCj; GzMARXlrgIMjANCj: } goto VYvDNihs059IH5KT; VYvDNihs059IH5KT: return $result; goto d8TC7vGTCrBEHTb_; Co6OKHwpWAhttGqi: $result = 0; goto T9_uzxcow_4yywrs; Dhy58d9EVtfStMdD: session_write_close(); goto Co6OKHwpWAhttGqi; d8TC7vGTCrBEHTb_: } public function getNumRows() { goto hcbr3wKsUUALtDCC; P8lx7pOG2gYVfHLv: return $result; goto YqzWMOkxLA0YzCDB; hcbr3wKsUUALtDCC: session_write_close(); goto gWphmfzXtze5H3xM; gWphmfzXtze5H3xM: $result = 0; goto YNWxrukjTkzsumMd; YNWxrukjTkzsumMd: try { goto zlFvK_j0GIlo7RqO; E0E2ruqoIO8SXzI3: $qry = $this->conn->prepare($this->sqlQuery); goto n3wFJkrNWbI6YUyH; WIDHJm2bR4cA9mpP: $this->params = $this->serializeData(); goto JOnWw1YmgdeslNaZ; aLGRHy4pQBdD2JQk: $fetchColumn = $qry->fetchColumn(); goto s0w2bHtp5NjR2jLU; EsxzeAs3cHHZjjG6: p6vMQPdabQ9plU2p: goto FpZ9lNXTmvsK1UQX; s0w2bHtp5NjR2jLU: $this->disconnect(); goto wFgNrgK7rpIOK3OI; T3VAUxzeXrRUxj3d: session_write_close(); goto IHuhekYp0skB9rXy; v_Gj0DPMO8pmarby: $this->open(); goto E0E2ruqoIO8SXzI3; cY3RM6qqvFJx_4Bh: $result = intval($fetchColumn); goto pee5UZNsDGi_nuw5; FpZ9lNXTmvsK1UQX: $this->sqlQuery = "SELECT COUNT(*) FROM `{$this->table}` {$this->joinQuery} {$getNumWhereQuery} {$this->groupByQuery}"; goto v_Gj0DPMO8pmarby; n3wFJkrNWbI6YUyH: $qry->execute($this->params); goto aLGRHy4pQBdD2JQk; IHuhekYp0skB9rXy: $getNumWhereQuery = "WHERE" . $this->whereQuery; goto EsxzeAs3cHHZjjG6; JOnWw1YmgdeslNaZ: $getNumWhereQuery = ''; goto fkdq3UXIF4PqZbxO; zlFvK_j0GIlo7RqO: session_write_close(); goto WIDHJm2bR4cA9mpP; fkdq3UXIF4PqZbxO: if (empty($this->whereQuery)) { goto p6vMQPdabQ9plU2p; } goto T3VAUxzeXrRUxj3d; wFgNrgK7rpIOK3OI: $this->resetVar(); goto cY3RM6qqvFJx_4Bh; pee5UZNsDGi_nuw5: } catch (\PDOException|\Exception $e) { goto EP8tu9mhTdLpNlBg; pVlBGxBLTd_tIK0P: $this->errors[] = $e->getMessage(); goto nKBFygcmgHx2Q2Hl; nKBFygcmgHx2Q2Hl: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto dsQCpXJd7iuJdZce; EP8tu9mhTdLpNlBg: session_write_close(); goto pVlBGxBLTd_tIK0P; dsQCpXJd7iuJdZce: } goto P8lx7pOG2gYVfHLv; YqzWMOkxLA0YzCDB: } public function insert(array $data = []) { goto rEFqAEK2zVKb1CGw; fRIYxY1d2iilcdMS: $result = false; goto eBCduOJlxoZIYyo7; aLT4hSmOgCGPLJgc: return $result; goto QtuubYcPTlqg1XvA; rEFqAEK2zVKb1CGw: session_write_close(); goto fRIYxY1d2iilcdMS; eBCduOJlxoZIYyo7: try { goto CvlmeIdTd74n7hRw; U2sL8WhpgvHGOnad: $insertParams = $this->serializeData($data); goto Rz0tNxnCQv0voKT9; veCUVFFmptExtNwJ: $this->resetVar(); goto StU4oyH78yv0w8xO; Ea3wqE_hZG6sWDAW: $qry = $this->conn->prepare($this->sqlQuery); goto PyAT2MDkp2BPm1kS; xvgXrKjxXU4O73RR: $keys = array_keys($data); goto RDCbQDppie1FIYv0; CvlmeIdTd74n7hRw: session_write_close(); goto xvgXrKjxXU4O73RR; hy2moSm4aoqzvJeZ: session_write_close(); goto MWXV9pJpeaZpSi0H; K9YG5X6v4IYm1rlC: $this->disconnect(); goto veCUVFFmptExtNwJ; MWXV9pJpeaZpSi0H: $result = $this->conn->lastInsertId($this->primaryKey); goto omCXcuga6BsMGXuU; JfuIDvsXGIGsAVaf: $this->open(); goto Ea3wqE_hZG6sWDAW; RDCbQDppie1FIYv0: $fieldsQuery = "(`" . implode("`,`", $keys) . "`)"; goto L_c2HL5j5gLh9r6d; tlRmxTlJcROWaNXi: $this->sqlQuery = "INSERT INTO `{$this->table}` {$fieldsQuery} VALUES {$valuesQuery}"; goto JfuIDvsXGIGsAVaf; PyAT2MDkp2BPm1kS: $exec = $qry->execute($insertParams); goto x0CF9mkYWuVJ_4Ww; x0CF9mkYWuVJ_4Ww: if (!$exec) { goto BfuDfpyv4zPmTwOv; } goto hy2moSm4aoqzvJeZ; StU4oyH78yv0w8xO: $this->clearCache(); goto GyEcKrzHOo1rFqsC; Rz0tNxnCQv0voKT9: $this->params = $insertParams; goto tlRmxTlJcROWaNXi; omCXcuga6BsMGXuU: BfuDfpyv4zPmTwOv: goto K9YG5X6v4IYm1rlC; L_c2HL5j5gLh9r6d: $valuesQuery = "(:" . implode(",:", $keys) . ")"; goto U2sL8WhpgvHGOnad; GyEcKrzHOo1rFqsC: } catch (\PDOException|\Exception $e) { goto naMTe_wY2KPQLyvc; w6eUKesOm_XB40pz: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto U2MtkSuboQ7OeJnb; naMTe_wY2KPQLyvc: session_write_close(); goto W_2GwLDDRXTcP6Eo; W_2GwLDDRXTcP6Eo: $this->errors[] = $e->getMessage(); goto w6eUKesOm_XB40pz; U2MtkSuboQ7OeJnb: } goto aLT4hSmOgCGPLJgc; QtuubYcPTlqg1XvA: } public function update(array $data = []) { goto zNL0PXUE_72dHVkK; k0TvTqbq0t3Atb8J: try { goto OS1NTpZlBlnrpLYr; Pf8a5jyd7iAxKTK5: $fieldsQuery = trim($fieldsQuery, ", "); goto etdtHNagtcfRe2KW; kenoifOxD7nXYmgw: $this->open(); goto w0tMZ7HYxYZEddHV; y8Mc129Sp41nFcqW: $this->disconnect(); goto jfrGhqwPtiug6lX0; nvsIZSL1YzYQxJwS: $this->sqlQuery = "UPDATE `{$this->table}` SET {$fieldsQuery} {$updateWhereQuery} {$this->limitQuery}"; goto kenoifOxD7nXYmgw; J9rofV5IhKJuB1mO: session_write_close(); goto b7GXFWW0Ie_6dpgD; SjvL_MAYbwMcgOES: $keys = array_keys($data); goto iJIRTNTKSIRQuc7t; oxXTt5Cf0gIMr224: if (empty($this->whereQuery)) { goto hnMoDqeYRrLBG_cG; } goto J9rofV5IhKJuB1mO; etdtHNagtcfRe2KW: $updateWhereQuery = ''; goto oxXTt5Cf0gIMr224; jfrGhqwPtiug6lX0: $this->resetVar(); goto JBLn01JI_ivpgaM8; WxSX5UOc9MfZYCMF: foreach ($keys as $key) { goto MKsLdNa4E1du2LLd; MKsLdNa4E1du2LLd: session_write_close(); goto CRS_lCicXOU9sAGV; aLkEdBvM77L7lNvj: MNYz_KK1uQ2gOE4P: goto hmW4fondrHFOfN01; CRS_lCicXOU9sAGV: $fieldsQuery .= "`{$key}` = :{$key}, "; goto aLkEdBvM77L7lNvj; hmW4fondrHFOfN01: } goto N9AV5hhtQSL9v3db; JBLn01JI_ivpgaM8: $this->clearCache(); goto mvY6GFGe6g90L741; UxHuCXaf8YgVbwKw: $this->params = $updateParams; goto SjvL_MAYbwMcgOES; kTRqsgCic4Fs1hU7: hnMoDqeYRrLBG_cG: goto nvsIZSL1YzYQxJwS; b7GXFWW0Ie_6dpgD: $updateWhereQuery = "WHERE" . $this->whereQuery; goto kTRqsgCic4Fs1hU7; iuSmLpsCkbqONSE4: $result = $qry->execute($updateParams); goto y8Mc129Sp41nFcqW; N9AV5hhtQSL9v3db: qLnGSPmCnmXokwt2: goto Pf8a5jyd7iAxKTK5; w0tMZ7HYxYZEddHV: $qry = $this->conn->prepare($this->sqlQuery); goto iuSmLpsCkbqONSE4; iJIRTNTKSIRQuc7t: $fieldsQuery = ''; goto WxSX5UOc9MfZYCMF; OS1NTpZlBlnrpLYr: session_write_close(); goto flKJLESYW_AfBPUq; flKJLESYW_AfBPUq: $updateParams = $this->serializeData($data); goto UxHuCXaf8YgVbwKw; mvY6GFGe6g90L741: } catch (\PDOException|\Exception $e) { goto qmJNNIPT9sdCtzh7; g61P05p_81d6RLDu: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto WGvBTBtA28s92pNP; qmJNNIPT9sdCtzh7: session_write_close(); goto gfCR0VQiVFxiHswS; gfCR0VQiVFxiHswS: $this->errors[] = $e->getMessage(); goto g61P05p_81d6RLDu; WGvBTBtA28s92pNP: } goto TDnQcWlag1xUJw8g; zNL0PXUE_72dHVkK: session_write_close(); goto zkOJsVv5lTZzTrnT; TDnQcWlag1xUJw8g: return $result; goto ZwLemaOGqUFpH9l4; zkOJsVv5lTZzTrnT: $result = false; goto k0TvTqbq0t3Atb8J; ZwLemaOGqUFpH9l4: } public function delete() { goto ag64N1HunLCf8RC1; lyccIsLDLdeK9DeA: try { goto TWlUhoC3C3k60mzd; lqRy_Vc8BUBh2d6A: $qry = $this->conn->query("ALTER TABLE `{$this->table}` AUTO_INCREMENT=1"); goto BylZDPUnF_6i_vzJ; FeHqbzPnnXEcMnlu: $deleteWhereQuery = "WHERE" . $this->whereQuery; goto CI_Ws3NQ0CoDCwLv; G2bijs33SeRzkkZU: $qry = $this->conn->prepare($this->sqlQuery); goto HiuczwyFTTpPcluw; IiCeJNwsYNDIFE4j: $this->resetVar(); goto bxDXfQ5uGaSB7jYl; WDkXTatzBdnRc5JP: $this->params = $this->serializeData(); goto cNjiiv_j5a8uoW_7; cNjiiv_j5a8uoW_7: $deleteWhereQuery = ''; goto T0GMQ6PYsWS81C7G; HiuczwyFTTpPcluw: $result = $qry->execute($this->params); goto lqRy_Vc8BUBh2d6A; F4NzADcu3G16sbtf: $this->sqlQuery = "DELETE FROM `{$this->table}` {$deleteWhereQuery}"; goto ALiOWXWHVU2BYmEX; bxDXfQ5uGaSB7jYl: $this->clearCache(); goto tesuPZi00CnY3dxY; BylZDPUnF_6i_vzJ: $this->disconnect(); goto IiCeJNwsYNDIFE4j; ALiOWXWHVU2BYmEX: $this->open(); goto G2bijs33SeRzkkZU; TWlUhoC3C3k60mzd: session_write_close(); goto WDkXTatzBdnRc5JP; T0GMQ6PYsWS81C7G: if (empty($this->whereQuery)) { goto r7Wo0sx3tP96khfT; } goto X_ZENwhw8dVI1D_I; CI_Ws3NQ0CoDCwLv: r7Wo0sx3tP96khfT: goto F4NzADcu3G16sbtf; X_ZENwhw8dVI1D_I: session_write_close(); goto FeHqbzPnnXEcMnlu; tesuPZi00CnY3dxY: } catch (\PDOException|\Exception $e) { goto xuc_F8mdJleFG_9n; JA0m_hUX46LifoeB: createErrorLog([__FILE__, __FUNCTION__, $this->table, $e->getMessage()]); goto upiu8xiVNxMNpoqw; xuc_F8mdJleFG_9n: session_write_close(); goto SWAmFXPQfDXBi6HS; SWAmFXPQfDXBi6HS: $this->errors[] = $e->getMessage(); goto JA0m_hUX46LifoeB; upiu8xiVNxMNpoqw: } goto F9AG7W0jYyqenIC2; aBgYeQ8e7olTKqkm: $result = false; goto lyccIsLDLdeK9DeA; ag64N1HunLCf8RC1: session_write_close(); goto aBgYeQ8e7olTKqkm; F9AG7W0jYyqenIC2: return $result; goto TDPwHW4N19CqTEpN; TDPwHW4N19CqTEpN: } public function removeAllIndexes(array $excludes = []) { goto Rdgb7MZFiTe8CE7I; H8tPd_MSOZ3_LJcJ: $dropSQL = ''; goto S2GZyeqpJc0XOWgV; iqpRt_YCz1VLavIY: TBaCWE8UlopFP2hQ: goto QBKu56_2etyi82j6; bP4ZPSIxsPXakCsb: return true; goto gbqRuht6SP5wgHzf; S2GZyeqpJc0XOWgV: foreach ($indexes as $idx) { goto QJ02dBcr4_caVE47; QJ02dBcr4_caVE47: session_write_close(); goto p0hVC01SyUPzWINX; p0hVC01SyUPzWINX: $dropSQL .= sprintf("DROP INDEX `%s` ON `%s`;", $idx["Key_name"], $this->table); goto zGXcimq4B1JGftbt; zGXcimq4B1JGftbt: GZZXJezCMSuiYkaQ: goto z0N6zE4yloR19Akd; z0N6zE4yloR19Akd: } goto iqpRt_YCz1VLavIY; OhtM0iUBKSsywTYw: lPrbY9eViE5kF5Gz: goto bP4ZPSIxsPXakCsb; xwldlqQNDHUYc7Gy: $indexes = $this->rawFetchAll(sprintf("SHOW INDEXES FROM `%s` WHERE `Key_name` <> "PRIMARY" and %s", $this->table, trim(implode(" and ", $qryExcludes), " and "))); goto HyMsY31yZaxMEs19; Rdgb7MZFiTe8CE7I: session_write_close(); goto Ss67vs_d5obE4bS3; yFAZmkeW30mREE90: aj9oXO_i7qexFeUK: goto xwldlqQNDHUYc7Gy; Ss67vs_d5obE4bS3: $qryExcludes = []; goto AX8fGkZeAR9K_BuI; HyMsY31yZaxMEs19: if (!$indexes) { goto lPrbY9eViE5kF5Gz; } goto CHnvxYNyI1PrzenM; AX8fGkZeAR9K_BuI: foreach ($excludes as $idx) { goto Ui9vsP20VkgyIZ6g; XAlPAtaDKXG0LK0R: RgelSZU8AeqU7TAO: goto fiNJZk0n52MKzTbA; Ui9vsP20VkgyIZ6g: session_write_close(); goto BkHvpQqiYVhFnH9K; BkHvpQqiYVhFnH9K: $qryExcludes[] = "`Key_name` <> '{$idx}'"; goto XAlPAtaDKXG0LK0R; fiNJZk0n52MKzTbA: } goto yFAZmkeW30mREE90; CHnvxYNyI1PrzenM: session_write_close(); goto H8tPd_MSOZ3_LJcJ; QBKu56_2etyi82j6: $this->rawQuery($dropSQL); goto OhtM0iUBKSsywTYw; gbqRuht6SP5wgHzf: } public function optimizeDB() { goto ghHxcSDWgaSN9Yyl; xmldD2kXGnoi5rua: $tables = trim(implode(",", $tableFine), ","); goto bRQOxK4vACvtHQW0; YJhNS5f245ZSsOuM: $check = $this->rawFetchAll("CHECK TABLE `tb_gdrive_auth`, " . "`tb_gdrive_mirrors`, " . "`tb_gdrive_queue`, " . "`tb_loadbalancers`, " . "`tb_plugins`, " . "`tb_sessions`, " . "`tb_settings`, " . "`tb_stats`, " . "`tb_stats_ua`, " . "`tb_subtitle_manager`, " . "`tb_subtitles`, " . "`tb_users`, " . "`tb_videos`, " . "`tb_videos_alternatives`, " . "`tb_videos_hash`, " . "`tb_videos_short`, " . "`tb_videos_sources`;"); goto ZDX0OecLsvr_QoTi; o13sbxFfm_sD9y1l: session_write_close(); goto qicoLgrDVu84NUgp; G0enUHWujD1HicY2: createErrorLog([__FILE__, __FUNCTION__, "tables error", trim(implode(",", $tableError), ",")]); goto QhZtIimjwPB9clKU; QAWPmtWf34T2_v0Q: if (!empty($tableFine)) { goto PVSjtNNMowyDKC38; } goto t22ixJsXZrdXX1Yz; ZDX0OecLsvr_QoTi: $tableError = []; goto ji4_UcJyzjteWUFt; QhZtIimjwPB9clKU: goto qLn36PNWWbUn43qu; goto Y8CZGq_ZfkqSs8dF; ghHxcSDWgaSN9Yyl: session_write_close(); goto YJhNS5f245ZSsOuM; x_runA3h4D6kLnSl: qLn36PNWWbUn43qu: goto HjCZWKXeQlmRXUsL; ji4_UcJyzjteWUFt: $tableFine = []; goto KF7yUeRGH0m1xAkq; BxEUoweC7wgPjvmt: return ["tables_error" => $tableError, "tables_fine" => $tableFine]; goto cdUyfmlxAKwSAHEq; qicoLgrDVu84NUgp: foreach ($check as $dt) { goto unjUssEVkC4KFcrH; rSA7wxiMRV2L_sXA: J5zBZxLmcHxRMqZf: goto pXHI0b2am72CQwA2; pXHI0b2am72CQwA2: session_write_close(); goto Ha7b1sGWx4XzwjZ5; nUin0klDDNrBzccn: if (strpos($dt["Msg_text"], "OK") !== false || strpos($dt["Msg_text"], "up to date") !== false) { goto J5zBZxLmcHxRMqZf; } goto gfc1jnWfx_gYkJGd; unjUssEVkC4KFcrH: session_write_close(); goto nUin0klDDNrBzccn; FzCGw2OgTgDsV67P: goto eTuOwR3I0_eB340V; goto rSA7wxiMRV2L_sXA; Ha7b1sGWx4XzwjZ5: $tableFine[] = $dt["Table"]; goto iLm9llsEwSmuDyM3; iLm9llsEwSmuDyM3: eTuOwR3I0_eB340V: goto y51cSxwx_j0xkgjO; FBB6LDUk5K4p0UQT: $tableError[] = $dt; goto FzCGw2OgTgDsV67P; gfc1jnWfx_gYkJGd: session_write_close(); goto FBB6LDUk5K4p0UQT; y51cSxwx_j0xkgjO: MYav9anbtMaSZI6E: goto gvCeEypP3dZgPT0d; gvCeEypP3dZgPT0d: } goto E5ALGToHodnAvezV; KF7yUeRGH0m1xAkq: if (!$check) { goto DIbfWpxUvYU1EU1S; } goto o13sbxFfm_sD9y1l; Y8CZGq_ZfkqSs8dF: PVSjtNNMowyDKC38: goto HiSIPhJF383CH_FT; HjCZWKXeQlmRXUsL: DIbfWpxUvYU1EU1S: goto BxEUoweC7wgPjvmt; E5ALGToHodnAvezV: kCL61F4r3829OTyn: goto QAWPmtWf34T2_v0Q; bRQOxK4vACvtHQW0: $this->rawFetchAll("ANALYZE TABLE {$tables};"); goto x_runA3h4D6kLnSl; t22ixJsXZrdXX1Yz: session_write_close(); goto G0enUHWujD1HicY2; HiSIPhJF383CH_FT: session_write_close(); goto xmldD2kXGnoi5rua; cdUyfmlxAKwSAHEq: } public function getLastError() { session_write_close(); return end($this->errors); } public function getSQLQuery() { session_write_close(); return $this->sqlQuery; } public function getFields() { session_write_close(); return $this->fields; } public function getPrimaryKey() { session_write_close(); return $this->primaryKey; } public function getCurrentTable() { session_write_close(); return $this->table; } public function __destruct() { goto BucmS0RtkZCVZu8c; TQ2TbNU1raBUlKQI: $this->disconnect(); goto hLJ_Ganz1tHZXF1V; BucmS0RtkZCVZu8c: session_write_close(); goto TQ2TbNU1raBUlKQI; hLJ_Ganz1tHZXF1V: $this->resetVar(); goto jzz3uOGXOF2pojzj; jzz3uOGXOF2pojzj: } }  
 ?>