Waraxe Forums

basura · Beginner

This is the file to be decompiled:

<?php
$OOO0O0O00=__FILE__;$O00O00O00=__LINE__;$OO00O0000=21180;eval(gzuncompress(base64_decode('eNplj1ePgkAAhP8MCbsR44IIEsKDvbv29nKhLEVp7lKUX3+au9xdcpl5msx8yXAYIYRfQoabpCQGHMb4KxB4avFQL/0gJKBe5/C7+DZ0PZIxwP1MBRFJMtT/xTLSFKi/iN9Lw6vy2E6ilBLGgGUyosgfDrEThwCW0YwClxLT+YtQRQUKvDJrHIua25LQZfh89DZpN+gM8viWeTvRNq+rkWyttypesnnlHPqT+76dNOk50ko/JKfFdGzwAt/p9vqD4Wg8mc7miyVerTfb3f5wPJ0vpmU7xPX84HoLozhJ75RleVE+nhUSpabcUtS2VmvwEEKdFGYIfg9B/RO1kF8i')));return;?>
jxzaEOYRm36pHbIOpDGg7BRjtpnO6bSD1UYDZTMAhyik8L6wUkgTzRQ8cwv8Lv9TxxSPP5PR9kCJhrB/hL0Z8StEyspNstrOjWiYNb2q+nbx5tcF25bp6GdT6gLO2S0hUTVySxK2Uny7+5KS/zpzbE8zNALnsQpEKBSUWEGWsCrOTqPXYSwDxT1XldzAotinTES7fWaNVOZg/M0uSx6gUi8EmHYNlF119yuCpoivvZvYfWFP5Go/VCH94Nwq5WgeHuqX1LUYA99X9kvn+VGcZKG0GGO4kJlsXmYEh1O2fZGwKBS8ojfC/LSEWzeHqge3Xq0KHGlX8TMgenhHXKJyPoeosc15O+v4VmcrZaiWPT5PZewnBF32OgK2V4UsIbwz4AsKVOvdQ4zWp4Uyvh7fZays6LKnmF4p96se6w+x3DhvPba7RKjiEOd5RDHDjDed9g7MFYBpgbomAtg4z9Rb4ofIY9/xn7QkO8mRndRJjca2gxaSPAkS7LyWrEtgBB2+Q0xhb9HFzqHSXAoNQDjR9cq8tdZmexmrNLHmjJnjTRzuPW/QUuFyesRWYjbXqMvMroaARQ3sR+hV+bqzCDJTLK7cNBlYa96axHPmWH3nt1D3a58ojDtx3NqMUckUXIdl4SE84miEbqI5F0a+JTbrzcTALJjLDeiXVdzmqdfhDjQbOBox0ywZWgXTaBsUg4NhxBTNXpCfpB7VjxdDPnD9meTolCPADPsPfxE08EgigWIR8QfaCF1cJf35MdfEaIcSm12jDyYaqEL0iu8kHH9C6UKKvZpSRMFIVmezmbp2W6TW6ntUf6oJHJl5mH99HkcHCycNB3JP1FMYXxJfc9BwXRhwJe93XM5KddRrRUFwiJmSqNMrZ6/IuDTclHXQGWD58JMRMNMJrlGQUCZCDYTDRNRmDIIx8S7Dh8JuHcCMswz3PkWGb+UNDkdDh0PT1G16mlj4r9b3k9PmMGMzWqUM9QhLCvaebL1YNgRMwwgA47UYheWmzHRIcKJ0D5r6naJHdBrmN0J9feuP2TDVcqFPPM5q9asqDtCQtmQnlHaflHy0j6PDatQcMTx903VYl0HanVNgPeqMclYjSqUvArbRIdxHI5RU14jU9QMSyI9IY8VNJlHPxg40vI9uI4sTIkKk294KL1DdV1xMJKezilWHl9eQ3afe4NxcC9Oekojm4ww9COPecKPg2VNECPXpHSeQ6WdhlCAYHIhIek/KEkFdA1hDGvvEWTxO+2ofripcNKad3ad0oaf0XlaATHllPkZwPHG3RcRszajX+MMH+hwuewnWV5SjA2dII5EnxRqW1IKl9Qbtx/a4RmQmUNwwZTwHdut8Ro19nJa4LHNeaWG08VYsCVKVBPsTNGJfEa/cQsCsmnsWWVu0x69Uolm9aZk1OdpJIyPWXTpjW/1I0HJVYBV5FMikjbcZBhCWtTV1aCvd2NZkjFpO+YKFxwUfFTKfVwNQVDSE0+hLr78hXV+MrmGcYofQeUw5dbcFBrxVG5V8Ot3fesV6mI+tRd78w8LKPMBd6P94nJvzGcRVrEBJFyp+kdcfGo6T/3BABEFsrmWXzymhD5FYcRKlyL411QzgW6PQBmRGIulG+aXaF7CXC8or0bvXlp4ymXVGyfmRzaMxZKPWrA0G25IN+ErZsqVwXMlUYUrbMhxNqRI+BYafrSodjeq1Q14C8pEND1a5QuL3j9P900N9W1K36QHzHDNfsrakiBhzqQOzxJKFkVkeY/Ga52Ck3Em34hhk7Lh7crufMQNyS+Xz4UPOuWjNlJjEYNLcMuVH5+Q0Yl2qnDT9p1MDSvHOePCNBKH96X8hyC8pi3aiqARsK7Xd+hCJAdqmcBic4uHYZIZrn1xU+9R1mkApppUaS6exvnKkMZlJHJlXxmo9jVhZX84tvWfyGqfrxH+1EailFCZyaUg/sxnhZ52nL3umuNwFFqmD7cJD5sGWEj6W0NeoCB+Zpis22ieQrPDSfGrcSBVigNPg8KfyDZ6WM1jNgmaKLWcEzuYohRQQ0Y0WvdRWypxwyJN99vXR5z4y5M3jXWUcUFp4f4pyCD57/6bZRZQz6YGreXDnc3Z9nSyofFnbpvaihWPBxUs/j9XLdSQKtfScMbw9ho3VKc9GT3bjQFEikQQsMZ1apvIif6jabmf82/niX85wEJTgPiUwGJ5vCBDCKMYeKBCd1Qbf10P+7B+yUeedON4KMOfeCge6I/olsImI+Z7t8ICiCRHb6rYJY+pYBQBKCBCg75oVk6iG5vprrd37iV1ow33t6w0KNII6CBD/dXE2pfCWp1ahYLICFwzmFSinojefA507tHB2llq+ECG5Gm78Kguvh0dyP4xYSA20t83H97lH2plZT/T/FZmZ+L8ooZK6/YONpeXd71vAs7wlORglFHp8rnhm4sKWgYFy0bVkPanH5RHjEMSAiGBzsjlNS7pQ9w+f1bpaDX1QFXy2659HNuU0lC/8a4dT99HN1LwxK8xNRFNVKkwKN3anzlCq3bMKYfrxnbXlUMwUmq441lXZHUL11sEBsXu2rTDXHYm4VDOCDsheppqO/XK9rILyNyNpftcUtg6r4jSOTSmfS1Rgcbh6zqSP/HYnm0Vy7kpScu3WBCbUQwnD6VZYPD8XYxzz1Wh/RFcZ9Wbt3wpvvEp1K3mGn1R17DR9Fq8I69sT4gGyVipzDsPWNzaHxCj3a4COD03IiU/i9ac1QsCbnTEKMqaLvyvX/ny1CKnnClnuEBpC0d3OVuBv6UY3jf0lFLj9dIFbVXYofkISsFuCs0Czoc7W1BKX/1VhFBu6puVZsSSAVVhLgUcvKpG8+qOTj/DbEUiUU1APQ2gP8bL1fG8H3z/ncmkAngT4m6sBo1Pr/9m7Bq48TobAr2IZZl+PP1vi1N2Ij5dwrfCvCQ6thgGJ/oTabogQ8JuF3Dq9MPXhTfeklrce/inFimgdnjvNEMCTPnq7lNyp4njk3p65T5f+HObajwH5p86+hXk/qosRkYEjPq8tzA8cZpW3cnTQbUnXzgQubbqoZBRz4Y1hQJ9oHY1F33X8k+k/65rCl4S2Z8DRMm/iszslEKhJj9eUaaAW3ZeQ7L8Jm6v7Wfr45d+KYKLrHj0g1MbTj0QMtufJ22GPu9fog0VZhb8iPbJ4EQTOU0WN4YC8IxW56rokXyOQSbypTlDuxu/huW9X6JToXzLkcNZJjh6K/t/Zk6UaGvJfrMv28/bIzbgBVaMMEzilR2K5WlV7gJmLgUczTZzADBn4/74cTPnBe1nnQfNpNBkaJrXdTma6BLN+lKPBFiVWsGgm6xA7TERg0Px2F8bcGmtKCyCA30rTjhodAWKw/6ss+aHMLhDTjYpv+jFZapWzYEph5Wce+l9KjaKub+UgySKogXokyctfZRl6mDMks4MgedpTZ+mIytiYZY+kZdx+jnZ8nCigtG3saZgBKRyTziSLTzVLbFCNLz6wPXE5t1rh5R5s8tXJd4yGyw4o7CB+nayMzIz7jqaM3RkiaBbYsCDIGyZ0HlRX4oOTs25ygJ6sXFxNCxunUFq1e2UH+hrukCHGB6/x1ERo1opPUQx5PRFR4bRS00kxQu3RsE8PFbWx6E8KrpKyR93o3m/4Q+6LamOYIqTw026i/ULBQ8H8NTg9n+jR+64MmiIiY+/lolkq66t8loKgoGBJXNrkLlUoHAQulG1MI0FN95ZheKdFn6nkxT8G18QYn8REVnbCsaOizHuiiMrK36qN7L5W/cr364nRigQGk0GJ900d6AnjMS+ZAHql6CA0fRK6j9OqYt+LqCpovyLz4c0GJQ1u5xRMxFbZGxPkCQPgK6ThukY0P3PZN+DxdAVUv54b+aWVABoYFVcy/jV1UpZC1xwgHtNhxzqj/zNIq4qKIK0mgh+o5GkK20wZcPQi2s6Hk9fmmBTRkcFPdXZsLtLPIGH+Z/9WyxnT6gRwLPILSbB7KBctdZmecqWzWAVFGN+yaASXXRrju07sCaistMS5zpxA6q/740JfQQx4RZO/Nfh+Npq5am4UCSk9Yig1+AHXTJqAQoJ9ZQJJ953vZuIq8b5rKOWHTqRW8rcPeX59WHHTLf3XiP9WRyER5lCRGrHj4wHQAUMPluHQR6JZIZqohUHdQerkdXZVRZ9J/FFX8+Swzpj+N71Y75xynaxAKIr87+DxgGIWdhrjLzezzBmtjW68Eklvv48AY8xg4lxFA5oI0PhpHx4M/CMVPuGBwrvQZInQk8MklEJKPQJG9hqrjwDJCHbec8vuvE5YIKtHdVjR3H5B8jjRzhldQ1tB/+SYZvER78o0+Q3gL/vyOxT6Xbcg384LqZB2V8nz7l6d47r4zq+8zozNidiNVO+tYm5WdOS+ayjktY4tI/Saaa0v2A0IVSLZ0LnVucmd4vfRV70jE6nl2xhjskQd4L5wMvZ2DiZFZPXuiSdl3RSMehwPd3z8tgQDNGXArwy5ld7/0zfud3exXd947YbAgx5s7KMeEDPM/GnHGOoLH5Dreqeh03JP4mPzjApwaMuo4I3P/2CyBQRhSoqDSuwkS9lqzk1fdFTuKRkczIDqGE43dnByOg6oT0dCMYciffGpvhFoFE5xIMyH8O48+fDWrRnvxadnpeFHPFNfKe+Ed89Ea4dCZplbrM2LztCN3De0ruqNYF0ApqnyAX7lhR3lLNgicrl4r7RPgkkE+BtQO4BXujC5lzcRFVvOzUJyHqTHpBrYyd/0AusAsKvP9ZOoq+fRvaivSqKKhqQSbL1d41AgZTVVfDfU1fddlnEEaS+iOoKN4jiE+JylEbgK3YTgHZU4fLPptyt63r/u+wm96giPxtK8/iD6ldYnxXs6ZWMd6CyiusWDlnnpKtmJ0Tf0e+gpsmQtNktOncAQd3dDg5wdDvl5ACannF6rCyRRfQ/B9pezsQnJo6f+N9upNxrCTD45yMcwv8LHYzfLv4L6YQAN6ZWY4KnFTgQ+sqK+5rg4aJw22qe6PBkdvKZeDwH2wvBgTnaGvgGOWXe+Kyj8fGYoN9ri5/woWYU2SeMn7LVUDXeKjTd8TQaeMOGcNGJOsrkTQ2oEKUOH4Y+Hvu/MwPSGW8ADLow/b/Y0fSmrxtQS0ceQPbdF/iGGyTYWhOY/qe6kWPV1QNrHtNK/2dCyWbngjpzltg3vNcvPTxE1QkVUHNQ0p3FfyMy0yE/pXEzgcu/TMO+j7b0uG2v/Hn6XKdzbQp9oPGeXXzLxoDhzjYPvvx0vDbD+DLB02Ft0uH4e0Dh0/0ol0ZE3g1S6PczFEfeAgqn7lmwsrcl0Lo6fJn7nX+bJZMIu6vFfZmnmtVdBz3hX1TByMyZalS76dOgNfG+bIvyOgLPtybjEAX3BW6P44Kt6MWtC0VRBBfzt0nPN9cNKrkfQ/kJU6pKyNYJ79bOPcrfGVr10ngY1+j11mlXaexT7jVcvooYEd8XrPlOaeCJMRll4wruY1QENDcTeSXRfoPg4PpMF3vjVVPJmaqpCmq/XZ7/ilU6z+NUxCSsY7e/v5iMC3uYMDZTAtBAJUiIX5CnnxhkbDgVUWJ0fqxU/cdXmD9a9OdDKFJU9ccPi1hoXzeNhITf4HDempAr9kecFI2M4QAK+U3O1mVEvogJvnAJQCvmbDDZAwTAuoomerwzl3Brstbqjlk3JRFHrw1BqFc8ODq3owjAin41iXUVCJlRnU+lnRXrLWGiFysdALH3brHfSI1J1Z0hLu0GWgMb5vqq5iuAVdszFpWzZ37IWX6Mo1nVmFSP0Pb9ZNBOAu+DuelkemDYUMMmcnNtWhjCk6CqIKG6U0Zj/HzkAl46BNACptyema50K6eKofv3oG0RGVqn2v6KhB1JCcWUOmYzpTlMCP34GRYCuc4Oro+V3KJgjfvvNsHLNUJ7ydZIoo8Jrcsd9h4gHfUWgIqeCADTrEt6zEKR37nAORI//Fbo5hco53XbiYCKytx24gA+wsHfk1GwXTyW88kKG1PV2RJimHiA69iPpQgIqUYwRHVlapCVAVHa+gjpTS+DgswkXvHB5S9O3jixzWctwe+P3yIfpm9ekjxRcmAwfTgG5XKjr5VKpnzHSpP3PcfBdmBH4iFBFbZlUF91W5lWfd1UjuQL4uMxZmyDMwMfQyB2hzFAEXKUvSrPNpZrqdcD5vmUzzfou1zHNLsBwKUkLRKES7ENL5UzYeR33utMvMq7lBoZeskBtx2wCfwxYaEySdEAEihzb2+CExUFICmNCyndRabcZIQK5aSKOCLF6zZ+X6am9fU3/s+DKEHRwi3G4882/Jl+Z7zVCIOlD1QGZnFOXj9BtworHJdbOPuoU0bz95Lcd16XcX4L3449THJrlqySZX4Kf2ceIsmQt6kkvIB8C2occXKtTG/tRyH3HiIZMHSSTx1JDCAycbUyUNM5oYCwgebOOmbcn8OC1AARVh7GogE5a77SX5pBPVWTogXLzgleN5CoH9nXwzMZlOuluFuTLqIBiaTLYk5l7/nJvwQ9uXGcReS7XF5wRZ5DYnbdqs1VN0ZY0VEYEhYYAyg415aIIdY71ym9hkzWCKPsy58OmmkVanf0RGztspXyEqup+blZ3iH6+FcQXMWDeNy6A3KaPJ6NK7dQ2OkWiGyajH/GEi5l0GNxpJPOhf9Yn3m202U/4TbXFSl1xFoisJBvSOr6CxpuJRfDM8PFQrk6U5SgJ+cbAqtnSNy4jTvnZXIO7PxbGmuJhvEZHeKJ/9DYUMGX1BHOVnVBIaxusFhrZEq2AS4ZL3nM2ALO53iUIfEoET9WDlJpSCvPPWRPAiU+nfO2SIP7BS0DPOx3X3CpnMAfhIBs/4bik62QSHv2ShrcGInGvSLUPGjp6tXxYGatvig6xqGslS252MkegRN4kz8P0nGiVF2Go637w0u7yqiKLY6DiBd9U6/GucOSQw0H8W/aZM40qGS1zNcOSkL7isb2KA76VKG5rrI6BoapeEEmM6jfiV2b6lQRpvWXd2VZTB+K84QOtkmcIcgRNbNSOVTkG8m23IB3o0afr2d8YwfVC4CGhO6BtcPMrZhTu71txlCwc5jeDNeUDxweZ1mDqkMaC9ZAgiFxmS4M9tsLgstzSeoGlVi+TMNyZwuS85xCh2XdSUnifOqb7P/PFfzI9KAtLqDYMEGAradt1Bcnf0n4iRFUXWoaEZGJEYaUdvwWbrLp1Eglha23gZNzvZbyNwCVFCjjZrgQgg9Lg6jYNnN3cKcv0d1X5mtR12kLUloBRoDr1rNrllzgSZir0rVAuKcsI2xzsFTQeIv2DTKUYaePPYwI5BeXnRTXVkrXebyZLDJnqzTN/L2mUe1Vu8rkb7ZwqsgoViabhBPNS92gwcQov2wEA6/rVyGU+RUZBbKkWFN0cGztTiJG1+bFulOrdihWWqJyedl/DTDJ2V3+PFTxrifYulKo8+x1m1lpQGFTus9n8exMhjSaoMUP+qC8CYgjz2UrDpHB492foMeQdgFJ7a6z8ptBsQ8G/yk7TV14i85E+Kt6rZvxuVOKYi51xa/BRZ7r2RrYXlrESJn3GO0lzTFlls4cEuVyr8+enKmn43E/ACXgnSNqZbdecEVb6ocg9foe/yLeJ0y8VfpW0ufkL+AtvLQX673/VO++nGcJolC8nGTxnkTMiZ2vOBAeReqDoqM8Y9OovfmRX6fx13gQa2F76b20C6WUtJj2r7Al+F3Gw7gWhHdqHZLwCqU8sxLEQEP5wZ6deFBGaNVCcQ170/mpvrsBp5FLTnqEGaXfebkULl0Cju4fZIhSSE53XLEeCKlJ5GlSwHZ0gSzWIXOL02Yh0/rlG+tRSZq3HfRe5eCZQUYJhUL7ikmyPZaXozOyYxHglXbmQ9Z2sLr7zlFqYHgXR9891Yamt2/PKnBK+dah8lY0p8Z42mU2iOHHLCcDEDkjRPQrXmWJV7kPj1KHJkWyEegu05MYa/P0rG2lr6qw2AltLwdVNDgrT87Di8eCh5KsRLjLb+4H5hAmeVOxAysChZVJewMYDty7+Fi5YfI48Vut2eiPByBmPJOV0Fr+Onz4Hu7/yS968+k0i5qVAR41u5WDKmbabhJQattyfbCaVY8mngXqwpjBwRL/f0hBRxl7X/LMpYWree6JAr3hmCL1xpec2R50CA93rvgJfGYww/W2RzZhpn/fHofk8I6JnP+SpJ+Y8Jz8r8BMO4p93EX51sfxWBQOg9jnaq4UA9tX90m4BxRy7dofZeUe9HrNfHkLQJJm8Y0JxuxKci29jkRmLnqucjgA0CAdgdgYGBZhtdU2nmF7bESOOowOmskIom2M4OpaKum4fqirmYZgNG9pw9lKxJbzK4hQw/lFY3zOcWQ2oOI1pgKTMaL83la9GTZx2LUusMt00tymHIgtISA9BLqvDwPf1SGo64kxbySXX2YJ7l4SFypAQ8dTdNUnswI2C/COdX3KE4AprZmp/SODN0UyNMHWBDqDbyTHe80AtH52BBv+3+Cv08RQhdhSPxpicnhrgvlmr3t3hFPJRO8axpqhPOXbcHHog3RjdPJcglyeO5psw2kfOcWk/UwACjKFPgSiqicrHYMekc3Z9Bw7BtzIQDOHZT9z0Fp8by76zvUqO7bX3Do6E/Wf7bD3XUDHyztrbqcp4xN2ToUD052Pk9ffrxMKGHhG853o2OH9NNMUf1UlCi9j2ECiYburx9QVSIIYGugTDx3Yo4CcsFMMgziwLS95p3AdLOrymeLadai73KgKUbOV404DQLzGOe68vx5enTT1U7qO7T4Y15UZxoZwOEiBSgean9XSnYt+TgiPmsrSFi1BVpa2lYMKB8FevVOdZ9wASxM/fjxNjWigFv5Gg9q98erM/fMki4wpgnwrBdkofgYLT9Tw2c5F92MLs9/LqWVXgGYsr2VpqL1LBr/kBvzPbCUEghrD+J12IDfg1ADtkQR0ut5kWr6LvxTt1Pdjd3l1gPSAMY7PClyVGazmqAWAnq6gDpEyHc3h407aNUY56zuFC7IHvakQoz5PQlZQhaqqUP1RmaNqHs/wCoE+0nJUSundHX0PDGHYaFSBCmdnluLg5sQor10A7yduHeDc1VGQYv7ntV+F5pgGrM7DoJrQNC9cKv9kLuCf43xECATKywNbPD7i+HJKuhgJhVi9gbuEamjeaY8UEfhIWWsAlt4ePYE7Xrws100rawzCzCsAvnkeASrZ4f5JQywsJ+QKz8KxUZAI8M2VwdRYTLqh3iXLTZhLkPej3Ur8G4OK/vbI3zLok+EshFNE9OtCxZc1+TVnCjM3KSZ8j9CAXEomsQLpj6mLkxCg7pgaDQKPPRW8zxRa6KIXOx72nxGI3BuQnqhs3BJsxiR6PeJyI8u3lMNJVqi3CTQzkZCws1JXrMNJKgIHCwBR+0R9n1MFIQbxBcSNng2NMczr0iqsogIGF8GilyI8YvB9Pd47FfhVppse6GGr2IxNsXBoyQ3508tKm5Q8U8Kc8MX/ZuZZHPkKimMhM93UJmkJePP2JN7O3tarANhbKx+4y6OBClLkTRfK2e4Ae3Ixjg7l7ogQcl3FegdOX0FP9d77NacvlBgXIkTIsFwnXqdoAaBTofWeu09F/o+xObXzYTEZ5F6wCystvPHP+d+A1MgohmI8c24qdTE1+O/8k/H5LJQIzVfKaWLG4CySngu9WgVXSYh820QWQMqoyd7FOWVL7ftzomJu2L5omOnKNJ8W3X9l9x4HvPZDq4iM2kKs4/U9Z9v71uHCc56MhGoESp86ncH6j08+NHabCsUbAZ9QWdudkb5B/GV83jfR2sQUBgehDshKLLgyusEaXcsGLwYkfI7QTc8o7EyJYdomziVflOkWCThAAA3pdzCGnIF4uYZ4J0nln7MUvonGc2iUeYC8AtaW71GmeoMOQL+PgDn8hL0Fg9isYh0kKJEEOeIxy35R/f0/PtoznUuZ8/lWi79z1xdarRuRiBzgz0GtQT0n2uhEA9v/DLSuU6mBkbG279dEwpEe8oGbKyRyZF8T9qbaR2aqQvyZkABEnApD97VyLXT1iQuS7GY+bfOp9eGwT7qBJqFRn/BH6bGqFTcYBkXXbAUPNeZosDcoDnIwnTYAZrsq1g5ab0MB+XITnjmn8ycXnEwSrmd+erkkOiRgFIVVLSOzUXNrwT7l6GQ5vjCjVoGrQWKC3e6gT7MYoLPDIaOyJ4JxUtdi+flQTp8wwbykFpOojqCZSmi7yS9vzucVnornVV9QUyKKKnb7UDnE1yBkxjPeCshagWpDbToA3Cc6LlOrVox9rvBS1hlSGpWPYLLx5K80nvea/vPD++kgID5QBLu6+LugboUO9Gl9UJLxJP7c/JZoUyZ1NngQTKUR+MqJn28sd3KqBt9rzDHfjjkaZbsSoJx5Fb2OTnK0OEnsg3mZ7X/efn5BzipuYNij9EnrR8eH9H+QxzeMen33+lfKbiUHQqoeDvjjzht1Squuo6hKqA3YDwrrH8fBW4SCkNggqQ0ubFxYDBtOHJ1bzOCVdUJNSP2Q8yD0zVseo1j6TjJ2V4oS1k3vJlJ/X/PbokHFD2B3rBJAaq6imYBBJwT63eCDr06gGElGSc1veNFgesx5F+KeqGZyU5TPTzvzSR47+uB9zlnflA60RKuzO0/5ZbE7JFiq67NOL4w+dn4ryXh6e0YYHwIJBxIKN5D1GpoiN4vGwsdu38DmxdQlzmPBtogsgeP0CTmmAUJn3qZRdXR2IJFN5nAolZcf9xvpfayPRYBqBzoksaEk6IxvFiqAnhl6gKPr43R94ifSjdR3xluC8VgbQf8T7p7GoYEd/E0ePtIoo3J1GezvlGIYgnG+zfbovUmeAIyWOWD9fFR1DqYXr/COY7BE6p4V0ePAYRwDAA3DaOWhuj+Cl+I8jcaNSkchzDYiNsGtbi5NY3iGbWdgpD1zuA8qRVHSFkKGQTKBsbNRcbohI9a4MKcMPkIjSo38YCfOphzke/vXtmLuvgad2baEsObfq3BBmDV3xkI2DHSWMfDXxoDqHCWINFU8uxYL3bx5b2QPfrqwR97HO1DxC6T8wWHadI8E9jpIjtiKyIjqUhEZr9EwerCBewmka9Zsx5n9PXmHBrR8+R7MFxwzf+xoPIooQolOx2zi1c7UmvY0bMslCuLI57qS2MKZNLeO6CSZM3C7LmX7sGU8rFWsuaDlxEJyW7xzK9tBWBC3nSU49z6C0QoUN2jGN77ubXLGoLmS570ypMRR0yuQDEF2BzWy+2Wlxd0Zr2Xb0Z2iLVIFVcA2b/hryHVqCKYCMCIlKMuoU5fIE9klby39EX/sJOOs5Ur7waL73gMvY4DX/nbwLIZ3IoM5Nn8bTcHKUXlVoAduqwEX8HRUVR7kWrdaodKodqsYYft6t8FlxSantMz9cFWW6rjlNCuIxP3J18Xkyw+DwNitFRXk8k2oNvxH/HQidJ/1Hoe1f6uHYKVjLcz8SFrP2JhZtTlvAr8gHZOtQcAieP58oDFaHtKlEDQ2eJMIg35e3LT3fD27DTXIcTh8Go04JxckEfCvFdP0vGMkg1GTq7/Q8RNjpkhXZnccrHLly2jKZ8u9ii1eQ6LSEJAVSO+sr2y5S/XrPq2A6g5eXJY+Bzf9VMcZWiHL7Fi0ZdIJeFFprE9UZyhhxynZeGJTzeZnL+LCbfpkE+EE4lRE16hksD8QuaEzc9h0491LXhcwH3eZ8LMzBGE9mmqd5flZuIgUnEnUx4mUMWyqD4g/wiDtorrxZdC1ArJLoRQTcGOrCwc2gR5RysZn8fhoYtKvSBJFPdnJJh1brfWqpR0bjdD2gon/w0VP8Mnmz4b7s1RGEFfCGIakBdukWho0Y2h6hKmC6hJnuJTEbNS2xzBeIs5XDHLEdk1eL6gXlN3HQ5wzwQUXtT+JIaUuWUWZtBrFI7/9fyxgSFRIoYL9oIs7vgdd6pIgxkp4pybXvs5UIF5rMMh1+lXemonhhH9WqiKoAy/TFkWSQGUJOjqIcjNIBR7XBhRfFJQ9EztVlk4gEgHLnozFqfwvWU7L4bBDWvKWoGOHL/GT8wxK7KDBE0mtJ9X2bG4HMF+ThSSitkB5JyUfpOauRcwaGk3MY1EiIvR7nFfRBB0KtDlfWyxfkrArwW/UnSJdrBaGxKViCXK0mCu0BCWQqhEp72GWFoAwFzLTQLzvlxcdDS+lc7TF6lnkVjhq79gNUeZBz1BvoSLjoEUeSpVoiWqx6NM/iZMbfT/tqGZ0bq4LMNOyDZXX2PbwhQ39xSYln87v9qJbzDHKDdSFrD+IW9JhnMf6xZa5A+bZN5BDRmX0lmOgQTAImsdT+fgk+AYITEp7fzMy4y58uWAwZsaTC0V0Tm8hH/cXOxhKje1AuDfrY1dTuWiGLrMsLVmk1/y2sEDR8+Xn5B28+WiDsDw7tB8ULAUx0/m+K0KyFL0c/c/abMRkmwAMIZv1ANFIwf+YpTW5dTSZd1EbOOWxbAq1DA/26fv1WOfCteHrr3Xb/ZTxbGsPS2Rv3OESC5xHfuP+GXIry0SW2cj11fElyRDH/cUZ6f0nJ7pk7EREDqRbx4REc8dp2Tmiim8Wn3f8F/mVz0skYGqZgobUNNo9tPpqhAxEIZhJ34PyXstQdJrOvR/VLmGYLdY7jhbxjlctaD3rvHk0WGiUEAPXrywtu0DFgWowq914rfZNXck1Llhk2NzU8juCRTeq8N7UKgkWxLt299uwUV/IIj6+RJI3UZWL6mB3ugAe9WBlEH6sgyPofeG7brb5mRcRs86K7zHdi3GdvhpBAyRsuq3f11XAPvIOFIyzNmsBjPlZ5dxrWN1ZwImELhk4FQXIlQcTKOL4cVbx7VZ1wsy/vAUsSwMXseU1mTRiLvt1ALy3/xU4dnAQ4nOBVwnSFBfb1e36Ck7VszOtE0SyQKD2GfnTRswjMtCXl+5cVWTJUf5OdXq8LBQZao6VKd4Q0JuS9CjPdOBNlQQ6WtDngUZxs2v2v28E+7uXO9QTzOzDh/VwjMw2K4eqbgj2D6njm1/H4bd8st9RXtCR3DHI58PjYeBx+vIgzOvlKYMMIHMRlEP4aFKo3rKhPrCmADUmQBz80/tScIRITo2v0iHRIZ2Q/taaZ+HlEpBQg12ySojB10pTGASl4aK0IvIZ4RVtULsHNLiSrL8QOXj1CN09ns6SsrHSbIpZUT3Yr1yf9NnZwGaDLDOJMrs+t0EL0aq0hLSXXAYBx4HTvJHmz8M9+hl4h4sahpWBWfFRUtMTM2wOhGJCG6XmCbal84kzBv9QbdvhNmKDfBjY2S1zwVvdHM+VpwroS3+p9Dx8DOfVU18VOwxMjzvViDB3NEB6yE7NnM/8BrvY7nxc3GKptWGPIxntNqf9xs7Lpa2dozQLELgwLub9+Hu+4qyEgRedXPZUjI9A1znIMK6Ykx0A933XLtXqQm+XvHEEykBwgsBdSCAeJs8HcOJGNMeh74xoVSF2H7sL3fxnQb0SX5Y8WEX5WwF+TgYPNu+plHyK99VI/C00GQi2Kj0utOIxPTWwuhZekbS09wPcDqms5SQwD895FhkNF8jReELDDns7b5Pv/s96iUiFnPdjYC0qC/UOt1onRjdeRZXQqq9qUt/vpcsZ36HvlUXvS50/dlroTxmS2/WB+WB2Tct5eitwAKiSKKlJdGWvLkCNxDD33Qc7aW8HVlmP9rYS61xK4YoGPl9QL2qxKg3TC95BInTxqsOWRo7a4s+z+AJSJi0jZTjINon9xHQOQvzmkrIEU08y5Om3bD1+2YadY5lLzjonnJscVmvUvgCLfmE80GY6ptzkuksEDgQA35K17prB0kdiEf6N8zkL+07QT0GJB8SUiNosYvTv74hJY+7+803bPQcDSkAWQ1LeKb5+2nsD3uESK1O6W/eSDNfeA7aa+QGMOSEJsoOUJUNzmJyG7WOlBbac5nYEyih86mHakt1trSD1JH0RyF01cYkAIacH3Fff94mFYnvebsKX+DBjpwQAhMEoDGq/LT/MdwJgKyK710GnS4gNOrYUuLXaW1ZIT5GaOpdz4Kbs/SlU8UgMDZrvBfk9teUcW/n2iP0ms9sSHncs+CpnW90ZGYkXCGoMp3I6WSZU87A4LvHQ6/sfkKpKWkoxsrehtF/oqvldwn5SFW7RYncWyO78oLatB84zyZY/BlInapP4ZGr2kQgULB3pZsiQofE08Ekfs/EZQpQmAFV8vxzDvycnB6k0QPIvypnpupiN42lKdUVa2rpIN8chby02tiZIkk71tu8wO9HubZ1v7c7dv7QIEsSkOsacvxywUego+vksPgVzGK6iQ77QnoEhFoez740pKBGzL1/8QtnEEHjBgLun/IboDvGYSTnESlaFZJ+Bxh3T77Tqv7xOYLL4oeP00AIqOo/6KtlpL6gyTx/KG+xyT9/S7USgnKGxYbUi8oGhBo/wKe+0W+yOpfLO3qATPFAP1iHdG5FHcCuD7l/O87PmnLqIhBrPgsrCH9OJ+ChHCUtVehq/8KMy/5i/NAsp5B+xtx0phGlFFylNgkK+sd3Pr/E75M0/dHLFcridLgKpswofdqqW32yznAsn94HAzvFjt/SABbYEM/8cRWNhx0sPi7T6ROQNEet9rAxk42Mj5AYG4HzkuPrSD9wnABTfb98vdZJuQXc7qGPeBjS8jC2u/DN6X0GCERRKRoxbtyni1vC22J4FNJMfXe3/2CGfCmEjdYizx5kvooej+5BpBa3eAdOLOCWd2MjEbeyf1Z6H3ie4Lu5UpP6wUI+4h7u1lTATuDY6Zf/u418yxvLaRR4fkA8gm+ffcVmQtaXA4moI+ddZagFuRR5CyS2cRFiayENcrmGTifQlzBhr1WsDvYKRkoBXETb4Sy5XIUoPqZw9hqWzkNery09V0eskD276d63vI0z8nxeFl1ZBo8MsTRmOBwOR8su699WmCDMJHdBrmXZepawcNDgHA+wTOtzmOj2250PKHhX09lekWkptGdy+uf3jGsVv+PCmo3hbdVNYuddnTiR/ALjTk7L4+/cwpSAxxOluAmybRoOydw79PsdOXJnh0jMSiMdqdOD1i/UBQWkXdMzb++Jd3u/W49gAOjqqMZVDwCznIVy9txVVJ2L79/jwxSARNt6ezyOjdtVDPdi1hkd7yZVAv1ibmJM3bl9D7P/GY3DumbuD8+sot0jRpn2arEwMcdf+1JZMSA/MPRd/jztTsiFECE7O/nx58Nujl/C+VtqSbMKBgp6rKz12cDolBugyToXRS83mhuSssq6zS5yK0SgmzEizHYaZzHQShu4gr+3ug08vacanY4wb3MvYiUvzA6RhMVtKqsmzWyBIgpQx+bQ4ARKIOo0SnsmuSiiuvo845h0bIod/FrdNFSYDa7/ow0zsIETMjzkpMgg/Xlzte/lLo5Xhlh14xUMcsG64S59qndgW0iZAh6Ah+nytDWVD2IM/gDlzpr7HGoU1Qz6oCAC4LsTrhBAVVAUlCoNhKSxUlKnhmDdqMcK/CspnAtjpECgo3hXserz+4H7Uelo0W66fSJ+HlCqFjInZT1KX+Mv/2bi1Z/HJFDxD7WFCGfTfcF3KBzOqxNRt7r0/kZ0duZA1ZZBCA7diJx/Ig3EaOgLQ8AVkynqmlg3runMXhCPLu5M6LxUo60pO+LQKwXNrKkfYztQIO6wzf0/bDpgd7E8Kak5zMBi4sxf5ecZamyZX+h/jikAI1SLTqHZimMJhUxlPomjZb0jYSBxZ+MpJPu9aLL1VEdU1hPQYJVkdA68Xdarl7jRYUIHJVETClrweo9BnA1S1rzfknrGZUCNSSWvko6x2s/QVEzwPai9/+RgNbITx0+F1UmRCSMBuAFXFB/6iGCNUrNEUsBLUwq3B75BzPJRGKRQf9NOdvDhr8SNtSCOIStssGnq26z3oyZ1jEklzAd3074zcUzok48/Z+x3Bv3oUiCfJ7TOiNMIdgBE0naqA0r30AOK7euSOeK/wz3ibS5uybvbjR0ZERt6N/nwwhbtwUVNCPc/FOYYuArmbpggbFsoX8oJ1+D7DUk/VIYTCUvfqluLgU0cxb1R/7myyu5Zwuk0KAkWvOD02FysYFsrGqxhMe95QylTGI8EDoORsmLQsY3N6gcTkSbRTDdZTfInH7xU+/A6/J7P9rZA7Lg1R8w12dwHfU0MYGPhJmKLxUcN7195OZVKvK/kbmy5F/OZ/xN/nCxyQsD5xc6yPADGLNguGEBFY0HxBaxKgW+fZphjJPYLz+PtkA4FtLG+Ics4/fcAOZOuIezK/wNP0dCQbMi8nXS+tQh7Sw7bTEriMzNmqCKiIZj9FggvuSrrhlZFsVrlztu3yzVDeOS304O21dM2EJYqVS7PIxisz3/c8sCcmR8bFllxPWmSOguanWmOlhHIwYz23e89RC5UsHaD7UktEbLJy+WURZXVIg7ImaTeNY0jSrj3jNK/Eo9HZGsveeJx1xR5jGlM3NymcyyBnAu+MsrHQIM5LhIs2veq0ehr0okmjc33MxZFE6jmjocHbo/KxH9UmloQk5VQIVAJF++j26wWojmIbjjZdm4OIsLZpUpQbsOR+iTyKzij8nSbLbkPBptu3Icf7TJ5W8ntSkVPpev11YCVsZfm/+8V0H5btDVxURVqFVXME0fOpfhCgc+Iu7k2vLtu34W4LkbWZ7EtkI5KLuiFP5qloUFlRGw/fIciOPv0K7LvXcwwz2VZYxr/x6r6PvIxWXEUjy8jYVrsS6k5ejsp2gFX3bjVrFsMQ3ODMqhZxDbRxt7KVp81lc6VQq/UGCkGGtU9chaA436+hPpEwLgko7Tzoi8AanobWDXAjLMMzuCTkM90vOTt3GBak0frUShpEOSIqdw9Cl0FkwsfBqQdgLrnIL9+oMuSegbpn2ixfk2Zt3bybbkcfj+aDP8RC9COX6XalocwMvcXCBsbC8hHK8p0U4yGa7ISucB+HBbXQ6G0/PHWhYFuUvA7Y2WAccKaSbdwc4nvz5r6yzUFUlfElGm5Zkxm4KDenGVQTa6sfN72s4y+XHH/R3izJuVh5HlOUw/G1+ULkT4zksTsJwBdLxsCiwk8eiXc0kgYJbvKrn3SgwDBwNakdWyiuhzEO8YhOboYm3/w3A/UPzS+lN4ehQ0kERMUKtyJMjmPe7JRjjWCzJJ5ngnniEJ9Vb5MtV9x9pvy/uNpnA3SnA0Tkyn5FjqzHH3r+3IYwHmOfk9UfY8KcDjdGzGM1plYTf8hokSbEdYFgvCHC/RUiDTKKr1HSzyekeuulu0hqgRayk8GSMwbEmSq6SZdpolvthS7iF4X8WNXdKXZkniCluRf5Q5sEf4s0ZX7Wnki8h2YIeRA5bve9bMZmx+eHuoadrkcdkqiWnt5VDQvcNRQTXJy5ER6RFrQLb0Xy+zLRL6OEeMl+utiOB+5Qi7KyFR0fiv5QfCic4J+0NNWQauOjytzFvnk8LV+fb7Yfb7Y7/XTHpVuCiZLXV29TrSTEDvkjGiC2r7AU1eotbfOGJyvTwvSvXyTougYoOR+QYc73keVlOGTrPK54Ht5twNOVta8KStb/zIvbm/9cF/UtBpdzxK1whOZsmzEDqDlLIuGu91ohzWEK45vDYMLt2FZ/jLVoA12gt4Z2VLBQprVT40u63YPr+W9D28ZpKzWmxExFYJyHsD9xoTsDI5VZASAnQjv2Yj+yiH8OYCdJY3D5JGUc9lAlSkDQhFkgy+MT4yHf90oX1gR1FyBjhuMpU9DWDXayuDOhfY8DL4zC52coxrnaV03A1l1tI8aazUzBSWJR555G1GP8oIMtcV0UPWotV+tTDkE52Lu57DKy+k135VAptPb7lgPGGi+VrvdUPDa8v1MfZezbLVflkMRjOl+kwy50ceggC6/se9KXBZQAkpeZlpYqSuhxgFQsC9S1Q0OJcS8d1oXpiKSkxBQEY5QziSyBM/HiQx65sQaPqxiuVGBQy31ewJ9KYSkeurC+KcKxX8WWohcxbZ/BNuDnR8puyAtqRk8Le/0BEemPzb1GbU2zXM5tdW+UDoWfXcnJ3Qz4gc4TjVdum9HeSNneXGdRw9nsza5c2JbZA0OWd1wfn1Ry/Fgtk5npUnTFZ2zLYDruzmUrF60hXZ3/zNdqS2E7haY6ZwBFq/hTcjF+oRTj0M0rOUIvSlj8Ka8NQXcKAzbHYN1vURE6iAPXn1Nd2EKmGrPSU/sy8d6f/6ZCOEXZ7Hi42jC1snB3Palzj2mCixslCNBmG9cM50HIYCNNQQ7sBFWyc9ef5kbq4RTmtGhHNm2d5+XCB4qvLCYE8Jc2IQywtymyL/UGEx7qCKEK/vqMXcRBlJlWJUAYJcMUvaRt6JvDjHqGs/4hr/KoQ+7Hrwnw7rViicPxBTlVGWrV/j1pcVO9I0JcjEyLhXy6BNwOw9wwlrL0DpJr1SJdKsWrjqB/H3oPXReruNvLomLjBc0a68MYZyO+JQTZmGSu3sM6Wr/7WxEtIit9eHQqdLpbilLtgv210cN9OcLH05sZuxb71XcZB+FFlWbcNUeWZCAZfzPdvrSQuyzhd9IQR1lPvMrtcO4eKfimZJacn8WKgSAi03fNaS7fBNk7ecSgdSMhtc7oAe91cT0chUF59lSFBSX9fMX08sIYnnlP3+8seceNz83V4cy+0QT1+1TK87kRxsRvxrFbhWGuqZJ1mGOmHV447g3tCyXHyvd2/CxL8Cc5Gq0EpYZ38dAT02/g1v9PjMaDWtFvaMf6m28u1bIrf+0XzucW9ntlNZt05U8typfZas0LS2noC2dodZkeJzJjzZUmkmaYyAXIrHWMhuSzAXqMRBRMH2qzd0b0Ypov9ilhcXslJdfQ9iVx/p1LY/6b0ilP+TLvIK/HzhA3Ryc/wQivT2/9N0pAGjKaVZBa5G3n+4ADjEVOAkqsumQgADi84WU4SBaEi5vGNpPwLLF45v7d1HChgr284YXR0Nzf26MmbxYockeZTC320wx4IZyXdOm6GKF5p/V+loYlTGQcrHuMdXgZYwFdgiIq5nXyoBhGNY7qPU4puAeDHwkLD3dBHxwVY1qAHekkTxpQe+J4fmp2t1hD1BdNkfROqYIqALFXF7AhOwqM3mqUbKRoRgY1nyWCOn7CHksho+b5vajEZ2ZNUg4oibP+CA07bswja05iuZmy9whdlZn98kvcPgts2uui16TEolLoi8wE3uoNuLSIdnzsmst8r65X3eAA+yEDiPBS7ujcPP1Mx4CLpZb1iW+RgPXizaYeLjy9c50eyY/dAtJEnuyzhpJA1Kj86PWsUztsmbQyfzpRND6Ssvh8xPpIpAz0i7/fX94nfQDWSOquTq1hHaRQK5EmfejO7Xv7y09HGS44bF0wNcH0L4o0sRiLBN7aZsVH+h+qfHZ4s2LnrVCIkuJY1pnsAFA5x6X+/iZIJn6S9crb/vEVMBYWt4NltTR6M9Uvr5+Yv4617vRmVoBVe7GPILRnYhybt/on5A7VDcIhBmlrlhAuQrcuxqROsuY3RyirSOvRbi9IOrWC4OE+JE69AMeciCkS4OVl1Rqb+Ii7jBAd3B+3Igb6LsYCS/XAP3+FbW+IlbCuUnh4brioi8d7Sh/j5JKygYWfSRU1IyD26iRaAMOoN3pTvemp25rSNVjZQV4QQVdUlPmpB+j39wjvkWs2c61/VET7LuC4j7DZS561SRRpalaOVSP45LmGcxNpjzN3vKglnSC47pa+BxCKeRTOX1PEH56ivVfbdX+dZ1aiZW2DfzxXBhGUMnMsdL0zonSVtSOoLSWEkLoPbAs6494BEoUmJTIprBo94unOKNgGWeYBoAGckS9wRQniAvxEsMxwNL/TDasJWTmyfadWqDiQI5krzqOOXRnQnW4qeQPYTNTy6E8+/q5Nn/ra+AD+rtd8Fyj0ZyKzvH5zNFpUfNj4ox6+lN9CwlyvSwvW7Zh5q14wjYtHjNj3ED7UjPSnZuUhb1I90vhgNZY5+F9Uc+RBugEu6QjvgPg9lQquM5EtJG7nrZdATNnhUaNwBHqI9kNXU5RrjQiPA3YJJkql8HkLNDe19XhqMHHe5UaqWsJRHCTS99q9ol3HPHJJMlIdTJIyNAhHMMF3VqHL4huXRPb8l3tcPR79xkOoEZLD1P3wzOxrKXXbwo2qh3SEFktNLz3oYVK2mJJ564HJYRVRvY7cPHDciKtnvWb/iuX2D2+NSMoaxt0xISi0X7yDrI23d5wMlxfC2n7cbos+HJ5VEP6lbcu6EIjmgRkN/tGEtYGajGQJ0W7QhysolRSbNX28q5MAevUD84m0ka/hXe2hHppv+6Gni6qyNFCse+hI1Wv9s2Gb9o5XPdNN9Nm2zM5A+eY8v6DXRuRLKMjqlkG8VTXDHoDl7MUiXzloizE23+B/BiJtEvX979zpmE8jnCj54lSRYKa7lrIh4bw7pP5ZpgJ3PibIPRuMvqTtC+NSHUJFMxJZVaVJP2qEe2/IFtkHEUeJU0yxK9jw8iX+kFBCJT4xKtgCkyGh+4y5hwxfHnhM12d5kfL8Rt1QlHUYLaEd1/OWJFrw5V6BzQT/IJrJP9NHmhReAmqmNlHjPR1eHMRNML9qwI71+7FnPeQHelPeTXHqRkDMHMqAJrMke3M1srXeMMu9luyRNLU34fEf6Bv4gUU3dzHPkzHPkwPS80AlN9MqwfJ56eoL7zMF3Iq1XA5DJQyJRzndwpBU63SMkiZ2gwd1Jf7VKT/RyN86JhDJ7N2URDplBP2ett4ewqta2bI0pLvTsrqRTFqYUzlS4TXHU8l3sITmbkTz70OqgrnLhdDkokxTopMNrfsfyB+wSHIReAYhFCzMQ+aU+QMjLO8hQs8hAegGgoRnTP4Ww+ARLeRwA6doJG3M2tlscmsv7YIxnpQOsXU786gFhIj4idRSLLj84w8hNt2va64yKu+PW+zUMLnhHGQHcjI3ifqY68HhvZjqtT5o+QDm7Hbvywj5gTXSCAHvAPNYyaTrADJwZQVxmE9nyXWCK/AkNIi82kFomasuWKH4+MpT8uBgtNELR5rVm0MgWMxgbrsOqlHiYiDiQWxG3AmQpi0QR/KyQvcs/K39jIHHS/B2PqQhJAZHReQJI8T4b+ApIvcSMzs2hOq65/QU7UOTChLJ2ysoUTDcAp1mN8yqykJIzB91U0oXREwKTfdjTgUlTZIFj9ZkIANt8gQysAvuUxWo7NYngHS8EXPb0NforNNzX4L9oJW77YNqSgIBZrXdsxBQn3eQ4QrELB1z7oT2Qq/wjO0OPrBUpDHP0pOGqkFqdjgIRn+LV+jhJcmXpBKBay8Urigz8/G+Rz2npcQRKZm0KboNmIrJZH16AXgk4NbPrzrv9J/LuvOv34JFot2OlfectGb1WZi2txO4I7a4OQOs6UJFtoH3gF1q0iO1oA1D64DTifyXWxk6lu6KzmILQcjL+T7xwRf2AE4OUT+Clu+NRNeGf5BFIzWX6o9Ky2gz1RMcTVKZSsXfjQFQ0henYAoHiBaz02OmMiWIQiZFvIuwbzwlBkVu2zm+S3aM0YxWBTJ4Suy+FmrihCy7Rg1ZYiLbsu5OgwKVgFfEhM0czZjHVr3MTiVNAhLwgQbk8mu0p9TzNj7La9hPyt/OFT3lDgKY992wL3EHSVKi7flJYVIFaA9lm+fo0zo4uogTlO3ZgUu0n4jOEgnn/1miUDukTzYB4FaoCScui5ytDdbCrwbd+xeCXJ6TQCrzC1sw/vjyi/jtE79kFsQD5BHHtdJnuAIiGjEDulDYBIJlx6ULHAJcqRR7/meMVhftFxcMGj7ewa4frGxfZeGe2QZ/y/MusmxD6/HaNQW+8uobqx2JRlGmO58OKXvfjSFok5SlmvuTM/Mol1gW6Gr5ptn3ILFVsrKWavl/ghz149AfJ5Nbzn3ig+syEtaGZakduMpo3sc1PB7OZ23kLW2jH41KsBLwqCntjAeqrH4h9qRhuk2DGZkAdLR4HR6qNKp==

zerobytes · Valuable expert

[code:1:45418c902a]
<?
###############################################################################
# PROGRAM : ONLYPAY GOLD #
# VERSION : 1.2 #
# COPYRIGHTS : (C)2007 FASTTRECK.INFO. ALL RIGHTS RESERVED #
###############################################################################
# THIS FILE IS PART OF ONLYPAY SCRIPT - THE NEW UNIVERSAL PAYMENT GATEWAY #
# DEVELOPED BY FASTTRECK.INFO #
###############################################################################
# ALL SOURCE CODE, IMAGES, PROGRAMS, FILES INCLUDED IN THIS DISTRIBUTION #
# COPYRIGHTS BY (C)2007 FASTTRECK.INFO. ALL RIGHTS RESERVDED #
###############################################################################
# ANY REDISTRIBUTION WITHOUT PERMISSION OF FASTTRECK.INFO AND IS #
# STRICTLY FORBIDDEN #
###############################################################################
###############################################################################
error_reporting(E_ERROR | E_WARNING | E_PARSE);
if(!ini_get('safe_mode'))set_time_limit(3600);
set_magic_quotes_runtime(0);
ignore_user_abort(true);
###############################################################################
$data['PostSent']=false;
$data['ScriptLoaded']=true;
###############################################################################
$data['Path']=dirname(__FILE__);
if($_SERVER['HTTPS']=='on')$data['Prot']='https';else $data['Prot']='http';
$data['Templates']="{$data['Path']}/templates";
$data['BannersPath']="{$data['Path']}/images/banners";
$data['SinBtnsPath']="{$data['Path']}/images/buttons/single";
$data['DonBtnsPath']="{$data['Path']}/images/buttons/donations";
$data['SubBtnsPath']="{$data['Path']}/images/buttons/subscriptions";
$data['ShopBtnsPath']="{$data['Path']}/images/buttons/shopcart";
if($data['Folder'])$data['Folder']="/{$data['Folder']}";
$data['Addr']="{$_SERVER['REMOTE_ADDR']}";
$data['Host']="{$data['Prot']}://{$_SERVER['HTTP_HOST']}{$data['Folder']}";
$data['Images']="{$data['Host']}/images";
$data['Banners']="{$data['Images']}/banners";
$data['SinBtns']="{$data['Images']}/buttons/single";
$data['DonBtns']="{$data['Images']}/buttons/donations";
$data['SubBtns']="{$data['Images']}/buttons/subscriptions";
$data['ShopBtns']="{$data['Images']}/buttons/shopcart";
$data['Admins']="{$data['Host']}/admins";
$data['Members']="{$data['Host']}/members";
$data['Home']="Location:{$data['Host']}/index.htm";
$data['DbPrefix']="{$data['DbPrefix']}_";
###############################################################################
function get_post(){
global $_POST;
$result=array();
foreach($_POST as $key=>$value)$result[$key]=$value;
reset($_POST);
return $result;
}
###############################################################################
function protect($buffer){
global $data, $_SERVER, $_SESSION;
if($data['ProtectHtml']&&$_SESSION['login'])return encrypt_pages($buffer);
else return $buffer;
}
function prepare($buffer){
return protect($buffer);
}
function show($template){
global $data, $post;
if(file_exists($template))include($template);
else echo("Template \"{$template}\" not found!");
}
function display($path=''){
global $data;
ob_start('prepare');
if($path)$path="/{$path}";
show("{$data['Templates']}{$path}/template.header.htm");
show("{$data['Templates']}{$path}/template.{$data['PageFile']}.htm");
show("{$data['Templates']}{$path}/template.footer.htm");
ob_end_flush();
}
function showpage($template){
global $data;
ob_start('prepare');
show("{$data['Templates']}/{$template}");
ob_end_flush();
}
function showmenu($mode, $path=''){
global $data;
$data['mode']=$mode;
if($path)$path="/{$path}";
show("{$data['Templates']}{$path}/template.menu.htm");
}
function showbanner(){
global $data;
show("{$data['Templates']}/template.banners.htm");
}
###############################################################################
$data['cid']=null;
function db_connect(){
global $data;
$data['cid']=@mysql_connect(
$data['Hostname'], $data['Username'], $data['Password']
);
if(!$data['cid']){
echo(
''.mysql_error().
". Please contact to site administrator <a href=\"mailto:{$data['AdminEmail']}\">".
"{$data['AdminEmail']}</a>."
);
exit;
}
@mysql_select_db($data['Database'], $data['cid']);
return (bool)$data['cid'];
}
function db_disconnect(){
global $data;
return (bool)@mysql_close($data['cid']);
}
function db_query($statement,$print=false){
global $data;
if($print) echo("-->{$statement}<-- ");
return @mysql_query($statement, $data['cid']);
}
function newid(){
global $data;
return @mysql_insert_id($data['cid']);
}
function db_count($result){
return (int)@mysql_num_rows($result);
}
function db_rows($statement,$print=false) {
$result=array();
if($print) echo("-->{$statement}<-- ");
$query=db_query($statement);
$count=db_count($query);
for($i=0;$i<$count;$i++){
$record=@mysql_fetch_array($query, MYSQL_ASSOC);
foreach($record as $key=>$value)$result[$i][$key]=$value;
}
return $result;
}
###############################################################################
function verify_email($email){
return !(bool)ereg("^.+@.+\\..+$", $email);
}
function verify_username($username){
return !(bool)ereg("^[a-zA-Z0-9]+$", $username);
}
function gencode(){
global $data;
list($usec, $sec)=explode(' ', microtime());
$rand=(float)$sec+((float)$usec*100000);
srand($rand);
if($data['TuringNumbers']){
return (string)rand(pow(10, $data['TuringSize']-1), pow(10, $data['TuringSize'])-1);
}else{
return strtoupper(substr(md5(rand()), rand(1, 26), $data['TuringSize']));
}
}
function around($amount){
return sprintf('%6.2f', $amount);
}
function encode($number, $size){
$result='';
$length=strlen($number);
for($i=0;$i<$length-$size;$i++)$result.='X';
return $result.substr($number, $length-$size, $length);
}
function is_changed($number){
return (bool)ereg("^[0-9]+$", $number);
}
function is_number($text){
if(!is_changed($text))return true;
return (bool)is_changed($text);
}
function showselect($values, $current=null){
$result='';
foreach($values as $key=>$value){
$result.=
"<option value=\"{$key}\"".
($current!=null?($current==$key?' selected':''):'').
">{$value}</option>"
;
}
return $result;
}
function read_csv( $filename, $break) {
if ( $file=fopen($filename,'r') ) {
while ($content[]=fgetcsv($file,1024,$break));
fclose($file);
array_pop($content);
return $content;
}
}
###############################################################################
function prndate($date){
global $data;
if($date=='0000-00-00 00:00:00')return '---';
else return date($data['DateFormat'], strtotime($date));
}
function prnintg($number){
return number_format($number, 0, '', ',');
}
function prnsum($sum){
return (float)str_replace(',', '', $sum);
}
function prnsumm($summ){
global $data;
$summ=str_replace(',', '.', $summ);
return number_format(($summ>0?$summ:-$summ), $data['CurrSize'], '.', ',');
}
function prnpays($summ, $splus=true){
global $data;
if($summ<0)$color='red';else $color='green';
return
"".
($summ>=0?($splus?'+':''):'-').$data['Currency'].prnsumm($summ).
''
;
}
function prnfees($summ){
return $summ!=0?prnpays($summ):'---';
}
function prntext($text){
$search = array ('@<script[^>]*?>.*?</script>@si',
'@<[\/\!]*?[^<>]*?>@si',
'@([\r\n])[\s]+@',
'@&(quot|#34);@i',
'@&(amp|#38);@i',
'@&(lt|#60);@i',
'@&(gt|#62);@i',
'@&(nbsp|#160);@i',
'@&(iexcl|#161);@i',
'@&(cent|#162);@i',
'@&(pound|#163);@i',
'@&(copy|#169);@i',
'@&#(\d+);@e');
$replace = array ('',
'',
'\1',
'"',
'&',
'<',
'>',
' ',
chr(161),
chr(162),
chr(163),
chr(169),
'chr(\1)');
return preg_replace($search, $replace, $text);
}
function balance($summ){
return prnpays($summ, false);
}
function prnuser($uid){
if($uid>0)return get_member_username($uid);
else return 'system';
}
function get_files_list($path){
$result=array();
if(@file_exists($path)){
$handle=@opendir($path);
while(($file=@readdir($handle))!==false){
if($file!='.'&&$file!='..'){
$x=strtolower(substr($file, -4));
if($x&&$x=='.jpg'||$x=='.gif'||$x=='.png')$result[]="{$file}";
}
}
}
return $result;
}
function get_html_templates(){
global $data;
$result=array('0'=>'--');
if(@file_exists($data['Templates'])){
$handle=@opendir($data['Templates']);
while(($file=@readdir($handle))!==false){
if($file!='.'&&$file!='..'){
$x=strtolower(substr($file, -4));
if($x&&$x=='.htm')$result[$file]="{$file}";
}
}
}
return $result;
}
###############################################################################
function send_email($key, $post){
global $data;
$template=db_rows(
"SELECT `name`,`value` FROM `{$data['DbPrefix']}emails`".
" WHERE `key`='{$key}'"
);
$text=$template[0]['value'];
$subject=$template[0]['name'];
if($post['username']){
$text=str_replace('[username]', $post['username'], $text);
$text=str_replace('[usersite]', "{$data['Host']}/?rid={$post['username']}", $text);
}
if($post['password'])$text=str_replace('[password]', $post['password'], $text);
if($post['fullname'])$text=str_replace('[fullname]', $post['fullname'], $text);
if($post['emailadr'])$text=str_replace('[emailadr]', $post['emailadr'], $text);
if($post['buyer'])$text=str_replace('[buyeradr]', $post['buyer'], $text);
if($post['product'])$text=str_replace('[product]', $post['product'], $text);
if($post['ccode'])$text=str_replace('[confcode]', $post['ccode'], $text);
if($post['chash'])$text=str_replace('[confhash]', $post['chash'], $text);
if($post['comments'])$text=str_replace('[comments]', $post['comments'], $text);
else $text=str_replace('[comments]', '---', $text);
if($post['uid'])$text=str_replace('[uid]', $post['uid'], $text);
$text=str_replace('[emailpage]', "{$data['Host']}/members/verifemail.htm", $text);
$text=str_replace('[email]', $post['email'], $text);
$text=str_replace('[sitename]', $data['SiteName'], $text);
$text=str_replace('[hostname]', $data['Host'], $text);
$text=str_replace('[singpage]', "{$data['Members']}/signup.htm", $text);
$text=str_replace('[confpage]', "{$data['Members']}/confirm.htm", $text);
$text=str_replace('[lognpage]', "{$data['Members']}/login.htm", $text);
$text=str_replace('[amount]', $data['Currency'].($post['amount']-$post['fees']), $text);
$header="From: {$data['AdminEmail']}\nReturn-Path: {$data['AdminEmail']}\n";
return @mail($post['email'], stripslashes($subject), stripslashes($text), $header);
}
function send_mass_email($subject, $message, $active=-1){
global $data;
$header="From: {$data['AdminEmail']}\nReturn-Path: {$data['AdminEmail']}\n";
$members=db_rows(
'SELECT `username`,`email`,`fname`,`lname`'.
" FROM `{$data['DbPrefix']}members`".
($active<0?'':" WHERE `active`={$active}")
);
foreach($members as $value){
mail($value['email'], $subject, $message, $header);
}
}
###############################################################################
function use_curl($href, $post=null){
$handle=curl_init();
curl_setopt($handle, CURLOPT_URL, $href);
if($post){
if($post){
curl_setopt($handle, CURLOPT_POST, 1);
curl_setopt($handle, CURLOPT_POSTFIELDS, $post);
}
curl_setopt($handle, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($handle, CURLOPT_TIMEOUT, 90);
}
$result=curl_exec($handle);
curl_close($handle);
return $result;
}
function autorize($uid, $post){
global $data;
$query=array();
array_push($query, 'x_ADC_Delim_Data=TRUE');
array_push($query, 'x_ADC_URL=FALSE');
array_push($query, 'x_Address='.urlencode($post['address']));
array_push($query, 'x_Amount='.urlencode($post['total']));
array_push($query, 'x_Card_Code='.urlencode($post['ccvv']));
array_push($query, 'x_Card_Num='.urlencode($post['cnumber']));
array_push($query, 'x_City='.urlencode($post['city']));
array_push($query, 'x_Company='.urlencode($post['company']));
array_push($query, 'x_Country='.urlencode($post['country']));
array_push($query, 'x_Cust_ID='.urlencode(get_member_username($uid)));
array_push($query, 'x_Customer_IP='.urlencode($_SERVER['REMOTE_ADDR']));
array_push($query, 'x_Customer_Organization_Type='.urlencode((strlen($post['company'])>0)?'B':'I'));
array_push($query, 'x_Description='.urlencode('Deposit to my account from Authorize.Net'));
array_push($query, 'x_Email='.urlencode($post['email']));
array_push($query, 'x_Exp_Date='.urlencode("{$post['cmonth']}/{$post['cyear']}"));
array_push($query, 'x_First_Name='.urlencode($post['fname']));
array_push($query, 'x_Last_Name='.urlencode($post['lname']));
array_push($query, 'x_Method=CC');
array_push($query, "x_Login={$data['DepositMethod']['autorize']['user']}");
array_push($query, "x_Password={$data['DepositMethod']['autorize']['pswd']}");
array_push($query, 'x_Phone='.urlencode($post['phone']));
array_push($query, 'x_Recurring_Billing=FALSE');
array_push($query, 'x_State='.urlencode($post['state']));
array_push($query, 'x_Tax_Exempt=TRUE');
array_push($query, 'x_Trans_ID=1');
array_push($query, 'x_Type=AUTH_CAPTURE');
array_push($query, 'x_Version=3.1');
array_push($query, 'x_Zip='.urlencode($post['zip']));
$query=implode('&', $query);
$cid=curl_init('https://secure.authorize.net/gateway/transact.dll');
curl_setopt($cid, CURLOPT_POST, 1);
curl_setopt($cid, CURLOPT_POSTFIELDS, $query);
curl_setopt($cid, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($cid, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($cid, CURLOPT_TIMEOUT, 90);
$result=curl_exec($cid);
curl_close($cid);
$rarray=array();
$rarray=explode(',', $result);
$result='Credit card transaction was denied.';
switch($rarray[0]){
case 1: $result='--DONE--';
case 2: $result='Credit card transaction was denied.';
case 3: $result="An error occurred while trying to process your information. {$rarray[3]}";
}
return $result;
}
###############################################################################
function is_user_available($username){
global $data;
$confirms=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}confirms`".
" WHERE(`newuser`='{$username}') LIMIT 1"
);
$members=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE(`username`='{$username}') LIMIT 1"
);
return (bool)(!$confirms&&!$members);
}
function is_mail_available($email){
global $data;
$confirms=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}confirms`".
" WHERE(`newmail`='{$email}') LIMIT 1"
);
$members=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE(`email`='{$email}') LIMIT 1"
);
$emails=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}member_emails`".
" WHERE(`email`='{$email}') LIMIT 1"
);
return (bool)(!$confirms&&!$members&&!$emails);
}
function create_confirmation(
$newuser, $newpass, $newques, $newansw, $newmail,
$newfname, $newlname, $newcompany, $newregnum, $newdrvnum, $newaddress,
$newcity, $newcountry, $newstate, $newzip, $newphone, $newfax,
$sponsor=0
){
global $data;
$result=gencode();
$sponsor=($sponsor?$sponsor:0);
db_query(
"INSERT INTO `{$data['DbPrefix']}confirms`(".
'`newuser`,`newpass`,`newquestion`,`newanswer`,`newmail`,'.
($data['UseExtRegForm']?
'`newfname`,`newlname`,`newcompany`,`newregnum`,`newdrvnum`,`newaddress`,'.
'`newcity`,`newcountry`,`newstate`,`newzip`,`newphone`,`newfax`,':''
).
'`sponsor`,`confirm`'.
')VALUES('.
"'{$newuser}','{$newpass}','{$newques}','{$newansw}','{$newmail}',".
($data['UseExtRegForm']?
"'{$newfname}','{$newlname}','{$newcompany}','{$newregnum}','{$newdrvnum}',".
"'{$newaddress}','{$newcity}','{$newcountry}','{$newstate}','{$newzip}',".
"'{$newphone}','{$newfax}',":''
).
"{$sponsor},'{$result}'".
')'
);
$post['ccode']=$result;
$post['email']=$newmail;
$post['chash']=strtoupper(md5($post['ccode'].'|'.$post['email']));
send_email('CONFIRM-TO-MEMBER', $post);
}
function select_confirmation($ccode, $email, $chash=''){
global $data;
if(isset($chash)&&!empty($chash)){
$query="WHERE MD5(CONCAT(`confirm`,'|',`newmail`))='{$chash}'";
}else{
$query="WHERE(`confirm`='{$ccode}' AND `newmail`='{$email}')";
}
$confirm=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}confirms` {$query} LIMIT 1"
);
return $confirm[0]['id'];
}
function select_email_confirmation($ccode, $email, $chash=''){
global $data;
if(isset($chash)&&!empty($chash)){
$query="WHERE MD5(CONCAT(`confirm`,'|',`email`))='{$chash}'";
}else{
$query="WHERE(`confirm`='{$ccode}' AND `email`='{$email}')";
}
$confirm=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}member_emails` {$query} LIMIT 1"
);
return $confirm[0]['id'];
}
function update_confirmation($cid){
global $data;
db_query(
"DELETE FROM `{$data['DbPrefix']}confirms`".
' WHERE(TO_DAYS(NOW())-TO_DAYS(`cdate`)>=2)'
);
$confirm=db_rows('SELECT'. '`id`,`newuser`,`newpass`,`newquestion`,`newanswer`,`newmail`,'. ($data['UseExtRegForm']? '`newfname`,`newlname`,`newcompany`,`newregnum`,`newdrvnum`,`newaddress`,'. '`newcity`,`newcountry`,`newstate`,`newzip`,`newphone`,`newfax`,':'' ). '`sponsor`'. " FROM `{$data['DbPrefix']}confirms` WHERE(`id`='{$cid}')");
$confirm=$confirm[0];
foreach($confirm as $key=>$value){
$confirm[$key] = @addslashes($value);
}
db_query(
"INSERT INTO `{$data['DbPrefix']}members`(".
'`sponsor`,`username`,`password`,`email`,`question`,`answer`,'.
($data['UseExtRegForm']?
'`fname`,`lname`,`company`,`regnum`,`drvnum`,`address`,'.
'`city`,`country`,`state`,`zip`,`phone`,`fax`,':''
).
'`active`,`empty`,`cdate`'.
')VALUES('.
"{$confirm['sponsor']},'{$confirm['newuser']}','{$confirm['newpass']}','{$confirm['email']}',".
"'{$confirm['newquestion']}','{$confirm['newanswer']}',".
($data['UseExtRegForm']?
"'{$confirm['newfname']}','{$confirm['newlname']}','{$confirm['newcompany']}',".
"'{$confirm['newregnum']}','{$confirm['newdrvnum']}','{$confirm['newaddress']}',".
"'{$confirm['newcity']}','{$confirm['newcountry']}','{$confirm['newstate']}',".
"'{$confirm['newzip']}','{$confirm['newphone']}','{$confirm['newfax']}',":''
).
'1,'.($data['UseExtRegForm']?'0':'1').",'".date('Y-m-d H:i:s')."')"
);
$code=gencode();
$receiver=newid();
db_query("INSERT INTO `{$data['DbPrefix']}member_emails`
(`owner`,`email`,`active`,`primary`) VALUES
('{$receiver}','{$confirm['newmail']}',1,1)
");
db_query(
"DELETE FROM `{$data['DbPrefix']}confirms`".
" WHERE(`id`={$confirm['id']})"
);
if($data['SignupBonus']){
transaction(
-1,
$receiver,
$data['SignupBonus'],
0,
4,
1,
'Signup Bonus'
);
}
$post['username']=$confirm['newuser'];
$post['password']=$confirm['newpass'];
$post['email']=$confirm['newmail'];
send_email('SIGNUP-TO-MEMBER', $post);
if($data['ReferralPays']){
$post['email']=get_member_email($confirm['sponsor']);
send_email('DOWNLINE-CHANGE', $post);
}
$tmpays=get_unreg_member_pay($receiver,'RECEIVER');
if($tmpays[0]) update_unreg_member_pays($receiver);
}
function update_email_confirmation($eid){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}member_emails`".
" SET `confirm`='', `status`=2".
" WHERE `id`={$eid}"
);
}
function get_members_count($active=0){
global $data;
$result=db_rows(
'SELECT COUNT(`id`) AS `count`'.
" FROM `{$data['DbPrefix']}members`".
" WHERE `active`={$active}".
' LIMIT 1'
);
return $result[0]['count'];
}
function get_members_list($active=0, $start=0, $count=0, $online=false){
global $data;
$limit=($start?($count?" LIMIT {$start},{$count}":" LIMIT {$start}"):
($count?" LIMIT {$count}":''));
$members=db_rows(
"SELECT * FROM `{$data['DbPrefix']}members`".
" WHERE `active`={$active}".($online?' AND (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`adate`)<1800)':'').
" ORDER BY `username` ASC{$limit}"
);
$result=array();
foreach($members as $key=>$value){
$result[$key]=$value;
$trans=db_rows(
'SELECT COUNT(`id`) AS `count`'.
" FROM `{$data['DbPrefix']}transactions`".
" WHERE `sender`={$result[$key]['id']}".
" OR `receiver`={$result[$key]['id']} LIMIT 1"
);
$result[$key]['transactions']=$trans[0]['count'];
$result[$key]['candelete']=$trans[0]['count']<2;
$result[$key]['email']=get_member_email($result[$key]['id'],true,true);
if($result[$key]['sponsor']){
$result[$key]['sname']=
get_member_username($result[$key]['sponsor']).' ('.
get_member_email($result[$key]['sponsor'],true,true).')'
;
}else $result[$key]['sname']='N/A';
}
return $result;
}
function get_members_count_where_pred($where_pred){
global $data;
$result=db_rows(
'SELECT COUNT(`id`) AS `count`'.
" FROM `{$data['DbPrefix']}members`".
" WHERE $where_pred ".
' LIMIT 1'
);
return $result[0]['count'];
}
function get_members_list_where_pred($start=0, $count=0, $where_pred){
global $data;
$limit=($start?($count?" LIMIT {$start},{$count}":" LIMIT {$start}"):
($count?" LIMIT {$count}":''));
$members=db_rows(
"SELECT * FROM `{$data['DbPrefix']}members`".
" WHERE $where_pred ".
" ORDER BY `username` ASC{$limit}"
);
$result=array();
foreach($members as $key=>$value){
$result[$key]=$value;
$trans=db_rows(
'SELECT COUNT(`id`) AS `count`'.
" FROM `{$data['DbPrefix']}transactions` ".
" WHERE `sender`={$result[$key]['id']}".
" OR `receiver`={$result[$key]['id']} LIMIT 1"
);
$result[$key]['transactions']=$trans[0]['count'];
$result[$key]['candelete']=$trans[0]['count']==0;
if($result[$key]['sponsor']){
$result[$key]['sname']=
get_member_username($result[$key]['sponsor']).' ('.
get_member_email($result[$key]['sponsor']).')'
;
}else $result[$key]['sname']='N/A';
}
return $result;
}
function get_member_id($username, $password='', $where=''){
global $data;
$result=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE (`username`='{$username}' OR `email`='{$username}')".
($password?" AND `password`='{$password}'":'').
($where?" AND $where":'').' LIMIT 1'
);
if(!$result){
$result=db_rows(
"SELECT `owner` as `id` FROM `{$data['DbPrefix']}member_emails`".
" WHERE `email`='{$username}' LIMIT 1"
);
if($result&&($password||$where)){
$result=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$result[0]['id']}".
($password?" AND `password`='{$password}'":'').
($where?" AND $where":'').' LIMIT 1'
);
}
}
return $result[0]['id'];
}
function get_member_email($uid, $primary=false, $confirmed=true){
global $data;
$result=db_rows(
"SELECT `email` FROM `{$data['DbPrefix']}member_emails`".
" WHERE `owner`={$uid}".
($primary?" AND `primary`='{$primary}'":'').
($confirmed?" AND `active`='{$confirmed}'":'').
' ORDER BY `primary` DESC'
);
return $result[0]['email'];
}
function count_member_emails($uid, $primary=false, $confirmed=true) {
global $data;
$result=db_rows(
'SELECT COUNT(`email`) AS `count`'.
" FROM `{$data['DbPrefix']}member_emails`".
" WHERE `owner`={$uid}".
($primary?" AND `primary`='{$primary}'":'').
($confirmed?" AND `active`='{$confirmed}'":'').
' LIMIT 1'
);
return $result[0]['count'];
}
function get_email_details($uid, $primary=false, $confirmed=true){
global $data;
$result=db_rows(
"SELECT * FROM `{$data['DbPrefix']}member_emails`".
" WHERE `owner`={$uid}".
($primary?" AND `primary`='{$primary}'":'').
($confirmed?" AND `active`='{$confirmed}'":'')
);
return $result;
}
function prnmemberemails($uid) {
global $data;
$str_add='';
$result=db_rows(
"SELECT `email` FROM `{$data['DbPrefix']}member_emails`".
" WHERE `owner`={$uid} AND `active`='1'".
' ORDER BY `primary` DESC'
);
foreach($result as $key=>$value) {
$str_add .= "<a href=mailto:{$result[$key]['email']}> {$result[$key]['email']}</a>".' ';
}
return $str_add;
}
function add_email($uid,$email){
global $data;
$max_email=$data['maxemails'];
$nb_emails=count_member_emails($uid,false,false);
if($nb_emails >= $max_email) return TOO_MANY_EMAILS;
elseif(verify_email($email)) return INVALID_EMAIL_ADDRESS;
elseif(email_exists($email)) return EMAIL_EXISTS;
else {
$verifcode=gencode($email);
$result=db_query(
"INSERT INTO `{$data['DbPrefix']}member_emails`".
'(`owner`,`email`,`active`,`primary`,`verifcode`) VALUES '.
"($uid,'{$email}',0,0,'{$verifcode}')"
);
if (!$result) return DB_ERROR;
$info=get_member_info($uid);
$post['email']=$email;
$post['fullname']=get_member_name($uid);
$post['ccode']=$verifcode;
$post['uid']=$uid;
$post['emailpage'];
send_email('CONFIRM-NEW-EMAIL',$post);
return SUCCESS;
}
}
function activate_email($uid, $verifcode){
global $data;
$confirm=db_rows(
"SELECT * FROM `{$data['DbPrefix']}member_emails` WHERE `owner`='$uid' AND `verifcode`='$verifcode' AND `active`=0");
if (!isset($confirm[0])) return CONFIRMATION_NOT_FOUND;
db_query("UPDATE `{$data['DbPrefix']}member_emails` SET `active`=1 WHERE `owner`={$uid} AND `verifcode`='{$verifcode}'");
$info=get_member_info($uid);
$post['email']=$confirm[0]['email'];
$post['fullname']=get_member_name($uid);
send_email('NEW-EMAIL-ACTIVATED',$post);
return SUCCESS;
}
function make_email_prim($uid, $email){
global $data;
if (verify_email($email)) return INVALID_EMAIL_ADDRESS;
$emails=get_email_details($uid,false,false);
$oldprim=get_member_email($uid,true);
foreach ($emails as $addr)
if($addr['email']==$email && $addr['primary']) return ALREADY_PRIMARY;
elseif($addr['email']==$email && !$addr['active']) return EMAIL_NOT_ACTIVE;
elseif($addr['email']==$email){
db_query("UPDATE {$data['DbPrefix']}member_emails SET `primary`=1 WHERE `owner`='{$uid}' AND `email`='{$email}'");
db_query("UPDATE {$data['DbPrefix']}member_emails SET `primary`=0 WHERE `owner`='{$uid}' AND `email`='{$oldprim}'");
db_query("UPDATE {$data['DbPrefix']}members SET `email`='{$email}' WHERE `id`='{$uid}'");
return SUCCESS;
}
return EMAIL_NOT_FOUND;
}
function get_email_detail($email, $type=ALL){
global $data;
if ($type==CONFIRMED) $result=db_rows(
"SELECT * FROM {$data['DbPrefix']}member_emails WHERE `email`='$email' AND `active`=1");
else $result=db_rows(
"SELECT * FROM {$data['DbPrefix']}member_emails WHERE `email`='$email'");
return $result[0];
}
function delete_member_email($uid, $email){
global $data;
if(verify_email($email)) return INVALID_EMAIL_ADDRESS;
$todel=get_email_detail($email);
if(!$todel) return EMAIL_NOT_FOUND;
elseif($todel['primary']) return CANNOT_DELETE_PRIMARY;
db_query("DELETE FROM {$data['DbPrefix']}member_emails WHERE owner='{$uid}' AND `email`='{$email}'");
return SUCCESS;
}
function email_exists ($email){
global $data;
$result=db_rows("SELECT owner FROM {$data['DbPrefix']}members_emails WHERE email='{$email}'");
return (bool)$result['0'];
}
function get_user_id($unoremail){
global $data;
if(verify_email($unoremail)){
$result=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE (`username`='{$unoremail}') AND `active`=1 LIMIT 1");
return $result[0]['id'];
} else {
$result=db_rows(
"SELECT `owner` FROM `{$data['DbPrefix']}member_emails` e, ".
"`{$data['DbPrefix']}members` m".
" WHERE (e.`email`='{$unoremail}' AND m.`active`=1)".
' LIMIT 1');
return $result[0]['owner'];
}
}
function get_sponsor_id($uid){
global $data;
$result=db_rows(
"SELECT `sponsor` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1"
);
return $result[0]['sponsor'];
}
function get_sponsors($uid){
global $data;
$members=db_rows(
'SELECT `id`,`username`,`email`'.
" FROM `{$data['DbPrefix']}members`".
($uid?" WHERE `id`<>{$uid} AND `sponsor`<>{$uid}":'')
);
$result=array('--');
foreach($members as $value)$result[$value['id']]="{$value['username']} ({$value['email']})";
return $result;
}
function get_member_username($uid){
global $data;
if($uid<0)return 'system';
$result=db_rows(
"SELECT `username` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1");
return $result[0]['username'];
}
function get_member_name($uid){
global $data;
if($uid<0)return 'system';
$result=db_rows(
"SELECT `fname`,`lname` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1");
return $result[0]['fname'].' '.strtoupper($result[0]['lname']);
}
function get_member_info($uid){
global $data;
$result=db_rows(
"SELECT * FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1");
$result[0]['emails']=db_rows(
"SELECT * FROM `{$data['DbPrefix']}member_emails`".
" WHERE `owner`={$uid} AND `email`<>'{$result[0]['email']}'");
return $result[0];
}
function get_member_status($uid){
global $data;
$result=db_rows(
"SELECT `status` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1"
);
return $result[0]['status'];
}
function get_ip_history($uid, $order=''){
global $data;
$result=db_rows(
"SELECT `date`,`address` FROM `{$data['DbPrefix']}visits`".
" WHERE `member`={$uid} ".($order?"ORDER BY `{$order}`":'ORDER BY `date` DESC')
);
return $result;
}
function is_member_found($username, $password){
return (bool)get_member_id($username, $password);
}
function is_member_active($username){
return (bool)get_member_id($username, '', '`active`=1');
}
function set_member_status($uid, $active){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members`".
' SET `active`='.(int)$active.
" WHERE `id`={$uid}"
);
}
function set_member_status_ex($uid, $status){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members`".
" SET `status`={$status}".
" WHERE `id`={$uid}"
);
}
function get_member_status_ex($uid){
global $data;
$record=db_rows(
"SELECT `status` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1"
);
return $record[0]['status'];
}
function set_member_inactive($username){
global $data;
set_member_status(get_member_id($username), false);
}
function delete_member($uid){
global $data;
db_query(
"DELETE FROM `{$data['DbPrefix']}members` WHERE `id`={$uid}"
);
}
function select_balance($uid){
global $data;
if($uid<0){
$isql=
'SELECT SUM(`fees`) AS `summ`'.
" FROM `{$data['DbPrefix']}transactions`".
' WHERE (`status`=1 OR `status`=6) LIMIT 1'
;
}else{
$isql=
'SELECT SUM(`amount`-`fees`) AS `summ`'.
" FROM `{$data['DbPrefix']}transactions`".
" WHERE `receiver`={$uid} AND (`status`=1 OR `status`=6) LIMIT 1"
;
}
$outgoing=db_rows(
'SELECT SUM(`amount`) AS `summ`'.
" FROM `{$data['DbPrefix']}transactions`".
" WHERE `sender`={$uid} AND (`status`=1 OR `status`=6) LIMIT 1"
);
$pending_out_unreg=db_rows(
'SELECT SUM(`amount`) AS `summ`'.
" FROM `{$data['DbPrefix']}temp_pays`".
" WHERE `sender`={$uid} AND (`status`=0) LIMIT 1"
);
$incoming=db_rows($isql);
$outgoing=(double)$outgoing[0]['summ'];
$pending_out_unreg=(double)$pending_out_unreg[0]['summ'];
$outgoing=$outgoing+$pending_out_unreg;
$incoming=(double)$incoming[0]['summ'];
return $incoming-$outgoing;
}
function set_last_access($username){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members`".
" SET `ldate`='".date('Y-m-d H:i:s')."',".
"`last_ip`='{$_SERVER['REMOTE_ADDR']}'".
' WHERE `id`='.get_member_id($username)
);
}
function set_last_access_date($uid, $reset=false){
global $data;
if(!$reset)$curr=date('Y-m-d H:i:s');else $curr=0;
db_query(
"UPDATE `{$data['DbPrefix']}members`".
" SET `adate`='{$curr}'".
" WHERE `id`={$uid}"
);
}
function save_remote_ip($uid, $address){
global $data;
db_query(
"INSERT `{$data['DbPrefix']}visits`(`member`,`date`,`address`".
")VALUES({$uid},'".date('Y-m-d H:i:s')."','{$address}')"
);
}
function is_valid_mail($email){
global $data;
$result=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}members`".
" WHERE `email`='{$email}' LIMIT 1"
);
$emails=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}member_emails`".
" WHERE(`email`='{$email}') LIMIT 1"
);
return (bool)(!$result&&!$emails);
}
function get_member_by_email($email){
global $data;
$result=db_rows(
"SELECT `password`,`question`,`answer` FROM `{$data['DbPrefix']}members`".
" WHERE `email`='{$email}'"
);
if(!$result){
$emails=db_rows(
"SELECT `owner` FROM `{$data['DbPrefix']}member_emails`".
" WHERE `email`='{$email}' LIMIT 1"
);
if($emails){
$result=db_rows(
"SELECT `password`,`question`,`answer` FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$emails[0]['owner']}"
);
}
}
return $result[0];
}
function is_info_empty($uid){
global $data;
$result=db_rows(
'SELECT `empty`'.
" FROM `{$data['DbPrefix']}members`".
" WHERE `id`={$uid} LIMIT 1"
);
return (bool)$result[0]['empty'];
}
function select_info($uid, $post){
global $data;
$result=$post;
$member=get_member_info($uid);
if(!$member){
$_SESSION['uid']=0;
$_SESSION['login']=false;
header("Location:{$data['Host']}/index.htm");
echo('ACCESS DENIED.');
exit;
}
foreach($member as $key=>$value)if(!isset($post[$key]))$result[$key]=$value;
if(!$result['active']){
$_SESSION['uid']=0;
$_SESSION['login']=false;
header("Location:{$data['Host']}/index.htm");
echo('ACCESS DENIED.');
exit;
}
return $result;
}
function insert_profile_info($post){
global $data;
if(!$post['sponsor'])$post['sponsor']=0;
db_query(
"INSERT INTO `{$data['DbPrefix']}members`(".
'`sponsor`,`username`,`password`,`email`,`active`,`empty`,'.
'`fname`,`lname`,`company`,`regnum`,`drvnum`,'.
'`address`,`city`,`country`,`state`,`zip`,`phone`,`fax`'.
')VALUES('.
"{$post['sponsor']},'{$post['username']}','{$post['password']}',".
"'{$post['email']}',0,0,'{$post['fname']}','{$post['lname']}',".
"'{$post['company']}','{$post['regnum']}','{$post['drvnum']}',".
"'{$post['address']}','{$post['city']}','{$post['country']}',".
"'{$post['state']}','{$post['zip']}','{$post['phone']}',".
"'{$post['fax']}'".
')'
);
$newid=newid();
db_query("INSERT INTO `{$data['DbPrefix']}member_emails`
(`owner`,`email`,`active`,`primary`) VALUES
('{$newid}','{$post['email']}',1,1)
");
return $newid;
}
function update_profile_info($post, $uid, $notify=true){
global $data;
if(!$post['sponsor'])$post['sponsor']=0;
db_query(
"UPDATE `{$data['DbPrefix']}members` SET ".
"`sponsor`={$post['sponsor']},".
"`empty`=0,`fname`='{$post['fname']}',`lname`='{$post['lname']}',".
"`company`='{$post['company']}',`regnum`='{$post['regnum']}',".
"`drvnum`='{$post['drvnum']}',`address`='{$post['address']}',".
"`city`='{$post['city']}',`country`='{$post['country']}',".
"`state`='{$post['state']}',`zip`='{$post['zip']}',".
"`phone`='{$post['phone']}',`fax`='{$post['fax']}',".
"`description`='{$post['description']}'".
" WHERE `id`={$uid}"
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-MEMBER-PROFILE', $post);
}
}
function update_private_info($post, $uid){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members` SET ".
"`username`='{$post['username']}',`password`='{$post['password']}',".
"`email`='{$post['email']}' WHERE `id`={$uid}"
);
}
function update_member_password($uid, $password, $notify=true){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members` SET ".
"`password`='{$password}'".
" WHERE `id`={$uid}"
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-MEMBER-PROFILE', $post);
}
}
function update_member_question($uid, $question, $answer, $notify=true){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}members` SET ".
"`question`='{$question}',`answer`='{$answer}'".
" WHERE `id`={$uid}"
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-MEMBER-PROFILE', $post);
}
}
function insert_email_info($email, $uid, $notify=true){
global $data;
db_query(
"INSERT INTO `{$data['DbPrefix']}member_emails`(".
'`owner`,`email`,`status`'.
')VALUES('.
"{$uid},'{$email}',0)"
);
if($notify)send_email_request(newid());
return newid();
}
function delete_email_info($gid){
global $data;
db_query(
"DELETE FROM `{$data['DbPrefix']}member_emails`".
" WHERE `id`={$gid}"
);
}
function send_email_request($gid){
global $data;
$emails=db_rows(
"SELECT * FROM `{$data['DbPrefix']}member_emails`".
" WHERE `id`={$gid} LIMIT 1"
);
if($emails[0]){
$post['ccode']=gencode();
db_query(
"UPDATE `{$data['DbPrefix']}member_emails`".
" SET `confirm`='{$post['ccode']}', `status`=1".
" WHERE `id`={$gid}"
);
$post['email']=$emails[0]['email'];
send_email('CONFIRM-EMAIL', $post);
}
}
function set_default_email($gid){
global $data;
$emails=db_rows(
"SELECT * FROM `{$data['DbPrefix']}member_emails`".
" WHERE `id`={$gid} LIMIT 1"
);
if($emails[0]){
db_query(
"INSERT INTO `{$data['DbPrefix']}member_emails`(".
'`owner`,`email`,`status`'.
')VALUES('.
"{$emails[0]['owner']},'".get_member_email($emails[0]['owner'])."',2)"
);
db_query(
"UPDATE `{$data['DbPrefix']}members`".
" SET `email`='{$emails[0]['email']}'".
" WHERE `id`={$emails[0]['owner']}"
);
db_query(
"DELETE FROM `{$data['DbPrefix']}member_emails`".
" WHERE `id`={$emails[0]['id']}"
);
}
}
function insert_card_info($post, $uid, $notify=true){
global $data;
db_query(
"INSERT INTO `{$data['DbPrefix']}cards`(".
'`owner`,`ctype`,`cname`,`cnumber`,`ccvv`,`cmonth`,`cyear`,'.
'`status`,`default`'.
')VALUES('.
"{$uid},'{$post['ctype']}','{$post['cname']}',".
"'{$post['cnumber']}','{$post['ccvv']}',".
"{$post['cmonth']},{$post['cyear']},".
'0,0)'
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-CARD-INFORMATION', $post);
}
return newid();
}
function update_card_info($post, $gid, $uid, $notify=true){
global $data;
$cnumber=(is_changed($post['cnumber']))?"`cnumber`='{$post['cnumber']}',":'';
$ccvv=(is_changed($post['ccvv']))?"`ccvv`='{$post['ccvv']}',":'';
db_query(
"UPDATE `{$data['DbPrefix']}cards` SET ".
"`ctype`='{$post['ctype']}',`cname`='{$post['cname']}',".
"{$cnumber}{$ccvv}".
"`cmonth`={$post['cmonth']},`cyear`={$post['cyear']}".
" WHERE `id`={$gid}"
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-CARD-INFORMATION', $post);
}
}
function delete_card($gid){
global $data;
db_query(
"DELETE FROM `{$data['DbPrefix']}cards`".
" WHERE `id`={$gid}"
);
}
function select_cards($uid, $hiden=true, $id=0, $single=false){
global $data;
$cards=db_rows(
"SELECT * FROM `{$data['DbPrefix']}cards`".
" WHERE `owner`={$uid}".
($id?" AND `id`={$id}":'').($single?' LIMIT 1':'')
);
$result=array();
foreach($cards as $key=>$value){
foreach($value as $name=>$v){
$result[$key][$name]=$v;
if($hiden){
if($name=='cnumber') $result[$key][$name]=encode($v, 4);
elseif($name=='ccvv') $result[$key][$name]=encode($v, 1);
}
}
}
return $result;
}
function insert_bank_info($post, $uid, $notify=true){
global $data;
db_query(
"INSERT INTO `{$data['DbPrefix']}banks`(".
'`owner`,`bname`,`baddress`,`bcity`,`bzip`,`bcountry`,`bstate`,'.
'`bphone`,`bnameacc`,`baccount`,`btype`,`brtgnum`,`bswift`,'.
'`status`,`default`'.
')VALUES('.
"{$uid},'{$post['bname']}','{$post['baddress']}','{$post['bcity']}',".
"'{$post['bzip']}','{$post['bcountry']}','{$post['bstate']}',".
"'{$post['bphone']}','{$post['bnameacc']}','{$post['baccount']}',".
"'{$post['btype']}','{$post['brtgnum']}','{$post['bswift']}',".
'0,0)'
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-BANK-INFORMATION', $post);
}
return newid();
}
function update_bank_info($post, $gid, $uid, $notify=true){
global $data;
db_query(
"UPDATE `{$data['DbPrefix']}banks` SET ".
"`bname`='{$post['bname']}',`baddress`='{$post['baddress']}',".
"`bcity`='{$post['bcity']}',`bzip`='{$post['bzip']}',".
"`bcountry`='{$post['bcountry']}',`bstate`='{$post['bstate']}',".
"`bphone`='{$post['bphone']}',`bnameacc`='{$post['bnameacc']}',".
"`baccount`='{$post['baccount']}',`btype`='{$post['btype']}',".
"`brtgnum`='{$post['brtgnum']}',`bswift`='{$post['bswift']}'".
" WHERE `id`={$gid}"
);
if($notify){
$post['email']=get_member_email($uid);
send_email('UPDATE-BANK-INFORMATION', $post);
}
}
function delete_bank($gid){
global $data;
db_query(
"DELETE FROM `{$data['DbPrefix']}banks`".
" WHERE `id`={$gid}"
);
}
function select_banks($uid, $id=0, $single=false){
global $data;
$banks=db_rows(
"SELECT * FROM `{$data['DbPrefix']}banks`".
" WHERE `owner`={$uid}".
($id?" AND `id`={$id}":'').($single?' LIMIT 1':'')
);
$result=array();
foreach($banks as $key=>$value){
foreach($value as $name=>$v)$result[$key][$name]=$v;
}
return $result;
}
function set_trtype($uid, $dir){
switch($dir){
case 'both':
return "(`sender`={$uid} OR `receiver`={$uid})";
case 'incoming':
return "`receiver`={$uid}";
case 'outgoing':
return "`sender`={$uid}";
}
return '';
}
function get_trans_count($where=''){
global $data;
$result=db_rows(
'SELECT COUNT(`id`) AS `count`'.
" FROM `{$data['DbPrefix']}transactions`{$where} LIMIT 1"
);
return $result[0]['count'];
}
function get_transactions_count($uid, $dir='both', $extra='1'){
$result=get_trans_count(
' WHERE '.($uid>0?set_trtype($uid, $dir).
($extra?" AND {$extra}":''):($extra?" {$extra}":''))
);
return $result;
}
function get_transactions_summ($where){
global $data;
$rows=db_rows(
'SELECT SUM(`amount`) AS `summ`, SUM(`fees`) AS `fees`'.
" FROM `{$data['DbPrefix']}transactions`".
($where?" WHERE {$where}":'').' ORDER BY `tdate` LIMIT 1'
);
$result['summ']=$rows[0]['summ'];
$result['fees']=$rows[0]['fees'];
return $result;
}
function get_transactions_summary($dateA, $dateB){
global $data;
foreach($data['TransactionType'] as $key=>$value){
$rows=get_transactions_summ(
"`type`={$key} AND".
" UNIX_TIMESTAMP(`tdate`)>={$dateA} AND".
" UNIX_TIMESTAMP(`tdate`)<{$dateB}"
);
$result[$value]['Summ']=prnpays($rows['summ']?$rows['summ']:0, false);
$result[$value]['Fees']=prnpays($rows['fees']?$rows['fees']:0, false);
}
return $result;
}
function get_transactions_year(){
global $data;
$years=db_rows(
'SELECT MIN(YEAR(`tdate`)) AS `min`, MAX(YEAR(`tdate`)) AS `max`'.
" FROM `{$data['DbPrefix']}transactions` LIMIT 1"
);
$result['min']=$years[0]['min'];
$result['max']=$years[0]['max'];
return $result;
}
function get_transactions_period(){
global $data;
$period=db_rows(
'SELECT MIN(`tdate`) AS `min`, MAX(`tdate`) AS `max`'.
" FROM `{$data['DbPrefix']}transactions` LIMIT 1"
);
$result['min']=getdate(strtotime($period[0]['min']));
$result['max']=getdate(strtotime($period[0]['max']));
return $result;
}
function can_refund($id, $uid){
global $data;
$balance=select_balance($uid);
$result=db_rows(
"SELECT `id` FROM `{$data['DbPrefix']}transactions`".
" WHERE `id`={$id} AND `receiver`={$uid}".
' AND `type`=0 AND (`status`=0 OR `status`=1)'.
" AND `amount`<{$balance}".
" AND TO_DAYS(NOW())-TO_DAYS(`tdate`)<{$data['RefundPeriod']}"
);
return $result[0];
}
function get_status_color($status){
$result='000000';
switch($status){
case 0:
$result='blue';
break;
case 1:
$result='green';
break;
case 2:
$result='red';
break;
case 3:
$result='maroon';
}
return $result;
}
function get_transactions(
$uid, $dir='both', $type=-1, $status=-1, $start=0,
$count=0, $order='', $suser='', $sdate=''
){
global $data;
if($suser||$sdata){
$start=0;
$count=0;
}
$order=($order?$order:'ORDER BY `tdate` DESC');
$limit=($start?($count?" LIMIT {$start},{$count}":" LIMIT {$start}"):
($count?" LIMIT {$count}":''));
$trans=db_rows(
'SELECT *,(TO_DAYS(NOW())-TO_DAYS(`tdate`)) as `period`'.
" FROM `{$data['DbPrefix']}transactions`".
($uid?' WHERE '.set_trtype($uid, $dir):'').
($type<0?'':($uid?' AND ':' WHERE ')."`type`={$type}").
($status<0?'':($uid||$type>=0?' AND ':' WHERE ')."`status`={$status}").
" {$order}{$limit}"
);
$result=array();
foreach($trans as $key=>$value){
if($suser){
if(
strpos(get_member_username($value['sender']), $suser)===false
&&
strpos(get_member_username($value['receiver']), $suser)===false
)continue;
}elseif($sdate){
if(strpos($value['tdate'], $sdate)===false)continue;
}
$dir=(bool)($value['sender']!=$uid);
$result[$key]['id']=$value['id'];
$result[$key]['direction']=$dir?'FROM':'TO';
$result[$key]['sender']=$value['sender'];
$result[$key]['senduser']=prnuser($value['sender']);
$result[$key]['receiver']=$value['receiver'];
$