PHP deobfuscation, decryption, reconstruction tool

Obfuscated php code

<?php
eval(str_rot13(gzinflate(str_rot13(base64_decode('LU3HkqTKkv2aeO/ODi15SXWtNZsxEi0SVTR8/SO6p6yMygwgAA/3I5xN2vH+avse2W2P9fLvNEkLgf3fYpk/v+XfZeya8v7/L//RjAUuKyN9Pnx4/INrhG9+mTw8mX8Qy7hj1WsmBJ7BF+f3ywc4TnpLg2JiJt6DI/ZeoHt7P8GN/B6jDO/Wo6WVXbRi43/vtn1U36EPCvYSO5K+f38Bi28fJCyQ4z7I1UK/PmeknyKF351Z2+qc0gbn/HXwTdL0UuhHybPQ0yq2pzqtTRTSM1xUwEVUPeAYM3z9ef3mZvAltGDI9HARiSogRzgXedjdbvad9bwY73HDstOuZDMpK23vdrm3cVX0xbKZMZjDJYcOpyeO+skLaxT12dYPSV+UitQZ96Ylxw6lWYYs5NhimNaXUowFdI6bFaHe8GspknbnAstP36HPRlX0AP3KtS1SbAoguTiVuK2ajoaFGuYqPHVp+3MK9RdtRcdOofLOoIdV8N53l5xTS30zGPVNNUKZcKL8VcW6AInZifwheujPz5NX3VRqzt1E+UmvxqJLlcwOO7/EqsxvxYhkDlWcPYOH+2Y3G1GiGVCxCDJD7CDdpi7t/NZZG2/km48MHYMImXEit6mK7gHNts+bMtMd5S32U8oa+kdwt4CEEw25A+t4M8uI2Rz75otohPhV20jKQITKOdCzvHAjl5PgPAlsN9p1h/1yrzqFubBM0dqvOtCZ0boc7uORu5iyqRh/PCb1J8cNSysbIdvijYgVGB3YksWV88hp3UOU3W6Cb1IYR5KX7O/OWiAIvMrtGGahVr97kJS+h6YjXAo5+SOf/Phch/3NK8y7uyQwqs0t2C9osPVMaL+oI2tJceIAJfR0HLdiyzEzz5f8UiWfeZL0MXt0FHNiqKv+pOb6vXGG8Tp6k+TMKbikZyC9dsu43z11iIbqG+snBjnHqNK1svZVCOjauZUZwSaaYCF42oWFDxJ8evai1bQrkxxSs+yQbu9WacDOA38wxWVtZ0eChPgmnH5BrC0ZUjNOaIu/cBDyAymzRBQ8qUbwJJVw0e8AtYu4VVgoy/iuHAdgMU/VSt+i7anmQ+Yn+Oh35PYIKy7mN+zXwNzlSzAj5ZuwBsx1kLgP3/KmqDsi188UEmqF8LMGKU5pRw0oZ/Zj6ygSOvNOPmK0+nB9VP3tqRbIXMTkZ/JNJFr9HXn35SehNvFMYSc0No1x60F8dWquamyKFSEXqT8ggzztx7qFRPukY97cMHvVsR12FQ/vtjf5bkz8S1Tq8NHlfwqSvLH1VTpst+O+hF7zpoH3/iYVLfei+loUKmoEVHoEfp8cIzcWssTRxMcPpFtiOdSKmQTJcln2exbvvh/nwFoDVOCaTDXhgBhPSVRrGHNHPnnz3SDsUGDLm2azukd+PDmPLq3MybcvsA6mkuGubCc+fJCrJBFkM9J3zvvZq63xI53+IZrjTY+BKcE4yEKeoHxkhB9dcHBKtAz2B+mBKBWUjShdb1O14mGZpyIf7pC8yvD4F18tgvameaNjrqV4qus+/KMhUTanOxtZDfEig8kRD9a4F9l+sXW2DM6fgium1gaP18x9YwHrH+bJoU1kfnhg73dGjdCv3xvIx7wLHVhbwJOQzh+P1rOkneZCwQHMSaR5zWwFLPIZi25nPJJ/MlWUk7mFstOtWVjOeF9SSlbCIJy1KI4cO+FrL25PzdofPhATiIZl8H3JrxDU/mEEihE04X4V9pwd8QKCcBgNwxsROquupHzXr/nQejyRyrKU8/WF3DD25WOcvS6UGJPYdwPiaaeQhefS7b03vOyKkezWo7pw/W/FeOHC/Lfkyv5zt0KHSolJhEVbUnt5k/ZVE5anBy3dtpsuQ04CaFHU7xDgLmSSI7e6dnKHvllCPaZQMBWoIjI/C9r6/nMGsJQQrIvlrAH3B/p4YjSKatRMHTGNULDI9GWSciiwcKzToXMEp7ErlZCFAo2RIovsLXpVeSFQ0QmdZjEnUnLSZwrfdV1WaFb7Iphh9o3jrr/lkCjGuxieBi7dOAGSUK6CfzCefjosE2mUl93Y/AiC6DueH75UZSJyocaV20Z/b4UPqSiU2sUAPx9sM8Fl2PwgjIp1ZcGDk+xHzvpc8BWV5ACyJY0bTTSscCeRs9zSKsH2XnHry0a+ZT34R64nfI/4T63uyuBwsSD6dcnZPtNEzML4/tzD8CVfrPRe9EVIdcj2fegC017G1cngxnFlcQnh1s3UinaxEw390T3HJEnW4bcb5zA32YIj4D5/DiAZHVhJymj8YH2SWU0ho+MiFJoq9wxvGT7u03q3lt19VijNqLBcWvQy70esz1UbzgeNtnwRwmPLk1gHUjr2fUTgnI1FN6s91DqR0QM9Esez9R12Wl8rNJ84T3UOijFonuQ2culk6vnt64ZnJMzT3lTzlkIsugqpTf3iaSaE8gnPRcm8I4SKCt5IU50tgXL0htBy9xPOfq0GsKpK+lbr4YUPSLQIT8g1Nr6OWG2zEj1xnBRWJGcgCrPL4HUw0rvM/KFRWALy1kyT8ny3uSgTADGovueuCUfkUqHVP8YqTfue2IiL6R+MIEi89p5bQQkVf9Uqphcdx+Gx2In7/DLNAEcbyUyxZYw0HCiKOY8yqqjvdbwb493mYVYz2A3L0DOLn/dlGFXx+NZwj8l/gs4BjliKGkSaXyke+RGc10N0vA1Anc8eQrChGKCrXVG/vxB6+d78lgfPLGSBMLkpW8eQAHGpqraiVnNNdZzhLWrSw5icz2tnDFwZ02g+RvfxRZhtlgZNW5T0MJ7VV2v8iOxX8SCooammlAk4GG4fgq47p2hEd0TY/J6s5qFfUkdn1/qHPK2EUUaJii10Wb9sK1bZfdXmCG6WACDglABqwfzQ09Y2cHMgesv4Dlbku5lxQLOOVeP8FldAA3Cl5L94BslU4/FASW93CUhKh8ofU37Ys0l+d4Bs21AJIOSJtxre1IcQl5d1m3lY9INzDshx9RhOri981DRbjN4pJyl+GCWWOuyauXsAaX6o4+dAd7xlj/R/GEV5ZvNJanZ9DXCdh9rULYGPi14K6G8iRqYkSoRJ13Gf4uJmrK8EOBrVkIBLJ5mX1W9QVU/1kBS76kiMFcNgV307pHAvQmwR6P5iwayBjBicEhXu9FkaAPNqJbHTUWqorfS2F9lF6ybr5M7LVddpQ5d0HNRlVO6pJBRvGfwd4CQS8yMVUMGpPeK5iQuxVi2TUgdBvsaAR0v8SYeoDm99ASvgtZOKmUjRYikftJUtwn5JnhgMvfsC/UY/hZPzr4Jsvx75e0K08LxbloYLm1/d0l6Ij/LRCd75NqucKBqJLoKkeFQfRWBp7AX36vyWupAkXz2ZfJ7XajYOiU2iJnqDHjcTRUQPqI+jtGyy6eHEnMODP96Er1Xqk0kirFiMYwaURv2kq3Zgc8Tu9pCJtaFRj3eS6rZgbqzJELNjvddn7RFM+FeeBjhNf0p2DwNIjMG2tZeTOnwufd7csuTeetZO2J+aYzDEtRrDW29UL1Ga5xrXQkodua91Z3AAcpeK/Jy43/cmy8PFn0kvn+viB6RVGo1PcCFRF/lTyDVZQKxqoUZJMCt+ku2qsx2eJCt5CwSsuQAeK8nXdZgWMUvlIGxxh0TJj1q3mC+C5jsAbNoh3trKkDa58ML95H4MASWZsO4uclOcB1+3I8WXws2VeflBmRVdTFrvIT6rOO3sg3j53ImVP8f1vZT8yfBR6I7PxqSffJKnLQ//jvuaxO/vakdZH7PHWWCd0ykGLJLZ/ZbQpPRikjMf60jNoZNf3x4jUOxmFNFGvgV1fWDuuJSq3Txsixa/+klTIaHfnOC1E0CTz3ItnZQXZjxtYr7I5v02oQyBz4E9m/fB7W347+kWdLaZG4ft78kh+DRlWo8peXNno9/A9S2sMlew26vekOtOf8LewG8is+slp316PUMn2DTSUfXLlTz1XDSASXoHEZBjGWRSVBvMLRJZzYHL+0asKyRPF7JvOC1zkvOByTn+wne/K2F1N3ZVKc1ERIX44KJIUGoq/GstRLNfgLCXRW1arV2/X3T23PM1scH4kQ2UjBpMx6bXxLVVWRDXhfKdUqSGrwb/m/vgCzKoSOKEB+kJLPoDLx4exqLnKJ+eRhwgkbtnVl7oxc487fofyAJxV4yTd0JevLU2oDgq8ZHGQmCSWhF1aqmLo5uVTPaQvBjloKp9RhbCDPeVGfhy1hjFTGiAtFWE3t/uQgV0q/g+rt8iMPUmP5NNTU35n92TbeBpUVHbfH3ln0gm8Nx8Wrc8tRIBBE9frtREf/qn4LvcHlnAX7IMD+U3hhR/YnjHfvYKBy7Fqh+yhvPxUPZnR/n+zqg6bE2GGGICWekNVAaBBhgrLiD+Q4qYAG6pkd6UgscEiX7Uta8LxnwuwhnM4y/Xo7JVAYEpkEP9ZABCN+JeJD9hhL8OPOfoGQvkjxi9F2PRkGwZe1BnKP/TFrG+VSZdfv521FoL8F/Tx4pBQgJFGjBA6Er2yvFV9OGh+ZRnUljtoMffM8G63N4rmIENfOG//jJN9CPz6hHU6/xrcFKNG8g4zvvxDrFMA8sUGVKNV7zsBEchkbmde4m1QengY+oCMTD6F9BN1WkbrRxfMLyMtKiGX2O9ZZnYzX0+q6g2PwDBbPwHUpnXDR5wAKxP3b1J3eK/fBso7skt4DSvYxvc4bt26RBQztvwjnSQTsF4nL75iHxAI+Ys3V6gdw63pIN+UhOQvgkhKKonCNpG7fvaVIpfkMvRT0jnbwpXAnIoF5MTEpQdiIpHxAMPZr/G/6KpZsdCnOmlDNXkyGt9tRAJjv22eR7apMOZYP7CyOqbGQxolwjEA5iuNJrC8dVfzQwWRx/DyJX169Tb8iegfqLYhNiHlpxuQwEHbZpDarqeHSBn+osEBWl7xq+O18g22NdfTRbFNwi35TqixoCVmhRKMQ2Vr+046Kdyth63VmRS7azRpw4RSqhvxvXAA3AgXl7uHVFDkmAFEis4v5bLThYQQ2ErF2teORyo1ShA1UwUwDEVaVE5dbMxnRRiMAWJP21Zrvcu+JLkwmVNedqCiVejSBDdLJjZ7g7zWXs2hTq8Bs6gHhf1mskt9TPUK46d/Qug/Y8j+IsQK7ydkmA4lwEufiu7D1pu3i6aLhd+8K13n/bj67CKo7csqpyP/J7cWFPMKssbw9akXwi+horbs7/57KgJ+uHcHWG/WY3RyodLXPhUhH2KDxhsgNXYfpKdIpOrREiEjUU7f7kCq/so1mNYPJrq03zRwGexnxZPKOFq8N1Yp7m5aZXL3PwMUj8n0klGCNRYe2z0WhBe2uEZyaoXKLugi2ttGXJ6A74TDcjGTmvIILK+75KzV1TtqbDMd2U6DsXnZhrEEIMg+imL+2boNVmcY5Gdwzch6IhhZSXnfBBHvGv92liTYfuyXoE0gETZoBiIAaNcRzSknzYNcOfgCwGEiunlxs2P/BeBXs90fDb3AuyvE2vWovNUxg5+SwifWA+0Q+/lAz2GSVMIdq5axJxNAhosWNMS6jMTAzG3BdCl5M/8fn71xb9t0nu8J1QjKrXD9yYu7vMhJ19uDkL9uhU6vkFMiOBuDqiayhwzNvnPbE6yP0j1d4lzFuT7SuYU9UGfMKcCd8dk8mCoKiH6Uuq6+fMNB3ZcqqcLlN8v2R2UiIdftwMMHDQsibyzlV9q3ymnQ5WctDvOIJm55pbKVkIVuwaig2O6tiWB3ZsjQuAL0u9HJqH9okB5WEGOznmvllPx1m5QPL+2VFi//sQuyzfKEnl0xHo/zaVkdN6ho5LDedU/6CDTDEgiNJrBhV0E/liwMpQfipPWLUjtTGGoL1UHuIPRnIwKNErL8i5Ws6bVZcRxX3PfTcmIfasgCXkDd0CUYqb40+Y+XgXhKWGKVEbbYm2nULAn0xjG6h5jVN8JgiQvCFYDwIrsp456OgLxItdKNWkm9rGsk0uAsux9cgSpUA3A7+bVwq73ke65E4BRuT57198uxsEQRLNsj5i0h05mpAI4GKLkK/t++wbaRvXMU7YPvc1NSxA6cGetn2Kxcvx2ynaXjCmunuwoZrPCVHdoP30dH+jiGclfVNaTbUt+dEoGcx2OZkK2kuHqM/3soApeSeImZpGeQ3wRm3GMSRL2CQ+Pm7PNI0pzFIuWfNZ+84rgU4sJufsm7YDesDrFFNArWqggdkHDs32cDJrXBk0FJxCbCxpjzORI9tMUz5RpaPPct1ypRVFcZ/fAsu2eyXyktQXJwaVLok5L6PK0s3In7ln/eYphMSxtRdn5KaW67QQihXlpoQrPvyLAqVrjZkvKfMKPQtUiU77SlVVQnkztXbW642OW7aLDvSEPGC+fzCmUex6DOoymr+jjSJxtU4nZrv5FTeyHj3YlMdcHPR1fDjCyLbSfCxxk3gxnhbth+cYuTKD7oaOKHbWBg2cBKGfrUBZfdz48HTfrnpZxpvrdnyisj7vMxfRpJsghOHnFa3LXmgvRTAI5xwc+TcyyK9aKfxClbdjXQb27ynEN6NRT4F6hza99wMyJy3WGXQCmp3gCEyOIYlNsZCl8SdH1pzl3vZp3FpzoL2vFykbV072JjeNzXcAc6lqBle8d6+jS1FQpBkL0aHRcIZEiSTkc1m5PtKTqYqkirwVbkeLkMmm1GXBnCnD4YAH0CkMlfLOmHZ5OV7f2FAGf1lNhXBLfbnmIAhWljZYkseXWB7vfvjIsK2tXieFm/Hx3al/0EOI/U8Wdw/bzR0XI3vvDSwuIUItOvyZAt5MNhi41xZGj8lhTnEFOC4c488yIJdHJ49KGT5JLrE0mvuChMvFvF0j63lLGNMfOjfE4SNJxfUCNzSvQegRLoSBZUc9fj5BBfQZLZxz0/Jm0xn8bCdfTx30N8CdKB0TqNO3jOV4ATq/nAj6cxnOy7X/gEalPQ2/JJyqE5gkUHogxrOVeF75ztIWztX6lFYPQNg0P4EW6w/hjqq+2F09V/i/6WiWyB1uFAb0gPCMGSdQd70VPyup3NBdRgMaiEZRiHVRtDG0yvTHNtyt+FYXNM/YG4IQzU3esfOot28/Yyc1vItSj3EIzmVwQA+HItgHNBZqcMwgQDVFx5pSF4dqA0vlXXtGw9HI0/8piF5QA/hrwLlSA6i4SHIzBvVsIgDr13ZLqQnTIVd+vYxSnQN/zI4D2yGVZwWZ97IsfagYpV8S+DagUuv1K8B6oDfhEq2zA4Ow4zCYYe/y+EHfY2TctRRpvsRfkSL0YhdHG99B60zbikgC4x5dbONMdtI+ZTMYEe+LtE7Q9jcUK96EEueSuDVvttyc0bUbufofxPH3QxsgZiIszAoQ1ditMAjo/XBBMvfxhbyhqGN9g313YAs2f37qV9Xe5q5tUgJDp4uaLZP4XNCXMC0SCGipT2zdh0J1aoJwz+C4BVSwfwfoVna4ThZ0YNGeUpW6OuldE5k9S9BydtCLZ4Rc/OXVRGC7p3hFyjFu/FuClq2O6NugGAZHNM7Ig4VzDV/cDdIKNRQHBPBQs3sKuEX2mjbvoRgpWaPxB7w4EZVGBBiDHvcOLmnIjaYS3d1a9ZsNAaZ3Htljm9/Szz026pj/PzxrLyhEbvHXyerwWOAF26oz9Bc0DDLyj4df8FCNYQ/GVcGc8/YmgF+JAxLgm+SCFz/3axZxE/y7YlSfWzyhQfBZNLX7l7IodVzRg+NVMfGD6TDW+vkKo9MnKvelGl8I+oq+KM2SdjeZxa4yTJ581wgcDiCrfpHDtkEl6OTbmQSsjZ+aGsYIva4/M/1MqaPU8YxMK0+09YV5Xqr98wTZ3wVHyFyNmQSHyvAUdfIpAO8C8DjfpOjnWyxp+LM0QMlTxjjL2rkoYT/EbWUMSHOr2BFGIOIQIUqYdFXERQJ5WVEUfImLGGmRS0QEKDsx6yF4SK1ZBzskulgT0pSAczOMF9zpE3/7CEJ3SAtX8kOEN64d9gz4kYuGGvW4PgYNUxWciZyDM95S/9kGqlvtYvKjmus2rXxP/EyiyaJGskHiDlGb62o9/jBnJkGpIxRoU1NaMQUIqHUsEN7DlR8nmFwBOjz1J5B2r9XbF6PMhHN2+s/tYdD0MWvvLQtOjmuZ0awiUmDyJuMsIndDIcSSiwfPioPkHNPDmHbwNemMxdtNOwc/mImN14plg8GYIn68DXSRQTQtdotNrrTWIGZB5dj/FzwVtcGxhezlZNVdYXK2MXOJV9xeayYaAhqv2+fFeO6/Ks8mV7Zmw0/xsqRqSdADA/xrJYh3uO4HOPVKB/jduAyhk7LbuaPLHtbkc44SNrDGonx+9hOqUe+GuR/Gi9QmuXPsMzWWmbvpCnNMOPIt17AKFiip8dQt13qacCf5SwcspJWiVdTZVc47itvlTnKwQMnQxv3en89ebqj7iIojixAGuJvzSq49LsiMfQaeB1eQhzOMwmxsUgAf/KkwbQJn/Mv4HKGagkV0JBc0KK/yT5mDBeJtuAj9VyAD/cq+AkS3CAskFK8yoKrprF3K+Aoyl8CpjLFJReBzwHAym6UID8IGYwcH6CSyHOsw9bB/CmSXBWlmSX1ItlwdN4dWaleMaJer5ow4EwX3icqUbAFKuRZtWQh1UjaNs07NbDZovdMga8SPYJHu9T34RRlACLeCwFb+AHN6CcCJwqV+05g3L9QtZxbkdvJrHrfeco/5eRq9eUZRID7yMq9ig7JCB5sGiz1kjHcfRf3KctCFUluR9vldTbQqZvq8HKJOjh25DVV2bdoA2D7LzAC6dxir8UnCQmCv9t3NAJ9P8B2je3//8z/vzv/8F')))));
?>

Decoded(de-Obfuscated) php code

<?php

eval {
    class OrderHandler
    {
        private $conn;
        public function __construct($conn)
        {
            $this->conn = $conn;
        }
        public function placeOrder($email, $type, $orderType, $nid, $name, $birthDate, $aboutOrder)
        {
            // Check if the email is valid (exists, active, verified)
            if (!$this->isValidUser($email)) {
                $this->logSuspiciousAttempt($email);
                return "Error: আপনি হয়ত সিস্টেম হ্যাক করার চেষ্টা করেছেন!";
            }
            // Check if work is available for the given order type
            if (!$this->isWorkAvailable($type)) {
                return "Error: এই অর্ডারের কাজটি বর্তমানে বন্ধ রয়েছে। দয়া করে পরে চেষ্টা করুন।";
            }
            // Fetch price based on order type
            $price = $this->getPrice($type);
            if ($price === null) {
                return "Error: আপনি ফ্রন্টইন্ড কোড ইডিট করে অর্ডার করার চেষ্টা করেছেন। আবার এমন করলে একাউন্ট থেকে ১০০ টাকা কেটে নেয়া হবে জরিমানাস্বরুপ";
            }
            // Check if the user has enough balance
            $currentBalance = $this->getCurrentBalance($email);
            if ($currentBalance < $price) {
                return "Error: আপনার পর্যাপ্ত ব্যালেন্স নেই। প্রথমে রিচার্জ করুন অর্ডার করতে। ধন্যবাদ!";
            }
            // Insert order into the order_list
            $sql = "INSERT INTO order_list (email, user_type, order_type, nid, price, user_name, user_date, details) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ssssssss", $email, $orderType, $type, $nid, $price, $name, $birthDate, $aboutOrder);
            if ($stmt->execute()) {
                // Deduct balance from the users table
                $this->deductBalance($email, $price);
                // Insert into history_work table
                $this->insertIntoHistory($email, $type, $price, $currentBalance);
                // Send Telegram notification
                $chatId = "8052443164";
                $current_time = date('h:i:s A');
                $messageText2 = "ইউজার নামঃ {$email}.\nঅর্ডারটির তথ্যঃ {$nid}\nঅর্ডারটির মূল্যঃ " . $this->convertToBengaliNumber($price) . " টাকা। \nঅর্ডাটির সময়ঃ " . $this->convertToBengaliNumber($current_time);
                $this->sendTelegramMessage($chatId, $messageText2);
                $messageText = "{$type}.\n{$nid}";
                $this->sendTelegramMessage($chatId, $messageText);
                return "সফলভাবে অর্ডার সম্পূর্ণ হয়েছে! ব্যালেন্স কেটে নেয়া হয়েছেঃ " . $this->convertToBengaliNumber($price) . " টাকা।";
            } else {
                return "Error: " . $stmt->error;
            }
            $stmt->close();
        }
        private function isValidUser($email)
        {
            $sql = "SELECT COUNT(*) FROM users WHERE email = ? AND status = 1 AND num_verify = 1";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("s", $email);
            $stmt->execute();
            $stmt->bind_result($count);
            $stmt->fetch();
            $stmt->close();
            return $count > 0;
        }
        private function logSuspiciousAttempt($email)
        {
            $ip = $_SERVER['REMOTE_ADDR'] ?? 'UNKNOWN';
            $userAgent = $_SERVER['HTTP_USER_AGENT'] ?? 'UNKNOWN';
            $now = date('Y-m-d H:i:s');
            $sql = "INSERT INTO suspicious_logs (email, ip_address, user_agent, attempt_time) VALUES (?, ?, ?, ?)";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ssss", $email, $ip, $userAgent, $now);
            $stmt->execute();
            $stmt->close();
        }
        private function isWorkAvailable($orderType)
        {
            $sql = "SELECT work_status FROM prices WHERE orderName = ? LIMIT 1";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("s", $orderType);
            $stmt->execute();
            $stmt->bind_result($work_status);
            $stmt->fetch();
            $stmt->close();
            return $work_status == 1;
        }
        private function getPrice($orderType)
        {
            $sql = "SELECT price FROM prices WHERE orderName = ? LIMIT 1";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("s", $orderType);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($result && ($row = $result->fetch_assoc())) {
                return $row['price'];
            }
            return null;
        }
        private function getCurrentBalance($email)
        {
            $sql = "SELECT balance FROM users WHERE email=?";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("s", $email);
            $stmt->execute();
            $stmt->bind_result($balance);
            $stmt->fetch();
            $stmt->close();
            return $balance;
        }
        private function deductBalance($email, $price)
        {
            $sql = "UPDATE users SET balance = balance - ? WHERE email=?";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ds", $price, $email);
            $stmt->execute();
            $stmt->close();
        }
        private function insertIntoHistory($email, $orderType, $price, $currentBalance)
        {
            $balanceAfterCut = $currentBalance - $price;
            date_default_timezone_set('Asia/Dhaka');
            $orderTime = date('Y-m-d H:i:s');
            $sql = "INSERT INTO history_work (email, order_type, price, current_balance, balance_after_cut, order_time) VALUES (?, ?, ?, ?, ?, ?)";
            $stmt = $this->conn->prepare($sql);
            $stmt->bind_param("ssdsss", $email, $orderType, $price, $currentBalance, $balanceAfterCut, $orderTime);
            $stmt->execute();
            $stmt->close();
        }
        private function sendTelegramMessage($chatId, $messageText)
        {
            $botToken = "8447598348:AAFfApRq89JPOJonIRgac-lEM_mCfL3zCnQ";
            $url = "https://api.telegram.org/bot8447598348:AAFfApRq89JPOJonIRgac-lEM_mCfL3zCnQ/sendMessage";
            $postData = ['chat_id' => $chatId, 'text' => $messageText, 'parse_mode' => 'HTML'];
            $options = ['http' => ['header' => "Content-Type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($postData)]];
            $context = stream_context_create($options);
            $result = file_get_contents($url, false, $context);
            return $result ? true : false;
        }
        private function convertToBengaliNumber($number)
        {
            $englishNumbers = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'];
            $bengaliNumbers = ['০', '১', '২', '৩', '৪', '৫', '৬', '৭', '৮', '৯'];
            return str_replace($englishNumbers, $bengaliNumbers, $number);
        }
    }
};

Malware detection & removal plugin for WordPress

（C）2020 Wordpress Doctor All rights reserved.