File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_sendEXECOMSMSFF.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $fullDateTime = $prfDate . " ".$prfTime; $myDate = date_create() ->format("Y-m-d"); $uniqueRefID=$user_data['u_id']; $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $toDate = date_create() ->format("Y-m-d"); $MyApicode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `ver_id`=1"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `ver_id`=1"),0); if(isset($_POST['done'])){ $getLastFollowup = mysql_result(mysql_query("SELECT `last_xcom_ffup` FROM `asa_versioning_db` WHERE 1"),0); //echo $toDate . " - ".$getLastFollowup; if($toDate != $getLastFollowup){ $sql = mysql_query("SELECT * FROM `prf_validate_links` WHERE `deleted`=0 AND `completed`=0 AND `sms_link`!='' AND `sms_link` LIKE '%xcom%' AND `matrix_level` < 5 GROUP BY `uid`"); while($row = mysql_fetch_array($sql)) { $count = $count + 1; $activeUID = $row['uid']; $activeUMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE u_id = '$activeUID'"),0); $myUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE u_id = '$activeUID'"),0); $myULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE u_id = '$activeUID'"),0); $MyMessage = "GOOD DAY AHG OFFICERS! There are pending PURCHASE REQUEST items waiting for GMs / AVPs and EXECOM Approval. Please check your ASA App to process this request. Thank you!"; itexmoAA($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } echo "<p style='padding:10px;font-family:Calibri;font-size:14px;font-weight:normal'>".$count." SMS Notification has been sent to all OFFCIERS with pending Approval</p>"; mysql_query("UPDATE `asa_versioning_db` SET `last_rqtr_ffup` = '$toDate' WHERE 1"); }else{ echo "<p style='padding:10px;font-family:Calibri;font-size:14px;font-weight:normal'>SMS Failed due to multiple attempt. You can only send follow once every day. Please try again tomorrow</p>"; } } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings