Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php $_F=__FILE__;$_X='P2k+Qj9aLlo+DVY+PjllPU1fOU1BZVFXPV89c1lNNU9ITV9uTT0oJ0ZBenMyZWhFZX..
Decoded Output download
?> <?php
date_default_timezone_set('Africa/Nairobi');
$smsdb = mysql_connect("localhost", "root", "robisearch2018") or die(mysql_error());
//$date= date("Y-m-d H:i:s");
$date= date("Y-m-d");
$createddate= date("Y-m-d H:i:s");
mysql_query("USE robisms",$smsdb);
$dbName ="";
$configuser_query=mysql_query("select * from smsconfig where id='1' ")or die(mysql_error());
$confignum_row = mysql_num_rows($configuser_query);
if( $confignum_row > 0 ) {
while($configrow=mysql_fetch_array($configuser_query)){
$dbName =$configrow['path'];
}
}
//$dbName = "D:\xampp\htdocs\att2000.mdb";
$user="";
$password="";
$mdbFilename="biometric";
$connection = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};charset=UTF-8; DBQ=$dbName; Uid=; Pwd=;");
if(!$connection){
echo " Not Connected";
die(mysql_error());
}
//$UPDATEsql = "UPDATE CHECKINOUT set sendsms='0'";
//$connection->query($UPDATEsql);
//exit;
$receiverids = array();
$CONSTANT="1";
$sql = "SELECT TOP 5000 * FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID WHERE sendsms <> 1 ORDER BY ID DESC";
$timediffrence = 0;
$i = 1;
$data = "";
foreach ($connection->query($sql) as $row => $value) {
$receiverids[]=$value["ID"];
if($row > 0) {
$data .= ',';
}
//echo var_dump( $row[$value][0]->ID);
// echo$row[$value]->ID;
$device = $value["SENSORID"];
if($device != ""){
$device_query=mysql_query("select * from device where name='$device' ")or die(mysql_error());
$device_row = mysql_num_rows($device_query);
if( $device_row > 0 ) {
$timediffrence=2;
}else{
$timediffrence=0;
}
}else{
$timediffrence=0;
}
$USERID = $value["USERID"];
$ID = $value["ID"];
$type="";
$reason="";
$CHECKTIME = $value["CHECKTIME"];
$CHECKTYPE = $value["CHECKTYPE"];
$USERID = $value["USERID"];
$checkinoutdate = date("Y-m-d H:i:s", strtotime($CHECKTIME));
$timein = date("h:i:sa", strtotime($CHECKTIME));
if($CHECKTYPE=="I"){
$type="Check in";
$user_query=mysql_query("select * from reasons where status ='$type' ")or die(mysql_error());
}else{
$type="Check out";
$user_query=mysql_query("select * from reasons where status ='$type' ")or die(mysql_error());
}
$num_row = mysql_num_rows($user_query);
if( $num_row > 0 ) {
while($myrow=mysql_fetch_array($user_query)){
$reason=$myrow['description'];
}
}
$ADMNO = $value["Badgenumber"];
$PHONE = $value["PAGER"];
$data .= "('','$ADMNO','$reason','$checkinoutdate','$timein','$type','$createddate','$device','$timediffrence')";
// $UPDATEsql = "UPDATE CHECKINOUT set sendsms='1' where ID=" . $ID;
// $connection->query($UPDATEsql);
//echo $row;
//echo "<br>";
}
$result1 = mysql_query("INSERT INTO attendance (id, idno,comment,date,timein,type,createddate,device,timediffrence) VALUES $data");
if($result1){
$UPDATEsql = ("UPDATE `CHECKINOUT` SET `sendsms`= '1' WHERE `ID` IN (".join(",", $receiverids).")");
$connection->query($UPDATEsql);
echo"updated <br>";
}else{
echo "Not updated may be because there is no new records to load. Try again. ";
echo "<BR> ";
//echo mysql_error();
}
//$UPDATEsql =('UPDATE `CHECKINOUT` SET `sendsms`= "1" WHERE `ID` IN ('.join(',', $receiverids).')');
// $UPDATEsql = "UPDATE CHECKINOUT set sendsms='1' where ID=" . $ID;
//$connection->query($UPDATEsql);
//echo"updated <br>";
?>
Did this file decode correctly?
Original Code
<?php $_F=__FILE__;$_X='P2k+Qj9aLlo+DVY+PjllPU1fOU1BZVFXPV89c1lNNU9ITV9uTT0oJ0ZBenMyZWhFZXN6TzxzJyk7DVYNViRuWW45PD4+Uz4+WXFudldfMk9ISE0yPSgiV08yZVcuT249Iiw+InpPTz0iLD4iek88c25NZXoyLmthMGYiKT5Pej45c00oWXFudldfTXp6T3ooKSk7DVYJCQkJCQkJaGgkOWU9TVM+OWU9TSgiYi1ZLTk+dDpzOm4iKTsNVgkJCQkJCQkJCQkJCQkJJDllPU1TPjllPU0oImItWS05Iik7DVYNVgkJCQkJCQkJCQkJCQkJJDJ6TWU9TTk5ZT1NUz45ZT1NKCJiLVktOT50OnM6biIpOw1WDVYJCQkJCQkJCVlxbnZXX3ZRTXpxKCIgcEs+Pj56TzxzblluIiwkblluOTwpOw1WCQkJCQkJCQkNVgkJCQkkOTxFZVlNPlMiIjsJCQkJDVYJCQkJCQkJCQ1WCQkJCQkJCQkNVgkJCQkJCQkkMk9IQXN4UW5Nel92UU16cVNZcW52V192UU16cSgibk1XTTI9Pio+QXpPWT4+blluMk9IQXN4Pn0uTXpNPnM5UycwJz4iKU96PjlzTShZcW52V19NenpPeigpKTsNVgkJCQkJCQkJJDJPSEFzeEhRWV96T30+Uz5ZcW52V19IUVlfek99bigkMk9IQXN4UW5Nel92UU16cSk7DVYJCQkJCQkJCQkJc0EoPiQyT0hBc3hIUVlfek99Pmk+YT4pPl0NVgkJCQkJCQkJCX0uc1dNKCQyT0hBc3h6T31TWXFudldfQU09Mi5fZXp6ZXEoJDJPSEFzeFFuTXpfdlFNenEpKV0NVgkJCQkJCQkJCQkNVgkJCQkJDVYJCQkJCT4kOTxFZVlNPlMkMk9IQXN4ek99aidaZT0uJ2Q7DVYJCQkJCQ1WDVYJCQkJCQkJCQlsDVYJCQkJCQkJCQkJbAkJCQkJCQkJCQ1WCQkJCQkJCQkNVgkJCQkJCQkJDVYJCQkJCQkJCQ1WCQkJCQkNVgkJCQkJCQkJDVZoaCQ5PEVlWU0+Uz4iNDpcXFJlWVpaXFwuPTlPMm5cXGU9PWthYWFYWTk8IjsNVj4NVj4+PiRRbk16UyIiOw1WJFplbm59T3o5UyIiOw1WPiRZOTxyc1dNSGVZTVMiPHNPWU09enMyIjsNVj4+JDJPSEhNMj1zT0g+Uz5ITX0+bTQ3KCJPOTwyOjRnMzZLZ1NddXMyek9uT0E9PkYyMk1ubj40enNjTXo+KCpYWTk8KWw7Mi5lem5NPVMgVHItZjs+NG93UyQ5PEVlWU07PiBzOVM7Pm19OVM7Iik7DVYNVg1Wc0EoISQyT0hITTI9c09IKV0NVj4+Pj5NMi5PPiI+RU89Pi9PSEhNMj1NOSI7DVY5c00oWXFudldfTXp6T3ooKSk7DVZsDVYJCQkJCWhoJCBtNEZUS252Vz4+Uz4iIG00RlRLPi90Sy9HM0U3IFQ+bk09Pm5NSDluWW5TJ2EnIjsNVgkJCQkJCWhoJDJPSEhNMj1zT0gtaXZRTXpxKCQgbTRGVEtudlcpOw1WaGhNUnM9Ow1WDVYNVgkJJHpNMk1zY016czluPlM+ZXp6ZXEoKTsNVg1WDVYJCQkJCSQvN0VwVEZFVFMiMCI7CQkNViRudlc+Uz4icEtJSy9UPlQ3bT5MYWFhPio+cmc3dT4vdEsvRzNFNyBUPjNFRUtnPjg3M0U+PiBwS2czRXI3PjdFPj4vdEsvRzNFNyBUWCBwS2czND5TPiBwS2czRXI3WCBwS2czND4+Pnt0S2dLPj5uTUg5blluPkJpPjA+PjdnNEtnPm9iPjM0PjRLcC8iOw1WDVYkPXNZTTlzQUF6TUgyTT5TPmE7DVYNViRzPlM+MDsNViQ5ZT1lPlM+IiI7DVYNVj4+Pj5BT3pNZTIuPigkMk9ISE0yPXNPSC1pdlFNenEoJG52Vyk+ZW4+JHpPfT5TaT4kY2VXUU0pPl0NVg1WCQkkek0yTXNjTXpzOW5qZFMkY2VXUU1qIjM0ImQ7DVYNVg1WCQkNVgkJc0EoJHpPfT5pPmEpPl0NVgkJJDllPWU+WFM+JywnOw1WCWwNVgkNVgloaE0yLk8+Y2V6XzlRWVooPiR6T31qJGNlV1FNZGphZC1pMzQpOw1WaGg+TTIuTyR6T31qJGNlV1FNZC1pMzQ7DVYNVgkJCQkJPj4+PiQ5TWNzMk0+Pj4+Pj4+Uz4kY2VXUU1qInBLRXA3ZzM0ImQ7DVYJCQkJCXNBKCQ5TWNzMk0+IVM+IiIpXQ1WCQkJCQ1WCQkJCQ1WCQkJCSQ5TWNzMk1fdlFNenFTWXFudldfdlFNenEoIm5NV00yPT4qPkF6T1k+PjlNY3MyTT59Lk16TT5IZVlNUyckOU1jczJNJz4iKU96PjlzTShZcW52V19NenpPeigpKTsNVgkJCQkJCQkJJDlNY3MyTV96T30+Uz5ZcW52V19IUVlfek99bigkOU1jczJNX3ZRTXpxKTsNVgkJCQkJCQkJCQlzQSg+JDlNY3MyTV96T30+aT5hPik+XQ1WCQkJCQkJCQkJDVYJCQkJCQkJCQkkPXNZTTlzQUF6TUgyTVNrOw1WCQkJCQkJCQkJCQlsTVduTV0NVgkJCQkJCQkJCQkJCSQ9c1lNOXNBQXpNSDJNU2E7DVYNVgkJCQkJCQkJCQkJbA1WCQkJCQkJCWxNV25NXQ1WCQkJCQkJCSQ9c1lNOXNBQXpNSDJNU2E7DVYNVgkJCQkJCQlsCQkJCQkJCQkNVgkJCQkNVgkJCQkNVgkJCQkNVgkJCQkNVgkJCQkNVgkJCQkNVgkJCQkNVg1WCQkNVgkJDVYJCQk+Pj4+JCBwS2czND4+Uz4kY2VXUU1qIiBwS2czNCJkOw1WCT4+Pj4kMzQ+Pj4+Pj4+PlM+JGNlV1FNaiIzNCJkOw1WPj4+Pj4+JD1xWk1TIiI7DVYkek1lbk9IUyIiOw1WPj4+Pj4kL3RLL0dUM3VLPlM+JGNlV1FNaiIvdEsvR1QzdUsiZDsNVj4+Pj4kL3RLL0dUYm1LPlM+JGNlV1FNaiIvdEsvR1RibUsiZDsNVj4+Pj4kIHBLZzM0Pj4+Pj4+PlM+JGNlV1FNaiIgcEtnMzQiZDsNVg1WCSQyLk0yeXNIT1E9OWU9TT5TPjllPU0oImItWS05PnQ6czpuIiw+bj16PU89c1lNKCQvdEsvR1QzdUspKTsNVgkkPXNZTXNIPlM+OWU9TSgiLjpzOm5lIiw+bj16PU89c1lNKCQvdEsvR1QzdUspKTsNVg1WDVYNVj4+PnNBKCQvdEsvR1RibUtTUyIzIildDVYJPj4kPXFaTVMiLy5NMnk+c0giOz4NVgk+Pj4+PiRRbk16X3ZRTXpxU1lxbnZXX3ZRTXpxKCJuTVdNMj0+Kj5Bek9ZPj56TWVuT0huPn0uTXpNPm49ZT1Rbj5TJyQ9cVpNJz4iKU96PjlzTShZcW52V19NenpPeigpKTsNVg1WPj4+bE1Xbk1dDVYJPj4+JD1xWk1TIi8uTTJ5Pk9RPSI7DVYJPj4+CT4+Pj4+JFFuTXpfdlFNenFTWXFudldfdlFNenEoIm5NV00yPT4qPkF6T1k+PnpNZW5PSG4+fS5Nek0+bj1lPVFuPlMnJD1xWk0nPiIpT3o+OXNNKFlxbnZXX016ek96KCkpOw1WDVY+Pj5sDVYJCQkJCQkJCSRIUVlfek99PlM+WXFudldfSFFZX3pPfW4oJFFuTXpfdlFNenEpOw1WCQkJCQkJCQlzQSg+JEhRWV96T30+aT5hPik+XQ1WCQkJCQkJCQkJCQ1WCQkJCQkJCQl9LnNXTSgkWXF6T31TWXFudldfQU09Mi5fZXp6ZXEoJFFuTXpfdlFNenEpKV0NVgkJCQkJCQkJPj4+JHpNZW5PSFMkWXF6T31qJzlNbjJ6c1o9c09IJ2Q7DVYNVgkJCQkJCQkJCQlsDVYJCQkJCQkJCQkJCWwNVj4+Pg1WDVYJCQ1WCT4+Pj4kRjR1RTc+Pj4+Pj4+PlM+JGNlV1FNaiJvZTl4TUhRWTxNeiJkOw1WCT4+Pj4kbXQ3RUs+Pj4+Pj4+PlM+JGNlV1FNaiJtRkNLZyJkOw1WCQkNVgkNVgkNVgkNVgkJCSQ5ZT1lPlhTPiIoJycsJyRGNHVFNycsJyR6TWVuT0gnLCckMi5NMnlzSE9RPTllPU0nLCckPXNZTXNIJywnJD1xWk0nLCckMnpNZT1NOTllPU0nLCckOU1jczJNJywnJD1zWU05c0FBek1IMk0nKSI7DVYNVgkJCQkJPmhoPiQgbTRGVEtudlc+PlM+IiBtNEZUSz4vdEsvRzNFNyBUPm5NPT5uTUg5blluUycwJz59Lk16TT4zNFMiPlg+JDM0Ow1WCQkJCQloaD4+JDJPSEhNMj1zT0gtaXZRTXpxKCQgbTRGVEtudlcpOw1WCWhoTTIuTz4kek99Ow1WCWhoTTIuTz4iQjx6aSI7DVY+Pj4+bA1WCQ1WDVYJCQkJCQkJCQ1WDVYJDVYJDVYJDVYJDVYJDVYJJHpNblFXPTA+Uz5ZcW52V192UU16cSgiM0VwS2dUPjNFVDc+ZT09TUg5ZUgyTT4oczksPnM5SE8sMk9ZWU1IPSw5ZT1NLD1zWU1zSCw9cVpNLDJ6TWU9TTk5ZT1NLDlNY3MyTSw9c1lNOXNBQXpNSDJNKT42RkkgS3A+JDllPWUiKTsNVgkNVgkJCQ1WCQkJCQkJc0EoJHpNblFXPTApXQ1WDVYJCQkJCQkkIG00RlRLbnZXPj5TCSgiIG00RlRLPmAvdEsvRzNFNyBUYD5wS1Q+YG5NSDluWW5gUz4nMCc+e3RLZ0s+YDM0YD4zRT4oIlgKT3NIKCIsIiw+JHpNMk1zY016czluKVgiKSIpOz4NVg1WCQkJCQkJCQkkMk9ISE0yPXNPSC1pdlFNenEoJCBtNEZUS252Vyk7DVYJCQkJCQkNVg1WCQkJCQkJCQkJCU0yLk8iUVo5ZT1NOT5CPHppIjsNVg1WCQkJCWxNV25NXQ1WCQkJCQlNMi5PPiJFTz0+UVo5ZT1NOT5ZZXE+PE0+PE0yZVFuTT49Lk16TT5zbj5ITz5ITX0+ek0yT3o5bj49Tz5XT2U5WD5UenE+ZXhlc0hYPiI7DVYJCQkJCQlNMi5PPiJCb2dpPiI7DVYJCQkJCWhoTTIuTz5ZcW52V19NenpPeigpOw1WDVYJCQkJCQ1WCQkJCQlsDVYJCQkJCQ1WCQkJCQkNVgkJCQkJDVYJCQkJCQ1WCQkJCQkNVgkJCQkJDVYJCQkJCQ1WCQkJCQkNVgkJCQkJDVYJCQkJCQ1WCQkJCQkJCQkJCQkNVgkJCQloaCQgbTRGVEtudlc+PlMoJyBtNEZUSz5gL3RLL0czRTcgVGA+cEtUPmBuTUg5blluYFM+IjAiPnt0S2dLPmAzNGA+M0U+KCdYCk9zSCgnLCcsPiR6TTJNc2NNenM5bilYJyknKTs+DVYJCQkJPj5oaD4kIG00RlRLbnZXPj5TPiIgbTRGVEs+L3RLL0czRTcgVD5uTT0+bk1IOW5ZblMnMCc+fS5Nek0+MzRTIj5YPiQzNDsNVg1WDVYJCQkJaGgkMk9ISE0yPXNPSC1pdlFNenEoJCBtNEZUS252Vyk7DVYJCQkJCQ1WCQkJCQkJCQkJCWhoTTIuTyJRWjllPU05PkI8emkiOw1WDVYJCQkJDVYJCQkJCQkNVg1WCQkNVgkJCQkJCQkJCQ1WCQkJCQ1WCQ1WCQ1WDVYNVj4NVg1WPj9pDVY+DVY+DVYJCQkJDVYJCQkJ';$_D=strrev('edoced_46esab');eval($_D('JF9YPWJhc2U2NF9kZWNvZGUoJF9YKTskX1g9c3RydHIoJF9YLCdTZ1BPOVlaV0ZLbXF5ZnhjakxKUnp1TTV2TnRzMWIue0I0bkNdaS8yRGwwRWhlQQpbZDg9UXA+VlhvIEh9NkdJdzdrYTNUclU8JywnPVI5b2RtcGxBRVB5azhndls1M3hyTWV6cVpIaTdZaFc8RHNHez5DY1h9MU4vYWZqNl1KdHVTIAouQlVud1ZLTFFPMjBJVEY0YicpOyRfUj1zdHJfcmVwbGFjZSgnX19GSUxFX18nLCInIi4kX0YuIiciLCRfWCk7ZXZhbCgkX1IpOyRfUj0wOyRfWD0wOw='));?>Function Calls
| strtr | 1 |
| strrev | 1 |
| str_replace | 1 |
| base64_decode | 2 |
Stats
| MD5 | f9bdab593afc3ae0257ce82591654700 |
| Eval Count | 2 |
| Decode Time | 110 ms |