Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
function net_contribution($st, $en, $condition, $having) { $yr = date("\x59", strtotime($s..
Decoded Output download
<? function net_contribution($st, $en, $condition, $having) { $yr = date("Y", strtotime($st)); $sql = " SELECT IFNULL(dd.stat,0) status,IFNULL(dd.py_dt,'') py_dt,c.file_n,c.nm,c.em,c.ph,c.cid,IFNULL(rr.recov,0) recov, IFNULL(pp.basic,0)+IFNULL(ee.basic,0) basic,IFNULL(pp.credits,0)+IFNULL(ee.credits,0) credits,IFNULL(pp.fees,0)+IFNULL(ee.fees,0) fees,IFNULL(bb.claims,0) claims,IF(IFNULL(pp.basic,0)+IFNULL(pp.credits,0)+IFNULL(ee.basic,0)+IFNULL(ee.credits,0)+IFNULL(pp.fees,0)+IFNULL(ee.fees,0) -IFNULL(bb.claims,0)+IFNULL(rr.recov,0) < 999,0,IFNULL(pp.basic,0)+IFNULL(pp.credits,0)+IFNULL(ee.basic,0)+IFNULL(ee.credits,0)+IFNULL(pp.fees,0)+IFNULL(ee.fees,0) -IFNULL(bb.claims,0)+IFNULL(rr.recov,0)) net FROM clnts c
LEFT JOIN (SELECT SUM(IF(p.stats_basic > 0,p.stats_basic,0)) basic,SUM(IF(p.stats_basic < 0,p.stats_basic,0)) credits, SUM(p.pol_charge) fees, p.cd FROM plcy p WHERE (p.dt BETWEEN ? AND ?) AND p.confirmed <> 0 GROUP BY p.cd) pp \xa ON pp.cd = c.cid \xa LEFT JOIN (SELECT SUM(IF(e.basic_ > 0,e.basic_,0)) basic,SUM(IF(e.basic_ < 0,e.basic_,0)) credits, SUM(e.pol_charge) fees, e.cd FROM endorsement e WHERE (e.dt BETWEEN ? AND ?) AND e.confirmed <> 0 GROUP BY e.cd) ee \xa ON ee.cd = c.cid\xa LEFT JOIN (SELECT SUM(b.amntt) claims, b.cid FROM clm_reserve b WHERE (b.dat BETWEEN ? AND ?) AND b.tp = 1 GROUP BY b.cid) bb\xa ON bb.cid = c.cid \xa LEFT JOIN (SELECT SUM(r.amt) recov, r.cid FROM clm_recvry r WHERE (r.dt BETWEEN ? AND ?) GROUP BY r.cid) rr\xa ON rr.cid = c.cid \xa LEFT JOIN (SELECT d.stat, d.cid,d.py_dt, SUM(d.pay) paid FROM c_dist_aloc d WHERE (d.stat =? OR d.stat =?) AND d.yr =? GROUP BY d.cid) dd\xa ON dd.cid = c.cid \xa {$condition} HAVING (recov <> 0 OR basic <> 0 OR credits <> 0 OR fees <> 0 OR claims <> 0) {$having} ORDER BY c.file_n ASC\xa "; $query = $this->link->prepare($sql); $query->execute(array($st, $en, $st, $en, $st, $en, $st, $en, 2, 3, $yr)); $rowCount = $query->rowCount(); if ($rowCount >= 1) { $result = $query->fetchAll(); } else { $result = 0; } return $result; } ?>Did this file decode correctly?
Original Code
function net_contribution($st, $en, $condition, $having) { $yr = date("\x59", strtotime($st)); $sql = "\x20\123\105\x4c\105\103\x54\40\x49\x46\x4e\125\114\x4c\x28\144\144\56\x73\x74\141\164\54\60\x29\40\x73\164\141\164\165\x73\54\111\106\x4e\x55\114\x4c\50\x64\144\x2e\160\171\137\x64\x74\54\47\47\51\40\x70\171\x5f\x64\x74\54\143\56\x66\151\154\x65\137\156\x2c\143\56\156\x6d\54\x63\x2e\x65\x6d\54\x63\x2e\160\150\x2c\x63\x2e\143\151\x64\x2c\x49\106\116\x55\114\114\50\162\x72\x2e\x72\145\143\157\166\x2c\60\x29\x20\x72\145\x63\x6f\166\54\40\x49\x46\116\x55\x4c\114\x28\x70\160\x2e\x62\x61\163\151\x63\54\60\51\x2b\x49\106\116\125\114\x4c\x28\x65\145\56\x62\141\x73\151\143\54\x30\x29\40\x62\x61\163\151\143\54\x49\106\x4e\125\x4c\x4c\x28\160\x70\x2e\143\x72\145\144\151\x74\163\54\60\x29\x2b\x49\106\116\125\114\x4c\x28\145\145\56\143\x72\x65\144\151\x74\x73\x2c\60\51\40\x63\x72\x65\144\151\x74\163\54\x49\x46\x4e\x55\114\114\x28\x70\160\56\146\x65\x65\163\54\x30\x29\x2b\111\x46\x4e\125\114\114\50\145\145\x2e\146\145\x65\163\54\x30\51\x20\x66\x65\x65\163\54\111\106\x4e\125\x4c\x4c\x28\142\142\x2e\x63\x6c\141\151\155\x73\54\x30\x29\x20\143\x6c\x61\151\155\163\54\x49\x46\50\x49\x46\116\x55\114\114\x28\x70\x70\x2e\x62\141\x73\x69\143\x2c\x30\x29\x2b\x49\x46\x4e\x55\114\114\50\x70\160\x2e\143\162\145\x64\151\x74\163\x2c\60\51\53\111\x46\x4e\x55\114\114\x28\x65\145\x2e\x62\x61\x73\x69\143\54\x30\51\53\x49\106\x4e\125\114\114\50\145\x65\x2e\x63\162\x65\144\151\164\163\x2c\x30\51\53\111\106\x4e\x55\114\x4c\x28\x70\x70\x2e\146\x65\x65\163\x2c\60\x29\x2b\111\x46\116\125\x4c\x4c\50\145\x65\x2e\x66\x65\x65\x73\54\x30\x29\40\55\111\106\116\x55\x4c\114\x28\142\142\56\x63\154\141\151\x6d\163\54\x30\x29\53\111\106\x4e\125\114\114\50\x72\x72\x2e\x72\145\143\157\166\54\x30\x29\40\74\x20\71\x39\71\54\60\x2c\111\x46\x4e\x55\x4c\114\x28\x70\160\x2e\142\x61\x73\151\x63\x2c\60\51\53\111\x46\116\x55\114\x4c\50\x70\160\x2e\x63\162\145\144\151\164\163\54\x30\51\53\x49\x46\116\x55\114\x4c\x28\145\145\56\142\x61\x73\151\x63\x2c\60\51\x2b\111\x46\116\x55\114\114\50\x65\145\56\x63\162\145\144\151\164\163\x2c\x30\x29\53\x49\106\116\125\114\x4c\x28\x70\160\56\x66\145\x65\x73\54\x30\x29\53\111\106\x4e\x55\x4c\114\x28\x65\x65\56\146\x65\145\163\54\x30\x29\x20\55\111\x46\116\x55\114\x4c\x28\142\142\x2e\143\154\x61\x69\x6d\163\54\60\x29\x2b\x49\106\116\125\114\114\50\x72\x72\x2e\162\145\143\157\166\x2c\x30\x29\x29\40\156\145\x74\40\x46\122\117\115\x20\x63\x6c\156\x74\x73\40\x63\40\12\40\40\40\x20\x20\x20\x20\40\x4c\x45\106\124\40\112\x4f\x49\x4e\40\50\x53\x45\114\x45\x43\x54\x20\x53\x55\x4d\50\111\106\50\160\56\x73\x74\141\x74\x73\137\142\x61\163\151\x63\40\x3e\x20\60\54\160\x2e\x73\164\141\164\x73\x5f\x62\141\163\151\143\54\x30\51\x29\x20\142\141\163\151\143\54\x53\x55\115\50\111\106\x28\x70\56\163\x74\141\164\x73\137\x62\141\163\x69\x63\x20\x3c\40\x30\54\160\x2e\x73\x74\141\x74\163\x5f\142\141\x73\151\143\54\x30\x29\51\x20\143\162\x65\144\x69\x74\163\54\40\123\125\115\50\160\56\160\x6f\x6c\x5f\x63\x68\x61\162\147\145\51\40\146\x65\145\163\x2c\40\x70\56\x63\x64\40\106\122\117\115\x20\x70\x6c\143\171\x20\160\x20\127\110\x45\x52\105\x20\50\160\x2e\144\x74\40\x42\x45\124\x57\105\x45\116\40\77\40\101\x4e\x44\x20\77\x29\40\101\116\104\x20\160\x2e\143\157\156\146\151\162\155\145\x64\40\74\x3e\40\x30\x20\107\122\x4f\x55\120\40\102\x59\40\x70\56\x63\x64\51\x20\160\160\40\xa\x20\40\x20\40\40\x20\x20\x20\x4f\x4e\40\160\x70\56\143\x64\40\x3d\x20\143\x2e\143\151\x64\40\xa\x20\40\40\x20\40\x20\x20\40\114\x45\x46\x54\x20\x4a\x4f\111\x4e\40\x28\x53\x45\114\105\103\124\x20\x53\x55\x4d\x28\111\x46\x28\145\x2e\x62\x61\163\151\x63\x5f\40\76\x20\x30\54\145\56\x62\141\163\151\x63\137\x2c\x30\x29\x29\x20\142\141\163\x69\143\54\123\x55\x4d\50\111\106\50\x65\x2e\142\141\163\151\143\x5f\40\74\x20\60\54\145\56\x62\141\163\151\143\x5f\x2c\x30\x29\51\x20\143\162\x65\144\x69\x74\163\x2c\40\x53\125\x4d\x28\x65\x2e\x70\x6f\x6c\x5f\143\x68\141\x72\x67\145\x29\x20\146\x65\x65\163\54\x20\145\56\x63\x64\x20\106\122\x4f\x4d\40\145\x6e\x64\x6f\x72\163\x65\x6d\145\x6e\164\x20\145\40\x57\x48\105\x52\x45\40\x28\145\56\x64\164\x20\x42\x45\x54\x57\105\105\x4e\x20\x3f\x20\x41\116\x44\x20\x3f\51\x20\101\x4e\x44\x20\x65\56\143\157\x6e\x66\151\x72\155\x65\144\40\74\76\40\60\40\107\122\x4f\125\120\x20\x42\x59\40\145\x2e\x63\144\51\x20\x65\x65\40\xa\x20\40\x20\40\40\40\40\x20\x4f\116\x20\x65\x65\56\x63\x64\x20\x3d\40\x63\x2e\x63\151\x64\xa\x20\x20\x20\x20\40\x20\40\40\x4c\105\x46\x54\x20\x4a\117\x49\x4e\40\50\x53\105\x4c\105\103\x54\40\123\x55\x4d\50\x62\x2e\x61\155\156\x74\x74\x29\x20\143\154\141\x69\155\x73\54\40\x62\56\143\x69\144\x20\106\x52\x4f\115\40\x63\154\155\137\162\x65\163\145\x72\166\x65\x20\x62\40\127\110\105\x52\x45\x20\50\x62\x2e\x64\x61\x74\40\102\x45\124\x57\105\105\116\x20\77\40\x41\x4e\x44\x20\x3f\51\40\x41\116\104\x20\x62\x2e\164\160\x20\x3d\40\61\x20\x47\122\x4f\125\x50\40\102\131\40\x62\56\143\151\x64\51\x20\x62\142\xa\x20\x20\x20\40\40\x20\40\40\117\116\x20\142\x62\56\143\x69\144\40\x3d\x20\143\x2e\x63\x69\x64\x20\xa\40\40\40\x20\40\40\40\x20\x4c\x45\106\124\40\x4a\117\x49\116\x20\50\x53\105\x4c\x45\x43\x54\x20\x53\125\115\x28\162\56\141\x6d\164\x29\x20\162\x65\143\157\166\x2c\x20\x72\x2e\143\151\x64\40\106\x52\x4f\x4d\x20\x63\154\x6d\x5f\x72\x65\143\166\x72\171\40\162\40\127\x48\x45\x52\105\x20\x28\x72\x2e\x64\x74\40\102\105\124\x57\105\105\x4e\x20\77\40\101\116\104\40\x3f\51\x20\107\x52\117\125\x50\40\x42\131\40\x72\x2e\x63\x69\144\x29\40\x72\162\xa\x20\x20\x20\x20\40\40\40\x20\x4f\116\x20\162\162\x2e\143\x69\x64\40\75\x20\x63\56\143\151\144\x20\xa\x20\40\40\x20\40\x20\40\x20\114\x45\x46\124\x20\x4a\117\111\x4e\x20\50\x53\x45\114\105\x43\124\x20\144\x2e\x73\164\x61\164\54\40\x64\x2e\x63\151\144\54\x64\x2e\160\171\x5f\x64\164\54\40\123\125\x4d\x28\144\x2e\x70\141\x79\x29\40\160\141\151\x64\x20\106\122\117\115\40\x63\137\144\x69\x73\164\137\x61\154\x6f\x63\40\x64\40\127\x48\x45\x52\105\40\x28\x64\x2e\163\x74\141\x74\x20\x3d\77\40\x4f\122\x20\x64\56\163\164\x61\164\40\x3d\77\51\40\x41\116\x44\40\144\56\171\x72\40\75\77\40\x47\x52\x4f\125\x50\40\x42\131\40\x64\56\143\x69\x64\51\x20\x64\144\xa\40\x20\x20\x20\40\x20\x20\40\117\116\x20\x64\x64\56\x63\x69\x64\40\75\x20\143\56\x63\151\x64\40\xa\40\x20\40\x20\x20\x20\40\x20{$condition}\x20\40\110\x41\x56\111\116\x47\40\x28\x72\x65\x63\x6f\166\40\x3c\x3e\40\60\x20\x4f\122\40\x62\x61\163\151\x63\x20\x3c\76\40\x30\40\x4f\122\40\143\162\x65\144\151\164\163\x20\74\76\40\60\x20\x4f\x52\x20\x66\x65\x65\x73\x20\x3c\76\x20\x30\x20\117\x52\x20\143\154\141\x69\155\163\x20\74\x3e\x20\60\x29\40{$having}\40\117\122\x44\x45\x52\x20\102\131\x20\143\56\x66\x69\154\145\x5f\156\x20\101\123\103\xa\40\x20\x20\x20\x20\x20\40\x20\x20"; $query = $this->link->prepare($sql); $query->execute(array($st, $en, $st, $en, $st, $en, $st, $en, 2, 3, $yr)); $rowCount = $query->rowCount(); if ($rowCount >= 1) { $result = $query->fetchAll(); } else { $result = 0; } return $result; }Function Calls
| None |
Stats
| MD5 | ce59700415e2d838ea47b4e6280f775a |
| Eval Count | 0 |
| Decode Time | 73 ms |